Planned payment in WorksheetHeader(CFMPlannedPaymentTable)

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	CFMPlannedPaymentTable/(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 Planned payment	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetHeader/CFMPlannedPaymentTable
AccountNum		WorksheetHeader/CFMPlannedPaymentTable
AccountType		WorksheetHeader/CFMPlannedPaymentTable
CurrencyCode		WorksheetHeader/CFMPlannedPaymentTable
DiscDate		WorksheetHeader/CFMPlannedPaymentTable
DueDate		WorksheetHeader/CFMPlannedPaymentTable
InvoiceAccountNum		WorksheetHeader/CFMPlannedPaymentTable
PaymentAccountNum		WorksheetHeader/CFMPlannedPaymentTable
PaymentAccountType		WorksheetHeader/CFMPlannedPaymentTable
PaymentDataAreaId		WorksheetHeader/CFMPlannedPaymentTable
PaymentMode		WorksheetHeader/CFMPlannedPaymentTable
PaymentPriority		WorksheetHeader/CFMPlannedPaymentTable
Prepayment		WorksheetHeader/CFMPlannedPaymentTable
SourceDataAreaId		WorksheetHeader/CFMPlannedPaymentTable
SourceRecId		WorksheetHeader/CFMPlannedPaymentTable
SourceType		WorksheetHeader/CFMPlannedPaymentTable
Relationship_BankAccountTableRelationshipId		WorksheetHeader/CFMPlannedPaymentTable
Relationship_CFMPaymentPriorityRelationshipId		WorksheetHeader/CFMPlannedPaymentTable
Relationship_CurrencyRelationshipId		WorksheetHeader/CFMPlannedPaymentTable
Relationship_CustInvoiceAccountRelationshipId		WorksheetHeader/CFMPlannedPaymentTable
Relationship_CustInvoiceTableRelationshipId		WorksheetHeader/CFMPlannedPaymentTable
Relationship_CustPaymModeTableRelationshipId		WorksheetHeader/CFMPlannedPaymentTable
Relationship_CustTableRelationshipId		WorksheetHeader/CFMPlannedPaymentTable
Relationship_PurchTableRelationshipId		WorksheetHeader/CFMPlannedPaymentTable
Relationship_RCashTableRelationshipId		WorksheetHeader/CFMPlannedPaymentTable
Relationship_SalesTableRelationshipId		WorksheetHeader/CFMPlannedPaymentTable
Relationship_VendInvoiceAccountRelationshipId		WorksheetHeader/CFMPlannedPaymentTable
Relationship_VendPaymModeTableRelationshipId		WorksheetHeader/CFMPlannedPaymentTable
Relationship_VendTableRelationshipId		WorksheetHeader/CFMPlannedPaymentTable

RecId

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

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

AccountNum

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true

Traits

List of traits for the AccountNum attribute are listed below.

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

AccountType

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the AccountType attribute are listed below.

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

is.dataFormat.integer

CurrencyCode

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true

Traits

List of traits for the CurrencyCode attribute are listed below.

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

DiscDate

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	date
isReadOnly	true
isNullable	true

Traits

List of traits for the DiscDate attribute are listed below.

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

is.dataFormat.date

DueDate

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	date
isReadOnly	true

Traits

List of traits for the DueDate attribute are listed below.

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

InvoiceAccountNum

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true

Traits

List of traits for the InvoiceAccountNum attribute are listed below.

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

PaymentAccountNum

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

PaymentAccountType

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the PaymentAccountType attribute are listed below.

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

is.dataFormat.integer

PaymentDataAreaId

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true

Traits

List of traits for the PaymentDataAreaId attribute are listed below.

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

PaymentMode

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

PaymentPriority

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

List of traits for the PaymentPriority attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

Prepayment

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the Prepayment attribute are listed below.

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

is.dataFormat.integer

SourceDataAreaId

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true

Traits

List of traits for the SourceDataAreaId attribute are listed below.

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

SourceRecId

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true

Traits

List of traits for the SourceRecId attribute are listed below.

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

SourceType

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the SourceType attribute are listed below.

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

is.dataFormat.integer

Relationship_BankAccountTableRelationshipId

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_CFMPaymentPriorityRelationshipId

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CFMPaymentPriorityRelationshipId 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/RCashFlowManagement/Group/CFMPaymentPriority.cdm.json/CFMPaymentPriority 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/CFMPlannedPaymentTable (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_CustInvoiceAccountRelationshipId

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustInvoiceAccountRelationshipId 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/Customer/Main/CustTable.cdm.json/CustTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_CustInvoiceTableRelationshipId

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustInvoiceTableRelationshipId attribute are listed below.

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

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

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

Relationship_CustPaymModeTableRelationshipId

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_CustTableRelationshipId

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustTableRelationshipId 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/Customer/Main/CustTable.cdm.json/CustTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_PurchTableRelationshipId

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

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_RCashTableRelationshipId 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/RCash/Main/RCashTable.cdm.json/RCashTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_SalesTableRelationshipId

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SalesTableRelationshipId attribute are listed below.

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

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

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

Relationship_VendInvoiceAccountRelationshipId

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

First included in: WorksheetHeader/CFMPlannedPaymentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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