ACCTG_TAG_DT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	ACCOUNT_CODE	Character(20)	VARCHAR2(20) NOT NULL	Accounting Tag
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	SEQUENCE_NBR_6	Number(6,0)	INTEGER NOT NULL	Sequence Default Value: 1
5	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: %EDIT_ACCOUNT
6	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account Prompt Table: %EDIT_ALTACCT
7	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPTID_BUGL_VW
8	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code Prompt Table: STAT_BUGL_VW
9	PERCENTAGE	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percentage
10	SPDCHRT_WEIGHT	Number(16,5)	DECIMAL(15,5) NOT NULL	Weight
11	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
12	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
13	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
14	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
15	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
16	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
17	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
18	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
19	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
20	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
21	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
22	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
23	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDIT_BU_PC
24	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: %EDIT_PROJECT
25	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDIT_ACTIVITY
26	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RESTYPE_FS Set Control Field: BUSINESS_UNIT_PC
27	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDIT_RES_CAT Set Control Field: BUSINESS_UNIT_PC
28	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDIT_RES_SUB Set Control Field: BUSINESS_UNIT_PC
29	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: %EDIT_ANALYSIS Set Control Field: BUSINESS_UNIT_PC
30	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Prompt Table: SP_BU_GL_NONVW
31	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL