EAS查询分析器插入id，fid

后台 可以使用SELECT newBosID('BosType') FROM dual 来生成，其中BosType查找方式可以通过查询分析器的fid转BosType来找到

 

 

最终如下：SELECT newBosID('584432FF') FROM dual

这里注意的是，单据头和分录都有自己的BosType

 如果想批量插入数据做测试可以现用geninsert 语句，如

geninsert select * from xxx

然后运行服务端脚本生成插入语句，让后用newsBosID('XXX')来插入，示例如下

insert into t_bc_travelaccountbillentry(FID, FSEQ, FFROM, FTO, FSTARTDATE, FENDDATE, FVEHICLE, FTAXIEXPENSE, FBUSSESEXPENSE, FHOTELEXPENSE, FOTHEREXPENSE, FAMOUNT, FBILLID, FEVENTIONSUBSIDY, FEXPENSETYPEID, FAMOUNTAPPROVED, FBUDGETAMOUNT, FBUDGETDO, FAMOUNTBALANCE, FAMOUNTUSED, FOPERATIONTYPEID, FCOSTCENTERID, FCOMPANYID, FRECEIVESTATE, FPAYSTATE, FSOURCEAMOUNTBALANCE, FBUDGETUSED, FAMOUNTSTRIKED, FAMOUNTENCASHED, FSOURCEBILLID, FSOURCEBILLENTRYID, FSOURCEBILLNUMBER, FAMOUNTORI, FAMOUNTAPPROVEDORI, FBUDGETAMOUNTORI, FBUDGETDOORI, FAMOUNTBALANCEORI, FAMOUNTUSEDORI, FBUDGETUSEDORI, FCURRENCYID, FEXCHANGERATE, FBUDGETBALANCE, FTRAVELAREA, FROOMDAYS, FALLOWANCEDAYS, FCONVERTMODE, FEXCHANGERATEPRECISION, FPURPOSE, FPROJECTID, FTICKETNUMBER, FTICKETURL, FTICKETCODE, FTICKETRANDOMCODE, FTAXRATE, FHOTELEXPENSEWITHOUTTAX, FAMOUNTAPPROVEDWITHOUTTAX, FAMOUNTWITHOUTTAX, FTAXAPPROVED, FTAX, FBILLINGDATE, FHOTELEXPENAPPWITHOUTTAX, FAMOUNTAPPROVEDORIWITHOUTTAX, FAMOUNTORIWITHOUTTAX, CFJTGJID, CFBREAKFAST, CFLUNCH, CFDINNER, CFINVOICETYPEID, CFFPJE, CFHSFYLXID, FINVOICENUM, CFOTHERTAX, CFOTHERTAXRATE, CFOTHEREXPENWITHOUTTAX, FBUSSESEXPENSEWITHOUTTAX, FBUSSESEXPENSETAX, FBUSSESEXPENSETAXRATE, FCADFUND, FCADFUNDAPPROVED, FENTRYSERIALNO, FENTRYTICNUMBER, CFDEVPROJECTID)
 values 
(newBosID('83E90A16'), 2, N'北京', N'上海', {ts'2022-11-15 00:00:00'}, {ts'2022-11-16 00:00:00'}, 10, 0, 0, 2, 0, 2, 's8RiHz8iQtCKhaYhDFAkP8VwA7w=', 0, N'Ex0AAAzisVN45LyU', 2, null, 0, null, null, N'Ex0AAAzR9S/Ji/mj', N'Ex0AAAKl/bDM567U', 'p2lIkQEVEADgAAvswKhYB8znrtQ=', 10, 10, 0, 0, 0, 0, null, null, null, 2, 2, 0, 0, 0, 0, 0, 'dfd38d11-00fd-1000-e000-1ebdc0a8100dDEB58FDC', 1, null, '5ftf6mv+TJqBwZSphv5DUsyIpaU=', 1, 2, 0, 4, null, N'Ex0AABISybza3gXu', null, null, null, null, 1, 1.98, 1.98, 1.98, 0.02, 0.02, {ts'2022-12-20 00:00:00'}, 1.98, 1.98, 1.98, null, 0, null, null, N'Ex0AAA0a7VTqTH89', 2, N'Ex0AAAzisVN45LyU', N'发票0张', 0, 0, 0, 0, 0, 0, 0, 0, null, null, null);