Table: dbo.Billing_Item
Columns
NameTypeConstraintsDescription
billing_item_KEYint (4)NOT NULLPrimary key for this table
descriptionnvarchar (100)NOT NULLDescription of this billing item
invoice_descriptionnvarchar (100)NOT NULLDescription displayed on invoice
amountdecimal (9, 2)NOT NULLAssociated amount (for fixed type)
use_additional_feebit (1)NOT NULLFlag, true when additional fee applies
additional_feedecimal (9, 2)NOT NULLFee posted for items beyond whats defined in table
use_final_rate_for_feebit (1)NOT NULLFlag, true when same rate is used for all items
link_to_all_clientsbit (1)NOT NULLFlag, true for this billing item to be automatically linked to all clients
is_taxablebit (1)NOT NULLFlag to indicate if this billing item is taxable
billing_fee_type_KEYint (4)NOT NULLForeign key; billing items billing fee type
billing_calculation_type_KEYint (4)Foreign key; billing items billing calculation type
applies_to_payroll_checksbit (1)NOT NULLFlag to indicate if this billing item applies to payroll checks
applies_to_vendor_checksbit (1)NOT NULLFlag to indicate if this billing item applies to vendor checks
billing_calculation_method_KEYnvarchar (20)NOT NULLForeign key; calculation method for this billing item
graduated_table_maximum_unit_countint (4)When NOT NULL sets an upper range limit on the graduated table.
print_as_discountbit (1)NOT NULLFlag; if true, then show the difference between graduated table calculation methods as a discount on the invoice.
print_orderint (4)NOT NULLNumeric value to indicate the relative printing order of the billing item on the invoice.
fees__gl_account_KEYint (4)Key to the firm-client gl_account for billing fees.
delivery__gl_account_KEYint (4)Key to the firm-client gl_account for billing delivery.
receivable__gl_account_KEYint (4)Key to the firm-client gl_account for billing receivables.
sales_tax__gl_account_KEYint (4)Key to the firm-client gl_account for billing sales tax.
discount__gl_account_KEYint (4)Key to the firm-client gl_account for billing discounts.
exclude_client_copybit (1)NOT NULLWhether or not a form fee should exclude the client copy.
billing_item_guiduniqueidentifier (16)NOT NULLUniquely identifies the billing item across firm databases.
Primary key
NameColumnsDescription
PK_Billing_Itembilling_item_KEY
Unique constraints
NameColumnsDescription
UK_Billing_Item$descriptiondescription
Foreign keys
NameColumnsReferenced tableDescription
FK_Billing_Item__Billing_Calculation_Method__billing_calculation_method_KEYbilling_calculation_method_KEYBilling_Calculation_Method (billing_calculation_method_KEY)
FK_Billing_Item__Billing_Calculation_Type__billing_calculation_type_KEYbilling_calculation_type_KEYBilling_Calculation_Type (billing_calculation_type_KEY)
FK_Billing_Item__Billing_Fee_Type__billing_fee_type_KEYbilling_fee_type_KEYBilling_Fee_Type (billing_fee_type_KEY)
FK_Billing_Item__GL_Account__delivery__gl_account_KEYdelivery__gl_account_KEYGL_Account (gl_account_KEY)
FK_Billing_Item__GL_Account__discount__gl_account_KEYdiscount__gl_account_KEYGL_Account (gl_account_KEY)
FK_Billing_Item__GL_Account__fees__gl_account_KEYfees__gl_account_KEYGL_Account (gl_account_KEY)
FK_Billing_Item__GL_Account__receivable__gl_account_KEYreceivable__gl_account_KEYGL_Account (gl_account_KEY)
FK_Billing_Item__GL_Account__sales_tax__gl_account_KEYsales_tax__gl_account_KEYGL_Account (gl_account_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Billing_Item_Form_Rate__Billing_Item__billing_item_KEYbilling_item_KEYBilling_Item_Form_Rate
FK_Client_Billing_Item__Billing_Item__billing_item_KEYbilling_item_KEYClient_Billing_Item
FK_Client_Billing_Item__Billing_Item__shipping__billing_item_KEYshipping__billing_item_KEYClient_Billing_Item
FK_BS_Billing_Item__GL_Account__deliverybilling_item_KEYBS_Billing_Item__GL_Account__delivery
FK_BS_Billing_Item__GL_Account__discountbilling_item_KEYBS_Billing_Item__GL_Account__discount
FK_BS_Billing_Item__GL_Account__sales_taxbilling_item_KEYBS_Billing_Item__GL_Account__sales_tax
FK_BS_Billing_Item__GL_Account__receivablebilling_item_KEYBS_Billing_Item__GL_Account__receivable
FK_BS_Billing_Item__GL_Account__feesbilling_item_KEYBS_Billing_Item__GL_Account__fees
FK_Billing_Fee_Schedule__Billing_Item__billing_item_KEYbilling_item_KEYBilling_Fee_Schedule
FK_Billing_Item_Schedule__Billing_Item__billing_item_KEYbilling_item_KEYBilling_Item_Schedule

Schema diagram