PRODUCT_MASTER_BY_VENDOR
Product Master By Vendor
tableFINPRODUCT
PRODUCT_MASTER_BY_VENDOR — Product Master By Vendor. FIN table in the standard Ross ERP 8.0 schema: 39 columns, used by 59 programs. Columns, data types, keys, foreign keys and relationships.
Open PRODUCT_MASTER_BY_VENDOR in the interactive Data Dictionary →Part of PRODUCT 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 | PART_CODE | varchar(15) | PK FK→PRODUCT_MASTER | Product |
| 4 | VENDOR_NUMBER | varchar(12) | PK | Supplier Number (or ID) |
| 5 | VENDORS_PART_CODE | varchar(20) | Suppliers Product Code | |
| 6 | DIVISION | varchar(2) | PK FK→VENDORS | Division |
| 7 | DESCRIPTION | varchar(30) | Description | |
| 8 | LAST_COST | numeric(20,4) | Last Cost | |
| 9 | STANDARD_COST | numeric(20,6) | Standard Cost | |
| 10 | OEM_PART_CODE | varchar(20) | Original Equipment Manufacturers Part Code | |
| 11 | DETAIL_DESCRIPTION | text | Detailed Description | |
| 12 | PURCHASE_LEAD_TIME | int | Purchase Order or Warehouse Transfer Lead Time | |
| 13 | UNIT_SUPPLIER | varchar(4) | FK→UNITS_OF_MEASURE | Unit of Measure (Suppliers) |
| 14 | POP_RECEIPT_AMOUNT_TOLERANCE | numeric(20,2) | Receipt Value Tolerance | |
| 15 | POP_RECEIPT_QTY_TOLERANCE | numeric(10,2) | Receipt Quantity Percent Tolerance | |
| 16 | POP_RECEIPT_PRICE_TOLERANCE | numeric(10,2) | Receipt Price Percent Tolerance | |
| 17 | POP_INVOICE_AMOUNT_TOLERANCE | numeric(20,2) | Invoice Amount Tolerance | |
| 18 | POP_INVOICE_PRICE_TOLERANCE | numeric(10,2) | Invoice Price Percent Tolerance | |
| 19 | POP_TOTAL_RECEIPT_TOLERANCE | numeric(20,2) | Total Receipt Value Which has Exceeded Tolerance to Date | |
| 20 | POP_TOTAL_INVOICE_TOLERANCE | numeric(20,2) | Total Invoice Value Which has Exceeded Tolerance to Date | |
| 21 | POP_MAX_RECEIPT_TOLERANCE | numeric(20,2) | Maximum Receipt Tolerance Allowed | |
| 22 | POP_MAX_INVOICE_TOLERANCE | numeric(20,2) | Maximum Invoice Tolerance Allowed | |
| 23 | SYS_CURRENCY_CODE | varchar(6) | Currency Code | |
| 24 | POP_R_TOLERANCE_IN_USE | varchar(1) | Receipt Tolerance Checking In Use | |
| 25 | POP_I_TOLERANCE_IN_USE | varchar(1) | Invoice Tolerance Checking In Use | |
| 26 | POP_INVOICE_QTY_TOLERANCE | numeric(10,2) | Invoice Quantity Percent Tolerance | |
| 27 | PURCHASE_COST | numeric(20,4) | Purchase Cost | |
| 28 | UNIT_PUR | varchar(4) | FK→UNITS_OF_MEASURE | Purchase/Transfer Unit Of Measure |
| 29 | SYS_EDI_VENDOR_PART_QUAL | varchar(4) | EDI Product Code Qualifier | |
| 30 | POP_NOMINATED_UNIT | varchar(4) | FK→UNITS_OF_MEASURE | Inventory unit which Purchase unit converts to |
| 31 | POP_UNIT_PRICE | varchar(4) | FK→UNITS_OF_MEASURE | Unit of Measure (Purchase Price) |
| 32 | POP_NOMINATED_PRICE_UNIT | varchar(4) | FK→UNITS_OF_MEASURE | Inventory unit which Purchase Price unit converts to |
| 33 | POP_NORMAL_RECEIPT_STATUS | varchar(8) | FK→IC_STATUS_CODES | Normal Inventory Status for Received stock |
| 34 | UOM_TEXT | varchar(20) | UOM Text | |
| 35 | SYS_QC_RESULTS_GROUP | varchar(6) | QC Test Results Group | |
| 36 | GEM_TRANSACTION_ID | varchar(64) | System transaction identifier stamped by GEMBASE when the row was written. | |
| 37 | PURCHASE_COST_INC_TAX | numeric(20,4) | Purchase Cost Including Tax | |
| 38 | SYS_COUNTRY_OF_ORIGIN | varchar(6) | ||
| 39 | EAN_NUMBER | varchar(15) | GTIN |