CONTRACT_NUMCHG_IDDefault Value: CA_CONTR_HDR.CURRENCY_CD
CA_CHG_CNCL_VW(SQL View) |
Index Back |
|---|
| SELECT CHG.CONTRACT_NUM , CHG.CHG_ID , SUM(DTL.GROSS_AMT) , SUM(DTL.GROSS_AMT_REV) , SUM(DTL.GROSS_AMT - DTL.NET_AMOUNT) , SUM(DTL.GROSS_AMT_REV - DTL.NET_AMOUNT_REV) , CHG.CURRENCY_CD FROM PS_CA_CHG_HDR CHG , PS_CA_DETAIL DTL , PS_CA_CHG_DTL CHG_DTL WHERE %Join(COMMON_KEYS, CA_CHG_HDR CHG, CA_CHG_DTL CHG_DTL) AND %Join(COMMON_KEYS, CA_CHG_HDR CHG, CA_DETAIL DTL) AND DTL.CONTRACT_LINE_NUM = CHG_DTL.CONTRACT_LINE_NUM AND CHG_DTL.FIELDNAME = 'CA_LINE_STATUS' AND CHG_DTL.NEWVALUE = 'C' AND CHG_DTL.OLDVALUE = 'A' GROUP BY CHG.CONTRACT_NUM, CHG.CHG_ID, CHG.CURRENCY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 2 | CHG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Change Package Identifier. This is sequenced from 1 to N for each contract. |
| 3 | GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Invoice Amount |
| 4 | GROSS_AMT_REV | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Revenue Amount |
| 5 | DISCOUNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the discount amount deducted from the par price of a given deal transaction such as a bond. |
| 6 | DISCOUNT_AMT_REV | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Cancelled Revenue Discount |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: CA_CONTR_HDR.CURRENCY_CD |