UPG_PC_HDR_TAO

(SQL Table)
 Index Back

Accounting Rules Header

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT

Prompt Table: SP_BU_PC_NONVW

3 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: PROJ_ANTYPE_TBL

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

Prompt Table: CA_CONTR_HDR

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

Prompt Table: SP_CAPRJ4_NONVW

6 PRJ_BUS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL Project GL Bus Unit

Prompt Table: SP_BU_GL_NONVW

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

Prompt Table: SP_BU_GL_NONVW

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

Prompt Table: PROJ_TYPE_TBL

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

Prompt Table: PROJ_ACT_VW

10 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RES_TYPE

11 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: PROJ_CATG_TBL

12 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: PROJ_SUBCAT_TBL

13 PROJ_TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Project Transaction Type

Prompt Table: PROJ_TRANS_TYPE

14 PROJ_TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Project Transaction Code

Prompt Table: PROJ_TRANS_CODE

15 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
16 CRIT_SEQ Number(8,0) INTEGER NOT NULL Criteria Sequence
17 DESCR Character(30) VARCHAR2(30) NOT NULL Description
18 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
19 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template

Prompt Table: JRNLGEN_APPL_ID
Set Control Field: BUSINESS_UNIT_GL

20 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

Prompt Table: SP_BULGRP_NONVW
Set Control Field: BUSINESS_UNIT_GL

21 ACTIVE_STATUS Character(1) VARCHAR2(1) NOT NULL Transfer Template Status
A=Active
I=Inactive

Default Value: A