PROCESS_INSTANCEWTHD_SETIDWTHD_RPT_IDPAYER_TINPAYEE_TINPAYEE_BNCALENDAR_YEARA=Amendment
C=Cancel
O=Original
AP_T4A_RPT(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 | PAYER_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Payer Name 1 |
| 13 | PAYER_NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Payer Name 2 |
| 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 | T4A_CODE_016_AMT | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | T4A Code 016 Amount |
| 27 | T4A_CODE_018_AMT | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | T4A Code 018 Amount |
| 28 | T4A_CODE_020_AMT | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | T4A Code 020 Amount |
| 29 | T4A_CODE_022_AMT | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | T4A Code 022 Amount |
| 30 | T4A_CODE_024_AMT | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | T4A Code 024 Amount |
| 31 | T4A_CODE_048_AMT | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | T4A Code 048 Amount |
| 32 | AMT1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used in Virtual Approver to store the various rule amounts that go on each approval step |
| 33 | AMT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used in Virtual Approver to store the various rule amounts that go on each approval step |
| 34 | AMT3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used in Virtual Approver to store the various rule amounts that go on each approval step |
| 35 | AMT4 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used in Virtual Approver to store the various rule amounts that go on each approval step |
| 36 | AMT5 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used in Virtual Approver to store the various rule amounts that go on each approval step |
| 37 | AMT6 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 6 |
| 38 | AMT7 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 7 |
| 39 | AMT8 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 8 |
| 40 | AMT9 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 9 |
| 41 | AMT10 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 10 |
| 42 | AMT11 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 11 |
| 43 | AMT12 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 12 |
| 44 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 45 | AMT_CODE_1 | Character(3) | VARCHAR2(3) NOT NULL | Rent |
| 46 | AMT_CODE_2 | Character(3) | VARCHAR2(3) NOT NULL | Royalties |
| 47 | AMT_CODE_3 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 48 | AMT_CODE_4 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 49 | AMT_CODE_5 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 50 | AMT_CODE_6 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 51 | AMT_CODE_7 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 52 | AMT_CODE_8 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 53 | AMT_CODE_9 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 54 | AMT_CODE_10 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 55 | AMT_CODE_11 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |
| 56 | AMT_CODE_12 | Character(3) | VARCHAR2(3) NOT NULL | Amount Code |