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.