1.通过单据号，查询是不是通过扫描提交的单据

# 1.提供单据号，查询是不是通过扫码提交的单据；
SELECT FCommitTime            AS 提交时间,
       FCommitMessage         AS Erp提交信息,
       FTargetBillKey         AS 目标单据KEY,
       FTargetBillName        AS 目标单据名称,
       FTargetBillNumber      AS 目标单据编号,
       FTargetBillEntryNumber AS 目标单据行号,
       FTargetBillId          AS 目标单据ID,
       FTargetBillEntryId     AS 目标单据分录ID,
       FBARCODEID             AS 提交的条码ID,
       FBarcode               AS 条码,
       FBarcodeType           AS 条码类型, # 0 - 普通条码 | 1 - 可扣减标签 | 2 - 容器标签
       FORGID                 AS 组织ID,
       FORGNUMBER             AS 组织代码,
       FORGNAME               AS 组织名称,
       FMATERIALID            AS 物料ID,
       FMATERIALIDNUMBER      AS 物料代码,
       FMATERIALIDNAME        AS 物料名称,
       FSPECIFICATION         AS 物料规格型号,
       FISBATCHMANAGE         AS 是否使用批次管理,
       FLOT_TEXT              AS 批次,
       FCommitQty             AS 提交的数量,
       FCommitUnitId          AS 提交的单位ID,
       FCommitUnitNumber      AS 提交的单位代码,
       FCommitUnitName        AS 提交的单位名称,
       FCommitCKId            AS 提交的仓库ID,
       FCommitCKNumber        AS 提交的仓库代码,
       FCommitCKName          AS 提交的仓库名称,
       FCommitCWId            AS 提交的仓位ID,
       FCommitCWNumber        AS 提交的仓位代码,
       FCommitCWName          AS 提交的仓位名称
FROM t_commit_log
WHERE FTargetBillNumber = 'CGSL000023';