CA_RECON_BI_H (SQL Table)	Index Back
Billing Sum for Reconciliation Summary from Billing accounting entries for the Revenue and Billing reconciliation. Populated by CA_RECON_SUM.

CA_RECON_BI_H

(SQL Table)

Billing Sum for Reconciliation

Summary from Billing accounting entries for the Revenue and Billing reconciliation. Populated by CA_RECON_SUM.

# 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 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

6 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

7 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

8 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

9 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

10 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

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

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

13 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

14 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

15 CONTRACT_TYPE Character(15) VARCHAR2(15) NOT NULL Contract Type

16 CONTRACT_ADMIN Character(40) VARCHAR2(40) NOT NULL Contract Administrator defined on CABU.

17 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment

18 PROJECT_MANAGER Character(11) VARCHAR2(11) NOT NULL Project Manager

19 LOC_REFERENCE_ID Character(10) VARCHAR2(10) NOT NULL Letter of Credit ID

#	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	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
6	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
7	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
8	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
9	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
10	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
13	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
14	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer
15	CONTRACT_TYPE	Character(15)	VARCHAR2(15) NOT NULL	Contract Type
16	CONTRACT_ADMIN	Character(40)	VARCHAR2(40) NOT NULL	Contract Administrator defined on CABU.
17	PROJECT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Project Type A=Activity G=Grant H=Phase P=Project S=Segment
18	PROJECT_MANAGER	Character(11)	VARCHAR2(11) NOT NULL	Project Manager
19	LOC_REFERENCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Letter of Credit ID