Table: dbo.AR_Transaction_Item_GL_Account
This table stores GL Accounts for AR Transaction Items and the type for that account.
Columns
NameTypeConstraintsDescription
ar_transaction_item_gl_account_KEYint (4)NOT NULLPrimary key for this table.
ar_transaction_item_KEYint (4)NOT NULLThe AR Transaction Item to link to the gl account.
gl_account_KEYint (4)NOT NULLgl account for the AR Transaction Item.
ar_transaction_item_gl_account_type_KEYint (4)NOT NULLThe type of gl account.
Primary key
NameColumnsDescription
PK_AR_Transaction_Item_GL_Accountar_transaction_item_gl_account_KEY
Unique constraints
NameColumnsDescription
UK_AR_Transaction_Item_GL_Account$ar_transaction_item_KEY$ar_transaction_item_gl_account_type_KEYar_transaction_item_KEY, ar_transaction_item_gl_account_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_AR_Transaction_Item_GL_Account__AR_Transaction_Item__ar_transaction_item_KEYar_transaction_item_KEYAR_Transaction_Item (ar_transaction_item_KEY)
FK_AR_Transaction_Item_GL_Account__AR_Transaction_Item_GL_Account_Type__ar_transaction_item_gl_account_type_KEYar_transaction_item_gl_account_type_KEYAR_Transaction_Item_GL_Account_Type (ar_transaction_item_gl_account_type_KEY)
FK_AR_Transaction_Item_GL_Account__GL_Account__gl_account_KEYgl_account_KEYGL_Account (gl_account_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_AR_Payment_Application_Distribution__AR_Transaction_Item_GL_Account__ar_transaction_item_gl_account_KEYar_transaction_item_gl_account_KEYAR_Payment_Application_Distribution

Schema diagram