CA_RECON_REV_H

(SQL Table)
 Index Back

Revenue Sum for Reconciliation

Summary from Contracts 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 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
10 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
11 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
12 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
13 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW

14 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

15 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_BUGL_VW

16 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_BUGL_VW

17 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASSCF_BUGL_VW

18 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_BUGL_VW

19 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_BUGL_VW

20 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

21 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

22 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

23 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_BUGL_VW

24 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CF2_BUGL_VW

25 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CF3_BUGL_VW

26 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
27 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.
28 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
29 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
30 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
31 CONTRACT_TYPE Character(15) VARCHAR2(15) NOT NULL Contract Type
32 CONTRACT_ADMIN Character(40) VARCHAR2(40) NOT NULL Contract Administrator defined on CABU.
33 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
34 PROJECT_MANAGER Character(11) VARCHAR2(11) NOT NULL Project Manager
35 LOC_REFERENCE_ID Character(10) VARCHAR2(10) NOT NULL Letter of Credit ID