VENDORS
Vendors
tableFINVENDORS
VENDORS — Vendors. FIN table in the standard Ross ERP 8.0 schema: 121 columns, used by 286 programs. Columns, data types, keys, foreign keys and relationships.
Open VENDORS 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 | Supplier Number (or ID) |
| 5 | VENDOR_NAME | varchar(60) | Supplier Name | |
| 6 | PHONE | varchar(21) | Phone Number | |
| 7 | TELEX | varchar(20) | Telex No | |
| 8 | REMARK | varchar(30) | Remarks | |
| 9 | PAYMENT_TYPE | varchar(6) | Payment Type | |
| 10 | MISCELLANEOUS_VENDOR | varchar(1) | Miscellaneous Supplier | |
| 11 | TEN99_FLAG | varchar(1) | US 1099 Flag | |
| 12 | TEN99_STATE_ID | varchar(8) | State Identification Code for 1099's | |
| 13 | LAST_PURCHASE_DATE | datetime | Last Purchase Date | |
| 14 | LAST_PURCHASE_AMOUNT | numeric(20,2) | Last Purchase Amount | |
| 15 | LAST_PAYMENT_DATE | datetime | Last Payment Date | |
| 16 | INTEREST_APPLIES | varchar(1) | Interest Applies | |
| 17 | CONTRACT_CODE | varchar(1) | Contract Pricing Allowed | |
| 18 | TAX_CODE | varchar(5) | FK→TAX_CODES | Tax Code |
| 19 | LAST_PERIOD_END | smallint | Last Period End | |
| 20 | STOP_PAYMENT | varchar(8) | FK→STOP_CODES | Stop Payment Flag |
| 21 | PURCHASES_YTD | numeric(20,2) | Purchase Year to Date | |
| 22 | PURCHASES_LY | numeric(20,2) | Purchases Last Year | |
| 23 | TAX_REFERENCE | varchar(20) | Tax Reference | |
| 24 | CREDIT_TERMS_CODE | varchar(6) | FK→CREDIT_TERMS | Credit Terms Code |
| 25 | BALANCE_FORWARD | varchar(1) | Balance Brought Forward Flag | |
| 26 | PAYEE_NUMBER | varchar(12) | Payee Number (or ID) | |
| 27 | SYSTEM_DATE | datetime | System Date Transaction Made | |
| 28 | BALANCE | numeric(20,2) | Balance | |
| 29 | PERIODS_RETAINED_HISTORY | smallint | Number of Periods of Retained Transaction History | |
| 30 | DEFAULT_POSTING_FORMAT | varchar(6) | FK→POSTING_FORMATS | Default Posting Format Code |
| 31 | FAX_NUMBER | varchar(21) | Fax Number | |
| 32 | VENDOR_ANALYSIS_CODE | varchar(6) | Supplier Analysis code | |
| 33 | VENDOR_REFERENCE | varchar(25) | Supplier Reference | |
| 34 | HOLD_PO | varchar(1) | Control Flag on entry of Purchase Orders for Vendor | |
| 35 | VENDOR_CONTACT | varchar(20) | Supplier Contact | |
| 36 | TELEPHONE_EXT | varchar(6) | Telephone Extension | |
| 37 | ORDER_DISCOUNT_GROUP | varchar(6) | FK→POP_VENDOR_DISCOUNT_GROUPS | Order Discount Group |
| 38 | DEFAULT_ADDR | varchar(10) | Default Address Code | |
| 39 | PURCHASE_LEAD_TIME | int | Purchase Order or Warehouse Transfer Lead Time | |
| 40 | LINE_DISCOUNT_GROUP | varchar(6) | FK→POP_VENDOR_DISCOUNT_GROUPS | Line Discount Group |
| 41 | AP_ALPHA_KEY | varchar(10) | Alpha Search Key | |
| 42 | SYS_ADDRESS_1 | varchar(40) | Address Line 1 | |
| 43 | SYS_ADDRESS_2 | varchar(40) | Address Line 2 | |
| 44 | SYS_ADDRESS_3 | varchar(40) | Address Line 3 | |
| 45 | SYS_ADDRESS_4 | varchar(40) | Address Line 4 | |
| 46 | SYS_POSTAL_CODE | varchar(12) | Postal Code | |
| 47 | SYS_CITY | varchar(25) | City | |
| 48 | SYS_COUNTY | varchar(25) | County | |
| 49 | SYS_STATE | varchar(6) | State Code | |
| 50 | SYS_PROVINCE | varchar(6) | Province Code | |
| 51 | SYS_COUNTRY | varchar(6) | Country Code | |
| 52 | SYS_LANGUAGE_CODE | varchar(8) | Language Code | |
| 53 | SYS_SIC_CODE | varchar(8) | FK→SYS_SIC_CODES | SIC Code |
| 54 | SYS_CURRENCY_CODE | varchar(6) | Currency Code | |
| 55 | POP_TOTAL_RECEIPT_TOLERANCE | numeric(20,2) | Total Receipt Value Which has Exceeded Tolerance to Date | |
| 56 | POP_RECEIPT_AMOUNT_TOLERANCE | numeric(20,2) | Receipt Value Tolerance | |
| 57 | POP_RECEIPT_QTY_TOLERANCE | numeric(10,2) | Receipt Quantity Percent Tolerance | |
| 58 | POP_RECEIPT_PRICE_TOLERANCE | numeric(10,2) | Receipt Price Percent Tolerance | |
| 59 | POP_TOTAL_INVOICE_TOLERANCE | numeric(20,2) | Total Invoice Value Which has Exceeded Tolerance to Date | |
| 60 | POP_INVOICE_AMOUNT_TOLERANCE | numeric(20,2) | Invoice Amount Tolerance | |
| 61 | POP_INVOICE_PRICE_TOLERANCE | numeric(10,2) | Invoice Price Percent Tolerance | |
| 62 | POP_MAX_RECEIPT_TOLERANCE | numeric(20,2) | Maximum Receipt Tolerance Allowed | |
| 63 | POP_MAX_INVOICE_TOLERANCE | numeric(20,2) | Maximum Invoice Tolerance Allowed | |
| 64 | POP_VENDOR_CONTACT | varchar(20) | ||
| 65 | POP_TELEPHONE_EXT | varchar(6) | ||
| 66 | SYS_TAX_REFERENCE_BRANCH | varchar(4) | Tax Branch Reference | |
| 67 | SYS_AGENT_IN_USE | varchar(1) | Agent In Use | |
| 68 | SYS_AGENT_TAX_REFERENCE | varchar(20) | Agents Tax Reference | |
| 69 | SYS_AGENT_TAX_REFERENCE_BRANCH | varchar(4) | Agents Tax Branch Reference | |
| 70 | SYS_EC_MODE_OF_TRANSPORT | varchar(1) | EC Mode of Transport | |
| 71 | SYS_EC_DELIVERY_TERMS | varchar(3) | EC Delivery Terms | |
| 72 | ACTIVATION_STATUS | varchar(1) | Activation Status | |
| 73 | POP_I_TOLERANCE_INDIC | varchar(1) | Invoice Tolerance Indicator | |
| 74 | POP_I_TOLERANCE_IN_USE | varchar(1) | Invoice Tolerance Checking In Use | |
| 75 | POP_R_TOLERANCE_INDIC | varchar(1) | Receipt Tolerance Indicator | |
| 76 | POP_R_TOLERANCE_IN_USE | varchar(1) | Receipt Tolerance Checking In Use | |
| 77 | AP_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | AP Full Account for Auto Postings |
| 78 | AP_SHORT_CODE | varchar(6) | FK→GL_SHORT_CODES | Short Code for Auto AP Postings |
| 79 | POP_INVOICE_QTY_TOLERANCE | numeric(10,2) | Invoice Quantity Percent Tolerance | |
| 80 | SYS_ACCRUE_TAX | varchar(1) | Accrue tax | |
| 81 | SYS_MINORITY_CODE | varchar(6) | FK→SYS_MINORITY_CODES | Minority Code |
| 82 | SYS_VENDOR_LOC_CODE | varchar(6) | FK→SYS_VENDOR_LOC_CODES | Supplier Location Code |
| 83 | SYS_TAXABLE_CODE | varchar(1) | Vendor taxable code | |
| 84 | POP_NORMAL_RECEIPT_STATUS | varchar(8) | FK→IC_STATUS_CODES | Normal Inventory Status for Received stock |
| 85 | AP_DRAFT_SHORT_CODE | varchar(6) | FK→GL_SHORT_CODES | Short Code for AP Drafts |
| 86 | AP_DRAFT_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full Account For AP Draft Control |
| 87 | SYS_347_EXCLUDE_FLAG | varchar(1) | ||
| 88 | SYS_347_CODE | varchar(1) | 347 Operation Code | |
| 89 | ACCRUE_IGIC | varchar(1) | Accrue IGIC | |
| 90 | SYS_USER_DEFINED_1 | varchar(25) | User Defined Field 1 | |
| 91 | SYS_USER_DEFINED_2 | varchar(25) | User Defined Field 2 | |
| 92 | SYS_USER_DEFINED_3 | varchar(25) | User Defined Field 3 | |
| 93 | SYS_USER_DEFINED_4 | numeric(20,2) | User Defined Field 4 | |
| 94 | SYS_USER_DEFINED_5 | numeric(20,2) | User Defined Field 5 | |
| 95 | SYS_TAX_ON_CASH | varchar(1) | Tax on Cash | |
| 96 | SYS_TAX_RETAINERS_FLAG | varchar(1) | Tax Retainers Flag | |
| 97 | SYS_TAX_RETAINERS_CODE_1 | varchar(5) | Tax Retainer Code | |
| 98 | SYS_TAX_RETAINERS_CODE_2 | varchar(5) | Tax Retainer Code | |
| 99 | SYS_TAX_RETAINERS_CODE_3 | varchar(5) | Tax Retainer Code | |
| 100 | SYS_TAX_RETAINERS_CODE_4 | varchar(5) | Tax Retainer Code | |
| 101 | TM_SUPPLIER_FLAG | varchar(1) | TM Supplier | |
| 102 | STREAMLINE_UPDATE_FLAG | varchar(1) | Include in Streamlined Update | |
| 103 | ES_INQUIRY_GEM_TRANSACTION_ID | varchar(64) | ||
| 104 | SYS_ISO_LANGUAGE_CODE | varchar(2) | ISO 2-character Language Code | |
| 105 | ADDED_TO_EXTERNAL | varchar(1) | Record has been updated to an external system | |
| 106 | PRICING_METHOD | smallint | Pricing method, tax exclusive or inclusive | |
| 107 | varchar(50) | Email Address | ||
| 108 | SYS_RECEIVING_CALENDAR | varchar(6) | Receiving Calendar Code | |
| 109 | LEGAL_NAME | varchar(70) | Legal Name of Customer | |
| 110 | SYS_EDI_SCAC | varchar(4) | ||
| 111 | PO_EMAIL_DOCUMENT | varchar(1) | ||
| 112 | PO_UPLOAD_DOCUMENT | varchar(1) | ||
| 113 | PO_EXPORT_DOCUMENT | varchar(1) | ||
| 114 | PO_EMAIL_ACCOUNTS | varchar(200) | ||
| 115 | GRN_EMAIL_DOCUMENT | varchar(1) | ||
| 116 | GRN_UPLOAD_DOCUMENT | varchar(1) | ||
| 117 | GRN_EXPORT_DOCUMENT | varchar(1) | ||
| 118 | GRN_EMAIL_ACCOUNTS | varchar(200) | ||
| 119 | DISCONTINUE_FLAG | varchar(1) | Discontinue Master Record | |
| 120 | TW_IN_USE | varchar(1) | MRO Supplier | |
| 121 | GEM_MODIFY_DATE | datetime | System timestamp of the most recent modification to the row, maintained by GEMBASE. |
Referenced by · 30 foreign keys
AP_BATCH_TRAN_LINESAP_VENDOR_DIARYA_TAX_TRANSACTIONSBT_BID_RESPONSESBT_VENDOR_COMMODITY_XREFPOP_REQUISITION_LINESGOODS_RECEIVED_HEADERSPOP_DISCOUNT_LINESPURCHASE_CREDIT_NOTESPURCHASE_REGISTERSYS_VENDOR_SEL_CODE_XREFTAX_TRANSACTIONSTM_CONTAINERSTM_TRANSPORT_ORDERTM_TRANSPORT_ORDERTM_TRANSPORT_SERVICE_RATESTM_TRANSPORT_DEPOTSTM_TRANSPORT_SERVICETM_VEHICLESMANUAL_PAYMENT_LINESVENDOR_ADDRESSESAP_VENDOR_PAYEE_LINKSRECURRING_CHARGE_LINESAP_TRANSACTIONSPURCHASE_INVOICESPRODUCT_MASTER_BY_VENDORPOP_HEADERSPOP_LINESPOP_REQUISITION_LINESPOP_REQUISITION_LINES