AP_T4ANR_RPT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	WTHD_SETID	Character(5)	VARCHAR2(5) NOT NULL	Setid for the Withholding Code
3	WTHD_RPT_ID	Character(10)	VARCHAR2(10) NOT NULL	Withholding Report ID
4	PAYER_TIN	Character(20)	VARCHAR2(20) NOT NULL	Payer Taxpayer Identification
5	PAYEE_TIN	Character(20)	VARCHAR2(20) NOT NULL	Payee Taxpayer Identification
6	PAYEE_BN	Character(15)	VARCHAR2(15) NOT NULL	Business Number
7	CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	Calendar Year
8	FOREIGN_TAX_ID	Character(20)	VARCHAR2(20) NOT NULL	Foreign Tax ID
9	REPORT_TYPE_CODE	Character(1)	VARCHAR2(1) NOT NULL	Report Type Code A=Amendment C=Cancel O=Original
10	NR_INDST_TCD	Character(2)	VARCHAR2(2) NOT NULL	Non resident�s Industry Type Code for Canadian T4A-NR
11	RCPNT_TCD	Character(1)	VARCHAR2(1) NOT NULL	Canadian T4A-NR Recipient Type Code
12	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
13	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
14	PAYER_NAME1	Character(40)	VARCHAR2(40) NOT NULL	Payer Name 1
15	PAYER_NAME2	Character(40)	VARCHAR2(40) NOT NULL	Payer Name 2
16	PAYER_CITY	Character(30)	VARCHAR2(30) NOT NULL	Payer City
17	PAYER_STATE	Character(6)	VARCHAR2(6) NOT NULL	Payer State
18	PAYEE_NAME1	Character(40)	VARCHAR2(40) NOT NULL	Payee Name 1
19	PAYEE_NAME2	Character(40)	VARCHAR2(40) NOT NULL	Payee Name 2
20	NAME1_CORP	Character(40)	VARCHAR2(40) NOT NULL	Corporate Vendor Name1
21	NAME2_CORP	Character(40)	VARCHAR2(40) NOT NULL	Customer Name2
22	PAYEE_ADDRESS1	Character(40)	VARCHAR2(40) NOT NULL	Payee Address Line1
23	PAYEE_ADDRESS2	Character(40)	VARCHAR2(40) NOT NULL	Payee Address Line 2
24	PAYEE_ADDRESS3	Character(40)	VARCHAR2(40) NOT NULL	Payee Address Line 3
25	PAYEE_ADDRESS4	Character(40)	VARCHAR2(40) NOT NULL	Payee Address Line 4
26	PAYEE_CITY	Character(40)	VARCHAR2(40) NOT NULL	IRS 1099 B-Record Payee City
27	PAYEE_STATE	Character(2)	VARCHAR2(2) NOT NULL	IRS 1099 B-Record payee state
28	PAYEE_POSTAL	Character(10)	VARCHAR2(10) NOT NULL	Remit Zip Code
29	PAYEE_COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Payee Country
30	GRO_INCAMT	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Withholding Basis Amount
31	ITX_DDCT_AMT	Signed Number(11,2)	DECIMAL(9,2) NOT NULL	Withholding Basis Amount
32	TRVL_EXAMT	Signed Number(11,2)	DECIMAL(9,2) NOT NULL	Withholding Basis Amount
33	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code