| 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 | ||