DW_NS_INVENTORY_SNAPSHOT_F
This fact contains daily end of the day on-hand inventory quantity information for a item at specific location.
Details
Module:
Key Columns
SNAPSHOT_DATE, ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ID | VARCHAR2 | 256 | True | Transaction Identifier. | |||
| SNAPSHOT_DATE | DATE | True | Specific date on which values of attributes and metrics of this snapshot is based. | ||||
| 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 | |
| location | NUMBER | 38 | 0 | Location Identifier. | DW_NS_location_D | id | |
| subsidiary | NUMBER | 38 | 0 | Subsidiary identifier associated with this transaction. | |||
| quantityonhand | NUMBER | Item quantity on hand. | |||||
| onhandvalue | NUMBER | Inventory on hand value. | |||||
| currency | NUMBER | 38 | 0 | Transaction currency identifier. | DW_NS_currency_D | id |