||Foreign Key Table
||A unique identifier for a customer account.
||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
It is up to each retailer to design its ledger categories for reporting and analyizing its business.
||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.
||The current period beginning monetary balance derived from closing balance of prior period.
||The cumulative value posted for the current period. This is the sum of journal entries posted to the current reporting period.
||The date a CustomerAccountLedger instance is created.
||The date a CustomerAccountLedger instance was last updated
||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.
||The cumulative quantity value posted for the current period. This is the sum of journal entries posted to the current reporting period.
||The current period beginning quantity balance derived from closing balance of prior period.