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 |

Foreign keys
Name | Columns | Referenced table | Description
FK_AR_Transaction_Item_GL_Account__AR_Transaction_Item__ar_transaction_item_KEY | ar_transaction_item_KEY | AR_Transaction_Item (ar_transaction_item_KEY) |
FK_AR_Transaction_Item_GL_Account__AR_Transaction_Item_GL_Account_Type__ar_transaction_item_gl_account_type_KEY | ar_transaction_item_gl_account_type_KEY | AR_Transaction_Item_GL_Account_Type (ar_transaction_item_gl_account_type_KEY) |
FK_AR_Transaction_Item_GL_Account__GL_Account__gl_account_KEY | gl_account_KEY | GL_Account (gl_account_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 |