CA_BP_SCHEDUL_H (SQL Table)	Index Back
CA Billing Schedule Tbl This table holds all of the combiniations of LINES (REV), Accounting Line Entries(UAR) and Discounts (DIS) for events and nonevents fix fee bill types. This is to elimiate the rounding done in CA_BI_INTFC and move it online.

CA_BP_SCHEDUL_H

(SQL Table)

CA Billing Schedule Tbl

This table holds all of the combiniations of LINES (REV), Accounting Line Entries(UAR) and Discounts (DIS) for events and nonevents fix fee bill types. This is to elimiate the rounding done in CA_BI_INTFC and move it online.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

3 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

4 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

5 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID

6 BPLAN_LN_NBR Number(3,0) SMALLINT NOT NULL Bill Plan Line Number

7 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.

8 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

9 DST_SEQ_NUM Number(6,0) INTEGER NOT NULL Distribution Sequence

10 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

11 CHG_ID Character(10) VARCHAR2(10) NOT NULL Change Package Identifier. This is sequenced from 1 to N for each contract.

12 CA_PERCENTAGE Signed Number(13,8) DECIMAL(11,8) NOT NULL Percentage

13 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

15 DONE_FLAG Character(1) VARCHAR2(1) NOT NULL Done Flag
Y/N Table Edit
Default Value: N

16 EFFDT_USED Date(10) DATE Effective Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
4	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
5	BILL_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Billing Plan ID
6	BPLAN_LN_NBR	Number(3,0)	SMALLINT NOT NULL	Bill Plan Line Number
7	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.
8	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
9	DST_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Distribution Sequence
10	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
11	CHG_ID	Character(10)	VARCHAR2(10) NOT NULL	Change Package Identifier. This is sequenced from 1 to N for each contract.
12	CA_PERCENTAGE	Signed Number(13,8)	DECIMAL(11,8) NOT NULL	Percentage
13	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
15	DONE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Done Flag Y/N Table Edit Default Value: N
16	EFFDT_USED	Date(10)	DATE	Effective Date