WM_CAP_INFO_VW(SQL View) |
Index Back |
---|---|
Capitalization Information VWThis view is used by Cost Capitalization Secondary page. |
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_AM , PROJ.ASSET_ID , PROJ.PROFILE_ID , PROJ.COST_TYPE , PROJ.BOOK , PROJ.CURRENCY_CD , PROJ.RESOURCE_AMOUNT , PROJ.FOREIGN_CURRENCY , PROJ.FOREIGN_AMOUNT FROM PS_PROJ_RESOURCE PROJ , PS_WM_WO_TSK TASK WHERE PROJ.BUSINESS_UNIT = TASK.BUSINESS_UNIT_PC AND PROJ.PROJECT_ID = TASK.PROJECT_ID AND PROJ.ACTIVITY_ID = TASK.ACTIVITY_ID AND PROJ.BUSINESS_UNIT_WO = TASK.BUSINESS_UNIT AND PROJ.WO_ID = TASK.WO_ID AND PROJ.WO_TASK_ID = TASK.WO_TASK_ID AND PROJ.ASSET_ID = TASK.ASSET_ID AND PROJ.AM_DISTRIB_STATUS = 'D' |
# | 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_AM | Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
10 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
11 | PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | Asset Profile ID |
12 | COST_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Cost Type |
13 | BOOK | Character(10) | VARCHAR2(10) NOT NULL | Asset Book Name |
14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
15 | RESOURCE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
16 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
17 | FOREIGN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item. |