| id |
int(6) |
|
|
|
|---|
|
| discount_code |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| smajor_id |
int(11) |
|
|
|
|---|
|
| smajor_code |
varchar(6) |
latin1_swedish_ci |
|
|
|---|
|
| category_master_id |
int(11) |
|
|
|
|---|
|
| category_code |
varchar(6) |
latin1_swedish_ci |
|
|
|---|
|
| cat_desc |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| bill_id |
int(11) |
|
|
|
|---|
|
| bill_class |
varchar(6) |
latin1_swedish_ci |
|
|
|---|
|
| bill_desc |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| majerminer_master_id |
int(11) |
|
|
|
|---|
|
| sminor_code |
varchar(6) |
latin1_swedish_ci |
|
|
|---|
|
| service_id |
int(6) |
|
|
|
|---|
|
| rate_id |
int(6) |
|
|
|
|---|
|
| normal_rate |
float(10,2) |
|
|
|
|---|
|
| diff_ind |
varchar(6) |
latin1_swedish_ci |
|
|
|---|
|
| descount |
float(10,2) |
|
|
|
|---|
|
| descount_rate |
float(10,2) |
|
|
|
|---|
|
| applicable_rate |
float(10,2) |
|
|
|
|---|
|
| emr_diff_ind |
varchar(5) |
latin1_swedish_ci |
|
|
|---|
|
| emr_discount |
float(10,2) |
|
|
|
|---|
|
| emr_discount_rate |
float(10,2) |
|
|
|
|---|
|
| emr_applicable_rate |
float(10,2) |
|
|
|
|---|
|
| created_date |
timestamp |
|
|
|
|---|
|
| created_by |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| modified_date |
datetime |
|
|
|
|---|
|
| modified_by |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| grade_id |
varchar(6) |
latin1_swedish_ci |
|
|
|---|
|
| grade_desc |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| start_date |
date |
|
|
|
|---|
|
| end_date |
date |
|
|
|
|---|
|
| locationname |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
