CONTRACT_NUMPrompt Table: CA_CONTR_HDR
CONTRACT_LINE_NUMCA_RECON_FF_DVW(SQL View) |
Index Back |
|---|---|
Compare Fixed Bill/RevContracts Compare Fixed amount Billing v/s Revenue. Deferred Revenue View. |
| SELECT ACTG.CONTRACT_NUM , ACTG.CONTRACT_LINE_NUM , ACTG.ACCT_PLAN_ID , ACTG.DST_USE , SUM(ACTG.AMOUNT) FROM PS_CA_ACCTG_LINE ACTG , PS_CA_CONTR_HDR HDR , PS_CA_DETAIL DET WHERE ACTG.CONTRACT_NUM = HDR.CONTRACT_NUM AND HDR.CONTRACT_NUM = DET.CONTRACT_NUM AND DET.CONTRACT_LINE_NUM = ACTG.CONTRACT_LINE_NUM AND DET.ACCT_PLAN_ID = ACTG.ACCT_PLAN_ID AND HDR.CA_PROC_STATUS = 'A' AND ACTG.DST_USE='DRV' AND EVENT_NUM<>0 AND DET.BOOK_CA_TO_DFR='Y' GROUP BY ACTG.CONTRACT_NUM, ACTG.CONTRACT_LINE_NUM, ACTG.ACCT_PLAN_ID,ACTG.DST_USE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_CONTR_HDR |
| 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 | DST_USE | Character(3) | VARCHAR2(3) NOT NULL | Added the following inactive translates for Contracts 8.4: AP Accounts Payable Liability AS Fixed Asset CA Contra Asset CG Cost of Goods Sold CL Contra Liability EX Expense IN Inventory WP Work In Progress |
| 5 | REV_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Reveune Amount |