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 |