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 |