Purchase orders in WorksheetHeader(PurchTable)

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

Traits

Traits for this entity are listed below.

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

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

is.CDM.entityVersion

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

is.application.releaseVersion

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

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

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

Attributes

Name	Description	First Included in Instance
RecId		WorksheetHeader/PurchTable
OrderAccount		WorksheetHeader/PurchTable
LineDisc		WorksheetHeader/PurchTable
AccountingDate		WorksheetHeader/PurchTable
AccountingDistributionTemplate		WorksheetHeader/PurchTable
AddressRefRecId		WorksheetHeader/PurchTable
AddressRefTableId		WorksheetHeader/PurchTable
AutoSummaryModuleType		WorksheetHeader/PurchTable
AvailSalesDate		WorksheetHeader/PurchTable
BankCentralBankPurposeCode		WorksheetHeader/PurchTable
BankCentralBankPurposeText		WorksheetHeader/PurchTable
BankDocumentType		WorksheetHeader/PurchTable
CashDisc		WorksheetHeader/PurchTable
CashDiscPercent		WorksheetHeader/PurchTable
ChangeRequestRequired		WorksheetHeader/PurchTable
ConfirmedDlv		WorksheetHeader/PurchTable
ConfirmedDlvEarliest		WorksheetHeader/PurchTable
ConfirmingPO		WorksheetHeader/PurchTable
ConsTarget_JP		WorksheetHeader/PurchTable
ContactPersonId		WorksheetHeader/PurchTable
ContractNum_SA		WorksheetHeader/PurchTable
CountyOrigDest		WorksheetHeader/PurchTable
CovStatus		WorksheetHeader/PurchTable
CrossDockingDate		WorksheetHeader/PurchTable
CurrencyCode		WorksheetHeader/PurchTable
DefaultDimension		WorksheetHeader/PurchTable
DeliveryDate		WorksheetHeader/PurchTable
DeliveryName		WorksheetHeader/PurchTable
DeliveryPostalAddress		WorksheetHeader/PurchTable
DeliveryType		WorksheetHeader/PurchTable
DiscPercent		WorksheetHeader/PurchTable
DlvMode		WorksheetHeader/PurchTable
DlvTerm		WorksheetHeader/PurchTable
DocumentState		WorksheetHeader/PurchTable
DocumentStatus		WorksheetHeader/PurchTable
Email		WorksheetHeader/PurchTable
EndDisc		WorksheetHeader/PurchTable
EnterpriseNumber		WorksheetHeader/PurchTable
ExchangeRateDate		WorksheetHeader/PurchTable
FinalizeClosingDate		WorksheetHeader/PurchTable
FixedDueDate		WorksheetHeader/PurchTable
FixedExchRate		WorksheetHeader/PurchTable
FreightSlipType		WorksheetHeader/PurchTable
FreightZone		WorksheetHeader/PurchTable
FSHAutoCreated		WorksheetHeader/PurchTable
InclTax		WorksheetHeader/PurchTable
InterCompanyAllowIndirectCreation		WorksheetHeader/PurchTable
InterCompanyCompanyId		WorksheetHeader/PurchTable
InterCompanyCustPurchOrderFormNum		WorksheetHeader/PurchTable
InterCompanyDirectDelivery		WorksheetHeader/PurchTable
InterCompanyOrder		WorksheetHeader/PurchTable
InterCompanyOrigin		WorksheetHeader/PurchTable
InterCompanyOriginalCustAccount		WorksheetHeader/PurchTable
InterCompanyOriginalSalesId		WorksheetHeader/PurchTable
InterCompanySalesId		WorksheetHeader/PurchTable
IntrastatAddValue_LV		WorksheetHeader/PurchTable
IntrastatFulfillmentDate_HU		WorksheetHeader/PurchTable
InventLocationId		WorksheetHeader/PurchTable
InventSiteId		WorksheetHeader/PurchTable
InvoiceAccount		WorksheetHeader/PurchTable
InvoiceAutoNumbering_LT		WorksheetHeader/PurchTable
IsEncumbranceRequired		WorksheetHeader/PurchTable
IsModified		WorksheetHeader/PurchTable
ItemBuyerGroupId		WorksheetHeader/PurchTable
LanguageId		WorksheetHeader/PurchTable
ListCode		WorksheetHeader/PurchTable
LocalDeliveryDate		WorksheetHeader/PurchTable
ManualEntryChangepolicy		WorksheetHeader/PurchTable
MarkupGroup		WorksheetHeader/PurchTable
MatchingAgreement		WorksheetHeader/PurchTable
MCRDropShipment		WorksheetHeader/PurchTable
MultiLineDisc		WorksheetHeader/PurchTable
NumberSequenceGroup		WorksheetHeader/PurchTable
OneTimeSupplier		WorksheetHeader/PurchTable
OneTimeVendor		WorksheetHeader/PurchTable
PackedExtensions		WorksheetHeader/PurchTable
PackingSlipAutoNumbering_LT		WorksheetHeader/PurchTable
Payment		WorksheetHeader/PurchTable
PaymentSched		WorksheetHeader/PurchTable
PaymMode		WorksheetHeader/PurchTable
PaymSpec		WorksheetHeader/PurchTable
Port		WorksheetHeader/PurchTable
PostingProfile		WorksheetHeader/PurchTable
PriceGroupId		WorksheetHeader/PurchTable
ProjId		WorksheetHeader/PurchTable
PurchaseType		WorksheetHeader/PurchTable
PurchId		WorksheetHeader/PurchTable
PurchName		WorksheetHeader/PurchTable
PurchPoolId		WorksheetHeader/PurchTable
PurchStatus		WorksheetHeader/PurchTable
ReasonTableRef		WorksheetHeader/PurchTable
ReceiptDateConfirmed		WorksheetHeader/PurchTable
ReplenishmentLocation		WorksheetHeader/PurchTable
ReqAttention		WorksheetHeader/PurchTable
Requester		WorksheetHeader/PurchTable
RetailDriverDetails		WorksheetHeader/PurchTable
RetailRetailStatusType		WorksheetHeader/PurchTable
ReturnItemNum		WorksheetHeader/PurchTable
ReturnReasonCodeId		WorksheetHeader/PurchTable
ReturnReplacementCreated		WorksheetHeader/PurchTable
ServiceAddress		WorksheetHeader/PurchTable
ServiceCategory		WorksheetHeader/PurchTable
ServiceDate		WorksheetHeader/PurchTable
ServiceName		WorksheetHeader/PurchTable
SettleVoucher		WorksheetHeader/PurchTable
ShippingDateConfirmed		WorksheetHeader/PurchTable
ShippingDateRequested		WorksheetHeader/PurchTable
SkipUpdate		WorksheetHeader/PurchTable
SourceDocumentHeader		WorksheetHeader/PurchTable
SourceDocumentLine		WorksheetHeader/PurchTable
StatProcId		WorksheetHeader/PurchTable
SystemEntryChangePolicy		WorksheetHeader/PurchTable
SystemEntrySource		WorksheetHeader/PurchTable
TAMVendRebateGroupId		WorksheetHeader/PurchTable
TaxGroup		WorksheetHeader/PurchTable
TaxPeriodPaymentCode_PL		WorksheetHeader/PurchTable
TransactionCode		WorksheetHeader/PurchTable
Transport		WorksheetHeader/PurchTable
TransportationDocument		WorksheetHeader/PurchTable
UnitedVATInvoice_LT		WorksheetHeader/PurchTable
URL		WorksheetHeader/PurchTable
VATNum		WorksheetHeader/PurchTable
VendGroup		WorksheetHeader/PurchTable
VendInvoiceDeclaration_IS		WorksheetHeader/PurchTable
VendorRef		WorksheetHeader/PurchTable
WorkerPurchPlacer		WorksheetHeader/PurchTable
SkipCreateMarkup		WorksheetHeader/PurchTable
SkipVersioning		WorksheetHeader/PurchTable
PurchaseOrderHeaderCreationMethod		WorksheetHeader/PurchTable
InvoiceRegister_LT		WorksheetHeader/PurchTable
PackingSlipRegister_LT		WorksheetHeader/PurchTable
PurchOrderFormNum		WorksheetHeader/PurchTable
BillToAddress		WorksheetHeader/PurchTable
ReportingCurrencyFixedExchRate		WorksheetHeader/PurchTable
CXMLOrderEnable		WorksheetHeader/PurchTable
IntentLetterId_IT		WorksheetHeader/PurchTable
ExtensionQuantity		WorksheetHeader/PurchTable
DataAreaId		WorksheetHeader/PurchTable
Relationship_AccountingDistributionTemplateRelationshipId		WorksheetHeader/PurchTable
Relationship_AgreementRelationshipId		WorksheetHeader/PurchTable
Relationship_BankCentralBankPurposeRelationshipId		WorksheetHeader/PurchTable
Relationship_CashDiscRelationshipId		WorksheetHeader/PurchTable
Relationship_ConfirmingPORelationshipId		WorksheetHeader/PurchTable
Relationship_ContactPersonRelationshipId		WorksheetHeader/PurchTable
Relationship_CountyOrigDestRelationshipId		WorksheetHeader/PurchTable
Relationship_CurrencyRelationshipId		WorksheetHeader/PurchTable
Relationship_DefaultDimensionRelationshipId		WorksheetHeader/PurchTable
Relationship_DeliveryPostalAddressRelationshipId		WorksheetHeader/PurchTable
Relationship_DlvModeRelationshipId		WorksheetHeader/PurchTable
Relationship_DlvTermRelationshipId		WorksheetHeader/PurchTable
Relationship_IntrastatPortRelationshipId		WorksheetHeader/PurchTable
Relationship_IntrastatStatProcRelationshipId		WorksheetHeader/PurchTable
Relationship_IntrastatTransactionCodeRelationshipId		WorksheetHeader/PurchTable
Relationship_IntrastatTransportModeRelationshipId		WorksheetHeader/PurchTable
Relationship_InventBuyerGroupRelationshipId		WorksheetHeader/PurchTable
Relationship_InventLocationRelationshipId		WorksheetHeader/PurchTable
Relationship_InventSiteRelationshipId		WorksheetHeader/PurchTable
Relationship_InvoiceDeclarationId_FKRelationshipId		WorksheetHeader/PurchTable
Relationship_InvoiceVendorRelationshipId		WorksheetHeader/PurchTable
Relationship_LanguageTableRelationshipId		WorksheetHeader/PurchTable
Relationship_MarkupGroupRelationshipId		WorksheetHeader/PurchTable
Relationship_MCRHoldCodeTransRelationshipId		WorksheetHeader/PurchTable
Relationship_NumberSequenceGroupRelationshipId		WorksheetHeader/PurchTable
Relationship_OrderVendorRelationshipId		WorksheetHeader/PurchTable
Relationship_PaymSchedRelationshipId		WorksheetHeader/PurchTable
Relationship_PaymTermRelationshipId		WorksheetHeader/PurchTable
Relationship_PlTaxDueTableRelationshipId		WorksheetHeader/PurchTable
Relationship_PriceDiscChangePolicyRecId1RelationshipId		WorksheetHeader/PurchTable
Relationship_PriceDiscChangePolicyRecId2RelationshipId		WorksheetHeader/PurchTable
Relationship_ProjTableRelationshipId		WorksheetHeader/PurchTable
Relationship_PurchPoolRelationshipId		WorksheetHeader/PurchTable
Relationship_ReasonTableRefRelationshipId		WorksheetHeader/PurchTable
Relationship_ReplenishmentLocationRelationshipId		WorksheetHeader/PurchTable
Relationship_ReturnReasonCodeRelationshipId		WorksheetHeader/PurchTable
Relationship_SalesTableInterCompanyRelationshipId		WorksheetHeader/PurchTable
Relationship_SourceDocumentHeaderRelationshipId		WorksheetHeader/PurchTable
Relationship_SourceDocumentLineRelationshipId		WorksheetHeader/PurchTable
Relationship_TAMVendRebateGroupRelationshipId		WorksheetHeader/PurchTable
Relationship_TaxGroupHeadingRelationshipId		WorksheetHeader/PurchTable
Relationship_TransportationDocumentRelationshipId		WorksheetHeader/PurchTable
Relationship_VendGroupRelationshipId		WorksheetHeader/PurchTable
Relationship_VendLedgerRelationshipId		WorksheetHeader/PurchTable
Relationship_VendLineDiscountGroupRelationshipId		WorksheetHeader/PurchTable
Relationship_VendMarkupGroupRelationshipId		WorksheetHeader/PurchTable
Relationship_VendMultiLineDiscountGroupRelationshipId		WorksheetHeader/PurchTable
Relationship_VendPaymModeSpecRelationshipId		WorksheetHeader/PurchTable
Relationship_VendPaymModeTableRelationshipId		WorksheetHeader/PurchTable
Relationship_VendPriceGroupRelationshipId		WorksheetHeader/PurchTable
Relationship_VendTotalDiscountGroupRelationshipId		WorksheetHeader/PurchTable
Relationship_BillToAddressRelationshipId		WorksheetHeader/PurchTable
Relationship_IntentLetter_ITRelationshipId		WorksheetHeader/PurchTable
Relationship_CompanyRelationshipId		WorksheetHeader/PurchTable

RecId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
isPrimaryKey	true
dataFormat	int64
isReadOnly	true

Traits

List of traits for the RecId attribute are listed below.

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

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

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

OrderAccount

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the OrderAccount attribute are listed below.

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

LineDisc

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

AccountingDate

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the AccountingDate attribute are listed below.

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

is.dataFormat.date

AccountingDistributionTemplate

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

AddressRefRecId

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

AvailSalesDate

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the AvailSalesDate attribute are listed below.

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

is.dataFormat.date

BankCentralBankPurposeCode

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

CashDiscPercent

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

ChangeRequestRequired

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ChangeRequestRequired attribute are listed below.

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

is.dataFormat.integer

ConfirmedDlv

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
displayName	Confirmed delivery date
dataFormat	date
isNullable	true

Traits

List of traits for the ConfirmedDlv 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 Confirmed delivery date	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.date

ConfirmedDlvEarliest

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
displayName	Earliest confirmed delivery
dataFormat	date
isReadOnly	true
isNullable	true

Traits

List of traits for the ConfirmedDlvEarliest attribute are listed below.

is.dataFormat.date
means.measurement.date
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 Earliest confirmed delivery	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.date

ConfirmingPO

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

ConsTarget_JP

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

ContractNum_SA

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the ContractNum_SA 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/PurchTable (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/PurchTable (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

CrossDockingDate

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the CrossDockingDate attribute are listed below.

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

is.dataFormat.date

CurrencyCode

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

DefaultDimension

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

DeliveryName

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

DeliveryType

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the DeliveryType attribute are listed below.

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

is.dataFormat.integer

DiscPercent

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

DlvTerm

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

DocumentState

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the DocumentState attribute are listed below.

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

is.dataFormat.integer

DocumentStatus

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

Email

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

ExchangeRateDate

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	date
isReadOnly	true
isNullable	true

Traits

List of traits for the ExchangeRateDate attribute are listed below.

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

is.dataFormat.date

FinalizeClosingDate

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the FinalizeClosingDate attribute are listed below.

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

is.dataFormat.date

FixedDueDate

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

FSHAutoCreated

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the FSHAutoCreated 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/PurchTable (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/PurchTable (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

InterCompanyCompanyId

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

InterCompanyCustPurchOrderFormNum

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

InterCompanyDirectDelivery

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
displayName	Intercompany direct delivery
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.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Intercompany direct delivery	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

InterCompanyOrder

First included in: WorksheetHeader/PurchTable (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/PurchTable (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/PurchTable (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/PurchTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

InterCompanySalesId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

IntrastatAddValue_LV

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

IsEncumbranceRequired

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the IsEncumbranceRequired attribute are listed below.

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

is.dataFormat.integer

IsModified

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the IsModified attribute are listed below.

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

is.dataFormat.integer

ItemBuyerGroupId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

LanguageId

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

LocalDeliveryDate

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the LocalDeliveryDate attribute are listed below.

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

is.dataFormat.date

ManualEntryChangepolicy

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

MCRDropShipment

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the MCRDropShipment 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/PurchTable (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

NumberSequenceGroup

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

OneTimeSupplier

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the OneTimeSupplier attribute are listed below.

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

is.dataFormat.integer

OneTimeVendor

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

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

Properties

Name	Value
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.dataFormat.character
is.dataFormat.array

PaymentSched

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

Port

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

PurchaseType

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the PurchaseType attribute are listed below.

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

is.dataFormat.integer

PurchId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the PurchId attribute are listed below.

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

PurchName

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
displayName	Vendor name
dataFormat	string
isNullable	true

Traits

List of traits for the PurchName 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 Vendor name	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

PurchPoolId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PurchStatus

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the PurchStatus attribute are listed below.

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

is.dataFormat.integer

ReasonTableRef

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
displayName	Reason
dataFormat	int64
isNullable	true

Traits

List of traits for the ReasonTableRef 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 Reason	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

ReceiptDateConfirmed

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	date
isReadOnly	true
isNullable	true

Traits

List of traits for the ReceiptDateConfirmed attribute are listed below.

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

is.dataFormat.date

ReplenishmentLocation

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
displayName	Location
dataFormat	string
isNullable	true

Traits

List of traits for the ReplenishmentLocation 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 Location	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

ReqAttention

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

Requester

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

RetailDriverDetails

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

RetailRetailStatusType

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the RetailRetailStatusType attribute are listed below.

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

is.dataFormat.integer

ReturnItemNum

First included in: WorksheetHeader/PurchTable (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/PurchTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

ReturnReplacementCreated

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ReturnReplacementCreated attribute are listed below.

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

is.dataFormat.integer

ServiceAddress

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
displayName	Service address
dataFormat	string
isReadOnly	true
isNullable	true

Traits

List of traits for the ServiceAddress 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.localized.displayedAs
Holds the list of language specific display text for an object.

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

is.dataFormat.character
is.dataFormat.array

ServiceCategory

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ServiceDate

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the ServiceDate attribute are listed below.

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

is.dataFormat.date

ServiceName

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
displayName	Service name
dataFormat	string
isNullable	true

Traits

List of traits for the ServiceName 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 Service name	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

SettleVoucher

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

ShippingDateConfirmed

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	date
isReadOnly	true
isNullable	true

Traits

List of traits for the ShippingDateConfirmed attribute are listed below.

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

is.dataFormat.date

ShippingDateRequested

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	date
isReadOnly	true
isNullable	true

Traits

List of traits for the ShippingDateRequested attribute are listed below.

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

is.dataFormat.date

SkipUpdate

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

SourceDocumentHeader

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

SourceDocumentLine

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
displayName	Source document line
dataFormat	int64
isNullable	true

Traits

List of traits for the SourceDocumentLine 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 line	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

StatProcId

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

TAMVendRebateGroupId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

TaxGroup

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

TransactionCode

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

VendGroup

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the VendGroup attribute are listed below.

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

VendInvoiceDeclaration_IS

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

VendorRef

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

WorkerPurchPlacer

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

List of traits for the WorkerPurchPlacer 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/PurchTable (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

SkipVersioning

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the SkipVersioning attribute are listed below.

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

is.dataFormat.integer

PurchaseOrderHeaderCreationMethod

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the PurchaseOrderHeaderCreationMethod attribute are listed below.

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

is.dataFormat.integer

InvoiceRegister_LT

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

PurchOrderFormNum

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

BillToAddress

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
displayName	Bill-to address
dataFormat	int64
isNullable	true

Traits

List of traits for the BillToAddress 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 Bill-to address	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

ReportingCurrencyFixedExchRate

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

CXMLOrderEnable

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the CXMLOrderEnable attribute are listed below.

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

is.dataFormat.integer

IntentLetterId_IT

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

ExtensionQuantity

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

DataAreaId

First included in: WorksheetHeader/PurchTable (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_AccountingDistributionTemplateRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_AccountingDistributionTemplateRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/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_AgreementRelationshipId

First included in: WorksheetHeader/PurchTable (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_BankCentralBankPurposeRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_BankCentralBankPurposeRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/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/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CashDiscRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/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_ConfirmingPORelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ConfirmingPORelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/PublicSector/Miscellaneous/ConfirmingPO.cdm.json/ConfirmingPO 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/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ContactPersonRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/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/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CountyOrigDestRelationshipId 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/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_CurrencyRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CurrencyRelationshipId 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/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_DefaultDimensionRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_DefaultDimensionRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/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_DeliveryPostalAddressRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_DlvModeRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/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_DlvTermRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_DlvTermRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/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/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

Properties

Name	Value
dataFormat	guid

Traits

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

Properties

Name	Value
dataFormat	guid

Traits

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

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_IntrastatTransportModeRelationshipId 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/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_InventBuyerGroupRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InventBuyerGroupRelationshipId 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/Inventory/Group/InventBuyerGroup.cdm.json/InventBuyerGroup 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/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InventSiteRelationshipId 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/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_InvoiceDeclarationId_FKRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InvoiceDeclarationId_FKRelationshipId attribute are listed below.

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

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

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

Relationship_InvoiceVendorRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InvoiceVendorRelationshipId 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/Vendor/Main/VendTable.cdm.json/VendTable 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/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

Properties

Name	Value
dataFormat	guid

Traits

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

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_MCRHoldCodeTransRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/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/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_NumberSequenceGroupRelationshipId 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/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_OrderVendorRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_OrderVendorRelationshipId 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/Vendor/Main/VendTable.cdm.json/VendTable 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/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PaymSchedRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/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/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PaymTermRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/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_PlTaxDueTableRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PlTaxDueTableRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/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/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PriceDiscChangePolicyRecId1RelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/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/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PriceDiscChangePolicyRecId2RelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/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/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ProjTableRelationshipId 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/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_PurchPoolRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PurchPoolRelationshipId 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/Group/PurchPool.cdm.json/PurchPool 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/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ReasonTableRefRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/Ledger/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_ReplenishmentLocationRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ReplenishmentLocationRelationshipId 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/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_ReturnReasonCodeRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ReturnReasonCodeRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/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_SalesTableInterCompanyRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SalesTableInterCompanyRelationshipId attribute are listed below.

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

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

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

Relationship_SourceDocumentHeaderRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SourceDocumentHeaderRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/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_SourceDocumentLineRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SourceDocumentLineRelationshipId attribute are listed below.

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

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

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

Relationship_TAMVendRebateGroupRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TAMVendRebateGroupRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/Group/TAMVendRebateGroup.cdm.json/TAMVendRebateGroup 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/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TaxGroupHeadingRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/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_TransportationDocumentRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TransportationDocumentRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/AccountsReceivable/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_VendGroupRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_VendGroupRelationshipId 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/Vendor/Group/VendGroup.cdm.json/VendGroup RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_VendLedgerRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_VendLedgerRelationshipId attribute are listed below.

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

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

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

Relationship_VendLineDiscountGroupRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_VendLineDiscountGroupRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/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_VendMarkupGroupRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_VendMarkupGroupRelationshipId 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/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_VendMultiLineDiscountGroupRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_VendMultiLineDiscountGroupRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/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_VendPaymModeSpecRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_VendPaymModeSpecRelationshipId attribute are listed below.

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

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

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

Relationship_VendPaymModeTableRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_VendPaymModeTableRelationshipId attribute are listed below.

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

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

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

Relationship_VendPriceGroupRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_VendPriceGroupRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/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_VendTotalDiscountGroupRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_VendTotalDiscountGroupRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/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_BillToAddressRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_BillToAddressRelationshipId 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/Common/GAB/Main/LogisticsLocation.cdm.json/LogisticsLocation RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_IntentLetter_ITRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_IntentLetter_ITRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/AccountsReceivable/Miscellaneous/IntentLetter_IT.cdm.json/IntentLetter_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_CompanyRelationshipId

First included in: WorksheetHeader/PurchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CompanyRelationshipId attribute are listed below.

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

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

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