Table: dbo.Client_Billing_Item
Columns
Name | Type | Constraints | Description
client_billing_item_KEY | int (4) | NOT NULL | Primary key for this table; the client-level billing item
client_KEY | int (4) | NOT NULL | Foreign key; key of the client
billing_item_KEY | int (4) | NOT NULL | Foreign key; the associated frim-level billing item
shipping__billing_item_KEY | int (4) |  | Foreign key; the associated shipping billing item
sales_tax_applies | bit (1) | NOT NULL | Flag to denote that sales tax applies to this billing item
discount_applies | bit (1) | NOT NULL | Flag to denote that the discount applies to this billing item
waive_until_date | smalldatetime (4) |  | Fees associated with this billing item are waived until this date
include_detail_on_invoice | bit (1) | NOT NULL | Flag to denote that detail information should be displayed on the invoice
record_status_KEY | int (4) | NOT NULL | FK which indicates if the record is active or deleted
sequence_number | int (4) | NOT NULL | Sequence number that determines the order the items are displayed on the invoicing screen
fixed_billing_amount_override | decimal (9, 2) |  | Override of the Billing_Item amount. If NULL, then the amount hasn't been overridden.

Primary key
Name | Columns | Description
PK_Client_Billing_Item | client_billing_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_Billing_Item__Billing_Item__billing_item_KEY | billing_item_KEY | Billing_Item (billing_item_KEY) |
FK_Client_Billing_Item__Billing_Item__shipping__billing_item_KEY | shipping__billing_item_KEY | Billing_Item (billing_item_KEY) |
FK_Client_Billing_Item__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Client_Billing_Item__Record_Status__record_status_KEY | record_status_KEY | Record_Status (record_status_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Client_Billing_Item_Rate_Adjustment__Client_Billing_Item__client_billing_item_KEY | client_billing_item_KEY | Client_Billing_Item_Rate_Adjustment |
FK_Client_Billing_Item_Schedule__Client_Billing_Item__client_billing_item_KEY | client_billing_item_KEY | Client_Billing_Item_Schedule |
FK_Billable_Item__Client_Billing_Item__client_billing_item_KEY | client_billing_item_KEY | Billable_Item |