BUSINESS_UNITWO_IDWM_CHILD_WO_VW(SQL View) |
Index Back |
|---|---|
Child Work Order ViewChild Work Order View |
| SELECT BUSINESS_UNIT , PARENT_WO_ID , DESCR254 , STATUS_CD , WO_ID , ACTL_COST_LBR , ACTL_COST_MAT , ACTL_COST_PO , ACTL_COST_TLS , (ACTL_COST_LBR + ACTL_COST_MAT + ACTL_COST_PO + ACTL_COST_TLS ) , CURRENCY_CD FROM PS_WM_WO_HDR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | WO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 3 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 4 | STATUS_CD | Character(4) | VARCHAR2(4) NOT NULL | User defined Status Code |
| 5 | CHILD_WO_ID | Character(10) | VARCHAR2(10) NOT NULL | Child Work Order ID |
| 6 | ACTL_COST_LBR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Actual Labor Cost |
| 7 | ACTL_COST_MAT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Actual Cost |
| 8 | ACTL_COST_PO | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Actual procurement costs for a work order |
| 9 | ACTL_COST_TLS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Actual Tools Cost |
| 10 | TOTAL_ACTL_COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Actual Cost |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |