Table: dbo.Receivable_Transaction_Sales_Tax_Taxable_Item
The table used to link a sales tax to the related taxable fee.
Columns
NameTypeConstraintsDescription
sales_tax__receivable_transaction_detail_KEYint (4)NOT NULLPrimary key. Also the foreign key into the Receivable_Transaction_Detail table of the sales tax item
taxable_item__receivable_transaction_detail_KEYint (4)NOT NULLForeign key into the Receivable_Transaction_Detail table of the taxable item
Primary key
NameColumnsDescription
PK_Receivable_Transaction_Sales_Tax_Taxable_Item$sales_tax__receivable_transaction_detail_KEYsales_tax__receivable_transaction_detail_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Receivable_Transaction_Sales_Tax_Taxable_Item__Receivable_Transaction_Detail__sales_tax__receivable_transaction_detail_KEYsales_tax__receivable_transaction_detail_KEYReceivable_Transaction_Detail (receivable_transaction_detail_KEY)
FK_Receivable_Transaction_Sales_Tax_Taxable_Item__Receivable_Transaction_Detail__taxable_item__receivable_transaction_detail_KEYtaxable_item__receivable_transaction_detail_KEYReceivable_Transaction_Detail (receivable_transaction_detail_KEY)

Schema diagram