| id |
int(11) |
|
|
|
|---|
|
| opencounter_id |
int(11) |
|
|
|
|---|
|
| counter_code |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| counter_desc |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| status |
varchar(10) |
latin1_swedish_ci |
|
|
|---|
|
| shift_code |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| shift_desc |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| todate |
datetime |
|
|
|
|---|
|
| opning_balance |
float(9,2) |
|
|
|
|---|
|
| closing_balance |
float(9,2) |
|
|
|
|---|
|
| cash_colloection |
float(9,2) |
|
|
|
|---|
|
| check_colloection |
float(9,2) |
|
|
|
|---|
|
| dd_colloection |
float(9,2) |
|
|
|
|---|
|
| ne_colloection |
float(9,2) |
|
|
|
|---|
|
| rt_colloection |
float(9,2) |
|
|
|
|---|
|
| cc_colloection |
float(9,2) |
|
|
|
|---|
|
| patient_reversal |
float(9,2) |
|
|
|
|---|
|
| payment_reversal |
float(9,2) |
|
|
|
|---|
|
| voucher_reversal |
float(9,2) |
|
|
|
|---|
|
| received_from_patient |
float(9,2) |
|
|
|
|---|
|
| discount_amount |
float(9,2) |
|
|
|
|---|
|
| discount_amount_after |
float(9,2) |
|
|
|
|---|
|
| ot_pay |
float(9,2) |
|
|
|
|---|
|
| doctor_payment |
float(10,2) |
|
|
|
|---|
|
| created_by |
varchar(11) |
latin1_swedish_ci |
|
|
|---|
|
| created_date |
timestamp |
|
|
|
|---|
|
| modified_by |
int(11) |
|
|
|
|---|
|
| modified_date |
datetime |
|
|
|
|---|
|
| locationname |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| cgst |
double(10,2) |
|
|
|
|---|
|
| igst |
double(10,2) |
|
|
|
|---|
|
| utgst |
double(10,2) |
|
|
|
|---|
|
| sgst |
double(10,2) |
|
|
|
|---|
|
| received_payment |
double(10,2) |
|
|
|
|---|
|
| transfered_payment |
double(10,2) |
|
|
|
|---|
|
| dbcs_colloection |
double(10,2) |
|
|
|
|---|
|
| npcb_colloection |
double(10,2) |
|
|
|
|---|
|
| fm_colloection |
double(10,2) |
|
|
|
|---|
|
| dbcp_colloection |
double(10,2) |
|
|
|
|---|
|
