BUSINESS_UNITWO_IDWO_TASK_ID1=Labor
2=Tools
3=Material
WM_CHRG_BACK_VW(SQL View) |
Index Back |
|---|---|
Chargeback viewChargeback view used on secondary pages of WO. This view definition changed and excluded the Project ID and Activity ID join because the project id is not necessarily always populated into the WM component. |
| SELECT PROJ.BUSINESS_UNIT_WO , PROJ.WO_ID , PROJ.WO_TASK_ID , PROJ.RSRC_TYPE , PROJ.RES_LN_NBR , PROJ.BUSINESS_UNIT , PROJ.PROJECT_ID , PROJ.ACTIVITY_ID ,PROJ.BUSINESS_UNIT_GL , PROJ.DEPTID , PROJ.RESOURCE_AMOUNT , PROJ.CURRENCY_CD , PROJ.ACCOUNT , %subrec(CF12_AN_SBR, PROJ) FROM %Table(CA_ACCTG_LN_PC) PROJ , %Table(WM_WO_TSK) TASK WHERE PROJ.BUSINESS_UNIT = TASK.BUSINESS_UNIT_PC AND PROJ.BUSINESS_UNIT_WO = TASK.BUSINESS_UNIT AND PROJ.WO_ID = TASK.WO_ID AND PROJ.WO_TASK_ID = TASK.WO_TASK_ID |
| # | 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 | WO_TASK_ID |
Number(5,0) | INTEGER NOT NULL | Task Number |
| 4 | RSRC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Work Order Management Resource Types
1=Labor 2=Tools 3=Material |
| 5 | RES_LN_NBR | Number(5,0) | INTEGER NOT NULL | Resource Line No. |
| 6 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 7 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 8 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 9 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 10 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 11 | RESOURCE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
| 12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 13 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 14 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL | Operating Unit ChartField |
| 15 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL | Product ChartField |
| 16 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL | Fund Code |
| 17 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL | Class Field |
| 18 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL | Program Code ChartField |
| 19 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL | Budget Reference |
| 20 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL | Affiliate |
| 21 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL | IntraUnit Affiliate1 |
| 22 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL | Operating Unit Affiliate |
| 23 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL | Expansion chartfield 1 |
| 24 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 2 |
| 25 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 3 |