DynDeveloper.com

DynDeveloper.com

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

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..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?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
ACTINDXint Account In...(more) Join Now
GP 9
ACTNUMBR_1char(5) Account Nu...(more) Join Now
GP 9
ACTNUMBR_2char(5) Account Nu...(more) Join Now
GP 9
ACTNUMBR_3char(5) Account Nu...(more) Join Now
GP 9
ACTNUMBR_4char(5) Account Nu...(more) Join Now
GP 9
ACTNUMBR_5char(5) Account Nu...(more) Join Now
GP 9
ACTNUMBR_6char PAM50901.ACTNUMBR_6
GP 2010
ACTALIASchar(21) Account Al...(more) Join Now
GP 9
ACTNUMBR_7char PAM40202.ACTNUMBR_7
GP 2010
MNACSGMTchar(67) Main Accou...(more) Join Now
GP 9
ACCTTYPEsmallint

Account...(more) Join Now


GP 9
ACTNUMBR_8char PAM50901.ACTNUMBR_8
GP 2010
ACTNUMBR_9char PAM40202.ACTNUMBR_9
GP 2010
ACTDESCRchar(51) Account De...(more) Join Now
GP 9
ACTNUMBR_10char PAM40202.ACTNUMBR_10
GP 2010
PSTNGTYPsmallint

Posting...(more) Join Now


GP 9
ACCATNUMsmallint Account Ca...(more) Join Now
GP 9
ACTIVEtinyint

Active:...(more) Join Now


GP 9
TPCLBLNCsmallint

Typical...(more) Join Now


GP 9
DECPLACSsmallint Decimal Pl...(more) Join Now
GP 9
FXDORVARsmallint

Fixed O...(more) Join Now


GP 9
BALFRCLCsmallint

Balance...(more) Join Now


GP 9
DSPLKUPSbinary(4) Display In...(more) Join Now
GP 9
CNVRMTHDsmallint Conversion...(more) Join Now
GP 9
HSTRCLRTnumeric(19,7) Historical...(more) Join Now
GP 9
NOTEINDXnumeric(19,5) Note Index...(more) Join Now
GP 9
join SY03900 on SY03900.NOTEINDX = GL00100.NOTEINDX
CREATDDTdatetime Created Da...(more) Join Now
GP 9
MODIFDTdatetime Date the r...(more) Join Now
GP 9
USERDEF1char(21) UserDefine...(more) Join Now
GP 9
USERDEF2char(21) UserDefine...(more) Join Now
GP 9
PostSlsInsmallint Post Sales...(more) Join Now
GP 9
PostIvInsmallint Post Inven...(more) Join Now
GP 9
PostPurchInsmallint Post Purch...(more) Join Now
GP 9
PostPRInsmallint Post Payro...(more) Join Now
GP 9
ADJINFLtinyint Adjust for...(more) Join Now
GP 9
INFLAREVint Inflation ...(more) Join Now
GP 9
INFLAEQUint Inflation ...(more) Join Now
GP 9
ACCTENTRtinyint Allow Acco...(more) Join Now
GP 9
USRDEFS1char(31) User Defin...(more) Join Now
GP 9
USRDEFS2char(31)

User De...(more) Join Now


GP 9
Clear_Balancetinyint 0 - Roll B...(more) Join Now
GP 2013
DEX_ROW_TSdatetime Time Stamp...(more) Join Now
GP 10
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9