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 |