CA_CH_BPS_TAO

(SQL Table)
Index Back

Process Amendments

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
2 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
3 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID
4 BPLAN_LN_NBR Number(3,0) SMALLINT NOT NULL Bill Plan Line Number
5 EVENT_OCCURRENCE Number(3,0) SMALLINT NOT NULL Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal.
6 DST_USE Character(3) VARCHAR2(3) NOT NULL Added the following inactive translates for Contracts 8.4: AP Accounts Payable Liability AS Fixed Asset CA Contra Asset CG Cost of Goods Sold CL Contra Liability EX Expense IN Inventory WP Work In Progress
7 DST_SEQ_NUM Number(6,0) INTEGER NOT NULL Distribution Sequence
8 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
9 CONTRACT_PPD_SEQ Number(5,0) INTEGER NOT NULL Prepaid Add Sequence
10 CHG_ID Character(10) VARCHAR2(10) NOT NULL Change Package Identifier. This is sequenced from 1 to N for each contract.
11 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
12 CA_PERCENTAGE Signed Number(13,8) DECIMAL(11,8) NOT NULL Percentage
13 CHG_ORD_ID Character(10) VARCHAR2(10) NOT NULL Change Order Id.
14 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
16 EFFDT_USED Date(10) DATE Effective Date
17 CHG_BIL_RETRO Character(1) VARCHAR2(1) NOT NULL Adjust Billing Retroactively
18 CHG_REV_RETRO Character(1) VARCHAR2(1) NOT NULL Adjust Revenue Retroactively
19 CHG_REVERSE_AMT Character(1) VARCHAR2(1) NOT NULL Reverse Amounts