GP Tables

Inventory

33 tables in this module

Inventory tables track items, quantities, pricing, serial/lot numbers, and cost layers. IV00101 (Item Master) is the central table, with supporting tables for quantities (IV00102), pricing (IV00108), and transaction history (IV30200+).

Table Description
BM00101 Bill of Materials Header
BM00111 Bill of Materials Component
BM10200 Assembly Transaction
BM10300 Assembly Component
BM10400 Assembly Serial Lot
BM30100 Assembly Batch History
BM30200 Assembly Transaction History
BM30300 Assembly Component History
BM30400 Assembly Serial Lot History
BM40100 Bill of Materials Setup
IV00101 Item Master
IV00102 Item Quantity Master
IV00103 Item Vendor Master
IV00104 Item Kit Master
IV00105 Item Currency Master
IV00106 Item Purchasing
IV00107 Item Price List Options
IV00108 Item Price List
IV00200 Item Serial Number Master
IV00300 Lot Number Master
IV10000 Inventory Transaction Work Header
IV10001 Inventory Transaction Work Detail
IV10200 Purchase Receipts Header
IV10201 Purchase Receipts Detail
IV30101 Sales Summary History
IV30200 Inventory Transaction History Header
IV30300 Inventory Transaction Amounts History
IV40201 Inventory U of M Schedule Setup
IV40202 Unit of Measure Schedule Detail
IV40400 Item Class Setup
IV40700 Site Setup
IV41000 Stock Calendar
IV41101 Inventory Landed Cost Group