PROCESS_INSTANCEY/N Table Edit
Default Value: N
AP_COPYB_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PAYER_TIN | Character(20) | VARCHAR2(20) NOT NULL | Payer Taxpayer Identification |
| 3 | PAYEE_TIN | Character(20) | VARCHAR2(20) NOT NULL | Payee Taxpayer Identification |
| 4 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 5 | PAYEE_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Payee Name 1 |
| 6 | PAYEE_NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Payee Name 2 |
| 7 | PAYER_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Payer Name 1 |
| 8 | PAYER_NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Payer Name 2 |
| 9 | PAYER_ADDRESS1 | Character(40) | VARCHAR2(40) NOT NULL | Payer Address Line 1 |
| 10 | PAYER_ADDRESS2 | Character(40) | VARCHAR2(40) NOT NULL | Payer Address Line 2 |
| 11 | PAYER_ADDRESS3 | Character(40) | VARCHAR2(40) NOT NULL | Payer Address Line 3 |
| 12 | PAYER_ADDRESS4 | Character(40) | VARCHAR2(40) NOT NULL | Payer Address Line 4 |
| 13 | PAYER_CITYSTZIP | Character(40) | VARCHAR2(40) NOT NULL | Payer City State Zip |
| 14 | PAYER_COUNTRY_DESC | Character(30) | VARCHAR2(30) NOT NULL | Payer Country |
| 15 | PAYER_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Payer Telephone |
| 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_CITYSTZIP | Character(40) | VARCHAR2(40) NOT NULL | Payee City State Zip |
| 21 | PAYEE_COUNTRY_DESC | Character(30) | VARCHAR2(30) NOT NULL | Payee Country |
| 22 | SECOND_TIN | Character(1) | VARCHAR2(1) NOT NULL | IRS Notified Twice of Invalid |
| 23 | PAYEE_CITY | Character(40) | VARCHAR2(40) NOT NULL | IRS 1099 B-Record Payee City |
| 24 | PAYEE_STATE | Character(2) | VARCHAR2(2) NOT NULL | IRS 1099 B-Record payee state |
| 25 | PAYEE_POSTAL | Character(10) | VARCHAR2(10) NOT NULL | Remit Zip Code |
| 26 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 27 | TAX_YEAR_REFUND | Character(4) | VARCHAR2(4) NOT NULL | Tax Year of Refund |
| 28 | COUNTRY_PAID | Character(40) | VARCHAR2(40) NOT NULL | Country Paid |
| 29 | FOREIGN_TAX_PAID | Number(16,2) | DECIMAL(15,2) NOT NULL | Foreign Tax Paid |
| 30 | TRADE_BUS_INC | Character(1) | VARCHAR2(1) NOT NULL | Trade or Business Income Ind |
| 31 | PAYMENT_AMT_1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 32 | PAYMENT_AMT_2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 33 | PAYMENT_AMT_3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 34 | PAYMENT_AMT_4 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 35 | PAYMENT_AMT_5 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 36 | PAYMENT_AMT_6 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 37 | PAYMENT_AMT_7 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 38 | PAYMENT_AMT_8 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 39 | PAYMENT_AMT_9 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 40 | PAYMENT_AMT_A | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 41 | PAYMENT_AMT_B | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 42 | PAYMENT_AMT_C | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 43 | PAYMENT_AMT_D | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 44 | PAYMENT_AMT_E | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 45 | PAYMENT_AMT_F | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 46 | PAYMENT_AMT_G | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 47 | PAYMENT_AMT_9G | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Withholding Amount |
| 48 | CALENDAR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Calendar SetID |
| 49 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 50 | PERIOD | Number(3,0) | SMALLINT NOT NULL | Period |
| 51 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 52 | WHERE_CLAUSE2 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 53 | WHERE_CLAUSE3 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 54 | WHERE_CLAUSE4 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 55 | BOND_PREMIUM | Number(13,2) | DECIMAL(12,2) NOT NULL | Bond Premium |
| 56 | MARKET_DISCOUNT | Number(13,2) | DECIMAL(12,2) NOT NULL | Market Discount |
| 57 | PRIVATE_BOND_INT | Number(13,2) | DECIMAL(12,2) NOT NULL | Private Activity Bond Interest |
| 58 | TAX_EXMPT_INTEREST | Number(13,2) | DECIMAL(12,2) NOT NULL | Tax-exempt Interest |
| 59 | BOND_PREMIUM_TAXEX | Number(13,2) | DECIMAL(12,2) NOT NULL | Bond Premium on Tax Exempt Bond |
| 60 | FATCA_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
FATCA Filiing Requirement Indicator
Y/N Table Edit Default Value: N |
| 61 | REPORT_BOND_PREM | Number(13,2) | DECIMAL(12,2) NOT NULL | Bond Premium on Treasury Obligations |
| 62 | AE_WHERE_LONG1 | Long Character(1300) | VARCHAR2(1300) | AE Where Clause Long String. |
| 63 | AE_WHERE_LONG2 | Long Character(1300) | VARCHAR2(1300) | AE Where Clause Long String. |
| 64 | WHERE_TXT_LONG | Long Character(4000) | CLOB | Where clause |