UPG_PC_DTL_TAO

#	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
3	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
4	PRJ_BUS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	Project GL Bus Unit
5	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
6	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
7	PROJECT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Project Type A=Activity G=Grant H=Phase P=Project S=Segment
8	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
9	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
10	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
11	PROJ_TRANS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Project Transaction Type
12	PROJ_TRANS_CODE	Character(5)	VARCHAR2(5) NOT NULL	Project Transaction Code
13	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
14	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
15	DEBIT_CREDIT	Character(2)	VARCHAR2(2) NOT NULL	Debit / Credit Indicator CR=Credit DR=Debit
16	CRIT_SEQ	Number(8,0)	INTEGER NOT NULL	Criteria Sequence
17	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
18	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit
19	ACCOUNT_SIGN	Signed Number(2,0)	DECIMAL(1) NOT NULL	Account Sign
20	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
21	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
22	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
23	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
24	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
25	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
26	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.
27	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_SC_VW
28	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_SC_VW
29	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_SC_VW
30	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASS_CF_SC_VW
31	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_SC_VW
32	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_SC_VW
33	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
34	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
35	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
36	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_SC_VW
37	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_SC_VW
38	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_SC_VW