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	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	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
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 #

Click to create a new notes page