DC_PM_MATERIAL_ISSUE_HST

PM Material Issue working table history

tableFINDC

DC_PM_MATERIAL_ISSUE_HST — PM Material Issue working table history. FIN table in the standard Ross ERP 8.0 schema: 27 columns, used by 2 programs. Columns, data types, keys, foreign keys and relationships.

Open DC_PM_MATERIAL_ISSUE_HST in the interactive Data Dictionary →

Part of DC tables & objects · all tables, views & procedures

Columns

#ColumnTypeKeyDescription
1GEM_DBKEYintGEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one.
2DC_TRANSACTION_IDvarchar(64)Data Collection (RF/mobile) transaction identifier for the row.
3COMPANY_CODEvarchar(10)Company Code
4FACTORYvarchar(2)Factory Code
5DC_LICENSE_PLATE_IDvarchar(30)Data Collection License Plate ID
6DC_LICENSE_PLATE_LINEsmallintData Collection License Plate Line
7JOB_NUMBERvarchar(10)Job Number
8PROCESS_STAGEvarchar(6)Process Stage
9RECIPE_LINE_NUMBERsmallintRecipe Line Sequence Number
10PART_CODEvarchar(15)Product
11WAREHOUSEvarchar(2)Warehouse Code
12IC_STATUS_CODEvarchar(8)Inventory Status
13ISSUE_DATEdatetime
14IC_LOT_NUMBERvarchar(20)Lot Number
15BIN_LOCATIONvarchar(15)Bin Location
16MH_NUMBERintMaterial Handling Number
17UOM_1varchar(4)
18QUANTITY_1numeric(20,6)Original Quantity
19UOM_2varchar(4)
20QUANTITY_2numeric(20,6)Original Quantity
21CLOSE_LINEsmallint
22DOC_REFERENCEvarchar(15)Document Reference
23SUBSTITUTE_PARTsmallintSubstitute Product
24RETAIN_COMMITMENTSsmallint
25NON_INVENTORY_PARTsmallint
26NON_INVENTORY_PART_DESCvarchar(30)
27NON_INVENTORY_UNIT_COSTnumeric(20,6)