Module List > Module GL tables GL00200
You are currently viewing the COMPANY database.
Change

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.
4Penny.net

Field Definitions:

What is the 'source' column?

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

TODATE datetime
'1/1/1900'

NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
DEX_ROW_ID int
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
3