AP_T4ANR_SUM

(SQL Table)
Index Back

Canadian T4A/T4ANR Summary

# 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 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year
6 REPORT_TYPE_CODE Character(1) VARCHAR2(1) NOT NULL Report Type Code
A=Amendment
C=Cancel
O=Original
7 SLIP_COUNT Number(7,0) INTEGER NOT NULL Slip Count
8 CNTCT_NAME1 Character(40) VARCHAR2(40) NOT NULL Contact Name1
9 AREA_CODE Character(3) VARCHAR2(3) NOT NULL Dialing Area Code
10 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
11 PAYER_NAME1 Character(40) VARCHAR2(40) NOT NULL Payer Name 1
12 PAYER_NAME2 Character(40) VARCHAR2(40) NOT NULL Payer Name 2
13 PAYER_ADDRESS1 Character(40) VARCHAR2(40) NOT NULL Payer Address Line 1
14 PAYER_ADDRESS2 Character(40) VARCHAR2(40) NOT NULL Payer Address Line 2
15 PAYER_CITY Character(30) VARCHAR2(30) NOT NULL Payer City
16 PAYER_STATE Character(6) VARCHAR2(6) NOT NULL Payer State
17 PAYER_POSTAL Character(12) VARCHAR2(12) NOT NULL Payer Postal
18 PAYER_COUNTRY Character(3) VARCHAR2(3) NOT NULL Payer Country
19 TOT_GRO_INCAMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Withholding Basis Amount
20 TOT_ITX_DDCT_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Withholding Basis Amount
21 TOT_TRVL_EXAMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Withholding Basis Amount