TABLE Command Examples |
  
|
Navigation: Deposit Screens > Definitions Screen Group > Service Charges Screen > EZ4U Programming > EZ4U Commands > TABLE Command >
TABLE Command Examples |
|
This help topic contains examples and explanations about how a TABLE Command can be used in EZ4U Programming.
Example 1
TABLE |
LOWBAL<= |
FEE |
|
500.00 |
2.00 |
|
1000.00 |
1.00 |
This is an example of a very simple TABLE statement. It says that if the low balance on a customer account is less than or equal to $500.00, it will be charged a $2.00 fee; but if the low balance on the account is greater than $500.00 and less than or equal to $1,000.00, it will be charged a $1.00 fee. No PER or FREE columns were used in this TABLE statement.
Example 2
TABLE |
LOWBAL<= |
PER#CSHCK |
FREE |
FEE |
|
3000.00 |
.15 |
10 |
10.00 |
|
6000.00 |
.13 |
15 |
8.00 |
|
13000.00 |
.11 |
30 |
6.00 |
|
24000.00 |
.09 |
50 |
4.00 |
This more complicated TABLE statement sets up a PER and FREE column that are dependent on the LOWBAL<= column. This TABLE statement says that if the low balance on a customer account is less than or equal to $3,000.00, 10 checks will be cashed for free. Every subsequent check will be charged a 15¢ cashing fee. The per-check charges are added to a flat fee of $10.00 for the account. If the account had a low balance of $1,000.00, with 12 checks cashed, the service charge for the account would be $10.30. The first 10 checks were free, but the remaining 2 checks were charged a 15¢ service charge that was added to the $10.00 flat fee.
Example 3
TABLE |
LOWBAL<= |
PER#ATM |
PER#CSHCK |
FEE |
|
500.00 |
1.00 |
.15 |
5.00 |
|
1000.00 |
.50 |
.10 |
5.00 |
|
1500.00 |
.25 |
.07 |
5.00 |
|
2500.00 |
.10 |
.05 |
5.00 |
In this example, a customer account with a low balance less than or equal to $500.00 would be charged $1.00 per ATM transaction and 15¢ per check cashed, in addition to a flat fee of $5.00. However, an account with a low balance of $1,400.00 would be charged 25¢ per ATM transaction and 7¢ per check cashed, in addition to a flat fee of $5.00.
Example 4
TABLE |
LOWBAL< |
#ATM> |
PER#ATM |
FREE |
|
100.00 |
3 |
.75 |
0 |
|
1000.00 |
10 |
.80 |
3 |
|
5000.00 |
15 |
1.00 |
10 |
|
999999.99 |
0 |
.15 |
25 |
In this example, a customer account with a low balance less than $100.00 and more than 3 ATM transactions would be charged 75¢ per ATM transaction. An account with a low balance less than $5,000.00 and greater than $1,000.00 with more than 15 ATM transactions would be charged nothing for the first 10 ATM transactions, and $1.00 for each ATM transaction beyond 10.