CA_CH_PCT_TAO(SQL Table) |
Index Back |
|---|---|
Process Amendments |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | Character(25) | VARCHAR2(25) NOT NULL | Contract | |
| 3 | Number(3,0) | SMALLINT NOT NULL | Contract Line Num | |
| 4 | Character(10) | VARCHAR2(10) NOT NULL | Change Package Identifier. This is sequenced from 1 to N for each contract. | |
| 5 | Character(1) | VARCHAR2(1) NOT NULL |
Accounting Policy
G=Gross N=Net |
|
| 6 | Number(5,0) | INTEGER NOT NULL | Prepaid Add Sequence | |
| 7 | Character(1) | VARCHAR2(1) NOT NULL |
Billing Location
Default Value: Y |
|
| 8 | CHG_PERCENTAGE | Signed Number(33,5) | DECIMAL(31,5) NOT NULL | Change Percentage |
| 9 | CHG_BIL_RETRO | Character(1) | VARCHAR2(1) NOT NULL | Adjust Billing Retroactively |
| 10 | CHG_REV_RETRO | Character(1) | VARCHAR2(1) NOT NULL | Adjust Revenue Retroactively |
| 11 | CHG_REVERSE_AMT | Character(1) | VARCHAR2(1) NOT NULL | Reverse Amounts |
| 12 | GROSS_CHANGE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Negotiated Amount |
| 13 | INT_CHG_PERCENTAGE | Signed Number(32,0) | DECIMAL(31) NOT NULL |
Integer Change Percentage
Default Value: 0 |
| 14 | DEC_CHG_PERCENTAGE | Signed Number(33,31) | DECIMAL(31,31) NOT NULL |
Decimal Change Percentage
Default Value: 0 |