AP_T4ANR_SLIP(SQL Table) |
Index Back |
---|---|
Canadian T4A/T4ANR Slip |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
2 | Character(5) | VARCHAR2(5) NOT NULL | Setid for the Withholding Code | |
3 | Character(10) | VARCHAR2(10) NOT NULL | Withholding Report ID | |
4 | Character(20) | VARCHAR2(20) NOT NULL | Payer Taxpayer Identification | |
5 | Character(20) | VARCHAR2(20) NOT NULL | Payee Taxpayer Identification | |
6 | Character(15) | VARCHAR2(15) NOT NULL | Business Number | |
7 | 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 |