Table: dbo.AR_Transaction_Item_GL_Account | |||
This table stores GL Accounts for AR Transaction Items and the type for that account. | |||
Columns | |||
Name | Type | Constraints | Description |
ar_transaction_item_gl_account_KEY | int (4) | NOT NULL | Primary key for this table. |
ar_transaction_item_KEY | int (4) | NOT NULL | The AR Transaction Item to link to the gl account. |
gl_account_KEY | int (4) | NOT NULL | gl account for the AR Transaction Item. |
ar_transaction_item_gl_account_type_KEY | int (4) | NOT NULL | The type of gl account. |
Primary key | |||
Name | Columns | Description | |
PK_AR_Transaction_Item_GL_Account | ar_transaction_item_gl_account_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_AR_Transaction_Item_GL_Account$ar_transaction_item_KEY$ar_transaction_item_gl_account_type_KEY | ar_transaction_item_KEY, ar_transaction_item_gl_account_type_KEY |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_AR_Payment_Application_Distribution__AR_Transaction_Item_GL_Account__ar_transaction_item_gl_account_KEY | ar_transaction_item_gl_account_KEY | AR_Payment_Application_Distribution |