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