billing_fee_schedule_KEY | int (4) | NOT NULL | Primary key for this table |
billing_item_KEY | int (4) | NOT NULL | Key of the associated billing item for this table entry |
unit_count_start | int (4) | NOT NULL | Unit count which define the start of when this table entry is used, end is defined by the unit_count_start of next table entry |
weekly_amount | decimal (9, 2) | NOT NULL | Amount to be billed for items with a weekly frequency |
biweekly_amount | decimal (9, 2) | NOT NULL | Amount to be billed for items with a bi-weekly frequency |
twice_monthly_amount | decimal (9, 2) | NOT NULL | Amount to be billed for items with a twice monthly frequency |
monthly_amount | decimal (9, 2) | NOT NULL | Amount to be billed for items with a monthly frequency |
quarterly_amount | decimal (9, 2) | NOT NULL | Amount to be billed for items with a quarterly frequency |
semiannually_amount | decimal (9, 2) | NOT NULL | Amount to be billed for items with a semi-annual frequency |
annually_amount | decimal (9, 2) | NOT NULL | Amount to be billed for items with a annual frequency |
vendor_amount | decimal (9, 2) | NOT NULL | Amount to be billed for vendor checks. |