PYAP_XTAX_AET

#	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	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
10	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality
11	TAX_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Tax Balance Class
12	INCLUDE_FEDERAL_TX	Character(1)	VARCHAR2(1) NOT NULL	Include Federal Taxes Y/N Table Edit
13	INCLUDE_STATE_TX	Character(1)	VARCHAR2(1) NOT NULL	Include State Taxes Y/N Table Edit
14	INCLUDE_LOCAL_TX	Character(1)	VARCHAR2(1) NOT NULL	Include Local Taxes Y/N Table Edit
15	STATE_ALL	Character(1)	VARCHAR2(1) NOT NULL	All States A=All States S=Specific States
16	LOCALITY_ALL	Character(1)	VARCHAR2(1) NOT NULL	All Localities A=All Localities S=Specific Localities
17	PERIOD_END_DT	Date(10)	DATE	Tax Period End Date
18	PAYMENT_DT	Date(10)	DATE	Payment Due Date
19	AP_INVNO_PREFIX	Character(1)	VARCHAR2(1) NOT NULL	AP Invoice Number Prefix
20	AP_INVNO_LAST	Number(7,0)	INTEGER NOT NULL	Last AP Invoice Number
21	ACTIVITY	Character(3)	VARCHAR2(3) NOT NULL	Payroll Activity
22	SETID_HR	Character(5)	VARCHAR2(5) NOT NULL	SetID - HR
23	REC_GROUP_ID	Character(10)	VARCHAR2(10) NOT NULL	Record Group ID
24	SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Sequence Number
25	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
26	BEGIN_POSITION	Number(2,0)	SMALLINT NOT NULL	Begin at Position
27	LENGTH	Number(5,0)	INTEGER NOT NULL	Length
28	CHART_KEY	Character(50)	VARCHAR2(50) NOT NULL	ChartField Key
29	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
30	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
31	INVOICE_DT	Date(10)	DATE	Invoice Date
32	INVOICE_ID	Character(22)	VARCHAR2(22) NOT NULL	Invoice Number
33	FEDERAL_EIN	Number(9,0)	DECIMAL(9) NOT NULL	Federal EIN
34	STATE_LOCAL_EIN	Character(20)	VARCHAR2(20) NOT NULL	State and Local EIN
35	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
36	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	General Ledger Unit
37	TEMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Temporary Field for App Engine
38	SEQUENCENO	Number(10,0)	DECIMAL(10) NOT NULL	Sequence Number
39	COUNT_INVNO	Number(7,0)	INTEGER NOT NULL	Counter
40	COUNTER	Signed Number(6,0)	DECIMAL(5) NOT NULL	Counter
41	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
42	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
43	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number