PYAP_XCTAX1_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
3	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
4	PAY_END_DT	Date(10)	DATE	Pay Period End Date
5	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ?
6	PAGE_NUM	Number(5,0)	INTEGER NOT NULL	Page Nbr
7	LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Line Nbr
8	SEPCHK	Number(2,0)	SMALLINT NOT NULL	Separate check number.
9	PROVINCE	Character(6)	VARCHAR2(6) NOT NULL	Province
10	TAX_CLASS_CAN	Character(3)	VARCHAR2(3) NOT NULL	Canadian Tax Class ALL=Total Gross CBT=Canadian Bonus Tax CIT=Canadian Income Tax (T4) CP2=CPP Second Additional Employee CPA=Pension Adjustment CPP=Canada Pension Plan Employee CPR=Canada Pension Plan Employer CR2=CPP Second Additional Employer EIE=Employment Insurance Employee EIR=Employment Insurance Employer HTX=Provincial Health Tax PYT=Payroll Tax QBT=Quebec Bonus Tax QCD=Quebec Tax Deduction QIE=Quebec Parental Plan Employee QIR=Quebec Parental Plan Employer QIT=Quebec Income Tax (RL-1) QP2=QPP Second Additional Employee QPP=Quebec Pension Plan Employee QPR=Quebec Pension Plan Employer QR2=QPP Second Additional Employer RV2=Quebec Income Tax (RL-2) T4A=Canadian Income Tax (T4A) TRV=True RL TT4=True T4
11	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
12	TAX_TYPE_CAN	Character(4)	VARCHAR2(4) NOT NULL	Tax Type
13	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
14	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
15	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
16	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	General Ledger Unit
17	PRIM_ADDR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Invoicing Location
18	REMIT_ADDR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Remitting Location
19	REMIT_LOC	Character(10)	VARCHAR2(10) NOT NULL	Remit to Location
20	DEFAULT_LOC	Character(10)	VARCHAR2(10) NOT NULL	Default Location
21	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
22	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
23	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.
24	PAYMENT_DT	Date(10)	DATE	Payment Date
25	INVOICE_DT	Date(10)	DATE	Invoice Date
26	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
27	DEPTID_CF	Character(10)	VARCHAR2(10) NOT NULL	Department
28	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project/Grant
29	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product
30	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
31	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code
32	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field.
33	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field
34	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit
35	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
36	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Chartfield
37	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield number 1
38	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
39	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
40	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
41	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate2
42	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Business Unit
43	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
44	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Type
45	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Category
46	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Sub Category
47	STATE_LOCAL_EIN	Character(20)	VARCHAR2(20) NOT NULL	State and Local EIN