UPG_PC_DTL2_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
3	PRJ_BUS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	Project GL Bus Unit
4	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
5	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
6	PROJECT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Project Type A=Activity G=Grant H=Phase P=Project S=Segment
7	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
8	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
9	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
10	PROJ_TRANS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Project Transaction Type
11	PROJ_TRANS_CODE	Character(5)	VARCHAR2(5) NOT NULL	Project Transaction Code
12	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
13	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
14	DEBIT_CREDIT	Character(2)	VARCHAR2(2) NOT NULL	Debit / Credit Indicator CR=Credit DR=Debit
15	CRIT_SEQ	Number(8,0)	INTEGER NOT NULL	Criteria Sequence
16	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
17	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit
18	ACCOUNT_SIGN	Signed Number(2,0)	DECIMAL(1) NOT NULL	Account Sign
19	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
20	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
21	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
22	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
23	PROJECT_FLAG	Character(3)	VARCHAR2(3) NOT NULL	Flag for Accounting Rules page. Specifies whether or not the Project ID value flows thru from PROJ_RESOURCE or flows thru with no value. NON=None SRC=Source
24	ORG_TO_BOOK	Character(1)	VARCHAR2(1) NOT NULL	Organization to Book C=Business Unit GL O=Override P=Project R=Resource S=From Business Unit GL
25	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
26	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_SC_VW
27	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_SC_VW
28	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_SC_VW
29	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASS_CF_SC_VW
30	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_SC_VW
31	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_SC_VW
32	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
33	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
34	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
35	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_SC_VW
36	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_SC_VW
37	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_SC_VW