DELETE FROM t_scmc_rpt_cf WHERE FID = 1534051467978336256;
INSERT INTO t_scmc_rpt_cf(FID,FMODIFYDATE,FMODIFIER,FCREATEDATE,FTIMEOUT,FREPO,FREPORT,FSYSDATA,FCREATER,FSTATUS,FNUMBER,FNAME) VALUES (1534051467978336256,{ts'2022-10-19  00:00:00'},0,{ts'2022-10-18  00:00:00'},30,'scp_delivery_col_repo','scp_deliveryrpt','1',0,'1','scp_delivery_col_out','供应商端交货计划报表'); 

DELETE FROM t_scmc_rpt_cf WHERE FID = 1509407647114411008;
INSERT INTO t_scmc_rpt_cf(FID,FMODIFYDATE,FMODIFIER,FCREATEDATE,FTIMEOUT,FREPO,FREPORT,FSYSDATA,FCREATER,FSTATUS,FNUMBER,FNAME) VALUES (1509407647114411008,{ts'2022-10-19  00:00:00'},0,{ts'2022-09-14  00:00:00'},30,'pur_delivery_col_repo','pur_deliveryrpt','1',0,'1','pur_delivery_col_out','采购端交货计划报表'); 

DELETE FROM t_scmc_rpt_cf_l WHERE FID = 1509407647114411008 and FLOCALEID = 'zh_CN';
INSERT INTO t_scmc_rpt_cf_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1509407647114411008,'2QDEAP7UQ/TP','zh_CN','采购端交货计划报表'); 
DELETE FROM t_scmc_rpt_cf_l WHERE FID = 1509407647114411008 and FLOCALEID = 'zh_TW';
INSERT INTO t_scmc_rpt_cf_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1509407647114411008,'2QDEAP7UQ/TQ','zh_TW','采購端交貨計劃報表'); 
DELETE FROM t_scmc_rpt_cf_l WHERE FID = 1534051467978336256 and FLOCALEID = 'zh_TW';
INSERT INTO t_scmc_rpt_cf_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1534051467978336256,'2TEGXT61SW9C','zh_TW','供應商端交貨計劃報表'); 
DELETE FROM t_scmc_rpt_cf_l WHERE FID = 1534051467978336256 and FLOCALEID = 'zh_CN';
INSERT INTO t_scmc_rpt_cf_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1534051467978336256,'2TEGXT61SW9D','zh_CN','供应商端交货计划报表'); 

DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1509407647114407939;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1509407647114411008,' ','1','采购组织','purorg','1',1509407647114407939,'A',5); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1518193028429380608;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1509407647114411008,' ','0','类型','type','0',1518193028429380608,'C',9); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1509407647114407938;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1509407647114411008,' ','1','供应商','supplier','1',1509407647114407938,'A',4); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1518193028429380610;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1509407647114411008,' ','0','交货日期','deliverydate','0',1518193028429380610,'C',11); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1518193028429380611;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1509407647114411008,' ','0','承诺日期','promisedate','0',1518193028429380611,'C',12); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1518193028429380612;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1509407647114411008,' ','0','数量','qty','0',1518193028429380612,'C',13); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1509407647114407940;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1509407647114411008,' ','1','收货仓库','warehouse','1',1509407647114407940,'A',7); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1509407647114407941;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1509407647114411008,' ','1','收货组织','recorg','1',1509407647114407941,'A',6); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1519611997065431040;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1509407647114411008,' ','0','单据状态','billstatus','0',1519611997065431040,'D',14); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1519611997065431041;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1509407647114411008,' ','0','行状态','entrystatus','0',1519611997065431041,'D',15); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1519611997065431042;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1509407647114411008,' ','0','采购员','person','0',1519611997065431042,'D',16); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1519714489388594176;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1509407647114411008,' ','0','业务日期','billdate','0',1519714489388594176,'C',17); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1509407647114407942;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1509407647114411008,' ','0','物料名称','materialname','1',1509407647114407942,'A',2); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1534051467978460168;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1534051467978336256,' ','0','类型','type','0',1534051467978460168,'C',9); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1534051467978460175;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1534051467978336256,' ','0','行状态','entrystatus','0',1534051467978460175,'D',16); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1509407647114407943;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1509407647114411008,' ','0','收货地址','recaddress','1',1509407647114407943,'A',8); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1509407647114407936;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1509407647114411008,'modelnum','2','物料编码','material','1',1509407647114407936,'A',1); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1509407647114407937;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1509407647114411008,' ','2','计量单位','unit','1',1509407647114407937,'A',3); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1534051467978460176;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1534051467978336256,' ','0','采购员','person','0',1534051467978460176,'D',17); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1534051467978460169;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1534051467978336256,' ','0','数量','qty','0',1534051467978460169,'C',10); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1534051467978460170;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1534051467978336256,' ','0','承诺数量','promiseqty','0',1534051467978460170,'C',11); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1534051467978460171;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1534051467978336256,' ','0','业务日期','billdate','0',1534051467978460171,'C',12); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1534051467978460172;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1534051467978336256,' ','0','交货日期','deliverydate','0',1534051467978460172,'C',13); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1534051467978460173;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1534051467978336256,' ','0','承诺日期','promisedate','0',1534051467978460173,'C',14); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1534051467978460174;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1534051467978336256,' ','0','单据状态','billstatus','0',1534051467978460174,'C',15); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1534051467978460166;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1534051467978336256,' ','0','物料名称','materialname','1',1534051467978460166,'A',2); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1534051467978460161;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1534051467978336256,' ','2','计量单位','unit','1',1534051467978460161,'A',3); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1534051467978460162;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1534051467978336256,' ','2','销售公司','supplier','1',1534051467978460162,'A',4); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1534051467978460163;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1534051467978336256,' ','1','订货客户','purorg','1',1534051467978460163,'A',5); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1534051467978460164;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1534051467978336256,' ','1','收货仓库','warehouse','1',1534051467978460164,'A',7); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1534051467978460165;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1534051467978336256,' ','1','收货方','recorg','1',1534051467978460165,'A',6); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1534051467978460160;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1534051467978336256,'modelnum','2','物料编码','material','1',1534051467978460160,'A',1); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1534051467978460167;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1534051467978336256,' ','0','收货地址','recaddress','1',1534051467978460167,'A',8); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1534638324122360832;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1534051467978336256,' ','0','商务伙伴','bizpartner','0',1534638324122360832,'C',18); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1518193028429380609;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1509407647114411008,' ','0','承诺数量','promiseqty','0',1518193028429380609,'C',10); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1535565926488035328;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1509407647114411008,' ','0','承诺状态','promisestatus','0',1535565926488035328,'C',18); 
DELETE FROM t_scmc_rpt_cf_cols WHERE FENTRYID = 1535589471943249920;
INSERT INTO t_scmc_rpt_cf_cols(FID,FSHOWREFPROP,FSHOWPROP,FCOLNAME,FREPO_COL,FDEFSHOW,FENTRYID,FCALTYPE,FSEQ) VALUES (1534051467978336256,' ','0','承诺状态','promisestatus','0',1535589471943249920,'C',19); 



DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1509407647114407940;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2QDEAP7UQ/TF','zh_CN','收货仓库',1509407647114407940); 


DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1509407647114407941;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2QDEAP7UQ/TI','zh_CN','收货组织',1509407647114407941); 

DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1535565926488035328;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2TLQWMOGTOV8','zh_CN','承诺状态',1535565926488035328); 

DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1535589471943249920;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2TLV=73JV2DH','zh_CN','承诺状态',1535589471943249920); 

DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1509407647114407937;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2QDEAP7UQ/T7','zh_CN','计量单位',1509407647114407937); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1509407647114407938;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2QDEAP7UQ/T=','zh_CN','供应商',1509407647114407938); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1509407647114407939;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2QDEAP7UQ/TC','zh_CN','采购组织',1509407647114407939); 


DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1509407647114407942;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2QDEAP7UQ/TL','zh_CN','物料名称',1509407647114407942); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1509407647114407943;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2QDEAP7UQ/TO','zh_CN','收货地址',1509407647114407943); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1518193028429380608;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2RGHUM8FEZ+8','zh_CN','类型',1518193028429380608); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1518193028429380609;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2RGHUM8FEZ+A','zh_CN','承诺数量',1518193028429380609); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1518193028429380610;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2RGHUM8FEZ+D','zh_CN','交货日期',1518193028429380610); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1518193028429380611;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2RGHUM8FEZ+G','zh_CN','承诺日期',1518193028429380611); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1518193028429380612;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2RGHUM8FEZ+J','zh_CN','数量',1518193028429380612); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1519611997065431040;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2RN=ZM8R2XY=','zh_CN','单据状态',1519611997065431040); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1519611997065431041;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2RN=ZM8R2XYC','zh_CN','行状态',1519611997065431041); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1519611997065431042;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2RN=ZM8R2XYF','zh_CN','采购员',1519611997065431042); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1519714489388594176;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2RNT3GSHSD97','zh_CN','业务日期',1519714489388594176); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1509407647114407936;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2QDEAP7UQ/T4','zh_CN','物料编码',1509407647114407936); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1534051467978460160;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2TEGXT61SW82','zh_CN','物料编码',1534051467978460160); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1534051467978460161;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2TEGXT61SW85','zh_CN','计量单位',1534051467978460161); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1534051467978460162;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2TEGXT61SW88','zh_CN','销售公司',1534051467978460162); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1534051467978460163;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2TEGXT61SW8A','zh_CN','订货客户',1534051467978460163); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1534051467978460164;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2TEGXT61SW8D','zh_CN','收货仓库',1534051467978460164); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1534051467978460165;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2TEGXT61SW8G','zh_CN','收货方',1534051467978460165); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1534051467978460166;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2TEGXT61SW8J','zh_CN','物料名称',1534051467978460166); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1534051467978460167;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2TEGXT61SW8M','zh_CN','收货地址',1534051467978460167); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1534051467978460168;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2TEGXT61SW8P','zh_CN','类型',1534051467978460168); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1534051467978460169;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2TEGXT61SW8S','zh_CN','数量',1534051467978460169); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1534051467978460170;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2TEGXT61SW8V','zh_CN','承诺数量',1534051467978460170); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1534051467978460171;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2TEGXT61SW8Y','zh_CN','业务日期',1534051467978460171); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1534051467978460172;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2TEGXT61SW9/','zh_CN','交货日期',1534051467978460172); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1534051467978460173;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2TEGXT61SW92','zh_CN','承诺日期',1534051467978460173); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1534051467978460174;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2TEGXT61SW95','zh_CN','单据状态',1534051467978460174); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1534051467978460175;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2TEGXT61SW98','zh_CN','行状态',1534051467978460175); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1534051467978460176;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2TEGXT61SW9A','zh_CN','采购员',1534051467978460176); 
DELETE FROM t_scmc_rpt_cf_cols_l WHERE FLOCALEID = 'zh_CN' and FENTRYID = 1534638324122360832;
INSERT INTO t_scmc_rpt_cf_cols_l(FPKID,FLOCALEID,FCOLNAME,FENTRYID) VALUES ('2TH=K76QJ/=D','zh_CN','商务伙伴',1534638324122360832); 


DELETE FROM t_scmc_rpt_cf_data WHERE FENTRYID = 1534051467978460177;
INSERT INTO t_scmc_rpt_cf_data(FID,FBLOCKSTATUS,FSRCTYPE,FDATAFS,FSRCENTITY,FENTRYID,FCOLMAP,FSEQ,FDATAFS_TAG,FBLOCKDESC) VALUES (1534051467978336256,'1','A',' ','pur_deliveryschedule',1534051467978460177,1534053463871572992,1,'{"expression":"","exprTran":"单据状态 等于 已审核","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2QDMRIWKS+J6","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2QDMRIWKRZ6O","value":"C"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2QDMRIWKS+J6\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2QDMRIWKRZ6O\",\"value\":\"C\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 等于 已审核"},"exprDesc":"单据状态 等于 已审核"}',' '); 
DELETE FROM t_scmc_rpt_cf_data WHERE FENTRYID = 1509407647114407944;
INSERT INTO t_scmc_rpt_cf_data(FID,FBLOCKSTATUS,FSRCTYPE,FDATAFS,FSRCENTITY,FENTRYID,FCOLMAP,FSEQ,FDATAFS_TAG,FBLOCKDESC) VALUES (1509407647114411008,'1','A',' ','pur_deliveryschedule',1509407647114407944,1509447766957476864,1,'{"expression":"","exprTran":"单据状态 等于 已审核","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2QDMRIWKS+J6","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2QDMRIWKRZ6O","value":"C"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2QDMRIWKS+J6\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2QDMRIWKRZ6O\",\"value\":\"C\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 等于 已审核"},"exprDesc":"单据状态 等于 已审核"}',' '); 

DELETE FROM t_scmc_rpt_cf_plugin WHERE FENTRYID = 1534051467978336308;
INSERT INTO t_scmc_rpt_cf_plugin(FID,FPLUGINCLASS,FENTRYID,FSEQ,FPLUGINNAME,FPLUGINSTATUS) VALUES (1534051467978336256,'kd.scm.scp.report.delivery.ScpDeliveryRptHandle',1534051467978336308,1,'交货计划查询报表','1'); 
DELETE FROM t_scmc_rpt_cf_plugin WHERE FENTRYID = 1509425483375516672;
INSERT INTO t_scmc_rpt_cf_plugin(FID,FPLUGINCLASS,FENTRYID,FSEQ,FPLUGINNAME,FPLUGINSTATUS) VALUES (1509407647114411008,'kd.scm.pur.report.deliver.PurDeliveryRptHandle',1509425483375516672,1,'交货计划查询报表','1'); 

DELETE FROM t_scmc_rpt_cf_plugin_l WHERE FENTRYID = 1509425483375516672 AND FLOCALEID = 'zh_CN';
INSERT INTO t_scmc_rpt_cf_plugin_l(FPKID,FLOCALEID,FENTRYID,FPLUGINNAME) VALUES ('2QDHNO517=CN','zh_CN',1509425483375516672,'交货计划查询报表'); 
DELETE FROM t_scmc_rpt_cf_plugin_l WHERE FENTRYID = 1534051467978336308 AND FLOCALEID = 'zh_CN';
INSERT INTO t_scmc_rpt_cf_plugin_l(FPKID,FLOCALEID,FENTRYID,FPLUGINNAME) VALUES ('2TEGXT61UZPI','zh_CN',1534051467978336308,'交货计划查询报表'); 



DELETE FROM t_scmc_rpt_colmap WHERE FID = 1534053463871572992;
INSERT INTO t_scmc_rpt_colmap(FID,FREPORTENTITY,FMODIFYDATE,FMODIFIER,FMAPINFO,FMAPINFO_TAG,FSRCENTITY,FCREATEDATE,FSYSDATA,FCREATER,FNUMBER,FNAME) VALUES (1534053463871572992,'scp_delivery_col_repo',{ts'2022-10-20  00:00:00'},10230057,' ','{"repocol":["material","unit","supplier","purorg","warehouse","recorg","materialname","recaddress","type","qty","promiseqty","billdate","deliverydate","promisedate","billstatus","entrystatus","person","bizpartner","promisestatus"],"fullsrccol":["materialentry.material","materialentry.unit","supplier","org","materialentry.warehouse","materialentry.entryrcvorg","materialentry.materialname","materialentry.deliaddr","","materialentry.qty","materialentry.promiseqty","billdate","materialentry.deliverydate","materialentry.promisedate","billstatus","materialentry.entrystatus","person","bizpartner","materialentry.promisestatus"],"defval":["","","","","","","","","","","","","","","","","","",""],"remark":["","","","","","","","","","","","","","","","","","",""],"srccol":["material","unit","supplier","org","warehouse","entryrcvorg","materialname","deliaddr","","qty","promiseqty","billdate","deliverydate","promisedate","billstatus","entrystatus","person","bizpartner","promisestatus"]}','pur_deliveryschedule',{ts'2022-10-18  00:00:00'},'1',10230057,'scp_deliveryrpt_pur_delivery','供应商端交货计划字段-交货计划'); 
DELETE FROM t_scmc_rpt_colmap WHERE FID = 1509447766957476864;
INSERT INTO t_scmc_rpt_colmap(FID,FREPORTENTITY,FMODIFYDATE,FMODIFIER,FMAPINFO,FMAPINFO_TAG,FSRCENTITY,FCREATEDATE,FSYSDATA,FCREATER,FNUMBER,FNAME) VALUES (1509447766957476864,'pur_delivery_col_repo',{ts'2022-10-20  00:00:00'},10230057,' ','{"repocol":["material","unit","supplier","purorg","warehouse","recorg","materialname","recaddress","qty","type","promiseqty","deliverydate","promisedate","billstatus","entrystatus","person","billdate","promisestatus"],"fullsrccol":["materialentry.material.id","materialentry.unit","supplier","org","materialentry.warehouse","materialentry.entryrcvorg","materialentry.materialname","materialentry.deliaddr","materialentry.qty","","materialentry.promiseqty","materialentry.deliverydate","materialentry.promisedate","billstatus","materialentry.entrystatus","person","billdate","materialentry.promisestatus"],"defval":["","","","","","","","","","1","","","","","","","",""],"remark":["","","","","","","","","","","","","","","","","",""],"srccol":["material.id","unit","supplier","org","warehouse","entryrcvorg","materialname","deliaddr","qty","","promiseqty","deliverydate","promisedate","billstatus","entrystatus","person","billdate","promisestatus"]}','pur_deliveryschedule',{ts'2022-09-14  00:00:00'},'1',10230057,'pur_deliveryrpt_pur_delivery','采购端交货计划字段-交货计划'); 


DELETE FROM t_scmc_rpt_colmap_l WHERE FID = 1509447766957476864 AND FLOCALEID = 'zh_CN';
INSERT INTO t_scmc_rpt_colmap_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1509447766957476864,'2QDLU1+57YN2','zh_CN','采购端交货计划字段-交货计划'); 
DELETE FROM t_scmc_rpt_colmap_l WHERE FID = 1534053463871572992 AND FLOCALEID = 'zh_CN';
INSERT INTO t_scmc_rpt_colmap_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1534053463871572992,'2TEH=BDJN//W','zh_CN','供应商端交货计划字段-交货计划'); 

