Table: dbo.AR_Deposit_Cash_Back_Distribution
This table is used to identify the Cash Back distribution, if any, for bank transactions of type AR Deposit.
Columns
NameTypeConstraintsDescription
ar_deposit__bank_transaction_KEYint (4)NOT NULLThis primary key shall be the key of an AR deposit bank transaction. The AR deposit must have a cash back bank transaction distribution to have an entry in this table.
cash_back__bank_transaction_distribution_KEYint (4)NOT NULLThis key is used to identify the bank transaction distribution that is the cash back bank transaction distribution of the AR deposit. An AR deposit may or may not have such a distribution.
Primary key
NameColumnsDescription
PK_AR_Deposit_Cash_Back_Distribution$ar_deposit__bank_transaction_KEYar_deposit__bank_transaction_KEY
Unique constraints
NameColumnsDescription
UK_AR_Deposit_Cash_Back_Distribution$cash_back__bank_transaction_distribution_KEYcash_back__bank_transaction_distribution_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_AR_Deposit_Cash_Back_Distribution__Bank_Transaction_Distribution__ar_deposit__bank_transaction_KEY__cash_back__bank_transactiar_deposit__bank_transaction_KEY, cash_back__bank_transaction_distribution_KEYBank_Transaction_Distribution (bank_transaction_KEY, bank_transaction_distribution_KEY)

Schema diagram