DynDeveloper.com

DynDeveloper.com

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

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..GL00105 Table Definition

(COMPANY..Account Index Master)

This table stores all Account Index fields for each account number to insure data integrity should an account record be damaged in the Account Master table.  For each record in the Account Master table, there is a corresponding record in the Account Index Master table. 

           

Comments:

All non-GL modules instead of the full-sized account number to store the Account Index conserve data space.  Should an account record be removed from the Account Master table, a check link can be run on the Account Master table and the Account Index Master table will be used to restore the connection between the Account Number and Account Index fields.  This will insure greater data integrity and prevent the loss of account number links in subsidiary modules.


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
join GL00100 on GL00100.ACTINDX = GL00105.ACTINDX
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
ACTNUMSTchar(129) Account Nu...(more) Join Now
GP 9
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9
ACTNUMBR_7char PAM40202.ACTNUMBR_7
GP 2010
ACTNUMBR_8char PAM50901.ACTNUMBR_8
GP 2010
ACTNUMBR_9char PAM40202.ACTNUMBR_9
GP 2010
ACTNUMBR_10char PAM40202.ACTNUMBR_10
GP 2010