Entity Definition

Logical Name : CustomerTradeAccount
Physical Name : LE_ACNT_CT_TRD

A type of CUSTOMER ACCOUNT established for builders, plumbers, electricians and other trade businesses that purchase merchandise, usually at a preferential discount, from the store. A CustomerTradeAccount grants credit to customers on an invoice by invoice basis with the expectation that each invoice will be paid in full. It is different from a revolving charge account which carries an aggregate credit balance from period to period.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerAccountID (FK)(PK) A unique identifier for a customer account. ID_CTAC Identity integer
DiscountMonetaryAmount The monetary amount of discount provided to a specific CUSTOMER TRADE ACCOUNT. MO_DSC_CT_TRD Money decimal(16,5)
DiscountPercent The percentage of the base retail price discount provided to a specific CUSTOMER TRADE ACCOUNT. PE_DSC_CT_TRD Percent decimal(7,4)
PaymentDueDayCount The number of days after an invoice date that the invoice must be paid. Invoices paid after their payment due date may (depending on the terms and conditions of the trade account and invoice) incur and interest charge. DI_PYM_DUE_DY_CNT QuantityDayCount decimal(3,0)
AnnualInterestRatePercent Tha annual interest rate percent charged on late invoice balances. Annual rates may be expressed in monthlly or daily rates. PE_ANN_INTRST_RT_PE Percent decimal(7,4)
EarlyPaymentDiscountDayCount The number of days after an invoice that grant the customer a discount for early payment of an invoice. For example terms 1.5% NET 20 means that if a customer pays an invoice within 20 days it can take a 1.5% discount off of its payment. DI_ERLY_PYM_DY_CNT QuantityDayCount decimal(3,0)


Parent Entity Verb Phrase Child Entity
CustomerAccount can be a CustomerTradeAccount

Logical Views containing CustomerTradeAccount

Logical View
Logical 07010 - Customer Account Information Extended