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 |