Table: dbo.Billing_Item
Columns
Name | Type | Constraints | Description
billing_item_KEY | int (4) | NOT NULL | Primary key for this table
description | nvarchar (100) | NOT NULL | Description of this billing item
invoice_description | nvarchar (100) | NOT NULL | Description displayed on invoice
amount | decimal (9, 2) | NOT NULL | Associated amount (for fixed type)
use_additional_fee | bit (1) | NOT NULL | Flag, true when additional fee applies
additional_fee | decimal (9, 2) | NOT NULL | Fee posted for items beyond whats defined in table
use_final_rate_for_fee | bit (1) | NOT NULL | Flag, true when same rate is used for all items
link_to_all_clients | bit (1) | NOT NULL | Flag, true for this billing item to be automatically linked to all clients
is_taxable | bit (1) | NOT NULL | Flag to indicate if this billing item is taxable
billing_fee_type_KEY | int (4) | NOT NULL | Foreign key; billing items billing fee type
billing_calculation_type_KEY | int (4) |  | Foreign key; billing items billing calculation type
applies_to_payroll_checks | bit (1) | NOT NULL | Flag to indicate if this billing item applies to payroll checks
applies_to_vendor_checks | bit (1) | NOT NULL | Flag to indicate if this billing item applies to vendor checks
billing_calculation_method_KEY | nvarchar (20) | NOT NULL | Foreign key; calculation method for this billing item
graduated_table_maximum_unit_count | int (4) |  | When NOT NULL sets an upper range limit on the graduated table.
print_as_discount | bit (1) | NOT NULL | Flag; if true, then show the difference between graduated table calculation methods as a discount on the invoice.
print_order | int (4) | NOT NULL | Numeric value to indicate the relative printing order of the billing item on the invoice.
fees__gl_account_KEY | int (4) |  | Key to the firm-client gl_account for billing fees.
delivery__gl_account_KEY | int (4) |  | Key to the firm-client gl_account for billing delivery.
receivable__gl_account_KEY | int (4) |  | Key to the firm-client gl_account for billing receivables.
sales_tax__gl_account_KEY | int (4) |  | Key to the firm-client gl_account for billing sales tax.
discount__gl_account_KEY | int (4) |  | Key to the firm-client gl_account for billing discounts.
exclude_client_copy | bit (1) | NOT NULL | Whether or not a form fee should exclude the client copy.
billing_item_guid | uniqueidentifier (16) | NOT NULL | Uniquely identifies the billing item across firm databases.

Primary key
Name | Columns | Description
PK_Billing_Item | billing_item_KEY |
Unique constraints
Name | Columns | Description
UK_Billing_Item$description | description |

Foreign keys
Name | Columns | Referenced table | Description
FK_Billing_Item__Billing_Calculation_Method__billing_calculation_method_KEY | billing_calculation_method_KEY | Billing_Calculation_Method (billing_calculation_method_KEY) |
FK_Billing_Item__Billing_Calculation_Type__billing_calculation_type_KEY | billing_calculation_type_KEY | Billing_Calculation_Type (billing_calculation_type_KEY) |
FK_Billing_Item__Billing_Fee_Type__billing_fee_type_KEY | billing_fee_type_KEY | Billing_Fee_Type (billing_fee_type_KEY) |
FK_Billing_Item__GL_Account__delivery__gl_account_KEY | delivery__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Billing_Item__GL_Account__discount__gl_account_KEY | discount__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Billing_Item__GL_Account__fees__gl_account_KEY | fees__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Billing_Item__GL_Account__receivable__gl_account_KEY | receivable__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Billing_Item__GL_Account__sales_tax__gl_account_KEY | sales_tax__gl_account_KEY | GL_Account (gl_account_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Billing_Item_Form_Rate__Billing_Item__billing_item_KEY | billing_item_KEY | Billing_Item_Form_Rate |
FK_Client_Billing_Item__Billing_Item__billing_item_KEY | billing_item_KEY | Client_Billing_Item |
FK_Client_Billing_Item__Billing_Item__shipping__billing_item_KEY | shipping__billing_item_KEY | Client_Billing_Item |
FK_BS_Billing_Item__GL_Account__delivery | billing_item_KEY | BS_Billing_Item__GL_Account__delivery |
FK_BS_Billing_Item__GL_Account__discount | billing_item_KEY | BS_Billing_Item__GL_Account__discount |
FK_BS_Billing_Item__GL_Account__sales_tax | billing_item_KEY | BS_Billing_Item__GL_Account__sales_tax |
FK_BS_Billing_Item__GL_Account__receivable | billing_item_KEY | BS_Billing_Item__GL_Account__receivable |
FK_BS_Billing_Item__GL_Account__fees | billing_item_KEY | BS_Billing_Item__GL_Account__fees |
FK_Billing_Fee_Schedule__Billing_Item__billing_item_KEY | billing_item_KEY | Billing_Fee_Schedule |
FK_Billing_Item_Schedule__Billing_Item__billing_item_KEY | billing_item_KEY | Billing_Item_Schedule |