CA_CH_PCT_TAO(SQL Table) |
Index Back |
---|---|
Process Amendments |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
3 | CONTRACT_LINE_NUM | Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
4 | CHG_ID | Character(10) | VARCHAR2(10) NOT NULL | Change Package Identifier. This is sequenced from 1 to N for each contract. |
5 | ACCTG_POLICY | Character(1) | VARCHAR2(1) NOT NULL |
Accounting Policy
G=Gross N=Net |
6 | CONTRACT_PPD_SEQ | Number(5,0) | INTEGER NOT NULL | Prepaid Add Sequence |
7 | BILL_FLAG | 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 |