金蝶云星空生产退料查询_v1 API

Platform: 金蝶云星空
Type: WebAPI
Effect: QUERY
API Version: 0.1
Adapter: \Adapter\K3Cloud\K3CloudQueryAdapter
Auth Mode: OTHER
Updated At: 2022-08-31

生产退料查询_v1

POSTexecuteBillQuery

Factory

{
  "operation": {
    "method": "none"
  }
}

Request Parameters

No.	Field	Name	Type	Default	Required	Description
1	FWorkCenterId	FWorkCenterId	string	1	Optional	111
2	FBillHead	FBillHead	string	1	Optional	111
3	FOptDetailId	FOptDetailId	string	1	Optional	111
4	FID	FID	string	1	Optional	111
5	FReqSrc	FReqSrc	string	1	Optional	111
6	FBillNo	FBillNo	string	1	Optional	111
7	FReqBillNo	FReqBillNo	string	1	Optional	111
8	FDocumentStatus	FDocumentStatus	string	1	Optional	111
9	FApproverId	FApproverId	string	1	Optional	111
10	FReqBillId	FReqBillId	string	1	Optional	111
11	FReqEntrySeq	FReqEntrySeq	string	1	Optional	111
12	FApproveDate	FApproveDate	string	1	Optional	111
13	FReqEntryId	FReqEntryId	string	1	Optional	111
14	FModifierId	FModifierId	string	1	Optional	111
15	FCreateDate	FCreateDate	string	1	Optional	111
16	FEquipmentId	FEquipmentId	string	1	Optional	111
17	FCreatorId	FCreatorId	string	1	Optional	111
18	FModifyDate	FModifyDate	string	1	Optional	111
19	FCancelDate	FCancelDate	string	1	Optional	111
20	FCanceler	FCanceler	string	1	Optional	111
21	FCancelStatus	FCancelStatus	string	1	Optional	111
22	FDescription	FDescription	string	1	Optional	111
23	FPrdOrgId(必填项)	FPrdOrgId(必填项)	string	1	Optional	111
24	FStockOrgId(必填项)	FStockOrgId(必填项)	string	1	Optional	111
25	FDate(必填项)	FDate(必填项)	string	1	Optional	111
26	FWorkShopId	FWorkShopId	string	1	Optional	111
27	FStockId0	FStockId0	string	1	Optional	111
28	FBillType(必填项)	FBillType(必填项)	string	1	Optional	111
29	FOwnerId0	FOwnerId0	string	1	Optional	111
30	FOwnerTypeId0	FOwnerTypeId0	string	1	Optional	111
31	FCurrId	FCurrId	string	1	Optional	111
32	FTransferBizType	FTransferBizType	string	1	Optional	111
33	FSTOCKERID	FSTOCKERID	string	1	Optional	111
34	FReturnerId	FReturnerId	string	1	Optional	111
35	FIsCrossTrade	FIsCrossTrade	string	1	Optional	111
36	FVmiBusiness	FVmiBusiness	string	1	Optional	111
37	FScanBox	FScanBox	string	1	Optional	111
38	FSourceType	FSourceType	string	1	Optional	111
39	FIsOwnerTInclOrg	FIsOwnerTInclOrg	string	1	Optional	111
40	FEntity	FEntity	string	1	Optional	111
41	FEntryID	FEntryID	string	1	Optional	111
42	FPPBOMEntryId	FPPBOMEntryId	string	1	Optional	111
43	FMaterialId(必填项)	FMaterialId(必填项)	string	1	Optional	111
44	FMaterialName	FMaterialName	string	1	Optional	111
45	FSpecification	FSpecification	string	1	Optional	111
46	FUnitID(必填项)	FUnitID(必填项)	string	1	Optional	111
47	FAPPQty	FAPPQty	string	1	Optional	111
48	FQty	FQty	string	1	Optional	111
49	FReturnType(必填项)	FReturnType(必填项)	string	1	Optional	111
50	FStockId(必填项)	FStockId(必填项)	string	1	Optional	111
51	FMoId	FMoId	string	1	Optional	111
52	FMoBillNo	FMoBillNo	string	1	Optional	111
53	FMoEntryId	FMoEntryId	string	1	Optional	111
54	FMoEntrySeq	FMoEntrySeq	string	1	Optional	111
55	FAuxPropId	FAuxPropId	string	1	Optional	111
56	FBaseAppQty	FBaseAppQty	string	1	Optional	111
57	FStockUnitId	FStockUnitId	string	1	Optional	111
58	FStockAppQty	FStockAppQty	string	1	Optional	111
59	FSecUnitId	FSecUnitId	string	1	Optional	111
60	FSecStockQty	FSecStockQty	string	1	Optional	111
61	FStockQty	FStockQty	string	1	Optional	111
62	FBaseQty	FBaseQty	string	1	Optional	111
63	FMtoNo	FMtoNo	string	1	Optional	111
64	FProjectNo	FProjectNo	string	1	Optional	111
65	FLot	FLot	string	1	Optional	111
66	FStockStatusId(必填项)	FStockStatusId(必填项)	string	1	Optional	111
67	FExpUnit	FExpUnit	string	1	Optional	111
68	FExpPeriod	FExpPeriod	string	1	Optional	111
69	FKeeperTypeId(必填项)	FKeeperTypeId(必填项)	string	1	Optional	111
70	FKeeperId(必填项)	FKeeperId(必填项)	string	1	Optional	111
71	FOperId	FOperId	string	1	Optional	111
72	FPrice	FPrice	string	1	Optional	111
73	FAmount	FAmount	string	1	Optional	111
74	FBomId	FBomId	string	1	Optional	111
75	FStockLocId	FStockLocId	string	1	Optional	111
76	FProcessId	FProcessId	string	1	Optional	111
77	FSrcBillType(必填项)	FSrcBillType(必填项)	string	1	Optional	111
78	FSrcBillNo	FSrcBillNo	string	1	Optional	111
79	FSelRePickedQty	FSelRePickedQty	string	1	Optional	111
80	FBaseSelRePickedQty	FBaseSelRePickedQty	string	1	Optional	111
81	FBaseUnitId	FBaseUnitId	string	1	Optional	111
82	FStockFlag	FStockFlag	string	1	Optional	111
83	FOwnerTypeId(必填项)	FOwnerTypeId(必填项)	string	1	Optional	111
84	FOwnerId(必填项)	FOwnerId(必填项)	string	1	Optional	111
85	FEntrySrcInterId	FEntrySrcInterId	string	1	Optional	111
86	FEntrySrcEnteryId	FEntrySrcEnteryId	string	1	Optional	111
87	FEntrySrcEntrySeq	FEntrySrcEntrySeq	string	1	Optional	111
88	FProduceDate	FProduceDate	string	1	Optional	111
89	FExpiryDate	FExpiryDate	string	1	Optional	111
90	FPPBomBillNo	FPPBomBillNo	string	1	Optional	111
91	FWorkShopId1	FWorkShopId1	string	1	Optional	111
92	FReturnReason	FReturnReason	string	1	Optional	111
93	FEntrtyMemo	FEntrtyMemo	string	1	Optional	111
94	FParentOwnerTypeId	FParentOwnerTypeId	string	1	Optional	111
95	FParentOwnerId	FParentOwnerId	string	1	Optional	111
96	FBFLowId	FBFLowId	string	1	Optional	111
97	FParentMaterialId	FParentMaterialId	string	1	Optional	111
98	FSrcBizBillType	FSrcBizBillType	string	1	Optional	111
99	FSrcBizBillNo	FSrcBizBillNo	string	1	Optional	111
100	FSrcBizInterId	FSrcBizInterId	string	1	Optional	111
101	FSrcBizEntryId	FSrcBizEntryId	string	1	Optional	111
102	FSrcBizEntrySeq	FSrcBizEntrySeq	string	1	Optional	111
103	FSNUnitID	FSNUnitID	string	1	Optional	111
104	FSNQty	FSNQty	string	1	Optional	111
105	FReserveType	FReserveType	string	1	Optional	111
106	FBASESTOCKQTY	FBASESTOCKQTY	string	1	Optional	111
107	FConsome	FConsome	string	1	Optional	111
108	FEntryVmiBusiness	FEntryVmiBusiness	string	1	Optional	111
109	FOptQueue	FOptQueue	string	1	Optional	111
110	FOptPlanBillNo	FOptPlanBillNo	string	1	Optional	111
111	FOptPlanBillId	FOptPlanBillId	string	1	Optional	111

Response Parameters

No.	Field	Name	Type	Default	Required	Description
1	FWorkCenterId	FWorkCenterId	string	1	Optional	111
2	FBillHead	FBillHead	string	1	Optional	111
3	FID	FID	string	1	Optional	111
4	FOptDetailId	FOptDetailId	string	1	Optional	111
5	FReqSrc	FReqSrc	string	1	Optional	111
6	FBillNo	FBillNo	string	1	Optional	111
7	FReqBillNo	FReqBillNo	string	1	Optional	111
8	FDocumentStatus	FDocumentStatus	string	1	Optional	111
9	FApproverId	FApproverId	string	1	Optional	111
10	FReqBillId	FReqBillId	string	1	Optional	111
11	FReqEntrySeq	FReqEntrySeq	string	1	Optional	111
12	FApproveDate	FApproveDate	string	1	Optional	111
13	FReqEntryId	FReqEntryId	string	1	Optional	111
14	FModifierId	FModifierId	string	1	Optional	111
15	FCreateDate	FCreateDate	string	1	Optional	111
16	FEquipmentId	FEquipmentId	string	1	Optional	111
17	FCreatorId	FCreatorId	string	1	Optional	111
18	FModifyDate	FModifyDate	string	1	Optional	111
19	FCancelDate	FCancelDate	string	1	Optional	111
20	FCanceler	FCanceler	string	1	Optional	111
21	FCancelStatus	FCancelStatus	string	1	Optional	111
22	FDescription	FDescription	string	1	Optional	111
23	FPrdOrgId(必填项)	FPrdOrgId(必填项)	string	1	Optional	111
24	FStockOrgId(必填项)	FStockOrgId(必填项)	string	1	Optional	111
25	FDate(必填项)	FDate(必填项)	string	1	Optional	111
26	FWorkShopId	FWorkShopId	string	1	Optional	111
27	FStockId0	FStockId0	string	1	Optional	111
28	FBillType(必填项)	FBillType(必填项)	string	1	Optional	111
29	FOwnerId0	FOwnerId0	string	1	Optional	111
30	FOwnerTypeId0	FOwnerTypeId0	string	1	Optional	111
31	FCurrId	FCurrId	string	1	Optional	111
32	FTransferBizType	FTransferBizType	string	1	Optional	111
33	FSTOCKERID	FSTOCKERID	string	1	Optional	111
34	FReturnerId	FReturnerId	string	1	Optional	111
35	FIsCrossTrade	FIsCrossTrade	string	1	Optional	111
36	FVmiBusiness	FVmiBusiness	string	1	Optional	111
37	FScanBox	FScanBox	string	1	Optional	111
38	FSourceType	FSourceType	string	1	Optional	111
39	FIsOwnerTInclOrg	FIsOwnerTInclOrg	string	1	Optional	111
40	FEntity	FEntity	string	1	Optional	111
41	FEntryID	FEntryID	string	1	Optional	111
42	FPPBOMEntryId	FPPBOMEntryId	string	1	Optional	111
43	FMaterialId(必填项)	FMaterialId(必填项)	string	1	Optional	111
44	FMaterialName	FMaterialName	string	1	Optional	111
45	FSpecification	FSpecification	string	1	Optional	111
46	FUnitID(必填项)	FUnitID(必填项)	string	1	Optional	111
47	FAPPQty	FAPPQty	string	1	Optional	111
48	FQty	FQty	string	1	Optional	111
49	FReturnType(必填项)	FReturnType(必填项)	string	1	Optional	111
50	FStockId(必填项)	FStockId(必填项)	string	1	Optional	111
51	FMoId	FMoId	string	1	Optional	111
52	FMoBillNo	FMoBillNo	string	1	Optional	111
53	FMoEntryId	FMoEntryId	string	1	Optional	111
54	FMoEntrySeq	FMoEntrySeq	string	1	Optional	111
55	FAuxPropId	FAuxPropId	string	1	Optional	111
56	FBaseAppQty	FBaseAppQty	string	1	Optional	111
57	FStockUnitId	FStockUnitId	string	1	Optional	111
58	FStockAppQty	FStockAppQty	string	1	Optional	111
59	FSecUnitId	FSecUnitId	string	1	Optional	111
60	FSecStockQty	FSecStockQty	string	1	Optional	111
61	FStockQty	FStockQty	string	1	Optional	111
62	FBaseQty	FBaseQty	string	1	Optional	111
63	FMtoNo	FMtoNo	string	1	Optional	111
64	FProjectNo	FProjectNo	string	1	Optional	111
65	FLot	FLot	string	1	Optional	111
66	FStockStatusId(必填项)	FStockStatusId(必填项)	string	1	Optional	111
67	FExpUnit	FExpUnit	string	1	Optional	111
68	FExpPeriod	FExpPeriod	string	1	Optional	111
69	FKeeperTypeId(必填项)	FKeeperTypeId(必填项)	string	1	Optional	111
70	FKeeperId(必填项)	FKeeperId(必填项)	string	1	Optional	111
71	FOperId	FOperId	string	1	Optional	111
72	FPrice	FPrice	string	1	Optional	111
73	FAmount	FAmount	string	1	Optional	111
74	FBomId	FBomId	string	1	Optional	111
75	FStockLocId	FStockLocId	string	1	Optional	111
76	FProcessId	FProcessId	string	1	Optional	111
77	FSrcBillType(必填项)	FSrcBillType(必填项)	string	1	Optional	111
78	FSrcBillNo	FSrcBillNo	string	1	Optional	111
79	FSelRePickedQty	FSelRePickedQty	string	1	Optional	111
80	FBaseSelRePickedQty	FBaseSelRePickedQty	string	1	Optional	111
81	FBaseUnitId	FBaseUnitId	string	1	Optional	111
82	FStockFlag	FStockFlag	string	1	Optional	111
83	FOwnerTypeId(必填项)	FOwnerTypeId(必填项)	string	1	Optional	111
84	FOwnerId(必填项)	FOwnerId(必填项)	string	1	Optional	111
85	FEntrySrcInterId	FEntrySrcInterId	string	1	Optional	111
86	FEntrySrcEnteryId	FEntrySrcEnteryId	string	1	Optional	111
87	FEntrySrcEntrySeq	FEntrySrcEntrySeq	string	1	Optional	111
88	FProduceDate	FProduceDate	string	1	Optional	111
89	FExpiryDate	FExpiryDate	string	1	Optional	111
90	FPPBomBillNo	FPPBomBillNo	string	1	Optional	111
91	FWorkShopId1	FWorkShopId1	string	1	Optional	111
92	FReturnReason	FReturnReason	string	1	Optional	111
93	FEntrtyMemo	FEntrtyMemo	string	1	Optional	111
94	FParentOwnerTypeId	FParentOwnerTypeId	string	1	Optional	111
95	FParentOwnerId	FParentOwnerId	string	1	Optional	111
96	FBFLowId	FBFLowId	string	1	Optional	111
97	FParentMaterialId	FParentMaterialId	string	1	Optional	111
98	FSrcBizBillType	FSrcBizBillType	string	1	Optional	111
99	FSrcBizBillNo	FSrcBizBillNo	string	1	Optional	111
100	FSrcBizInterId	FSrcBizInterId	string	1	Optional	111
101	FSrcBizEntryId	FSrcBizEntryId	string	1	Optional	111
102	FSrcBizEntrySeq	FSrcBizEntrySeq	string	1	Optional	111
103	FSNUnitID	FSNUnitID	string	1	Optional	111
104	FSNQty	FSNQty	string	1	Optional	111
105	FReserveType	FReserveType	string	1	Optional	111
106	FBASESTOCKQTY	FBASESTOCKQTY	string	1	Optional	111
107	FConsome	FConsome	string	1	Optional	111
108	FEntryVmiBusiness	FEntryVmiBusiness	string	1	Optional	111
109	FOptQueue	FOptQueue	string	1	Optional	111
110	FOptPlanBillNo	FOptPlanBillNo	string	1	Optional	111
111	FOptPlanBillId	FOptPlanBillId	string	1	Optional	111

The 生产退料查询_v1 API (executeBillQuery) of 金蝶云星空 is curated by the API asset management module of the Qeasy Cloud data integration platform and kept in sync with 金蝶云星空 version updates.

Need to integrate this API?

Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.