UNITS_OF_MEASURE
Units of Measure
tableFINUNITS
UNITS_OF_MEASURE — Units of Measure. FIN table in the standard Ross ERP 8.0 schema: 8 columns, used by 365 programs. Columns, data types, keys, foreign keys and relationships.
Open UNITS_OF_MEASURE 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 | UNIT_OF_MEASURE | varchar(4) | PK | Unit of Measure |
| 3 | UNIT_OF_MEASURE_DESC | varchar(20) | Unit of Measure Description | |
| 4 | SYS_EDI_UNIT_CODE | varchar(2) | EDI Unit Code | |
| 5 | IC_QUANTITY_MASK | varchar(20) | A display mask for the quantity. | |
| 6 | IC_DECIMALS | smallint | Number of decimal places | |
| 7 | DC_AI_CODE | varchar(4) | UCC/EAN-128 Application Identifier | |
| 8 | GEM_MODIFY_DATE | datetime | System timestamp of the most recent modification to the row, maintained by GEMBASE. |
Referenced by · 61 foreign keys
MISCELLANEOUS_ADJUSTMENTSAR_CONTROLSCUSTOMERSBT_BID_RESPONSE_LINESBT_BID_RESPONSE_LINESPOP_REQUISITION_LINESPOP_REQUISITION_LINESPRODUCT_MASTERBIN_LOCATIONSAR_CONTROLSAR_CONTROLSGOODS_RECEIVED_LINESGOODS_RECEIVED_LINESGOODS_RECEIVED_LINESIC_PRODUCT_CHARACTERISTICSPRODUCT_MASTERPRODUCT_MASTERBIN_LOCATIONSPRODUCT_WAREHOUSEBIN_LOCATIONSBIN_LOCATION_DETAILSBIN_TYPE_CAPACITY_BY_PARTPRODUCT_MASTER_BY_VENDORPRODUCT_MASTER_BY_VENDORPRODUCT_MASTER_BY_VENDORPRODUCT_MASTERSALES_CREDIT_NOTE_LINESSALES_CREDIT_NOTE_LINESSALES_CREDIT_NOTE_LINESSALES_CREDIT_NOTE_LINESSALES_ORDER_INVOICE_LINESSALES_ORDER_INVOICE_LINESSALES_ORDER_INVOICE_LINESSALES_ORDER_LINESSALES_ORDER_LINESSALES_ORDER_LINESSALES_ORDER_LINESSF_FORECASTING_GROUPSSF_FORECASTING_GROUP_ITEMSSYS_QC_TEST_LIMITSSYS_QC_TEST_CODESTP_DISCOUNT_DETAILSTP_DISCOUNT_DETAILSPART_UOM_CONVERSIONSPRODUCT_MASTERPOP_LINESPURCHASE_INVOICE_LINESPOP_REQUISITION_LINESPRODUCT_MASTERPRODUCT_MASTER_BY_VENDORPOP_LINESPURCHASE_INVOICE_LINESPOP_REQUISITION_LINESPRODUCT_MASTERPRODUCT_MASTERPRODUCT_MASTER_BY_VENDORPART_UOM_CONVERSIONSPOP_LINESPOP_LINESPRODUCT_MASTERBIN_LOCATIONS