편집

다음을 통해 공유


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

ParameterValueData typeExplanation
attributePurchParmTable/(resolvedAttributes)/RecIdattribute

is.CDM.entityVersion

ParameterValueData typeExplanation
versionNumber"1.1"stringsemantic version number of the entity

is.application.releaseVersion

ParameterValueData typeExplanation
releaseVersion"10.0.13.0"stringsemantic version number of the application introducing this entity

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enPurchase order - update table
entitya 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

NameValue
isPrimaryKeytrue
dataFormatint64
isReadOnlytrue

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

ParameterValueData typeExplanation
attributePurchParmTable/(resolvedAttributes)/RecIdattribute

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

OrderAccount

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatint64
isNullabletrue

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

NameValue
dataFormatint32
isNullabletrue

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

NameValue
displayNameCash discount
dataFormatdecimal
isNullabletrue

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.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enCash discount
entitya 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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatdate
isNullabletrue

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

NameValue
dataFormatdecimal
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatstring

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

NameValue
displayNameNumber
dataFormatint64
isNullabletrue

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.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enNumber
entitya 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

NameValue
displayNameImport invoice number
dataFormatint64
isNullabletrue

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.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enImport invoice number
entitya 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

NameValue
displayNameDelivery name
dataFormatstring
isNullabletrue

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.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enDelivery name
entitya 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

NameValue
dataFormatint64
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatdate
isNullabletrue

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

NameValue
displayNameDocument number
dataFormatstring
isNullabletrue

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.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enDocument number
entitya 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

NameValue
dataFormatint32
isNullabletrue

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

NameValue
dataFormatint32
isNullabletrue

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

NameValue
dataFormatdate
isNullabletrue

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

NameValue
dataFormatdecimal
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatint32
isNullabletrue

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

NameValue
dataFormatdecimal
isNullabletrue

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

NameValue
dataFormatdecimal
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatint32
isNullabletrue

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

NameValue
dataFormatint64
isNullabletrue

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

NameValue
dataFormatdate
isNullabletrue

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

NameValue
dataFormatint32
isNullabletrue

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

NameValue
dataFormatint32
isNullabletrue

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

NameValue
displayNameIgnore calculated sales tax
dataFormatint32
isNullabletrue

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.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enIgnore calculated sales tax
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

InclTax

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

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

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatdate
isNullabletrue

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

NameValue
dataFormatdecimal
isNullabletrue

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

NameValue
dataFormatint32
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatint32
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
displayNameUpdate
dataFormatint32
isNullabletrue

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.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enUpdate
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

PackingSlipIdForUpdate_W

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatstring

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

NameValue
dataFormatint32
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatint64
isNullabletrue

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

NameValue
displayNameRecalculation
dataFormatint32
isNullabletrue

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.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enRecalculation
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

ReleaseDateComment

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatint64
isNullabletrue

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

NameValue
dataFormatint32
isNullabletrue

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

NameValue
dataFormatint32
isNullabletrue

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

NameValue
dataFormatdate
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
displayNameCredit correction
dataFormatint32
isNullabletrue

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.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enCredit correction
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

StornoPhysical_RU

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

NameValue
displayNameCredit correction (physical)
dataFormatint32
isNullabletrue

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.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enCredit correction (physical)
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

TableRefId

First included in: WorksheetHeader/PurchParmTable (this entity)

Properties

NameValue
dataFormatstring

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatint64
isNullabletrue

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

NameValue
displayNameSales tax rounding
dataFormatdecimal
isNullabletrue

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.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enSales tax rounding
entitya 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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatdate
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatint32
isNullabletrue

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

NameValue
dataFormatdate
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatint32
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatint32
isNullabletrue

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

NameValue
dataFormatint64
isNullabletrue

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

NameValue
dataFormatstring
isNullabletrue

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

NameValue
dataFormatint32
isNullabletrue

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

NameValue
dataFormatint32
isNullabletrue

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

NameValue
dataFormatint32
isNullabletrue

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

NameValue
dataFormatdecimal
isNullabletrue

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

NameValue
dataFormatstring
isReadOnlytrue
isNullabletrue

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

NameValue
dataFormatstring
isReadOnlytrue

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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/Bank/WorksheetLine/BankLCImportLine.cdm.json/BankLCImportLineRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/Bank/Group/CashDisc.cdm.json/CashDiscRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Common/GAB/Group/LogisticsAddressCounty.cdm.json/LogisticsAddressCountyRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Common/Currency/Group/Currency.cdm.json/CurrencyRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/AccountsReceivable/Main/CustomsBillOfEntryNumberTable_IN.cdm.json/CustomsBillOfEntryNumberTable_INRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/AccountsReceivable/Main/CustomsImportInvoiceNumberTable_IN.cdm.json/CustomsImportInvoiceNumberTable_INRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Common/GAB/Main/LogisticsPostalAddress.cdm.json/LogisticsPostalAddressRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/FiscalBooksBrazil/Group/FiscalDocModel_BR.cdm.json/FiscalDocModel_BRRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/FiscalBooksBrazil/Parameter/FiscalDocumentType_BR.cdm.json/FiscalDocumentType_BRRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Common/Intrastat/Group/IntrastatPort.cdm.json/IntrastatPortRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Common/Intrastat/Group/IntrastatStatProc.cdm.json/IntrastatStatProcRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Common/Intrastat/Group/IntrastatTransactionCode.cdm.json/IntrastatTransactionCodeRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Common/Intrastat/Group/IntrastatTransportMode.cdm.json/IntrastatTransportModeRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Vendor/Main/VendTable.cdm.json/VendTableRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/System/SystemAdministration/Framework/NumberSequenceGroup.cdm.json/NumberSequenceGroupRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/APARShared/Transaction/OfficialsTrans_RU.cdm.json/OfficialsTrans_RURecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Vendor/Main/VendTable.cdm.json/VendTableRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/Bank/Group/PaymSched.cdm.json/PaymSchedRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/Bank/Group/PaymTerm.cdm.json/PaymTermRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/ProcurementAndSourcing/Transaction/PurchParmUpdate.cdm.json/PurchParmUpdateRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/ProcurementAndSourcing/WorksheetHeader/PurchTable.cdm.json/PurchTableRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/Ledger/Transaction/ReasonTableRef.cdm.json/ReasonTableRefRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Common/GAB/Main/LogisticsLocation.cdm.json/LogisticsLocationRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/Tax/Group/TaxGroupHeading.cdm.json/TaxGroupHeadingRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/Tax/Miscellaneous/TaxInformation_IN.cdm.json/TaxInformation_INRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/Tax/WorksheetLine/TaxWorkRegulation.cdm.json/TaxWorkRegulationRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Vendor/Main/VendBankAccount.cdm.json/VendBankAccountRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/AccountsPayable/Group/VendLedger.cdm.json/VendLedgerRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/ProcurementAndSourcing/Transaction/VendPackingSlipJour.cdm.json/VendPackingSlipJourRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/Bank/Group/VendPaymModeSpec.cdm.json/VendPaymModeSpecRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/Bank/Group/VendPaymModeTable.cdm.json/VendPaymModeTableRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/WorksheetHeader/WHSLoadTable.cdm.json/WHSLoadTableRecId
entitya 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

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/Ledger/Main/CompanyInfo.cdm.json/CompanyInfoRecId
entitya reference to the constant entity holding the list of entity references

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