Inventory Insight 10.x specific objects
The table below lists the objects for the Inventory Insight for Lawson 10.x:
| Table name | Friendly name | Table des cription |
Date field for full extraction | Date field for incremental extraction |
Master/ Transaction |
|---|---|---|---|---|---|
| BINGROUP | Bin Group | Bin Group | NA | NA | Master |
| BINGRPDTL | Bin Group Detail | Bin Group Detail | NA | NA | Master |
| BIN STORAGE |
Bin Storage Code | Bin Storage Code | NA | NA | Master |
| COMPONENT | Components of a Kit | Components of a Kit | NA | NA | Master |
| HAZARD | Hazard Code | Hazard Code | NA | Master | |
| ICAUDIT | Item/Item Location Audit | Item/Item Location Audit | NA | NA | Master |
| ICBIN | Bin Numbers | Bin Numbers | NA | NA | Master |
| IC CATEGORY |
GL Account Category | GL Account Category | NA | NA | Master |
| IC COMPANY |
Inventory Company Information | Inventory Company Information | NA | NA | Master |
| ICGENERIC | Generic Name | Generic Name | NA | NA | Master |
| ICHISTORY | Transaction History | Transaction History | NA | NA | Master |
| IC LOCATION |
Company Location | Company Location | NA | NA | Master |
| ICLOCGRP | Location Group | Location Group | NA | NA | Master |
| ICLOT | Lots with Expire Date/On Hold | Lots with Expire Date/On Hold | NA | NA | Master |
| IC MANFCODE |
Manufacturer Code | Manufacturer Code | NA | NA | Master |
| ICMFGDIST | Central Distribution Center | Central Distribution Center | NA | NA | Master |
| ICRECEIPTS | Costing Record | Costing Record | RECEIVED-DATE | LAST_ACT_ DATE | Transaction |
| ICTRANS | Inventory Transaction | Inventory Transaction | TRANS-DATE | UPDATE-DATE | Transaction |
| IC TRANSDTL |
Inventory Transaction Detail | Inventory Transaction Detail | TRANS-DATE | UPDATE-DATE | Transaction |
| ITEM GROUP |
Item Group | Item Group | NA | NA | Master |
| ITEMLOC | Item Location | Item Location | NA | NA | Master |
| ITEM LOCBIN |
Item Location in Reorder File | Item Location in Reorder File | NA | NA | Master |
| ITEMMAST | Item Master |
Item Master | NA | NA | Master |
| KITITEM | Kit Item | Kit Item | NA | NA | Master |
| KT INSTRUCT |
Kit Instructions | Kit Instructions | NA | NA | Master |
| PO RECEIVE |
PO Receivers | PO Receivers | REC_ DATE |
LAST-UPDT- DATE |
Transaction |
| PORECLINE | Inventory Transaction | Inventory Transaction | REC_ DATE |
UPDATE_ DATE |
Transaction |