CONTRACT_NUMCA_BILLED_VW(SQL View) |
Index Back |
|---|---|
Billed Amount by Contract |
| SELECT XRF.CONTRACT_NUM ,SUM(%Round(%decdiv(%decmult(XRF.NET_EXTENDED_AMT, RT.RATE_MULT),RT.RATE_DIV),RT.DECIMAL_POSITIONS)) ,INST.CURRENCY_CD FROM PS_CA_BP_XREF XRF ,PS_CA_CURR_RATE_VW RT ,PS_INSTALLATION_CA INST WHERE XRF.XREF_STATUS <> 'DEL' AND RT.RT_TYPE = INST.RT_TYPE AND RT.FROM_CUR = XRF.BI_CURRENCY_CD AND RT.TO_CUR = INST.CURRENCY_CD GROUP BY INST.CURRENCY_CD ,XRF.CONTRACT_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 2 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 3 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |