PART_BATCHES
Lots
tableFINPART
PART_BATCHES — Lots. FIN table in the standard Ross ERP 8.0 schema: 42 columns, used by 221 programs. Columns, data types, keys, foreign keys and relationships.
Open PART_BATCHES 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 | PART_CODE | varchar(15) | PK | Product |
| 4 | WAREHOUSE | varchar(2) | PK FK→PRODUCT_WAREHOUSE | Warehouse Code |
| 5 | BATCH_TYPE | varchar(1) | Batch Type Indicator | |
| 6 | QTY_COMMITTED_CURRENT | numeric(20,6) | Quantity Committed (current Release) | |
| 7 | QTY_COMMITTED_FORWARD | numeric(20,6) | Quantity Committed Forward | |
| 8 | QTY_COMMITTED_BACK | numeric(20,6) | Quantity Committed on Backorder | |
| 9 | QTY_ORDERED_CURRENT | numeric(20,6) | Quantity on PO - Current | |
| 10 | QTY_ORDERED_FORWARD | numeric(20,6) | Quantity Ordered Forward | |
| 11 | QTY_ORDERED_BACK | numeric(20,6) | Quantity on Puchase BackOrder | |
| 12 | BATCH_DATE | datetime | Batch Date | |
| 13 | UNIT_COST | numeric(20,6) | Unit Cost | |
| 14 | CREATION_DATE | datetime | Creation Date | |
| 15 | STATUS_FLAG | varchar(1) | Status Flag | |
| 16 | PHYS_COUNT_NUMBER | int | Count Number | |
| 17 | COUNT_SEQ_NUMBER | int | Inventory Count Sequence Number | |
| 18 | QTY_RECEIVED | numeric(20,6) | Qty Received | |
| 19 | USERNAME | varchar(20) | Username | |
| 20 | QTY_TRANSIT_IN | numeric(20,6) | Quantity in Transit - Inwards | |
| 21 | QTY_TRANSIT_OUT | numeric(20,6) | Quantity in Transit - Outwards | |
| 22 | BEST_BEFORE_DATE | datetime | Best Before End / Best Before Date | |
| 23 | RECEIVED_DATE | datetime | Received Date | |
| 24 | RELEASE_DATE | datetime | Job Release Date | |
| 25 | IC_LOT_NUMBER | varchar(20) | PK | Lot Number |
| 26 | IC_VENDOR_LOT_NUMBER | varchar(20) | Supplier Lot Number | |
| 27 | IC_RETEST_DATE | datetime | Retest Date | |
| 28 | IC_LAST_MOVEMENT_DATE | datetime | Date of the last movement | |
| 29 | IC_CATCHWEIGHT_AVERAGE | numeric(20,6) | ||
| 30 | IC_LAST_SPOT_COUNT_DATE | datetime | Last Spot Check Count Date | |
| 31 | IC_LAST_CYCLE_COUNT_DATE | datetime | ||
| 32 | IC_LAST_PHYSICAL_COUNT_DATE | datetime | ||
| 33 | LAST_COUNT_DATE | datetime | Last Inventory Count Date | |
| 34 | RCS_CONVERSION_STATUS | varchar(1) | Ren/CS Data Conversion Status | |
| 35 | PA_PROJECT_CODE | varchar(10) | PA Project Code | |
| 36 | PA_WBS_NUMBER | varchar(25) | Project WBS Number | |
| 37 | MANUFACTURING_DATE | datetime | Manufactured Date | |
| 38 | QTY_ORDERED_TOTAL | computed | ||
| 39 | QTY_COMMITTED_TOTAL | computed | ||
| 40 | REWORK_FACTORY | varchar(2) | ||
| 41 | REWORK_JOB | varchar(10) | ||
| 42 | GEM_MODIFY_DATE | datetime | System timestamp of the most recent modification to the row, maintained by GEMBASE. |