const table = [ { tablekey: 'table_pcweb_delivery', tabletype: 2, tablename: '现货合同', tabelmenu: '', remark: 'web端-现货合同', columns: [ { autoid: 21485, tablekey: 'table_pcweb_delivery', columnfield: 'contracctstatus', columntitle: '状态', columnwidth: '120', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contracctstatus', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21503, tablekey: 'table_pcweb_delivery', columnfield: 'meruserid', columntitle: '跟单员', columnwidth: '120', orderindex: 190, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'meruserid', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21486, tablekey: 'table_pcweb_delivery', columnfield: 'contractno', columntitle: '合同编号', columnwidth: '120', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contractno', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21487, tablekey: 'table_pcweb_delivery', columnfield: 'contracttype', columntitle: '类型', columnwidth: '120', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contracttype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21488, tablekey: 'table_pcweb_delivery', columnfield: 'negative', columntitle: '对手方', columnwidth: '250', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'negative', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21489, tablekey: 'table_pcweb_delivery', columnfield: 'qty', columntitle: '合同量', columnwidth: '120', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'qty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21490, tablekey: 'table_pcweb_delivery', columnfield: 'deliverygoodsname', columntitle: '现货品种', columnwidth: '120', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverygoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21491, tablekey: 'table_pcweb_delivery', columnfield: 'wrstandardname', columntitle: '品类', columnwidth: '120', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'wrstandardname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21492, tablekey: 'table_pcweb_delivery', columnfield: 'biztype', columntitle: '业务类型', columnwidth: '120', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'biztype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21493, tablekey: 'table_pcweb_delivery', columnfield: 'convertfactor', columntitle: '标仓系数', columnwidth: '120', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'convertfactor', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21494, tablekey: 'table_pcweb_delivery', columnfield: 'pricetype', columntitle: '定价类型', columnwidth: '120', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricetype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21495, tablekey: 'table_pcweb_delivery', columnfield: 'goodscode', columntitle: '点价合约', columnwidth: '120', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodscode', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21496, tablekey: 'table_pcweb_delivery', columnfield: 'price', columntitle: '价格', columnwidth: '120', orderindex: 120, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'price', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21497, tablekey: 'table_pcweb_delivery', columnfield: 'pricemove', columntitle: '升贴水', columnwidth: '120', orderindex: 130, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricemove', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21498, tablekey: 'table_pcweb_delivery', columnfield: 'amount', columntitle: '金额', columnwidth: '120', orderindex: 140, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'amount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21499, tablekey: 'table_pcweb_delivery', columnfield: 'margin', columntitle: '保证金', columnwidth: '120', orderindex: 150, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'margin', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21500, tablekey: 'table_pcweb_delivery', columnfield: 'startdate', columntitle: '点价期', columnwidth: '200', orderindex: 160, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'startdate', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21501, tablekey: 'table_pcweb_delivery', columnfield: 'deliverystartdate', columntitle: '交收期', columnwidth: '200', orderindex: 170, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverystartdate', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21502, tablekey: 'table_pcweb_delivery', columnfield: 'saleuserid', columntitle: '业务员', columnwidth: '120', orderindex: 180, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'saleuserid', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21504, tablekey: 'table_pcweb_delivery', columnfield: 'tradeusername', columntitle: '交易员', columnwidth: '120', orderindex: 190, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'tradeusername', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_userinfo', tabletype: 2, tablename: '客户资料', tabelmenu: '', remark: 'web端-客户资料', columns: [ { autoid: 21505, tablekey: 'table_pcweb_userinfo', columnfield: 'status', columntitle: '状态', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'status', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21506, tablekey: 'table_pcweb_userinfo', columnfield: 'userinfotype', columntitle: '客户类型', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21507, tablekey: 'table_pcweb_userinfo', columnfield: 'nickname', columntitle: '客户简称', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'nickname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21508, tablekey: 'table_pcweb_userinfo', columnfield: 'customername', columntitle: '客户名称', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'customername', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21509, tablekey: 'table_pcweb_userinfo', columnfield: 'cardtype', columntitle: '证件类型', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'cardtype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21510, tablekey: 'table_pcweb_userinfo', columnfield: 'cardnum', columntitle: '证件号码', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'cardnum', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21511, tablekey: 'table_pcweb_userinfo', columnfield: 'contactname', columntitle: '联系人', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contactname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21512, tablekey: 'table_pcweb_userinfo', columnfield: 'mobile', columntitle: '手机号码', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'mobile', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21513, tablekey: 'table_pcweb_userinfo', columnfield: 'email', columntitle: '邮箱', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'email', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21514, tablekey: 'table_pcweb_userinfo', columnfield: 'legalpersonname', columntitle: '法定代表人', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'legalpersonname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21515, tablekey: 'table_pcweb_userinfo', columnfield: 'taxpayernum', columntitle: '纳税人识别号', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'taxpayernum', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21516, tablekey: 'table_pcweb_userinfo', columnfield: 'cardphotourl', columntitle: '证件照', columnwidth: '0', orderindex: 120, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'cardphotourl', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21517, tablekey: 'table_pcweb_userinfo', columnfield: 'address', columntitle: '地址', columnwidth: '0', orderindex: 130, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'address', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21518, tablekey: 'table_pcweb_userinfo', columnfield: 'remark', columntitle: '备注', columnwidth: '0', orderindex: 140, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'remark', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_warehouse', tabletype: 2, tablename: '仓库信息', tabelmenu: '', remark: 'web端-仓库信息', columns: [ { autoid: 21519, tablekey: 'table_pcweb_warehouse', columnfield: 'warehousestatus', columntitle: '状态', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'warehousestatus', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21520, tablekey: 'table_pcweb_warehouse', columnfield: 'warehousecode', columntitle: '仓库简称', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'warehousecode', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21521, tablekey: 'table_pcweb_warehouse', columnfield: 'warehousetype', columntitle: '仓库类型', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'warehousetype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21522, tablekey: 'table_pcweb_warehouse', columnfield: 'warehousename', columntitle: '仓库名称', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'warehousename', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21523, tablekey: 'table_pcweb_warehouse', columnfield: 'contactname', columntitle: '联系人', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contactname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21524, tablekey: 'table_pcweb_warehouse', columnfield: 'contactnum', columntitle: '联系电话', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contactnum', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21525, tablekey: 'table_pcweb_warehouse', columnfield: 'address', columntitle: '详细地址', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'address', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_stock_aduit_in', tabletype: 2, tablename: '库存审核-入库', tabelmenu: '', remark: 'web端-库存审核-入库', columns: [ { autoid: 21771, tablekey: 'table_pcweb_stock_aduit_in', columnfield: 'applystatus', columntitle: '状态', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applystatus', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21772, tablekey: 'table_pcweb_stock_aduit_in', columnfield: 'inouttype', columntitle: '入库类型', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'inouttype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21773, tablekey: 'table_pcweb_stock_aduit_in', columnfield: 'deliverygoodsname', columntitle: '现货品种', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverygoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21774, tablekey: 'table_pcweb_stock_aduit_in', columnfield: 'wrstandardname', columntitle: '品类', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'wrstandardname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21775, tablekey: 'table_pcweb_stock_aduit_in', columnfield: 'brandname', columntitle: '品牌', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'brandname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21776, tablekey: 'table_pcweb_stock_aduit_in', columnfield: 'warehousename', columntitle: '仓库', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'warehousename', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21777, tablekey: 'table_pcweb_stock_aduit_in', columnfield: 'contracttype', columntitle: '合同类型', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contracttype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21778, tablekey: 'table_pcweb_stock_aduit_in', columnfield: 'buynicknameOrsellusername', columntitle: '对手方', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'buynicknameOrsellusername', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21779, tablekey: 'table_pcweb_stock_aduit_in', columnfield: 'contractno', columntitle: '合同编号', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contractno', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21780, tablekey: 'table_pcweb_stock_aduit_in', columnfield: 'pricetype', columntitle: '点价类型', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricetype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21781, tablekey: 'table_pcweb_stock_aduit_in', columnfield: 'applytime', columntitle: '登记时间', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applytime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21782, tablekey: 'table_pcweb_stock_aduit_in', columnfield: 'applyname', columntitle: '登记人', columnwidth: '0', orderindex: 120, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applyname', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_stock_aduit_out', tabletype: 2, tablename: '库存审核-出库', tabelmenu: '', remark: 'web端-库存审核-出库', columns: [ { autoid: 21783, tablekey: 'table_pcweb_stock_aduit_out', columnfield: 'applystatus', columntitle: '状态', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applystatus', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21784, tablekey: 'table_pcweb_stock_aduit_out', columnfield: 'inouttype', columntitle: '出库类型', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'inouttype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21785, tablekey: 'table_pcweb_stock_aduit_out', columnfield: 'deliverygoodsname', columntitle: '现货品种', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverygoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21786, tablekey: 'table_pcweb_stock_aduit_out', columnfield: 'wrstandardname', columntitle: '品类', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'wrstandardname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21787, tablekey: 'table_pcweb_stock_aduit_out', columnfield: 'brandname', columntitle: '品牌', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'brandname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21788, tablekey: 'table_pcweb_stock_aduit_out', columnfield: 'warehousename', columntitle: '仓库', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'warehousename', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21789, tablekey: 'table_pcweb_stock_aduit_out', columnfield: 'contracttype', columntitle: '合同类型', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contracttype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21790, tablekey: 'table_pcweb_stock_aduit_out', columnfield: 'buynicknameOrsellusername', columntitle: '对手方', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'buynicknameOrsellusername', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21791, tablekey: 'table_pcweb_stock_aduit_out', columnfield: 'contractno', columntitle: '合同编号', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contractno', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21792, tablekey: 'table_pcweb_stock_aduit_out', columnfield: 'pricetype', columntitle: '点价类型', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricetype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21793, tablekey: 'table_pcweb_stock_aduit_out', columnfield: 'applytime', columntitle: '登记时间', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applytime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21794, tablekey: 'table_pcweb_stock_aduit_out', columnfield: 'applyname', columntitle: '登记人', columnwidth: '0', orderindex: 120, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applyname', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_stock_manage_current', tabletype: 2, tablename: '库存管理-当前库存', tabelmenu: '', remark: '手机端-库存管理-当前库存', columns: [ { autoid: 21795, tablekey: 'table_pcweb_stock_manage_current', columnfield: 'userinfotype', columntitle: '现货品种', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21796, tablekey: 'table_pcweb_stock_manage_current', columnfield: 'userinfotype', columntitle: '品类', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21797, tablekey: 'table_pcweb_stock_manage_current', columnfield: 'userinfotype', columntitle: '品牌', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21798, tablekey: 'table_pcweb_stock_manage_current', columnfield: 'userinfotype', columntitle: '仓库', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21799, tablekey: 'table_pcweb_stock_manage_current', columnfield: 'userinfotype', columntitle: '昨日量', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21800, tablekey: 'table_pcweb_stock_manage_current', columnfield: 'userinfotype', columntitle: '今日量 ', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21801, tablekey: 'table_pcweb_stock_manage_current', columnfield: 'userinfotype', columntitle: '今日入库量', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21802, tablekey: 'table_pcweb_stock_manage_current', columnfield: 'userinfotype', columntitle: '今日出库量', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_stock_manage_applylog', tabletype: 2, tablename: '库存管理-当前库存', tabelmenu: '', remark: 'web端-库存管理-当前库存', columns: [ { autoid: 21803, tablekey: 'table_pcweb_stock_manage_applylog', columnfield: 'userinfotype', columntitle: '登记时间', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21804, tablekey: 'table_pcweb_stock_manage_applylog', columnfield: 'userinfotype', columntitle: '审核时间', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21805, tablekey: 'table_pcweb_stock_manage_applylog', columnfield: 'userinfotype', columntitle: '现货品种', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21806, tablekey: 'table_pcweb_stock_manage_applylog', columnfield: 'userinfotype', columntitle: '类型', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21807, tablekey: 'table_pcweb_stock_manage_applylog', columnfield: 'userinfotype', columntitle: '数量', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21808, tablekey: 'table_pcweb_stock_manage_applylog', columnfield: 'userinfotype', columntitle: '状态', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21809, tablekey: 'table_pcweb_stock_manage_applylog', columnfield: 'userinfotype', columntitle: '合同编号', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21810, tablekey: 'table_pcweb_stock_manage_applylog', columnfield: 'userinfotype', columntitle: '品类', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21811, tablekey: 'table_pcweb_stock_manage_applylog', columnfield: 'userinfotype', columntitle: '品牌', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21812, tablekey: 'table_pcweb_stock_manage_applylog', columnfield: 'userinfotype', columntitle: '仓库', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21813, tablekey: 'table_pcweb_stock_manage_applylog', columnfield: 'userinfotype', columntitle: '申请人', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21814, tablekey: 'table_pcweb_stock_manage_applylog', columnfield: 'userinfotype', columntitle: '审核人', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_purchase_pointprice', tabletype: 2, tablename: '采购_待点价', tabelmenu: '', remark: 'web端-采购-待点价', columns: [ { autoid: 21526, tablekey: 'table_pcweb_purchase_pointprice', columnfield: 'accountname', columntitle: '销售方', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'accountname,', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21527, tablekey: 'table_pcweb_purchase_pointprice', columnfield: 'contractno', columntitle: '合同编号 ', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contractno', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21528, tablekey: 'table_pcweb_purchase_pointprice', columnfield: 'deliverygoodsname', columntitle: '现货品种', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverygoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21529, tablekey: 'table_pcweb_purchase_pointprice', columnfield: 'spotgoodsdesc', columntitle: '商品规格 ', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'spotgoodsdesc', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21530, tablekey: 'table_pcweb_purchase_pointprice', columnfield: 'goodscode', columntitle: '点价合约', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodscode', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21531, tablekey: 'table_pcweb_purchase_pointprice', columnfield: 'pricemove', columntitle: '升贴水', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricemove', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21532, tablekey: 'table_pcweb_purchase_pointprice', columnfield: 'qty', columntitle: '合同量', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'qty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21533, tablekey: 'table_pcweb_purchase_pointprice', columnfield: 'unpricedqty', columntitle: '未定价量', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'unpricedqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21534, tablekey: 'table_pcweb_purchase_pointprice', columnfield: 'pricedqty', columntitle: '已定价量', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricedqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21535, tablekey: 'table_pcweb_purchase_pointprice', columnfield: 'unsureqty', columntitle: '未交收量 ', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'unsureqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21536, tablekey: 'table_pcweb_purchase_pointprice', columnfield: 'payamount', columntitle: '已支付额', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'payamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21537, tablekey: 'table_pcweb_purchase_pointprice', columnfield: 'unpayAmount', columntitle: '待支付额 ', columnwidth: '0', orderindex: 120, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'unpayAmount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21538, tablekey: 'table_pcweb_purchase_pointprice', columnfield: 'invoiceamount', columntitle: '已开票额', columnwidth: '0', orderindex: 130, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'invoiceamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21539, tablekey: 'table_pcweb_purchase_pointprice', columnfield: 'daikaiAmount', columntitle: '待开票额', columnwidth: '0', orderindex: 140, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'daikaiAmount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21540, tablekey: 'table_pcweb_purchase_pointprice', columnfield: 'eliverystartdate,deliveryenddate', columntitle: '点价期', columnwidth: '0', orderindex: 150, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'eliverystartdate,deliveryenddate', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21541, tablekey: 'table_pcweb_purchase_pointprice', columnfield: 'startdate,enddate', columntitle: '交收期', columnwidth: '0', orderindex: 160, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'startdate,enddate', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21542, tablekey: 'table_pcweb_purchase_pointprice', columnfield: 'convertfactor', columntitle: '标仓系数', columnwidth: '0', orderindex: 170, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'convertfactor', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_purchase_settle', tabletype: 2, tablename: '采购_履约交收', tabelmenu: '', remark: 'web端-采购-履约交收', columns: [ { autoid: 21543, tablekey: 'table_pcweb_purchase_settle', columnfield: 'accountname', columntitle: '销售方', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'accountname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21544, tablekey: 'table_pcweb_purchase_settle', columnfield: 'contractno', columntitle: '合同编号 ', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contractno', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21545, tablekey: 'table_pcweb_purchase_settle', columnfield: 'deliverygoodsname', columntitle: '现货品种', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverygoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21546, tablekey: 'table_pcweb_purchase_settle', columnfield: 'spotgoodsdesc', columntitle: '商品规格', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'spotgoodsdesc', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21547, tablekey: 'table_pcweb_purchase_settle', columnfield: 'goodscode', columntitle: '点价合约', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodscode', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21548, tablekey: 'table_pcweb_purchase_settle', columnfield: 'pricemove', columntitle: '升贴水', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricemove', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21549, tablekey: 'table_pcweb_purchase_settle', columnfield: 'pricedqty', columntitle: '已定价量', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricedqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21550, tablekey: 'table_pcweb_purchase_settle', columnfield: 'unsureqty', columntitle: '未交收量', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'unsureqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21551, tablekey: 'table_pcweb_purchase_settle', columnfield: 'payamount', columntitle: '已支付额', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'payamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21552, tablekey: 'table_pcweb_purchase_settle', columnfield: 'unpayAmount', columntitle: '待支付额 ', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'unpayAmount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21553, tablekey: 'table_pcweb_purchase_settle', columnfield: 'invoiceamount', columntitle: '已开票额', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'invoiceamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21554, tablekey: 'table_pcweb_purchase_settle', columnfield: 'daikaiAmount', columntitle: '待开票额 ', columnwidth: '0', orderindex: 120, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'daikaiAmount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21555, tablekey: 'table_pcweb_purchase_settle', columnfield: 'deliverystartdate,deliveryenddate', columntitle: '点价期', columnwidth: '0', orderindex: 130, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverystartdate,deliveryenddate', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21556, tablekey: 'table_pcweb_purchase_settle', columnfield: 'startdate,enddate', columntitle: '交收期 ', columnwidth: '0', orderindex: 140, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'tartdate,enddate', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21557, tablekey: 'table_pcweb_purchase_settle', columnfield: 'convertfactor', columntitle: '标仓系数', columnwidth: '0', orderindex: 150, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'convertfactor', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21558, tablekey: 'table_pcweb_purchase_settle', columnfield: 'qty', columntitle: '合同量', columnwidth: '0', orderindex: 160, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'qty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21559, tablekey: 'table_pcweb_purchase_settle', columnfield: 'unpricedqty', columntitle: '未定价量', columnwidth: '0', orderindex: 170, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'unpricedqty', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_purchase_all', tabletype: 2, tablename: '采购_全部', tabelmenu: '', remark: 'web端-采购-全部', columns: [ { autoid: 21560, tablekey: 'table_pcweb_purchase_all', columnfield: 'accountname', columntitle: '销售方 ', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'accountname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21561, tablekey: 'table_pcweb_purchase_all', columnfield: 'contractno', columntitle: '合同编号 ', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contractno', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21562, tablekey: 'table_pcweb_purchase_all', columnfield: 'contracctstatus', columntitle: '状态', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contracctstatus', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21563, tablekey: 'table_pcweb_purchase_all', columnfield: 'deliverygoodsname', columntitle: '现货品种', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverygoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21564, tablekey: 'table_pcweb_purchase_all', columnfield: 'spotgoodsdesc', columntitle: '商品规格', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'spotgoodsdesc', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21565, tablekey: 'table_pcweb_purchase_all', columnfield: 'goodscode', columntitle: '点价合约 ', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodscode', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21566, tablekey: 'table_pcweb_purchase_all', columnfield: 'pricemove', columntitle: '升贴水 ', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricemove', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21567, tablekey: 'table_pcweb_purchase_all', columnfield: 'convertfactor', columntitle: '标仓系数 ', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'convertfactor', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21568, tablekey: 'table_pcweb_purchase_all', columnfield: 'contracctstatus', columntitle: '状态 ', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contracctstatus', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21569, tablekey: 'table_pcweb_purchase_all', columnfield: 'qty', columntitle: '合同量', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'qty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21570, tablekey: 'table_pcweb_purchase_all', columnfield: 'unpricedqty', columntitle: '未定价量 ', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'unpricedqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21571, tablekey: 'table_pcweb_purchase_all', columnfield: 'pricedqty', columntitle: '已定价量 ', columnwidth: '0', orderindex: 120, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricedqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21572, tablekey: 'table_pcweb_purchase_all', columnfield: 'unsureqty', columntitle: '未交收量 ', columnwidth: '0', orderindex: 130, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'unsureqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21573, tablekey: 'table_pcweb_purchase_all', columnfield: 'payamount', columntitle: '已支付额', columnwidth: '0', orderindex: 140, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'payamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21574, tablekey: 'table_pcweb_purchase_all', columnfield: 'unpayAmount', columntitle: '待支付额 ', columnwidth: '0', orderindex: 150, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'unpayAmount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21575, tablekey: 'table_pcweb_purchase_all', columnfield: 'invoiceamount', columntitle: '已开票额', columnwidth: '0', orderindex: 160, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'invoiceamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21576, tablekey: 'table_pcweb_purchase_all', columnfield: 'daikaiAmount', columntitle: '待开票额 ', columnwidth: '0', orderindex: 170, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'daikaiAmount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21577, tablekey: 'table_pcweb_purchase_all', columnfield: 'deliverystartdate,deliveryenddate', columntitle: '点价期 ', columnwidth: '0', orderindex: 180, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverystartdate,deliveryenddate', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21578, tablekey: 'table_pcweb_purchase_all', columnfield: 'startdate,enddate', columntitle: '交收期 ', columnwidth: '0', orderindex: 190, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'startdate,enddate', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_sales_pointprice', tabletype: 2, tablename: '销售_待点价', tabelmenu: '', remark: 'web端-销售-待点价', columns: [ { autoid: 21579, tablekey: 'table_pcweb_sales_pointprice', columnfield: 'accountname', columntitle: '采购方 ', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'accountname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21580, tablekey: 'table_pcweb_sales_pointprice', columnfield: 'contractno', columntitle: '合同编号', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contractno', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21581, tablekey: 'table_pcweb_sales_pointprice', columnfield: 'deliverygoodsname', columntitle: '现货品种 ', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverygoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21582, tablekey: 'table_pcweb_sales_pointprice', columnfield: 'spotgoodsdesc', columntitle: '商品规格 ', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'spotgoodsdesc', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21583, tablekey: 'table_pcweb_sales_pointprice', columnfield: 'goodscode', columntitle: '点价合约', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodscode', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21584, tablekey: 'table_pcweb_sales_pointprice', columnfield: 'pricemove', columntitle: '升贴水 ', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricemove', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21585, tablekey: 'table_pcweb_sales_pointprice', columnfield: 'qty', columntitle: '合同量', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'qty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21586, tablekey: 'table_pcweb_sales_pointprice', columnfield: 'unpricedqty', columntitle: '未定价量 ', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'unpricedqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21587, tablekey: 'table_pcweb_sales_pointprice', columnfield: 'pricedqty', columntitle: '已定价量 ', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricedqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21588, tablekey: 'table_pcweb_sales_pointprice', columnfield: 'unsureqty', columntitle: '未交收量 ', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'unsureqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21589, tablekey: 'table_pcweb_sales_pointprice', columnfield: 'payamount', columntitle: '已收款额 ', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'payamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21590, tablekey: 'table_pcweb_sales_pointprice', columnfield: 'unpayAmount', columntitle: '待收款额 ', columnwidth: '0', orderindex: 120, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'unpayAmount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21591, tablekey: 'table_pcweb_sales_pointprice', columnfield: 'invoiceamount', columntitle: '已开票额 ', columnwidth: '0', orderindex: 130, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'invoiceamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21592, tablekey: 'table_pcweb_sales_pointprice', columnfield: 'deliverystartdate,deliveryenddate', columntitle: '点价期', columnwidth: '0', orderindex: 140, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverystartdate,deliveryenddate', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21593, tablekey: 'table_pcweb_sales_pointprice', columnfield: 'startdate,enddate', columntitle: '交收期 ', columnwidth: '0', orderindex: 150, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'startdate,enddate', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21594, tablekey: 'table_pcweb_sales_pointprice', columnfield: 'convertfactor', columntitle: '标仓系数', columnwidth: '0', orderindex: 160, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'convertfactor', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_sales_settle', tabletype: 2, tablename: '销售_履约交收', tabelmenu: '', remark: 'web端-销售-履约交收', columns: [ { autoid: 21595, tablekey: 'table_pcweb_sales_settle', columnfield: 'accountname', columntitle: '采购方', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'accountname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21596, tablekey: 'table_pcweb_sales_settle', columnfield: 'contractno', columntitle: '合同编号 ', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contractno', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21597, tablekey: 'table_pcweb_sales_settle', columnfield: 'deliverygoodsname', columntitle: '现货品种 ', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverygoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21598, tablekey: 'table_pcweb_sales_settle', columnfield: 'spotgoodsdesc', columntitle: '商品规格 ', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'spotgoodsdesc', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21599, tablekey: 'table_pcweb_sales_settle', columnfield: 'goodscode', columntitle: '点价合约', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodscode', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21600, tablekey: 'table_pcweb_sales_settle', columnfield: 'pricemove', columntitle: '升贴水 ', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricemove', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21601, tablekey: 'table_pcweb_sales_settle', columnfield: 'pricedqty', columntitle: '已定价量 ', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricedqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21602, tablekey: 'table_pcweb_sales_settle', columnfield: 'unsureqty', columntitle: '未交收量 ', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'unsureqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21603, tablekey: 'table_pcweb_sales_settle', columnfield: 'payamount', columntitle: '已收款额 ', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'payamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21604, tablekey: 'table_pcweb_sales_settle', columnfield: 'unpayAmount', columntitle: '待收款额 ', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'unpayAmount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21605, tablekey: 'table_pcweb_sales_settle', columnfield: 'invoiceamount', columntitle: '已开票额', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'invoiceamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21606, tablekey: 'table_pcweb_sales_settle', columnfield: 'daikaiAmount', columntitle: '待开票额 ', columnwidth: '0', orderindex: 120, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'daikaiAmount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21607, tablekey: 'table_pcweb_sales_settle', columnfield: 'deliverystartdate,deliveryenddate', columntitle: '点价期 ', columnwidth: '0', orderindex: 130, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverystartdate,deliveryenddate', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21608, tablekey: 'table_pcweb_sales_settle', columnfield: 'startdate,enddate', columntitle: '交收期 ', columnwidth: '0', orderindex: 140, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'startdate,enddate', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21609, tablekey: 'table_pcweb_sales_settle', columnfield: 'convertfactor', columntitle: '标仓系数', columnwidth: '0', orderindex: 150, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'convertfactor', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21610, tablekey: 'table_pcweb_sales_settle', columnfield: 'qty', columntitle: '合同量', columnwidth: '0', orderindex: 160, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'qty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21611, tablekey: 'table_pcweb_sales_settle', columnfield: 'unpricedqty', columntitle: '未定价量 ', columnwidth: '0', orderindex: 170, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'unpricedqty', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_sales_all', tabletype: 2, tablename: '销售_全部', tabelmenu: '', remark: 'web端-销售-全部', columns: [ { autoid: 21612, tablekey: 'table_pcweb_sales_all', columnfield: 'accountname', columntitle: '采购方', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'accountname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21613, tablekey: 'table_pcweb_sales_all', columnfield: 'contractno', columntitle: '合同编号 ', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contractno', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21614, tablekey: 'table_pcweb_sales_all', columnfield: 'contracctstatus', columntitle: '状态', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contracctstatus', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21615, tablekey: 'table_pcweb_sales_all', columnfield: 'deliverygoodsname', columntitle: '现货品种 ', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverygoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21616, tablekey: 'table_pcweb_sales_all', columnfield: 'spotgoodsdesc', columntitle: '商品规格 ', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'spotgoodsdesc', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21617, tablekey: 'table_pcweb_sales_all', columnfield: 'goodscode', columntitle: '点价合约 ', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodscode', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21618, tablekey: 'table_pcweb_sales_all', columnfield: 'pricemove', columntitle: '升贴水 ', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricemove', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21619, tablekey: 'table_pcweb_sales_all', columnfield: 'convertfactor', columntitle: '标仓系数 ', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'convertfactor', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21620, tablekey: 'table_pcweb_sales_all', columnfield: 'contracctstatus', columntitle: '状态 ', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contracctstatus', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21621, tablekey: 'table_pcweb_sales_all', columnfield: 'qty', columntitle: '合同量', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'qty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21622, tablekey: 'table_pcweb_sales_all', columnfield: 'unpricedqty', columntitle: '未定价量 ', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'unpricedqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21623, tablekey: 'table_pcweb_sales_all', columnfield: 'pricedqty', columntitle: '已定价量 ', columnwidth: '0', orderindex: 120, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricedqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21624, tablekey: 'table_pcweb_sales_all', columnfield: 'unsureqty', columntitle: '未交收量 ', columnwidth: '0', orderindex: 130, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'unsureqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21625, tablekey: 'table_pcweb_sales_all', columnfield: 'payamount', columntitle: '已收款额 ', columnwidth: '0', orderindex: 140, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'payamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21626, tablekey: 'table_pcweb_sales_all', columnfield: 'unpayAmount', columntitle: '待收款额 ', columnwidth: '0', orderindex: 150, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'unpayAmount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21627, tablekey: 'table_pcweb_sales_all', columnfield: 'invoiceamount', columntitle: '已开票额 ', columnwidth: '0', orderindex: 160, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'invoiceamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21628, tablekey: 'table_pcweb_sales_all', columnfield: 'daikaiAmount', columntitle: '待开票额 ', columnwidth: '0', orderindex: 170, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'daikaiAmount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21629, tablekey: 'table_pcweb_sales_all', columnfield: 'deliverystartdate,deliveryenddate', columntitle: '点价期 ', columnwidth: '0', orderindex: 180, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverystartdate,deliveryenddate', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21630, tablekey: 'table_pcweb_sales_all', columnfield: 'startdate,enddate', columntitle: '交收期 ', columnwidth: '0', orderindex: 190, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'startdate,enddate', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_exposure', tabletype: 2, tablename: '实时敞口', tabelmenu: '', remark: 'web端-实时敞口', columns: [ { autoid: 21631, tablekey: 'table_pcweb_exposure', columnfield: 'MiddleGoodsName', columntitle: '套保品种', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'MiddleGoodsName', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21632, tablekey: 'table_pcweb_exposure', columnfield: 'MiddleGoodsCode', columntitle: '代码', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'MiddleGoodsCode', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21633, tablekey: 'table_pcweb_exposure', columnfield: 'TotalSpotQty', columntitle: '现货总量', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'TotalSpotQty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21634, tablekey: 'table_pcweb_exposure', columnfield: 'diffSpotQty', columntitle: '现货总量变动量', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'diffSpotQty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21635, tablekey: 'table_pcweb_exposure', columnfield: 'hedgeqty', columntitle: '套保量', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'hedgeqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21636, tablekey: 'table_pcweb_exposure', columnfield: 'arbitrageqty', columntitle: '套利量', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'arbitrageqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21637, tablekey: 'table_pcweb_exposure', columnfield: 'diffHedgeQty', columntitle: '套保变动量', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'diffHedgeQty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21638, tablekey: 'table_pcweb_exposure', columnfield: 'diffArbitrageQty', columntitle: '套利变动量', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'diffArbitrageQty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21639, tablekey: 'table_pcweb_exposure', columnfield: 'MiddleGoodsHedgeRatio', columntitle: '套保比例', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'MiddleGoodsHedgeRatio', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21640, tablekey: 'table_pcweb_exposure', columnfield: 'needarbitrageratio', columntitle: '套利比例', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'needarbitrageratio', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21641, tablekey: 'table_pcweb_exposure', columnfield: 'needhedgeqty', columntitle: '应套保量', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'needhedgeqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21642, tablekey: 'table_pcweb_exposure', columnfield: 'needarbitrageqty', columntitle: '应套利量', columnwidth: '0', orderindex: 120, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'needarbitrageqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21643, tablekey: 'table_pcweb_exposure', columnfield: 'TotalNeedHedgeQty', columntitle: '现货应套保总量', columnwidth: '0', orderindex: 130, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'TotalNeedHedgeQty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21644, tablekey: 'table_pcweb_exposure', columnfield: 'diffSpotHedgeQty', columntitle: '现货应套保总量变动量', columnwidth: '0', orderindex: 140, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'diffSpotHedgeQty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21645, tablekey: 'table_pcweb_exposure', columnfield: 'TotalFutureQty', columntitle: '期货总量', columnwidth: '0', orderindex: 150, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'TotalFutureQty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21646, tablekey: 'table_pcweb_exposure', columnfield: 'diffFutuQty', columntitle: '期货总量变动量', columnwidth: '0', orderindex: 160, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'diffFutuQty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21647, tablekey: 'table_pcweb_exposure', columnfield: 'NeedHedgeExposoure', columntitle: '套保敞口', columnwidth: '0', orderindex: 170, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'NeedHedgeExposoure', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21648, tablekey: 'table_pcweb_exposure', columnfield: 'diffExposoureQty', columntitle: '套保敞口变动量', columnwidth: '0', orderindex: 180, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'diffExposoureQty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21649, tablekey: 'table_pcweb_exposure', columnfield: 'TotalExposure', columntitle: '总敞口', columnwidth: '0', orderindex: 190, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'TotalExposure', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21650, tablekey: 'table_pcweb_exposure', columnfield: 'diffQty', columntitle: '总敞口变动量', columnwidth: '0', orderindex: 200, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'diffQty', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_exposure_detail', tabletype: 2, tablename: '实时敞口--现货明细', tabelmenu: '', remark: 'web端--实时敞口--现货明细', columns: [ { autoid: 21651, tablekey: 'table_pcweb_exposure_detail', columnfield: 'createtime', columntitle: '套保品种', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'createtime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21652, tablekey: 'table_pcweb_exposure_detail', columnfield: 'createtime', columntitle: '代码', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'createtime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21653, tablekey: 'table_pcweb_exposure_detail', columnfield: 'createtime', columntitle: '时间', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'createtime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21654, tablekey: 'table_pcweb_exposure_detail', columnfield: 'logtype', columntitle: '类型', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'logtype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21655, tablekey: 'table_pcweb_exposure_detail', columnfield: 'deliverygoodsname', columntitle: '现货品种', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverygoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21656, tablekey: 'table_pcweb_exposure_detail', columnfield: 'qty', columntitle: '现货品种数量', columnwidth: '0', orderindex: 4, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'qty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21657, tablekey: 'table_pcweb_exposure_detail', columnfield: 'middlegoodscode', columntitle: '套保品种变动量', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'middlegoodscode', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21658, tablekey: 'table_pcweb_exposure_detail', columnfield: 'relateNo', columntitle: '合同(计划)编号 ', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'relateNo', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21659, tablekey: 'table_pcweb_exposure_detail', columnfield: 'convertfactor', columntitle: '标仓系数', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'convertfactor', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21660, tablekey: 'table_pcweb_exposure_detail', columnfield: 'convertratio', columntitle: '套保系数 ', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'convertratio', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_exposure_futures_detail', tabletype: 2, tablename: '实时敞口--期货明细', tabelmenu: '', remark: 'web端--实时敞口--期货明细', columns: [ { autoid: 21661, tablekey: 'table_pcweb_exposure_futures_detail', columnfield: 'goodsname', columntitle: '期货合约 ', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21662, tablekey: 'table_pcweb_exposure_futures_detail', columnfield: 'goodscode', columntitle: '代码 ', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodscode', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21663, tablekey: 'table_pcweb_exposure_futures_detail', columnfield: 'goodscode', columntitle: '时间 ', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodscode', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21664, tablekey: 'table_pcweb_exposure_futures_detail', columnfield: 'ydqty', columntitle: '昨日持仓', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'ydqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21665, tablekey: 'table_pcweb_exposure_futures_detail', columnfield: 'diffqty', columntitle: '持仓变动量', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'diffqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21666, tablekey: 'table_pcweb_exposure_futures_detail', columnfield: 'curqty', columntitle: '当前持仓', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'curqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21667, tablekey: 'table_pcweb_exposure_futures_detail', columnfield: 'diffhedgeqty', columntitle: '套保品种变动量', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'diffhedgeqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21668, tablekey: 'table_pcweb_exposure_futures_detail', columnfield: 'agreeunit', columntitle: '合约单位', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'agreeunit', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21669, tablekey: 'table_pcweb_exposure_futures_detail', columnfield: 'convertratio', columntitle: '期货品种系数 ', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'convertratio', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_exposure_spotposition', tabletype: 2, tablename: '敞口--现货头寸', tabelmenu: '', remark: 'web端--敞口--现货头寸', columns: [ { autoid: 21670, tablekey: 'table_pcweb_exposure_spotposition', columnfield: 'deliverygoodsname', columntitle: '现货品种', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'wrstandardname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21671, tablekey: 'table_pcweb_exposure_spotposition', columnfield: 'deliverygoodscode', columntitle: '代码', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'wrstandardcode', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21672, tablekey: 'table_pcweb_exposure_spotposition', columnfield: 'oritoalspotqty', columntitle: '昨日数量', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'oritoalspotqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21673, tablekey: 'table_pcweb_exposure_spotposition', columnfield: 'increaseqty', columntitle: '增加数量', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'increaseqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21674, tablekey: 'table_pcweb_exposure_spotposition', columnfield: 'decreaseqty', columntitle: '减少数量', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'decreaseqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21675, tablekey: 'table_pcweb_exposure_spotposition', columnfield: 'totalspotqty', columntitle: '当前数量', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'totalspotqty', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_exposure_spotposition_detail', tabletype: 2, tablename: '敞口--现货头寸--现货明细', tabelmenu: '', remark: 'web端-敞口--现货头寸--现货明细', columns: [ { autoid: 21676, tablekey: 'table_pcweb_exposure_spotposition_detail', columnfield: 'strtime', columntitle: '时间', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'strtime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21677, tablekey: 'table_pcweb_exposure_spotposition_detail', columnfield: 'nrelatedid', columntitle: '编号 ', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'nrelatedid', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21678, tablekey: 'table_pcweb_exposure_spotposition_detail', columnfield: 'contracttype', columntitle: '类型', columnwidth: '0', orderindex: 230, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contracttype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21679, tablekey: 'table_pcweb_exposure_spotposition_detail', columnfield: 'wrstandardname', columntitle: '现货品种', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'wrstandardname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21680, tablekey: 'table_pcweb_exposure_spotposition_detail', columnfield: 'qty', columntitle: '数量', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'qty', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_exposure_futuresposition', tabletype: 2, tablename: '敞口--期货头寸', tabelmenu: '', remark: 'web端-敞口--期货头寸', columns: [ { autoid: 21681, tablekey: 'table_pcweb_exposure_futuresposition', columnfield: 'goodsname', columntitle: '期货合约', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21682, tablekey: 'table_pcweb_exposure_futuresposition', columnfield: 'goodscode', columntitle: '代码 ', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodscode', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21683, tablekey: 'table_pcweb_exposure_futuresposition', columnfield: 'totalydqty', columntitle: '昨日数量', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'totalydqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21684, tablekey: 'table_pcweb_exposure_futuresposition', columnfield: 'increaseqty', columntitle: '增加数量', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'increaseqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21685, tablekey: 'table_pcweb_exposure_futuresposition', columnfield: 'decreaseqty', columntitle: '减少数量 ', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'decreaseqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21686, tablekey: 'table_pcweb_exposure_futuresposition', columnfield: 'totalcurqty', columntitle: '当前数量', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'totalcurqty', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_exposure_futuresposition_detail', tabletype: 2, tablename: '敞口--现货头寸--期货明细', tabelmenu: '', remark: 'web端-敞口--现货头寸--期货明细', columns: [ { autoid: 21687, tablekey: 'table_pcweb_exposure_futuresposition_detail', columnfield: 'tradetime', columntitle: '时间', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'tradetime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21688, tablekey: 'table_pcweb_exposure_futuresposition_detail', columnfield: 'goodsname', columntitle: '期货合约 ', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21689, tablekey: 'table_pcweb_exposure_futuresposition_detail', columnfield: 'buyorsell', columntitle: '方向', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'buyorsell', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21690, tablekey: 'table_pcweb_exposure_futuresposition_detail', columnfield: 'channelbuildtype', columntitle: '开平', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'channelbuildtype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21691, tablekey: 'table_pcweb_exposure_futuresposition_detail', columnfield: 'tradeqty', columntitle: '数量(手)', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'tradeqty', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_report_spot_detail_day', tabletype: 2, tablename: '现货日报表-详情', tabelmenu: '', remark: 'web端-现货日报表-详情', columns: [ { autoid: 21692, tablekey: 'table_pcweb_report_spot_detail_day', columnfield: 'logdatetime', columntitle: '发生时间', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'logdatetime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21693, tablekey: 'table_pcweb_report_spot_detail_day', columnfield: 'brandname', columntitle: '商品品类 ', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'brandname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21694, tablekey: 'table_pcweb_report_spot_detail_day', columnfield: 'logtypename', columntitle: '合同类型', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'logtypename', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21695, tablekey: 'table_pcweb_report_spot_detail_day', columnfield: 'relatedno', columntitle: '合同编号 ', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'relatedno', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21696, tablekey: 'table_pcweb_report_spot_detail_day', columnfield: 'biztype', columntitle: '操作类型', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'biztype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21697, tablekey: 'table_pcweb_report_spot_detail_day', columnfield: 'logvalue', columntitle: '值 ', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'logvalue', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21698, tablekey: 'table_pcweb_report_spot_detail_day', columnfield: 'applyname', columntitle: '操作人', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applyname', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_report_spot_detail_month', tabletype: 2, tablename: '现货月报表-详情', tabelmenu: '', remark: 'web端-现货月报表-详情', columns: [ { autoid: 21699, tablekey: 'table_pcweb_report_spot_detail_month', columnfield: 'reckondate', columntitle: '日期', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'reckondate', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21700, tablekey: 'table_pcweb_report_spot_detail_month', columnfield: 'totalbuypricedqty', columntitle: '采购定价量', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'totalbuypricedqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21701, tablekey: 'table_pcweb_report_spot_detail_month', columnfield: 'totalsellpricedqty', columntitle: '销售定价量 ', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'totalsellpricedqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21702, tablekey: 'table_pcweb_report_spot_detail_month', columnfield: 'todaysellreckonqty', columntitle: '采购确定量', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todaysellreckonqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21703, tablekey: 'table_pcweb_report_spot_detail_month', columnfield: 'todaysellreckonqty', columntitle: '销售确定量 ', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todaysellreckonqty', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_report_fincial_payment_day', tabletype: 2, tablename: '报表-财务报表-款项-日报表', tabelmenu: '', remark: 'web端-报表-财务报表-款项-日报表', columns: [ { autoid: 21704, tablekey: 'table_pcweb_report_fincial_payment_day', columnfield: 'logdatetime', columntitle: '款项发生时间', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'logdatetime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21705, tablekey: 'table_pcweb_report_fincial_payment_day', columnfield: 'logtypename', columntitle: '合同类型', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'logtypename', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21706, tablekey: 'table_pcweb_report_fincial_payment_day', columnfield: 'relatedno', columntitle: '合同编号 ', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'relatedno', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21707, tablekey: 'table_pcweb_report_fincial_payment_day', columnfield: 'biztype', columntitle: '类型', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'biztype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21708, tablekey: 'table_pcweb_report_fincial_payment_day', columnfield: 'logvalue', columntitle: '金额 ', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'logvalue', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21709, tablekey: 'table_pcweb_report_fincial_payment_day', columnfield: 'applyname', columntitle: '操作人', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applyname', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_report_fincial_invoice_day', tabletype: 2, tablename: '报表-财务报表-发票-日报表', tabelmenu: '', remark: 'web端-报表-财务报表-发票-日报表', columns: [ { autoid: 21710, tablekey: 'table_pcweb_report_fincial_invoice_day', columnfield: 'logdatetime', columntitle: '发票发生时间', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'logdatetime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21711, tablekey: 'table_pcweb_report_fincial_invoice_day', columnfield: 'optypename', columntitle: '合同类型', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'optypename', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21712, tablekey: 'table_pcweb_report_fincial_invoice_day', columnfield: 'relatedno', columntitle: '合同编号', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'relatedno', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21713, tablekey: 'table_pcweb_report_fincial_invoice_day', columnfield: 'contracttype', columntitle: '类型', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contracttype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21714, tablekey: 'table_pcweb_report_fincial_invoice_day', columnfield: 'logvalue', columntitle: '金额 ', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'logvalue', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21715, tablekey: 'table_pcweb_report_fincial_invoice_day', columnfield: 'applyname', columntitle: '操作人', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applyname', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_report_fincial_month', tabletype: 2, tablename: '报表-财务报表-月报表', tabelmenu: '', remark: 'web端-报表-财务报表-月报表', columns: [ { autoid: 21716, tablekey: 'table_pcweb_report_fincial_month', columnfield: 'updatetime', columntitle: '日期', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'updatetime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21717, tablekey: 'table_pcweb_report_fincial_month', columnfield: 'collectmoneycount', columntitle: '收笔款数', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'collectmoneycount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21718, tablekey: 'table_pcweb_report_fincial_month', columnfield: 'collectmoneyamount', columntitle: '收款金额 ', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'collectmoneyamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21719, tablekey: 'table_pcweb_report_fincial_month', columnfield: 'paymoneycount', columntitle: '付款笔数', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'paymoneycount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21720, tablekey: 'table_pcweb_report_fincial_month', columnfield: 'paymoneyamount', columntitle: '付款金额 ', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'paymoneyamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21721, tablekey: 'table_pcweb_report_fincial_month', columnfield: 'payinvoicecount', columntitle: '收票笔数', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'payinvoicecount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21722, tablekey: 'table_pcweb_report_fincial_month', columnfield: 'payinvoiceamount', columntitle: '收票金额 ', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'payinvoiceamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21723, tablekey: 'table_pcweb_report_fincial_month', columnfield: 'collectinvoicecount', columntitle: '开票笔数', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'collectinvoicecount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21724, tablekey: 'table_pcweb_report_fincial_month', columnfield: 'collectinvoiceamount', columntitle: '开票金额 ', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'collectinvoiceamount', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_business_aduit_dj', tabletype: 2, tablename: '业务审核-点价', tabelmenu: '', remark: 'web端-业务审核-点价', columns: [ { autoid: 21725, tablekey: 'table_pcweb_business_aduit_dj', columnfield: 'applystatus', columntitle: '状态', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contractstatus', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21726, tablekey: 'table_pcweb_business_aduit_dj', columnfield: 'contracttype', columntitle: '合同类型', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contracttype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21727, tablekey: 'table_pcweb_business_aduit_dj', columnfield: 'buyusernameOrsellusername', columntitle: '对手方', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'buyusernameOrsellusername', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21728, tablekey: 'table_pcweb_business_aduit_dj', columnfield: 'contractno', columntitle: '合同编号', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contractno', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21729, tablekey: 'table_pcweb_business_aduit_dj', columnfield: 'deliverygoodsname', columntitle: '现货品种', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverygoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21730, tablekey: 'table_pcweb_business_aduit_dj', columnfield: 'pricetype', columntitle: '点价类型', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricetype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21731, tablekey: 'table_pcweb_business_aduit_dj', columnfield: 'goodscode', columntitle: '点价合约', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodscode', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21732, tablekey: 'table_pcweb_business_aduit_dj', columnfield: 'pricedPrice', columntitle: '点价价格', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricedPrice', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21733, tablekey: 'table_pcweb_business_aduit_dj', columnfield: 'pricemove', columntitle: '升贴水', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricemove', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21734, tablekey: 'table_pcweb_business_aduit_dj', columnfield: 'pricedQty', columntitle: '点价数量', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applyname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21735, tablekey: 'table_pcweb_business_aduit_dj', columnfield: 'amount', columntitle: '点价金额', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'amount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21736, tablekey: 'table_pcweb_business_aduit_dj', columnfield: 'applytime', columntitle: '登记时间', columnwidth: '0', orderindex: 120, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'audittime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21737, tablekey: 'table_pcweb_business_aduit_dj', columnfield: 'applyname', columntitle: '登记人', columnwidth: '0', orderindex: 130, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contractstatus', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_business_aduit_js', tabletype: 2, tablename: '业务审核-交收', tabelmenu: '', remark: 'web端-业务审核-交收', columns: [ { autoid: 21738, tablekey: 'table_pcweb_business_aduit_js', columnfield: 'applystatus', columntitle: '状态', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applystatus', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21739, tablekey: 'table_pcweb_business_aduit_js', columnfield: 'contracttype', columntitle: '合同类型', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contracttype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21740, tablekey: 'table_pcweb_business_aduit_js', columnfield: 'buyusernameOrsellusername', columntitle: '对手方', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'buyusernameOrsellusername', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21741, tablekey: 'table_pcweb_business_aduit_js', columnfield: 'contractno', columntitle: '合同编号', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contractno', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21742, tablekey: 'table_pcweb_business_aduit_js', columnfield: 'deliverygoodsname', columntitle: '现货品种', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverygoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21743, tablekey: 'table_pcweb_business_aduit_js', columnfield: 'operateapplytype', columntitle: '点价类型', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'operateapplytype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21744, tablekey: 'table_pcweb_business_aduit_js', columnfield: 'reckonrealqty', columntitle: '交收量', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'reckonrealqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21745, tablekey: 'table_pcweb_business_aduit_js', columnfield: 'reckonotheramount', columntitle: '其它费用', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'reckonotheramount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21746, tablekey: 'table_pcweb_business_aduit_js', columnfield: 'addmargin||decmargin', columntitle: '调整保证金', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'addmargin||decmargin', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21747, tablekey: 'table_pcweb_business_aduit_js', columnfield: 'reckonadjustamount', columntitle: '调整金额', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'reckonadjustamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21748, tablekey: 'table_pcweb_business_aduit_js', columnfield: 'applytime', columntitle: '登记时间', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'audittime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21749, tablekey: 'table_pcweb_business_aduit_js', columnfield: 'applyname', columntitle: '登记人', columnwidth: '0', orderindex: 120, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'auditname', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_fincial_aduit_fp', tabletype: 2, tablename: '业务审核-发票', tabelmenu: '', remark: 'web端-业务审核-发票', columns: [ { autoid: 21750, tablekey: 'table_pcweb_fincial_aduit_fp', columnfield: 'applystatus', columntitle: '状态', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applystatus', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21751, tablekey: 'table_pcweb_fincial_aduit_fp', columnfield: 'contracttype', columntitle: '合同类型', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contracttype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21752, tablekey: 'table_pcweb_fincial_aduit_fp', columnfield: 'buyusernameOrsellusername', columntitle: '对手方', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contracttype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21753, tablekey: 'table_pcweb_fincial_aduit_fp', columnfield: 'contractno', columntitle: '合同编号', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contractno', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21754, tablekey: 'table_pcweb_fincial_aduit_fp', columnfield: 'deliverygoodsname', columntitle: '现货品种', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'audittime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21755, tablekey: 'table_pcweb_fincial_aduit_fp', columnfield: 'operateapplytype', columntitle: '点价类型', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'audittime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21756, tablekey: 'table_pcweb_fincial_aduit_fp', columnfield: 'contracttype', columntitle: '发票类型', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contracttype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21757, tablekey: 'table_pcweb_fincial_aduit_fp', columnfield: 'InvoiceAmount', columntitle: '金额', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'InvoiceAmount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21758, tablekey: 'table_pcweb_fincial_aduit_fp', columnfield: 'attachurl', columntitle: '发票附件', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'attachurl', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21759, tablekey: 'table_pcweb_fincial_aduit_fp', columnfield: 'applytime', columntitle: '登记时间', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applytime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21760, tablekey: 'table_pcweb_fincial_aduit_fp', columnfield: 'applyname', columntitle: '登记人', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applyname', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_fincial_aduit_kx', tabletype: 2, tablename: '财务审核-款项', tabelmenu: '', remark: 'web端-财务审核-款项', columns: [ { autoid: 21761, tablekey: 'table_pcweb_fincial_aduit_kx', columnfield: 'contractstatus', columntitle: '状态', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contractstatus', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21762, tablekey: 'table_pcweb_fincial_aduit_kx', columnfield: 'contracttype', columntitle: '合同类型', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contracttype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21763, tablekey: 'table_pcweb_fincial_aduit_kx', columnfield: 'buyusernameOrsellusername', columntitle: '对手方', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21764, tablekey: 'table_pcweb_fincial_aduit_kx', columnfield: 'contractno', columntitle: '合同编号', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contractno', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21765, tablekey: 'table_pcweb_fincial_aduit_kx', columnfield: 'deliverygoodsname', columntitle: '现货品种', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverygoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21766, tablekey: 'table_pcweb_fincial_aduit_kx', columnfield: 'operateapplytype', columntitle: '点价类型', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'operateapplytype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21767, tablekey: 'table_pcweb_fincial_aduit_kx', columnfield: 'kxtype', columntitle: '款项类型', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'kxtype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21768, tablekey: 'table_pcweb_fincial_aduit_kx', columnfield: 'payamount', columntitle: '金额', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'payamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21769, tablekey: 'table_pcweb_fincial_aduit_kx', columnfield: 'applytime', columntitle: '登记时间', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applytime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21770, tablekey: 'table_pcweb_fincial_aduit_kx', columnfield: 'applyname', columntitle: '登记人', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applyname', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_hedging_plan', tabletype: 2, tablename: '业务-套保计划', tabelmenu: '', remark: 'web端-业务-套保计划', columns: [ { autoid: 21815, tablekey: 'table_pcweb_hedging_plan', columnfield: 'contracttype', columntitle: '计划类型', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contracttype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21816, tablekey: 'table_pcweb_hedging_plan', columnfield: 'hedgeplanno', columntitle: '计划名称', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'hedgeplanno', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21817, tablekey: 'table_pcweb_hedging_plan', columnfield: 'deliverygoodsname', columntitle: '现货品种', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverygoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21818, tablekey: 'table_pcweb_hedging_plan', columnfield: 'convertfactor', columntitle: '标仓系数', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'convertfactor', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21819, tablekey: 'table_pcweb_hedging_plan', columnfield: 'planqty', columntitle: '计划量', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'planqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21820, tablekey: 'table_pcweb_hedging_plan', columnfield: 'hedgeplanstatus', columntitle: '状态', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'hedgeplanstatus', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_current_inventory', tabletype: 2, tablename: '库存查询-当前库存', tabelmenu: '', remark: 'web端-库存查询-当前库存', columns: [ { autoid: 21821, tablekey: 'table_pcweb_current_inventory', columnfield: 'deliverygoodsname', columntitle: '现货品种', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverygoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21822, tablekey: 'table_pcweb_current_inventory', columnfield: 'wrstandardname', columntitle: '品类', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'wrstandardname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21823, tablekey: 'table_pcweb_current_inventory', columnfield: 'brandname', columntitle: '品牌', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'brandname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21824, tablekey: 'table_pcweb_current_inventory', columnfield: 'warehousename', columntitle: '仓库', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'warehousename', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21825, tablekey: 'table_pcweb_current_inventory', columnfield: 'oristock', columntitle: '昨日量', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'oristock', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21826, tablekey: 'table_pcweb_current_inventory', columnfield: 'todayproduceinqty', columntitle: '今日入库量', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todayproduceinqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21827, tablekey: 'table_pcweb_current_inventory', columnfield: 'todayproduceoutqty', columntitle: '今日出库量', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todayproduceoutqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21828, tablekey: 'table_pcweb_current_inventory', columnfield: 'curstock', columntitle: '今日量', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'curstock', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_application_record', tabletype: 2, tablename: '库存查询-申请记录', tabelmenu: '', remark: 'web端-库存查询-申请记录', columns: [ { autoid: 21829, tablekey: 'table_pcweb_application_record', columnfield: 'deliverygoodsname', columntitle: '现货品种', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverygoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21830, tablekey: 'table_pcweb_application_record', columnfield: 'wrstandardname', columntitle: '品类', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'wrstandardname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21831, tablekey: 'table_pcweb_application_record', columnfield: 'brandname', columntitle: '品牌', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'brandname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21832, tablekey: 'table_pcweb_application_record', columnfield: 'warehousename', columntitle: '仓库', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'warehousename', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21833, tablekey: 'table_pcweb_application_record', columnfield: 'pricetype', columntitle: '类型', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricetype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21834, tablekey: 'table_pcweb_application_record', columnfield: 'qty', columntitle: '数量', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'qty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21835, tablekey: 'table_pcweb_application_record', columnfield: 'contractno', columntitle: '合同编号', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contractno', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21836, tablekey: 'table_pcweb_application_record', columnfield: 'applytime', columntitle: '登记时间', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'hedgeplanstatus', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21837, tablekey: 'table_pcweb_application_record', columnfield: 'applyname', columntitle: '登记人', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'hedgeplanstatus', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21838, tablekey: 'table_pcweb_application_record', columnfield: 'audittime', columntitle: '审核时间', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'hedgeplanstatus', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21839, tablekey: 'table_pcweb_application_record', columnfield: 'auditname', columntitle: '审核人', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'hedgeplanstatus', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_someprice_detail_dj', tabletype: 2, tablename: '现货合同详情-点价记录', tabelmenu: '', remark: 'web端-现货合同详情-点价记录', columns: [ { autoid: 21840, tablekey: 'table_pcweb_someprice_detail_dj', columnfield: 'applytime', columntitle: '点价登记时间', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applytime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21841, tablekey: 'table_pcweb_someprice_detail_dj', columnfield: 'audittime', columntitle: '点价审核时间', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'audittime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21842, tablekey: 'table_pcweb_someprice_detail_dj', columnfield: 'pricedPrice', columntitle: '点价价格', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricedPrice', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21843, tablekey: 'table_pcweb_someprice_detail_dj', columnfield: 'pricemove', columntitle: '升贴水', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricemove', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21844, tablekey: 'table_pcweb_someprice_detail_dj', columnfield: 'pricedQty', columntitle: '点价数量', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pricedQty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21845, tablekey: 'table_pcweb_someprice_detail_dj', columnfield: 'amount', columntitle: '点价金额', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'amount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21846, tablekey: 'table_pcweb_someprice_detail_dj', columnfield: 'applyname', columntitle: '申请人', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applyname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21847, tablekey: 'table_pcweb_someprice_detail_dj', columnfield: 'auditname', columntitle: '审核人', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'auditname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21848, tablekey: 'table_pcweb_someprice_detail_dj', columnfield: 'applystatus', columntitle: '状态', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applystatus', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_someprice_detail_js', tabletype: 2, tablename: '现货合同详情-交收记录', tabelmenu: '', remark: 'web端-现货合同详情-交收记录', columns: [ { autoid: 21849, tablekey: 'table_pcweb_someprice_detail_js', columnfield: 'applytime', columntitle: '交收登记时间', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applytime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21850, tablekey: 'table_pcweb_someprice_detail_js', columnfield: 'audittime', columntitle: '交收审核时间', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'audittime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21851, tablekey: 'table_pcweb_someprice_detail_js', columnfield: 'reckonrealqty', columntitle: '交收量', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'reckonrealqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21852, tablekey: 'table_pcweb_someprice_detail_js', columnfield: 'reckonotheramount', columntitle: '其他费用', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'reckonotheramount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21853, tablekey: 'table_pcweb_someprice_detail_js', columnfield: 'reckonadjustamount', columntitle: '调整保证金', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'reckonadjustamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21854, tablekey: 'table_pcweb_someprice_detail_js', columnfield: 'reckonadjustamount', columntitle: '调整金额', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'reckonadjustamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21855, tablekey: 'table_pcweb_someprice_detail_js', columnfield: 'applyname', columntitle: '申请人', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applyname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21856, tablekey: 'table_pcweb_someprice_detail_js', columnfield: 'auditname', columntitle: '审核人', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'auditname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21857, tablekey: 'table_pcweb_someprice_detail_js', columnfield: 'applystatus', columntitle: '状态', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applystatus', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_someprice_detail_kx', tabletype: 2, tablename: '现货合同详情-款项记录', tabelmenu: '', remark: 'web端-现货合同详情-款项记录', columns: [ { autoid: 21858, tablekey: 'table_pcweb_someprice_detail_kx', columnfield: 'applytime', columntitle: '款项登记时间', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applytime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21859, tablekey: 'table_pcweb_someprice_detail_kx', columnfield: 'audittime', columntitle: '款项审核时间', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'audittime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21860, tablekey: 'table_pcweb_someprice_detail_kx', columnfield: 'kxtype', columntitle: '款项类型', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'kxtype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21861, tablekey: 'table_pcweb_someprice_detail_kx', columnfield: 'payamount', columntitle: '金额', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'payamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21862, tablekey: 'table_pcweb_someprice_detail_kx', columnfield: 'applyname', columntitle: '申请人', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applyname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21863, tablekey: 'table_pcweb_someprice_detail_kx', columnfield: 'auditname', columntitle: '审核人', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'auditname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21864, tablekey: 'table_pcweb_someprice_detail_kx', columnfield: 'applystatus', columntitle: '状态', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applystatus', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_someprice_detail_fp', tabletype: 2, tablename: '现货合同详情-发票记录', tabelmenu: '', remark: 'web端-现货合同详情-发票记录', columns: [ { autoid: 21865, tablekey: 'table_pcweb_someprice_detail_fp', columnfield: 'applytime', columntitle: '发票登记时间', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applytime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21866, tablekey: 'table_pcweb_someprice_detail_fp', columnfield: 'audittime', columntitle: '发票审核时间', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'audittime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21867, tablekey: 'table_pcweb_someprice_detail_fp', columnfield: 'contracttype', columntitle: '发票类型', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contracttype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21868, tablekey: 'table_pcweb_someprice_detail_fp', columnfield: 'InvoiceAmount', columntitle: '金额', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'InvoiceAmount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21869, tablekey: 'table_pcweb_someprice_detail_fp', columnfield: 'applyname', columntitle: '申请人', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applyname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21870, tablekey: 'table_pcweb_someprice_detail_fp', columnfield: 'auditname', columntitle: '审核人', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'auditname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21871, tablekey: 'table_pcweb_someprice_detail_fp', columnfield: 'applystatus', columntitle: '状态', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applystatus', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_someprice_detail_stock', tabletype: 2, tablename: '现货合同详情-入库记录', tabelmenu: '', remark: 'web端-现货合同详情-入库记录', columns: [ { autoid: 21872, tablekey: 'table_pcweb_someprice_detail_stock', columnfield: 'applytime', columntitle: '入库登记时间', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applytime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21873, tablekey: 'table_pcweb_someprice_detail_stock', columnfield: 'audittime', columntitle: '入库审核时间', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'audittime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21874, tablekey: 'table_pcweb_someprice_detail_stock', columnfield: 'deliverygoodsname', columntitle: '现货品种', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverygoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21875, tablekey: 'table_pcweb_someprice_detail_stock', columnfield: 'wrstandardname', columntitle: '品类', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'wrstandardname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21876, tablekey: 'table_pcweb_someprice_detail_stock', columnfield: 'brandname', columntitle: '品牌', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'brandname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21877, tablekey: 'table_pcweb_someprice_detail_stock', columnfield: 'warehousename', columntitle: '仓库', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'warehousename', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21878, tablekey: 'table_pcweb_someprice_detail_stock', columnfield: 'inouttype', columntitle: '类型', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'inouttype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21879, tablekey: 'table_pcweb_someprice_detail_stock', columnfield: 'qty', columntitle: '数量', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'qty', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_someprice_detail_stock_out', tabletype: 2, tablename: '现货合同详情-出库记录', tabelmenu: '', remark: 'web端-现货合同详情-出库记录', columns: [ { autoid: 21880, tablekey: 'table_pcweb_someprice_detail_stock_out', columnfield: 'applytime', columntitle: '出库登记时间', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applytime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21881, tablekey: 'table_pcweb_someprice_detail_stock_out', columnfield: 'audittime', columntitle: '出库审核时间', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'audittime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21882, tablekey: 'table_pcweb_someprice_detail_stock_out', columnfield: 'deliverygoodsname', columntitle: '现货品种', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverygoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21883, tablekey: 'table_pcweb_someprice_detail_stock_out', columnfield: 'wrstandardname', columntitle: '品类', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'wrstandardname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21884, tablekey: 'table_pcweb_someprice_detail_stock_out', columnfield: 'brandname', columntitle: '品牌', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'brandname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21885, tablekey: 'table_pcweb_someprice_detail_stock_out', columnfield: 'warehousename', columntitle: '仓库', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'warehousename', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21886, tablekey: 'table_pcweb_someprice_detail_stock_out', columnfield: 'inouttype', columntitle: '类型', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'inouttype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21887, tablekey: 'table_pcweb_someprice_detail_stock_out', columnfield: 'qty', columntitle: '数量', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'qty', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_someprice_detail_change', tabletype: 2, tablename: '现货合同详情-变更记录', tabelmenu: '', remark: 'web端-现货合同详情-变更记录', columns: [ { autoid: 21888, tablekey: 'table_pcweb_someprice_detail_change', columnfield: 'updatetime', columntitle: '变更时间', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'updatetime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21889, tablekey: 'table_pcweb_someprice_detail_change', columnfield: 'operatelogtypedesc', columntitle: '类型', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'operatelogtypedesc', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21890, tablekey: 'table_pcweb_someprice_detail_change', columnfield: 'applyname', columntitle: '操作人', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'applyname', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_exposure_report', tabletype: 2, tablename: '报表-敞口报表', tabelmenu: '', remark: 'web端-报表-敞口报表', columns: [ { autoid: 21891, tablekey: 'table_pcweb_exposure_report', columnfield: 'areauserid', columntitle: '交易用户', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'areauserid', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21892, tablekey: 'table_pcweb_exposure_report', columnfield: 'middlegoodsname', columntitle: '套保品种', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'middlegoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21893, tablekey: 'table_pcweb_exposure_report', columnfield: 'totalspotqty', columntitle: '现货总量', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'totalspotqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21894, tablekey: 'table_pcweb_exposure_report', columnfield: 'diffspotqty', columntitle: '现货总量变动量', columnwidth: '160', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'diffspotqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21895, tablekey: 'table_pcweb_exposure_report', columnfield: 'hedgeqty', columntitle: '套保量', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'hedgeqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21896, tablekey: 'table_pcweb_exposure_report', columnfield: 'arbitrageqty', columntitle: '套利量', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'arbitrageqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21897, tablekey: 'table_pcweb_exposure_report', columnfield: 'diffmgqtya', columntitle: '套保变动量', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'diffmgqtya', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21898, tablekey: 'table_pcweb_exposure_report', columnfield: 'diffmgqtyb', columntitle: '套利变动量', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'diffmgqtyb', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21899, tablekey: 'table_pcweb_exposure_report', columnfield: 'mgneedhedgeratio', columntitle: '套保比例', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'mgneedhedgeratio', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21900, tablekey: 'table_pcweb_exposure_report', columnfield: 'needarbitrageratio', columntitle: '套利比例', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'needarbitrageratio', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21901, tablekey: 'table_pcweb_exposure_report', columnfield: 'needhedgeqty', columntitle: '应套保量', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'needhedgeqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21902, tablekey: 'table_pcweb_exposure_report', columnfield: 'needarbitrageqty', columntitle: '应套利量', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'needarbitrageqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21903, tablekey: 'table_pcweb_exposure_report', columnfield: 'totalneedhedgeqty', columntitle: '现货应套保量', columnwidth: '160', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'totalneedhedgeqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21904, tablekey: 'table_pcweb_exposure_report', columnfield: 'diffhedgeqty', columntitle: '现货应套保变动量', columnwidth: '160', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'diffhedgeqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21905, tablekey: 'table_pcweb_exposure_report', columnfield: 'totalfutureqty', columntitle: '期货总量', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'totalfutureqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21906, tablekey: 'table_pcweb_exposure_report', columnfield: 'needhedgeexposoure', columntitle: '套保敞口', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'needhedgeexposoure', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21907, tablekey: 'table_pcweb_exposure_report', columnfield: 'needhedgeqty', columntitle: '套保敞口变动', columnwidth: '160', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'needhedgeqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21908, tablekey: 'table_pcweb_exposure_report', columnfield: 'totalexposure', columntitle: '总敞口', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'totalexposure', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21909, tablekey: 'table_pcweb_exposure_report', columnfield: 'diffqty', columntitle: '总敞口变动量', columnwidth: '160', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'diffqty', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_futures_report', tabletype: 2, tablename: '报表-期货报表', tabelmenu: '', remark: 'web端-报表-期货报表', columns: [ { autoid: 21926, tablekey: 'table_pcweb_futures_report', columnfield: 'holdamount', columntitle: '期末持仓额', columnwidth: '0', orderindex: 170, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'holdamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21927, tablekey: 'table_pcweb_futures_report', columnfield: 'reckonprice', columntitle: '结算价', columnwidth: '0', orderindex: 180, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'reckonprice', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21928, tablekey: 'table_pcweb_futures_report', columnfield: 'reckonholdamount', columntitle: '结算持仓额', columnwidth: '0', orderindex: 190, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'reckonholdamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21929, tablekey: 'table_pcweb_futures_report', columnfield: 'charge', columntitle: '手续费', columnwidth: '0', orderindex: 200, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'charge', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21930, tablekey: 'table_pcweb_futures_report', columnfield: 'closepl', columntitle: '平仓损益', columnwidth: '0', orderindex: 210, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'closepl', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21931, tablekey: 'table_pcweb_futures_report', columnfield: 'reckonpl', columntitle: '结算损益', columnwidth: '0', orderindex: 220, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'reckonpl', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21932, tablekey: 'table_pcweb_futures_report', columnfield: 'goodsgroupspotqty', columntitle: '交易品种期末量', columnwidth: '0', orderindex: 230, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodsgroupspotqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21933, tablekey: 'table_pcweb_futures_report', columnfield: 'middlegoodsqty', columntitle: '套保品种', columnwidth: '0', orderindex: 240, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'middlegoodsqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21934, tablekey: 'table_pcweb_futures_report', columnfield: 'todaymiddlegoodsqty', columntitle: '套保品种变动量', columnwidth: '0', orderindex: 250, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todaymiddlegoodsqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21910, tablekey: 'table_pcweb_futures_report', columnfield: 'currencyid', columntitle: '结算币种', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'currencyid', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21911, tablekey: 'table_pcweb_futures_report', columnfield: 'userid', columntitle: '交易用户', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userid', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21912, tablekey: 'table_pcweb_futures_report', columnfield: 'goodsgroupname', columntitle: '交易品种', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodsgroupname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21913, tablekey: 'table_pcweb_futures_report', columnfield: 'goodsname', columntitle: '交易合约', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21914, tablekey: 'table_pcweb_futures_report', columnfield: 'buyorsell', columntitle: '持仓方向', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'buyorsell', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21915, tablekey: 'table_pcweb_futures_report', columnfield: 'oriholdqty', columntitle: '期初持仓量', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'oriholdqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21916, tablekey: 'table_pcweb_futures_report', columnfield: 'oriopenamount', columntitle: '期初开仓额', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'oriopenamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21917, tablekey: 'table_pcweb_futures_report', columnfield: 'oriholdamount', columntitle: '期初持仓额', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'oriholdamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21918, tablekey: 'table_pcweb_futures_report', columnfield: 'todayopenqty', columntitle: '今开仓量', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todayopenqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21919, tablekey: 'table_pcweb_futures_report', columnfield: 'todayopenamount', columntitle: '今开仓额', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todayopenamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21920, tablekey: 'table_pcweb_futures_report', columnfield: 'auditname', columntitle: '开仓均价', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'hedgeplanstatus', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21921, tablekey: 'table_pcweb_futures_report', columnfield: 'todaycloseqty', columntitle: '今平仓量', columnwidth: '0', orderindex: 120, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todaycloseqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21922, tablekey: 'table_pcweb_futures_report', columnfield: 'todaycloseamount', columntitle: '今平仓额', columnwidth: '0', orderindex: 130, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todaycloseamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21923, tablekey: 'table_pcweb_futures_report', columnfield: 'auditname', columntitle: '平仓均价', columnwidth: '0', orderindex: 140, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'hedgeplanstatus', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21924, tablekey: 'table_pcweb_futures_report', columnfield: 'holdqty', columntitle: '期末持仓量', columnwidth: '0', orderindex: 150, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'holdqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21925, tablekey: 'table_pcweb_futures_report', columnfield: 'openamount', columntitle: '期末开仓额', columnwidth: '0', orderindex: 160, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'openamount', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_spot_report', tabletype: 2, tablename: '报表-现货报表', tabelmenu: '', remark: 'web端-报表-现货报表', columns: [ { autoid: 21935, tablekey: 'table_pcweb_spot_report', columnfield: 'areauserid', columntitle: '交易用户', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'areauserid', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21936, tablekey: 'table_pcweb_spot_report', columnfield: 'currencyname', columntitle: '结算币种', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'currencyname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21937, tablekey: 'table_pcweb_spot_report', columnfield: 'deliverygoodsname', columntitle: '现货品种', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverygoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21938, tablekey: 'table_pcweb_spot_report', columnfield: 'oriqty', columntitle: '期初量', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todaybuyqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21939, tablekey: 'table_pcweb_spot_report', columnfield: 'oriamount', columntitle: '期初额', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'oriamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21940, tablekey: 'table_pcweb_spot_report', columnfield: 'oriaverageprice', columntitle: '期初均价', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'oriaverageprice', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21941, tablekey: 'table_pcweb_spot_report', columnfield: 'curamount', columntitle: '期末额', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'curamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21942, tablekey: 'table_pcweb_spot_report', columnfield: 'oriaverageprice', columntitle: '期初均价', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'oriaverageprice', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21943, tablekey: 'table_pcweb_spot_report', columnfield: 'todaybuyqty', columntitle: '今采购量', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todaybuyqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21944, tablekey: 'table_pcweb_spot_report', columnfield: 'todaybuyamount', columntitle: '今采购额', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todaybuyamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21945, tablekey: 'table_pcweb_spot_report', columnfield: 'todaybuyaverageprice', columntitle: '采购均价', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todaybuyaverageprice', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21946, tablekey: 'table_pcweb_spot_report', columnfield: 'todaysellqty', columntitle: '今销售量', columnwidth: '0', orderindex: 120, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todaysellqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21947, tablekey: 'table_pcweb_spot_report', columnfield: 'todaysellamount', columntitle: '今销售额', columnwidth: '0', orderindex: 130, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todaysellamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21948, tablekey: 'table_pcweb_spot_report', columnfield: 'todaysellaverageprice', columntitle: '销售均价', columnwidth: '0', orderindex: 140, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todaysellaverageprice', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21949, tablekey: 'table_pcweb_spot_report', columnfield: 'curqty', columntitle: '期末量', columnwidth: '0', orderindex: 150, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'curqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21950, tablekey: 'table_pcweb_spot_report', columnfield: 'curamount', columntitle: '期末额', columnwidth: '0', orderindex: 160, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'curamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21951, tablekey: 'table_pcweb_spot_report', columnfield: 'curaverageprice', columntitle: '期末均价', columnwidth: '0', orderindex: 170, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'curaverageprice', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21952, tablekey: 'table_pcweb_spot_report', columnfield: 'actualpl', columntitle: '现货损益', columnwidth: '0', orderindex: 180, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'actualpl', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21953, tablekey: 'table_pcweb_spot_report', columnfield: 'curspotprice', columntitle: '最新价', columnwidth: '0', orderindex: 190, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'curspotprice', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21954, tablekey: 'table_pcweb_spot_report', columnfield: 'curmarketvalue', columntitle: '期末市值', columnwidth: '0', orderindex: 200, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'curmarketvalue', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21955, tablekey: 'table_pcweb_spot_report', columnfield: 'floatpl', columntitle: '浮动损益', columnwidth: '0', orderindex: 210, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'floatpl', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_finance_report', tabletype: 2, tablename: '报表-财务报表', tabelmenu: '', remark: 'web端-报表-财务报表', columns: [ { autoid: 21956, tablekey: 'table_pcweb_finance_report', columnfield: 'areauserid', columntitle: '交易用户', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'areauserid', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21957, tablekey: 'table_pcweb_finance_report', columnfield: 'currencyname', columntitle: '结算币种', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'currencyname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21958, tablekey: 'table_pcweb_finance_report', columnfield: 'buytodaysettleamount', columntitle: '今付货款额', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'buytodaysettleamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21959, tablekey: 'table_pcweb_finance_report', columnfield: 'buytodayrefundamount', columntitle: '今收退款额', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'buytodayrefundamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21960, tablekey: 'table_pcweb_finance_report', columnfield: 'buyprepaidamount', columntitle: '预付货款额', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'buyprepaidamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21961, tablekey: 'table_pcweb_finance_report', columnfield: 'buyunpaidamount', columntitle: '应付货款额', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'buyunpaidamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21962, tablekey: 'table_pcweb_finance_report', columnfield: 'buytodayinvoiceamount', columntitle: '今收票额', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'buytodayinvoiceamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21963, tablekey: 'table_pcweb_finance_report', columnfield: 'buypreinvoicedamount', columntitle: '预收票额', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'buypreinvoicedamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21964, tablekey: 'table_pcweb_finance_report', columnfield: 'buyuninvoicedamount', columntitle: '应收票额', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'buyuninvoicedamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21965, tablekey: 'table_pcweb_finance_report', columnfield: 'selltodaysettleamount', columntitle: '今收货款额', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'selltodaysettleamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21966, tablekey: 'table_pcweb_finance_report', columnfield: 'buyunpaidamount', columntitle: '今付退款额', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'buyunpaidamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21967, tablekey: 'table_pcweb_finance_report', columnfield: 'sellprepaidamount', columntitle: '预收货款额', columnwidth: '0', orderindex: 120, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'sellprepaidamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21968, tablekey: 'table_pcweb_finance_report', columnfield: 'sellunpaidamount', columntitle: '应收货款额', columnwidth: '0', orderindex: 130, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'sellunpaidamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21969, tablekey: 'table_pcweb_finance_report', columnfield: 'selltodayinvoiceamount', columntitle: '今开票额', columnwidth: '0', orderindex: 140, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'selltodayinvoiceamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21970, tablekey: 'table_pcweb_finance_report', columnfield: 'sellpreinvoicedamount', columntitle: '预开票额', columnwidth: '0', orderindex: 150, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'sellpreinvoicedamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21971, tablekey: 'table_pcweb_finance_report', columnfield: 'selluninvoicedamount', columntitle: '应开票额', columnwidth: '0', orderindex: 160, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'selluninvoicedamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21972, tablekey: 'table_pcweb_finance_report', columnfield: 'todayreceivesum', columntitle: '今收款合计', columnwidth: '0', orderindex: 170, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todayreceivesum', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21973, tablekey: 'table_pcweb_finance_report', columnfield: 'todaypaysum', columntitle: '今付款合计', columnwidth: '0', orderindex: 180, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todaypaysum', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_warehouse_category_report', tabletype: 2, tablename: '报表-库存报表', tabelmenu: '', remark: 'web端-报表-库存报表(品类)', columns: [ { autoid: 21974, tablekey: 'table_pcweb_warehouse_category_report', columnfield: 'deliverygoodsname', columntitle: '现货品种', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverygoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21975, tablekey: 'table_pcweb_warehouse_category_report', columnfield: 'wrstandardname', columntitle: '现货品类', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'wrstandardname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21976, tablekey: 'table_pcweb_warehouse_category_report', columnfield: 'oristock', columntitle: '期初库存量', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'oristock', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21977, tablekey: 'table_pcweb_warehouse_category_report', columnfield: 'todaybuyinqty', columntitle: '采购入库量', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todaybuyinqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21978, tablekey: 'table_pcweb_warehouse_category_report', columnfield: 'todayselloutqty', columntitle: '销售出库量', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todayselloutqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21979, tablekey: 'table_pcweb_warehouse_category_report', columnfield: 'todayproduceinqty', columntitle: '内部入库量', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todayproduceinqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21980, tablekey: 'table_pcweb_warehouse_category_report', columnfield: 'todayproduceoutqty', columntitle: '内部出库量', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todayproduceoutqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21981, tablekey: 'table_pcweb_warehouse_category_report', columnfield: 'curstock', columntitle: '期末库存量', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'curstock', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21982, tablekey: 'table_pcweb_warehouse_category_report', columnfield: 'diffqty', columntitle: '库存变化量', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'diffqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21983, tablekey: 'table_pcweb_warehouse_category_report', columnfield: 'unbuyinqty', columntitle: '采购未入库量', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'unbuyinqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21984, tablekey: 'table_pcweb_warehouse_category_report', columnfield: 'unselloutqty', columntitle: '销售未出库量', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'unselloutqty', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_warehouse_report', tabletype: 2, tablename: '报表-库存报表', tabelmenu: '', remark: 'web端-报表-库存报表(仓库)', columns: [ { autoid: 21985, tablekey: 'table_pcweb_warehouse_report', columnfield: 'warehousename', columntitle: '仓库', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'warehousename', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21986, tablekey: 'table_pcweb_warehouse_report', columnfield: 'deliverygoodsname', columntitle: '现货品种', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'deliverygoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21987, tablekey: 'table_pcweb_warehouse_report', columnfield: 'wrstandardname', columntitle: '现货品类', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'wrstandardname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21988, tablekey: 'table_pcweb_warehouse_report', columnfield: 'oristock', columntitle: '期初库存量', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'oristock', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21989, tablekey: 'table_pcweb_warehouse_report', columnfield: 'todaybuyinqty', columntitle: '采购入库量', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todaybuyinqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21990, tablekey: 'table_pcweb_warehouse_report', columnfield: 'todayselloutqty', columntitle: '销售出库量', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todayselloutqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21991, tablekey: 'table_pcweb_warehouse_report', columnfield: 'todayproduceinqty', columntitle: '内部入库量', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todayproduceinqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21992, tablekey: 'table_pcweb_warehouse_report', columnfield: 'todayproduceoutqty', columntitle: '内部出库量', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'todayproduceoutqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21993, tablekey: 'table_pcweb_warehouse_report', columnfield: 'curstock', columntitle: '期末库存量', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'curstock', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21994, tablekey: 'table_pcweb_warehouse_report', columnfield: 'diffqty', columntitle: '库存变化量', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'diffqty', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_aggregate_profit_and_loss', tabletype: 2, tablename: '报表-汇总损益报表', tabelmenu: '', remark: 'web端-报表-汇总损益报表', columns: [ { autoid: 21997, tablekey: 'table_pcweb_aggregate_profit_and_loss', columnfield: 'spotactualpl', columntitle: '现货损益', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'spotactualpl', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21998, tablekey: 'table_pcweb_aggregate_profit_and_loss', columnfield: 'spotfloatpl', columntitle: '现货浮动损益', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'spotfloatpl', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21999, tablekey: 'table_pcweb_aggregate_profit_and_loss', columnfield: 'futureactualpl', columntitle: '期货损益', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'futureactualpl', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22000, tablekey: 'table_pcweb_aggregate_profit_and_loss', columnfield: 'sumactualpl', columntitle: '实际损益', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'sumactualpl', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22001, tablekey: 'table_pcweb_aggregate_profit_and_loss', columnfield: 'sumpl', columntitle: '汇总损益', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'sumpl', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21995, tablekey: 'table_pcweb_aggregate_profit_and_loss', columnfield: 'currencyname', columntitle: '结算币种', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'currencyname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 21996, tablekey: 'table_pcweb_aggregate_profit_and_loss', columnfield: 'accountname', columntitle: '交易用户', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'accountname', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_qhj_recharge_review', tabletype: 2, tablename: '铂金宝-充值提现审核-充值审核', tabelmenu: '', remark: 'web端-铂金宝-充值提现审核-充值审核', columns: [ { autoid: 22002, tablekey: 'table_pcweb_qhj_recharge_review', columnfield: 'accountcode', columntitle: '账号', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'accountcode', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22003, tablekey: 'table_pcweb_qhj_recharge_review', columnfield: 'accountname', columntitle: '名称', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'accountname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22004, tablekey: 'table_pcweb_qhj_recharge_review', columnfield: 'userinfotype', columntitle: '账户类型', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22005, tablekey: 'table_pcweb_qhj_recharge_review', columnfield: 'amount', columntitle: '充值金额', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'amount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22006, tablekey: 'table_pcweb_qhj_recharge_review', columnfield: 'certificatephotourl', columntitle: '凭证', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'certificatephotourl', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22007, tablekey: 'table_pcweb_qhj_recharge_review', columnfield: 'updatetime', columntitle: '申请时间', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'updatetime', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_qhj_withdrawal_review', tabletype: 2, tablename: '铂金宝-充值提现审核-提现审核', tabelmenu: '', remark: 'web端-铂金宝-充值提现审核-提现审核', columns: [ { autoid: 22008, tablekey: 'table_pcweb_qhj_withdrawal_review', columnfield: 'accountcode', columntitle: '账号', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'accountcode', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22009, tablekey: 'table_pcweb_qhj_withdrawal_review', columnfield: 'accountname', columntitle: '名称', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'accountname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22010, tablekey: 'table_pcweb_qhj_withdrawal_review', columnfield: 'userinfotype', columntitle: '账户类型', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22011, tablekey: 'table_pcweb_qhj_withdrawal_review', columnfield: 'amount', columntitle: '提现金额', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'amount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22012, tablekey: 'table_pcweb_qhj_withdrawal_review', columnfield: 'bankid', columntitle: '提现银行', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'bankid', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22013, tablekey: 'table_pcweb_qhj_withdrawal_review', columnfield: 'bankaccountno', columntitle: '银行卡号', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'bankaccountno', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22014, tablekey: 'table_pcweb_qhj_withdrawal_review', columnfield: 'branchbankname', columntitle: '支行名称', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'branchbankname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22015, tablekey: 'table_pcweb_qhj_withdrawal_review', columnfield: 'bankaccountname', columntitle: '姓名', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'bankaccountname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22016, tablekey: 'table_pcweb_qhj_withdrawal_review', columnfield: 'updatetime', columntitle: '申请时间', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'updatetime', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_qhj_pickup_query', tabletype: 2, tablename: '铂金宝-提货查询', tabelmenu: '', remark: 'web端-铂金宝-提货查询', columns: [ { autoid: 22017, tablekey: 'table_pcweb_qhj_pickup_query', columnfield: 'accountcode', columntitle: '账号', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'accountcode', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22018, tablekey: 'table_pcweb_qhj_pickup_query', columnfield: 'username', columntitle: '名称', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'username', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22019, tablekey: 'table_pcweb_qhj_pickup_query', columnfield: 'userinfotype', columntitle: '账户类型', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22020, tablekey: 'table_pcweb_qhj_pickup_query', columnfield: 'pickupgoodsname', columntitle: '提货商品', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pickupgoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22021, tablekey: 'table_pcweb_qhj_pickup_query', columnfield: 'pickupgoodsqty', columntitle: '提货数量', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pickupgoodsqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22022, tablekey: 'table_pcweb_qhj_pickup_query', columnfield: 'goodsname', columntitle: '交易商品', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22023, tablekey: 'table_pcweb_qhj_pickup_query', columnfield: 'qty', columntitle: '商品数量', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'qty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22024, tablekey: 'table_pcweb_qhj_pickup_query', columnfield: 'takemode', columntitle: '收货方式', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'takemode', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22025, tablekey: 'table_pcweb_qhj_pickup_query', columnfield: 'recivername', columntitle: '提货/收货人', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'recivername', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22026, tablekey: 'table_pcweb_qhj_pickup_query', columnfield: 'address', columntitle: '提货/收货地址', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'address', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_qhj_fixed_investment_price_query', tabletype: 2, tablename: '铂金宝-定投价查询', tabelmenu: '', remark: 'web端-铂金宝-定投价查询', columns: [ { autoid: 22027, tablekey: 'table_pcweb_qhj_fixed_investment_price_query', columnfield: 'goodsid', columntitle: '商品', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodsid', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22028, tablekey: 'table_pcweb_qhj_fixed_investment_price_query', columnfield: 'tradedate', columntitle: '交易日', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'tradedate', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22029, tablekey: 'table_pcweb_qhj_fixed_investment_price_query', columnfield: 'reckonprice', columntitle: '定投价', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'reckonprice', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_qhj_fixed_investment_plan_query', tabletype: 2, tablename: '铂金宝-定投查询-定投计划查询', tabelmenu: '', remark: 'web端-铂金宝-定投查询-定投计划查询', columns: [ { autoid: 22030, tablekey: 'table_pcweb_qhj_fixed_investment_plan_query', columnfield: 'accountid', columntitle: '账号', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'accountid', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22031, tablekey: 'table_pcweb_qhj_fixed_investment_plan_query', columnfield: 'accountname', columntitle: '名称', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'accountname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22032, tablekey: 'table_pcweb_qhj_fixed_investment_plan_query', columnfield: 'userinfotype', columntitle: '账户类型', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22033, tablekey: 'table_pcweb_qhj_fixed_investment_plan_query', columnfield: 'goodsname', columntitle: '定投商品', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22034, tablekey: 'table_pcweb_qhj_fixed_investment_plan_query', columnfield: 'regularlymode', columntitle: '定投方式', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'regularlymode', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22035, tablekey: 'table_pcweb_qhj_fixed_investment_plan_query', columnfield: 'regularlymodevalue', columntitle: '定投金额/数量', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'regularlymodevalue', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22036, tablekey: 'table_pcweb_qhj_fixed_investment_plan_query', columnfield: 'regularlycycle', columntitle: '定投频率', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'regularlycycle', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22037, tablekey: 'table_pcweb_qhj_fixed_investment_plan_query', columnfield: 'triggertotalamount', columntitle: '已定投金额', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'triggertotalamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22038, tablekey: 'table_pcweb_qhj_fixed_investment_plan_query', columnfield: 'triggertotalqty', columntitle: '已定投数量', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'triggertotalqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22039, tablekey: 'table_pcweb_qhj_fixed_investment_plan_query', columnfield: 'triggersuccesstimes', columntitle: '已定投期数', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'triggersuccesstimes', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22040, tablekey: 'table_pcweb_qhj_fixed_investment_plan_query', columnfield: 'nexttriggerdate', columntitle: '计划开始时间', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'nexttriggerdate', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22041, tablekey: 'table_pcweb_qhj_fixed_investment_plan_query', columnfield: 'regularlystrategystatus', columntitle: '状态', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'regularlystrategystatus', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_qhj_fixed_investment_flow_query', tabletype: 2, tablename: '铂金宝-定投查询-定投流水查询', tabelmenu: '', remark: 'web端-铂金宝-定投查询-定投流水查询', columns: [ { autoid: 22042, tablekey: 'table_pcweb_qhj_fixed_investment_flow_query', columnfield: 'accountname', columntitle: '账号', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'accountname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22043, tablekey: 'table_pcweb_qhj_fixed_investment_flow_query', columnfield: 'goodsname', columntitle: '定投商品', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22044, tablekey: 'table_pcweb_qhj_fixed_investment_flow_query', columnfield: 'regularlymodevalue', columntitle: '定投金额', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22045, tablekey: 'table_pcweb_qhj_fixed_investment_flow_query', columnfield: 'regularlymodevalue', columntitle: '定投数量', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'pickupgoodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22046, tablekey: 'table_pcweb_qhj_fixed_investment_flow_query', columnfield: 'triggertime', columntitle: '定投时间', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'triggertime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22047, tablekey: 'table_pcweb_qhj_fixed_investment_flow_query', columnfield: 'triggerstatus', columntitle: '执行结果', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'triggerstatus', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_qhj_fixed_financing_information', tabletype: 2, tablename: '铂金宝-融资信息', tabelmenu: '', remark: 'web端-铂金宝-融资信息', columns: [ { autoid: 22048, tablekey: 'table_pcweb_qhj_fixed_financing_information', columnfield: 'userid', columntitle: '账号', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'accountname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22049, tablekey: 'table_pcweb_qhj_fixed_financing_information', columnfield: 'username', columntitle: '名称', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22050, tablekey: 'table_pcweb_qhj_fixed_financing_information', columnfield: 'regularlymodevalue', columntitle: '账户类型', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22051, tablekey: 'table_pcweb_qhj_fixed_financing_information', columnfield: 'goodsname', columntitle: '商品', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'goodsname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22052, tablekey: 'table_pcweb_qhj_fixed_financing_information', columnfield: 'tradeprice', columntitle: '价格', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'tradeprice', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22053, tablekey: 'table_pcweb_qhj_fixed_financing_information', columnfield: 'wrqty', columntitle: '数量', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'wrqty', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22054, tablekey: 'table_pcweb_qhj_fixed_financing_information', columnfield: 'lenderamount', columntitle: '金额', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'lenderamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22055, tablekey: 'table_pcweb_qhj_fixed_financing_information', columnfield: 'payamount', columntitle: '已付款', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'payamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22056, tablekey: 'table_pcweb_qhj_fixed_financing_information', columnfield: 'remainamount', columntitle: '融资额', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'remainamount', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22057, tablekey: 'table_pcweb_qhj_fixed_financing_information', columnfield: 'totalinterest', columntitle: '利息', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'totalinterest', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22058, tablekey: 'table_pcweb_qhj_fixed_financing_information', columnfield: 'contractconfirmtime', columntitle: '融资时间', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contractconfirmtime', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22059, tablekey: 'table_pcweb_qhj_fixed_financing_information', columnfield: 'scfcontracttype', columntitle: '状态', columnwidth: '0', orderindex: 120, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'scfcontracttype', needsummary: 0, summarytype: 0, groupname: '' } ] }, { tablekey: 'table_pcweb_qhj_customer_info', tabletype: 2, tablename: '铂金宝-客户资料', tabelmenu: '', remark: 'web端-铂金宝-客户资料', columns: [ { autoid: 22060, tablekey: 'table_pcweb_qhj_customer_info', columnfield: 'userid', columntitle: '登录账号', columnwidth: '0', orderindex: 10, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userid', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22061, tablekey: 'table_pcweb_qhj_customer_info', columnfield: 'parentusername', columntitle: '所属', columnwidth: '0', orderindex: 20, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'parentusername', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22062, tablekey: 'table_pcweb_qhj_customer_info', columnfield: 'status', columntitle: '状态', columnwidth: '0', orderindex: 30, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'status', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22063, tablekey: 'table_pcweb_qhj_customer_info', columnfield: 'userinfotype', columntitle: '客户类型', columnwidth: '0', orderindex: 40, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'userinfotype', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22064, tablekey: 'table_pcweb_qhj_customer_info', columnfield: 'nickname', columntitle: '客户简称', columnwidth: '0', orderindex: 50, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'nickname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22065, tablekey: 'table_pcweb_qhj_customer_info', columnfield: 'customername', columntitle: '客户名称', columnwidth: '0', orderindex: 60, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'customername', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22066, tablekey: 'table_pcweb_qhj_customer_info', columnfield: 'cardtypename', columntitle: '证件类型', columnwidth: '0', orderindex: 70, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'cardtypename', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22067, tablekey: 'table_pcweb_qhj_customer_info', columnfield: 'cardnum', columntitle: '证件号码', columnwidth: '0', orderindex: 80, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'cardnum', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22068, tablekey: 'table_pcweb_qhj_customer_info', columnfield: 'contactname', columntitle: '联系人', columnwidth: '0', orderindex: 90, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'contactname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22069, tablekey: 'table_pcweb_qhj_customer_info', columnfield: 'mobile', columntitle: '手机号码', columnwidth: '0', orderindex: 100, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'mobile', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22070, tablekey: 'table_pcweb_qhj_customer_info', columnfield: 'email', columntitle: '邮箱', columnwidth: '0', orderindex: 110, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'email', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22071, tablekey: 'table_pcweb_qhj_customer_info', columnfield: 'legalpersonname', columntitle: '法定代表人', columnwidth: '0', orderindex: 120, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'legalpersonname', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22072, tablekey: 'table_pcweb_qhj_customer_info', columnfield: 'taxpayernum', columntitle: '纳税人识别号', columnwidth: '0', orderindex: 130, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'taxpayernum', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22073, tablekey: 'table_pcweb_qhj_customer_info', columnfield: 'cardbackphotourl', columntitle: '证件照', columnwidth: '0', orderindex: 140, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'cardbackphotourl', needsummary: 0, summarytype: 0, groupname: '' }, { autoid: 22074, tablekey: 'table_pcweb_qhj_customer_info', columnfield: 'address', columntitle: '地址', columnwidth: '0', orderindex: 150, isshow: 1, aligntype: 1, formattertype: '', formatterstring: '', remark: 'address', needsummary: 0, summarytype: 0, groupname: '' } ] } ]; const fs = require('fs'); // function handleTable() { const result = {}; table.forEach((el) => { const { tablekey, tablename } = el; result[tablekey] = `string; // ${tablename}`; }); let newValue = ` interface CustomRender { customRender: string; } // 动态表头类型 export interface ColumnType { key: string; dataIndex: string; title: string; width?: number; align: string; // AlignType 对齐方式 - 1:居中对齐 2:左对齐 3:右对齐 filteredValue?: string | null; slots?: CustomRender; onFilter?: Function; sorter?: Function; render?: Function; customRender?: Function; } export interface TableKey ${JSON.stringify(result).replace(/\"/g, '').replace(/,/g, '\n').replace(/;/g, ',')}`; const path = '../src/common/methods/table/interface.ts'; fs.unlink(path, (err) => { !err && console.log('文件删除成功!'); }); fs.writeFile(path, newValue, { flag: 'a' }, (err) => { !err && console.log('写入文件成功!'); }); } handleTable();