CA_RECON_FF_BVW

(SQL View)
 Index Back

Contracts Compare Bill/rev

Contracts Compare Fixed amount Billing v/s Revenue. Billing View.

SELECT XREF.CONTRACT_NUM , XREF.CONTRACT_LINE_NUM , XREF.BILL_PLAN_ID , SUM(DET.NET_AMOUNT) , SUM(XREF.NET_AMOUNT) , SUM(DET.NET_AMOUNT) - SUM(XREF.NET_AMOUNT) FROM PS_CA_BP_XREF XREF , PS_CA_CONTR_HDR HDR , PS_CA_DETAIL DET WHERE XREF.CONTRACT_NUM = HDR.CONTRACT_NUM AND HDR.CONTRACT_NUM = DET.CONTRACT_NUM AND DET.CONTRACT_LINE_NUM = XREF.CONTRACT_LINE_NUM AND DET.BILL_PLAN_ID = XREF.BILL_PLAN_ID AND HDR.CA_PROC_STATUS = 'A' AND XREF.XREF_STATUS = 'FIN' GROUP BY XREF.CONTRACT_NUM, XREF.CONTRACT_LINE_NUM, XREF.BILL_PLAN_ID

# 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 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID
4 NET_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL The resulting net amount related to settlement cash flows subject to counterparty netting agreements.
5 BILLED_AMT_CA Signed Number(28,3) DECIMAL(26,3) NOT NULL Billed Amount
6 BILLABLE_AMT_CA Signed Number(28,3) DECIMAL(26,3) NOT NULL Unbilled Billable Amount