UPG_PC_HDR_AET

(SQL Table)
Index Back

Accounting Rules State Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
5 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
6 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
7 PRJ_BUS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL Project GL Bus Unit
8 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
9 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
10 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
11 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
12 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
13 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
14 PROJ_TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Project Transaction Type
15 PROJ_TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Project Transaction Code
16 INTER_ORG_LEVEL Character(4) VARCHAR2(4) NOT NULL Inter-Organization Level
DFLT=Default
LVL1=Level 1
LVL2=Level 2
LVL3=Level 3
LVL4=Level 4
LVL5=Level 5
17 CRIT_SEQ Number(8,0) INTEGER NOT NULL Criteria Sequence