IC_MSDS_ITEM_CODE_LINES

MSDS Item Code Lines

tableFINIC

IC_MSDS_ITEM_CODE_LINES — MSDS Item Code Lines. FIN table in the standard Ross ERP 8.0 schema: 3 columns, used by 6 programs. Columns, data types, keys, foreign keys and relationships.

Open IC_MSDS_ITEM_CODE_LINES in the interactive Data Dictionary →

Part of IC 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.
2IC_MSDS_ITEM_CODEvarchar(10)PK FK→IC_MSDS_ITEM_CODESMSDS Item Code
3IC_MSDS_STATEMENT_CODEvarchar(10)PKMSDS Statement Code

Referenced by views / procedures · 1

IC_MSDS_STATEMENT_LS