VENDOR_ADDRESSES
Vendor Addresses
tableFINVENDOR
VENDOR_ADDRESSES — Vendor Addresses. FIN table in the standard Ross ERP 8.0 schema: 48 columns, used by 55 programs. Columns, data types, keys, foreign keys and relationships.
Open VENDOR_ADDRESSES in the interactive Data Dictionary →Part of Other 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 | COMPANY_CODE | varchar(10) | PK | Company Code |
| 3 | AP_DIVISION | varchar(2) | PK FK→AP_CONTROLS | Division |
| 4 | VENDOR_NUMBER | varchar(12) | PK FK→VENDORS | Supplier Number (or ID) |
| 5 | ADDRESS_CODE | varchar(10) | PK | Address Code |
| 6 | VENDOR_NAME | varchar(60) | Supplier Name | |
| 7 | PHONE | varchar(21) | Phone Number | |
| 8 | TELEX | varchar(20) | Telex No | |
| 9 | REMARK | varchar(30) | Remarks | |
| 10 | FAX_NUMBER | varchar(21) | Fax Number | |
| 11 | SHIPPING_TERMS_CODE | varchar(8) | FK→POP_SHIPPING_TERMS | Shipping Terms Code |
| 12 | FREIGHT_CODE | varchar(8) | FK→POP_FREIGHT_CODES | Company wide Freight code to indicate a carrier |
| 13 | SYS_ADDRESS_1 | varchar(40) | Address Line 1 | |
| 14 | SYS_ADDRESS_2 | varchar(40) | Address Line 2 | |
| 15 | SYS_ADDRESS_3 | varchar(40) | Address Line 3 | |
| 16 | SYS_ADDRESS_4 | varchar(40) | Address Line 4 | |
| 17 | SYS_POSTAL_CODE | varchar(12) | Postal Code | |
| 18 | SYS_CITY | varchar(25) | City | |
| 19 | SYS_COUNTY | varchar(25) | County | |
| 20 | SYS_STATE | varchar(6) | State Code | |
| 21 | SYS_PROVINCE | varchar(6) | Province Code | |
| 22 | SYS_COUNTRY | varchar(6) | Country Code | |
| 23 | SYS_LANGUAGE_CODE | varchar(8) | Language Code | |
| 24 | TAX_REFERENCE | varchar(20) | Tax Reference | |
| 25 | SYS_TAX_REFERENCE_BRANCH | varchar(4) | Tax Branch Reference | |
| 26 | SYS_EC_MODE_OF_TRANSPORT | varchar(1) | EC Mode of Transport | |
| 27 | SYS_EC_DELIVERY_TERMS | varchar(3) | EC Delivery Terms | |
| 28 | SYS_EC_TRANSACTION_TYPE | varchar(2) | EC Nature of Transaction | |
| 29 | ACTIVATION_STATUS | varchar(1) | Activation Status | |
| 30 | SYS_EC_FACTOR | numeric(10,4) | EC Factor | |
| 31 | SYS_TRADING_PARTNER_CODE | varchar(6) | Trading Partner Code | |
| 32 | SYS_EDI_ENTITY_ID_QUAL | varchar(2) | EDI Entity ID Qualifier | |
| 33 | SYS_EDI_ENTITY_ID | varchar(20) | EDI Entity ID | |
| 34 | SYS_USER_DEFINED_1 | varchar(25) | User Defined Field 1 | |
| 35 | SYS_USER_DEFINED_2 | varchar(25) | User Defined Field 2 | |
| 36 | SYS_USER_DEFINED_3 | varchar(25) | User Defined Field 3 | |
| 37 | SYS_USER_DEFINED_4 | numeric(20,2) | User Defined Field 4 | |
| 38 | SYS_USER_DEFINED_5 | numeric(20,2) | User Defined Field 5 | |
| 39 | GEM_TRANSACTION_ID | varchar(64) | System transaction identifier stamped by GEMBASE when the row was written. | |
| 40 | SYS_ISO_LANGUAGE_CODE | varchar(2) | ISO 2-character Language Code | |
| 41 | SEND_TO_EXTERNAL | varchar(1) | Send to an external system in next update transaction | |
| 42 | ADDED_TO_EXTERNAL | varchar(1) | Record has been updated to an external system | |
| 43 | varchar(50) | Email Address | ||
| 44 | SYS_RECEIVING_CALENDAR | varchar(6) | Receiving Calendar Code | |
| 45 | LEGAL_NAME | varchar(70) | Legal Name of Customer | |
| 46 | TW_STATUS | varchar(1) | Ross TabWare Send Flag | |
| 47 | CARRIER_ID | varchar(10) | Carrier ID | |
| 48 | SHIP_INFO_CODE | varchar(8) | Carrier Information Code |