INTFC_IDINTFC_LINE_NUMINTF_SRC_CST_VW(SQL View) |
Index Back |
|---|
| SELECT A.INTFC_ID ,A.INTFC_LINE_NUM ,B.BUSINESS_UNIT ,B.ASSET_ID ,SUM(B.AMOUNT) FROM PS_INTFC_ROOT_MAP A , PS_INTFC_PHY_A B WHERE A.ORIG_INTFC_ID = B.INTFC_ID AND A.ORIG_LINE_NUM = B.INTFC_LINE_NUM GROUP BY A.INTFC_ID,A.INTFC_LINE_NUM,B.BUSINESS_UNIT,B.ASSET_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INTFC_ID |
Number(8,0) | INTEGER NOT NULL | Interface ID |
| 2 | INTFC_LINE_NUM |
Number(8,0) | INTEGER NOT NULL | Interface Line Number |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 5 | COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Cost |