1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
| 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"
| }
| ]
| }
| ]
| }
| }
|
|
