Table: dbo.Billing_Item_Schedule
The table used to store default schedule settings associated with a global schedule.
Columns
NameTypeConstraintsDescription
billing_item_schedule_KEYint (4)NOT NULLPrimary key for this table; the default schedule for a billing item.
billing_item_KEYint (4)NOT NULLForeign key; billing item this schedule is associated with.
billing_fee_frequency_KEYint (4)NOT NULLForeign key; frequency at which this item is billed.
billing_fee_method_KEYint (4)NOT NULLForeign key; method of billing.
billing_fee_month_KEYint (4)Foreign key; month that the billing should occur.
billing_fee_dayint (4)Day that the billing should occur.
day_offsetint (4)The number of days before a paydate to offset the billing date for a fee.
Primary key
NameColumnsDescription
PK_Billing_Item_Schedulebilling_item_schedule_KEY
Unique constraints
NameColumnsDescription
UK_Billing_Item_Schedule$billing_item_KEYbilling_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Billing_Item_Schedule__Billing_Fee_Frequency__billing_fee_frequency_KEYbilling_fee_frequency_KEYBilling_Fee_Frequency (billing_fee_frequency_KEY)
FK_Billing_Item_Schedule__Billing_Fee_Method__billing_fee_method_KEYbilling_fee_method_KEYBilling_Fee_Method (billing_fee_method_KEY)
FK_Billing_Item_Schedule__Billing_Fee_Month__billing_fee_month_KEYbilling_fee_month_KEYBilling_Fee_Month (billing_fee_month_KEY)
FK_Billing_Item_Schedule__Billing_Item__billing_item_KEYbilling_item_KEYBilling_Item (billing_item_KEY)

Schema diagram