{"text_format":"2","workbook":"xlsx","n_sheets":11,"sheets":["目录索引","设备基本信息表","商品设备关联表","商品类目表","商品表","订单表","订单详情表","公众号基本信息表","收款商户号表","提货表","账户历史表"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"目录索引","index":0,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,24,0],[25,0,27,0],[28,0,30,0],[31,0,33,0],[34,0,36,0],[37,0,39,0],[40,0,42,0],[43,0,45,0],[46,0,48,0],[49,0,51,0],[52,0,54,0],[55,0,57,0],[58,0,60,0],[61,0,63,0],[64,0,66,0],[67,0,69,0],[70,0,72,0],[1,4,24,4],[25,4,49,4],[50,4,74,4],[75,4,99,4]]}
["表属性","数据库表名","数据库表说明","是否建分区表","所属数据库","备注说明"]
[null,"VM_EQUIPMENT_INF","设备基本信息表"]
[null,"VM_PRO_EQU_REL","商品设备关联表"]
[null,"VM_CATEGORY_INF","商品类目表"]
[null,"VM_PRODUCT_INF","商品表"]
[null,"VM_ORDER_INF","订单表"]
[null,"VM_ORDER_DETAILS","订单详情表"]
[null,"VM_TENCENT_INF","公众号基本信息表"]
[null,"VM_COLLECTION_BRANCH","收款商户号表"]
[null,"vm_delivery_inf","提货表"]
[null,null,"充值规则表"]
[null,"vm_acc_detail","账户历史表"]
[null,"vm_account","账户表"]
[null,"vm_person_inf","用户表"]
[null,null,"游戏规则表"]
[null,"vm_payment_inf","支付流水表"]

{"sheet":"设备基本信息表","index":1,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,4,1,6],[1,7,1,11],[2,6,2,10],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,11,3,11]]}
["返回首页"]
["中文表名","设备基本信息表",null,null,"英文表名",null,null,"VM_EQUIPMENT_INF"]
["序号","字段名","字段描述","数据类型","必填项","默认值","索引",{"$nulls":4},"备注说明"]
[{"$nulls":6},"唯一","普通","普通","普通","普通"]
[1,"VEQ_ID","ID","varchar(20)      ","M",null,"①"]
[2,"VEQ_CHANNEL","渠道（V01:自助售货机）","varchar(3)      ","M",{"$nulls":6},"渠道（V01:自助售货机）"]
[3,"VEQ_NAME","设备名称","varcha(100)      ","M"]
[4,"VEQ_IOT_SERVICE_PROVIDER","物联服务商","varchar(20)   ","O"]
[5,"VEQ_IOT_CARD_NUMBER","物联卡号","varchar(20)   ","O"]
[6,"VEQ_VERSION_TYPE","版本类型(00:直接购买,01:幸运购,02:游戏购,03:10倍,04:7件商品,05参与分配(超级彩蛋))","varchar(2)   ","O","00",{"$nulls":5},"版本类型(00:直接购买,01:幸运购,02:游戏购,03:10倍,04:7件商品,05参与分配(超级彩蛋))"]
[7,"VEQ_ADDRESS","机器地址","varcha(300)   ","O"]
[8,"VEQ_EQU_TYPE","机器类型（EQU_TYEP：00：支付盒子售货机，01：支付盒子存货机 02：便携式售货机）","varchar(2)   ","O",{"$nulls":6},"机器类型（EQU_TYEP：00：支付盒子售货机，01：支付盒子存货机 02：便携式售货机）"]
[9,"VEQ_EQU_IMG","机器图片","varcha(512)   ","O"]
[10,"VEQ_WC_ACCOUNT","微信公众号","varchar(32)   ","O"]
[11,"VEQ_ZFB_ACCOUNT","支付宝账号","varchar(32)   ","O"]
[12,"VEQ_CHARGE","手续费","varchar(10)   ","O"]
[13,"VEQ_CREDIT_CHANNEL","收款通道","varcha(512)   ","O"]
[14,"VEQ_PAYEE_NO","收款机构号/商户号","varchar(32)   ","O"]
[15,"VEQ_PAYMENT","支付金额","varchar(10)   ","O"]
[16,"VEQ_PAYMENT_TYPE","支付金额类型(00随机 01固定)","varchar(2)   ","O"]
[17,"VEQ_BACKGROUND_ONE","游戏背景图1","varcha(512)   ","O"]
[18,"VEQ_BACKGROUND_TWO","游戏背景图2","varcha(512)   ","O"]
[19,"VEQ_EXCHANGE_RATE","汇率","varchar(10)   ","O"]
[20,"VEQ_SUPPORT_BALANCE","是否支持余额(00支持01不支持)","varchar(2)   ","O","01",{"$nulls":5},"是否支持余额(00支持01不支持)"]
[21,"VEQ_REMARKS","备注","varcha(300)   ","O"]
[null,"VEQ_CREATE_USER","创建人","varchar(20)   "]
[22,"VEQ_CREATE_TIME","创建时间","varchar(14)   ","O"]
[23,"VEQ_MODIFY_USER","最后修改人","varchar(20)   ","O"]
[24,"VEQ_MODIFY_TIME","最后修改时间","varchar(14)   ","O"]
[25,"VEQ_IMEI_ADDR","设备IMEI","varchar(50)   ","O"]
[26,"VEQ_HEART_RATES","设备心跳次数","varchar(50)   "]
[27,"VEQ_STATE","运行状态","varchar(2)   ",null,"01",{"$nulls":5},"运行状态:00正常01离线02检修03销毁"]
[28,"VEQ_MACHINE_NO","设备编号","varchar(32)   "]
[29,"VEQ_PROGRAM_EDITION","程序版本","varchar(50)   "]
[30,"VEQ_TEMPERATURE","机箱温度","varchar(20)   "]
[31,"VEQ_SIGNAL","信号强度","varchar(20)   "]
[32,"VEQ_BRANCHID","所属商户","varchar(32)   ",{"$nulls":7},"所属商户（机构号）"]

{"sheet":"商品设备关联表","index":2,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,4,1,6],[1,7,1,11],[2,6,2,10],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,11,3,11]]}
["返回首页"]
["中文表名","商品设备关联表",null,null,"英文表名",null,null,"VM_PRO_EQU_REL"]
["序号","字段名","字段描述","数据类型","必填项","默认值","索引",{"$nulls":4},"备注说明"]
[{"$nulls":6},"唯一","普通","普通","普通","普通"]
[1,"VCI_ID","ID","varchar(20)      ","M",null,"①"]
[2,"VCI_CHANNEL","渠道（V01:自助售货机）","varchar(3)      ","M","V01",{"$nulls":5},"渠道（V01:自助售货机）"]
[3,"VCI_PRODUCT_ID","商品Id","varchar(20)   ","O"]
[4,"VCI_EQUIPMENT_ID","设备Id","varchar(20)   ","O"]
[5,"VCI_AISLE","货道指令","varchar(5)   ","O"]
[6,"VCI_CARGO_WAY_ROW","货道行","varchar(5)   ","O"]
[7,"VCI_CARGO_WAY_LINE","货道列","varchar(5)   ","O"]
[8,"VCI_CARGO_WAY_NUMS","货道容量","varchar(5)   ","O"]
[9,"VCI_PRODUCT_NUMS","商品余量","varchar(5)   ","O"]
[10,"VCI_USER_Id","商户Id","varchar(20)   ","O"]
[11,"VCI_SALL_PRICE","售货价","varchar(10)   ","O"]
[12,"VCI_GAME_PRICE","游戏价","varchar(10)   ","O"]
[13,"VCI_COST_PRICE","成本价","varchar(10)   ","O"]
[14,"VCI_IS_PROMOTION","是否促销","char(1)   ","O",{"$nulls":6},"是否促销:0是1否"]
[15,"VCI_PROMOTION_PRICE","促销价","varchar(10)   ","O"]
[16,"VCI_GAME_TYPE","游戏类型","varchar(2)   ","O",{"$nulls":6},"游戏类型（GAME_TYEP：00：不参与，10：游戏购 20：幸运购）"]
[17,"VCI_IS_FRAGILE","是否易碎","char(1)   ","O",{"$nulls":6},"是否易碎:0是1否"]
[18,"VCI_REMARKS","备注","varcha(200)   ","O"]
[19,"VCI_CREATE_USER","创建人","varchar(20)   ","O"]
[20,"VCI_CREATE_TIME","创建时间","varchar(14)   ","O"]
[21,"VCI_MODIFY_USER","最后修改人","varchar(20)   ","O"]
[22,"VCI_MODIFY_TIME","最后修改时间","varchar(14)   ","O"]
[23,"VCI_EXEIT_STATE","状态","char(2)   ","O",{"$nulls":6},"状态:00正常01货道删除02删除"]

{"sheet":"商品类目表","index":3,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,4,1,6],[1,7,1,11],[2,6,2,10],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,11,3,11]]}
["返回首页"]
["中文表名","商品类目表",null,null,"英文表名",null,null,"VM_CATEGORY_INF"]
["序号","字段名","字段描述","数据类型","必填项","默认值","索引",{"$nulls":4},"备注说明"]
[{"$nulls":6},"唯一","普通","普通","普通","普通"]
[1,"VCI_ID","ID","varchar(10)      ","M",null,"①"]
[2,"VCI_CHANNEL","渠道（V01:自助售货机）","varchar(3)      ","M","V01",{"$nulls":5},"渠道（V01:自助售货机）"]
[3,"VCI_NAME","类目名称","varchar(50)   ","O"]
[4,"VCI_ALIAS","类目别名","varchar(30)   ","O"]
[5,"VCI_INITIAL","类目名称首字母","char(1)   ","O"]
[6,"VCI_CODE","类目编号","varchar(10)   ","O"]
[7,"VCI_PARENT_CODE","上级类目","varchar(10)   ","O"]
[8,"VCI_LEVEL","类目级别","char(1)   ","O"]
[9,"VCI_SORT","类目排序","varchar(4)   ","O","9999"]
[10,"VCI_CATEGORY_IMG","类目图片","varcha(100)   ","O"]
[11,"VCI_CATEGORY_URL","类目关联路径","varcha(100)   ","O"]
[12,"VCI_STATE","状态(0正常1失效)","varchar(1)   ","O","0",{"$nulls":5},"状态(0正常1失效)"]
[13,"VCI_REMARKS","备注","varcha(255)   ","O"]
[14,"VCI_CREATE_USER","创建人","varchar(20)   ","O"]
[15,"VCI_CREATE_TIME","创建时间","varchar(14)   ","O"]
[16,"VCI_MODIFY_USER","最后修改人","varchar(20)   ","O"]
[17,"VCI_MODIFY_TIME","最后修改时间","varchar(14)   ","O"]

{"sheet":"商品表","index":4,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,4,1,6],[1,7,1,11],[2,6,2,10],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,11,3,11]]}
["返回首页"]
["中文表名","银行卡BIN信息表",null,null,"英文表名",null,null,"T_P_BIN_INFO"]
["序号","字段名","字段描述","数据类型","必填项","默认值","索引",{"$nulls":4},"备注说明"]
[{"$nulls":6},"唯一","普通","普通","普通","普通"]
[1,"PRT_ID","商品ID","varchar(20)      ","M",null,"①"]
[2,"PRT_CHANNEL","渠道（V01:自助售货机）","varchar(3)      ","M",{"$nulls":6},"渠道（V01:自助售货机）"]
[3,"PRT_NAME","商品名称","varchar(100)      ","M"]
[4,"PRT_CATEGORY_ID","商品类别id","varchar(20)      ","M"]
[5,"PRT_MASTER_MAP","商品主图","varchar(100)      ","M"]
[6,"PRT_FMPIC","商品封面图","varchar(100)   ","O"]
[7,"PRT_PICLIST","商品图片列表，以逗号分割","varchar(300)   ","O"]
[8,"PRT_DESCRIBE","商品描述","varchar(100)   ","O"]
[9,"PRT_PRO_VEDIO","商品视频","varchar(100)   ","O"]
[10,"PRT_BRANCHID","商品所属商户（机构）","varchar(20)   ","O",{"$nulls":6},"商品所属商户ID()"]
[11,"PRT_SORT","排序越大越靠后","varchar(4)   ","O",9999]
[12,"PRT_STATE","状态","char(1)   ","O",0,{"$nulls":5},"状态(0正常1停售2删除)"]
[13,"PRT_CREATE_USER","创建人","varchar(20)   ","O"]
[14,"PRT_CREATE_TIME","创建时间","varchar(14)   ","O"]
[15,"PRT_MODIFY_USER","最后修改人","varchar(20)   ","O"]
[16,"PRT_MODIFY_TIME","最后修改时间","varchar(14)   ","O"]

{"sheet":"订单表","index":5,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,4,1,6],[1,7,1,12],[2,6,2,11],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,12,3,12]]}
["返回首页"]
["中文表名","订单表",null,null,"英文表名",null,null,"vm_order_inf"]
["序号","字段名","字段描述","数据类型","必填项","默认值","索引",{"$nulls":5},"备注说明"]
[{"$nulls":6},"唯一","唯一","普通","普通","普通","普通"]
[1,"VOI_ID","ID","varchar(20) NOT NULL","M",null,"①"]
[2,"VOI_CHANNEL","渠道","varchar(3) NOT NULL","M","V01",{"$nulls":6},"渠道（V01:自助售货机）"]
[3,"VOI_USER_ID","用户Id","varchar(20) NULL","O"]
[4,"VOI_EQUIPMENT_ID","商品设备关联表","varchar(30) NOT NULL","M",{"$nulls":7},"商品设备关联表VM_EQUIPMENT_INF.VEQ_ID"]
[5,"VOI_ORDER_AMT","订单总金额","varchar(20) NULL","O"]
[6,"VOI_STATE","支付状态 ","varchar(2) NULL","O",{"$nulls":7},"支付状态 80:已重新支付 90:已取消 91:未支付 92:支付中 00 ：已支付"]
[7,"VOI_RECORD_ID","结算批次号","varchar(20) NULL","O",null,null,"②",{"$nulls":4},"（VM_SET_RECORD.PSR_BATCHNO）,空代表未结算 废弃"]
[8,"VOI_PAY_ORDERNO","支付平台订单号","varchar(50) NULL","O",null,null,"③",{"$nulls":4},"支付平台订单号（微信、支付宝订单号）"]
[9,"VOI_REMARKS","备注","varchar(100) NULL","O",null,null,"④"]
[10,"VOI_PAY_TYPE","支付金额类别","varchar(2) NULL","O",null,null,"⑤",{"$nulls":4},"支付金额类别:1:1倍支付 3:3倍支付 5:5倍支付"]
[11,"VOI_NUMBER","购买次数","varchar(2) NULL","O"]
[12,"VOI_PRO_TYPE","商品交易类别","varchar(2) NULL","O",{"$nulls":7},"商品交易类别:00正常商品，01抽奖商品，02：充值"]
[13,"VOI_IS_DRAW","是否中奖","varchar(2) NULL","O",{"$nulls":7},"是否中奖:00未中奖01中奖"]
[14,"VOI_IS_USED","是否使用","varchar(2) NULL","O",{"$nulls":7},"是否使用:00已使用01未使用"]
[15,"VOI_PRO_STATE","00直接取货01放入卡包02失效","varchar(2) NULL","O",{"$nulls":7},"00直接取货01放入卡包02失效"]
[16,"VOI_DRAW_PRICE","中奖金额","varchar(20) NULL","O"]
[17,"VOI_CREATE_USER","创建人","varchar(20) NULL","O"]
[18,"VOI_CREATE_TIME","创建时间","varchar(14) NULL","O"]
[19,"VOI_MODIFY_USER","最后修改人","varchar(20) NULL","O"]
[20,"VOI_MODIFY_TIME","最后修改时间","varchar(14) NULL","O"]
[21,"VOI_BRANCHID","所属商户id","varchar(32) NULL"]

{"sheet":"订单详情表","index":6,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,4,1,6],[1,7,1,12],[2,6,2,11],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,12,3,12]]}
["返回首页"]
["中文表名","非金融交易流水表",null,null,"英文表名",null,null,"T_P_NON_FINANCE_TXN"]
["序号","字段名","字段描述","数据类型","必填项","默认值","索引",{"$nulls":5},"备注说明"]
[{"$nulls":6},"唯一","唯一","普通","普通","普通","普通"]
[1,"VOD_DETAILS_ID","ID","varchar(20) NOT NULL","M",null,"①"]
[2,"VOD_CHANNEL","渠道（V01:自助售货机）","varchar(3) NOT NULL","M"]
[3,"VOD_ORDER_ID","所属订单表vm_order_inf.VOI_ID","varchar(20) NULL","O"]
[4,"VOD_PRO_EQU_REL_ID","商品设备关联表vm_pro_equ_rel.VCI_ID","varchar(20) NOT NULL","M"]
[5,"VOD_CARGO_WAY","商品所在售货机货道(00:第一行第一列)","varchar(20) NOT NULL","M"]
[6,"VOD_PRODUCT_ID","商品编号","varchar(20) NOT NULL","M"]
[7,"VOD_PRO_TYPE","商品交易类别:00正常商品01抽奖商品","varchar(2) NULL","O",0]
[8,"VOD_PRO_NAME","商品名称","varchar(100) NULL","O"]
[9,"VOD_PRO_PRICE","商品单价格","varchar(20) NULL","O"]
[10,"VOD_PRO_NUMS","商品数量","varchar(20) NULL","O"]
[11,"VOD_AMOUNT","商品总价","varchar(20) NULL","O"]
[12,"VOD_RECORD_ID","结算批次号（VM_SET_RECORD.PSR_BATCHNO）,空代表未结算","varchar(20) NULL","O"]
[13,"VOD_REMARKS","备注","varchar(200) NULL","O"]
[14,"VOD_CREATE_USER","创建人","varchar(20) NULL","O"]
[15,"VOD_CREATE_TIME","创建时间","varchar(14) NULL","O"]
[16,"VOD_MODIFY_USER","最后修改人","varchar(20) NULL","O"]
[17,"VOD_MODIFY_TIME","最后修改时间","varchar(14) NULL","O"]

{"sheet":"公众号基本信息表","index":7,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,4,1,6],[1,7,1,12],[2,6,2,11],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,12,3,12]]}
["返回首页"]
["中文表名","公众号基本信息表",null,null,"英文表名",null,null,"VM_TENCENT_INF"]
["序号","字段名","字段描述","数据类型","必填项","默认值","索引",{"$nulls":5},"备注说明"]
[{"$nulls":6},"唯一","唯一","普通","普通","普通","普通"]
[1,"VTI_ID","公众号ID","varchar(20)  ","M",null,"①"]
[2,"VTI_CHANNEL","渠道（V01:自助售货机）","varchar(3)  ","M","V01"]
[3,"VTI_NAME","公众号名称","varchar(30)  ","O"]
[4,"VTI_VX_NUM","微信号","varchar(30)  ","M"]
[5,"VTI_VX_ID","微信原ID","varchar(100) ","O"]
[6,"VTI_APP_ID","APPID（应用ID)","varchar(300) ","O"]
[7,"VTI_APP_SECRET","AppSecret(应用秘钥)","varchar(300) ","O"]
[8,"VTI_USER_ID","客户编号","varchar(20) ","O"]
[9,"VTI_CREATE_USER","创建人","varchar(20) ","O"]
[10,"VTI_CREATE_TIME","创建时间","varchar(14) ","O"]
[11,"VTI_MODIFY_USER","最后修改人","varchar(20) ","O"]
[12,"VTI_MODIFY_TIME","最后修改时间","varchar(14) ","O"]
[13,"VTI_STATUS","状态:00正常、01删除","char(2) ","O","00",{"$nulls":6},"状态:00正常、01删除"]

{"sheet":"收款商户号表","index":8,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,4,1,6],[1,7,1,12],[2,6,2,11],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,12,3,12]]}
["返回首页"]
["中文表名","收款商户号表",null,null,"英文表名",null,null,"vm_collection_branch"]
["序号","字段名","字段描述","数据类型","必填项","默认值","索引",{"$nulls":5},"备注说明"]
[{"$nulls":6},"唯一","唯一","普通","普通","普通","普通"]
[1,"VCB_ID","编号","varchar(32) ","M",null,"①"]
[2,"VCB_BRANCHID","所属商户id","varchar(32) ","M"]
[3,"VCB_TERMINAL_ID","终端号","varchar(32) ","O"]
[4,"VCB_TYPE","商户类型（00富友01合力宝02收钱吧）","varchar(2) ","O",{"$nulls":7},"商户类型（00富友01合力宝02收钱吧）"]
[5,"VCB_COLLECTION_ID","收款商户号","varchar(32) ","O"]
[6,"VCB_CREATE_USER","创建人","varchar(32) ","O"]
[7,"VCB_CREATE_TIME","创建时间","varchar(20) ","O"]
[8,"VCB_STATUS","状态:00正常、01删除","varchar(2) ","M"]
[9,"VCB_MODIFY_USER","最后修改人","varchar(32) ","O"]
[10,"VCB_MODIFY_TIME","最后修改时间","varchar(20) ","O"]

{"sheet":"提货表","index":9,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,4,1,6],[1,7,1,12],[2,6,2,11],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,12,3,12]]}
["返回首页"]
["中文表名","提货表",null,null,"英文表名",null,null,"vm_delivery_inf"]
["序号","字段名","字段描述","数据类型","必填项","默认值","索引",{"$nulls":5},"备注说明"]
[{"$nulls":6},"唯一","唯一","普通","普通","普通","普通"]
[1,"VDI_DELIVERY_ID","ID","varchar(20)  ","M",null,"①"]
[2,"VDI_CHANNEL","渠道（V01:自助售货机）","varchar(3)  ","M"]
[3,"VDI_EQUIPMENT_ID","商品设备关联表VM_EQUIPMENT_INF.VEQ_ID","varchar(30)  ","M"]
[4,"VDI_PERSON_ID","所属会员编号vm_person_inf.VCI_ID","varchar(20) ","O"]
[5,"VDI_ORD_DET_ID","所属订单详情表VM_ORDER_DETAILS.VOD_DETAILS_ID","varchar(20) ","O",{"$nulls":7},"所属订单详情表VM_ORDER_DETAILS.VOD_DETAILS_ID"]
[6,"VDI_PRO_TYPE","商品交易类别:00正常商品01抽奖商品","varchar(2) ","O"]
[7,"VDI_PRO_NAME","商品名称","varchar(100) ","O"]
[8,"VDI_PRO_PRICE","商品单价格","varchar(20) ","M"]
[9,"VDI_PRO_NUMS","商品数量","varchar(20) ","O"]
[10,"VDI_AMOUNT","商品总价","varchar(20) ","O"]
[11,"VDI_STATUS","提货状态","varchar(2) ",{"$nulls":8},"提货状态:0未出货1部分出货2已出货3卡货4清零5处理中"]
[12,"VDI_CARGO_WAY","所在售货机货道(00:第一行第一列)","varchar(20) "]
[13,"VDI_DELIVERY_NUMS","提货数量","varchar(20) "]
[14,"VDI_REMARKS","备注","varchar(200) "]
[15,"VDI_CREATE_USER","创建人","varchar(20) "]
[16,"VDI_CREATE_TIME","创建时间","varchar(14) "]
[17,"VDI_MODIFY_USER","最后修改人","varchar(20) "]
[18,"VDI_MODIFY_TIME","最后修改时间","varchar(14) "]
[19,"VDI_BRANCHID","所属商户","varchar(32) "]

{"sheet":"账户历史表","index":10,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,4,1,6],[1,7,1,12],[2,6,2,11],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,12,3,12]]}
["返回首页"]
["中文表名","账户历史表",null,null,"英文表名",null,null,"vm_collection_branch"]
["序号","字段名","字段描述","数据类型","必填项","默认值","索引",{"$nulls":5},"备注说明"]
[{"$nulls":6},"唯一","唯一","普通","普通","普通","普通"]
[1,"ADL_FLOWNO","流水号","varchar(10) NOT NULL","M",null,"①"]
[2,"ADL_ACCNO","账号","varchar(10) NOT NULL","M"]
[3,"ADL_TRANS_TYPE","交易类型00垫资","varchar(2) NULL","O"]
[4,"ADL_TYPE","收支类型00收入01支出","varchar(2) NULL","O"]
[5,"ADL_BALANCE_LAST","变更前金额","varchar(20) NULL","O",{"$nulls":7},"所属订单详情表VM_ORDER_DETAILS.VOD_DETAILS_ID"]
[6,"ADL_BALANCE","变更后金额","varchar(20) NULL","O"]
[7,"ADL_TRXAMOUT","交易额","varchar(20) NULL","O"]
[8,"ADL_REL_NO","关联编号","varchar(10) NULL","M"]
[9,"ADL_REMARK","备注","varchar(300) NULL","O"]
[10,"ADL_CREATE_USER","创建人","varchar(10) NULL","O"]
[11,"ADL_CREATE_TIME","创建时间","varchar(14) NULL",{"$nulls":8},"提货状态:0未出货1部分出货2已出货3卡货4清零5处理中"]