-- 调拨申请单到预留供应模型 字段映射
DELETE FROM t_sbs_billfieldmap_e WHERE FENTRYID = 1903032678525978624;
INSERT INTO t_sbs_billfieldmap_e(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('org',' ',1903032678517588992,'库存组织',' ','物料明细.调入组织','0',1903032678525978624,1,'billentry.inorg',' ');
DELETE FROM t_sbs_billfieldmap_e WHERE FENTRYID = 1903032678525978625;
INSERT INTO t_sbs_billfieldmap_e(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('materiel',' ',1903032678517588992,'物料',' ','物料明细.物料编码.物料编码','0',1903032678525978625,2,'billentry.material.masterid',' ');
DELETE FROM t_sbs_billfieldmap_e WHERE FENTRYID = 1903032678525978626;
INSERT INTO t_sbs_billfieldmap_e(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('auxpty',' ',1903032678517588992,'辅助属性',' ','物料明细.辅助属性','0',1903032678525978626,3,'billentry.auxpty',' ');
DELETE FROM t_sbs_billfieldmap_e WHERE FENTRYID = 1903032678525978627;
INSERT INTO t_sbs_billfieldmap_e(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('project',' ',1903032678517588992,'项目',' ','物料明细.调入项目号','0',1903032678525978627,4,'billentry.inproject',' ');
DELETE FROM t_sbs_billfieldmap_e WHERE FENTRYID = 1903032678525978628;
INSERT INTO t_sbs_billfieldmap_e(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('configuredcode',' ',1903032678517588992,'配置号',' ','物料明细.配置号','0',1903032678525978628,5,'billentry.configuredcode',' ');
DELETE FROM t_sbs_billfieldmap_e WHERE FENTRYID = 1903032678525978629;
INSERT INTO t_sbs_billfieldmap_e(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('baseunit',' ',1903032678517588992,'基本单位',' ','物料明细.基本单位','0',1903032678525978629,6,'billentry.baseunit',' ');
DELETE FROM t_sbs_billfieldmap_e WHERE FENTRYID = 1903032678525978630;
INSERT INTO t_sbs_billfieldmap_e(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('unit',' ',1903032678517588992,'计量单位',' ','物料明细.计量单位','0',1903032678525978630,7,'billentry.unit',' ');
DELETE FROM t_sbs_billfieldmap_e WHERE FENTRYID = 1903032678525978631;
INSERT INTO t_sbs_billfieldmap_e(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('baseqty',' ',1903032678517588992,'基本数量','{"expression":"baseqty -  orderbaseqty ","exprTran":"基本数量 -  已订货基本数量 ","description":{"zh_CN":""},"exprDesc":"基本数量 -  已订货基本数量 ","localeExprTran":{"zh_CN":"基本数量 -  已订货基本数量 "}}','物料明细.未调入基本数量','0',1903032678525978631,8,'billentry.remtrsinbaseqty',' ');
DELETE FROM t_sbs_billfieldmap_e WHERE FENTRYID = 1903032678525978632;
INSERT INTO t_sbs_billfieldmap_e(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('qty',' ',1903032678517588992,'数量','{"expression":"qty -  orderqty ","exprTran":"核准数量 -  已订货数量 ","description":{"zh_CN":""},"exprDesc":"核准数量 -  已订货数量 ","localeExprTran":{"zh_CN":"核准数量 -  已订货数量 "}}','物料明细.未调入数量','0',1903032678525978632,9,'billentry.remtrsinqty',' ');
DELETE FROM t_sbs_billfieldmap_e WHERE FENTRYID = 1903032678525978633;
INSERT INTO t_sbs_billfieldmap_e(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('billnum',' ',1903032678517588992,'单据编号',' ','单据编号','0',1903032678525978633,10,'billno',' ');
DELETE FROM t_sbs_billfieldmap_e WHERE FENTRYID = 1903032678525978634;
INSERT INTO t_sbs_billfieldmap_e(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('bizdate',' ',1903032678517588992,'业务日期',' ','业务日期','0',1903032678525978634,11,'biztime',' ');
DELETE FROM t_sbs_billfieldmap_e WHERE FENTRYID = 1903032678525978635;
INSERT INTO t_sbs_billfieldmap_e(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('billstatus',' ',1903032678517588992,'单据状态',' ','单据状态','0',1903032678525978635,12,'billstatus',' ');
DELETE FROM t_sbs_billfieldmap_e WHERE FENTRYID = 1903032678525978636;
INSERT INTO t_sbs_billfieldmap_e(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('billentry',' ',1903032678517588992,'单据体标识',' ','物料明细','0',1903032678525978636,13,'billentry',' ');
DELETE FROM t_sbs_billfieldmap_e WHERE FENTRYID = 1903696732471031808;
INSERT INTO t_sbs_billfieldmap_e(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('warehouse',' ',1903032678517588992,'仓库',' ','物料明细.调入仓库','0',1903696732471031808,14,'billentry.inwarehouse',' ');
DELETE FROM t_sbs_billfieldmap_e WHERE FENTRYID = 1903696732471031809;
INSERT INTO t_sbs_billfieldmap_e(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('location',' ',1903032678517588992,'仓位',' ','物料明细.调入仓位','0',1903696732471031809,15,'billentry.inlocation',' ');
DELETE FROM t_sbs_billfieldmap_e WHERE FENTRYID = 1903696732471031810;
INSERT INTO t_sbs_billfieldmap_e(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('owner_type',' ',1903032678517588992,'货主类型',' ','物料明细.入库货主类型','0',1903696732471031810,16,'billentry.inownertype',' ');
DELETE FROM t_sbs_billfieldmap_e WHERE FENTRYID = 1903696732471031811;
INSERT INTO t_sbs_billfieldmap_e(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('owner',' ',1903032678517588992,'货主',' ','物料明细.入库货主','0',1903696732471031811,17,'billentry.inowner',' ');
DELETE FROM t_sbs_billfieldmap_e WHERE FENTRYID = 1903696732471031812;
INSERT INTO t_sbs_billfieldmap_e(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('keeper_type',' ',1903032678517588992,'保管者类型',' ','物料明细.入库保管者类型','0',1903696732471031812,18,'billentry.inkeepertype',' ');
DELETE FROM t_sbs_billfieldmap_e WHERE FENTRYID = 1903696732471031813;
INSERT INTO t_sbs_billfieldmap_e(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('keeper',' ',1903032678517588992,'保管者',' ','物料明细.入库保管者','0',1903696732471031813,19,'billentry.inkeeper',' ');
DELETE FROM t_sbs_billfieldmap_e WHERE FENTRYID = 1903696732471031814;
INSERT INTO t_sbs_billfieldmap_e(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('invstatus',' ',1903032678517588992,'库存状态',' ','物料明细.入库库存状态','0',1903696732471031814,20,'billentry.ininvstatus',' ');
DELETE FROM t_sbs_billfieldmap_e WHERE FENTRYID = 1903696732471031815;
INSERT INTO t_sbs_billfieldmap_e(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('invtype',' ',1903032678517588992,'库存类型',' ','物料明细.入库库存类型','0',1903696732471031815,21,'billentry.ininvtype',' ');
DELETE FROM t_sbs_billfieldmap WHERE FID = 1903032678517588992;
INSERT INTO t_sbs_billfieldmap(FID,FTARGETOBJ,FMODIFYDATE,FSOURCEBILL,FMODIFIERID,FCREATEDATE,FBIZAPPID,FISENABLE,FCREATERID,FNUMBER,FISSYSINIT) VALUES (1903032678517588992,'msmod_std_inv_field',{ts'2024-01-01  00:00:00'},'im_transapply',1,{ts'2024-01-01  00:00:00'},'0ZACM0PE=J24','1',1,'msmod_datasource_im_transapply','1');
DELETE FROM t_sbs_billfieldmap_l WHERE FID = 1903032678517588992 and FLOCALEID = 'zh_CN';
INSERT INTO t_sbs_billfieldmap_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1903032678517588992,'3ZR8GKCTJK=E','zh_CN','预留供应模型_调拨申请单');
DELETE FROM t_sbs_billfieldmap_l WHERE FID = 1903032678517588992 and FLOCALEID = 'zh_TW';
INSERT INTO t_sbs_billfieldmap_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1903032678517588992,'3ZR8GKCTJK=F','zh_TW','預留供應模型_調撥申請單');
DELETE FROM t_sbs_billfieldmap_l WHERE FID = 1903032678517588992 and FLOCALEID = 'en_US';
INSERT INTO t_sbs_billfieldmap_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1903032678517588992,'3ZRNZZ8QS0A0','en_US','^en_US预留供应模型_调拨申请单^');
