November 14, 2011

Tables Microsoft Great Plains
2010 and MS Dynamics GP 10

Author ALLAN JONES
Category Blog | Integration |
Share
  • 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.

Here you can create the content that will be used within the module.

Recent Blogs

Different Types of Cloud Services

Different Types of Cloud Services

Different Types of Cloud Services Author Category Share The IT industry is developing at lightning speed and shows no sign of slowing down. New tides of tech innovation keep hitting the...

read more