Entity Definition

Logical Name : FulfillmentAcknowledgementLineItem
Physical Name : TR_LTM_FLF_ACK

A component of a FulfillmentAcknowledgmentTransaction, recording the fact that the Customer has received a particular StockItem that was to be delivered or picked up,

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
InventoryControl (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. INV_CTL IdentityUUID char(32) FulfillmentAcknowledgmentTransaction(TR_FLF_ACK)
FulfillmentAcknowledgementLineItemSequenceNumber (PK) The sequence number of line item within the context of this FulfillmentAcknowledgmentTransaction. IC_LTM_FLF_ACK LineNumber smallint
LocationID (FK) A unique system assigned identifier for the Location. ID_LCN Identity integer InventoryLocation(LO_LCN_INV)
ItemID (FK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) Item(AS_ITM)
FulfillmentAcknowledgementLineItemQuantity The number of Items that are being fulfilled. QU_FLF Quantity DECIMAL(9,3)


Parent Entity Verb Phrase Child Entity
FulfillmentAcknowledgmentTransaction contains FulfillmentAcknowledgementLineItem
Item is dispatched via FulfillmentAcknowledgementLineItem
InventoryLocation acts on FulfillmentAcknowledgementLineItem
FulfillmentAcknowledgementLineItem is posted to ItemInventoryJournalEntry
FulfillmentAcknowledgementLineItem is dispatched because of SaleReturnLineItem

Logical Views containing FulfillmentAcknowledgementLineItem

Logical View
Logical 02000 - Item Inventory and Stock Ledger View
Logical 02020 - Item Inventory - Selling View
Logical 02200 - Transaction Macro View
Logical 02309 - Retail Transaction Delivery
Logical 02316 - Distributed Order Management View
Logical 02600 - Inventory Control Transaction View
Logical 21000 - Fresh Item Management Macro View