Not logged in - Login

GP Table Listing

Listing (of most) of the table in Microsoft Great Plains company database.

Table Physical NameSeriesTable Technical Name
ACTIVITYSystemSY_Current_Activity
BM00101InventorybmBill
BM00111InventorybmBillComp
BM10200InventorybmTrx
BM10300InventorybmTrxComp
BM10400InventorybmTrxSerialLot
BM30100InventorybmBatchHist
BM30200InventorybmTrxHist
BM30300InventorybmTrxCompHist
BM30400InventorybmTrxSerialLotHist
BM40100InventorybmSetup
CM00100FinancialCM_Checkbook_MSTR
CM10100FinancialCM_Deposit_WORK
CM10101FinancialCM_Deposit_Work_Totals
CM20100FinancialCM_Journal
CM20200FinancialCM_Transaction
CM20201FinancialCM_Transaction_Totals
CM20300FinancialCM_Receipt
CM20400FinancialCM_Distribution
CM20400FinancialCM_Distribution_DUP
CM20500FinancialCM_Reconcile_HDR
CM20501FinancialCM_Reconcile_Adjustments
CM20600FinancialCM_Transfer
CM40100FinancialCM_SETP
CM40101FinancialCM_Transaction_SETP
coAccounCompanycoAccountCache
coPeriodCompanycoPeriodCache
DD00100PayrollddEmpMstr
DD00200PayrollddEmpAcctMstr
DD10100PayrollddDeposits
DD10200PayrollddACHCopy
DD10300PayrollddACHCrossRef
DD10400PayrollddACHHdr
DD10500PayrollddACHItems
DD10600PayrollddPrenotesCompleted
DD10700PayrollddExceptions
DD40100PayrollddSetup
DD40200PayrollddChkMsgsSetup
DD40400PayrollddACHFtrSetup
DD40400PayrollddACHHdrSetup
DD40500PayrollddACHPrenotesSetup
DD40600PayrollddDeductionLinkSetup
DTA00100FinancialDTA_Group_MSTR
DTA00200FinancialDTA_Code_MSTR
DTA00300FinancialDTA_Account_Groups
DTA00301FinancialDTA_Account_Group_Codes
DTA10100FinancialDTA_Transaction_Groups_WORK
DTA10200FinancialDTA_Transaction_Codes_WORK
GL00100FinancialGL_Breakdown_Account_MSTR
GL00100FinancialGL_Distribution_Account_MSTR
GL00100FinancialGL_Account_MSTR_CopyA
GL00100FinancialGL_Account_MSTR
GL00102FinancialGL_Account_Category_MSTR
GL00103FinancialGL_Allocation_Fixed_MSTR
GL00104FinancialGL_Allocation_Variable_MSTR
GL00105FinancialGL_Account_Index_MSTR
GL00200FinancialGL_Budget_MSTR
GL00201FinancialGL_Budget_SUM_MSTR
GL10000FinancialGL_TRX_HDR_WORK
GL10001FinancialGL_TRX_LINE_WORK
GL10002FinancialGL_TRX_Clearing_WORK
GL10100FinancialGL_Business_Form_HDR_WORK
GL10101FinancialGL_Business_Form_LINE_WORK
GL10110FinancialGL_Account_SUM_MSTR
GL10111FinancialGL_Account_SUM_HIST
GL11110FinancialGL_Account_SUM_MSTR_View
GL11111FinancialGL_Account_SUM_HIST_View
GL20000FinancialGL_YTD_TRX_OPEN
GL30000FinancialGL_Account_TRX_HIST
GL40000FinancialGL_SETP
GL40100FinancialGL_Business_Form_SETP
GL40101FinancialGL_Business_Form_Account_SETP
GL40200FinancialGL_Segment_Description_SETP
GL40300FinancialglPostingNumbersSetup
GL50400FinancialGL_Period_Consolidation_Activity
IC40100SystemIC_Account_SETP
IV00101InventoryIV_Item_MSTR
IV00102InventoryIV_Item_MSTR_QTYS
IV00103InventoryIV_Item_MSTR_VNDR
IV00104InventoryIV_Item_MSTR_KIT
IV00105InventoryivItemCurr
IV00106InventoryivItemPurch
IV00107InventoryivItemPriceListOpt
IV00108InventoryivItemPriceList
IV00109InventoryIV_SerialNumberMask
IV00200InventoryIV_Serial_MSTR
IV00300InventoryIV_Lot_MSTR
IV00301InventoryIV_Lot_Attributes
IV10000InventoryIV_TRX_WORK_HDR
IV10001InventoryIV_TRX_WORK_LINE
IV10002InventoryIV_TRX_WORK_Serial_Lot
IV10200InventoryIV_Purchase_Receipts
IV10300InventoryivStockCount
IV10301InventoryivStockCountLine
IV10302InventoryivStockCountSerialLot
IV10303InventoryivStockCountUofM
IV30100InventoryIV_TRX_HIST_Batch
IV30101InventoryIV_SUM_HIST
IV30102InventoryIV_SUM_HIST_Period
IV30200InventoryIV_TRX_HIST_HDR
IV30300InventoryIV_TRX_HIST_LINE
IV30301InventoryIV_TRX_HIST_LINE_DTL
IV30400InventoryIV_TRX_HIST_Serial_Lot
IV30500InventoryIV_Distribution_HIST
IV30600InventoryIV_TRX_HIST_Lot_Attributes
IV30700InventoryivStockCountHist
IV30701InventoryivStockCountLineHist
IV30702InventoryivStockCountSerialLotHist
IV40100InventoryIV_SETP
IV40201InventoryIV_UofM_SETP_HDR
IV40202InventoryIV_UofM_SETP_DTL
IV40400InventoryIV_Item_Class_SETP
IV40401InventoryivItemClassCurr
IV40500InventoryIV_Lot_Type_SETP
IV40600InventoryIV_User_Category_SETP
IV40700InventoryIV_Location_SETP
IV40800InventoryIV_Price_Level_SETP
IV40900InventoryivPriceGroup
IV41000InventoryivStockCalendar
IV41001InventoryivExceptionDays
IVC10100SalesIVC_HDR_WORK
IVC10101SalesIVC_LINE_WORK
IVC10102SalesIVC_Serial_Lot_WORK
IVC10103SalesIVC_LINE_Comment
IVC10200SalesIVC_Payment_WORK
IVC10300SalesIVC_Distribution
IVC10400SalesIVC_Commission
IVC10500SalesIVC_Taxes
IVC30100SalesIVC_Batch_HIST
IVC30101SalesIVC_HDR_HIST
IVC30102SalesIVC_LINE_HIST
IVC40100SalesIVC_SETP
IVC40101SalesIVC_Document_SETP
MC00100SystemMC_Exchange_Rate_MSTR
MC00200FinancialMC_Currency_Account_MSTR
MC00201FinancialMC_Account_Summary_MSTR
MC00300FinancialMC_Account_Rate_MSTR
MC00500CompanyMC_Batch_Headers
MC020102SalesMC_RM_TransactionsDebitCopy
MC020102SalesMC_RM_Transactions
MC020103PurchasingMC_PM_Transactions
MC020104SalesMC_RM_Revaluation
MC020105PurchasingMC_PM_Revaluation
MC10000FinancialMC_Revaluation_HDR_WORK
MC10001FinancialMC_Revaluation_LINE_WORK
MC30001FinancialMC_Account_Summary_HIST
MC40000FinancialMC_SETP
MC40100FinancialMC_Rate_Type_SETP
MC40200SystemMC_Currency_SETP
MC40201FinancialMC_Currency_Account_SETP
MC40300SystemMC_Exchange_Table_SETP
MC40301FinancialMC_Exchange_Table_Account_SETP
MC40400SystemmcEuroHdrSetup
MC40401SystemmcEuroLineSetup
MC40500FinancialMC_User_Preferences
MC60100SystemMC_Currency_Access
MC60200SystemMC_Exchange_Table_Access
MC60400FinancialmcEuroEnable
ORG00100SystemORG_Relation_MSTR
ORG40000SystemORG_Level_SETP
ORG40100SystemORG_Entity_SETP
PM00100PurchasingPM_Class_MSTR
PM00101PurchasingpmClassAccounts
PM00200PurchasingPM_Vendor_MSTR
PM00201PurchasingPM_Vendor_MSTR_SUM
PM00202PurchasingPM_Vendor_MSTR_Period_SUM
PM00203PurchasingpmVendorAccounts
PM00300PurchasingPM_Address_MSTR
PM00400PurchasingPM_Key_MSTR
PM10000PurchasingPM_Transaction_WORK
PM10100PurchasingPM_Distribution_WORK_OPEN
PM10200PurchasingPM_Apply_To_WORK_OPEN
PM10201PurchasingPM_Payment_Apply_WORK
PM10300PurchasingPM_Payment_WORK
PM10400PurchasingPM_Manual_Payment_WORK
PM10500PurchasingPM_Tax_WORK
PM10600PurchasingPM_Distribution_Void_WORK
PM10801PurchasingPM_Payment_Stub_Duplicate
PM10902PurchasingPM_Tax_Void_WORK
PM20000PurchasingPM_Transaction_OPEN
PM30200PurchasingPM_Paid_Transaction_HIST
PM30300PurchasingPM_Apply_To_HIST
PM30600PurchasingPM_Distribution_HIST
PM30700PurchasingPM_Tax_HIST
PM30800PurchasingPM_Tax_Invoices
PM40100PurchasingPM_SETP
PM40101PurchasingPM_Period_SETP
PM40102PurchasingPM_Document_Type_SETP
PM40103PurchasingPM_Distribution_Type_SETP
PM80100PurchasingPM_Reprint_Batch_Headers
PM80200PurchasingPM_Reprint_Void_Payment
PM80300PurchasingPM_Reprint_Void_Transaction
PM80500PurchasingPM_Reprint_Apply_To
PM80600PurchasingPM_Reprint_Distribution
PM80700PurchasingPM_Reprint_Tax
PM80800PurchasingPM_Reprint_Transaction_Check
PM80905PurchasingPM_Apply_Document_Browse
PM81000PurchasingpmModifyAccounts
POP00101PurchasingPOP_Buyer
POP10100PurchasingPOP_PO
POP10110PurchasingPOP_POLine
POP10150PurchasingPOP_POComment
POP10300PurchasingPOP_Receipt
POP10310PurchasingPOP_ReceiptLine
POP10330PurchasingPOP_SerialLot
POP10360PurchasingPOP_Tax
POP10390PurchasingPOP_Distribution
POP10500PurchasingPOP_PORcptApply
POP10550PurchasingPOP_Comment
POP10600PurchasingPOP_ShipIvcApply
POP30000PurchasingPOP_BatchHist
POP30100PurchasingPOP_POHist
POP30110PurchasingPOP_POLineHist
POP30300PurchasingPOP_ReceiptHist
POP30310PurchasingPOP_ReceiptLineHist
POP30330PurchasingPOP_SerialLotHist
POP30360PurchasingPOP_TaxHist
POP30390PurchasingPOP_DistributionHist
POP40100PurchasingPOP_Setup
POP40600PurchasingpopNonIVItemCurr
RM00101SalesRM_Customer_MSTR
RM00102SalesRM_Customer_MSTR_ADDR
RM00103SalesRM_Customer_MSTR_SUM
RM00104SalesRM_Customer_MSTR_Period_SUM
RM00105SalesRM_NationalAccounts_MSTR
RM00201SalesRM_Class_MSTR
RM00301SalesRM_Salesperson_MSTR
RM00302SalesRM_Salesperson_MSTR_SUM
RM00303SalesRM_Sales_Territory_MSTR
RM00305SalesRM_Sales_Territory_MSTR_SUM
RM00401SalesRM_Keys_MSTR
RM10101SalesRM_Distribution_WORK
RM10201SalesRM_Cash_WORK
RM10301SalesRM_Sales_WORK
RM10501SalesRM_Commission_WORK
RM10504SalesRM_Unpaid_Removed_Commissions
RM10601SalesRM_Tax_WORK
RM10901SalesRM_Aging_Reconcile_Control
RM20101SalesRM_OPEN
RM20101SalesRM_OPENDebitCopy
RM20102SalesRM_Realtime_OPEN_WORK
RM20201SalesRM_Applied_OPEN
RM30101SalesRM_HISTORY
RM30201SalesRM_Applied_History
RM30202SalesRM_Applied_Journal_Reprint
RM30301SalesRM_Distribution_History
RM30501SalesRM_Commission_History
RM30502SalesRM_Batch_History
RM30601SalesRM_Tax_History
RM40101SalesRM_Module_SETP
RM40201SalesRM_Period_SETP
RM40401SalesRM_Document_SETP
RM40601SalesRM_Statement_Messages_SETP
SOP00100SalesSOP_Process_Holds_MSTR
SOP00200SalesSOP_Prospect_MSTR
SOP10100SalesSOP_HDR_WORK
SOP10101SalesSOP_Commission_WORK_HIST
SOP10102SalesSOP_Distribution_WORK_HIST
SOP10103SalesSOP_Payment_WORK_HIST
SOP10104SalesSOP_Process_Holds_WORK_HIST
SOP10105SalesSOP_Tax_WORK_HIST
SOP10106SalessopUsrDefWorkHist
SOP10200SalesSOP_LINE_WORK
SOP10201SalesSOP_Serial_Lot_WORK_HIST
SOP10202SalesSOP_LINE_CMT_WORK_HIST
SOP30100SalesSOP_Batch_HIST
SOP30200SalesSOP_HDR_HIST
SOP30201SalesSOP_Deposit_HIST
SOP30300SalesSOP_LINE_HIST
SOP40100SalesSOP_SETP
SOP40200SalesSOP_ID_SETP
SOP40201SalesSOP_Default_Holds_SETP
SOP40300SalesSOP_Document_SETP
SOP40400SalesSOP_User_Defined_SETP
SOP40500SalesSOP_Master_Number_SETP
SOP40600SalessopNonIVItemCurr
SOP60100SalesSOP_POPLink
SOP70100SalesSOP_Restrictions_MSTR
STN41100SystemST_Printer_Options_MSTR
STN41200SystemST_Printer_Assign_MSTR
STN41250SystemST_Printer_Assign_MODE
STN41300SystemST_Printer_Settings_MSTR
STN41350SystemST_Printer_Users_MSTR
SY00300CompanySY_Account_Format_Setup
SY003001SystemSY_Account_Definition_HDR
SY00302SystemSY_Account_Definition_LINE
SY00400CompanySY_Work_Maintenance_MSTR
SY00500CompanyBatch_Headers
SY00500CompanyBatch_Headers_DUP
SY00600CompanySY_Location_MSTR
SY00700CompanySY_Notes_MSTR
SY00800SystemSY_Batch_Activity_MSTR
SY00801SystemSY_ResourceActivity
SY00900CompanySY_Source_Document_MSTR
SY01000CompanySY_Transaction_Source_MSTR
SY01100CompanySY_Posting_Account_MSTR
SY01200CompanycoINetAddrs
SY01300CompanycoProcess
SY01301SystemcoProcessCleanup
SY01400SystemSY_Users_MSTR
SY01401CompanycoUserDefaults
SY01402SystemsyUserDefaults
SY01500SystemSY_Company_MSTR
SY01600SystemSY_Initialization_MSTR
SY01990SystemsyShortcutMstr
SY02000SystemSY_Security_Normal_MSTR
SY02200CompanySY_Posting_Journal_Destination
SY02300CompanySY_Posting_Journal_Settings
SY02400SystemSY_System_Password_MSTR
SY02500CompanySY_End_Routines_MSTR
SY02600SystemSY_User_Notes_MSTR
SY02700SystemSY_End_Routines_Master_MSTR
SY02800CompanySY_End_Routines_Check_MSTR
SY03000CompanySY_Shipping_Methods_MSTR
SY03003SystemSY_Account_Definition_Template
SY03100CompanySY_Credit_Card_MSTR
SY03300CompanySY_Payment_Terms_MSTR
SY03400CompanySY_File_Maintenance_Error_Log
SY03500SystemSY_Registration
SY03900CompanySY_Record_Notes_MSTR
SY04100FinancialCM_Bank_MSTR
SY04200CompanySY_Comment_MSTR
SY04300SystemSY_Security_Log_SETP
SY04400SystemSY_Process_Server_Log
SY04701SystemSY_Process_Server_Server_SETP
SY04702SystemSY_Process_Server_Service_SETP
SY04703SystemSY_Process_Server_Manager_SETP
SY04704SystemSY_Process_Server_Service_MSTR
SY04800CompanycoINetPrompts
SY05000SystemSY_Security_Log
SY05300SystemSY_Language_MSTR
SY40100CompanySY_Period_SETP
SY40101CompanySY_Period_HDR
SY40300SystemSY_Class_Normal_SETP
SY40400SystemSY_Class_Main_SETP
SY60100SystemSY_User_Company_Access_REL
SY80000SystemSY_Module_Options
SY90000CompanySY_User_Object_Store
TX00101CompanyTX_Schedule_MSTR_HDR
TX00102CompanyTX_Schedule_MSTR
TX00201CompanyTX_Detail_MSTR
TX00202CompanyTX_Detail_MSTR_SUM
TX00203CompanyTX_Detail_Period_SUM
TX00300CompanytaxReturn
TX00301CompanytaxReturnException
TX00302CompanytaxReturnEuInputTax
TX00303CompanytaxReturnGLException
TX40101CompanyTX_Module_SETP
UPR00100PayrollUPR_MSTR
UPR00102PayrolluprMstrAddress
UPR00300PayrollUPR_MSTR_Tax_Info
UPR00400PayrollUPR_MSTR_Pay_Type
UPR00402PayrolluprMstrPayTypePostDated
UPR00500PayrollUPR_MSTR_Deduction
UPR00501PayrollUPR_MSTR_Deduction_Based_On
UPR00600PayrollUPR_MSTR_Benefit
UPR00601PayrollUPR_MSTR_Benefit_Based_On
UPR00700PayrollUPR_MSTR_State_Tax
UPR00800PayrollUPR_MSTR_Local_Tax
UPR00900PayrollUPR_Employee_SUM
UPR00901PayrollUPR_Employee_Tips_SUM
UPR10100PayrollUPR_Year_End_WORK_HDR
UPR10101PayrollUPR_Year_End_WORK_Wage
UPR10103PayrollUPR_Year_End_WORK_Pension
UPR10104PayrollUPR_Year_End_WORK_Special
UPR10105PayrollUPR_Year_End_WORK_State
UPR10106PayrollUPR_Year_End_WORK_Local
UPR10107PayrollUPR_Year_End_WORK_Other
UPR10200PayrollUPR_WORK_MSTR
UPR10201PayrollUPR_WORK_MSTR_Detail
UPR10202PayrollUPR_WORK_HDR
UPR10203PayrollUPR_WORK_Pay_Type
UPR10204PayrollUPR_WORK_Deduction
UPR10205PayrollUPR_WORK_Benefit
UPR10206PayrollUPR_WORK_State_Tax
UPR10207PayrollUPR_WORK_Local_Tax
UPR10208PayrollUPR_WORK_Check
UPR10209PayrollUPR_WORK_Post
UPR10210PayrollUPR_Build_Check_Defaults
UPR10211PayrollUPR_Build_Check_Defaults_Detail
UPR10213PayrolluprWorkChkDesc
UPR10300SystemUPR_Activity
UPR10301PayrollUPR_TRX_Batch_HDR
UPR10302PayrollUPR_TRX_Batch_Detail
UPR10303PayrollUPR_TRX_Audit
UPR10304SystemUPR_TRX_Batch_Activity
UPR10307PayrollUPR_Manual_Check_HDR
UPR10308PayrollUPR_Manual_Check_Detail
UPR10309PayrollUPR_Keys_MSTR
UPR10400PayrollUPR_Distribution_WORK
UPR19900PayrollUPR_Flat_Tax_Records
UPR19901PayrollUPR_Account_Cache
UPR30100PayrollUPR_Check_HIST
UPR30200PayrollUPR_Federal_Tax_Liability
UPR30300PayrollUPR_Transaction_HIST
UPR30400PayrollUPR_Distribution_HIST_HDR
UPR30401PayrollUPR_Distribution_HIST_Detail
UPR40100PayrollUPR_SETP_Futa/Suta
UPR40101PayrollUPR_Futa/Suta_TSA
UPR40200PayrollUPR_SETP_Info
UPR40300PayrollUPR_SETP_Department
UPR40301PayrollUPR_SETP_Job_Title
UPR40500PayrollUPR_SETP_Account
UPR40501PayrollUPR_SETP_Tax_Exp/With
UPR40600PayrollUPR_SETP_Pay_Type
UPR40700PayrollUPR_SETP_Workers_Comp
UPR40800PayrollUPR_SETP_Benefit
UPR40801PayrollUPR_SETP_Benefit_Based_On
UPR40900PayrollUPR_SETP_Deduction
UPR40901PayrollUPR_SETP_Deduction_Based_On
UPR40902PayrollUPR_SETP_Deduction_Sequence
UPR41100PayrollUPR_SETP_State_Code
UPR41105SystemUPR_SETP_Country_Code
UPR41200PayrollUPR_SETP_Class
UPR41201PayrollUPR_SETP_Class_Detail
UPR41300Payroll TaxUPR_SETP_Tax
UPR41301Payroll TaxUPR_SETP_Tax_Status
UPR41302Payroll TaxUPR_SETP_Tax_Table
UPR41303Payroll TaxUPR_SETP_Tax_Date
UPR41400PayrollUPR_SETP_Local_Tax
UPR41401PayrollUPR_SETP_Local_Tax_Table
UPR41500PayrolluprSetupShiftCode
UPR41600SystemuprEmployeeCount
VAT00200CompanyVAT_IV_Comm_Code
VAT00300CompanyVAT_ADDR_MSTR
VAT10000CompanyVAT Tax Comm Code MSTR
VAT10001CompanyVAT Country Code MSTR
VAT10002CompanyVAT Transport Mode MSTR
VAT10003CompanyVAT Transaction Nature MSTR
VAT10004CompanyVAT Process Type MSTR
VAT10005CompanyVAT Value Basis MSTR
VAT10100SalesRM_Class_Intrastat_MSTR
VAT10101SalesRM_Customer_Intrastat_MSTR
VAT10200PurchasingPM_Class_Intrastat_MSTR
VAT10201PurchasingPM_Vendor_Intrastat_MSTR
VAT10301CompanyVAT_WORK
VAT10302CompanyVAT_INTRA_WORK
W200001SystemW2_Mag_Media_MSTR
W200002SystemW2_Mag_Media_Detail
W200005SystemW2_MMREF1_MSTR
W200006SystemW2_MMREF1_Detail
wkPostingValidationStateFinancialwkPostingValidationState