!!!Alias: DGA
Unique Keys: ___\\
Child Table: ___\\
Parent Table: ___\\
\\
Information about all the GL Accounts.

!!Table Columns
\\
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y|
|[DGC_ID]|Number(10)|[ID]|Y|link to [P2K_CM_GL_COMPANIES]
|[GL_ACCOUNT_CODE]|Varchar2(16)|[CODE]|Y|
|[ACCOUNT_TYPE]|Varchar2(2)|[X_ACCOUNT_TYPE]|Y|
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[JOURNAL_TYPE]|Varchar2(2)|[X_JOURNAL_TYPE]|Y|
|[ACCOUNT_USAGE]|Varchar2(4)|[X_ACCOUNT_USAGE]| |
|[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| |
|[DISTRIBUTION_MASK]|Varchar2(50)|[DISTRIBUTION]| |
|[AFFECTS_COSTING]|Varchar2(1)|[TOGGLE]| |
|[PRE_PAYROLL]|Varchar2(1)|[TOGGLE]| |
|[POST_PAYROLL]|Varchar2(1)|[TOGGLE]| |
|[RETAIN_DETAIL]|Varchar2(1)|[TOGGLE]| |
|[ACCRUAL_REQUIRED]|Varchar2(1)|[TOGGLE]| |
|[INTERCOMPANY_REQUIRED]|Varchar2(1)|[TOGGLE]| |
|[POSTING_DATE_METHOD]|Varchar2(2)|[X_POSTING_DATE_METHOD]| |
|[GL_ACCOUNT_SUFX]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[DEN_ID]|Number(10)|[ID]| |link to [P2K_CM_ENTITIES]
|[DUN_ID]|Number(10)|[ID]| |link to [P2K_CM_UNITS]
|[DGR_ID]|Number(10)|[ID]| |link to [P2K_CM_GROUPS]
|[DSP_ID]|Number(10)|[ID]| |link to [P2K_CM_STATE_PROVINCES]
|[DCN_ID]|Number(10)|[ID]| |link to [P2K_CM_COUNTIES]
|[DTX_ID]|Number(10)|[ID]| |link to [P2K_CM_TAX_JURISDICTIONS]
|[DSD_ID]|Number(10)|[ID]| |link to [P2K_CM_SCHOOL_DISTRICTS]
|[ACCOUNT_CHARGE_TO]|Varchar2(2)|[X_ACCOUNT_CHARGE_TO]| |

User Fields: Allowed\\
Audit Logging: Allowed\\


----
![Notes|Edit:Internal.P2K_CM_GL_ACCOUNTS] 	
[{InsertPage page='Internal.P2K_CM_GL_ACCOUNTS' default='Click to create a new notes page'}]