Purchase order - update table in WorksheetHeader(PurchParmTable)

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	PurchParmTable/(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 order - update table	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetHeader/PurchParmTable
OrderAccount		WorksheetHeader/PurchParmTable
BankLCImportLine		WorksheetHeader/PurchParmTable
BatchAdministration		WorksheetHeader/PurchParmTable
CashDisc		WorksheetHeader/PurchParmTable
CashDiscCode		WorksheetHeader/PurchParmTable
CashDiscDate		WorksheetHeader/PurchParmTable
CashDiscPercent		WorksheetHeader/PurchParmTable
ConsignmentNoteNum_IN		WorksheetHeader/PurchParmTable
CountyOrigDest		WorksheetHeader/PurchParmTable
CurrencyCode		WorksheetHeader/PurchParmTable
CustomsBillOfEntryNumberTable_IN		WorksheetHeader/PurchParmTable
CustomsImportInvoiceNumberTable_IN		WorksheetHeader/PurchParmTable
DeliveryName		WorksheetHeader/PurchParmTable
DeliveryPostalAddress		WorksheetHeader/PurchParmTable
Description		WorksheetHeader/PurchParmTable
DocumentDate		WorksheetHeader/PurchParmTable
DocumentNum		WorksheetHeader/PurchParmTable
DocumentOrigin		WorksheetHeader/PurchParmTable
ElectronicInvoice_BR		WorksheetHeader/PurchParmTable
EndDateTime		WorksheetHeader/PurchParmTable
EndDisc		WorksheetHeader/PurchParmTable
EnterpriseNumber		WorksheetHeader/PurchParmTable
EUROTriangulation		WorksheetHeader/PurchParmTable
ExchRate		WorksheetHeader/PurchParmTable
ExchRateSecondary		WorksheetHeader/PurchParmTable
FiscalDocumentModel_BR		WorksheetHeader/PurchParmTable
FiscalDocumentSeries_BR		WorksheetHeader/PurchParmTable
FiscalDocumentSpecie_BR		WorksheetHeader/PurchParmTable
FiscalDocumentType_BR		WorksheetHeader/PurchParmTable
FixedDueDate		WorksheetHeader/PurchParmTable
FixedExchRate		WorksheetHeader/PurchParmTable
Hold		WorksheetHeader/PurchParmTable
IgnoreCalculatedSalesTax		WorksheetHeader/PurchParmTable
InclTax		WorksheetHeader/PurchParmTable
InventProfileType_RU		WorksheetHeader/PurchParmTable
InvoiceAccount		WorksheetHeader/PurchParmTable
InvoiceReleaseDate		WorksheetHeader/PurchParmTable
InvoiceRoundOff		WorksheetHeader/PurchParmTable
LastMatchVariance		WorksheetHeader/PurchParmTable
Log		WorksheetHeader/PurchParmTable
Num		WorksheetHeader/PurchParmTable
NumberSequenceGroup		WorksheetHeader/PurchParmTable
OffReportType_RU		WorksheetHeader/PurchParmTable
OffSessionId_RU		WorksheetHeader/PurchParmTable
Ordering		WorksheetHeader/PurchParmTable
PackingSlipIdForUpdate_W		WorksheetHeader/PurchParmTable
ParmId		WorksheetHeader/PurchParmTable
ParmJobStatus		WorksheetHeader/PurchParmTable
Payment		WorksheetHeader/PurchParmTable
PaymentSched		WorksheetHeader/PurchParmTable
PaymId		WorksheetHeader/PurchParmTable
PaymMode		WorksheetHeader/PurchParmTable
PaymSpec		WorksheetHeader/PurchParmTable
Port		WorksheetHeader/PurchParmTable
PostingProfile		WorksheetHeader/PurchParmTable
PurchId		WorksheetHeader/PurchParmTable
PurchName		WorksheetHeader/PurchParmTable
ReasonTableRef_BR		WorksheetHeader/PurchParmTable
ReCalculate		WorksheetHeader/PurchParmTable
ReleaseDateComment		WorksheetHeader/PurchParmTable
RemittanceLocation		WorksheetHeader/PurchParmTable
ServiceCodeOnDlvAddress_BR		WorksheetHeader/PurchParmTable
SettleVoucher		WorksheetHeader/PurchParmTable
StartDateTime		WorksheetHeader/PurchParmTable
StatProcId		WorksheetHeader/PurchParmTable
Storno		WorksheetHeader/PurchParmTable
StornoPhysical_RU		WorksheetHeader/PurchParmTable
TableRefId		WorksheetHeader/PurchParmTable
TaxGroup		WorksheetHeader/PurchParmTable
TaxInformation_IN		WorksheetHeader/PurchParmTable
TaxRoundOff		WorksheetHeader/PurchParmTable
TransactionCode		WorksheetHeader/PurchParmTable
TransDate		WorksheetHeader/PurchParmTable
Transport		WorksheetHeader/PurchParmTable
VarianceApproved		WorksheetHeader/PurchParmTable
VarianceApprovedDateTime		WorksheetHeader/PurchParmTable
VarianceComment		WorksheetHeader/PurchParmTable
VATNum		WorksheetHeader/PurchParmTable
VendBankAccountID		WorksheetHeader/PurchParmTable
VendFinalUser_BR		WorksheetHeader/PurchParmTable
VendInvoiceGroup		WorksheetHeader/PurchParmTable
VendInvoiceSaveStatus		WorksheetHeader/PurchParmTable
VendPackingSlipJour		WorksheetHeader/PurchParmTable
VendPaymentGroup		WorksheetHeader/PurchParmTable
WorkflowState		WorksheetHeader/PurchParmTable
PresenceType_BR		WorksheetHeader/PurchParmTable
DocAutoNumbering_LT		WorksheetHeader/PurchParmTable
ReportingCurrencyExchangeRate		WorksheetHeader/PurchParmTable
LoadId		WorksheetHeader/PurchParmTable
DataAreaId		WorksheetHeader/PurchParmTable
Relationship_BankLCImportLineRelationshipId		WorksheetHeader/PurchParmTable
Relationship_CashDiscRelationshipId		WorksheetHeader/PurchParmTable
Relationship_CountyOrigDestRelationshipId		WorksheetHeader/PurchParmTable
Relationship_CurrencyRelationshipId		WorksheetHeader/PurchParmTable
Relationship_CustomsBillOfEntryNumberTable_INRelationshipId		WorksheetHeader/PurchParmTable
Relationship_CustomsImportInvoiceNumberTable_INRelationshipId		WorksheetHeader/PurchParmTable
Relationship_DeliveryPostalAddress_FKRelationshipId		WorksheetHeader/PurchParmTable
Relationship_FiscalDocModel_BRRelationshipId		WorksheetHeader/PurchParmTable
Relationship_FiscalDocumentType_BRRelationshipId		WorksheetHeader/PurchParmTable
Relationship_IntrastatPortRelationshipId		WorksheetHeader/PurchParmTable
Relationship_IntrastatStatProcRelationshipId		WorksheetHeader/PurchParmTable
Relationship_IntrastatTransactionCodeRelationshipId		WorksheetHeader/PurchParmTable
Relationship_IntrastatTransportModeRelationshipId		WorksheetHeader/PurchParmTable
Relationship_InvoiceVendorRelationshipId		WorksheetHeader/PurchParmTable
Relationship_NumberSequenceGroupRelationshipId		WorksheetHeader/PurchParmTable
Relationship_OfficialsTrans_RURelationshipId		WorksheetHeader/PurchParmTable
Relationship_OrderVendorRelationshipId		WorksheetHeader/PurchParmTable
Relationship_PaymSchedRelationshipId		WorksheetHeader/PurchParmTable
Relationship_PaymTermRelationshipId		WorksheetHeader/PurchParmTable
Relationship_PurchParmUpdateRelationshipId		WorksheetHeader/PurchParmTable
Relationship_PurchTableRelationshipId		WorksheetHeader/PurchParmTable
Relationship_ReasonTableRefRelationshipId		WorksheetHeader/PurchParmTable
Relationship_RemittanceLocation_FKRelationshipId		WorksheetHeader/PurchParmTable
Relationship_TaxGroupHeadingRelationshipId		WorksheetHeader/PurchParmTable
Relationship_TaxInformation_INRelationshipId		WorksheetHeader/PurchParmTable
Relationship_TaxWorkRegulationRelationshipId		WorksheetHeader/PurchParmTable
Relationship_VendBankAccountRelationshipId		WorksheetHeader/PurchParmTable
Relationship_VendLedgerRelationshipId		WorksheetHeader/PurchParmTable
Relationship_VendPackingSlipJourRelationshipId		WorksheetHeader/PurchParmTable
Relationship_VendPaymentModeSpecRelationshipId		WorksheetHeader/PurchParmTable
Relationship_VendPaymModeTableRelationshipId		WorksheetHeader/PurchParmTable
Relationship_WHSLoadTableRelationshipId		WorksheetHeader/PurchParmTable
Relationship_CompanyRelationshipId		WorksheetHeader/PurchParmTable

RecId

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

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

OrderAccount

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

BankLCImportLine

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

BatchAdministration

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the BatchAdministration attribute are listed below.

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

is.dataFormat.integer

CashDisc

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
displayName	Cash discount
dataFormat	decimal
isNullable	true

Traits

List of traits for the CashDisc attribute are listed below.

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

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

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

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

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

CashDiscCode

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

CashDiscDate

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the CashDiscDate attribute are listed below.

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

is.dataFormat.date

CashDiscPercent

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

ConsignmentNoteNum_IN

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the ConsignmentNoteNum_IN attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

CountyOrigDest

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

CurrencyCode

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

CustomsBillOfEntryNumberTable_IN

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
displayName	Number
dataFormat	int64
isNullable	true

Traits

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

is.dataFormat.integer
is.dataFormat.big

CustomsImportInvoiceNumberTable_IN

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
displayName	Import invoice number
dataFormat	int64
isNullable	true

Traits

List of traits for the CustomsImportInvoiceNumberTable_IN 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 Import invoice number	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

DeliveryName

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

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

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

is.dataFormat.character
is.dataFormat.array

DeliveryPostalAddress

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

Description

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DocumentDate

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the DocumentDate attribute are listed below.

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

is.dataFormat.date

DocumentNum

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
displayName	Document number
dataFormat	string
isNullable	true

Traits

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

is.dataFormat.character
is.dataFormat.array

DocumentOrigin

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the DocumentOrigin attribute are listed below.

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

is.dataFormat.integer

ElectronicInvoice_BR

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ElectronicInvoice_BR attribute are listed below.

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

is.dataFormat.integer

EndDateTime

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the EndDateTime attribute are listed below.

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

is.dataFormat.date

EndDisc

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

EnterpriseNumber

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

EUROTriangulation

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the EUROTriangulation attribute are listed below.

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

is.dataFormat.integer

ExchRate

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

ExchRateSecondary

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

FiscalDocumentModel_BR

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the FiscalDocumentModel_BR attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

FiscalDocumentSeries_BR

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the FiscalDocumentSeries_BR attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

FiscalDocumentSpecie_BR

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the FiscalDocumentSpecie_BR attribute are listed below.

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

is.dataFormat.integer

FiscalDocumentType_BR

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

List of traits for the FiscalDocumentType_BR attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

FixedDueDate

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

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the FixedExchRate attribute are listed below.

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

is.dataFormat.integer

Hold

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the Hold attribute are listed below.

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

is.dataFormat.integer

IgnoreCalculatedSalesTax

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
displayName	Ignore calculated sales tax
dataFormat	int32
isNullable	true

Traits

List of traits for the IgnoreCalculatedSalesTax 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 Ignore calculated sales tax	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

InclTax

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

InventProfileType_RU

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the InventProfileType_RU attribute are listed below.

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

is.dataFormat.integer

InvoiceAccount

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

InvoiceReleaseDate

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the InvoiceReleaseDate attribute are listed below.

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

is.dataFormat.date

InvoiceRoundOff

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

LastMatchVariance

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the LastMatchVariance attribute are listed below.

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

is.dataFormat.integer

Log

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

Num

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the Num 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/PurchParmTable (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

OffReportType_RU

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the OffReportType_RU attribute are listed below.

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

is.dataFormat.integer

OffSessionId_RU

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

Ordering

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
displayName	Update
dataFormat	int32
isNullable	true

Traits

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

is.dataFormat.integer

PackingSlipIdForUpdate_W

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ParmId

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the ParmId attribute are listed below.

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

ParmJobStatus

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ParmJobStatus 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/PurchParmTable (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/PurchParmTable (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

PaymId

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the PaymId 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/PurchParmTable (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/PurchParmTable (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/PurchParmTable (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/PurchParmTable (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

PurchId

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the PurchId attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

PurchName

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

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

ReasonTableRef_BR

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

List of traits for the ReasonTableRef_BR attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

ReCalculate

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
displayName	Recalculation
dataFormat	int32
isNullable	true

Traits

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

is.dataFormat.integer

ReleaseDateComment

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

RemittanceLocation

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

List of traits for the RemittanceLocation attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

ServiceCodeOnDlvAddress_BR

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ServiceCodeOnDlvAddress_BR attribute are listed below.

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

is.dataFormat.integer

SettleVoucher

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

StartDateTime

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the StartDateTime attribute are listed below.

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

is.dataFormat.date

StatProcId

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

Storno

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
displayName	Credit correction
dataFormat	int32
isNullable	true

Traits

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

is.dataFormat.integer

StornoPhysical_RU

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
displayName	Credit correction (physical)
dataFormat	int32
isNullable	true

Traits

List of traits for the StornoPhysical_RU 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 Credit correction (physical)	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

TableRefId

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the TableRefId attribute are listed below.

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

TaxGroup

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

TaxInformation_IN

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

TaxRoundOff

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
displayName	Sales tax rounding
dataFormat	decimal
isNullable	true

Traits

List of traits for the TaxRoundOff attribute are listed below.

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

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

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

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

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

TransactionCode

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

TransDate

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the TransDate attribute are listed below.

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

is.dataFormat.date

Transport

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

VarianceApproved

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the VarianceApproved attribute are listed below.

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

is.dataFormat.integer

VarianceApprovedDateTime

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the VarianceApprovedDateTime attribute are listed below.

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

is.dataFormat.date

VarianceComment

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the VarianceComment 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/PurchParmTable (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

VendBankAccountID

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

VendFinalUser_BR

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the VendFinalUser_BR attribute are listed below.

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

is.dataFormat.integer

VendInvoiceGroup

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

VendInvoiceSaveStatus

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the VendInvoiceSaveStatus attribute are listed below.

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

is.dataFormat.integer

VendPackingSlipJour

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

VendPaymentGroup

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

WorkflowState

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the WorkflowState attribute are listed below.

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

is.dataFormat.integer

PresenceType_BR

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the PresenceType_BR attribute are listed below.

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

is.dataFormat.integer

DocAutoNumbering_LT

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the DocAutoNumbering_LT attribute are listed below.

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

is.dataFormat.integer

ReportingCurrencyExchangeRate

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

LoadId

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

DataAreaId

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

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_BankLCImportLineRelationshipId 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/WorksheetLine/BankLCImportLine.cdm.json/BankLCImportLine 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/PurchParmTable (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_CountyOrigDestRelationshipId

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

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustomsBillOfEntryNumberTable_INRelationshipId attribute are listed below.

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

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

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

Relationship_CustomsImportInvoiceNumberTable_INRelationshipId

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustomsImportInvoiceNumberTable_INRelationshipId attribute are listed below.

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

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

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

Relationship_DeliveryPostalAddress_FKRelationshipId

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_DeliveryPostalAddress_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/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_FiscalDocModel_BRRelationshipId

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_FiscalDocModel_BRRelationshipId attribute are listed below.

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

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

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

Relationship_FiscalDocumentType_BRRelationshipId

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_FiscalDocumentType_BRRelationshipId attribute are listed below.

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

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

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

Relationship_IntrastatPortRelationshipId

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

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

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

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_OfficialsTrans_RURelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/APARShared/Transaction/OfficialsTrans_RU.cdm.json/OfficialsTrans_RU 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/PurchParmTable (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/PurchParmTable (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/PurchParmTable (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_PurchParmUpdateRelationshipId

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PurchParmUpdateRelationshipId 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/Transaction/PurchParmUpdate.cdm.json/PurchParmUpdate RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_PurchTableRelationshipId

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PurchTableRelationshipId attribute are listed below.

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

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

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

Relationship_ReasonTableRefRelationshipId

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

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_RemittanceLocation_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/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_TaxGroupHeadingRelationshipId

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

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TaxInformation_INRelationshipId 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/Miscellaneous/TaxInformation_IN.cdm.json/TaxInformation_IN RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_TaxWorkRegulationRelationshipId

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TaxWorkRegulationRelationshipId 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/WorksheetLine/TaxWorkRegulation.cdm.json/TaxWorkRegulation RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_VendBankAccountRelationshipId

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_VendBankAccountRelationshipId 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/VendBankAccount.cdm.json/VendBankAccount 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/PurchParmTable (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_VendPackingSlipJourRelationshipId

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_VendPackingSlipJourRelationshipId 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/Transaction/VendPackingSlipJour.cdm.json/VendPackingSlipJour RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_VendPaymentModeSpecRelationshipId

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_VendPaymentModeSpecRelationshipId 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/PurchParmTable (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_WHSLoadTableRelationshipId

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_WHSLoadTableRelationshipId 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/WorksheetHeader/WHSLoadTable.cdm.json/WHSLoadTable 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/PurchParmTable (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