Table: dbo.GL_Account_Tickmark
This table contains the connection between a GL account and a tickmark.
Columns
NameTypeConstraintsDescription
gl_account_KEYint (4)NOT NULLThis points to a specific gl account.
tickmark_KEYint (4)NOT NULLThis points to a specific tickmark that belongs to a GL account.
gl_account_tickmark_KEYint (4)NOT NULLThe primary key.
gl_period_KEYint (4)NOT NULLPoints to a specific GL period.
Primary key
NameColumnsDescription
PK_GL_Account_Tickmarkgl_account_tickmark_KEY
Unique constraints
NameColumnsDescription
UK_GL_Account_Tickmark$gl_period_KEY$gl_account_KEYgl_period_KEY, gl_account_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Account_Tickmark__GL_Account__gl_account_KEYgl_account_KEYGL_Account (gl_account_KEY)
FK_GL_Account_Tickmark__GL_Period__gl_period_KEYgl_period_KEYGL_Period (gl_period_KEY)
FK_GL_Account_Tickmark__Tickmark__tickmark_KEYtickmark_KEYTickmark (tickmark_KEY)

Schema diagram