| Name | Description | Type | Additional information |
|---|---|---|---|
| PHARMACY_ID | integer |
None. |
|
| PHARMACY_NO | string |
None. |
|
| MRN_NO | string |
None. |
|
| PATIENT_FIRSTNAME | string |
None. |
|
| PATIENT_MIDDLENAME | string |
None. |
|
| PATIENT_LASTNAME | string |
None. |
|
| AGE | integer |
None. |
|
| GENDER_ID | integer |
None. |
|
| DOCTORID | integer |
None. |
|
| PATIENT_PHONEDTLS | string |
None. |
|
| VISIT_ID | integer |
None. |
|
| PATIENT_ID | integer |
None. |
|
| CREATED_BY | integer |
None. |
|
| CREATED_DATE | date |
None. |
|
| MODIFIED_BY | integer |
None. |
|
| MODIFIED_DATE | date |
None. |
|
| CONSULTATIONSTATUS | integer |
None. |
|
| STATUS | integer |
None. |
|
| CONSULTATIONDATE | date |
None. |
|
| DOCTORNAME | string |
None. |
|
| DCID | integer |
None. |
|
| CENTER_ID | integer |
None. |
|
| ORG_ID | integer |
None. |
|
| STORE_ID | integer |
None. |
|
| PHARMACY_BILL_DATETIME | date |
None. |
|
| SALE_PRICE | decimal number |
None. |
|
| SALE_AMOUNT | decimal number |
None. |
|
| BILL_AMOUNT | decimal number |
None. |
|
| NET_AMOUNT | decimal number |
None. |
|
| PATIENT_PAYAMOUNT | decimal number |
None. |
|
| COMPANY_PAYAMOUNT | decimal number |
None. |
|
| CREDIT_LIMIT | decimal number |
None. |
|
| CREDIT_COMPANY_ID | integer |
None. |
|
| COMPANY_SCHEME_ID | integer |
None. |
|
| SCHEME_MEMBER_ID | integer |
None. |
|
| CASH_REQUEST_ID | integer |
None. |
|
| PHARMACY_SALE_TYPE | string |
None. |
|
| PATIENT_TYPE | integer |
None. |
|
| PAYMENTTYPE_ID | integer |
None. |
|
| PATIENT_CATEGORY_ID | integer |
None. |
|
| DiscountAmount | decimal number |
None. |
|
| DueAmount | decimal number |
None. |