ZenotiHelp

Inventory Fact Table

ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide

Stores inventory transaction detail including purchase orders, stock actions (received, transferred, consumed, adjusted), costs (COGS, FIFO, perpetual average), and cumulative stock levels.

Columns

Column Name Data Type Nullable Description
factinventorywid BIGINT IDENTITY No Surrogate primary key (auto-generated)
FactInventoryPk BIGINT Yes Source primary key of the inventory fact
centerwid BIGINT Yes Foreign key to the center dimension
POID VARCHAR(36) Yes GUID of the purchase order
OrgPOnumber BIGINT Yes Organization-level purchase order number
PONumber BIGINT Yes Purchase order number
ActionType VARCHAR(1600) Yes Type of inventory action (e.g., Received, Transferred, Consumed)
ActionDate TIMESTAMP Yes Date and time of the inventory action
OrderRaisedDate TIMESTAMP Yes Date when the purchase order was raised
IntransitDate TIMESTAMP Yes Date when the inventory was in transit
ItemdeliveredDt TIMESTAMP Yes Date when the item was delivered
TransferCenterWID BIGINT Yes Foreign key to the center involved in the transfer
OrderType VARCHAR(800) Yes Type of order
vendorwid BIGINT Yes Foreign key to the vendor dimension
Productwid BIGINT Yes Foreign key to the product dimension
VolumeTypename VARCHAR(1200) Yes Name of the volume type
Volumeperitem FLOAT Yes Volume per item unit
ProductType VARCHAR(1200) Yes Type of product
OrderedQuantity INT Yes Quantity originally ordered
ActionQuantity FLOAT Yes Quantity affected by this action
DeliveredPricePU FLOAT Yes Delivered price per unit (excluding tax)
ItemTax FLOAT Yes Tax on the item
ItemDiscount FLOAT Yes Discount on the item
ItemShippingCost FLOAT Yes Shipping cost for the item
COGS FLOAT Yes Cost of goods sold (excluding tax)
COGSWithTax FLOAT Yes Cost of goods sold (including tax)
FIFOCost FLOAT Yes FIFO cost of the inventory
InventoryActionid VARCHAR(36) Yes GUID of the inventory action
FIFOStock FLOAT Yes Current FIFO stock level
CumulativeStock FLOAT Yes Cumulative stock after this action
PerpetualAvgWithTax FLOAT Yes Perpetual average cost including tax
PerpetualAvg FLOAT Yes Perpetual average cost excluding tax
CumulativeCost FLOAT Yes Cumulative cost of inventory
InventoryRecordType INT Yes Type of inventory record (enumerator)
BundleVersionId VARCHAR(36) Yes GUID of the bundle version
FIFOCostWithTax FLOAT Yes FIFO cost including tax
CumulativeCostWithTax FLOAT Yes Cumulative cost including tax
DeliveredPricePUWithTax FLOAT Yes Delivered price per unit including tax
ItemDeliveryOther FLOAT Yes Other delivery-related costs
RefundInvoiceItemid VARCHAR(36) Yes GUID of the refund invoice item
PodId INT Yes Pod identifier for multi-tenant partitioning
Void INT Yes Indicates if the record is voided
invoicenum VARCHAR(2048) Yes Related invoice number(s)
actionorgponumber BIGINT Yes Organization PO number for the action
pocreationdate TIMESTAMP Yes Purchase order creation date
postatus VARCHAR(100) Yes Purchase order status
reconciliationdate TIMESTAMP Yes Date when inventory was reconciled
isopenbalanceentry BOOLEAN Yes Flag indicating if this is an open balance entry
actionvendorwid BIGINT Yes Foreign key to the vendor for the action
batchwid BIGINT Yes Foreign key to the batch dimension
batchtransactionid VARCHAR(36) YES Batch transaction identifier
cumulativebatchstock FLOAT YES Cumulative batch stock

Note: All fact tables also include standard ETL metadata columns (podname, organizationid, groupid, etlCreatedDate) which are omitted from this reference for brevity.

Primary Key

factinventorywid

Foreign Keys

Column References
centerwid Bi_DimCenter.centerwid
TransferCenterWID Bi_DimCenter.centerwid

Enumerator Values

Column Values
InventoryRecordType 1 = PO
2 = Retail Sale
3 = Consumption
4 = Audit
5 = Checkout
6 = Bundle
7 = Conversion
8 = Same-center Refund
9 = PO Return
10 = Cross-center Refund
11 = Audit Adjustment
12 = Manual Adjustment
Void 0 = active; non-zero = voided/soft-deleted.
isopenbalanceentry TRUE = Open balance entry; FALSE = Regular entry.
Was this article helpful?
Your feedback helps us improve our documentation.