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