Journal load details in WorksheetLine(WHSJourLoadLine)

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	WHSJourLoadLine/(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 Journal load details	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetLine/WHSJourLoadLine
CustJourType		WorksheetLine/WHSJourLoadLine
InventDimId		WorksheetLine/WHSJourLoadLine
InventQty		WorksheetLine/WHSJourLoadLine
InventTransId		WorksheetLine/WHSJourLoadLine
InventTransType		WorksheetLine/WHSJourLoadLine
ItemId		WorksheetLine/WHSJourLoadLine
LoadClosedUTCDateTime		WorksheetLine/WHSJourLoadLine
LoadDirection		WorksheetLine/WHSJourLoadLine
LoadId		WorksheetLine/WHSJourLoadLine
LoadInProcessUTCDateTime		WorksheetLine/WHSJourLoadLine
LoadOpenUTCDateTime		WorksheetLine/WHSJourLoadLine
LoadReadyToShipUTCDateTime		WorksheetLine/WHSJourLoadLine
OrderNum		WorksheetLine/WHSJourLoadLine
OverDeliveryPct		WorksheetLine/WHSJourLoadLine
PackingQty		WorksheetLine/WHSJourLoadLine
ParmId		WorksheetLine/WHSJourLoadLine
Qty		WorksheetLine/WHSJourLoadLine
QtyLeftToStructure		WorksheetLine/WHSJourLoadLine
RefId		WorksheetLine/WHSJourLoadLine
RefRecId		WorksheetLine/WHSJourLoadLine
ReleaseToWarehouseId		WorksheetLine/WHSJourLoadLine
ShipmentId		WorksheetLine/WHSJourLoadLine
UnderDeliveryPct		WorksheetLine/WHSJourLoadLine
UOM		WorksheetLine/WHSJourLoadLine
WorkCreatedQty		WorksheetLine/WHSJourLoadLine
DataAreaId		WorksheetLine/WHSJourLoadLine
Relationship_CustConfirmTransRelationshipId		WorksheetLine/WHSJourLoadLine
Relationship_CustInvoiceTransRelationshipId		WorksheetLine/WHSJourLoadLine
Relationship_InventDimRelationshipId		WorksheetLine/WHSJourLoadLine
Relationship_InventTableRelationshipId		WorksheetLine/WHSJourLoadLine
Relationship_InventTransOriginRelationshipId		WorksheetLine/WHSJourLoadLine
Relationship_WHSInventTableRelationshipId		WorksheetLine/WHSJourLoadLine
Relationship_WHSJourLoadTableRelationshipId		WorksheetLine/WHSJourLoadLine
Relationship_WHSLoadLineRelationshipId		WorksheetLine/WHSJourLoadLine
Relationship_WHSLoadTableRelationshipId		WorksheetLine/WHSJourLoadLine
Relationship_WHSShipmentTableRelationshipId		WorksheetLine/WHSJourLoadLine
Relationship_CompanyRelationshipId		WorksheetLine/WHSJourLoadLine

RecId

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

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

CustJourType

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the CustJourType attribute are listed below.

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

is.dataFormat.integer

InventDimId

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

InventQty

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

InventTransId

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true

Traits

List of traits for the InventTransId attribute are listed below.

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

InventTransType

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the InventTransType attribute are listed below.

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

is.dataFormat.integer

ItemId

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the ItemId attribute are listed below.

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

LoadClosedUTCDateTime

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the LoadClosedUTCDateTime attribute are listed below.

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

is.dataFormat.date

LoadDirection

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the LoadDirection attribute are listed below.

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

is.dataFormat.integer

LoadId

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

LoadInProcessUTCDateTime

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the LoadInProcessUTCDateTime attribute are listed below.

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

is.dataFormat.date

LoadOpenUTCDateTime

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the LoadOpenUTCDateTime attribute are listed below.

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

is.dataFormat.date

LoadReadyToShipUTCDateTime

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the LoadReadyToShipUTCDateTime attribute are listed below.

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

is.dataFormat.date

OrderNum

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

OverDeliveryPct

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

PackingQty

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

ParmId

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true

Traits

List of traits for the ParmId attribute are listed below.

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

Qty

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	decimal

Traits

List of traits for the Qty attribute are listed below.

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

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

QtyLeftToStructure

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

RefId

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true

Traits

List of traits for the RefId attribute are listed below.

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

RefRecId

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true

Traits

List of traits for the RefRecId attribute are listed below.

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

ReleaseToWarehouseId

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ShipmentId

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

UnderDeliveryPct

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

UOM

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the UOM attribute are listed below.

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

WorkCreatedQty

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the WorkCreatedQty attribute are listed below.

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

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

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

DataAreaId

First included in: WorksheetLine/WHSJourLoadLine (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_CustConfirmTransRelationshipId

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustConfirmTransRelationshipId attribute are listed below.

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

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

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

Relationship_CustInvoiceTransRelationshipId

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustInvoiceTransRelationshipId 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/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_InventDimRelationshipId

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InventDimRelationshipId attribute are listed below.

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

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

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

Relationship_InventTableRelationshipId

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_InventTransOriginRelationshipId

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InventTransOriginRelationshipId attribute are listed below.

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

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

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

Relationship_WHSInventTableRelationshipId

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_WHSInventTableRelationshipId attribute are listed below.

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

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

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

Relationship_WHSJourLoadTableRelationshipId

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_WHSJourLoadTableRelationshipId attribute are listed below.

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

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

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

Relationship_WHSLoadLineRelationshipId

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_WHSLoadLineRelationshipId attribute are listed below.

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

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

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

Relationship_WHSLoadTableRelationshipId

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_WHSLoadTableRelationshipId attribute are listed below.

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

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

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

Relationship_WHSShipmentTableRelationshipId

First included in: WorksheetLine/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_WHSShipmentTableRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/SupplyChain/Inventory/WorksheetHeader/WHSShipmentTable.cdm.json/WHSShipmentTable 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/WHSJourLoadLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CompanyRelationshipId attribute are listed below.

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

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

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