IC tables & objects
100 Object
IC tables & objects — 100 object in the standard vanilla Ross ERP 8.0 IC · FIN.
| Object | Name | Description |
|---|---|---|
| A_IC_BIN_MOVEMENTS | Archived All quantity changes affecting bins | table · FIN · 33 columns |
| A_IC_MOVEMENTS | Archived All quantity changes | table · FIN · 43 columns |
| A_IC_QUALITY_DOCS | Archived Quality Document Header | table · FIN · 35 columns |
| A_IC_QUALITY_DOC_LINES | Archived Quality Document Lines | table · FIN · 23 columns |
| A_IC_QUALITY_DOC_LINE_DETAILS | Archived Quality Document Line Details | table · FIN · 23 columns |
| A_IC_WH_XFER_LANDED_COSTS | Archive Landed Cost for Warehouse Transfer | table · FIN · 17 columns |
| IC_ATP_DEFAULT_SOURCES | Default sources for ATP | table · FIN · 3 columns |
| IC_ATP_EXCEPTIONS | Available to Promise Exceptions | table · FIN · 22 columns |
| IC_ATP_INPUTS | Available to Promise_Inputs | table · FIN · 19 columns |
| IC_ATP_SOURCES | Sources of Inventory for the ATP system | table · FIN · 5 columns |
| IC_BALANCE_QUERY_HEADERS | Balance Query Header information | table · FIN · 10 columns |
| IC_BALANCE_QUERY_LINES | Balance Query result lines | table · FIN · 23 columns |
| IC_BIN_DETAIL_STATUS | Bin Location Detail Status | table · FIN · 16 columns |
| IC_BIN_MOVEMENTS | All quantity changes affecting bins | table · FIN · 31 columns |
| IC_CONTROLS | Inventory Costing Division Control | table · FIN · 9 columns |
| IC_COSTING_TYPES | Costing types | table · FIN · 10 columns |
| IC_COST_HISTORY_TYPE | Cost History Types | table · FIN · 3 columns |
| IC_COUNT_DEFER_LIST | IC Count Defer List | table · FIN · 7 columns |
| IC_COUNT_LISTS | Inventory Count Lists | table · FIN · 36 columns |
| IC_COUNT_LISTS_HISTORY | Inventory Count Lists History | table · FIN · 37 columns |
| IC_COUNT_REASON_CODES | Count Deferral or Cancellation Reason Codes | table · FIN · 4 columns |
| IC_COUNT_STATUS_CODES | Count Status Codes | table · FIN · 3 columns |
| IC_COUNT_SUMMARY | Inventory Count Summary | table · FIN · 22 columns |
| IC_DEMAND_SUPPLY | Actual Demand and Supply data | table · FIN · 25 columns |
| IC_DOCUMENTS_TEMPORARY_XREF | IC Transaction Documents Cross Reference Table | table · FIN · 17 columns |
| IC_INGREDIENT_CLASS_MSDS_ITEMS | Ingredient Class MSDS Items | table · FIN · 10 columns |
| IC_INGREDIENT_MSDS_ITEMS | Ingredient MSDS Items | table · FIN · 11 columns |
| IC_LOTS | Lot availability and expiry | view · FIN |
| IC_LOT_AUDIT | Lot Audit | table · FIN · 17 columns |
| IC_LOT_CHARACTERISTICS | Lot Characteristics | table · FIN · 10 columns |
| IC_LOT_CHARACTERISTICS_AUDIT | Lot Characteristics Audit | table · FIN · 14 columns |
| IC_LOT_STATUS | Lot Quantity Status | table · FIN · 16 columns |
| IC_LOT_TRACE | Lot Trace | table · FIN · 26 columns |
| IC_MM_PART_XREF | A Cross-Reference for Ross ERP part codes with OEM/Manufactu | table · FIN · 6 columns |
| IC_MOVEMENTS | All quantity changes | table · FIN · 44 columns |
| IC_MOVEMENTS_WAC_BY_PERIOD | Archive product unit cost | table · FIN · 10 columns |
| IC_MSDS_FIELD_XREF | MSDS Field Cross Reference | table · FIN · 5 columns |
| IC_MSDS_FORMATS | MSDS Formats | table · FIN · 7 columns |
| IC_MSDS_FORMAT_CODES | MSDS Format Codes | table · FIN · 10 columns |
| IC_MSDS_FORMAT_ITEMS | MSDS Format Items | table · FIN · 11 columns |
| IC_MSDS_FORMAT_ITEM_STRUCTURES | MSDS Format Item Structures | table · FIN · 8 columns |
| IC_MSDS_FORMAT_SECTIONS | MSDS Format Sections | table · FIN · 5 columns |
| IC_MSDS_HAZARDOUS_INGREDIENTS | MSDS Hazardous Ingredients | table · FIN · 5 columns |
| IC_MSDS_ITEM_CODES | MSDS Item Codes | table · FIN · 12 columns |
| IC_MSDS_ITEM_CODE_LINES | MSDS Item Code Lines | table · FIN · 3 columns |
| IC_MSDS_ITEM_PROMPTS | MSDS Item Prompts | table · FIN · 5 columns |
| IC_MSDS_METADATA | MSDS Metadata for field prompts, headings and help text | table · FIN · 4 columns |
| IC_MSDS_REASONS_LANGUAGE | MSDS Reasons Language | table · FIN · 5 columns |
| IC_MSDS_REASON_CODES | MSDS Reason Codes | table · FIN · 4 columns |
| IC_MSDS_SECTIONS_LANGUAGE | MSDS Section Codes Language | table · FIN · 4 columns |
| IC_MSDS_SECTION_CODES | MSDS Section Codes | table · FIN · 3 columns |
| IC_MSDS_STATEMENTS_LANGUAGE | MSDS Statements Language | table · FIN · 5 columns |
| IC_MSDS_STATEMENT_CODES | MSDS Statement Codes | table · FIN · 4 columns |
| IC_MSDS_STATEMENT_LS | MSDS Statement LS View | view · FIN |
| IC_PART_PERIOD_END_STATUS | Period End Controls Status | table · FIN · 21 columns |
| IC_PART_PERIOD_END_STATUS_LOT | Period End Controls Status At Lot Level | table · FIN · 18 columns |
| IC_PERIOD_END_BAL | Inventory Closing Balance(FIFO,LIFO) | table · FIN · 42 columns |
| IC_PERIOD_INVENTORY | Period Inventory | table · FIN · 45 columns |
| IC_PLANNED_WH_XFER_CONTROL | WMS WH Transfer - Planned WH Transfer Headers | table · FIN · 17 columns |
| IC_PLANNED_WH_XFER_LINES | WMS WH Transfers - Planned WH Transfer Lines | table · FIN · 25 columns |
| IC_PRODUCT_AUDIT | table · FIN · 11 columns | |
| IC_PRODUCT_CHARACTERISTICS | Characteristics enabled for products | table · FIN · 12 columns |
| IC_PRODUCT_CLASS_LANGUAGE | Product Class Language | table · FIN · 5 columns |
| IC_PRODUCT_CLASS_MSDS | Product Classes MSDS | table · FIN · 8 columns |
| IC_PRODUCT_CLASS_MSDS_ITEMS | Product Class MSDS Items | table · FIN · 10 columns |
| IC_PRODUCT_MASTER_UNITS | Product Master Units of Measure | table · FIN · 11 columns |
| IC_PRODUCT_MSDS | Product MSDS | table · FIN · 8 columns |
| IC_PRODUCT_MSDS_AUDIT | Product MSDS Audit | table · FIN · 11 columns |
| IC_PRODUCT_MSDS_ITEMS | Product MSDS Items | table · FIN · 10 columns |
| IC_PRODUCT_MSDS_LANGUAGE | Product MSDS Language | table · FIN · 9 columns |
| IC_PRODUCT_STATUS | Product Status Quantities | table · FIN · 15 columns |
| IC_PRODUCT_UOM_CONTROL_CODES | Valid product UOM controls. System table for description | table · FIN · 3 columns |
| IC_PRODUCT_UOM_TYPES | Valid product UOM types. System table for description. | table · FIN · 3 columns |
| IC_PROD_WAREHOUSE_BY_STATUS | Holds Days to QOH | table · FIN · 6 columns |
| IC_PROMISE_DETAILS | ATP Promise Details | table · FIN · 20 columns |
| IC_QUALITY_DOCS | Quality Document Header | table · FIN · 32 columns |
| IC_QUALITY_DOC_LINES | Quality Document Lines | table · FIN · 21 columns |
| IC_QUALITY_DOC_LINE_DETAILS | Quality Document Line Details | table · FIN · 21 columns |
| IC_RECEIPT_ISSUE_TYPES | Inventory Receipt/Issue Types | table · FIN · 3 columns |
| IC_SPECIFICATION_LIMITS | Specification Limits | table · FIN · 9 columns |
| IC_STATUS_CODES | Inventory Status Codes | table · FIN · 9 columns |
| IC_STD_COST_HISTORY | Standard Cost History Table | table · FIN · 44 columns |
| IC_STD_LOT_COST_HISTORY | table · FIN · 44 columns | |
| IC_TRANSACTION_TYPES | IC Transaction Types | table · FIN · 9 columns |
| IC_WH_XFER_LANDED_COSTS | Landed Cost for Inventory Transfer | table · FIN · 14 columns |
| IC_WORK_CALCULATION | Inventory Costing Work Calculation | table · FIN · 43 columns |
| IC_WORK_CALC_RETURNS | Inventory Costing Work Calc for Returns | table · FIN · 42 columns |
| IC_WORK_CLOSE_BALANCE | Inventory Costing Work Closing Balance | table · FIN · 45 columns |
| IC_WORK_DAILY_BALANCE | Inventory Costing Work Daily Balance | table · FIN · 43 columns |
| IC_WORK_MOVEMENTS | Inventory Costing Work Movements | table · FIN · 45 columns |
| IC_WORK_OPEN_BALANCE | Inventory Costing Work Opening Balance | table · FIN · 43 columns |
| IC_WTVOL_FROM_CONTROL_CODES | Valid weight/volume control codes. System for description | table · FIN · 3 columns |
| IC_XREF_INGRED_MSDS_REASONS | Ingredient MSDS Reasons Cross Reference | table · FIN · 9 columns |
| IC_XREF_INGRED_MSDS_STATEMENTS | Ingredient MSDS Statements Cross Reference | table · FIN · 9 columns |
| IC_XREF_PRDCLS_MSDS_STATEMTS | MSDS Product Class Statement Codes | table · FIN · 9 columns |
| IC_XREF_PRODCLASS_MSDS_REASONS | Product Class MSDS Reasons Cross Reference | table · FIN · 9 columns |
| IC_XREF_PRODUCT_MSDS_ITEMS | Product MSDS Items Cross Reference | table · FIN · 8 columns |
| IC_XREF_PRODUCT_MSDS_REASONS | Product MSDS Reasons Cross Reference | table · FIN · 8 columns |
| IC_XREF_PROD_CLASS_MSDS_ITEMS | Product Class MSDS Items Cross Reference | table · FIN · 8 columns |
| IC_XREF_PROD_MSDS_STATEMENTS | MSDS Statement Codes | table · FIN · 8 columns |