DynDeveloper.com
Sign Up Now!
Log In
Home
Sign Up
Ask A Question
Knowledge Base
The Dynamics GP Table Reference
Our list of the Dynamics GP Tables, their structures and relationships
Visual Studio Tools For Dynamics GP
How Tos
Tutorials
Most popular posts
Code Examples
Menus for VS Tools
SDK
eConnect
Our Tutorials, Code Examples
Link to the Microsoft Help pages
Service Based Architecture
Tutorials, Code Examples
SQL Reporting Svcs
SQL General Purpose
SQL for Dynamics GP
SQL for Beginners
Web Services
Help, code samples, resources
VBA/Dynamics Modifier VBA mods
Our VBA code library
Integration Manager
Tools for working with Integration Manager
.NET Development
Code libraries
How Tos
Tutorials
Sage advice from the most
experienced coders around
Telerik Development
ASP.NET Menu
WinForms Menu
DevExpress
Dynamics GP
Dynamics 365
Extender
Tips and Tricks
SmartConnect
Dynamics Report Writer
Management Reporter
And More
Microsoft Access
Our Favorite Posts
More
Contact Us
Products We Recommend
Policies
Module List
>
Module GL tables
>
GL10111
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..GL10111
Table Definition
(
COMPANY..Account Summary History
)
This table displays period balances by Account Number.'
Field Definitions:
What is the 'source' column?
* the version information goes back to GP 9
Column Name
Data Type
Source
First Version
ACTINDX
int
Account In...(more)
Join Now
GP 9
join GL00100 on GL00100.ACTINDX = GL10111.ACTINDX
YEAR1
smallint
Year fisca...(more)
Join Now
GP 9
PERIODID
smallint
Period ID:...(more)
Join Now
GP 9
Ledger_ID
smallint
Ledger ID:...(more)
Join Now
GL10000.Ledger_ID
GP 2010
ACTNUMBR_1
char(5)
Account Nu...(more)
Join Now
GP 9
ACTNUMBR_2
char(5)
Account Nu...(more)
Join Now
GL00105.ACTNUMBR_2
GP 9
ACTNUMBR_3
char(5)
Account Nu...(more)
Join Now
GP 9
ACTNUMBR_4
char(5)
Account Nu...(more)
Join Now
GL00105.ACTNUMBR_4
GP 9
ACTNUMBR_5
char(5)
Account Nu...(more)
Join Now
GP 9
ACTNUMBR_6
char
PAM50901.ACTNUMBR_6
GP 2010
ACCATNUM
smallint
Account Ca...(more)
Join Now
GP 9
PERDBLNC
numeric(19,5)
SE00400.PERDBLNC
GP 9
ACTNUMBR_7
char
PAM40202.ACTNUMBR_7
GP 2010
ACTNUMBR_8
char
PAM50901.ACTNUMBR_8
GP 2010
CRDTAMNT
numeric(19,5)
Credit Amo...(more)
Join Now
GL10001.CRDTAMNT
GP 9
DEBITAMT
numeric(19,5)
Debit Amou...(more)
Join Now
GL10001.DEBITAMT
GP 9
ACTNUMBR_9
char
PAM40202.ACTNUMBR_9
GP 2010
DEX_ROW_ID
int
Unique aut...(more)
Join Now
GP 9
ACTNUMBR_10
char
PAM40202.ACTNUMBR_10
GP 2010