Table: dbo.GL_Transaction_Note | |||
Columns | |||
Name | Type | Constraints | Description |
gl_transaction_note_KEY | int (4) | NOT NULL | Primary key |
gl_transaction_KEY | int (4) | NOT NULL | Foreign key to the bank transaction table |
is_accountant_note | bit (1) | NOT NULL | Boolean that indicates if the note is for the accountant |
note | nvarchar (2048) | NOT NULL | The actual note text |
Primary key | |||
Name | Columns | Description | |
PK_GL_Transaction_Note | gl_transaction_note_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_GL_Transaction_Note__GL_Transaction__gl_transaction_KEY | gl_transaction_KEY | GL_Transaction (gl_transaction_KEY) |