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 |
|
|
处理打印指引单时间 |