DW_NS_INVENTORY_QUANTITY_CHANGE_F
This fact table contains the daily net quantity change for an item at specific location.
Details
Module:
Key Columns
trandate, inventoryidentifier
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| inventoryidentifier | VARCHAR2 | 64 | True | Inventory identifier is combination of item~location. | |||
| trandate | TIMESTAMP | True | Posting or occurring date of this transaction. | ||||
| SOURCE_RECORD_ID | VARCHAR2 | 999 | This column is for Oracle Internal use only. Composite key that consists of all PK values of the transaction. This consists combination of columns that defines the granularity of the table and identifies a row uniquely. | ||||
| item | NUMBER | 38 | 0 | Identifier of the item. | DW_NS_item_D | id | |
| inventorylocation | NUMBER | 38 | 0 | Location that allows fulfillment. | DW_NS_location_D | id | |
| subsidiary | NUMBER | 38 | 0 | Subsidiary identifier associated with this transaction. | DW_NS_subsidiary_D | id | |
| quantity | NUMBER | Number or unit count of items used in the transaction. |