Entity Definition

Logical Name : CustomerAccountLedger
Physical Name : LE_CT_ACNT_LDG

A current reporting period summary of CustomerAccount transaction activity that, depending on its ReportingClassification may represent money, points, miles or any other retailer designated accounting units.

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 CustomerAccount(LE_CTAC)
ReportingClassificationCode (FK)(PK) A code used to classify the monetary values, unit counts and quantities that are accumulated in the CustomerAccountLedger and CustomerAccountJournal. The range of values varies depending on the CustomerAccountType and varieites of financial, non-finanicl unit counts and other quantities tracked by a retailer. Some samples include SALES $'s and units RETURN $;s and units TRANSACTION_COUNTs etc. It is up to each retailer to design its ledger categories for reporting and analyizing its business. CD_RP_CLSFN Code varchar(20) CustomerLedgerReportingClassification(CO_CT_LDG_RP_CLSFN)
CustomerAccountTypeCode (FK)(PK) Determines what kind of customer account this is. Examples include a trade account, a school account, a not-for-profit, regular customer, etc. LOYALTY - customer loyalty account for tracking points earned/redeemed REBATE -Customer reward account that pays customers based on cumulative net purchases over a deisgnated period of time TRADE - customer business credit account CONSUMER_CHG - customer individual consumer credit extended by retailer INSTALLMENT - credit account set up for one time purchase LAYAWAY - cash time payment account (not credit) RENTAL - customer rental for videos, equipment WORKORDER - account for handling services like installation and set up BACKORDER - account for handling backorder deposit and adjustments. TY_CTAC Code varchar(20) CustomerLedgerReportingClassification(CO_CT_LDG_RP_CLSFN)
BeginningMonetaryBalanceAmount The current period beginning monetary balance derived from closing balance of prior period. MO_BGNNNG_MNTY_BLNC_AMT Money decimal(16,5)
CurrentPeriodCumulativeMonetaryAmount The cumulative value posted for the current period. This is the sum of journal entries posted to the current reporting period. MO_CRT_PRD_CUM_MNTY_AMT Money decimal(16,5)
CreateDate The date a CustomerAccountLedger instance is created. DT_CRT AuditDateTime datetime
LastUpdateDate The date a CustomerAccountLedger instance was last updated DT_LS_UPDT AuditDateTime datetime
StatusCode Designates the current state of the CustomerAccountLedger. Valid values are OPEN or CLOSED. OPEN refers to a current period that is activly being updated with summary information. CLOSED refers to an inactive period that is to be transferred to CustomerAccountLedgerHistory. Period as used here refers to the ReportingPeriod used for reporting and analytic purposes. CD_STS Code2Status char(2)
CurrentPeriodCumulativeQuantity The cumulative quantity value posted for the current period. This is the sum of journal entries posted to the current reporting period. QU_CRT_PRD_CUM_QTY Quantity DECIMAL(9,3)
BeginningQuantity The current period beginning quantity balance derived from closing balance of prior period. QU_BGNNNG_QTY Quantity DECIMAL(9,3)


Parent Entity Verb Phrase Child Entity
CustomerAccount activity summarized through CustomerAccountLedger
CustomerLedgerReportingClassification classifies measures for CustomerAccountLedger
CustomerAccountLedger identifies summarization account for CustomerAccountJournal
CustomerAccountLedger records history for CustomerAccountLedgerHistory

Logical Views containing CustomerAccountLedger

Logical View
Logical 07010 - Customer Account Information Extended
Logical 07040 - Customer Segment Dependent Behavior