IC_LOT_TRACE
Lot Trace
tableFINIC
IC_LOT_TRACE — Lot Trace. FIN table in the standard Ross ERP 8.0 schema: 26 columns, used by 19 programs. Columns, data types, keys, foreign keys and relationships.
Open IC_LOT_TRACE in the interactive Data Dictionary →Part of IC 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 | IC_LT_FROM_INDICATOR | varchar(8) | PK | Lot Trace From Source |
| 4 | IC_LT_FROM_DIV_WH_FA | varchar(2) | PK | |
| 5 | IC_LT_FROM_DOC_PART_JOB | varchar(15) | PK | Lot Trace From Product/Document/Job |
| 6 | IC_LT_FROM_LINE_LOT_STAGE | varchar(20) | PK | |
| 7 | IC_LT_FROM_DOCSEQ_LOTSEQ_LINE | int | PK | |
| 8 | IC_LT_FROM_STATUS | varchar(8) | PK | |
| 9 | IC_LT_TO_INDICATOR | varchar(8) | PK | Lot Trace To Source |
| 10 | IC_LT_TO_DIV_WH_FA | varchar(2) | PK | |
| 11 | IC_LT_TO_DOC_PART_JOB | varchar(15) | PK | Lot Trace To Prod/Document/Job |
| 12 | IC_LT_TO_LINE_LOT_STAGE | varchar(20) | PK | |
| 13 | IC_LT_TO_DOCSEQ_LOTSEQ_LINE | int | PK | |
| 14 | IC_LT_TO_STATUS | varchar(8) | PK | |
| 15 | SOURCE_MODULE | varchar(2) | Source Module Reference | |
| 16 | DESCRIPTION | varchar(30) | Description | |
| 17 | TRANSACTION_TYPE | varchar(2) | Transaction Type | |
| 18 | MOVEMENT_CODE | varchar(6) | Movement Code | |
| 19 | SYSTEM_DATE | datetime | System Date Transaction Made | |
| 20 | TRANSACTION_DATE | datetime | Transaction Date | |
| 21 | IC_MOVE_QUANTITY_1 | numeric(20,6) | Inventory movement quantity | |
| 22 | UNIT_OF_MEASURE_1 | varchar(4) | Unit of Measure | |
| 23 | IC_MOVE_QUANTITY_2 | numeric(20,6) | Inventory movement quantity | |
| 24 | UNIT_OF_MEASURE_2 | varchar(4) | Unit of Measure | |
| 25 | GEM_TRANSACTION_ID | varchar(64) | System transaction identifier stamped by GEMBASE when the row was written. | |
| 26 | GEM_ARCHIVE_FLAG | varchar(20) | System flag indicating whether the row has been archived by the GEMBASE archive process. |