Table: dbo.Customer_Historical_AR_Transaction
This table stores the link to any AR Transactions that are considered historical transactions for a customer.
Columns
Name | Type | Constraints | Description
gl_transaction_KEY | int (4) | NOT NULL | Primary key for this table and FK to the AR Transaction table
customer_KEY | int (4) | NOT NULL | FK to the Customer table

Primary key
Name | Columns | Description
PK_Customer_Historical_AR_Transaction$gl_transaction_KEY | gl_transaction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Customer_Historical_AR_Transaction__AR_Transaction__gl_transaction_KEY | gl_transaction_KEY | AR_Transaction (gl_transaction_KEY) |
FK_Customer_Historical_AR_Transaction__Customer__customer_KEY | customer_KEY | Customer (customer_KEY) |