GP Tables

Field Value Reference

Decode what numeric field values mean in Dynamics GP. 38 fields documented.

Field Description
ACCTTYPE Account Type
ACTINDX Account Index
BACHFREQ Batch Frequency
CNTRLTYP Control Type
CREDTLMT Credit Limit Type
CURNCYID Currency ID
DCSTATUS Document Status
DISTTYPE Distribution Type (Payables)
DOCTYPE Document Type (Payables)
FOBTYPE Free On Board
FXDORVAR Fixed or Variable Allocation
HOLD Hold Status
INACTIVE Active Status
ITEMTYPE Item Type
ITMTRKOP Item Tracking Option
ITMVNDTY Item Vendor Type
KTACCTSR Kit COGS Account Source
ORDERPOLICY Order Policy
PCHSRCTY Purchase Receipt Type
PRICMTHD Price Method
PSTGSTUS Posting Status
PSTNGTYP Posting Type
PYENTTYP Payment Type
PYMTTYPE Payment Type (SOP)
QTYTYPE Quantity Type
RCRDTYPE Record Type (Quantity Master)
SERIES Module Series
SMRYTYPE Summary Type
SOPTYPE SOP Document Type
STCKCNTSTTS Stock Count Status
TAXOPTNS Tax Options
TEN99TYPE 1099 Type
TPCLBLNC Typical Balance
TRXTYPE Transaction Type
VCTNMTHD Valuation Method
VENDSTTS Vendor Status
VOIDSTTS Void Status
VOTEFLAG Void Flag