AP_T4ANR_SLIP

(SQL Table)
Index Back

Canadian T4A/T4ANR Slip

# 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 PAYEE_NAME1 Character(40) VARCHAR2(40) NOT NULL Payee Name 1
15 PAYEE_NAME2 Character(40) VARCHAR2(40) NOT NULL Payee Name 2
16 NAME1_CORP Character(40) VARCHAR2(40) NOT NULL Corporate Vendor Name1
17 NAME2_CORP Character(40) VARCHAR2(40) NOT NULL Customer Name2
18 PAYEE_ADDRESS1 Character(40) VARCHAR2(40) NOT NULL Payee Address Line1
19 PAYEE_ADDRESS2 Character(40) VARCHAR2(40) NOT NULL Payee Address Line 2
20 PAYEE_ADDRESS3 Character(40) VARCHAR2(40) NOT NULL Payee Address Line 3
21 PAYEE_ADDRESS4 Character(40) VARCHAR2(40) NOT NULL Payee Address Line 4
22 PAYEE_CITY Character(40) VARCHAR2(40) NOT NULL IRS 1099 B-Record Payee City
23 PAYEE_STATE Character(2) VARCHAR2(2) NOT NULL IRS 1099 B-Record payee state
24 PAYEE_POSTAL Character(10) VARCHAR2(10) NOT NULL Remit Zip Code
25 PAYEE_COUNTRY Character(3) VARCHAR2(3) NOT NULL Payee Country
26 GRO_INCAMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Withholding Basis Amount
27 ITX_DDCT_AMT Signed Number(11,2) DECIMAL(9,2) NOT NULL Withholding Basis Amount
28 TRVL_EXAMT Signed Number(11,2) DECIMAL(9,2) NOT NULL Withholding Basis Amount