Inventory Control – Lawson IC tables and programs
Inventory Control (IC) in Lawson S3 v10 MSP6 has 101 tables, 190 online screens and 148 batch programs.
Tables (101)
| Table | Prefix | Description | Primary key | Fields |
|---|---|---|---|---|
| BINGROUP | BGR | Bin Group | COMPANY, LOCATION, BIN-GROUP | 5 |
| BINGRPDTL | BGD | Bin Group Detail | COMPANY, LOCATION, BIN-GROUP, BIN-SEQ | 5 |
| BINSTORAGE | BST | Bin Storage Code | COMPANY, LOCATION, STORAGE-CODE | 10 |
| CNTBOD | IBG | No description in the Lawson data dictionary | COMPANY, LOCATION, ITEM | 9 |
| COMMCODES | ISC | No description in the Lawson data dictionary | ITEM-GROUP, COMMODITY-CODE | 4 |
| COMMSTRUCT | CCS | No description in the Lawson data dictionary | COMM-STRUCTURE | 6 |
| COMPONENT | COM | User Field | ITEM-GROUP, COMPANY, LOCATION, KIT-ITEM, SEQ, OPT-SEQ | 23 |
| GLNLOC | GLO | No description in the Lawson data dictionary | ITEM-GROUP, GLN-NBR | 5 |
| GLNLOCDTL | GLX | No description in the Lawson data dictionary | ITEM-GROUP, GLN-NBR, GLN-TYPE, SEQUENCE | 12 |
| HAZARD | HAZ | Hazard Code | ITEM-GROUP, HAZARD-CODE | 5 |
| HCCHRGITEM | HCI | Charge Item | COMPANY, REV-CENTER, CHARGE-NBR, ITEM | 7 |
| HCHPPAUDIT | HPA | No description in the Lawson data dictionary | COMPANY, REQ-NUMBER, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, DATE, TIME, FLD-NBR | 15 |
| HCPATCHRG | HPR | Patient Charge | COMPANY, VISIT-NBR, REV-CENTER, FROM-LOCATION, DATE-OF-CHRG, ITEM, CHARGE-SEQ | 15 |
| HCPATIENT | HPT | Patient | COMPANY, PATIENT-ID | 9 |
| HCPATPROC | HPP | No description in the Lawson data dictionary | OBJ-ID | 22 |
| HCPATVISIT | HPV | Patient Visit | COMPANY, VISIT-NBR | 14 |
| HCPCS | HCC | No description in the Lawson data dictionary | HCPCS-CODE, SEQ-NBR | 5 |
| HCPRCCLASS | HPC | Price Class | ITEM-GROUP, PRICE-CLASS, COST-LIMIT | 8 |
| ICACCURACY | ACC | Inventory Accuracy Statistics | COMPANY, LOCATION, YEAR, PERIOD, REASON-CODE | 13 |
| ICACTIVITY | IAC | Pre-Released Document Header | COMPANY, LOCATION, DOC-TYPE, DOCUMENT | 16 |
| ICAUDIT | IAU | Item/Item Location Audit | ITEM-GROUP, COMPANY, LOCATION, ITEM, GL-CATEGORY, DATE, TIME, FLD-NBR | 15 |
| ICBIN | ICB | Bin Numbers | COMPANY, LOCATION, BIN | 12 |
| ICBRDNTMPL | IBT | Burden Template | COMPANY, LOCATION, BURDEN-CODE | 20 |
| ICCATEGORY | ICA | GL Account Category | COMPANY, LOCATION, GL-CATEGORY | 33 |
| ICCOMPANY | ICC | Inventory Company Information | COMPANY | 86 |
| ICCPHYINV | IPI | Physical Inventory | COMPANY, SELECT-ID, LOCATION, ITEM, SEQ-TRNS-NBR | 16 |
| ICCTRNDTL | ITJ | Inventory Detail Adjustment | COMPANY, LOCATION, RECRD-TYPE, DOC-TYPE, DOCUMENT, LINE-NBR, SEQ | 16 |
| ICCTRNHDR | ITH | Inventory Adjustment | COMPANY, LOCATION, RECRD-TYPE, DOC-TYPE, DOCUMENT | 19 |
| ICCTRNLIN | ITI | Inventory Line Adjustment | COMPANY, LOCATION, RECRD-TYPE, DOC-TYPE, DOCUMENT, LINE-NBR | 30 |
| ICDICT | IDI | Item/Item Location Dictionary | FLD-NBR | 8 |
| ICFACILITY | FAC | Ship To Facility | ITEM-GROUP, ST-FACILITY, COMPANY, FACILITY-LOC | 6 |
| ICFGBRDN | IBR | Finished Goods Burden | COMPANY, LOCATION, ITEM, SEQ | 14 |
| ICFGBYPROD | ICP | Finished Goods Byproduct | COMPANY, LOCATION, FG-ITEM, SEQ | 6 |
| ICFORECAST | IFO | Inventory Forecast | COMPANY, LOCATION, ITEM, FORECAST-YEAR, FORECAST-NBR, QUARTER | 8 |
| ICFREEZE | ICF | Physical Inven Freeze Record | COMPANY, SELECT-ID, PAGE, LINE | 22 |
| ICFRREXP | IFX | No description in the Lawson data dictionary | COMPANY, SYSTEM-CD, LOCATION, DOC-TYPE, DOC-NUMBER, DOC-NBR-NUM, PO-CODE, LINE-NBR, COMPONENT-SEQ, AOC-CODE, LINE-SEQ, REQ-LOCATION, API-OBJ-ID | 31 |
| ICGENERIC | ICG | Generic Name | ITEM-GROUP, GENERIC | 3 |
| ICHCIAUDIT | HIA | No description in the Lawson data dictionary | COMPANY, REV-CENTER, CHARGE-NBR, ITEM, DATE, TIME, FLD-NBR | 12 |
| ICHISTORY | ICH | Transaction History | COMPANY, LOCATION, ITEM, YEAR, QUARTER | 23 |
| ICICDUF | UFD | No description in the Lawson data dictionary | COMPANY, LOCATION, DOC-TYPE, SYSTEM-CD, DOCUMENT, SHIPMENT-NBR, LINE-NBR, COMPONENT-SEQ, TRANS-SEQ | 14 |
| ICICLAUDIT | ILA | The IC Location Audit table is created as a result of choosing the audit option in IC01.1 (IC Company). | COMPANY, LOCATION, SYSTEM-CD, SEQ, DATE, TIME, FLD-NBR | 11 |
| ICICRAUDIT | IRA | No description in the Lawson data dictionary | COMPANY, LOCATION, ITEM, DOCUMENT, DOC-TYPE, SYSTEM-CD, LINE-NBR, COMPONENT-SEQ, DATE, TIME, FLD-NBR | 16 |
| ICICTUF | UFT | No description in the Lawson data dictionary | COMPANY, LOCATION, DOC-TYPE, SYSTEM-CD, DOCUMENT, SHIPMENT-NBR, LINE-NBR, COMPONENT-SEQ | 13 |
| ICITEMCODE | IIC | Item Code | ITEM-GROUP, ICSEGMENT, ICFAMILY, ICCLASS, ICCOMMODITY | 9 |
| ICITEMGPC | GPC | No description in the Lawson data dictionary | ITEM-GROUP, SEGMENT, FAMILY, CLASS, BRICK, ATTRIBUTE-TYPE, ATTRIBUTE-VAL | 8 |
| ICITEMGTIN | GTI | Inventory Item for GTIN | ITEM-GROUP, ITEM, GTIN | 61 |
| ICITEUF | UFM | Item User Field | ITEM-GROUP, ITEM | 7 |
| ICITLLBL | ILL | Item Location Label | COMPANY, LOCATION, LABEL-TYPE, USER-ID, ITEM, UPDATE-DATE, UPDATE-TIME | 14 |
| ICITLUF | UFL | Item Location User Field | COMPANY, LOCATION, ITEM | 8 |
| ICITSUF | UFS | No description in the Lawson data dictionary | ITEM-GROUP, ITEM, SUB-TYPE, SUB-ITEM | 9 |
| ICLBOD | IBE | No description in the Lawson data dictionary | COMPANY, LOCATION | 8 |
| ICLMXVAL | ILV | Matrix Attribute Value | ICL-OBJ-ID, MATRIX-CAT | 3 |
| ICLOCATION | ICL | Company Location | COMPANY, LOCATION | 115 |
| ICLOCGRP | ILG | Location Group | COMPANY, LOCATION, SYSTEM-CD, SEQ | 5 |
| ICLOT | ILT | Lots with Expire Date/On Hold | COMPANY, LOCATION, ITEM, LOT | 7 |
| ICMANFCODE | IMC | Manufacturers Code | ITEM-GROUP, MANUF-CODE, MANUF-DIVISION | 7 |
| ICMANUF | ICM | Manufacturer | ITEM-GROUP, MANUF-ID | 12 |
| ICMFGCODE | MFC | IC Manufacturing Code | ITEM-GROUP, MANUF-ID, MANUF-CODE, MANUF-DIVISION | 4 |
| ICMFGDIST | MFD | IC Manufacturers Distribution | ITEM-GROUP, MANUF-ID, COMPANY, LOCATION, NAME | 15 |
| ICMXVAL | IMV | Matrix Value | IC-OBJ-ID, MATRIX-CAT | 3 |
| ICPLANORD | IPL | Inventory Planned Order File | COMPANY, LOCATION, ITEM, PERIOD-DT | 17 |
| ICRECEIPTS | ICR | Costing Record | COMPANY, LOCATION, ITEM, DOCUMENT, DOC-TYPE, SYSTEM-CD, LINE-NBR, COMPONENT-SEQ | 19 |
| ICRPTGRP | IRG | Report Group | COMPANY, REPORT-GRP, LOCATION | 4 |
| ICSELECT | ICS | Select ID | COMPANY, SELECT-ID | 49 |
| ICTBOD | IBC | No description in the Lawson data dictionary | COMPANY, LOCATION, DOC-TYPE, SYSTEM-CD, DOCUMENT, SHIPMENT-NBR, LINE-NBR, COMPONENT-SEQ | 14 |
| ICTRANS | ICT | Inventory Transaction | COMPANY, LOCATION, DOC-TYPE, SYSTEM-CD, DOCUMENT, SHIPMENT-NBR, LINE-NBR, COMPONENT-SEQ | 90 |
| ICTRANSDTL | ICD | Inventory Transaction Detail | COMPANY, LOCATION, DOC-TYPE, SYSTEM-CD, DOCUMENT, SHIPMENT-NBR, LINE-NBR, COMPONENT-SEQ, TRANS-SEQ | 27 |
| ICUSRFLDEF | ICU | No description in the Lawson data dictionary | USER-FLD-TYPE, COMPANY, ITEM-GROUP | 8 |
| ICVALUOM | ICV | Valid Units Of Measure | ITEM-GROUP, VALID-UOM | 3 |
| ITCOMMENT | ICO | Comments | ITEM-GROUP, ITEM, LANGUAGE-CODE, SEQ | 8 |
| ITEBOD | IBA | No description in the Lawson data dictionary | ITEM-GROUP, ITEM | 8 |
| ITEMASTOUT | ITO | No description in the Lawson data dictionary | ITEM-GROUP, COMPANY, ITEM, CREATION-DATE, CREATION-TIME | 68 |
| ITEMFORMAT | ITF | User-Defined Item Format | COMPANY, FORMAT-ID | 11 |
| ITEMGROUP | ITG | Item Group | ITEM-GROUP | 15 |
| ITEMLOC | ITL | Item Location | COMPANY, LOCATION, ITEM | 137 |
| ITEMLOCBIN | ILB | Item Location Bin Reorder File | COMPANY, LOCATION, ITEM, BIN, UOM | 13 |
| ITEMMAST | ITE | Item Master | ITEM-GROUP, ITEM | 107 |
| ITEMNDC | IDC | Item National Drug Code | ITEM-GROUP, ITEM, NDC-NBR | 14 |
| ITEMSKU | ISK | Item SKU | ITEM-GROUP, ITEM, SKU | 16 |
| ITEMSPECL | ITP | No description in the Lawson data dictionary | ITEM-GROUP, PVN-OBJ-ID | 11 |
| ITEMSRC | ITM | Item Source | COMPANY, LOCATION, ITEM, REPLENISH-PRI | 9 |
| ITEMSUB | ITS | Item Substitute | ITEM-GROUP, ITEM, SUBTYPE, SUB-ITEM | 7 |
| ITEMUPC | IPC | Item Universal Product Code | ITEM-GROUP, ITEM, UPC | 11 |
| ITEMUPN1 | IPN | Item UPN1 | ITEM-GROUP, ITEM, UPN-NBR | 13 |
| ITEMUPN2 | IP2 | Item UPN2 | ITEM-GROUP, ITEM, UPN2-NBR | 13 |
| ITFLINE | IFL | Field Nbrs for Item Format | COMPANY, FORMAT-ID, FLD-NBR | 6 |
| ITLBOD | IBB | No description in the Lawson data dictionary | COMPANY, LOCATION, ITEM | 9 |
| ITSERIAL | SER | Serial Numbers | COMPANY, ITEM, SERIAL | 10 |
| KITBOD | IBF | No description in the Lawson data dictionary | ITEM-GROUP, COMPANY, LOCATION, ITEM | 10 |
| KITITEM | KIT | Kit Item | ITEM-GROUP, COMPANY, LOCATION, ITEM | 31 |
| KTINSTRUCT | KTI | Kit Instructions | ITEM-GROUP, COMPANY, LOCATION, KIT-ITEM, SEQ, INST-LINE | 7 |
| KWDDETAIL | IC2 | No description in the Lawson data dictionary | SEARCH-TYPE, KWD-ORIGIN, KEYWORD, SEARCH-GROUP, ITEM, COMPANY, REQUISITION, IS-SYNONYM | 8 |
| KWDMASTER | IC1 | No description in the Lawson data dictionary | SEARCH-TYPE, KWD-ORIGIN, KEYWORD, SEARCH-GROUP, COMPANY | 6 |
| KWDSETUP | ICK | No description in the Lawson data dictionary | SEARCH-TYPE, KWD-ORIGIN, SEARCH-GROUP, COMPANY, USAGE-FLAG | 6 |
| KWDSYNONYM | IC3 | Keywords Synonym | SYNONYM, KEYWORD | 2 |
| MAJORCL | MAJ | Major Class | ITEM-GROUP, CLASS-TYPE, MAJOR-CLASS | 5 |
| MFGSHPFAC | MFG | Manufacturer Relationship | ITEM-GROUP, MANUF-ID, ST-FACILITY | 14 |
| MINORCL | MIN | Minor Class | ITEM-GROUP, CLASS-TYPE, MAJOR-CLASS, MINOR-CLASS | 6 |
| REASON | REA | Reason Code | COMPANY, REASON-CODE | 8 |
| SOHDETAIL | SDT | Stock-on-Hand Detail | COMPANY, LOCATION, ITEM, UOM, LOT, SUBLOT, BIN | 17 |
| UOMLOADCSV | UML | No description in the Lawson data dictionary | VALID-UOM | 2 |
Online screens (190)
| Screen | Description | Updates | References |
|---|---|---|---|
| DR25.1 | Planned Orders | 1 | 4 |
| DR40.1 | Time Phased Order Point | 0 | 5 |
| DR42.1 | Time Phased Order Point by Buyer | 0 | 5 |
| IC00.1 | Corporate Item Group | 8 | 14 |
| IC00.2 | Item Comment Types | 1 | 0 |
| IC00.3 | Item Comment Report Options | 1 | 0 |
| IC00.5 | Keyword Search Setup | 1 | 1 |
| IC01.1 | Company | 8 | 14 |
| IC01.2 | Period End Dates | 2 | 1 |
| IC01.3 | Bin Usage Types | 2 | 3 |
| IC01.4 | Report Options | 2 | 1 |
| IC02.1 | Location | 12 | 58 |
| IC02.2 | Substitute Locations | 2 | 2 |
| IC02.3 | IC Location Attributes | 0 | 7 |
| IC02.4 | Values by IC Location Attributes | 0 | 6 |
| IC02.5 | Query List Members | 0 | 2 |
| IC02.6 | Manual IC Location List | 3 | 2 |
| IC03.1 | Report Group | 1 | 2 |
| IC04.1 | General Ledger Category | 2 | 2 |
| IC05.1 | Sales Class | 2 | 2 |
| IC06.1 | Inventory Class | 2 | 2 |
| IC07.1 | Purchasing Class | 2 | 4 |
| IC08.1 | Generic Names | 1 | 2 |
| IC09.1 | Hazard Codes | 1 | 1 |
| IC10.1 | Item Formats | 6 | 26 |
| IC10.2 | Item Master and Location | 16 | 44 |
| IC11.1 | Item Master | 19 | 61 |
| IC11.2 | Item Universal Product Code | 0 | 6 |
| IC11.3 | Item Universal Product Number 1 | 0 | 6 |
| IC11.4 | Item Universal Product Number 2 | 0 | 6 |
| IC11.5 | Item Stocking Keeping Unit | 0 | 6 |
| IC11.6 | National Drug Code | 0 | 6 |
| IC11.7 | Global Trade Item Number | 0 | 9 |
| IC11.8 | Old Special Items for Item | 0 | 1 |
| IC12.1 | Item Location | 180 | 196 |
| IC12.2 | Replenishment Setup | 5 | 9 |
| IC13.1 | Associated Items | 2 | 4 |
| IC14.1 | Manufacturer Code | 3 | 7 |
| IC15.1 | Storage Codes | 1 | 3 |
| IC15.2 | Bins | 3 | 27 |
| IC15.3 | Bin Groups | 3 | 3 |
| IC16.1 | UNSPSC Product Codes | 1 | 2 |
| IC17.1 | Reason Codes | 1 | 2 |
| IC18.1 | Item Comments | 2 | 1 |
| IC19.1 | Forecasts | 1 | 4 |
| IC20.1 | Receipts | 15 | 33 |
| IC20.2 | Detail Receipts | 15 | 35 |
| IC21.1 | Issues | 17 | 41 |
| IC21.2 | Detail Issues | 17 | 43 |
| IC21.5 | Issues Detail List | 6 | 14 |
| IC22.1 | Transfers | 17 | 38 |
| IC22.2 | Detail Transfer | 17 | 41 |
| IC23.1 | Intransit Receiving | 14 | 29 |
| IC23.2 | Detail Intransit Receiving | 14 | 18 |
| IC23.3 | Intransit Receiving by Lot | 2 | 7 |
| IC23.4 | Intransit Receiving by Bin, UOM | 2 | 7 |
| IC23.5 | Intransit Receiving by Serial | 2 | 7 |
| IC24.1 | Adjustments | 16 | 35 |
| IC24.2 | Detail Adjustments | 16 | 38 |
| IC25.1 | Document Release | 15 | 33 |
| IC26.1 | Detail Transfers | 7 | 5 |
| IC26.2 | Bin Transfer by Serial | 7 | 6 |
| IC27.1 | Lot Hold Control | 1 | 4 |
| IC28.1 | Cost Adjustments | 5 | 10 |
| IC29.1 | Lots | 3 | 12 |
| IC29.2 | Serials | 2 | 9 |
| IC29.3 | Bins | 2 | 8 |
| IC30.1 | Item Search | 0 | 6 |
| IC30.2 | GTIN Inquiry | 0 | 4 |
| IC31.1 | Item Location Balances | 2 | 7 |
| IC32.1 | Keyword Synonym | 2 | 1 |
| IC33.1 | Ship to Facility | 1 | 4 |
| IC34.1 | Manufacturer Relationship Management | 4 | 5 |
| IC34.2 | Distribution Center Detail | 0 | 3 |
| IC34.3 | Ship To Facility Detail | 0 | 2 |
| IC35.1 | Inquiry Formats | 2 | 3 |
| IC36.1 | User Defined Item Inquiry | 2 | 13 |
| IC37.1 | Daily Transaction Summary | 1 | 7 |
| IC38.1 | Bin Reorder Policy | 1 | 5 |
| IC39.1 | Freight Class | 1 | 1 |
| IC40.1 | Availability by Location | 2 | 7 |
| IC40.2 | Secondary Quantity Availability | 2 | 7 |
| IC41.1 | Items Within a Bin | 0 | 6 |
| IC42.1 | Stock by Detail | 0 | 6 |
| IC42.2 | Stock by Lot | 0 | 6 |
| IC42.3 | Serial Numbers | 0 | 6 |
| IC42.4 | Secondary Detail | 0 | 6 |
| IC43.1 | Bin Type Inquiry | 0 | 4 |
| IC44.1 | Inventory Stock Status | 2 | 16 |
| IC45.1 | Stock Status | 2 | 11 |
| IC46.1 | Inventory Status | 0 | 11 |
| IC46.2 | Inventory Status | 0 | 3 |
| IC47.1 | Cost History | 0 | 6 |
| IC48.1 | Open Intransits | 0 | 5 |
| IC49.1 | Usage History | 0 | 5 |
| IC50.1 | Transaction History | 0 | 6 |
| IC50.2 | Detail Transaction History | 1 | 9 |
| IC51.1 | Available Bin Space | 0 | 7 |
| IC52.1 | Serial or Lot History | 0 | 6 |
| IC53.1 | Document Inquiry | 0 | 6 |
| IC54.1 | Inventory Control Adjustment | 1 | 0 |
| IC54.2 | Inventory Control Line Adjustment | 1 | 1 |
| IC54.3 | Inventory Control Detail Adjustment | 1 | 0 |
| IC55.1 | Transaction History Inquiry | 0 | 12 |
| IC55.2 | Transaction History Inquiry | 0 | 9 |
| IC56.1 | Item Attributes | 0 | 7 |
| IC56.2 | Values by Item Attributes | 0 | 6 |
| IC56.3 | Query List Members | 0 | 2 |
| IC56.4 | Manual Item List | 3 | 2 |
| IC57.1 | Physical Inventory Table Fix | 1 | 0 |
| IC58.1 | Global Location Numbers | 1 | 32 |
| IC58.2 | Global Location Numbers Inquiry | 1 | 15 |
| IC58.3 | Global Location Numbers Inquiry Details | 1 | 15 |
| IC59.1 | Create Label Entry | 1 | 7 |
| IC60.1 | Kit Assembly | 4 | 4 |
| IC60.2 | Options | 2 | 6 |
| IC60.3 | Instructions | 3 | 4 |
| IC61.1 | Kit Component Replacement | 4 | 7 |
| IC62.1 | Finished Goods | 10 | 27 |
| IC62.2 | Finished Good Byproducts | 5 | 4 |
| IC62.4 | Component Finished Goods | 10 | 8 |
| IC63.1 | Burdens | 3 | 5 |
| IC64.1 | Global Location Nbr Assignment GL/IC Company | 185 | 181 |
| IC64.2 | Global Location Nbr Assignment IC Location | 185 | 187 |
| IC64.3 | Global Location Number Assignment RQ Location | 185 | 181 |
| IC64.4 | Global Location Number Assignment Manuf Code | 185 | 181 |
| IC64.5 | Global Location Number Assignment Manuf Div | 185 | 181 |
| IC64.6 | Global Location Number Assignment Vendor | 183 | 191 |
| IC64.7 | Global Location Number Assignment Vendor Location | 185 | 181 |
| IC64.8 | Global Location Number Assignment IC Bin | 185 | 181 |
| IC64.9 | Global Location Number Assignment Buyer | 185 | 181 |
| IC65.1 | Component Where Used | 0 | 5 |
| IC66.1 | Replenishment PO Worksheet | 177 | 184 |
| IC67.1 | Kit Availability | 2 | 7 |
| IC68.1 | Finished Good Component Availability | 3 | 7 |
| IC68.2 | Finished Good Component Availability | 3 | 7 |
| IC68.3 | Finished Good Component Sub Location Availability | 2 | 5 |
| IC70.1 | Select IDs | 1 | 9 |
| IC72.1 | Counts by Page | 2 | 6 |
| IC73.1 | Count Detail | 4 | 7 |
| IC74.1 | Random Counts | 2 | 9 |
| IC76.1 | Variance Reasons | 3 | 4 |
| IC78.1 | Select ID Status | 0 | 2 |
| IC81.1 | Cart, Par Location | 18 | 37 |
| IC81.2 | Cart, Par Location Item Detail | 0 | 11 |
| IC82.1 | Par Location Item Mass Change | 7 | 28 |
| IC83.1 | Par Location Counts | 193 | 241 |
| IC84.1 | Detail Par Location Utilization by Month | 3 | 16 |
| IC84.2 | Detail Par Location Utilization by Month | 2 | 12 |
| IC90.1 | Bin Transfers | 7 | 7 |
| IC91.1 | Item Audit Inquiry | 0 | 4 |
| IC91.2 | Item Location and Item Source Audit Inquiry | 0 | 6 |
| IC91.3 | GL Category Audit Inquiry | 1 | 5 |
| IC91.4 | Item Group Audit Inquiry | 1 | 2 |
| IC91.5 | IC Company Audit Inquiry | 1 | 2 |
| IC92.1 | IC Location Audit Inquiry | 0 | 4 |
| IC93.1 | Bin Audit | 0 | 5 |
| IC93.2 | Bin Group Audit | 0 | 5 |
| IC95.1 | Catch Weight | 0 | 5 |
| IC95.2 | Catch Weight | 0 | 5 |
| IC95.3 | Catch Weight | 0 | 6 |
| IC95.4 | IC Receipts Audit | 1 | 4 |
| ICBD.1 | IC BOD Maintenance | 5 | 4 |
| ICBD.2 | IC BOD Inquiry | 0 | 9 |
| ICBL.1 | Build Item Matrix List | 2 | 7 |
| ICBL.2 | Update Global Matrix List | 2 | 7 |
| ICBL.3 | Item Matrix Value Object | 2 | 3 |
| ICBL.4 | Populate Sort File from Matrix List | 0 | 4 |
| ICCP.1 | IC Company Edit | 0 | 1 |
| ICI1.1 | Unit Of Measure Routines | 1 | 5 |
| ICI4.1 | ITEMUPC Invoked Object | 2 | 1 |
| ICI5.1 | ITEMUPN1 Invoked Object | 2 | 1 |
| ICI6.1 | ITEMUPN2 Invoked Object | 2 | 1 |
| ICI7.1 | ITEMSKU Invoked Object | 2 | 1 |
| ICI8.1 | ITEMUPC Invoked Object | 0 | 7 |
| ICI9.1 | Item GTIN Invoke Object | 4 | 14 |
| ICIA.1 | Keyword Search INVOKED Object | 0 | 11 |
| ICIB.1 | Keyword Load INVOKED Object | 2 | 2 |
| ICIC.1 | ITEMNDC Invoked Object | 2 | 1 |
| ICIG.1 | Item Group Edit | 0 | 1 |
| ICIT.1 | Item Master Edit | 0 | 1 |
| ICIZ.1 | Update Ictrans from M3 PFI | 1 | 0 |
| ICLC.1 | Item Location Lookup | 0 | 4 |
| ICLM.1 | Build Location Matrix List | 3 | 10 |
| ICLM.3 | Location Matrix Value Object | 2 | 3 |
| PC08.1 | Price Class | 1 | 1 |
| PC10.1 | Patient Charge Items | 2 | 4 |
| PC20.1 | Patient Charges | 2 | 6 |
| PC20.2 | Patient | 1 | 2 |
| PC90.1 | Patient Charge Item Audit Inquiry | 1 | 3 |
Batch programs (148)
| Program | Description | Updates | References |
|---|---|---|---|
| DR100 | Distribution Requirements Report | 195 | 240 |
| IC110 | Intransit Shipping | 2 | 9 |
| IC120 | Economic Order Quantity and Reorder Calculation | 3 | 12 |
| IC125 | Standard Cost Valuation | 5 | 16 |
| IC130 | General Ledger Interface | 16 | 45 |
| IC131 | Build IC Financial Reporting File | 3 | 1 |
| IC134 | Inventory Turnover | 3 | 16 |
| IC135 | Inventory Turnover by Issues | 3 | 14 |
| IC138 | Bin Replenishment Report | 3 | 14 |
| IC140 | Vendor Reorder Advice | 178 | 187 |
| IC141 | Location Replenishment Report | 193 | 239 |
| IC142 | Replenishment by Requisition PO's | 192 | 239 |
| IC143 | Finished Good Replenishment | 3 | 4 |
| IC145 | Stock Status Report | 178 | 187 |
| IC150 | Movement Analysis - Cost | 4 | 14 |
| IC151 | Movement Analysis - Sales | 4 | 14 |
| IC152 | Movement Analysis - GMROI | 4 | 14 |
| IC153 | Product Transfer, Resale Report | 2 | 10 |
| IC170 | Freeze Selected Items | 6 | 9 |
| IC175 | Update Variances | 15 | 32 |
| IC179 | Delete Freeze Records | 5 | 2 |
| IC180 | Dictionary Setup | 2 | 0 |
| IC182 | Par Location Utilization | 4 | 16 |
| IC183 | Par Level Load | 3 | 26 |
| IC189 | Bin Audit Report | 2 | 4 |
| IC190 | Closing | 4 | 6 |
| IC191 | Item Master Audit Trail | 2 | 4 |
| IC192 | Item Location Audit Trail | 2 | 5 |
| IC193 | IC Location Audit Report | 2 | 4 |
| IC194 | GL Category Audit Report | 2 | 4 |
| IC195 | IC Receipts Audit Report | 2 | 3 |
| IC196 | Item Group Audit Report | 2 | 1 |
| IC197 | IC Company Audit Report | 2 | 1 |
| IC198 | Bin Group Audit Report | 2 | 4 |
| IC199 | Subsystem Close | 3 | 10 |
| IC200 | Item Group Listing | 1 | 3 |
| IC201 | Company Listing | 1 | 2 |
| IC202 | Location Listing | 1 | 4 |
| IC203 | Report Group Listing | 1 | 3 |
| IC204 | General Ledger Category Listing | 1 | 3 |
| IC205 | Sales Class Listing | 1 | 3 |
| IC206 | Inventory Class Listing | 1 | 3 |
| IC207 | Purchase Class Listing | 1 | 3 |
| IC208 | Generic Name Listing | 1 | 2 |
| IC209 | Hazard Code Listing | 1 | 2 |
| IC210 | Item Master Listing | 1 | 5 |
| IC211 | Item Location Listing | 2 | 12 |
| IC212 | Item Comments Listing | 1 | 5 |
| IC213 | Item Substitutes Listing | 1 | 5 |
| IC215 | Bin Listing | 1 | 6 |
| IC216 | Open Transaction Report | 13 | 20 |
| IC217 | Reason Code Listing | 1 | 2 |
| IC218 | GTIN Listing | 1 | 8 |
| IC219 | Forecast Listing | 1 | 6 |
| IC220 | Transaction History Report | 1 | 16 |
| IC221 | Open Intransit Report | 1 | 6 |
| IC222 | Unreleased Documents | 14 | 75 |
| IC223 | Availability Report | 3 | 32 |
| IC224 | Gross Margin Return on Investment | 2 | 13 |
| IC225 | Inventory Reorder Advice | 3 | 12 |
| IC226 | Leadtime Review Report | 3 | 15 |
| IC227 | Potential Obsolete | 2 | 16 |
| IC228 | Potential Overstock | 2 | 15 |
| IC229 | Transactions by Reason Code | 1 | 8 |
| IC230 | Lot Status Report | 1 | 9 |
| IC231 | Issue Summary Report | 1 | 13 |
| IC232 | Serial Status Report | 1 | 7 |
| IC233 | Inventory Valuation | 3 | 16 |
| IC234 | Period End Valuation | 3 | 19 |
| IC235 | Market Inventory Valuation | 2 | 10 |
| IC236 | Freight Class Listing | 1 | 2 |
| IC237 | Unapproved Bin Report | 1 | 7 |
| IC238 | Bin Stock on Hand Report | 1 | 8 |
| IC239 | Forecast Variance | 1 | 9 |
| IC240 | General Ledger Audit Report | 3 | 9 |
| IC241 | Bin Reorder Policy Listing | 1 | 7 |
| IC242 | Transaction Audit Report | 1 | 9 |
| IC243 | Killed Item Report | 178 | 184 |
| IC244 | Inventory Issue Document | 1 | 7 |
| IC246 | Inventory Status Report | 1 | 1 |
| IC247 | IFRS FIFO Period End Valuation | 3 | 19 |
| IC250 | Released Document Report | 1 | 6 |
| IC258 | Global Location Number Listing | 2 | 15 |
| IC260 | Kit, Assembly Listing | 1 | 7 |
| IC262 | Finished Good Listing | 4 | 9 |
| IC263 | Burden Listing | 3 | 3 |
| IC266 | Replenishment PO Worksheet Rpt | 2 | 10 |
| IC270 | Count Sheets | 4 | 14 |
| IC271 | Select ID Listing | 1 | 2 |
| IC280 | Distribution History Report | 3 | 13 |
| IC281 | Par Inventory Worksheet | 4 | 14 |
| IC282 | Requesting Location Usage | 6 | 25 |
| IC283 | Par Location Valuation | 3 | 10 |
| IC284 | Variance Explanations | 1 | 4 |
| IC285 | Detail Par Loc Utilization | 4 | 16 |
| IC286 | Accuracy Progress | 1 | 4 |
| IC287 | Transactions by Document Type | 1 | 7 |
| IC289 | Batch Handheld Stop of IC588 | 1 | 0 |
| IC290 | Item Format Listing | 1 | 4 |
| IC295 | Count Control Status | 1 | 9 |
| IC300 | Inventory Purge | 13 | 7 |
| IC311 | ITEMASTOUT Purge | 2 | 1 |
| IC320 | Mass Item Location Copy | 6 | 29 |
| IC330 | Item Mass Change | 180 | 200 |
| IC331 | Par Cart Mass Changes | 7 | 30 |
| IC500 | Transaction Interface | 20 | 41 |
| IC501 | IC Company Setup Extract | 1 | 4 |
| IC502 | IC Location CSV Create | 1 | 5 |
| IC503 | IC Valid UOM CSV Create | 1 | 25 |
| IC511 | Item Master-Item Location Extr | 1 | 18 |
| IC512 | Item Audit Extract | 2 | 12 |
| IC516 | Load UNSPSC Product Codes | 2 | 1 |
| IC519 | Forecast Interface | 2 | 3 |
| IC520 | Handheld Item Master Interface | 4 | 13 |
| IC521 | Bar Code Item Master Interface | 4 | 13 |
| IC522 | HL7 Item Master - Atwork | 5 | 21 |
| IC523 | HL7 Item Master - OmniCell | 4 | 16 |
| IC524 | CSV Item Master | 4 | 42 |
| IC525 | HL7 Item Master Interface | 5 | 20 |
| IC526 | HL7 Item Master - McKesson | 5 | 21 |
| IC527 | HL7 Item Master - DeRoyal | 5 | 21 |
| IC550 | Overallocated Items | 1 | 4 |
| IC558 | GLN Master Load | 2 | 2 |
| IC574 | Physical Inventory Interface | 4 | 9 |
| IC588 | Handheld Processing | 1 | 0 |
| IC589 | Forecast Transfer | 2 | 4 |
| IC590 | Out of Stock Extract | 1 | 6 |
| IC598 | Bin Label Export | 4 | 19 |
| IC599 | Label Print Export | 2 | 1 |
| IC800 | Keyword Search Load | 4 | 14 |
| IC802 | Locations to LRO via BCI | 10 | 14 |
| IC811 | Item Master Load | 14 | 37 |
| IC812 | Item Location Load | 12 | 30 |
| IC820 | Beginning Balance Load | 7 | 5 |
| IC840 | Cart Par Location Conversion | 40 | 71 |
| IC841 | General Ledger Category Conversion | 3 | 2 |
| IC850 | Transaction Load | 5 | 4 |
| IC851 | History Load | 2 | 6 |
| PC120 | Price Calculation | 5 | 12 |
| PC190 | Patient Charge Item Audit Rpt | 2 | 3 |
| PC210 | Patient Charge Reconciliation | 1 | 9 |
| PC310 | Patient Purge | 3 | 3 |
| PC320 | Patient Charge Purge | 2 | 1 |
| PC520 | Patient Upload | 3 | 2 |
| PC521 | HL7 ADT Patient Interface | 5 | 7 |
| PC530 | Patient Charge Download | 3 | 4 |
| PC540 | Patient Charge Upload | 3 | 5 |
| PC810 | Patient Charge Item Conversion | 3 | 3 |
Other tables used by Inventory Control programs (398)
ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACAMCODE, ACBILL, ACBILLX, ACBUDHDR, ACCAL, ACCALX, ACCATGRP, ACCATGRPX, ACCATSUM, ACCATSUMX, ACCNTRACT, ACCOMMIT, ACCOMMITX, ACCONSOL, ACDETAILAU, ACHEADERAU, ACIFACTV, ACPRDPERF, ACTRANS, ADDRDATA, AGINGCODE, AMACCOUNT, AMACCTAU, AMACCTGPAU, AMACCTGRP, AMASSET, AMASSETADJ, AMASSETBOD, AMASSETDSP, AMASSETGRP, AMASSETTRF, AMASTBKADJ, AMASTBKDSP, AMASTBKTRF, AMASTBOOK, AMASTITADJ, AMASTITDSP, AMASTITEM, AMASTITTRF, AMASTMXVAL, AMASTRECAP, AMASTRPAIR, AMASTTYPAU, AMASTTYPE, AMAUGROUP, AMAUGRPAU, AMBKHIST, AMBKHISTX, AMBKTEMPLT, AMBKTRANS, AMBOOK, AMCALENDAR, AMCLASSDEP, AMCNTRLAU, AMCOMPUTE, AMCONTROL, AMCTLTRANS, AMDICT2, AMDIVISION, AMDIVISNAU, AMINTER, AMINTERAU, AMLOCATION, AMLOCAUDIT, AMLOCDTL, AMMETHOD, AMMONITOR, AMPOASTDTL, AMPOASTHDR, AMPODFLTS, AMPUCODE, AMPUHIS, AMSEGBLOCK, AMSYSOPTAU, AMTABLEPCT, AMTABLETAX, AMTAXAUTH, AMTEMPLATE, AMTRANS, AMTRANSBOD, AMTRANSUMM, AMTYPALLOC, AMTYPALLOX, AMUOPPDS, APACCRCODE, APAPIHIST, APAPPROVAL, APAUDIT, APAUTHOR, APCOMMENTS, APCOMPANY, APCONTACT, APCPYVND, APDISCCODE, APDISTCODE, APDISTHDR, APDRAFTS, APHLDINV, APHOLDCODE, APINCCODE, APINVOICE, APPAYMENT, APPMTBOD, APPROCGRP, APPROCLEV, APUAVAL, APUDISTCD, APUSRFLDEF, APVENADDR, APVENBAL, APVENCERT, APVENCLASS, APVENGROUP, APVENLCBOD, APVENLOC, APVENMAST, APVENPAY, APVNMXVAL, ARCOMP, ARCUSTFLDS, ARCUSTGRP, ARCUSTOMER, ARCUSTTOTS, ARLOCKBOX, ARPAYMENT, AUMXVALUAU, AUMXVLDTAU, BILLTO, BUYBOD, BUYCLASS, BUYCMPLOC, BUYER, BUYVENPF, CAALOCGPAU, CADETAILAU, CAHEADERAU, CBBANKENT, CBBANKINST, CBCASHCODE, CBCASHFORM, CBCHECK, CBPAYMENT, CBRECPTHDR, CBTRANS, CBTRANSBOD, CBUSER, CBUSRCLASS, COCOMP, COLINE, COSGBLK, CUACCT, CUACCTAU, CUCODES, CUCODESAU, CUCONV, CUCONVAU, CURELAT, CURELATAU, CUSTDESC, CUSTEP, CUSTORDER, CUTABLE, CUTABLEAU, CUTRANSL, CUTRNSLAU, CXBURDEN, CXCASEHEAD, CXCASEPREF, CXCOMPANY, CXCPIUAVAL, CXITEMHIST, CXPRACTNR, CXPREFITEM, CXPTMPITEM, EEADVANCE, EEAPPROVAL, EEEXPENSE, EPTRANS, FBADJCODAU, FBCNTRLAU, FBDETAIL, FBDETAILAU, FBFNDHDRAU, FBFUNDAMT, FBFUNDDTL, FBHEADER, FBHEADERAU, FBHSTHDRAU, FBINTBUAU, FBSPREADAU, FBTRANS, FBTRANSAU, FBYETR, GLACCTVLD, GLACMXVLAU, GLADDRESS, GLAMOUNTS, GLAUTMXVAU, GLCGCPY, GLCHART, GLCHARTDTL, GLCHARTSUM, GLCHTDTLAU, GLCODES, GLCOMMIT, GLCOMMITX, GLCPYGRP, GLHISCOMBL, GLHISCOMX, GLINTCO, GLMASTER, GLMASTERAU, GLNAMES, GLNAMESAU, GLSYSTEM, GLSYSTEMAU, GLTRANS, GMFNDACT, GTMXVALUAU, ICCOUT, IFBCIQUEUE, INDOCTPCD, INLINETYPE, INSTATPROC, INSTCMDTY, INSTCTRYCD, INSTDETAIL, INSTHEADER, INSTNBR, INSTNOTC, INSTPORTS, INSTREGN, JBKACCT, JBOOKHDR, LMLEASE, LMLEASESEG, MAAOCDTL, MACAPDTL, MACOMPANY, MAELMGPREL, MAELMVALUE, MAFRXREF, MAINVDTL, MAINVHAND, MAMAAHIST, MAMADHIST, MAMATCHTBL, MAMSGTOL, MAMTCHELEM, MAMTCHRULE, MAPOINV, MAREASONCD, MATCHCLASS, MLCOLEDGER, MMDIST, MMUAVAL, MXCATDEF, MXCATDEFAU, MXELEMENT, MXELEMNTAU, MXLISTDTL, MXLISTHDR, MXLISTMBR, MXLSTDTLAU, MXLSTHDRAU, MXOBJCAT, MXOBJCATAU, MXTMPDTLAU, MXTMPHDRAU, MXTPEFDTAU, MXTPHEDTAU, MXVALIDATE, MXVALIDAU, MXVEWDTLAU, MXVEWHDRAU, NATACCT, NATBALANCE, OECOMPANY, OECUST, OEFRTCODE, OEINVCLINE, OEINVOICE, OEROUTE, ORDERTYPE, PDCARD, PDCCHRGERR, PJLBOD, POAGMAUDIT, POAGMTPART, POAGMTPRIC, POAOCDTL, POAOCMAST, POAOCSPRD, POAPPCODE, POAPPROVE, POAUDIT, POAUDRULES, POAUDTYPE, POCODE, POCOMPANY, POCONTRACT, PODOCREF, POHDROUT, POHDRPVT, POINTAOC, POINTAUDIT, POINTERFAC, POITEMVEN, POIVACMNT, POLINE, POLINEOUT, POLINEPVT, POLINESRC, POMATCHOBJ, POMESSAGE, POMXVAL, POPCRUF, POPLIUF, POPOVUF, PORECADJHD, PORECADJLN, PORECEIVE, PORECLINE, PORECON, PORETURNHD, PORETURNLN, POREVISION, PORLNUF, PORQHUF, POTRACK, POTRANSDTL, POUSRFLDEF, POVACOMMIT, POVACOMMIX, POVADIST, POVAGLNERR, POVAGRMTHD, POVAGRMTLN, POVAPARTLN, POVENDLOC, POVENDOR, PROCLEV, PROCTEMPLN, PROCUREGRP, PTHBOD, PURCHORDER, PVHBOD, RECAOCDTL, REQBOD, REQHEADER, REQLINE, REQUESTER, RETURNLINE, RJMXVALUAU, ROUTEDOC, ROUTEHDR, ROUTESTOP, RQACCTU, RQAOCDTL, RQAPPCODE, RQAPPROVE, RQAUDIT, RQHBOD, RQLMXVAL, RQLOC, RQPURCHCLS, RQRQLAUDIT, RQTRANS, SHIPTO, SLSEGMENT, SLSEGVALUE, STATICCUST, STCOMMCODE, SUBCKPOINT, SYSTEMCODE, TERMS, TXCODEMAST, TXCOMPANY, TXTAXCODE, TXTAXRATE, TXTAXTABLE, VBABOD, WFSETUP, WHDEMAND, WHDEMNDHDR, WHLOCRULE, WHPROCTYPE, WHSHIPLINE, WHSHIPMENT, WHSHLAUD, WHUSRFLDEF, WODMNDFCST, WORDER, WOUSRFLDEF