MICROSOFT DYNAMICS GREAT PLAINS ( MS GP ) TABLE DEFINITION GUIDE / REFERENCE

Bank Rec Tables

Commonly Used Tables:

• CM00100 – Checkbook Master   - setup information like GL account, next check and deposit numbers and checkbook balance
• CM10100 – Deposit Work   – saved unposted deposit data
• CM20100 – Bank Rec Journal   - contains a record for each posted transaction, allows for reprinting of some bank rec posting journals
• CM20200 – Transactions   - all transaction data except receipts
• CM20201 – Transaction Totals   - information for posted deposits
• CM20300 – Receipts  - all receipts (deposited and undeposited)
• CM20400 – Distributions   - GL distributions for all bank rec transactions
• CM20500 – Reconciliation Headers   - header information entered during bank reconciliation
• CM20501 – Reconcile Adjustments   - adjustments on current reconciliations
• CM20600 – Transfers

INACTIVE in CM00100:
0 – Active
1 – Inactive

CNTRLTYP (Control Type):
1 – Transaction
2 – Receipt

CMTrxType (Transaction Type) and abbreviation:
1 – DEP – Deposit
2 – RCT – Receipt [not used in CM20200]
3 – CHK – Check
4 – WDL – Withdrawal
5 – IAJ – Increase Adjustment
6 – DAJ – Decrease Adjustment
7 – XFR – Transfer
101 – INT – Interest Income
102 – OIN – Other Income
103 – OEX – Other Expense
104 – SVC – Service Charge

DEPTYPE (Deposit Type):
1 – Deposit with Receipts
2 – Deposit without Receipts
3 – Clearing Deposit

DEPOSITED:
0 – False
1 – True

RcpType (Receipt Type):
1 – Check
2 – Cash
3 – Credit Card

Company/System Tables

Commonly Used Tables – Company databases:
SY00500 – Batch Master
SY01200 – Internet Addresses
SY02200 – Posting Journal Destinations
SY03900 – Record Notes Master

Commonly Used Tables – System (DYNAMICS) database:
ACTIVITY – User Activity
SY003001 – Account Definition Header
SY00302 – Account Definition Detail
SY00800 – Batch Activity
SY00801 – Resource Activity
SY01400 – Users Master
SY01500 – Company Master

Security Tables in GP 10.0 – System (DYNAMICS) database:
SY09000 – Task master 
SY09100 – Role master 
SY09200 – Alternate or modified form and report ID master 
SY10500 – Role assignment master 
SY10550 – DEFAULTUSER task ID assignment master 
SY10600 – Tasks assignments master 
SY10700 – Operations assignments master 
SY10750 – DEFAULTUSER task assignment 
SY10800 – Alternate or modified form and report ID assignment master

Official list of BCHSTTUS (Batch Status) in SY00500:
0 – Available
1 – Marked to Post
2 – Available / Delete
3 – Marked / Receive
4 – Marked
5 – Marked / Print
6 – Marked / Update
7 – Posting Interrupted
8 – Journal Printing Interrupted
9 – Table Updates Interrupted
10 – Recurring Batch Error – Edit Required
11 – Single Use Error – Edit Required
15 – Computer Check Posting Error
110 – Checks Printing
130 – Remittance Processing

Francisco’s list of BCHSTTUS (Batch Status) in SY00500:
[This is a much more comprehensive list posted by Francisco Hillyer in a GP Newsgroup - provided courtesy of e-mail by Robert Cavill - thanks Robert and Francisco!]
0 – Available
1 - Batch Posting
2 - Batch Being Deleted
3 - Batch Receiving Transactions
4 - Batch Done Posting
5 - Being Printed
6 - Being Updated
7 - Interrupted While Posting
8 - Interrupted While Printing
9 - Interrupted While Updating
10 - Recurring Batch Errors / Transactions Did Not Post
11 - Single Batch Error / Transactions Did Not Post
15 - Error While Posting Computer Checks
20 - Interrupted While Processing Computer Checks
25 - Interrupted While Printing Computer Checks Align
30 - Interrupted While Printing Computer Checks
35 - Interrupted While Printing Computer Checks Align Before Reprint Computer Checks
40 - Interrupted While Voiding Checks
45 - Interrupted While Reprinting Checks
50 - Interrupted While Processing Remittance Report
55 - Interrupted While Processing Remittance Report Align
60 - Interrupted While Printing Remittance Report
100 – Processing Computer Checks
105 – Check Align Being Printed Before Print Checks
110 – Printing Computer Checks
115 – Check Align Being Printed Before Reprint Checks
120 – Voiding Computer Checks
125 – Reprint Computer Checks
130 – Remittance Report
135 – Printing Remittance Align Form
140 – Printing Remittance Form

Series:
1 – All
2 – Financial
3 – Sales
4 – Purchasing
5 – Inventory
6 – Payroll
7 – Project
10 – 3rd Party

BACHFREQ (Batch Frequency):
1 – Single Use
2 – Weekly
3 – Biweekly
4 – Semimonthly
5 – Monthly
6 – Bimonthly
7 – Quarterly
8 – Miscellaneous

Fixed Assets Tables

Commonly Used Tables:
FA00100 – Asset General Information Master
FA00200 – Book Master
FA00400 – Asset Account Master
FA00500 – Lease Master
FA00600 – Insurance Master
FA00902 – Financial Detail Master
FA19900 – User Data Master
FA41200 – Insurance Class Setup
FA41600 – Lease Company Setup

ASSETTYPE (Asset Type):
1 – New
2 – Used
3 – Leased

ASSETSTATUS (Asset Status):
1 – Active
2 – Deleted
3 – Partial Open
4 – Retired

PROPTYPE (Property Type):
1 – Personal
2 – Personal, Listed
3 – Real
4 – Real, Listed
5 – Real, Conservation
6 – Real, Energy
7 – Real, Farms
8 – Real, Low Income Housing
9 – Amortizable

Reporting Notes:
Most of the tables will use the Asset Index (ASSETINDEX), not the Asset ID, so link the tables on that.

GL Tables

Commonly Used Tables:
GL00100 – Account Master
GL00102 – Account Category Master
GL00105 – Account Index Master [contains concatenated account number]
GL10000 – Transaction Work/Unposted (header)
GL10001 – Transaction Work/Unposted (line detail)
GL10110 – Open Year Summary Master
GL10111 – Historical Year Summary Master
GL20000 – Open Year Posted Transactions
GL30000 – Historical Year Transactions
DTA10100 – MDA Transaction Groups
DTA10200 – MDA Transaction Codes

Summary Views:
GL11110 – Open Year Summary Master
GL11111 – Historical Year Summary Master
[Note: These views show debits, credits and net changes per period per account, they do not show the period balances. The reason to use these and not the corresponding GL10110 and GL10111 tables is that these views also include the Account Description.]

ACCTTYPE (Account Type):
1 – Posting Account
2 – Unit Account
3 – Posting Allocation Account
4 – Unit Allocation Account

PSTNGTYP (Posting Type):
0 – Balance Sheet
1 – Profit and Loss

Active:
0 – Inactive
1 – Active

TPCLBLNC (Typical Balance):
0 – Debit
1 – Credit

FXDORVAR (Fixed or Variable):
1 – Fixed Allocation
2 – Variable Allocation

ACCATNUM (Account Category):
1 – Cash
2 – Short Term Investments
3 – Accounts Receivable
4 – Notes Receivable
5 – Inventory
6 – Work In Process
7 – Prepaid Expenses
8 – Long-Term Investments
9 – Property, Plant and Equipment
10 – Accumulated Depreciation
11 – Intangible Assets
12 – Other Assets
13 – Accounts Payable
14 – Notes Payable
15 – Current Maturities Of Long-Term Debt
16 – Taxes Payable
17 – Interest Payable
18 – Dividends Payable
19 – Leases Payable (Current)
20 – Sinking Fund Payable (Current)
21 – Other Current Liabilities
22 – Long-Term Debt
23 – Common Stock
24 – Preferred Stock
25 – Additional Paid-In Capital – Common
26 – Additional Paid-In Capital – Preferred
27 – Retained Earnings
28 – Treasury Stock
29 – Common Dividends
30 – Preferred Dividends
31 – Sales
32 – Sales Returns And Discounts
33 – Cost Of Goods Sold
34 – Selling Expense
35 – Administrative Expense
36 – Salaries Expense
37 – Other Employee Expenses
38 – Interest Expense
39 – Tax Expense
40 – Depreciation Expense
41 – Income Tax Expense
42 – Other Expenses
43 – Other Income
44 – Charges Not Using Working Capital
45 – Revenues Not Producing Working Capital
46 – Gain/Loss On Asset Disposal
47 – Amortization Of Intangible Assets
48 – Non-Financial Accounts
[Note: Many installations that we have seen have changed the account category names to better fit their chart of accounts. Any categories created in addition to these defaults are marked with a * in GP, even thought they have a valid category number in the GL00102 table.]

DECPLACS (Decimal Places):
[Used for Unit Accounts]
1 – 0
2 – 1
3 – 2

TRXTYPE (Transaction Type) in GL10000:
0 – Standard
1 – Reversing

Series (in GL tables):
1 – All
2 – Financial
3 – Sales
4 – Purchasing
5 – Inventory
6 – Payroll – USA
7 – Project
10 – 3rd Party

DTA_Series (in DTA tables):
2 – Financial
3 – Sales
4 – Purchasing
10 - Invoicing
11 – Sales Order Processing
12 – Purchase OrderProcessing

BACHFREQ (Batch Frequency):
1 – Single Use
2 – Weekly
3 – Biweekly
4 – Semimonthly
5 – Monthly
6 – Bimonthly
7 – Quarterly
8 – Miscellaneous

PSTGSTUS (Posting Status) in DTA10100:
1 – Work
2 – Open
3 – History
4 – Originating (not in the GL yet)

Inventory Tables

Commonly Used Tables:
IV00101 – Item Master
IV00102 – Item Quantity Master
IV00103 – Item Vendor Master
IV00108 – Item Price List
IV10000 – Unposted/Work Transactions (header)
IV10001 – Unposted/Work Transactions (line detail)
IV00118 – Item Cost Change History
IV10000 – Inventory Transaction Work (header)
IV10001 – Inventory Transaction Amounts Work (line detail)
IV10200 – Purchase Receipts (header)
IV10201 – Purchase Receipts Detail (line detail)
IV10300 – Unposted Stock Count (header)
IV10301 – Unposted Stock Count (line detail)
IV30101 – Sales Summary History
IV30102 – Sales Summary Period History
IV30200 – Transaction History (header)
IV30300 – Transaction Amounts History (line detail)
IV30301 – Transaction Amounts Detail History
IV30700 – Stock Count History (header)
IV30701 – Stock Count Line History (line detail)
IV40600 – Item Category Setup
IV40700 – Site Setup

Inventory Transaction Document Types:
1 – Inventory Adjustment
2 – Variance
3 – Inventory Transfer
4 – Purchase Receipt
5 – Sales Returns
6 – Sales Invoices
7 – Assembly

Inventory Valuation Methods:
1 – FIFO Perpetual
2 – LIFO Perpetual
3 – Average Perpetual
4 – FIFO Periodic
5 – LIFO Periodic

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

RCRDTYPE (Record Type) in IV00102:
1 – Overall record (total for all sites)
2 – Site record

ORDERPOLICY (Order Policy) in IV00102:
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 IV00103:
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):
1 – Taxable
2 – Nontaxable
3 – Base on customer / vendor

ITMTRKOP (Item Tracking Option):
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 IV10000:
0 – New Transaction
1 – Unposted
2 – Posted
3 – Posted with Error

Source Indicator in IV10000:
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

PM Tables

Commonly Used Tables:
PM00200 – Vendor Master
PM00201 – Vendor Master Summary
PM00202 - Vendor Period Summary
PM00400 – PM Keys Master
PM10000 - Work/Unposted Transactions
PM10100 – GL Distributions for Work and Open Transactions
PM10200 – Apply To Work/Open
PM10300 – Work/Unposted Payments
PM10400 – Work/Unposted Manual Payments
PM20000 – Open/Posted Transactions
PM30200 – Historical/Paid Transactions
PM30300 – Apply To History
PM30600 – GL Distributions for Historical Transactions
MC020103 – Multicurrency Payables Transactions

DOCTYPE (Document Type):
1 – Invoice
2 – Finance Charge
3 – Misc Charge
4 – Return
5 – Credit Memo
6 – Payment (Check, Cash, or Credit Card)

DISTTYPE (PM Distribution Type):
1 – Cash
2 – Payable
3 – Discount Available
4 – Discount Taken
5 – Finance Charge
6 – Purchase
7 – Trade Disc.
8 – Misc. Charge
9 – Freight
10 – Taxes
11 – Writeoffs
12 – Other
13 – GST Disc
14 – PPS Amount

PM AGE BY:
0 = Due Date
1 = Document Date

TEN99TYPE (1099 Type):
1 – Not a 1099 Vendor
2 – Divident
3 – Interest
4 – Miscellaneous
5 – Withholding

PSTGSTUS (Posting Status) in PM10000:
10 - transaction being entered for the first time before it has been saved by the used
20 - saved but unposted transaction
30 -  transaction that is currently realtime posting
40 - posted transaction
50 - transactions that has encountered an error during posting
60 - transaction that has been saved previously and has a status of 20 is now being edited by a user
70 - transaction that has been posted previously in a recurring batch that still contains unposted transactions is now being edited by the user

PSTGSTUS (Posting Status) in PM10100:
0 – Unposted
1 – Posted
3 – Unposted  [used for Computer Checks, not in the SDK]

CNTRLTYP (Control Type):
0 – Voucher types
1 – Payment types
2 – Printed alignment forms

DCSTATUS (Document Status):
0 – Reserved
1 – Work
2 – Open
3 – History

VENDSTTS (Vendor Status):
1 – Active
2 – Inactive
3 – Temporary

CREDTLMT (Credit Limit) in PM00200:
[Thanks to Bud Cool, a frequent contributor to the Microsoft GP Newsgroup, for this information!]
0 – No Credit
1 – Unlimited
2 – Amount  
[Note: If CREDTLMT = 2 then CRLMTDLR contains the amount of the credit limit, otherwise CRLMTDLR is zero]

HISTTYPE (History Type):
0 – Calendar
1 – Fiscal

POP Tables

Commonly Used Tables:
POP10100 – Purchase Order Work (header)
POP10110 – Purchase Order Line Work (line detail)
POP10150 – Purchase Order Comment (header)
POP10300 – Receipt Work (header)
POP10310 – Receipt Work Line (line detail)
POP10330 – Serial / Lot Work
POP10500 – Receipt Line Quantities (line detail)
POP10550 – Line Item Comment (line detail)
POP30100 – Purchase Order History (header)
POP30110 – Purchase Order Line History (line detail)
POP30300 – Receipt History (header)
POP30310 – Receipt Line History (line detail)
POP30330 – Serial / Lot History
POP30390 – Distribution History
POA40003 – PO Approval Control

Status in POP10500:
0 – Unposted
1 – Posted
2 – Voided

PO Status:
1 – New
2 – Released
3 – Change Order
4 – Received
5 – Closed
6 – Cancelled

STATGRP (Status Group):
0 – Voided [this is not a valid according to the SDK, but we have seen it for voided PO's]
1 – Active (includes New, Open and Modified)
2 – Closed (includes Cancelled and Closed)

[Note: In our experience, when a PO is voided and it moves to the history tables, in POP30100 the STATGRP will be 1 or 0 whereas for a regularly closed PO the STATGRP will be 2. Also, there is a value starting with POPVT in TRXSORCE of POP30310 for voided PO's.]

PO Type:
1 – Standard
2 – Drop Ship
3 – Blanket
4 – Blanket Drop Ship

POLNESTA (PO Line Status):
1 – New
2 – Released
3 – Change Order
4 – Received
5 – Closed
6 – Cancelled

POPTYPE (POP Receipt Type):
1 – Shipment
2 – Invoice
3 – Shipment/Invoice
4 – Return
5 – Return w/Credit
6 – Inventory Return
7 – Inventory Return w/Credit

[Thanks to Frank Hamelly of GP2theMax for the complete list of POP Receipt Types, as these are not in the SDK.]

DISTTYPE (Distribution Type):
1 – Purchases
2 – Trade Discounts
3 – Freight
4 – Miscellaneous
5 – Tax
6 – Discounts Available
7 – Accounts Payable
8 – Other
9 – Accrued
10 – Round

NONINVEN (Non-Inventory):
0 – Inventory item
1 – Non-inventory item

DECPLCUR (Decimal Places for Currency):
7 – 0
8 – 1
9 – 2
10 – 3
11 – 4
12 – 5

DECPLQTY (Decimal Places for Quantity):
1 – 0
2 – 1
3 – 2
4 – 3
5 – 4
6 – 5

DOCTYPE in POP10550:
1 – PO
2 – Receipt

ITMTRKOP (Item Tracking):
1 – None
2 – Serial Numbers
3 – Lot Numbers

PO Approval Status in POA40003:
1 – Unapproved
2 – Approved

PO Note ID Array in POP10100:
1 - PO Note Index – POP_PONOTEID_PO
2 - Buyer Note Index – POP_PONOTEID_BUYER
3 - Vendor ID Index – POP_PONOTEID_VENDOR
4 - Comment Note Index – POP_PONOTEID_COMMENT
5 - Payment Term ID Note Index – POP_PONOTEID_PAYTERM
6 - Shipping Method Note Index – POP_PONOTEID_SHIPMETHOD
7 - Currency ID Index – POP_PONOTEID_CURRENCY
8 - Tax Schedule Index – POP_PONOTEID_TAXSCHED
9 - Freight Tax Schedule Index – POP_PONOTEID_FREIGHTTAXSCHED
10-  Misc Tax Schedule Index – POP_PONOTEID_MISCTAXSCHED
11 - Contract Number Index – POP_PONOTEID_CONTRACTNUMBER
12 - not used at this time
13 - not used at this time
14 - not used at this time
15 – not used at this time

PO Line Note ID Array Array in POP10110:
1 - Item Number Note Index – POP_POLINENOTEID_ITEM
2 - Location Code Note Index – POP_POLINENOTEID_SITE
3 - Line Comment Note Index – POP_POLINENOTEID_COMMENT
4 - Inventory Index Note Index – POP_POLINENOTEID_ACCOUNT
5 - PO Line Note Index – POP_POLINENOTEID_LINE
6 - Item Tax Schedule Note Index – POP_POLINENOTEID_ITEMTAXSCHED
7 - Site Tax Schedule Note Index – POP_POLINENOTEID_SITETAXSCHED
8 - Landed Cost Group ID Note Index – POP_POLINENOTEID_LCGROUPID
9 – Shipping Method Note Index – POP_POLINENOTEID_SHIPPINGMETHOD

RM Tables

Commonly Used Tables:
RM00101 – Customer Master
RM00102 – Customer Addresses
RM00103 – Customer Master Summary
RM00104 – Customer Period Summary
RM00401 – RM Key File
RM10101 – Distribution Work and Open
RM10201 – Work/Unposted Cash Receipts
RM10301 – Work/Unposted Sales Transactions
RM20101 – Open Transactions
RM20201 – Open Transactions Apply
RM30101 – Historical Transactions
RM30201 – Historical Transactions Apply
RM30301 – Distribution History

RMDTYPAL – RM Document Types:
0 – Reserved for balance carried forward records
1 – Sale / Invoice
2 – Reserved for scheduled payments
3 – Debit Memo
4 – Finance Charge
5 – Service Repair
6 – Warranty
7 – Credit Memo
8 – Return
9 – Payment

VOIDSTTS – Void Status in RM20101 and RM30101:
0 – Not voided
1 – Voided
2 – NSF check
3 – Waived finance charge

CSHRCTYP – Cash Receipt Type in RM20101 and RM30101:
0 – Check
1 – Cash
2 – Credit Card

BACHFREQ – Batch Frequency:
1 – Single Use
2 – Weekly
3 – Biweekly
4 – Semimonthly
5 – Monthly
6 – Bimonthly
7 – Quarterly
8 – Miscellaneous

HISTTYPE – History Type in RM00104:
0 – Calendar
1 – Fiscal

DCSTATUS – Document Status in RM00401:
0 – Reserved
1 – Work
2 – Open
3 – History

DISTTYPE – Distribution Type:
1 – Cash  (CASH)
2 – Terms Taken  (TAKEN)
3 – Accounts Receivable  (RECV)
4 – Writeoffs  (WRITE)
5 – Terms Available  (AVAIL)
6 – GST  (GST)
7 – PPS  (WH)
8 – Other  (OTHER)
9 – Sales  (SALES)
10 – Trade  (TRADE)
11 – Frieght  (FREIGHT)
12 – Miscellaneous  (MISC)
13 – Taxes  (TAXES)
14 – COGS  (COGS)
15 – Inventory  (INV)
16 – Finance Charges  (FNCHG)
17 – Returns  (RETURNS)
18 – Debit Memo  (DRMEMO)
19 – Credit Memo  (CRMEMO)
20 – Service  (SERVICE)
21 – Warranty Expense  (WARREXP)
22 – Warranty Sales  (WARRSLS)
23 – Commissions Expense  (COMMEXP)
24 – Commissions Payable  (COMMPAY)
25 – Unit Account  (UNIT)
26 – Rounding  (ROUND)
27 – Realized Gain  (RZGAIN)
28 – Realized Loss  (RZLOSS)
29 – Unrealized Gain  (URZGAIN)
30 – Unrealized Loss  (URZLOSS)

SOP Tables

Commonly Used Tables:

• SOP10100 – Unposted/Work Transactions (header)  - one record per unposted sales transaction
• SOP10200 – Unposted/Work Transactions (line detail)  - one record per line item on unposted sales transactions (for kits, there will be one record per kit component)
• SOP10101 – Commissions Work and History
• SOP10102 – GL Distributions Work and History  - GL distributions for posted and unposted Invoices, Returns and Fulfillment Orders
• SOP10103 – Payment Work and History  - one record per payment entered on sales transaction
• SOP10104 – Process Holds Work and History
• SOP10106 – User Defined Work and History
• SOP10107 – Tracking Numbers Work and History
• SOP10201 – Serial/Lot Work and History
• SOP10202 – Line Comment Work and History
• SOP30200 – Historical Transactions (header)  - one record per posted sales transaction
• SOP30300 – Historical Transactions (line detail)  - one record per line item on posted sales transactions (for kits, there will be one record per kit component)
• SOP60100 – SOP-POP Link  - one record for each link to a PO line, unique link on: SOPNUMBE, SOPTYPE, LNITMSEQ
• SOP60300 – Customer Item Numbers

SOPTYPE (SOP Document Types):
1 – Quote
2 – Order
3 – Invoice
4 – Return
5 – Back Order
6 – Fulfillment Order

Distribution Types:
1 – SALES
2 – RECV
3 – CASH
4 – TAKEN
5 – AVAIL
6 – TRADE
7 – FREIGHT
8 – MISC
9 – TAXES
10 – MARK
11 – COMMEXP
12 – COMMPAY
13 – OTHER
14 – COGS
15 – INV
16 – RETURN
17 – IN USE
18 – IN SERVICE
19 – DAMAGED
20 – UNIT
21 – DEPOSITS
22 – ROUND
23 – REBATE

PYMTTYPE (Payment Type) in SOP10103:
1 – Cash Deposit
2 – Check Deposit
3 – Credit Card Deposit
4 – Cash Payment
5 – Check Payment
6 – Credit Card Payment
[Note:  The PYMTTYPE values in the GP SDK are not correct, at least for the recent versions of GP - thank you to Beth Lott for bringing that to my attention.  I have confirmed the values above with GP Support.]

Decimal Places (for both Quantity and Currency):
1 – 0
2 – 1
3 – 2
4 – 3
5 – 4
6 – 5

Transaction Frequency:
1 – Weekly
2 – Biweekly
3 – Semimonthly
4 – Monthly
5 – Bimonthly
6 – Quarterly
7 – Miscellaneous

PURCHSTAT (Purchasing Status):
1 – None (will always be this for Quote, Return and Invoice)
2 – Needs Purchase
3 – Purchased
4 – Partially Received
5 – Fully Received

QTYTYPE (Quantity Type):
1 – On Hand
2 – Returned
3 – In Use
4 – In Service
5 – Damaged

PROSPECT:
0 – Existing Customer
1 – Prospect

COMAPPTO (Commission Applied To):
0 – Sales
1 – Invoice Total

VOIDSTTS (Void Status):
0 – Not Voided
1 – Voided

DROPSHIP (Drop Ship):
0 – No Drop Ship
1 – Drop Ship

NONINVEN (Non-Inventory):
0 – Inventory item
1 – Non-inventory item

SOPSTATUS (SOP Status):
1 – New  (Order)
2 – Ready to Print Pick Ticket  (Fulfillment Order)
3 – Unconfirmed Pick  (Fulfillment Order)
4 – Ready to Print Pack Slip  (Fulfillment Order)
5 – Unconfirmed Pick  (Fulfillment Order)
6 – Shipped  (Fulfillment Order)
7 – Ready to Post  (Invoice)
8 – In Process  (Order)
9 – Complete  (Order)

DELETE1 (Delete)  in SOP10104:
0 – Not deleted
1 – Hold has been removed

Notes on reporting in SOP:

• Remember to filter out voided transactions.
• When linking SOP tables, always link on the SOPNUMBE and SOPTYPE.  While it doesn’t happen too often in real life, the system will allow you to have the same SOP number for different SOP types.
• On Invoices and Returns, QUANTITY is what was billed/credited, however, if you want to see the quantity in the ‘Base’ Unit of Measure (what the Inventory module keeps the quantities in), you will need to multiply the QUANTITY by the QTYBSUOM (Quantity in Base U of M).
• Returns will show up as positive numbers – you’ll need to subtract them yourself.