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