AP_TEN99_FORMATS
AP 1099 Formats for AP 1099-MISC non-Crystal Reports
tableFINAP
AP_TEN99_FORMATS — AP 1099 Formats for AP 1099-MISC non-Crystal Reports. FIN table in the standard Ross ERP 8.0 schema: 76 columns, used by 5 programs. Columns, data types, keys, foreign keys and relationships.
Open AP_TEN99_FORMATS in the interactive Data Dictionary →Part of AP tables & objects · all tables, views & procedures
Columns
| # | Column | Type | Key | Description |
|---|---|---|---|---|
| 1 | GEM_DBKEY | int | GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one. | |
| 2 | TEN99_FORMAT | varchar(8) | PK | Ten99 Format Code |
| 3 | CODE_DESCRIPTION | varchar(30) | Code Description | |
| 4 | START_ROW | varchar(2) | ||
| 5 | START_COLUMN | varchar(3) | Start Column | |
| 6 | LINES_PER_PAGE | varchar(2) | ||
| 7 | LINES_BETWEEN_FORMS | varchar(2) | ||
| 8 | PAYER_NAME_ROW | varchar(2) | ||
| 9 | PAYER_NAME_COLUMN | varchar(3) | ||
| 10 | PAYER_NAME_LENGTH | varchar(2) | ||
| 11 | PAYER_ADDRESS_ROW | varchar(2) | ||
| 12 | PAYER_ADDRESS_COLUMN | varchar(3) | ||
| 13 | PAYER_ADDRESS_LENGTH | varchar(2) | ||
| 14 | PAYER_CITY_ROW | varchar(2) | ||
| 15 | PAYER_CITY_COLUMN | varchar(3) | ||
| 16 | PAYER_CITY_LENGTH | varchar(2) | ||
| 17 | PAYER_PHONE_ROW | varchar(2) | ||
| 18 | PAYER_PHONE_COLUMN | varchar(3) | ||
| 19 | PAYER_PHONE_LENGTH | varchar(2) | ||
| 20 | FEDERAL_ID_ROW | varchar(2) | ||
| 21 | FEDERAL_ID_COLUMN | varchar(3) | ||
| 22 | FEDERAL_ID_LENGTH | varchar(2) | ||
| 23 | RECIPIENT_ID_ROW | varchar(2) | ||
| 24 | RECIPIENT_ID_COLUMN | varchar(3) | ||
| 25 | RECIPIENT_ID_LENGTH | varchar(2) | ||
| 26 | RECIPIENT_NAME_ROW | varchar(2) | ||
| 27 | RECIPIENT_NAME_COLUMN | varchar(3) | ||
| 28 | RECIPIENT_NAME_LENGTH | varchar(2) | ||
| 29 | RECIPIENT_ADDRESS_ROW | varchar(2) | ||
| 30 | RECIPIENT_ADDRESS_COLUMN | varchar(3) | ||
| 31 | RECIPIENT_ADDRESS_LENGTH | varchar(2) | ||
| 32 | RECIPIENT_CITY_ROW | varchar(2) | ||
| 33 | RECIPIENT_CITY_COLUMN | varchar(3) | ||
| 34 | RECIPIENT_CITY_LENGTH | varchar(2) | ||
| 35 | BOX1_IN_USE | varchar(1) | ||
| 36 | BOX1_ROW | varchar(2) | ||
| 37 | BOX1_COLUMN | varchar(3) | ||
| 38 | BOX2_IN_USE | varchar(1) | ||
| 39 | BOX2_ROW | varchar(2) | ||
| 40 | BOX2_COLUMN | varchar(3) | ||
| 41 | BOX3_IN_USE | varchar(1) | ||
| 42 | BOX3_ROW | varchar(2) | ||
| 43 | BOX3_COLUMN | varchar(3) | ||
| 44 | BOX4_IN_USE | varchar(1) | ||
| 45 | BOX4_ROW | varchar(2) | ||
| 46 | BOX4_COLUMN | varchar(3) | ||
| 47 | BOX5_IN_USE | varchar(1) | ||
| 48 | BOX5_ROW | varchar(2) | ||
| 49 | BOX5_COLUMN | varchar(3) | ||
| 50 | BOX6_IN_USE | varchar(1) | ||
| 51 | BOX6_ROW | varchar(2) | ||
| 52 | BOX6_COLUMN | varchar(3) | ||
| 53 | BOX7_IN_USE | varchar(1) | ||
| 54 | BOX7_ROW | varchar(2) | ||
| 55 | BOX7_COLUMN | varchar(3) | ||
| 56 | BOX8_IN_USE | varchar(1) | ||
| 57 | BOX8_ROW | varchar(2) | ||
| 58 | BOX8_COLUMN | varchar(3) | ||
| 59 | BOX9_IN_USE | varchar(1) | ||
| 60 | BOX9_ROW | varchar(2) | ||
| 61 | BOX9_COLUMN | varchar(3) | ||
| 62 | BOX10_IN_USE | varchar(1) | ||
| 63 | BOX10_ROW | varchar(2) | ||
| 64 | BOX10_COLUMN | varchar(3) | ||
| 65 | BOX13_IN_USE | varchar(1) | ||
| 66 | BOX13_ROW | varchar(2) | ||
| 67 | BOX13_COLUMN | varchar(3) | ||
| 68 | BOX14_IN_USE | varchar(1) | ||
| 69 | BOX14_ROW | varchar(2) | ||
| 70 | BOX14_COLUMN | varchar(3) | ||
| 71 | BOX15A_IN_USE | varchar(1) | ||
| 72 | BOX15A_ROW | varchar(2) | ||
| 73 | BOX15A_COLUMN | varchar(3) | ||
| 74 | BOX15B_IN_USE | varchar(1) | ||
| 75 | BOX15B_ROW | varchar(2) | ||
| 76 | BOX15B_COLUMN | varchar(3) |