Entity Definition

Logical Name : PaymentOnAccountLineItem
Physical Name : TR_LTM_PYAN

A detail line item recording a payment for a product or service purchased on an installment account basis. These line items are different from those charged to a house account. In this case the account normally has to be completely paid off within a specific time period. The account exists only until the installment sale is completely extinguished.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint
CustomerAccountID (FK) A unique identifier for a customer account. ID_CTAC Identity integer CustomerAccount(LE_CTAC)
CustomerAccountCardID (FK) A 16 digit Credit or Debit card PAN as defined by ISO-7812, uniquely identifying CustomerAccountCard. AI_ACNT_CT_CRD CreditDebitCardPAN varchar(20) CustomerAccountCard(LE_ACNT_CT_CRD)
AmountReceived The monetary payment on account received from the Customer MO_PYM_AGT_RCV Money decimal(16,5)
CustomerAccountInvoiceID (FK) A unique system assigned identifier for the CustomerAccountInvoice ID_INVC_CTAC Identity integer CustomerAccountInvoice(DO_INVC_CTAC)
BalanceDue The monetary amount due on the CustomerAccount after the payment is processed - as calculated by the POS Application and printed on the transaction receipt. This is a transaction snapshot of the balance plus accured interest in CustomerAccount which is the on-going balance. MO_BLNC MoneyShortRetail decimal(7,2)
RefundFlag A boolean flag that is set to YES means this PaymentOnAccountLineItem represents a REFUND which reduces the accounts receivable balance of a customer. See POSLOG6 PaymentOnAccountBase complex type @Refund FL_RFD Code4 char(4)
PaymentOnAccountTypeCode Designates the type of payment and target account it is intended to debit or credit (depending on the transaction context). Valid values are: REVOLVING_CHG_PAYMENT LAYAWAY_PAYMENT INSTALLMENT_PAYMENT CD_PYM_ON_ACNT_TYP Code varchar(20)


Parent Entity Verb Phrase Child Entity
CustomerAccountInvoice is paid via PaymentOnAccountLineItem
CustomerAccountCard is credited with PaymentOnAccountLineItem
CustomerAccount is credited with PaymentOnAccountLineItem
PaymentOnAccountLineItem is received in CustomerOrderPaymentLineItem
RetailTransactionLineItem can be a PaymentOnAccountLineItem

Logical Views containing PaymentOnAccountLineItem

Logical View
Logical 02300 - Retail Transaction - Macro View
Logical 02315 - Retail Transaction - Customer Order
Logical 02316 - Distributed Order Management View
Logical 04100 - Financial Ledger - Retail Transaction View
Logical 07200 - Customer Purchase Transaction History View