Tables Microsoft Great Plains
2010 and MS Dynamics GP 10

• IV00101 – Item Master
• IV00102 – Item Quantity Master
• IV00103 – Item Vendor Master
• 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/Work Transactions (Main Table)
• IV10001 – Unposted/Work Transactions (Detailed Table)
• IV10002 – Serial and Lot Number Work
• IV10200 – Purchase Receipts (Main Table)
• IV10201 – Purchase Receipts Detail (Detailed Table)
• IV10300 – Unposted Stock Count (Main Table)
• IV10301 – Unposted Stock Count (Detailed Table)
• IV30101 – Sales Summary History
• IV30102 – Sales Summary Period History
• IV30200 – Transaction History (Main Table)
• IV30300 – Transaction Amounts History (Detailed Table)
• IV30301 – Transaction Amounts Detail History
• IV30400 – Serial and Lot Number History
• IV30500 – Distribution History
• IV30600 – Lot Attribute History
• IV30700 – Stock Count History (Main Table)
• IV30701 – Stock Count Line History (Detailed Table)
• IV40400 – Item Class Setup
• IV40201 – U of M Schedule Setup (Main Table)
• IV40202 – U of M Schedule Detail Setup
• IV40600 – Item Category Setup
• IV40700 – Site Setup

Bill of Materials Tables:

• BM00101 – Bill of Materials Header
• BM00111 – Bill of Materials Component
• BM10200 – Assembly Transaction (Main Table)
• BM10300 – Assembly Component (Detailed Table)
• BM10400 – Assembly Serial/Lot
• BM30100 – Assembly Batch History
• BM30200 – Assembly Transaction History (Main Table)
• BM30300 – Assembly Component History (Detailed Table)
• BM30400 – Assembly Serial/Lot History
• BM40100 – Bill of Materials Setup

Inventory Transaction Document Types:

• 1 – Inventory Adjustment
• 2 – Variance
• 3 – Inventory Transfer
• 4 – Purchase Receipt
• 5 – Sales Returns
• 6 – Sales Invoices
• 7 – Assembly
• 8 – Inventory cost adjustment from POP Shipment (transaction source GLTRX)
• 11 – Inventory cost adjustment from POP Invoice (transaction source POIVC)

Inventory Valuation Methods:

• 1 – FIFO Perpetual
• 2 – LIFO Perpetual
• 3 – Average Perpetual
• 4 – FIFO Periodic
• 5 – LIFO Periodic

GP Item Types:

• 1 – Sales Inventory
• 2 – Discontinued
• 3 – Kit
• 4 – Misc Charges
• 5 – Services
• 6 – Flat Fee

RCRDTYPE (Record Type) Column in IV00102 Table:

• 1 – Overall record (total for all sites)
• 2 – Site record

ORDERPOLICY (Order Policy) Column in IV00102 Table:

• 1 – Not planned
• 2 – Lot for Lot
• 3 – Fixed Order Quantity
• 4 – Period Order Quantity
• 5 – Order Point
• 6 – Manually Planned

ITMVNDTY (Item Vendor Type) in Column IV00103 Table:

• 1 – Primary Vendor
• 2 – Non-primary Vendor

Quantity Types:

• 1 – On Hand
• 2 – Returned
• 3 – In Use
• 4 – In Service
• 5 – Damaged

Decimal Places:

• 1 – 0
• 2 – 1
• 3 – 2
• 4 – 3
• 5 – 4
• 6 – 5

TAXOPTNS and Purchase_Tax_Options (Tax Options in GP):

• 1 – Taxable
• 2 – Nontaxable
• 3 – Base on customer / vendor

ITMTRKOP (Item Tracking Option IN GP):

• 1 – None
• 2 – Serial Numbers
• 3 – Lot Numbers

PRICMTHD (Price Method):

• 1 – Currency Amount
• 2 – % of List Price
• 3 – % Markup – Current Cost
• 4 – % Markup – Standard Cost
• 5 – % Margin – Current Cost
• 6 – % Margin – Standard Cost

KTACCTSR (Kit COGS Account Source):

• 0 – COGS accounts from component items
• 1 – COGS account from kit

PSTGSTUS (Posting Status IN GP) Column in IV10000 Table:

• 0 – New Transaction
• 1 – Unposted
• 2 – Posted
• 3 – Posted with Error

Source Indicator Column in IV10000 Table:

• 1 – (none)
• 2 – Issue
• 3 – Reverse Issue
• 4 – Finished Good Post
• 5 – Reverse Finished Good Post
• 6 – Stock Count
• 7 – Field Service – Service Call
• 8 – Field Service – Return Material Authorization
• 9 – Field Service – Return to Vendor
• 10 – Field Service – Work Order
• 11 – Project Accounting

STCKCNTSTTS (Stock Count Status):

• 1 – Available
• 2 – Started
• 3 – Entered

SMRYTYPE (Summary Type):

• 1 – Calendar
• 2 – Fiscal

Account Indexes:

• IVIVINDX – Inventory On Hand
• IVIVOFIX – Inventory Offset
• IVCOGSIX – Cost of Goods Sold
• IVSLSIDX – Sales
• IVSLDSIX – Markdowns
• IVSLRNIX – Sales Returns
• IVINUSIX – In Use
• IVINSVIX – In Service
• IVDMGIDX – Damaged
• IVVARIDX – Variance
• DPSHPIDX – Drop Ship Items
• PURPVIDX – Purchase Price Variance
• UPPVIDX – Unrealized Purchase Price Var
• IVRETIDX – Inventory Returns
• ASMVRIDX – Assembly Variance

PCHSRCTY Column in IV10200 Table

• 1 – Adjustment
• 2 – Variance
• 3 – Transfer
• 4 – Override
• 5 – Receipt
• 6 – Return
• 7 – Assembly
• 8 – In-Transit

The tables related to the Inventory, Finance and Sales modules in the Dynamics GP.