Table: dbo.Customer_Historical_AR_Transaction
This table stores the link to any AR Transactions that are considered historical transactions for a customer.
Columns
NameTypeConstraintsDescription
gl_transaction_KEYint (4)NOT NULLPrimary key for this table and FK to the AR Transaction table
customer_KEYint (4)NOT NULLFK to the Customer table
Primary key
NameColumnsDescription
PK_Customer_Historical_AR_Transaction$gl_transaction_KEYgl_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Customer_Historical_AR_Transaction__AR_Transaction__gl_transaction_KEYgl_transaction_KEYAR_Transaction (gl_transaction_KEY)
FK_Customer_Historical_AR_Transaction__Customer__customer_KEYcustomer_KEYCustomer (customer_KEY)

Schema diagram