service_charge_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table |
update__staff_KEY | int | NOT NULL | |
update_date_utc | datetime | NOT NULL | |
description | nvarchar (250) | NOT NULL | User defined description (unique). |
annual_rate | decimal (7, 6) | NOT NULL | Rate to be used for the service charge calculation. |
service_charge_type_KEY | int | NOT NULL | Key from one of the Service Charge Types. 1=Invoice Date, 2=Due Date, 3=Due Date + Grace Days |
grace_days | int | NOT NULL | Number of days after the due date the client is given until service charges begin calculating. |
minimum_balance | decimal (17, 2) | NOT NULL | The system will not calculate service charges for clients unless their A/R balance is equal to or greater than this value. |
minimum_charge | decimal (17, 2) | NOT NULL | If the system calculates a service charge amount and it is less than this amount then the calculated amount should be dropped and this amount should be used. |
use_maximum_charge | bit | NOT NULL | Determines whether the maximum charge is enforced. |
maximum_charge | decimal (17, 2) | NOT NULL | If the system calculates a service charge amount and it is greater than this amount then the calculated amount should be dropped and this amount should be used. |
compound | bit | NOT NULL | Determines whether prior service charges should be included in the balance that is going to be used for the service charge. |
round | bit | NOT NULL | Round to the nearest dollar when true. |
create_date_utc | datetime | NOT NULL | |