2023/6/29 11:21:19 sqlselect  a.FID,a.FNUMBER Employee,d.FNUMBER Dept from Gy_Employee e
join AIS20210811135644..T_HR_EMPINFO_L a1 on a1.FNAME=e.HName
join AIS20210811135644..T_HR_EMPINFO a on a1.FID = a.FID
join AIS20210811135644..T_BD_STAFFTEMP c on c.FID = a.FID
join AIS20210811135644..T_BD_DEPARTMENT d on c.FDEPTID = d.FDEPTID
where e.HItemID ='102119' 

2023/6/29 11:21:19 质检部门BM000004

2023/6/29 11:21:19 质检员201801004

2023/6/29 11:21:19 检验单json：{
  "Creator": "",
  "NeedUpDateFields": [],
  "NeedReturnFields": [],
  "IsDeleteEntry": "false",
  "SubSystemId": "",
  "IsVerifyBaseDataField": "false",
  "Model": {
    "FBillTypeID": {
      "Fnumber": "JYD001_SYS"
    },
    "FBusinessType": "1",
    "FDate": "2023-06-29",
    "FInspectOrgId": {
      "Fnumber": "101.2"
    },
    "FSourceOrgId": {
      "Fnumber": "101.2"
    },
    "FInspectDepId": {
      "Fnumber": "BM000004"
    },
    "FInspectorId": {
      "Fnumber": "201801004"
    },
    "FISSYNCED": "false",
    "F_PGKJ_Date": "2023-06-29",
    "FBillNo": "LLJYD00000743",
    "FEntity": [
      {
        "FMaterialId": {
          "Fnumber": "1.02.001.0002.00001"
        },
        "FUnitID": {
          "Fnumber": "Pcs"
        },
        "FInspectQty": "2",
        "FQualifiedQty": "0",
        "FUnqualifiedQty": "1",
        "FInspectResult": "2",
        "FQCStatus": "1",
        "FIsRelated": false,
        "FSrcBillType0": "PUR_ReceiveBill",
        "FBaseUnitId": {
          "Fnumber": "Pcs"
        },
        "FBaseInspectQty": "2",
        "FSupplierId": {
          "Fnumber": "VEN00001"
        },
        "FInspectTimes": "1",
        "FTimeUnit": "24",
        "FSAMPLEDAMAGEBEARER": "2",
        "FISFIRSTINSPECT": false,
        "FBaseQualifiedQty": "0",
        "FBaseAcceptQty": "0",
        "FCurrency": {
          "Fnumber": "PRE001"
        },
        "FIsSplitRow ": false,
        "FPolicyDetail": [
          {
            "FPolicyMaterialId": {
              "Fnumber": "1.02.001.0002.00001"
            },
            "FPolicyStatus": "1",
            "FPolicyQty": "1",
            "FBasePolicyQty": "1",
            "FUsePolicy": "F",
            "FIsCheck": false,
            "FIsDefectProcess": false,
            "FCanSale": false,
            "FIsMRBReview": false,
            "FIsReturn": true,
            "FIsRelatedDefect": false
          }
        ],
        "FReferDetail": [
          {
            "FDetailID": "0",
            "FSrcBillType": "PUR_ReceiveBill",
            "FSrcBillNo": "CGSL000082",
            "FSrcInterId": "100188",
            "FSrcEntryId": "100264",
            "FSrcEntrySeq": "1",
            "FOrderType": {
              "FID": "PUR_PurchaseOrder"
            },
            "FOrderBillNo": "CGDD000112",
            "FOrderId": "100122",
            "FOrderEntryId": "100240",
            "FOrderEntrySeq": "1"
          }
        ],
        "FEntity_Link": [
          {
            "FEntity_Link_FRuleId": "QM_PURReceive2Inspect",
            "FEntity_Link_FSTableName": "T_PUR_RECEIVEENTRY",
            "FEntity_Link_FSBillId": "100188",
            "FEntity_Link_FSId": "100264",
            "FEntity_Link_FBaseAcceptQty": "0",
            "FEntity_Link_FBaseAcceptQtyOld": "0",
            "FEntity_Link_FBaseInspectQtyOld": "0",
            "FEntity_Link_FInspectQtyOld": "0"
          }
        ]
      }
    ]
  }
}