AP_T4A_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 REPORT_TYPE_CODE Character(1) VARCHAR2(1) NOT NULL Report Type Code
A=Amendment
C=Cancel
O=Original
9 RCPNT_TCD Character(1) VARCHAR2(1) NOT NULL Canadian T4A-NR Recipient Type Code
10 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
11 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
12 PAYEE_NAME1 Character(40) VARCHAR2(40) NOT NULL Payee Name 1
13 PAYEE_NAME2 Character(40) VARCHAR2(40) NOT NULL Payee Name 2
14 NAME1_CORP Character(40) VARCHAR2(40) NOT NULL Corporate Vendor Name1
15 NAME2_CORP Character(40) VARCHAR2(40) NOT NULL Customer Name2
16 PAYEE_ADDRESS1 Character(40) VARCHAR2(40) NOT NULL Payee Address Line1
17 PAYEE_ADDRESS2 Character(40) VARCHAR2(40) NOT NULL Payee Address Line 2
18 PAYEE_ADDRESS3 Character(40) VARCHAR2(40) NOT NULL Payee Address Line 3
19 PAYEE_ADDRESS4 Character(40) VARCHAR2(40) NOT NULL Payee Address Line 4
20 PAYEE_CITY Character(40) VARCHAR2(40) NOT NULL IRS 1099 B-Record Payee City
21 PAYEE_STATE Character(2) VARCHAR2(2) NOT NULL IRS 1099 B-Record payee state
22 PAYEE_POSTAL Character(10) VARCHAR2(10) NOT NULL Remit Zip Code
23 PAYEE_COUNTRY Character(3) VARCHAR2(3) NOT NULL Payee Country
24 T4A_CODE_016_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 016 Amount
25 T4A_CODE_018_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 018 Amount
26 T4A_CODE_020_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 020 Amount
27 T4A_CODE_022_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 022 Amount
28 T4A_CODE_024_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 024 Amount
29 T4A_CODE_026_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 026 Amount
30 T4A_CODE_027_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 027 Amount
31 T4A_CODE_028_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 028 Amount
32 T4A_CODE_030_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 030 Amount
33 T4A_CODE_032_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 032 Amount
34 T4A_CODE_034_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 034 Amount
35 T4A_CODE_037_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 037 Amount
36 T4A_CODE_040_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 040 Amount
37 T4A_CODE_042_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 042 Amount
38 T4A_CODE_046_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 046 Amount
39 T4A_CODE_048_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 048 Amount
40 T4A_CODE_102_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 102 Amount
41 T4A_CODE_104_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 104 Amount
42 T4A_CODE_105_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 105 Amount
43 T4A_CODE_106_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 106 Amount
44 T4A_CODE_107_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 107 Amount
45 T4A_CODE_108_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 108 Amount
46 T4A_CODE_109_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 109 Amount
47 T4A_CODE_110_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 110 Amount
48 T4A_CODE_111_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 111 Amount
49 T4A_CODE_115_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 115 Amount
50 T4A_CODE_116_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 116 Amount
51 T4A_CODE_117_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 117 Amount
52 T4A_CODE_118_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 118 Amount
53 T4A_CODE_119_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 119 Amount
54 T4A_CODE_122_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 122 Amount
55 T4A_CODE_123_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 123 Amount
56 T4A_CODE_124_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 124 Amount
57 T4A_CODE_125_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 125 Amount
58 T4A_CODE_126_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 126 Amount
59 T4A_CODE_127_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 127 Amount
60 T4A_CODE_128_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 128 Amount
61 T4A_CODE_129_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 129 Amount
62 T4A_CODE_130_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 130 Amount
63 T4A_CODE_131_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 131 Amount
64 T4A_CODE_132_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 132 Amount
65 T4A_CODE_133_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 133 Amount
66 T4A_CODE_134_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 134 Amount
67 T4A_CODE_135_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 135 Amount
68 T4A_CODE_136_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 136 Amount
69 T4A_CODE_142_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 142 Amount
70 T4A_CODE_143_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 143 Amount
71 T4A_CODE_144_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 144 Amount
72 T4A_CODE_146_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 146 Amount
73 T4A_CODE_148_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 148 Amount
74 T4A_CODE_150_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 150 Amount
75 T4A_CODE_152_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 152 Amount
76 T4A_CODE_154_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 154 Amount
77 T4A_CODE_156_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 156 Amount
78 T4A_CODE_158_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 158 Amount
79 T4A_CODE_162_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 162 Amount
80 T4A_CODE_180_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 180 Amount
81 T4A_CODE_190_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 190 Amount
82 T4A_CODE_194_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 194 Amount
83 T4A_CODE_195_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 195 Amount
84 T4A_CODE_196_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 196 Amount
85 T4A_CODE_200_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 200 Amount
86 T4A_CODE_201_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 201 Amount
87 T4A_CODE_205_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 205 Amount
88 T4A_CODE_210_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL T4A Code 210 Amount