Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Module List > Module GL tables > GL00200
DynDeveloper Table Reference is in Wiki format! Registered users have the ability to improve the table reference, add comments, and generally make the world a better place.
You are currently viewing the COMPANY database.

COMPANY..GL00200 Table Definition

(COMPANY..Budget Master)
The easiest method is to create the budget ID in the budget maintenance window (but adding no accounts) then to import to the Budget Summary Master. Accounts with a typical credit balance would import budget figures as negative to show correctly on financial statements. Note: the Account Summary Master is no longer used for importing Budget data; the summary information is contained in the Budget Summary Master.

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
BUDGETID char(15)
Budget ID:...(more) Join Now
BUDCOMNT char(31)
Budget Com...(more) Join Now
BUDPWRD binary(16)
*Budget Pa...(more) Join Now
YEAR1 smallint
Year fisca...(more) Join Now
Based_On smallint
Based On: ...(more) Join Now
From_Date datetime

TODATE datetime

NOTEINDX numeric(19,5)
Note Index...(more) Join Now
join ... more text available
auto number (1,1)
Unique ide...(more) Join Now

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables