Table: dbo.Billable_Item
Columns
NameTypeConstraintsDescription
billable_item_KEYint (4)NOT NULLPrimary key
client_billing_item_KEYint (4)The foreign key to the billing item that defined the event triggering the creation of the billable item. If this key is NULL, then this is an On Demand billable item created directly by the user; it wasn't triggered by a billing item.
billing_event_datesmalldatetime (4)NOT NULLThe date when the billing event occurred ie. the date of the print run for a check run billing item.
client_KEYint (4)NOT NULLForeign key to the client related to the billable item.
billable_item_guiduniqueidentifier (16)NOT NULLUniquely identifies the billable item across firm databases.
Primary key
NameColumnsDescription
PK_Billable_Itembillable_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Billable_Item__Client__client_KEYclient_KEYClient (client_KEY)
FK_Billable_Item__Client_Billing_Item__client_billing_item_KEYclient_billing_item_KEYClient_Billing_Item (client_billing_item_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Billable_Item_N_Form_Processing_Run__Billable_Item__billable_item_KEYbillable_item_KEYBillable_Item_N_Form_Processing_Run
FK_Billable_Item_N_Check_Print_Run__Billable_Item__billable_item_KEYbillable_item_KEYBillable_Item_N_Check_Print_Run
FK_Receivable_Transaction_Fee__Billable_Item__billable_item_KEYbillable_item_KEYReceivable_Transaction_Fee

Schema diagram