The table used to store default schedule settings associated with a global schedule. |
billing_item_schedule_KEY | int (4) | NOT NULL | Primary key for this table; the default schedule for a billing item. |
billing_item_KEY | int (4) | NOT NULL | Foreign key; billing item this schedule is associated with. |
billing_fee_frequency_KEY | int (4) | NOT NULL | Foreign key; frequency at which this item is billed. |
billing_fee_method_KEY | int (4) | NOT NULL | Foreign key; method of billing. |
billing_fee_month_KEY | int (4) | | Foreign key; month that the billing should occur. |
billing_fee_day | int (4) | | Day that the billing should occur. |
day_offset | int (4) | | The number of days before a paydate to offset the billing date for a fee. |