Module: Work Asset Analytics
Type: Dimension
PO_LINE_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PO_LINE_ID | VARCHAR2 | 14 | True | Purchase Order Line | |||
| SOURCE_RECORD_ID | VARCHAR2 | 14 | Source Record Id | ||||
| BO_STATUS_CD | VARCHAR2 | 12 | Status | ||||
| DESCR100 | VARCHAR2 | 100 | Description | ||||
| PO_HEADER_DESCR100 | VARCHAR2 | 100 | PO Header Description | ||||
| PO_HEADER_ID | VARCHAR2 | 14 | Purchase Order Header | ||||
| PO_HEADER_STATUS_CD | VARCHAR2 | 12 | PO Header Status | ||||
| PO_LINE_UNIT_PRICE | NUMBER | 18 | 7 | ||||
| PO_NUM | VARCHAR2 | 14 | PO Number | ||||
| REQUEST_DT | DATE | 0 | Request Date | ||||
| REVISION_NUM | NUMBER | 3 | 0 | Revision Number | |||
| STOCK_ITEM_DTL_ID | VARCHAR2 | 12 | Stock Item Detail | ||||
| UOP | VARCHAR2 | 30 | Unit of Purchase | ||||
| W1_QUANTITY | NUMBER | 13 | 5 | Quantity | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |