| TBL_ORDER |
TBL_ORDER |
|
|
结构名称 |
| ID |
|
|
|
|
| ORDER_NUM |
ORDERNUM |
|
orderNum |
订单号 |
| EXAM_DATE |
examDate |
|
examDate |
CRM体检日期 |
|
MYEXAMDATE |
|
myExamDate |
CRM体检日期 |
| NAME |
NAME |
|
|
体检人姓名 |
| IDCARD |
IDCARD |
|
examinerExportDto.idCard |
体检人身份证号 |
| IDCARDTYPE |
|
|
examinerExportDto.addAccountType |
|
| FINANCENAME |
|
|
accountCompanyExportDto.name |
|
| DEPARTMENT |
DEPARTMENT |
|
department |
体检人所属部门 |
| FEE_TYPE |
PAYTYPE |
|
payType |
支付类型 |
| OWNER |
|
|
accountCompanyExportDto.owner |
|
| STATUS |
UPLOAD |
|
|
状态，0代表未同步到中间表，1代表已同步到中间表,-1代表已撤销 |
| IMPORT_TIME |
INSERTTIME |
|
|
新增时间 |
| OPERATOR |
|
|
|
|
| HIS_BM |
HISEXAMINEENUM |
|
hisExamineeNum |
体检号 |
| EXAM_COMPANY_CODE |
COMPANYID |
|
companyId |
CRM单位id |
| EXAM_COMPANY_NAME |
EXAMCOMPANY |
|
examCompany |
所属单位 |
| CANCEL_ORDER_FLAGS |
|
|
|
|
| POSITION |
|
|
position |
|
| CANCEL_ORDER_STATUS |
|
|
|
|
| MEAL_NAME |
MEALNAME |
|
mealName |
套餐名称 |
| MEAL_CODE |
MYMEALID |
|
myMealId |
套餐ID |
| HEALTH_NUM |
HEALTHNUM |
|
healthNum |
保健号 |
| IS_RETIRE |
|
|
retire |
|
| MOBILE |
MOBILE |
|
examinerExportDto.mobile |
体检人手机号码 |
| HEALTH_LEVEL |
HEALTHLEVEL |
|
healthLevel |
保健级别 |
| MARRIAGE_STATUS |
MARRIAGESTATUS |
|
marriageStatus |
婚姻状况(0:未婚，1：已婚) |
| HIS_TJKH |
|
|
hisExamineeNum |
|
| ORDER_MONEY |
ORDERMONEY |
|
orderMoney |
订单金额 |
| ONLINE_PAY_MONEY |
ONLINEPAYMONEY |
|
onlinePayMoney |
线上支付金额 |
| OFFLINE_PAY_MONEY |
OFFLINEPAYMONEY |
|
offlinePayMoney |
线下支付金额 |
| SEQUENCE |
|
|
sequence |
|
| IS_VIP |
VIP |
|
vip |
VIP |
| WORKNO |
EMPLOYEEID |
|
examinerExportDto.employeeId |
保健级别 |
| HAS_PAPERREPORT |
needPaperReport |
|
needPaperReport |
|
| REMARK |
REMARK |
|
remarks |
备注信息 |
| GROUP_NAME |
|
|
examinerExportDto.group |
|
| FINISH_TIME |
|
|
|
|
| HIS_COMPANY_CODE |
HISCOMPID |
|
hisCompId |
his系统单位编码 |
| HIS_COMPANY_NAME |
HISCOMPNAME |
|
hisCompName |
his系统单位名称 |
| MYTIJIAN_MEAL_ID |
|
|
|
|
| EXT |
|
|
|
|
| AGE |
AGE |
|
age |
年龄 |
| GENDER |
GENDER |
|
gender |
性别 |
| BIRTHDAY |
BIRTHDAY |
|
birthDay |
出生日期 |
| ORDER_EXPORT_TYPE |
|
|
|
|
| IDCARD_IMAGE |
|
|
|
|
| IDCARD_FIELD_TYPE |
|
|
|
|
|
|
|
|
|
| 表中未创建字段 |
|
|
|
|
| FULLADDRESS |
|
|
examinerExportDto.address |
|
| CardPayAmount |
|
|
CardPayAmount |
|
| NATIONALITY |
|
|
|
nationality |
| Card_Holder_Info_Name |
|
|
cardHolderInfoName |
|
|
MEALCLASSIFYNAME |
|
mealClassify |
套餐体检类型 |
|
ADDRESS |
|
address |
地址 |
|
UPLOADTIME |
|
|
写到中间表时间 |
|
EXAMPERIOD |
|
|
体检时间段 |
|
RECEIPTSTATUS |
|
|
回单状态，0代表未回单，1代表已回单 |
|
HANDLERECEIPTTIME |
|
|
处理回单时间 |
|
ARRIVALSTATUS |
|
|
到检状态，0代表未到检，1代表已到检 |
|
HANDLEARRIVALTIME |
|
|
处理到检时间 |
|
ADDACCOUNTTYPE |
|
|
添加账户类型 |
|
ORDERCREATETIME |
|
|
下单时间 |
|
GUIDESTATUS |
|
|
打印指引单状态，0代表未打印，1代表已打印 |
|
HANDLEGUIDETIME |
|
|
处理打印指引单时间 |
