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
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Module List > Module GL tables > GL00100
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.
Change

COMPANY..GL00100 Table Definition

(COMPANY..Account Master)

This table contains nonfinancial information about account numbers.

 

Required fields:

Account Number

Account Index

Main Account Segment

Account Type

Account Description

Posting Type

Account Category Number

Active

Typical Balance

Decimal Places

Fixed Or Variable

Balance For Calculation

Display In Lookups

Post Sales In

Post Inventory In

Post Purchasing In

Post Payroll In

 

Comments:

The following fields are assigned values only for specific account types:

Typical Balance: posting accounts only

Decimal Places: unit accounts only

Fixed Or Variable: allocations only

Balance For Calculation: variable allocations only.


4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
ACTINDX int
0
Account In...(more) Join Now
ACTNUMBR_1 char(5)
''
Account Nu...(more) Join Now
ACTNUMBR_2 char(5)
''
Account Nu...(more) Join Now
ACTNUMBR_3 char(5)
''
Account Nu...(more) Join Now
ACTNUMBR_4 char(5)
''
Account Nu...(more) Join Now
ACTNUMBR_5 char(5)
''
Account Nu...(more) Join Now
ACTALIAS char(21)
''
Account Al...(more) Join Now
ACTNUMBR_6 char
''
Account Number: This field is a composite of the individual account segments that were defined at the point of installation. Jude
ACTNUMBR_7 char
''
Account Number: This field is a composite of the individual account segments that were defined at the point of installation. Jude
MNACSGMT char(67)
''
Main Accou...(more) Join Now
ACTNUMBR_8 char
''
Account Number: This field is a composite of the individual account segments that were defined at the point of installation. Jude
ACCTTYPE smallint
0
p>Account ...(more) Join Now
ACTNUMBR_9 char
''
Account Number: This field is a composite of the individual account segments that were defined at the point of installation. Jude
ACTDESCR char(51)
''
Account De...(more) Join Now
ACTNUMBR_10 char
''

PSTNGTYP smallint
0
p>Posting ...(more) Join Now
ACCATNUM smallint
0
Account Ca...(more) Join Now
ACTIVE tinyint
0
p>Active:&...(more) Join Now
TPCLBLNC smallint
0
p>Typical ...(more) Join Now
DECPLACS smallint
0
Decimal Pl...(more) Join Now
FXDORVAR smallint
0
p>Fixed Or...(more) Join Now
BALFRCLC smallint
0
p>Balance ...(more) Join Now
DSPLKUPS binary(4)
0
Display In...(more) Join Now
CNVRMTHD smallint
0
Conversion...(more) Join Now
HSTRCLRT numeric(19,7)
0.00
Historical...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
CREATDDT datetime
'1/1/1900'
Created Da...(more) Join Now
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
USERDEF1 char(21)
''
UserDefine...(more) Join Now
USERDEF2 char(21)
''
UserDefine...(more) Join Now
PostSlsIn smallint
0
Post Sales...(more) Join Now
PostIvIn smallint
0
Post Inven...(more) Join Now
PostPurchIn smallint
0
Post Purch...(more) Join Now
PostPRIn smallint
0
Post Payro...(more) Join Now
ADJINFL tinyint
0
Adjust for...(more) Join Now
INFLAREV int
0
Inflation ...(more) Join Now
INFLAEQU int
0
Inflation ...(more) Join Now
ACCTENTR tinyint
0
Allow Acco...(more) Join Now
USRDEFS1 char(31)
''
User Defin...(more) Join Now
USRDEFS2 char(31)
''
p>User Def...(more) Join Now
Clear_Balance tinyint
0
0 - Roll B...(more) Join Now
DEX_ROW_TS datetime
(getutcdate())
Time Stamp...(more) Join Now
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