These are what I have found to be the most commonly used tables in IV. To see the most common inventory windows mapped out look here.
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
IV00118 – Item Cost Change History
IV00200 – Item Serial Number Master
IV00300 – Lot Number Master
IV00301 – Lot Attribute Master
IV10000 – Unposted Transactions (header)
IV10001 – Unposted Transactions (line)
IV10002 – Unposted Serial and Lot Number
IV10200 – Unposted Purchase Receipts (header)
IV10201 – Unposted Purchase Receipts (line)
IV10300 – Unposted Stock Count (header)
IV10301 – Unposted Stock Count (line)
IV30101 – Sales Summary History
IV30102 – Sales Summary Period History
IV30200 – Transaction History (header)
IV30300 – Transaction Amounts History (line)
IV30301 – Transaction Amounts Detail History
IV30400 – Serial and Lot Number History
IV30500 – Distribution History
IV30600 – Lot Attribute History
IV30700 – Stock Count History (header)
IV30701 – Stock Count History (line)
All check boxes in GP: unchecked is a 0 (zero) in the DB and checked is a 1.
All drop down menus on windows, just count down the selection in the drop down: the first item listed is a 1 in the DB, second a 2, etc.
IVDOCTYPE
1 – Adjustment
2 – Variance
3 – Transfer
4 – Receipt
5 – Return
6 – Invoice
7 – Assembly
PSTGSTUS
0 – New Transaction
1 – Unposted
2 – Posted
3 – Posted with Error
PCHSRCTY
1 – Adjustment
2 – Variance
3 – Transfer
4 – Override
5 – Receipt
6 – Return
7 – Assembly
8 – In Transit
ITEMTYPE
1 – Sales Inventory
2 – Discontinued
3 – Kit
4 – Misc Charges
5 – Services
ORDERPOLICY
1 – Not planned
2 – Lot for Lot
3 – Fixed Order Quantity
4 – Period Order Quantity
5 – Order Point
6 – Manually Planned
TAXOPTNS
1 – Taxable
2 – Nontaxable
3 – Base on customer/vendor
PRICMTHD
1 – Currency Amount
2 – % of List Price
3 – % Markup – Current Cost
4 – % Markup – Standard Cost
5 – % Margin – Current Cost
6 – % Margin – Standard Cost
QTYTYPE
1 – On Hand
2 – Returned
3 – In Use
4 – In Service
5 – Damaged