i95Dev
Blog
 

Tables Microsoft Great Plains 2010 and MS  Dynamics GP 10

Commonly GP Used Tables ( Master Tables):

  • 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.

No Comments

Leave a Comment