Module: Work Asset Analytics
Type: Dimension
PI_CNT_LINE_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PI_CNT_LINE_ID | VARCHAR2 | 14 | True | Physical Inventory Count Line | |||
| SOURCE_RECORD_ID | VARCHAR2 | 14 | Source Record Id | ||||
| ADJUSTED_SYSTEM_COUNT | NUMBER | 13 | 5 | Adjusted System Count | |||
| FIRST_COUNT | NUMBER | 13 | 5 | First Count | |||
| PI_CNT_LINE_STATUS_CD | VARCHAR2 | 12 | Physical Inventory Count Line Status | ||||
| RECOUNT | NUMBER | 13 | 5 | Recount | |||
| RECOUNT_INDICATOR_FLG | VARCHAR2 | 38 | Recount Indicator | ||||
| SYSTEM_COUNT | NUMBER | 13 | 5 | System Count | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |