DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
Module List > Module GL tables > GL00200

DynDeveloper Table Reference is now in Wiki format! Registered users have the ability to improve the table reference, add comments, and make the world a better place
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?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
BUDGETIDchar(15) Budget ID:...(more) Join Now
GP 9
BUDCOMNTchar(31) Budget Com...(more) Join Now
GP 9
BUDPWRDbinary(16) *Budget Pa...(more) Join Now
GP 9
YEAR1smallint Year fisca...(more) Join Now
GP 9
Based_Onsmallint Based On: ...(more) Join Now
GP 10
From_Datedatetime From Date:...(more) Join Now
GP 10
TODATEdatetime To Date: e...(more) Join Now
GP 10
NOTEINDXnumeric(19,5) Note Index...(more) Join Now
GP 9
join SY03900 on SY03900.NOTEINDX = GL00200.NOTEINDX
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9