Table: dbo.GL_Account_Tickmark
This table contains the connection between a GL account and a tickmark.
Columns
Name | Type | Constraints | Description
gl_account_KEY | int (4) | NOT NULL | This points to a specific gl account.
tickmark_KEY | int (4) | NOT NULL | This points to a specific tickmark that belongs to a GL account.
gl_account_tickmark_KEY | int (4) | NOT NULL | The primary key.
gl_period_KEY | int (4) | NOT NULL | Points to a specific GL period.

Primary key
Name | Columns | Description
PK_GL_Account_Tickmark | gl_account_tickmark_KEY |
Unique constraints
Name | Columns | Description
UK_GL_Account_Tickmark$gl_period_KEY$gl_account_KEY | gl_period_KEY, gl_account_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_GL_Account_Tickmark__GL_Account__gl_account_KEY | gl_account_KEY | GL_Account (gl_account_KEY) |
FK_GL_Account_Tickmark__GL_Period__gl_period_KEY | gl_period_KEY | GL_Period (gl_period_KEY) |
FK_GL_Account_Tickmark__Tickmark__tickmark_KEY | tickmark_KEY | Tickmark (tickmark_KEY) |