Module: Work Asset Analytics
Type: Dimension
STOCK_ITEM_DTL_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| STOCK_ITEM_DTL_ID | VARCHAR2 | 12 | True | Stock Item Detail | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| ABC_CLASS_FLG | VARCHAR2 | 4 | ABC Class | ||||
| ACCOUNT_SEGMENT | VARCHAR2 | 254 | Account Segment | ||||
| ALLOW_USER_CHG_FLG | VARCHAR2 | 4 | Allow User Charge | ||||
| AUTO_REORDER_FLG | VARCHAR2 | 4 | Auto Reorder | ||||
| BIN | VARCHAR2 | 100 | Bin | ||||
| BIN_SEQNO | NUMBER | 5 | 0 | Bin Sequence | |||
| BIN_TYPE_FLG | VARCHAR2 | 4 | Bin Type | ||||
| BO_STATUS_CD | VARCHAR2 | 12 | Status | ||||
| BUDGET_AMT | NUMBER | 17 | 3 | Budget Amount | |||
| CAPITAL_ACCOUNT_FLG | VARCHAR2 | 4 | Capital Account | ||||
| COPY_TO_PO_FLG | VARCHAR2 | 4 | Copy to PO | ||||
| CURRENCY_CD | VARCHAR2 | 3 | Currency Code | ||||
| DIVISION | VARCHAR2 | 40 | Vendor Division | ||||
| INVENTORY_COST_CENTER_CD | VARCHAR2 | 30 | Inventory Cost Center | ||||
| LEAD_TIME_IN_DAYS | NUMBER | 5 | 0 | Lead Time | |||
| MANUFACTURER_PART_NO | VARCHAR2 | 60 | Manufacturer Part Number | ||||
| MASTER_STOCK_ITEM_DTL_ID | VARCHAR2 | 12 | Master Stock Item Detail Id | ||||
| MAX_QTY | NUMBER | 13 | 5 | Maximum Quantity | |||
| MIN_QTY | NUMBER | 13 | 5 | Minimum Quantity | |||
| PI_RATIO | NUMBER | 8 | 0 | Purchase to Issue Ratio | |||
| REORDER_POINT | NUMBER | 13 | 5 | Reorder Point | |||
| REORDER_QTY | NUMBER | 13 | 5 | Reorder Quantity | |||
| SAFETY_STOCK_QTY | NUMBER | 13 | 5 | Safety Stock Quantity | |||
| SID_BUYER_CD | VARCHAR2 | 30 | SID Buyer | ||||
| SID_CLASS_FLG | VARCHAR2 | 4 | Stock Item Detail Class | ||||
| STOCK_ITEM_DTL_STATUS_CD | VARCHAR2 | 12 | Stock Item Detail Status | ||||
| TAX_RATE_SCHED_CD | VARCHAR2 | 30 | Tax Rate Schedule | ||||
| UOI | VARCHAR2 | 30 | Unit of Issue | ||||
| UOP | VARCHAR2 | 30 | Unit of Purchase | ||||
| VENDOR_ADDRESS1 | VARCHAR2 | 254 | Vendor Address | ||||
| VENDOR_CD | VARCHAR2 | 30 | Vendor | ||||
| VENDOR_CITY | VARCHAR2 | 90 | Vendor City | ||||
| VENDOR_COUNTRY | VARCHAR2 | 3 | Vendor Country | ||||
| VENDOR_LOC_ID | VARCHAR2 | 12 | Vendor Location | ||||
| VENDOR_LOC_NAME | VARCHAR2 | 254 | Vendor Location Name | ||||
| VENDOR_LOC_STATUS_CD | VARCHAR2 | 12 | Vendor Location Status | ||||
| VENDOR_NAME | VARCHAR2 | 254 | Vendor Name | ||||
| VENDOR_PART_NO | VARCHAR2 | 60 | Vendor Part Number | ||||
| VENDOR_POSTAL | VARCHAR2 | 12 | Vendor Postal | ||||
| VENDOR_PRI_FLG | VARCHAR2 | 4 | Vendor Priority | ||||
| VENDOR_STATE | VARCHAR2 | 6 | Vendor State | ||||
| VENDOR_W1_SUBURB | VARCHAR2 | 64 | Vendor Suburb | ||||
| W1_CROSS_STREET | VARCHAR2 | 64 | Cross Street | ||||
| W1_MANUFACTURER_CD | VARCHAR2 | 30 | Manufacturer | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |