insert
into
custom_list_config (custom_field ,list_code )
values ('[{
{"prop":"id","index":0,"label":"主键","isChecked":true},
{"prop":"domainId","index":1,"label":"领域id","isChecked":true},
{"prop":"tenantId","index":2,"label":"租户id","isChecked":true},
{"prop":"receiptNoticeNo","index":3,"label":"收货通知单编号","isChecked":true},
{"prop":"receiptNoticeDate","index":4,"label":"收货日期","isChecked":true},
{"prop":"supplierCompanyId","index":5,"label":"供应商公司ID","isChecked":true},
{"prop":"supplierCompanyName","index":6,"label":"供应商公司名称","isChecked":true},
{"prop":"ourCompanyId","index":7,"label":"本方公司ID","isChecked":true},
{"prop":"ourCompanyName","index":8,"label":"本方公司名称","isChecked":true},
{"prop":"customerCompanyId","index":9,"label":"客户公司编号","isChecked":true},
{"prop":"customerCompanyName","index":10,"label":"客户公司名称","isChecked":true},
{"prop":"purchaseOrderId","index":11,"label":"采购订单ID","isChecked":true},
{"prop":"purchaseOrderNo","index":12,"label":"采购订单编号","isChecked":true},
{"prop":"salesOrderId","index":13,"label":"销售订单ID","isChecked":true},
{"prop":"salesOrderNo","index":14,"label":"销售订单编号","isChecked":true},
{"prop":"businessMode","index":15,"label":"业务模式","isChecked":true},
{"prop":"receiptMan","index":16,"label":"收货员","isChecked":true},
{"prop":"businessMan","index":17,"label":"业务员","isChecked":true},
{"prop":"status","index":18,"label":"状态","isChecked":true},
{"prop":"transferStatus","index":19,"label":"过户状态","isChecked":true},
{"prop":"rejectionReason","index":20,"label":"驳回原因","isChecked":true},
{"prop":"rejectionDate","index":21,"label":"驳回时间","isChecked":true},
{"prop":"rejectionId","index":22,"label":"驳回人id","isChecked":true},
{"prop":"rejectionName","index":23,"label":"驳回人","isChecked":true},
{"prop":"warehouseConfirmStatus","index":24,"label":"仓储确认状态","isChecked":true},
{"prop":"type","index":25,"label":"收货通知单类型","isChecked":true},
{"prop":"dispatchWay","index":26,"label":"提货方式","isChecked":true},
{"prop":"warehouseId","index":27,"label":"仓库ID","isChecked":true},
{"prop":"warehouseName","index":28,"label":"仓库名称","isChecked":true},
{"prop":"unionStatus","index":29,"label":"关联状态","isChecked":true},
{"prop":"cancelApprovalStatus","index":30,"label":"作废审批状态","isChecked":true},
{"prop":"cancelReason","index":31,"label":"作废原因","isChecked":true},
{"prop":"cancelDate","index":32,"label":"作废时间","isChecked":true},
{"prop":"cancelId","index":33,"label":"作废人id","isChecked":true},
{"prop":"cancelName","index":34,"label":"作废人","isChecked":true},
{"prop":"orderType","index":35,"label":"订单类型","isChecked":true},
{"prop":"outOrderType","index":36,"label":"外部单据类型","isChecked":true},
{"prop":"outOrderId","index":37,"label":"外部单据id","isChecked":true},
{"prop":"","index":38,"label":"外部单据编号","isChecked":true},
{"prop":"outOrderNo","index":39,"label":"","isChecked":true},
{"prop":"sourceOrderType","index":40,"label":"来源单据类型","isChecked":true},
{"prop":"sourceOrderNo","index":41,"label":"来源单据编号","isChecked":true},
{"prop":"sourceOrderId","index":42,"label":"来源单据id","isChecked":true},
{"prop":"backToBack","index":43,"label":"采购单上冗余","isChecked":true},
{"prop":"ownerId","index":44,"label":"","isChecked":true},
{"prop":"departRange","index":45,"label":"单据所属部门","isChecked":true},
{"prop":"remark","index":46,"label":"备注信息","isChecked":true},
{"prop":"quickEntryWarehouse","index":47,"label":"采购单上冗余快捷入库","isChecked":true},
{"prop":"projectName","index":48,"label":"工程项目名称","isChecked":true},
{"prop":"projectId","index":49,"label":"工程项目id","isChecked":true},
{"prop":"projectType","index":50,"label":"项目类型","isChecked":true},
{"prop":"feature","index":51,"label":"feature扩展字段","isChecked":true},
{"prop":"udfFields","index":52,"label":"自定义字段","isChecked":true},
{"prop":"fileKey","index":53,"label":"收货通知单文件key(未盖章)","isChecked":true},
{"prop":"sealFileKey","index":54,"label":"收货通知单文件key(盖章)","isChecked":true},
{"prop":"isFirstCreate","index":55,"label":"首次","isChecked":true},
{"prop":"attachmentOrderId","index":56,"label":"附件单id","isChecked":true},
{"prop":"stampStatus","index":57,"label":"盖章状态","isChecked":true},
{"prop":"sealApprovalStatus","index":58,"label":"印章审批状态","isChecked":true},
{"prop":"version","index":59,"label":"数据版本号","isChecked":true},
{"prop":"collaStatus","index":60,"label":"协同状态","isChecked":true},
{"prop":"deleteFlag","index":61,"label":"0有效,-1无效","isChecked":true},
{"prop":"gmtCreated","index":62,"label":"创建时间","isChecked":true},
{"prop":"gmtModified","index":63,"label":"最后修改时间","isChecked":true},
{"prop":"createdId","index":64,"label":"新增人id","isChecked":true},
{"prop":"createdName","index":65,"label":"新增人名称","isChecked":true},
{"prop":"modifiedId","index":66,"label":"修改人id","isChecked":true},
{"prop":"modifiedName","index":67,"label":"修改人名称","isChecked":true}
}]','purchase_receipt_notice_list_view_order_exportExcel')
检查一下SQL语法有没有问题