CONTRACT_NUMCONTRACT_PPD_SEQCA_PPD_USE_VW(SQL View) |
Index Back |
|---|---|
Contract Prepaid Balance Usage |
| SELECT DTL_PROJ.CONTRACT_NUM , PROJ.CONTRACT_PPD_SEQ , PROJ.TRANS_DT , PROJ.DESCR , PROJ.ANALYSIS_TYPE , PROJ.INVOICE , PROJ.CONTRACT_LINE_NUM , PROJ.PROJECT_ID , PROJ.ACTIVITY_ID , PROJ.RESOURCE_TYPE , PROJ.RESOURCE_CATEGORY , PROJ.RESOURCE_SUB_CAT , PROJ.PROJ_TRANS_TYPE , %Round (%DecMult(%decmult(PROJ.FOREIGN_AMOUNT,AGM.SIGNED_VALUE), -1) ,3) , PROJ.FOREIGN_CURRENCY FROM PS_PROJ_RESOURCE PROJ , PS_PROJ_AN_GRP_MAP AGM , PS_SET_CNTRL_GROUP GRP , PS_CA_DETAIL_PROJ DTL_PROJ WHERE DTL_PROJ.BUSINESS_UNIT_PC = PROJ.BUSINESS_UNIT AND DTL_PROJ.PROJECT_ID = PROJ.PROJECT_ID AND DTL_PROJ.ACTIVITY_ID = PROJ.ACTIVITY_ID AND PROJ.ANALYSIS_TYPE IN ('UTL', 'UAJ') AND AGM.ANALYSIS_GROUP = 'PSBLD' AND DTL_PROJ.BUSINESS_UNIT_PC = GRP.SETCNTRLVALUE AND GRP.REC_GROUP_ID = 'PC_01' AND GRP.SETID = AGM.SETID AND AGM.ANALYSIS_TYPE = PROJ.ANALYSIS_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 2 | CONTRACT_PPD_SEQ |
Number(5,0) | INTEGER NOT NULL | Prepaid Add Sequence |
| 3 | TRANS_DT | Date(10) | DATE | Transaction Date |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 6 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 7 | CONTRACT_LINE_NUM | Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 8 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 9 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 10 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 11 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
| 12 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
| 13 | PROJ_TRANS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Project Transaction Type |
| 14 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |