Purchase orders information for Brazil in WorksheetHeader(PurchTable_BR)

Latest version of the JSON entity definition is available on GitHub.

Traits

Traits for this entity are listed below.

is.identifiedBy
names a specifc identity attribute to use with an entity

Parameter	Value	Data type	Explanation
attribute	PurchTable_BR/(resolvedAttributes)/RecId	attribute

is.CDM.entityVersion

Parameter	Value	Data type	Explanation
versionNumber	"1.1"	string	semantic version number of the entity

is.application.releaseVersion

Parameter	Value	Data type	Explanation
releaseVersion	"10.0.13.0"	string	semantic version number of the application introducing this entity

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Purchase orders information for Brazil	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetHeader/PurchTable_BR
CFPSId_BR		WorksheetHeader/PurchTable_BR
InvoiceRefRecId_BR		WorksheetHeader/PurchTable_BR
PurchTable		WorksheetHeader/PurchTable_BR
SalesPurchOperationType_BR		WorksheetHeader/PurchTable_BR
ServiceCodeOnDlvAddress_BR		WorksheetHeader/PurchTable_BR
TaxDirectImport_BR		WorksheetHeader/PurchTable_BR
VendFinalUser_BR		WorksheetHeader/PurchTable_BR
VendFineSetup_BR		WorksheetHeader/PurchTable_BR
VendInterestSetup_BR		WorksheetHeader/PurchTable_BR
PresenceType		WorksheetHeader/PurchTable_BR
DataAreaId		WorksheetHeader/PurchTable_BR
Relationship_FineCodeRelationshipId		WorksheetHeader/PurchTable_BR
Relationship_InterestCodeRelationshipId		WorksheetHeader/PurchTable_BR
Relationship_InvoiceRefRecId_BRRelationshipId		WorksheetHeader/PurchTable_BR
Relationship_PurchTableRelationshipId		WorksheetHeader/PurchTable_BR
Relationship_SalesPurchOperationType_BRRelationshipId		WorksheetHeader/PurchTable_BR
Relationship_CompanyRelationshipId		WorksheetHeader/PurchTable_BR

RecId

First included in: WorksheetHeader/PurchTable_BR (this entity)

Properties

Name	Value
isPrimaryKey	true
dataFormat	int64
isReadOnly	true

Traits

List of traits for the RecId attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
is.identifiedBy
names a specifc identity attribute to use with an entity

Parameter	Value	Data type	Explanation
attribute	PurchTable_BR/(resolvedAttributes)/RecId	attribute

is.readOnly
is.dataFormat.integer
is.dataFormat.big

CFPSId_BR

First included in: WorksheetHeader/PurchTable_BR (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the CFPSId_BR attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.character
is.dataFormat.array

InvoiceRefRecId_BR

First included in: WorksheetHeader/PurchTable_BR (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

List of traits for the InvoiceRefRecId_BR attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer
is.dataFormat.big

PurchTable

First included in: WorksheetHeader/PurchTable_BR (this entity)

Properties

Name	Value
dataFormat	int64

Traits

List of traits for the PurchTable attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
is.dataFormat.integer
is.dataFormat.big

SalesPurchOperationType_BR

First included in: WorksheetHeader/PurchTable_BR (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

List of traits for the SalesPurchOperationType_BR attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer
is.dataFormat.big

ServiceCodeOnDlvAddress_BR

First included in: WorksheetHeader/PurchTable_BR (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ServiceCodeOnDlvAddress_BR attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

TaxDirectImport_BR

First included in: WorksheetHeader/PurchTable_BR (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the TaxDirectImport_BR attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

VendFinalUser_BR

First included in: WorksheetHeader/PurchTable_BR (this entity)

Properties

Name	Value
displayName	Use and consumption
dataFormat	int32
isNullable	true

Traits

List of traits for the VendFinalUser_BR attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Use and consumption	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

VendFineSetup_BR

First included in: WorksheetHeader/PurchTable_BR (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the VendFineSetup_BR attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.character
is.dataFormat.array

VendInterestSetup_BR

First included in: WorksheetHeader/PurchTable_BR (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the VendInterestSetup_BR attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.character
is.dataFormat.array

PresenceType

First included in: WorksheetHeader/PurchTable_BR (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the PresenceType attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

DataAreaId

First included in: WorksheetHeader/PurchTable_BR (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true

Traits

List of traits for the DataAreaId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.readOnly
is.dataFormat.character
is.dataFormat.array

Relationship_FineCodeRelationshipId

First included in: WorksheetHeader/PurchTable_BR (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_FineCodeRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/AccountsPayable/Main/VendFineSetup_BR.cdm.json/VendFineSetup_BR RecId	entity	a reference to the constant entity holding the list of entity references

is.dataFormat.guid
is.dataFormat.character
is.dataFormat.array

Relationship_InterestCodeRelationshipId

First included in: WorksheetHeader/PurchTable_BR (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InterestCodeRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/AccountsPayable/Main/VendInterestSetup_BR.cdm.json/VendInterestSetup_BR RecId	entity	a reference to the constant entity holding the list of entity references

is.dataFormat.guid
is.dataFormat.character
is.dataFormat.array

Relationship_InvoiceRefRecId_BRRelationshipId

First included in: WorksheetHeader/PurchTable_BR (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InvoiceRefRecId_BRRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/AccountsPayable/Transaction/VendInvoiceJour.cdm.json/VendInvoiceJour RecId	entity	a reference to the constant entity holding the list of entity references

is.dataFormat.guid
is.dataFormat.character
is.dataFormat.array

Relationship_PurchTableRelationshipId

First included in: WorksheetHeader/PurchTable_BR (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PurchTableRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/SupplyChain/ProcurementAndSourcing/WorksheetHeader/PurchTable.cdm.json/PurchTable RecId	entity	a reference to the constant entity holding the list of entity references

is.dataFormat.guid
is.dataFormat.character
is.dataFormat.array

Relationship_SalesPurchOperationType_BRRelationshipId

First included in: WorksheetHeader/PurchTable_BR (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SalesPurchOperationType_BRRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/AccountsReceivable/Main/SalesPurchOperationType_BR.cdm.json/SalesPurchOperationType_BR RecId	entity	a reference to the constant entity holding the list of entity references

is.dataFormat.guid
is.dataFormat.character
is.dataFormat.array

Relationship_CompanyRelationshipId

First included in: WorksheetHeader/PurchTable_BR (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CompanyRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/Ledger/Main/CompanyInfo.cdm.json/CompanyInfo RecId	entity	a reference to the constant entity holding the list of entity references

is.dataFormat.guid
is.dataFormat.character
is.dataFormat.array