CostValuationLedgerAccount

Entity Definition

Logical Name : CostValuationLedgerAccount
Physical Name : LE_STKACT_CST

The CostValuation portion of the StockLedgerAccount figures.

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
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
CumulativeReceivedCostAmount The cumulative cost value of units received by the MerchandisingRevenueCenter since the beginning of the current ReportingPeriod. This figure is used to update the AverageWeightedUnitCost of Items during the ReportingPeriod. TC_RCV_CM Money decimal(16,5)
BeginningAverageWeightedUnitCost The weighted average cost for each retail sale unit of this item at the beginning of the current ReportingPeriod. The weighted average cost is updated each time a shipment of this item is received by the owning MerchandisingRevenueCenter. CP_UN_AV_WT_BGN MoneyShortCost decimal(16,5)
EndingAverageWeightedUnitCost The weighted average cost for each retail sale unit of this item at the current time. CP_UN_AV_WT_END MoneyShortCost decimal(16,5)

Relationships

Parent Entity Verb Phrase Child Entity
CostValuationLedgerAccount is tracked by CostValuationLedgerAccountHistory
StockLedgerAccount can be a CostValuationLedgerAccount

Logical Views containing CostValuationLedgerAccount

Logical View
Logical 02000 - Item Inventory and Stock Ledger View
Logical 03300 - Reporting - Stock Ledger View