StockLedgerAccount

Entity Definition

Logical Name : StockLedgerAccount
Physical Name : LE_STKACT

A reporting period based record of the beginning balance and cumulative activity for a particular MerchandiseHierarchyGroup during the current ReportingPeriod. Records both raw Item numbers as well as a Valuation amount - The valuation figures for any particular StockLedgerAccount may be either RetailValuation or CostPriceValuation as required by the needs of the retail enterprise.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
MerchandiseHierarchyGroupID (FK)(PK) Unique system assigned identifier for a group or class of merchandise. ID_MRHRC_GP Identity integer MerchandiseHierarchyGroup(CO_MRHRC_GP)
RevenueCostCenterID (FK)(PK) A unique retailer assigned identifier for an accounting budget, that owns merchandise and is used to track the financial performance of the retail enterprise. ID_CTR_RVN_CST Identity integer RevenueCostCenter(CO_CTR_RVN_CST)
StockLedgerAccountValuationType A retailer assigned code denoting which valuation method is used to value the Items owned by the MerchandisingRevenueCenter being tracked. Possible values include - Retail Valuation; Last Known Cost Valuation; Average Weighted Cost Valuation, Replacement Cost Valuation. TY_STLKG_VLN Code2 char(2)
BeginningUnitCount The number of all Items owned by the MerchandisingCenter at the beginning of the current ReportingPeriod. QU_UN_BGN QuantityTransactionCount decimal(7,0)
CumulativeGrossSalesUnitCount The cumulative unit sales for a specific ITEM since the beginning of the current ReportingPeriod, excluding any returns. QU_SLS_GS_CM QuantityTransactionCount decimal(7,0)
CumulativeReturnUnitCount The cumulative number of units returned of a specific ITEM since the beginning of the current ReportingPeriod. QU_RTN_CM QuantityTransactionCount decimal(7,0)
CumulativeReceivedUnitCount The cumulative number of units received for a particular ITEM since the beginning of the current ReportingPeriod. QU_RCV QuantityTransactionCount decimal(7,0)
CumulativeTransferInUnitCount The cumulative number of units of a specific ITEM transferred into the RETIL STORE since the beginning of the current ReportingPeriod. QU_TSF_IN_CM QuantityTransactionCount decimal(7,0)
CumulativeTransferOutUnitCount The cumulative number of units of a specific ITEM transferred out to other RETIL STOREs or other FACILITYs within the retail enterprise since the beginning of the current ReportingPeriod. QU_TSF_OT_CM QuantityTransactionCount decimal(7,0)
CumulativeReturnToVendorUnitCount The cumulative number of units of a specific ITEM returned to the vendor since the beginning of the current ReportingPeriod. QU_RTN_TO_VN QuantityTransactionCount decimal(7,0)
CumulativeAdjustmentUnitCount The cumulative adjustment made to the on hand amount of an ITEM since the start of the current ReportingPeriod. QU_UN_ADJT_CM QuantityTransactionCount decimal(7,0)
CurrentUnitCount The number of all Items owned by the MerchandisingCenter at the current time. QU_UN_CRT QuantityTransactionCount decimal(7,0)

Relationships

Parent Entity Verb Phrase Child Entity
MerchandiseHierarchyGroup is tracked via StockLedgerAccount
RevenueCostCenter defines accounting disposition of StockLedgerAccount
StockLedgerAccount is updated via StockLedgerJournalEntry
StockLedgerAccount is tracked by StockLedgerAccountHistory
StockLedgerAccount can be a RetailValuationLedgerAccount
StockLedgerAccount can be a CostValuationLedgerAccount

Logical Views containing StockLedgerAccount

Logical View
Logical 02000 - Item Inventory and Stock Ledger View
Logical 02010 - Item Inventory - Adjustments View
Logical 02130 - Item Inventory - Receiving View
Logical 02600 - Inventory Control Transaction View
Logical 03300 - Reporting - Stock Ledger View
Logical 04100 - Financial Ledger - Retail Transaction View
Logical 04300 - Financial Ledger - Inventory Control View