盘点方案增加物料基础资料字段作为分单依据的SQL示例

以物料自定义业务员字段，物料盘点方案按自定义业务员进行分单为例进行说明。

步骤如下：

1、物料增加自定义字段：

2、物料信息：

3、执行以下SQL：

delete T_STK_COUNTSEPBILLITEM where FKEY = 'FMaterialId.FBase1';

insert into T_STK_COUNTSEPBILLITEM(FID,FNUMBER,FKEY,FFIELDTYPE,FSRCFIELDNAME,FINVFIELDNAME,FTABLENAME,FTABLERELATION,FSEQ,FDOCUMENTSTATUS,FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,

FAPPROVERID,FAPPROVEDATE,FFORBIDSTATUS,FFORBIDDERID,FFORBIDDATE,FFORTABLECOUNT,FFORCYCLECOUNT)

values(100020,'materialbase1','FMaterialId.FBase1',2,'TM.FBase1','FMaterialId',' T_BD_MATERIAL',' LEFT JOIN T_BD_MATERIAL TM ON T2.FMATERIALID = TM.FMASTERID AND ( TM.FUSEORGID = T2.FSTOCKORGID OR EXISTS ( SELECT 1 FROM T_META_BASEDATATYPE WHERE FBASEDATATYPEID = ''BD_MATERIAL'' AND FSTRATEGYTYPE = 1))',20,'C',16394,'2030-09-08',16