Table: dbo.Client_Billing_Sales_Tax
Columns
NameTypeConstraintsDescription
client_billing_sales_tax_KEYint (4)NOT NULLPrimary key for this table; dictionary to associate a client to a taxing authority for billing purposes
client_KEYint (4)NOT NULLForeign key; key of the client
taxing_authority_KEYint (4)NOT NULLForeign key; key of the taxing authority
apply_to_shippingbit (1)NOT NULLFlag to specify whether this tax applies to delivery items
apply_to_discountbit (1)NOT NULLFlag to specify whether this tax applies to discount items
exemptbit (1)NOT NULLFlag to specify whether this tax is exempt
sales_tax__gl_account_KEYint (4)Key to the gl_account table for sales tax account.
Primary key
NameColumnsDescription
PK_Client_Billing_Sales_Taxclient_billing_sales_tax_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Billing_Sales_Tax__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_Billing_Sales_Tax__GL_Account__sales_tax__gl_account_KEYsales_tax__gl_account_KEYGL_Account (gl_account_KEY)
FK_Client_Billing_Sales_Tax__Taxing_Authority__taxing_authority_KEYtaxing_authority_KEYTaxing_Authority (taxing_authority_KEY)

Schema diagram