Entity Definition

Logical Name : CustomerOrderPaymentLineItem
Physical Name : DO_CTOLTM_PYM

A line item component of a Customer placed order, recording any deposit payment that is made during the life cycle of the Order. The actual payment will be recorded as a PaymentOnAccount line item in a RetailTransaction, and will be accrued in a CustomerAccount, until the ordered merchandise is shipped or picked up.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerOrderID (FK)(PK) A unique system assigned identifier for the CustomerOrder. ID_ORD Identity integer
CustomerOrderLineItemSequenceNumber (FK)(PK) A unique system assigned identifier for the LineItem within the confines of the CustomerOrder. IC_OR_LTM LineNumber smallint
TransactionID (FK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) PaymentOnAccountLineItem(TR_LTM_PYAN)
RetailTransactionLineItemSequenceNumber (FK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint PaymentOnAccountLineItem(TR_LTM_PYAN)


Parent Entity Verb Phrase Child Entity
PaymentOnAccountLineItem is received in CustomerOrderPaymentLineItem
CustomerOrderLineItem can be a CustomerOrderPaymentLineItem

Logical Views containing CustomerOrderPaymentLineItem

Logical View
Logical 02315 - Retail Transaction - Customer Order
Logical 02316 - Distributed Order Management View
Logical 07600 - Customer Order - Macro View
Logical 07610 - Customer Order - Maintenance View
Logical 10400 - Enterprise - Channels