| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
TRANSACTION_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Type
|
| 2 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 3 |
PRIOR_YEAR_DATA |
Character(1) |
VARCHAR2(1) NOT NULL |
This field should contain a 1 if the IRS 1099 data being reported on is for the prior year.
|
| 4 |
TRANSMITTER_TIN |
Character(20) |
VARCHAR2(20) NOT NULL |
Transmitter Tax Identification Number used in 1099 reporting
|
| 5 |
TCC |
Character(5) |
VARCHAR2(5) NOT NULL |
Transmitter Control Code is a value the IRS provides submitting 1099 reports.
|
| 6 |
REPLACE_CHAR |
Character(2) |
VARCHAR2(2) NOT NULL |
Replacement Character
|
| 7 |
TEST_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Specifies if the 1099 file to be generated is just a test run.
|
| 8 |
FOREIGN_CORP |
Character(1) |
VARCHAR2(1) NOT NULL |
This field will be 1 if the transmitter is a foreign entity for IRS 1099 reporting.
|
| 9 |
TRANSMITTER_NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Transmitter name used for IRS 1099 Reporting
|
| 10 |
TRANSMITTER_NAME2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Transmitter name for IRS 1099 Reporting
|
| 11 |
COMPANY_NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Company Name 1
|
| 12 |
COMPANY_NAME2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Company Name used for IRS 1099 Reporting
|
| 13 |
COMPANY_ADDRESS |
Character(40) |
VARCHAR2(40) NOT NULL |
Company address used for IRS 1099 Reporting
|
| 14 |
COMPANY_CITY |
Character(40) |
VARCHAR2(40) NOT NULL |
Company city used for IRS 1099 reporting
|
| 15 |
COMPANY_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
Company state used on IRS 1099 report.
|
| 16 |
COMPANY_ZIP |
Character(9) |
VARCHAR2(9) NOT NULL |
Company zip code used for IRS 1099 reporting.
|
| 17 |
TOTAL_PAYEES |
Number(8,0) |
INTEGER NOT NULL |
Total number of payees being reported on the IRS 1099 file
|
| 18 |
CONTACT_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
The individual contact name associated with a given bank/counterparty.
|
| 19 |
CONTACTPHONENBR |
Character(24) |
VARCHAR2(24) NOT NULL |
Integration Server Business Entity Contact Phone Number
|
| 20 |
MAG_TAPE_FILER |
Character(2) |
VARCHAR2(2) NOT NULL |
Specifies if the IRS 1099 file is being submitted on magnetic tape.
|
| 21 |
ELEC_FILE_NAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Electronic file name is only requires for IRS 1099 reporting if the IRS requests that the file be resent.
|
| 22 |
VNDR_SFT_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
2001 IRS Vendor Software Indicator
|
| 23 |
SFT_VNDR_ADDR |
Character(40) |
VARCHAR2(40) NOT NULL |
For IRS 1099 reporting purpose: the software vendor's (PeopleSoft's) address
|
| 24 |
SFT_VNDR_CITY |
Character(40) |
VARCHAR2(40) NOT NULL |
For IRS 1099 Reporting purposes: The vendor software's (PeopleSoft's) city
|
| 25 |
SFT_VNDR_ZIP |
Character(9) |
VARCHAR2(9) NOT NULL |
For IRS 1099 Reporting: the software vendor's (PeopleSoft's) zip code
|
| 26 |
SFT_VNDR_CONTACT |
Character(40) |
VARCHAR2(40) NOT NULL |
For IRS 1099 Reporting: the vendor software's (PeopleSoft's) contact name
|
| 27 |
SFT_VNDR_PHONE |
Character(15) |
VARCHAR2(15) NOT NULL |
For IRS 1099 Reporting: the softwared vendor's (PeopleSoft's) phone
|
| 28 |
SFT_VNDR_EMAIL |
Character(20) |
VARCHAR2(20) NOT NULL |
For IRS 1099 Reporting: the software vendor's (PeopleSoft's) email
|