CONTRACT_NUMCONTRACT_LINE_NUMACCT_PLAN_IDEVENT_NUMCA_AP_DFEVT_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.CONTRACT_NUM , B.CONTRACT_LINE_NUM , B.ACCT_PLAN_ID , E.EVENT_NUM , E.AMOUNT , B.GROSS_AMT , B.CURRENCY_CD FROM PS_CA_CONTR_HDR A , PS_CA_DETAIL B , PS_CA_ACCTPLAN D , PS_CA_AP_EVENT E WHERE A.CONTRACT_NUM = B.CONTRACT_NUM AND B.CONTRACT_NUM = D.CONTRACT_NUM AND D.CONTRACT_NUM = E.CONTRACT_NUM AND D.ACCT_PLAN_ID = E.ACCT_PLAN_ID AND B.ACCT_PLAN_ID = D.ACCT_PLAN_ID AND (E.AP_EVENT_STATUS = 'RDY' OR E.AP_EVENT_STATUS = 'NEW') AND B.BOOK_CA_TO_DFR = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 2 | CONTRACT_LINE_NUM |
Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 3 | ACCT_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Revenue Recognition Plan |
| 4 | EVENT_NUM |
Number(3,0) | SMALLINT NOT NULL | Event Number |
| 5 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 6 | GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Invoice Amount |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |