Sales orders in WorksheetHeader(SalesTable)

Article
02/22/2022

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/(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 orders

entity

a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetHeader/SalesTable
LineDisc		WorksheetHeader/SalesTable
SalesId		WorksheetHeader/SalesTable
TDSGroup_IN		WorksheetHeader/SalesTable
AddressRefRecId		WorksheetHeader/SalesTable
AddressRefTableId		WorksheetHeader/SalesTable
AutoSummaryModuleType		WorksheetHeader/SalesTable
BankAccount_LV		WorksheetHeader/SalesTable
BankCentralBankPurposeCode		WorksheetHeader/SalesTable
BankCentralBankPurposeText		WorksheetHeader/SalesTable
BankDocumentType		WorksheetHeader/SalesTable
CashDisc		WorksheetHeader/SalesTable
CashDiscBaseDate		WorksheetHeader/SalesTable
CashDiscBaseDays		WorksheetHeader/SalesTable
CashDiscPercent		WorksheetHeader/SalesTable
CommissionGroup		WorksheetHeader/SalesTable
ConsTarget_JP		WorksheetHeader/SalesTable
ContactPersonId		WorksheetHeader/SalesTable
CountyOrigDest		WorksheetHeader/SalesTable
CovStatus		WorksheetHeader/SalesTable
CreditCardApprovalAmount		WorksheetHeader/SalesTable
CreditCardAuthorization		WorksheetHeader/SalesTable
CreditCardAuthorizationError		WorksheetHeader/SalesTable
CreditCardCustRefId		WorksheetHeader/SalesTable
CreditNoteReasonCode		WorksheetHeader/SalesTable
CurBankAccount_LV		WorksheetHeader/SalesTable
CurrencyCode		WorksheetHeader/SalesTable
CustAccount		WorksheetHeader/SalesTable
CustBankAccount_LV		WorksheetHeader/SalesTable
CustGroup		WorksheetHeader/SalesTable
CustInvoiceId		WorksheetHeader/SalesTable
CustomerRef		WorksheetHeader/SalesTable
CustomsExportOrder_IN		WorksheetHeader/SalesTable
CustomsShippingBill_IN		WorksheetHeader/SalesTable
Deadline		WorksheetHeader/SalesTable
DefaultDimension		WorksheetHeader/SalesTable
DeliveryDate		WorksheetHeader/SalesTable
DeliveryDateControlType		WorksheetHeader/SalesTable
DeliveryName		WorksheetHeader/SalesTable
DeliveryPostalAddress		WorksheetHeader/SalesTable
DirectDebitMandate		WorksheetHeader/SalesTable
DiscPercent		WorksheetHeader/SalesTable
DlvMode		WorksheetHeader/SalesTable
DlvReason		WorksheetHeader/SalesTable
DlvTerm		WorksheetHeader/SalesTable
DocumentStatus		WorksheetHeader/SalesTable
EInvoiceAccountCode		WorksheetHeader/SalesTable
EInvoiceLineSpec		WorksheetHeader/SalesTable
Email		WorksheetHeader/SalesTable
EndDisc		WorksheetHeader/SalesTable
EnterpriseNumber		WorksheetHeader/SalesTable
Estimate		WorksheetHeader/SalesTable
ExportReason		WorksheetHeader/SalesTable
FiscalDocType_PL		WorksheetHeader/SalesTable
FixedDueDate		WorksheetHeader/SalesTable
FixedExchRate		WorksheetHeader/SalesTable
FreightSlipType		WorksheetHeader/SalesTable
FreightZone		WorksheetHeader/SalesTable
GiroType		WorksheetHeader/SalesTable
InclTax		WorksheetHeader/SalesTable
InterCompanyAllowIndirectCreation		WorksheetHeader/SalesTable
InterCompanyAllowIndirectCreationOrig		WorksheetHeader/SalesTable
InterCompanyAutoCreateOrders		WorksheetHeader/SalesTable
InterCompanyCompanyId		WorksheetHeader/SalesTable
InterCompanyDirectDelivery		WorksheetHeader/SalesTable
InterCompanyDirectDeliveryOrig		WorksheetHeader/SalesTable
InterCompanyOrder		WorksheetHeader/SalesTable
InterCompanyOrigin		WorksheetHeader/SalesTable
InterCompanyOriginalCustAccount		WorksheetHeader/SalesTable
InterCompanyOriginalSalesId		WorksheetHeader/SalesTable
InterCompanyPurchId		WorksheetHeader/SalesTable
IntrastatAddValue_LV		WorksheetHeader/SalesTable
IntrastatFulfillmentDate_HU		WorksheetHeader/SalesTable
InventLocationId		WorksheetHeader/SalesTable
InventSiteId		WorksheetHeader/SalesTable
InvoiceAccount		WorksheetHeader/SalesTable
InvoiceAutoNumbering_LT		WorksheetHeader/SalesTable
LanguageId		WorksheetHeader/SalesTable
Listcode		WorksheetHeader/SalesTable
ManualEntryChangepolicy		WorksheetHeader/SalesTable
MarkupGroup		WorksheetHeader/SalesTable
MatchingAgreement		WorksheetHeader/SalesTable
MCROrderStopped		WorksheetHeader/SalesTable
MultiLineDisc		WorksheetHeader/SalesTable
NatureOfAssessee_IN		WorksheetHeader/SalesTable
NumberSequenceGroup		WorksheetHeader/SalesTable
OneTimeCustomer		WorksheetHeader/SalesTable
PackedExtensions		WorksheetHeader/SalesTable
PackingSlipAutoNumbering_LT		WorksheetHeader/SalesTable
Payment		WorksheetHeader/SalesTable
PaymentSched		WorksheetHeader/SalesTable
PaymMode		WorksheetHeader/SalesTable
PaymSpec		WorksheetHeader/SalesTable
PdsBatchAttribAutoRes		WorksheetHeader/SalesTable
PdsCustRebateGroupId		WorksheetHeader/SalesTable
PdsRebateProgramTMAGroup		WorksheetHeader/SalesTable
Port		WorksheetHeader/SalesTable
PostingProfile		WorksheetHeader/SalesTable
PriceGroupId		WorksheetHeader/SalesTable
ProjId		WorksheetHeader/SalesTable
PurchId		WorksheetHeader/SalesTable
PurchOrderFormNum		WorksheetHeader/SalesTable
QuotationId		WorksheetHeader/SalesTable
ReceiptDateConfirmed		WorksheetHeader/SalesTable
ReceiptDateRequested		WorksheetHeader/SalesTable
ReleaseStatus		WorksheetHeader/SalesTable
Reservation		WorksheetHeader/SalesTable
RetailChannelTable		WorksheetHeader/SalesTable
ReturnDeadline		WorksheetHeader/SalesTable
ReturnItemNum		WorksheetHeader/SalesTable
ReturnReasonCodeId		WorksheetHeader/SalesTable
ReturnReplacementCreated		WorksheetHeader/SalesTable
ReturnReplacementId		WorksheetHeader/SalesTable
ReturnStatus		WorksheetHeader/SalesTable
SalesGroup		WorksheetHeader/SalesTable
SalesName		WorksheetHeader/SalesTable
SalesOriginId		WorksheetHeader/SalesTable
SalesPoolId		WorksheetHeader/SalesTable
SalesStatus		WorksheetHeader/SalesTable
SalesType		WorksheetHeader/SalesTable
SalesUnitId		WorksheetHeader/SalesTable
SettleVoucher		WorksheetHeader/SalesTable
ShipCarrierAccount		WorksheetHeader/SalesTable
ShipCarrierAccountCode		WorksheetHeader/SalesTable
ShipCarrierBlindShipment		WorksheetHeader/SalesTable
ShipCarrierDeliveryContact		WorksheetHeader/SalesTable
ShipCarrierDlvType		WorksheetHeader/SalesTable
ShipCarrierExpeditedShipment		WorksheetHeader/SalesTable
ShipCarrierFuelSurcharge		WorksheetHeader/SalesTable
ShipCarrierId		WorksheetHeader/SalesTable
ShipCarrierName		WorksheetHeader/SalesTable
ShipCarrierPostalAddress		WorksheetHeader/SalesTable
ShipCarrierResidential		WorksheetHeader/SalesTable
ShippingDateConfirmed		WorksheetHeader/SalesTable
ShippingDateRequested		WorksheetHeader/SalesTable
SkipUpdate		WorksheetHeader/SalesTable
smmCampaignId		WorksheetHeader/SalesTable
smmSalesAmountTotal		WorksheetHeader/SalesTable
SourceDocumentHeader		WorksheetHeader/SalesTable
StatProcId		WorksheetHeader/SalesTable
SystemEntryChangePolicy		WorksheetHeader/SalesTable
SystemEntrySource		WorksheetHeader/SalesTable
TaxGroup		WorksheetHeader/SalesTable
TaxPeriodPaymentCode_PL		WorksheetHeader/SalesTable
TCSGroup_IN		WorksheetHeader/SalesTable
Touched		WorksheetHeader/SalesTable
TransactionCode		WorksheetHeader/SalesTable
Transport		WorksheetHeader/SalesTable
TransportationDocument		WorksheetHeader/SalesTable
UnitedVATInvoice_LT		WorksheetHeader/SalesTable
URL		WorksheetHeader/SalesTable
VATNum		WorksheetHeader/SalesTable
WorkerSalesResponsible		WorksheetHeader/SalesTable
WorkerSalesTaker		WorksheetHeader/SalesTable
SkipCreateMarkup		WorksheetHeader/SalesTable
SkipLineUpdate		WorksheetHeader/SalesTable
InvoiceRegister_LT		WorksheetHeader/SalesTable
PackingSlipRegister_LT		WorksheetHeader/SalesTable
EInvoiceCFDIConfirmNumber_MX		WorksheetHeader/SalesTable
SATPaymMethod_MX		WorksheetHeader/SalesTable
SATPurpose_MX		WorksheetHeader/SalesTable
CertificateNumber_MX		WorksheetHeader/SalesTable
FiscalAddress_MX		WorksheetHeader/SalesTable
ForeignTrade_MX		WorksheetHeader/SalesTable
NumRegIdTrib_MX		WorksheetHeader/SalesTable
SATIncotermCode_MX		WorksheetHeader/SalesTable
SourceCertificate_MX		WorksheetHeader/SalesTable
SATShippingReason_MX		WorksheetHeader/SalesTable
AccountingDistributionTemplate		WorksheetHeader/SalesTable
FundingSource		WorksheetHeader/SalesTable
ReportingCurrencyFixedExchRate		WorksheetHeader/SalesTable
ASOHOrderClass		WorksheetHeader/SalesTable
IntentLetterId_IT		WorksheetHeader/SalesTable
CommissionType_IT		WorksheetHeader/SalesTable
CredManExcludeSalesOrder		WorksheetHeader/SalesTable
CredManReleasedFromCreditControl		WorksheetHeader/SalesTable
CredManRejected		WorksheetHeader/SalesTable
CredManId		WorksheetHeader/SalesTable
CredManInCreditControl		WorksheetHeader/SalesTable
DOMIterations		WorksheetHeader/SalesTable
DOMProcessed		WorksheetHeader/SalesTable
DOMProcessedDateTime		WorksheetHeader/SalesTable
DOMIgnore		WorksheetHeader/SalesTable
DOMExceptionType		WorksheetHeader/SalesTable
RevRecFollowOriginalPricingMethod		WorksheetHeader/SalesTable
RevRecContractEndDate		WorksheetHeader/SalesTable
RevRecContractStartDate		WorksheetHeader/SalesTable
RevRecLatestReverseJournal		WorksheetHeader/SalesTable
RevRecMultipleSOReallocation		WorksheetHeader/SalesTable
RevRecReallocationId		WorksheetHeader/SalesTable
DataAreaId		WorksheetHeader/SalesTable
Relationship_AgreementRelationshipId		WorksheetHeader/SalesTable
Relationship_BankAccount_LVRelationshipId		WorksheetHeader/SalesTable
Relationship_BankCentralBankPurposeRelationshipId		WorksheetHeader/SalesTable
Relationship_CashDiscRelationshipId		WorksheetHeader/SalesTable
Relationship_CommissionCustomerGroupRelationshipId		WorksheetHeader/SalesTable
Relationship_CommissionSalesGroupRelationshipId		WorksheetHeader/SalesTable
Relationship_ContactPersonRelationshipId		WorksheetHeader/SalesTable
Relationship_CountyOrigDestRelationshipId		WorksheetHeader/SalesTable
Relationship_CreditCardRelationshipId		WorksheetHeader/SalesTable
Relationship_CurBankAccount_LVRelationshipId		WorksheetHeader/SalesTable
Relationship_CurrencyRelationshipId		WorksheetHeader/SalesTable
Relationship_CustBankAccount_LVRelationshipId		WorksheetHeader/SalesTable
Relationship_CustDirectDebitMandateRelationshipId		WorksheetHeader/SalesTable
Relationship_CustGroupRelationshipId		WorksheetHeader/SalesTable
Relationship_CustInvoiceJourRelationshipId		WorksheetHeader/SalesTable
Relationship_CustLedgerRelationshipId		WorksheetHeader/SalesTable
Relationship_CustLineDiscountGroupRelationshipId		WorksheetHeader/SalesTable
Relationship_CustMarkupGroupRelationshipId		WorksheetHeader/SalesTable
Relationship_CustMultiLineDiscountGroupRelationshipId		WorksheetHeader/SalesTable
Relationship_CustPaymModeSpecRelationshipId		WorksheetHeader/SalesTable
Relationship_CustPaymModeTableRelationshipId		WorksheetHeader/SalesTable
Relationship_CustPriceGroupRelationshipId		WorksheetHeader/SalesTable
Relationship_CustTotalDiscountGroupRelationshipId		WorksheetHeader/SalesTable
Relationship_DefaultDimensionRelationshipId		WorksheetHeader/SalesTable
Relationship_DeliveryPostalAddress_FKRelationshipId		WorksheetHeader/SalesTable
Relationship_DlvModeRelationshipId		WorksheetHeader/SalesTable
Relationship_DlvReasonRelationshipId		WorksheetHeader/SalesTable
Relationship_DlvTermRelationshipId		WorksheetHeader/SalesTable
Relationship_IntrastatPortRelationshipId		WorksheetHeader/SalesTable
Relationship_IntrastatStatProcRelationshipId		WorksheetHeader/SalesTable
Relationship_IntrastatTransactionCodeRelationshipId		WorksheetHeader/SalesTable
Relationship_IntrastatTransportModeRelationshipId		WorksheetHeader/SalesTable
Relationship_InventLocationRelationshipId		WorksheetHeader/SalesTable
Relationship_InventSiteRelationshipId		WorksheetHeader/SalesTable
Relationship_InvoiceCustomerRelationshipId		WorksheetHeader/SalesTable
Relationship_LanguageTableRelationshipId		WorksheetHeader/SalesTable
Relationship_MarkupGroupRelationshipId		WorksheetHeader/SalesTable
Relationship_MCRHoldCodeTransRelationshipId		WorksheetHeader/SalesTable
Relationship_NumberSequenceGroupRelationshipId		WorksheetHeader/SalesTable
Relationship_OrderCustomerRelationshipId		WorksheetHeader/SalesTable
Relationship_PaymSchedRelationshipId		WorksheetHeader/SalesTable
Relationship_PaymTermRelationshipId		WorksheetHeader/SalesTable
Relationship_PdsCustRebateGroupRelationshipId		WorksheetHeader/SalesTable
Relationship_PdsRebateProgramTMATableRelationshipId		WorksheetHeader/SalesTable
Relationship_PlTaxDueTableRelationshipId		WorksheetHeader/SalesTable
Relationship_PriceDiscChangePolicyRecId1RelationshipId		WorksheetHeader/SalesTable
Relationship_PriceDiscChangePolicyRecId2RelationshipId		WorksheetHeader/SalesTable
Relationship_ProjTableRelationshipId		WorksheetHeader/SalesTable
Relationship_PurchTableRelationshipId		WorksheetHeader/SalesTable
Relationship_PurchTableInterCompanyRelationshipId		WorksheetHeader/SalesTable
Relationship_ReasonTableRefRelationshipId		WorksheetHeader/SalesTable
Relationship_ReturnReasonCodeRelationshipId		WorksheetHeader/SalesTable
Relationship_SalesOriginRelationshipId		WorksheetHeader/SalesTable
Relationship_SalesPoolRelationshipId		WorksheetHeader/SalesTable
Relationship_ShipCarrierPostalAddress_FKRelationshipId		WorksheetHeader/SalesTable
Relationship_smmCampaignTableRelationshipId		WorksheetHeader/SalesTable
Relationship_smmSalesUnitRelationshipId		WorksheetHeader/SalesTable
Relationship_SourceDocumentHeaderRelationshipId		WorksheetHeader/SalesTable
Relationship_TaxGroupHeadingRelationshipId		WorksheetHeader/SalesTable
Relationship_TaxServiceTariffRelationshipId		WorksheetHeader/SalesTable
Relationship_TaxWithholdGroupHeadingTCS_INRelationshipId		WorksheetHeader/SalesTable
Relationship_TaxWithholdGroupHeadingTDS_INRelationshipId		WorksheetHeader/SalesTable
Relationship_TransportationDocumentRelationshipId		WorksheetHeader/SalesTable
Relationship_SATPaymMethod_MXRelationshipId		WorksheetHeader/SalesTable
Relationship_SATPurpose_MXRelationshipId		WorksheetHeader/SalesTable
Relationship_SATIncotermCode_MXRelationshipId		WorksheetHeader/SalesTable
Relationship_LogisticsAddressCountryRegionRelationshipId		WorksheetHeader/SalesTable
Relationship_SATShippingReason_MXRelationshipId		WorksheetHeader/SalesTable
Relationship_AccountingDistributionTemplateRelationshipId		WorksheetHeader/SalesTable
Relationship_ProjFundingSourceRelationshipId		WorksheetHeader/SalesTable
Relationship_CustIntentLetter_ITRelationshipId		WorksheetHeader/SalesTable
Relationship_CredManTableRelationshipId		WorksheetHeader/SalesTable
Relationship_RevRecLatestReverseJournalRelationshipId		WorksheetHeader/SalesTable
Relationship_CompanyRelationshipId		WorksheetHeader/SalesTable

RecId

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

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

LineDisc

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

SalesId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the SalesId attribute are listed below.

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

TDSGroup_IN

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
displayName	TDS group
dataFormat	string
isNullable	true

Traits

List of traits for the TDSGroup_IN attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
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	TDS group

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

AddressRefRecId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

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

AddressRefTableId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the AddressRefTableId attribute are listed below.

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

is.dataFormat.integer

AutoSummaryModuleType

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
displayName	Summary update parameters
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the AutoSummaryModuleType attribute are listed below.

is.dataFormat.integer
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	Summary update parameters

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

BankAccount_LV

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
displayName	Primary company bank account
dataFormat	string
isNullable	true

Traits

List of traits for the BankAccount_LV attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
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	Primary company bank account

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

BankCentralBankPurposeCode

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

BankCentralBankPurposeText

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

BankDocumentType

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
displayName	Bank document type
dataFormat	int32
isNullable	true

Traits

List of traits for the BankDocumentType 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	Bank document type

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

CashDisc

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

CashDiscBaseDate

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the CashDiscBaseDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

CashDiscBaseDays

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the CashDiscBaseDays attribute are listed below.

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

is.dataFormat.integer

CashDiscPercent

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the CashDiscPercent attribute are listed below.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

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

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

CommissionGroup

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ConsTarget_JP

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ConsTarget_JP attribute are listed below.

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

is.dataFormat.integer

ContactPersonId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

CountyOrigDest

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

CovStatus

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the CovStatus attribute are listed below.

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

is.dataFormat.integer

CreditCardApprovalAmount

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
displayName	Approval amount
dataFormat	decimal
isNullable	true

Traits

List of traits for the CreditCardApprovalAmount attribute are listed below.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

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	Approval amount

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

CreditCardAuthorization

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

CreditCardAuthorizationError

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
displayName	Capture error
dataFormat	int32
isNullable	true

Traits

List of traits for the CreditCardAuthorizationError 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	Capture error

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

CreditCardCustRefId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
displayName	Reference ID
dataFormat	int64
isNullable	true

Traits

List of traits for the CreditCardCustRefId 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	Reference ID

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

CreditNoteReasonCode

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

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

CurBankAccount_LV

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
displayName	Bank code for additional currency
dataFormat	string
isNullable	true

Traits

List of traits for the CurBankAccount_LV attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
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	Bank code for additional currency

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

CurrencyCode

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the CurrencyCode attribute are listed below.

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

CustAccount

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the CustAccount attribute are listed below.

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

CustBankAccount_LV

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
displayName	Customer bank account
dataFormat	string
isNullable	true

Traits

List of traits for the CustBankAccount_LV attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
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	Customer bank account

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

CustGroup

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the CustGroup attribute are listed below.

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

CustInvoiceId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

CustomerRef

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

CustomsExportOrder_IN

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
displayName	Export order
dataFormat	int32
isNullable	true

Traits

List of traits for the CustomsExportOrder_IN 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	Export order

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

CustomsShippingBill_IN

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
displayName	Shipping bill
dataFormat	int32
isNullable	true

Traits

List of traits for the CustomsShippingBill_IN 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	Shipping bill

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

Deadline

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the Deadline attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

DefaultDimension

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

DeliveryDate

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the DeliveryDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

DeliveryDateControlType

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the DeliveryDateControlType attribute are listed below.

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

is.dataFormat.integer

DeliveryName

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DeliveryPostalAddress

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

DirectDebitMandate

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

DiscPercent

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the DiscPercent attribute are listed below.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

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

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

DlvMode

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DlvReason

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DlvTerm

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DocumentStatus

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the DocumentStatus attribute are listed below.

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

is.dataFormat.integer

EInvoiceAccountCode

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

EInvoiceLineSpec

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the EInvoiceLineSpec attribute are listed below.

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

is.dataFormat.integer

Email

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

EndDisc

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

EnterpriseNumber

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

Estimate

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the Estimate attribute are listed below.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

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

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

ExportReason

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

FiscalDocType_PL

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the FiscalDocType_PL attribute are listed below.

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

is.dataFormat.integer

FixedDueDate

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the FixedDueDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

FixedExchRate

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the FixedExchRate attribute are listed below.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

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

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

FreightSlipType

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the FreightSlipType attribute are listed below.

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

is.dataFormat.integer

FreightZone

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

GiroType

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the GiroType attribute are listed below.

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

is.dataFormat.integer

InclTax

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the InclTax attribute are listed below.

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

is.dataFormat.integer

InterCompanyAllowIndirectCreation

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the InterCompanyAllowIndirectCreation attribute are listed below.

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

is.dataFormat.integer

InterCompanyAllowIndirectCreationOrig

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the InterCompanyAllowIndirectCreationOrig attribute are listed below.

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

is.dataFormat.integer

InterCompanyAutoCreateOrders

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the InterCompanyAutoCreateOrders attribute are listed below.

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

is.dataFormat.integer

InterCompanyCompanyId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

List of traits for the InterCompanyCompanyId attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

InterCompanyDirectDelivery

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the InterCompanyDirectDelivery attribute are listed below.

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

is.dataFormat.integer

InterCompanyDirectDeliveryOrig

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the InterCompanyDirectDeliveryOrig attribute are listed below.

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

is.dataFormat.integer

InterCompanyOrder

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the InterCompanyOrder attribute are listed below.

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

is.dataFormat.integer

InterCompanyOrigin

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the InterCompanyOrigin attribute are listed below.

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

is.dataFormat.integer

InterCompanyOriginalCustAccount

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

InterCompanyOriginalSalesId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

InterCompanyPurchId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

IntrastatAddValue_LV

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the IntrastatAddValue_LV attribute are listed below.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

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

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

IntrastatFulfillmentDate_HU

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the IntrastatFulfillmentDate_HU attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

InventLocationId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

InventSiteId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

InvoiceAccount

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the InvoiceAccount attribute are listed below.

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

InvoiceAutoNumbering_LT

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the InvoiceAutoNumbering_LT attribute are listed below.

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

is.dataFormat.integer

LanguageId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the LanguageId attribute are listed below.

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

Listcode

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the Listcode attribute are listed below.

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

is.dataFormat.integer

ManualEntryChangepolicy

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

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

MarkupGroup

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

MatchingAgreement

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

MCROrderStopped

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the MCROrderStopped attribute are listed below.

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

is.dataFormat.integer

MultiLineDisc

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

NatureOfAssessee_IN

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the NatureOfAssessee_IN attribute are listed below.

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

is.dataFormat.integer

NumberSequenceGroup

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

OneTimeCustomer

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the OneTimeCustomer attribute are listed below.

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

is.dataFormat.integer

PackedExtensions

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	binary
isNullable	true

Traits

List of traits for the PackedExtensions attribute are listed below.

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

is.dataFormat.byte
is.dataFormat.array

PackingSlipAutoNumbering_LT

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the PackingSlipAutoNumbering_LT attribute are listed below.

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

is.dataFormat.integer

Payment

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
displayName	Payment
dataFormat	string
isNullable	true

Traits

List of traits for the Payment attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
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	Payment

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

PaymentSched

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PaymMode

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PaymSpec

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PdsBatchAttribAutoRes

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the PdsBatchAttribAutoRes attribute are listed below.

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

is.dataFormat.integer

PdsCustRebateGroupId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PdsRebateProgramTMAGroup

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

Port

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PostingProfile

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PriceGroupId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ProjId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PurchId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PurchOrderFormNum

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

QuotationId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ReceiptDateConfirmed

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the ReceiptDateConfirmed attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

ReceiptDateRequested

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the ReceiptDateRequested attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

ReleaseStatus

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the ReleaseStatus attribute are listed below.

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

is.dataFormat.integer

Reservation

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the Reservation attribute are listed below.

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

is.dataFormat.integer

RetailChannelTable

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

ReturnDeadline

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the ReturnDeadline attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

ReturnItemNum

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ReturnReasonCodeId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ReturnReplacementCreated

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the ReturnReplacementCreated attribute are listed below.

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

is.dataFormat.integer

ReturnReplacementId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

List of traits for the ReturnReplacementId attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

ReturnStatus

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the ReturnStatus attribute are listed below.

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

is.dataFormat.integer

SalesGroup

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

SalesName

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
displayName	Customer name
dataFormat	string
isNullable	true

Traits

List of traits for the SalesName attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
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	Customer name

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

SalesOriginId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

SalesPoolId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

SalesStatus

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the SalesStatus attribute are listed below.

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

is.dataFormat.integer

SalesType

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the SalesType attribute are listed below.

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

is.dataFormat.integer

SalesUnitId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

SettleVoucher

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the SettleVoucher attribute are listed below.

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

is.dataFormat.integer

ShipCarrierAccount

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ShipCarrierAccountCode

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

List of traits for the ShipCarrierAccountCode attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

ShipCarrierBlindShipment

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ShipCarrierBlindShipment attribute are listed below.

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

is.dataFormat.integer

ShipCarrierDeliveryContact

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
displayName	Delivery contact
dataFormat	string
isNullable	true

Traits

List of traits for the ShipCarrierDeliveryContact attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
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	Delivery contact

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

ShipCarrierDlvType

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ShipCarrierDlvType attribute are listed below.

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

is.dataFormat.integer

ShipCarrierExpeditedShipment

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ShipCarrierExpeditedShipment attribute are listed below.

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

is.dataFormat.integer

ShipCarrierFuelSurcharge

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ShipCarrierFuelSurcharge attribute are listed below.

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

is.dataFormat.integer

ShipCarrierId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

List of traits for the ShipCarrierId attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

ShipCarrierName

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ShipCarrierPostalAddress

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

ShipCarrierResidential

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ShipCarrierResidential attribute are listed below.

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

is.dataFormat.integer

ShippingDateConfirmed

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the ShippingDateConfirmed attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

ShippingDateRequested

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	date

Traits

List of traits for the ShippingDateRequested attribute are listed below.

is.dataFormat.date
means.measurement.date
is.dataFormat.date

SkipUpdate

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the SkipUpdate attribute are listed below.

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

is.dataFormat.integer

smmCampaignId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

smmSalesAmountTotal

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the smmSalesAmountTotal attribute are listed below.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

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

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

SourceDocumentHeader

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
displayName	Source document header
dataFormat	int64
isNullable	true

Traits

List of traits for the SourceDocumentHeader 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	Source document header

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

StatProcId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

SystemEntryChangePolicy

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

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

SystemEntrySource

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the SystemEntrySource attribute are listed below.

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

is.dataFormat.integer

TaxGroup

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

TaxPeriodPaymentCode_PL

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

TCSGroup_IN

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
displayName	TCS group
dataFormat	string
isNullable	true

Traits

List of traits for the TCSGroup_IN attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
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	TCS group

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

Touched

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the Touched attribute are listed below.

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

is.dataFormat.integer

TransactionCode

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

Transport

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

TransportationDocument

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

UnitedVATInvoice_LT

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the UnitedVATInvoice_LT attribute are listed below.

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

is.dataFormat.integer

URL

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

VATNum

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

WorkerSalesResponsible

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

WorkerSalesTaker

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

SkipCreateMarkup

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the SkipCreateMarkup attribute are listed below.

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

is.dataFormat.integer

SkipLineUpdate

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the SkipLineUpdate attribute are listed below.

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

is.dataFormat.integer

InvoiceRegister_LT

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the InvoiceRegister_LT attribute are listed below.

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

is.dataFormat.integer

PackingSlipRegister_LT

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the PackingSlipRegister_LT attribute are listed below.

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

is.dataFormat.integer

EInvoiceCFDIConfirmNumber_MX

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

SATPaymMethod_MX

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

SATPurpose_MX

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

CertificateNumber_MX

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

FiscalAddress_MX

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
displayName	Fiscal address
dataFormat	string
isNullable	true

Traits

List of traits for the FiscalAddress_MX attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
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	Fiscal address

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

ForeignTrade_MX

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ForeignTrade_MX attribute are listed below.

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

is.dataFormat.integer

NumRegIdTrib_MX

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

SATIncotermCode_MX

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

SourceCertificate_MX

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the SourceCertificate_MX attribute are listed below.

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

is.dataFormat.integer

SATShippingReason_MX

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

AccountingDistributionTemplate

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

FundingSource

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

ReportingCurrencyFixedExchRate

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the ReportingCurrencyFixedExchRate attribute are listed below.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

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

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

ASOHOrderClass

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

IntentLetterId_IT

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

CommissionType_IT

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
displayName	Commission settlement
dataFormat	int32
isNullable	true

Traits

List of traits for the CommissionType_IT 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	Commission settlement

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

CredManExcludeSalesOrder

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the CredManExcludeSalesOrder attribute are listed below.

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

is.dataFormat.integer

CredManReleasedFromCreditControl

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the CredManReleasedFromCreditControl attribute are listed below.

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

is.dataFormat.integer

CredManRejected

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the CredManRejected attribute are listed below.

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

is.dataFormat.integer

CredManId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

List of traits for the CredManId attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

CredManInCreditControl

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the CredManInCreditControl attribute are listed below.

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

is.dataFormat.integer

DOMIterations

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the DOMIterations attribute are listed below.

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

is.dataFormat.integer

DOMProcessed

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the DOMProcessed attribute are listed below.

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

is.dataFormat.integer

DOMProcessedDateTime

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the DOMProcessedDateTime attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

DOMIgnore

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the DOMIgnore attribute are listed below.

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

is.dataFormat.integer

DOMExceptionType

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the DOMExceptionType attribute are listed below.

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

is.dataFormat.integer

RevRecFollowOriginalPricingMethod

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
displayName	Apply residual method
dataFormat	int32
isNullable	true

Traits

List of traits for the RevRecFollowOriginalPricingMethod 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	Apply residual method

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

RevRecContractEndDate

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
displayName	End date
dataFormat	date
isNullable	true

Traits

List of traits for the RevRecContractEndDate attribute are listed below.

is.dataFormat.date
means.measurement.date
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	End date

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.date

RevRecContractStartDate

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the RevRecContractStartDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

RevRecLatestReverseJournal

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

RevRecMultipleSOReallocation

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the RevRecMultipleSOReallocation attribute are listed below.

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

is.dataFormat.integer

RevRecReallocationId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DataAreaId

First included in: WorksheetHeader/SalesTable (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_AgreementRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_AgreementRelationshipId 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/AgreementHeader.cdm.json/AgreementHeader	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_BankAccount_LVRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_BankAccount_LVRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Bank/Main/BankAccountTable.cdm.json/BankAccountTable	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_BankCentralBankPurposeRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_BankCentralBankPurposeRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Bank/Group/BankCentralBankPurpose.cdm.json/BankCentralBankPurpose	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_CashDiscRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CashDiscRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Bank/Group/CashDisc.cdm.json/CashDisc	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_CommissionCustomerGroupRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CommissionCustomerGroupRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/Group/CommissionCustomerGroup.cdm.json/CommissionCustomerGroup	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_CommissionSalesGroupRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CommissionSalesGroupRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/Group/CommissionSalesGroup.cdm.json/CommissionSalesGroup	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_ContactPersonRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ContactPersonRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/Main/ContactPerson.cdm.json/ContactPerson	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_CountyOrigDestRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CountyOrigDestRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Common/GAB/Group/LogisticsAddressCounty.cdm.json/LogisticsAddressCounty	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_CreditCardRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CreditCardRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/AccountsReceivable/Main/CreditCardCust.cdm.json/CreditCardCust	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_CurBankAccount_LVRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CurBankAccount_LVRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Bank/Main/BankAccountTable.cdm.json/BankAccountTable	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_CurrencyRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CurrencyRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Common/Currency/Group/Currency.cdm.json/Currency	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_CustBankAccount_LVRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustBankAccount_LVRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/AccountsReceivable/Main/CustBankAccount.cdm.json/CustBankAccount	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_CustDirectDebitMandateRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustDirectDebitMandateRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/AccountsReceivable/Main/CustDirectDebitMandate.cdm.json/CustDirectDebitMandate	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_CustGroupRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustGroupRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/AccountsReceivable/Group/CustGroup.cdm.json/CustGroup	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_CustInvoiceJourRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustInvoiceJourRelationshipId attribute are listed below.

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_CustLedgerRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustLedgerRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/AccountsReceivable/Group/CustLedger.cdm.json/CustLedger	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_CustLineDiscountGroupRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustLineDiscountGroupRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/Group/PriceDiscGroup.cdm.json/PriceDiscGroup	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_CustMarkupGroupRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustMarkupGroupRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/ProcurementAndSourcing/Group/MarkupGroup.cdm.json/MarkupGroup	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_CustMultiLineDiscountGroupRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustMultiLineDiscountGroupRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/Group/PriceDiscGroup.cdm.json/PriceDiscGroup	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_CustPaymModeSpecRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustPaymModeSpecRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Bank/Group/CustPaymModeSpec.cdm.json/CustPaymModeSpec	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_CustPaymModeTableRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustPaymModeTableRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Bank/Group/CustPaymModeTable.cdm.json/CustPaymModeTable	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_CustPriceGroupRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustPriceGroupRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/Group/PriceDiscGroup.cdm.json/PriceDiscGroup	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_CustTotalDiscountGroupRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustTotalDiscountGroupRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/Group/PriceDiscGroup.cdm.json/PriceDiscGroup	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_DefaultDimensionRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_DefaultDimensionRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/FinancialDimensions/Main/DimensionAttributeValueSet.cdm.json/DimensionAttributeValueSet	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_DeliveryPostalAddress_FKRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_DeliveryPostalAddress_FKRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Common/GAB/Main/LogisticsPostalAddress.cdm.json/LogisticsPostalAddress	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_DlvModeRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_DlvModeRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/Group/DlvMode.cdm.json/DlvMode	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_DlvReasonRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_DlvReasonRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/Group/DlvReason.cdm.json/DlvReason	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_DlvTermRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_DlvTermRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/Group/DlvTerm.cdm.json/DlvTerm	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_IntrastatPortRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_IntrastatPortRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Common/Intrastat/Group/IntrastatPort.cdm.json/IntrastatPort	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_IntrastatStatProcRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_IntrastatStatProcRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Common/Intrastat/Group/IntrastatStatProc.cdm.json/IntrastatStatProc	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_IntrastatTransactionCodeRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_IntrastatTransactionCodeRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Common/Intrastat/Group/IntrastatTransactionCode.cdm.json/IntrastatTransactionCode	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_IntrastatTransportModeRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_IntrastatTransportModeRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Common/Intrastat/Group/IntrastatTransportMode.cdm.json/IntrastatTransportMode	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_InventLocationRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InventLocationRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/Group/InventLocation.cdm.json/InventLocation	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_InventSiteRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InventSiteRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/Group/InventSite.cdm.json/InventSite	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_InvoiceCustomerRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InvoiceCustomerRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Common/Customer/Main/CustTable.cdm.json/CustTable	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_LanguageTableRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_LanguageTableRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/System/SystemAdministration/Group/LanguageTable.cdm.json/LanguageTable	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_MarkupGroupRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_MarkupGroupRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/ProcurementAndSourcing/Group/MarkupGroup.cdm.json/MarkupGroup	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_MCRHoldCodeTransRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_MCRHoldCodeTransRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/Transaction/MCRHoldCodeTrans.cdm.json/MCRHoldCodeTrans	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_NumberSequenceGroupRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_NumberSequenceGroupRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/System/SystemAdministration/Framework/NumberSequenceGroup.cdm.json/NumberSequenceGroup	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_OrderCustomerRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_OrderCustomerRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Common/Customer/Main/CustTable.cdm.json/CustTable	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_PaymSchedRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PaymSchedRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Bank/Group/PaymSched.cdm.json/PaymSched	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_PaymTermRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PaymTermRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Bank/Group/PaymTerm.cdm.json/PaymTerm	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_PdsCustRebateGroupRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PdsCustRebateGroupRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/Group/PdsCustRebateGroup.cdm.json/PdsCustRebateGroup	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_PdsRebateProgramTMATableRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PdsRebateProgramTMATableRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/Group/PdsRebateProgramTMATable.cdm.json/PdsRebateProgramTMATable	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_PlTaxDueTableRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PlTaxDueTableRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Tax/Group/PlTaxDueTable.cdm.json/PlTaxDueTable	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_PriceDiscChangePolicyRecId1RelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PriceDiscChangePolicyRecId1RelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/Group/PriceDiscChangePolicy.cdm.json/PriceDiscChangePolicy	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_PriceDiscChangePolicyRecId2RelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PriceDiscChangePolicyRecId2RelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/Group/PriceDiscChangePolicy.cdm.json/PriceDiscChangePolicy	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_ProjTableRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ProjTableRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/ProfessionalServices/ProjectManagementAndAccounting/Main/ProjTable.cdm.json/ProjTable	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/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PurchTableRelationshipId attribute are listed below.

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_PurchTableInterCompanyRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PurchTableInterCompanyRelationshipId attribute are listed below.

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_ReasonTableRefRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ReasonTableRefRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Ledger/Transaction/ReasonTableRef.cdm.json/ReasonTableRef	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_ReturnReasonCodeRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ReturnReasonCodeRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/Reference/ReturnReasonCode.cdm.json/ReturnReasonCode	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_SalesOriginRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SalesOriginRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/Group/SalesOrigin.cdm.json/SalesOrigin	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_SalesPoolRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SalesPoolRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/Group/SalesPool.cdm.json/SalesPool	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_ShipCarrierPostalAddress_FKRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ShipCarrierPostalAddress_FKRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Common/GAB/Main/LogisticsPostalAddress.cdm.json/LogisticsPostalAddress	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_smmCampaignTableRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_smmCampaignTableRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/Main/smmCampaignTable.cdm.json/smmCampaignTable	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_smmSalesUnitRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_smmSalesUnitRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/Group/smmSalesUnit.cdm.json/smmSalesUnit	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_SourceDocumentHeaderRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SourceDocumentHeaderRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/AccountingFoundation/TransactionHeader/SourceDocumentHeader.cdm.json/SourceDocumentHeader	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_TaxGroupHeadingRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TaxGroupHeadingRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Tax/Group/TaxGroupHeading.cdm.json/TaxGroupHeading	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_TaxServiceTariffRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TaxServiceTariffRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Tax/Transaction/TaxServiceTariff.cdm.json/TaxServiceTariff	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_TaxWithholdGroupHeadingTCS_INRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TaxWithholdGroupHeadingTCS_INRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Tax/Group/TaxWithholdGroupHeading.cdm.json/TaxWithholdGroupHeading	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_TaxWithholdGroupHeadingTDS_INRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TaxWithholdGroupHeadingTDS_INRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Tax/Group/TaxWithholdGroupHeading.cdm.json/TaxWithholdGroupHeading	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_TransportationDocumentRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TransportationDocumentRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/AccountsReceivable/WorksheetHeader/TransportationDocument.cdm.json/TransportationDocument	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_SATPaymMethod_MXRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SATPaymMethod_MXRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/EInvoice/Group/EInvoiceExtCodeTable_MX.cdm.json/EInvoiceExtCodeTable_MX	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_SATPurpose_MXRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SATPurpose_MXRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/EInvoice/Group/EInvoiceExtCodeTable_MX.cdm.json/EInvoiceExtCodeTable_MX	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_SATIncotermCode_MXRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SATIncotermCode_MXRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/EInvoice/Group/EInvoiceExtCodeTable_MX.cdm.json/EInvoiceExtCodeTable_MX	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_LogisticsAddressCountryRegionRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_LogisticsAddressCountryRegionRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Common/GAB/Group/LogisticsAddressCountryRegion.cdm.json/LogisticsAddressCountryRegion	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_SATShippingReason_MXRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SATShippingReason_MXRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/EInvoice/Group/EInvoiceExtCodeTable_MX.cdm.json/EInvoiceExtCodeTable_MX	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_AccountingDistributionTemplateRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_AccountingDistributionTemplateRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/AccountingFoundation/Group/AccountingDistributionTemplate.cdm.json/AccountingDistributionTemplate	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_ProjFundingSourceRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ProjFundingSourceRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/ProfessionalServices/ProjectManagementAndAccounting/Main/ProjFundingSource.cdm.json/ProjFundingSource	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_CustIntentLetter_ITRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustIntentLetter_ITRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/AccountsReceivable/Miscellaneous/CustIntentLetter_IT.cdm.json/CustIntentLetter_IT	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_CredManTableRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CredManTableRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/AccountsReceivable/Miscellaneous/CredManTable.cdm.json/CredManTable	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_RevRecLatestReverseJournalRelationshipId

First included in: WorksheetHeader/SalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_RevRecLatestReverseJournalRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/AccountingFoundation/WorksheetHeader/LedgerJournalTable.cdm.json/LedgerJournalTable	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 (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CompanyRelationshipId attribute are listed below.

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

Share via

Sales orders in WorksheetHeader(SalesTable)

Traits

Attributes

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits