| 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 | |