PYAP_XDEDN_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PAY_MODES	Character(1)	VARCHAR2(1) NOT NULL	Pay Modes O=Deduct/Collect Comp./Bond Met S=Specified Date
3	RUN_ID	Character(10)	VARCHAR2(10) NOT NULL	Pay Run ID
4	SPECIFIED_DT	Date(10)	DATE	Specified Date
5	PAYMENT_DT	Date(10)	DATE	Payment Date
6	PAY_ALL	Character(1)	VARCHAR2(1) NOT NULL	Pay All ?
7	AP_INVNO_PREFIX	Character(1)	VARCHAR2(1) NOT NULL	AP Invoice Number Prefix
8	AP_INVNO_LAST	Number(7,0)	INTEGER NOT NULL	Last AP Invoice Number
9	REC_GROUP_ID	Character(10)	VARCHAR2(10) NOT NULL	Record Group ID
10	TEMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Temporary Field for App Engine
11	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
12	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
13	PAY_END_DT	Date(10)	DATE	Pay Period End Date
14	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ?
15	PAGE_NUM	Number(5,0)	INTEGER NOT NULL	Page Nbr
16	LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Line Nbr
17	SEPCHK	Number(2,0)	SMALLINT NOT NULL	Separate check number.
18	BENEFIT_RCD_NBR	Number(3,0)	SMALLINT NOT NULL	Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
19	PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
20	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
21	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code
22	DED_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Deduction Classification A=After-Tax B=Before-Tax L=QC Taxable Benefit N=Nontaxable Benefit P=Nontaxable Btax Benefit T=Taxable Benefit
23	DED_SLSTX_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Sales Tax Type B=None G=Goods and Services Tax H=Harmonized Sales Tax I=Provincial Sales Tax Insurance P=Provincial Sales Tax Q=QC Prov Sales Tax Insurance S=QC Provincial Sales Tax T=Provincial Premium Tax U=QC Provincial Premium Tax
24	GARN_PRIORITY	Number(3,0)	SMALLINT NOT NULL	Garnishment priority.
25	GARNID	Character(6)	VARCHAR2(6) NOT NULL	Garnishment id.
26	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
27	BOND_ID	Character(3)	VARCHAR2(3) NOT NULL	Savings Bond ID
28	BOND_OWNER_ID	Character(2)	VARCHAR2(2) NOT NULL	Bond Owner ID
29	BOND_OTH_REG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Bond Other Registrant Type B=Beneficiary C=Co-Owner N=No Other Bond Registrant
30	BOND_OTH_REG_ID	Character(2)	VARCHAR2(2) NOT NULL	Bond Other Registrant ID
31	BOND_LOG_SEQ	Number(3,0)	SMALLINT NOT NULL	Bond Activity Seq Nbr
32	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
33	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
34	INVOICE_ID	Character(22)	VARCHAR2(22) NOT NULL	Invoice Number
35	INVOICE_DT	Date(10)	DATE	Invoice Date
36	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
37	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	General Ledger Unit
38	SEQUENCENO	Number(10,0)	DECIMAL(10) NOT NULL	Sequence Number
39	COUNTER	Signed Number(6,0)	DECIMAL(5) NOT NULL	Counter
40	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
41	COUNT_INVNO	Number(7,0)	INTEGER NOT NULL	Counter
42	REMIT_LOC	Character(10)	VARCHAR2(10) NOT NULL	Remit to Location
43	REMIT_ADDR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Remitting Location