Table: dbo.Client_Billing_Item
Columns
NameTypeConstraintsDescription
client_billing_item_KEYint (4)NOT NULLPrimary key for this table; the client-level billing item
client_KEYint (4)NOT NULLForeign key; key of the client
billing_item_KEYint (4)NOT NULLForeign key; the associated frim-level billing item
shipping__billing_item_KEYint (4)Foreign key; the associated shipping billing item
sales_tax_appliesbit (1)NOT NULLFlag to denote that sales tax applies to this billing item
discount_appliesbit (1)NOT NULLFlag to denote that the discount applies to this billing item
waive_until_datesmalldatetime (4)Fees associated with this billing item are waived until this date
include_detail_on_invoicebit (1)NOT NULLFlag to denote that detail information should be displayed on the invoice
record_status_KEYint (4)NOT NULLFK which indicates if the record is active or deleted
sequence_numberint (4)NOT NULLSequence number that determines the order the items are displayed on the invoicing screen
fixed_billing_amount_overridedecimal (9, 2)Override of the Billing_Item amount. If NULL, then the amount hasn't been overridden.
Primary key
NameColumnsDescription
PK_Client_Billing_Itemclient_billing_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Billing_Item__Billing_Item__billing_item_KEYbilling_item_KEYBilling_Item (billing_item_KEY)
FK_Client_Billing_Item__Billing_Item__shipping__billing_item_KEYshipping__billing_item_KEYBilling_Item (billing_item_KEY)
FK_Client_Billing_Item__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_Billing_Item__Record_Status__record_status_KEYrecord_status_KEYRecord_Status (record_status_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Billing_Item_Rate_Adjustment__Client_Billing_Item__client_billing_item_KEYclient_billing_item_KEYClient_Billing_Item_Rate_Adjustment
FK_Client_Billing_Item_Schedule__Client_Billing_Item__client_billing_item_KEYclient_billing_item_KEYClient_Billing_Item_Schedule
FK_Billable_Item__Client_Billing_Item__client_billing_item_KEYclient_billing_item_KEYBillable_Item

Schema diagram