SalesTable_BR.md

title	description	author	ms.reviewer	ms.topic	ms.date	ms.author
SalesTable_BR in WorksheetHeader - Common Data Model | Microsoft Docs	undefined	llawwaii	deonhe	reference	8/7/2020	weiluo

Sales order header information for Brazil in WorksheetHeader(SalesTable_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	SalesTable_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 Sales order header 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/SalesTable_BR
CFPSId_BR		WorksheetHeader/SalesTable_BR
CustFinalUser_BR		WorksheetHeader/SalesTable_BR
FineCode_BR		WorksheetHeader/SalesTable_BR
FiscalDocumentType_BR		WorksheetHeader/SalesTable_BR
InterestCode_BR		WorksheetHeader/SalesTable_BR
InvoiceRefRecID_BR		WorksheetHeader/SalesTable_BR
SalesPurchOperationType_BR		WorksheetHeader/SalesTable_BR
SalesTable		WorksheetHeader/SalesTable_BR
ServiceCodeOnDlvAddress_BR		WorksheetHeader/SalesTable_BR
TaxServiceCode_BR		WorksheetHeader/SalesTable_BR
PresenceType		WorksheetHeader/SalesTable_BR
DataAreaId		WorksheetHeader/SalesTable_BR
Relationship_CFPSTable_BRRelationshipId		WorksheetHeader/SalesTable_BR
Relationship_CustFineSetup_BRRelationshipId		WorksheetHeader/SalesTable_BR
Relationship_CustInterestSetup_BRRelationshipId		WorksheetHeader/SalesTable_BR
Relationship_FiscalDocumentType_BRRelationshipId		WorksheetHeader/SalesTable_BR
Relationship_InvoiceRefRecID_BRRelationshipId		WorksheetHeader/SalesTable_BR
Relationship_SalesPurchOperationType_BRRelationshipId		WorksheetHeader/SalesTable_BR
Relationship_SalesTableRelationshipId		WorksheetHeader/SalesTable_BR
Relationship_CompanyRelationshipId		WorksheetHeader/SalesTable_BR

RecId

First included in: WorksheetHeader/SalesTable_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	SalesTable_BR/(resolvedAttributes)/RecId	attribute

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

CFPSId_BR

First included in: WorksheetHeader/SalesTable_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

CustFinalUser_BR

First included in: WorksheetHeader/SalesTable_BR (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the CustFinalUser_BR attribute are listed below.

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

is.dataFormat.integer

FineCode_BR

First included in: WorksheetHeader/SalesTable_BR (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the FineCode_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

FiscalDocumentType_BR

First included in: WorksheetHeader/SalesTable_BR (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

List of traits for the FiscalDocumentType_BR attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

InterestCode_BR

First included in: WorksheetHeader/SalesTable_BR (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the InterestCode_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/SalesTable_BR (this entity)

Properties

Name	Value
displayName	Invoice reference
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

List of traits for the InvoiceRefRecID_BR attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
is.readOnly
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 Invoice reference	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

SalesPurchOperationType_BR

First included in: WorksheetHeader/SalesTable_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

SalesTable

First included in: WorksheetHeader/SalesTable_BR (this entity)

Properties

Name	Value
displayName	Sales order
dataFormat	int64
isNullable	true

Traits

List of traits for the SalesTable attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
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 Sales order	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

ServiceCodeOnDlvAddress_BR

First included in: WorksheetHeader/SalesTable_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

TaxServiceCode_BR

First included in: WorksheetHeader/SalesTable_BR (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the TaxServiceCode_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/SalesTable_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/SalesTable_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_CFPSTable_BRRelationshipId

First included in: WorksheetHeader/SalesTable_BR (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CFPSTable_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/APARShared/Group/CFPSTable_BR.cdm.json/CFPSTable_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_CustFineSetup_BRRelationshipId

First included in: WorksheetHeader/SalesTable_BR (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustFineSetup_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/CustFineSetup_BR.cdm.json/CustFineSetup_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_CustInterestSetup_BRRelationshipId

First included in: WorksheetHeader/SalesTable_BR (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustInterestSetup_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/CustInterestSetup_BR.cdm.json/CustInterestSetup_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_FiscalDocumentType_BRRelationshipId

First included in: WorksheetHeader/SalesTable_BR (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_FiscalDocumentType_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/FiscalBooksBrazil/Parameter/FiscalDocumentType_BR.cdm.json/FiscalDocumentType_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/SalesTable_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/AccountsReceivable/Transaction/CustInvoiceJour.cdm.json/CustInvoiceJour 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/SalesTable_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_SalesTableRelationshipId

First included in: WorksheetHeader/SalesTable_BR (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SalesTableRelationshipId 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/SalesAndMarketing/WorksheetHeader/SalesTable.cdm.json/SalesTable 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/SalesTable_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