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