Table: dbo.AR_Transaction_Template_N_Customer
Links AR templates to customers. An AR template can have multiple customers selected for it and a customer can be used for multiple templates.
Columns
NameTypeConstraintsDescription
ar_transaction_template_N_customer_KEYint (4)NOT NULLA primary key.
transaction_template_KEYint (4)NOT NULLA link to an AR template.
customer_KEYint (4)NOT NULLA link to a customer.
Primary key
NameColumnsDescription
PK_AR_Transaction_Template_N_Customerar_transaction_template_N_customer_KEY
Unique constraints
NameColumnsDescription
UK_AR_Transaction_Template_N_Customer$customer_KEY$transaction_template_KEYcustomer_KEY, transaction_template_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_AR_Transaction_Template_N_Customer__AR_Transaction_Template__transaction_template_KEYtransaction_template_KEYAR_Transaction_Template (transaction_template_KEY)
FK_AR_Transaction_Template_N_Customer__Customer__customer_KEYcustomer_KEYCustomer (customer_KEY)

Schema diagram