Customer free text invoice lines in WorksheetLine(CustInvoiceLine)

Article
02/22/2022

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

Traits

Traits for this entity are listed below.

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

Parameter	Value	Data type	Explanation
attribute	CustInvoiceLine/(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	Customer free text invoice lines

entity

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

Attributes

Name	Description	First Included in Instance
RecId		WorksheetLine/CustInvoiceLine
OrigCountryRegionId		WorksheetLine/CustInvoiceLine
AccountingDistributionTemplate		WorksheetLine/CustInvoiceLine
AmountCur		WorksheetLine/CustInvoiceLine
AmountDetails		WorksheetLine/CustInvoiceLine
AssetBookId		WorksheetLine/CustInvoiceLine
AssetId		WorksheetLine/CustInvoiceLine
AssetId_RU		WorksheetLine/CustInvoiceLine
BillingCode		WorksheetLine/CustInvoiceLine
CFOPTable_BR		WorksheetLine/CustInvoiceLine
CorrectedCustInvoiceLine		WorksheetLine/CustInvoiceLine
CountryName_RU		WorksheetLine/CustInvoiceLine
CreditNoteInternalRef_PL		WorksheetLine/CustInvoiceLine
CurrencyCode		WorksheetLine/CustInvoiceLine
CustBillingCode		WorksheetLine/CustInvoiceLine
CustDirective_PSN		WorksheetLine/CustInvoiceLine
CustInvoiceLineTemplate		WorksheetLine/CustInvoiceLine
DefaultDimension		WorksheetLine/CustInvoiceLine
DeliveryLocation		WorksheetLine/CustInvoiceLine
Description		WorksheetLine/CustInvoiceLine
EInvoiceAccountCode		WorksheetLine/CustInvoiceLine
InvoiceGtd_RU		WorksheetLine/CustInvoiceLine
InvoiceTxt		WorksheetLine/CustInvoiceLine
IntrastatCommodity		WorksheetLine/CustInvoiceLine
LedgerDimension		WorksheetLine/CustInvoiceLine
LineNum		WorksheetLine/CustInvoiceLine
NGPCodesTable_FR		WorksheetLine/CustInvoiceLine
OrigState		WorksheetLine/CustInvoiceLine
PackedExtensions		WorksheetLine/CustInvoiceLine
ParentRecId		WorksheetLine/CustInvoiceLine
PKWiUCode_PL		WorksheetLine/CustInvoiceLine
Port		WorksheetLine/CustInvoiceLine
ProjCategoryId		WorksheetLine/CustInvoiceLine
ProjFundingSource		WorksheetLine/CustInvoiceLine
ProjId		WorksheetLine/CustInvoiceLine
ProjTransId		WorksheetLine/CustInvoiceLine
PropertyNumber_MX		WorksheetLine/CustInvoiceLine
Quantity		WorksheetLine/CustInvoiceLine
ReasonRefRecId		WorksheetLine/CustInvoiceLine
RefReturnInvoiceTrans_W		WorksheetLine/CustInvoiceLine
SalesUnit_RU		WorksheetLine/CustInvoiceLine
ServiceInvoice_BR		WorksheetLine/CustInvoiceLine
SourceDocumentLine		WorksheetLine/CustInvoiceLine
StatProcId		WorksheetLine/CustInvoiceLine
TaxAmount		WorksheetLine/CustInvoiceLine
TaxAutogenerated		WorksheetLine/CustInvoiceLine
TaxGroup		WorksheetLine/CustInvoiceLine
TaxItemGroup		WorksheetLine/CustInvoiceLine
TaxServiceCode_BR		WorksheetLine/CustInvoiceLine
TaxWithholdGroup		WorksheetLine/CustInvoiceLine
TaxWithholdItemGroupHeading_TH		WorksheetLine/CustInvoiceLine
TaxWriteCode		WorksheetLine/CustInvoiceLine
TransactionCode		WorksheetLine/CustInvoiceLine
Transport		WorksheetLine/CustInvoiceLine
UnitPrice		WorksheetLine/CustInvoiceLine
Weight		WorksheetLine/CustInvoiceLine
OrderLineReference_NO		WorksheetLine/CustInvoiceLine
ItemCodeId		WorksheetLine/CustInvoiceLine
SATProductCode_MX		WorksheetLine/CustInvoiceLine
SATUnitCode_MX		WorksheetLine/CustInvoiceLine
Brand_MX		WorksheetLine/CustInvoiceLine
Consignment_MX		WorksheetLine/CustInvoiceLine
Samples_MX		WorksheetLine/CustInvoiceLine
SATCustomUnitOfMeasure_MX		WorksheetLine/CustInvoiceLine
SATCustomsQty_MX		WorksheetLine/CustInvoiceLine
SATTariffFraction_MX		WorksheetLine/CustInvoiceLine
CompanyLocation_IN		WorksheetLine/CustInvoiceLine
CustomerLocation_IN		WorksheetLine/CustInvoiceLine
CustomerTaxInformation_IN		WorksheetLine/CustInvoiceLine
CustomsTariffCodeTable_IN		WorksheetLine/CustInvoiceLine
ExciseRecordType_IN		WorksheetLine/CustInvoiceLine
ExciseTariffCodes_IN		WorksheetLine/CustInvoiceLine
ExciseType_IN		WorksheetLine/CustInvoiceLine
Exempt_IN		WorksheetLine/CustInvoiceLine
GTAServiceCategory_IN		WorksheetLine/CustInvoiceLine
HSNCodeTable_IN		WorksheetLine/CustInvoiceLine
ITCCategory_IN		WorksheetLine/CustInvoiceLine
SalesTaxFormTypes_IN		WorksheetLine/CustInvoiceLine
ServiceAccountingCodeTable_IN		WorksheetLine/CustInvoiceLine
ServiceCodeTable_IN		WorksheetLine/CustInvoiceLine
AssessableValue_IN		WorksheetLine/CustInvoiceLine
MaximumRetailPrice_IN		WorksheetLine/CustInvoiceLine
MaxRetailPricePerUnit_IN		WorksheetLine/CustInvoiceLine
TCSGroup_IN		WorksheetLine/CustInvoiceLine
TDSGroup_IN		WorksheetLine/CustInvoiceLine
ExternalInvoiceId		WorksheetLine/CustInvoiceLine
DataAreaId		WorksheetLine/CustInvoiceLine
Relationship_AccountingDistributionTemplateRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_AssetBookRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_AssetBookTableRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_AssetTableRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_CFOPTable_BRRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_CurrencyRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_CustBillingCodeRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_CustDirective_PSNRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_CustInvoiceLineTemplateRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_CustInvoiceTable_ParentRecIdRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_CustInvoiceTrans_WRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_DefaultDimensionRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_DeliveryLocation_FKRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_IntrastatCommodityRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_IntrastatPortRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_IntrastatStatProcRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_IntrastatTransactionCodeRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_IntrastatTransportModeRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_LedgerDimensionRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_LogisticsAddressCountryRegionRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_LogisticsAddressCountryRegion_RURelationshipId		WorksheetLine/CustInvoiceLine
Relationship_NGPCodesTable_FRRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_OrigStateRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_ProjCategoryRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_ProjFundingSourceRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_ProjTableRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_ReasonTableRefRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_SourceDocumentLineRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_TaxGroupHeadingRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_TaxItemGroupHeadingRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_TaxServiceCode_BRRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_TaxServiceTariffRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_TaxWithholdGroupHeadingRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_TaxWithholdItemGroupHeading_THRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_SATProductCode_MXRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_SATUnitCode_MXRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_SATCustomUnitOfMeasure_MXRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_SATTariffFraction_MXRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_BrandTable_MXRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_RAssetTableRelationshipId		WorksheetLine/CustInvoiceLine
Relationship_CompanyRelationshipId		WorksheetLine/CustInvoiceLine

RecId

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

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

OrigCountryRegionId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
displayName	Country/region of origin
dataFormat	string
isNullable	true

Traits

List of traits for the OrigCountryRegionId attribute are listed below.

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

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

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Country/region of origin

entity

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

is.dataFormat.character
is.dataFormat.array

AccountingDistributionTemplate

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

List of traits for the AccountingDistributionTemplate attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

AmountCur

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
displayName	Amount
dataFormat	decimal
isNullable	true

Traits

List of traits for the AmountCur attribute are listed below.

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

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

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

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Amount

entity

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

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

AmountDetails

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

AssetBookId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

AssetId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

AssetId_RU

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

BillingCode

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

CFOPTable_BR

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

CorrectedCustInvoiceLine

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

CountryName_RU

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

CreditNoteInternalRef_PL

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

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

CurrencyCode

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

CustBillingCode

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

CustDirective_PSN

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

CustInvoiceLineTemplate

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

DefaultDimension

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

List of traits for the DefaultDimension attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

DeliveryLocation

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

List of traits for the DeliveryLocation 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: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the Description attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

EInvoiceAccountCode

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the EInvoiceAccountCode attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

InvoiceGtd_RU

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

InvoiceTxt

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
displayName	Invoice text
dataFormat	string
isNullable	true

Traits

List of traits for the InvoiceTxt attribute are listed below.

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

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

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Invoice text

entity

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

is.dataFormat.character
is.dataFormat.array

IntrastatCommodity

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

LedgerDimension

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

LineNum

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

NGPCodesTable_FR

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

OrigState

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
displayName	State of origin
dataFormat	string
isNullable	true

Traits

List of traits for the OrigState attribute are listed below.

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

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

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	State of origin

entity

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

is.dataFormat.character
is.dataFormat.array

PackedExtensions

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	binary
isNullable	true

Traits

List of traits for the PackedExtensions attribute are listed below.

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

is.dataFormat.byte
is.dataFormat.array

ParentRecId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

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

PKWiUCode_PL

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the PKWiUCode_PL attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

Port

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the Port attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

ProjCategoryId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ProjFundingSource

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

ProjId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the ProjId attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

ProjTransId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

PropertyNumber_MX

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the PropertyNumber_MX attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

Quantity

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

ReasonRefRecId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

RefReturnInvoiceTrans_W

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

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

SalesUnit_RU

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
displayName	Measurement unit
dataFormat	string
isNullable	true

Traits

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

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Measurement unit

entity

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

is.dataFormat.character
is.dataFormat.array

ServiceInvoice_BR

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
displayName	Service invoice
dataFormat	int32
isNullable	true

Traits

List of traits for the ServiceInvoice_BR attribute are listed below.

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

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

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Service invoice

entity

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

is.dataFormat.integer

SourceDocumentLine

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
displayName	Source document line
dataFormat	int64
isNullable	true

Traits

List of traits for the SourceDocumentLine attribute are listed below.

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

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

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Source document line

entity

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

is.dataFormat.integer
is.dataFormat.big

StatProcId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the StatProcId attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

TaxAmount

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

TaxAutogenerated

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the TaxAutogenerated attribute are listed below.

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

is.dataFormat.integer

TaxGroup

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the TaxGroup attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

TaxItemGroup

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

TaxServiceCode_BR

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

TaxWithholdGroup

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

TaxWithholdItemGroupHeading_TH

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

TaxWriteCode

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the TaxWriteCode attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

TransactionCode

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the TransactionCode attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

Transport

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the Transport attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

UnitPrice

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

Weight

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
displayName	Total weight
dataFormat	decimal
isNullable	true

Traits

List of traits for the Weight attribute are listed below.

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

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

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

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Total weight

entity

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

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

OrderLineReference_NO

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ItemCodeId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

SATProductCode_MX

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the SATProductCode_MX attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

SATUnitCode_MX

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the SATUnitCode_MX attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

Brand_MX

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the Brand_MX attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

Consignment_MX

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the Consignment_MX attribute are listed below.

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

is.dataFormat.integer

Samples_MX

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the Samples_MX attribute are listed below.

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

is.dataFormat.integer

SATCustomUnitOfMeasure_MX

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the SATCustomUnitOfMeasure_MX attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

SATCustomsQty_MX

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

SATTariffFraction_MX

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the SATTariffFraction_MX attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

CompanyLocation_IN

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

CustomerLocation_IN

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

CustomerTaxInformation_IN

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

CustomsTariffCodeTable_IN

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

ExciseRecordType_IN

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ExciseRecordType_IN attribute are listed below.

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

is.dataFormat.integer

ExciseTariffCodes_IN

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

ExciseType_IN

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ExciseType_IN attribute are listed below.

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

is.dataFormat.integer

Exempt_IN

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the Exempt_IN attribute are listed below.

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

is.dataFormat.integer

GTAServiceCategory_IN

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the GTAServiceCategory_IN attribute are listed below.

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

is.dataFormat.integer

HSNCodeTable_IN

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

ITCCategory_IN

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ITCCategory_IN attribute are listed below.

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

is.dataFormat.integer

SalesTaxFormTypes_IN

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

ServiceAccountingCodeTable_IN

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

ServiceCodeTable_IN

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

AssessableValue_IN

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

MaximumRetailPrice_IN

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

MaxRetailPricePerUnit_IN

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

TCSGroup_IN

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the TCSGroup_IN attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

TDSGroup_IN

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the TDSGroup_IN attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

ExternalInvoiceId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the ExternalInvoiceId attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

DataAreaId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true

Traits

List of traits for the DataAreaId attribute are listed below.

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

Relationship_AccountingDistributionTemplateRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_AccountingDistributionTemplateRelationshipId attribute are listed below.

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

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_AssetBookRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_AssetBookRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/FixedAssets/Main/AssetBook.cdm.json/AssetBook	RecId

entity

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

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

Relationship_AssetBookTableRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_AssetBookTableRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/FixedAssets/Main/AssetBookTable.cdm.json/AssetBookTable	RecId

entity

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

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

Relationship_AssetTableRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_AssetTableRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/FixedAssets/Main/AssetTable.cdm.json/AssetTable	RecId

entity

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

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

Relationship_CFOPTable_BRRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CFOPTable_BRRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_CurrencyRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CurrencyRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_CustBillingCodeRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustBillingCodeRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_CustDirective_PSNRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustDirective_PSNRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_CustInvoiceLineTemplateRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustInvoiceLineTemplateRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/AccountsReceivable/WorksheetLine/CustInvoiceLineTemplate.cdm.json/CustInvoiceLineTemplate	RecId

entity

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

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

Relationship_CustInvoiceTable_ParentRecIdRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustInvoiceTable_ParentRecIdRelationshipId attribute are listed below.

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_CustInvoiceTrans_WRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustInvoiceTrans_WRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/AccountsReceivable/Transaction/CustInvoiceTrans.cdm.json/CustInvoiceTrans	RecId

entity

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

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

Relationship_DefaultDimensionRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_DefaultDimensionRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_DeliveryLocation_FKRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_DeliveryLocation_FKRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_IntrastatCommodityRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_IntrastatCommodityRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/ProductInformationManagement/Main/EcoResCategory.cdm.json/EcoResCategory	RecId

entity

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

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

Relationship_IntrastatPortRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_IntrastatPortRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_IntrastatStatProcRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_IntrastatStatProcRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_IntrastatTransactionCodeRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_IntrastatTransactionCodeRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_IntrastatTransportModeRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_IntrastatTransportModeRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_LedgerDimensionRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_LedgerDimensionRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_LogisticsAddressCountryRegionRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_LogisticsAddressCountryRegionRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_LogisticsAddressCountryRegion_RURelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_LogisticsAddressCountryRegion_RURelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_NGPCodesTable_FRRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_NGPCodesTable_FRRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/Miscellaneous/NGPCodesTable_FR.cdm.json/NGPCodesTable_FR	RecId

entity

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

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

Relationship_OrigStateRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_OrigStateRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_ProjCategoryRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ProjCategoryRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/ProfessionalServices/ProjectManagementAndAccounting/Group/ProjCategory.cdm.json/ProjCategory	RecId

entity

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

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

Relationship_ProjFundingSourceRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ProjFundingSourceRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_ProjTableRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ProjTableRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_ReasonTableRefRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ReasonTableRefRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_SourceDocumentLineRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SourceDocumentLineRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/AccountingFoundation/TransactionLine/SourceDocumentLine.cdm.json/SourceDocumentLine	RecId

entity

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

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

Relationship_TaxGroupHeadingRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TaxGroupHeadingRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_TaxItemGroupHeadingRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TaxItemGroupHeadingRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_TaxServiceCode_BRRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TaxServiceCode_BRRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_TaxServiceTariffRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TaxServiceTariffRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_TaxWithholdGroupHeadingRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TaxWithholdGroupHeadingRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_TaxWithholdItemGroupHeading_THRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TaxWithholdItemGroupHeading_THRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_SATProductCode_MXRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SATProductCode_MXRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_SATUnitCode_MXRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SATUnitCode_MXRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_SATCustomUnitOfMeasure_MXRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SATCustomUnitOfMeasure_MXRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_SATTariffFraction_MXRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SATTariffFraction_MXRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Relationship_BrandTable_MXRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_BrandTable_MXRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/APARShared/Miscellaneous/BrandTable_MX.cdm.json/BrandTable_MX	RecId

entity

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

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

Relationship_RAssetTableRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_RAssetTableRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/RAsset/Main/RAssetTable.cdm.json/RAssetTable	RecId

entity

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

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

Relationship_CompanyRelationshipId

First included in: WorksheetLine/CustInvoiceLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CompanyRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Ledger/Main/CompanyInfo.cdm.json/CompanyInfo	RecId

entity

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

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

Share via

Customer free text invoice lines in WorksheetLine(CustInvoiceLine)

Traits

Attributes

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits