Sp_Manufacture_InsertMftPlanSlave（存储过程）

生产计划从：插入计划（Sp_Manufacture_InsertMftPlan调用）

• 类型： PROCEDURE
• 确定性： NO
• SQL 数据访问： CONTAINS SQL
• 创建时间： 2026-04-27 19:10:36
• 最后修改： 2026-04-27 19:10:36

参数

#	模式	名称	类型
1	IN	p_sMachineStyle	varchar(255)
2	IN	p_dPlateQty	decimal(18,6)
3	IN	p_dGiveQty	decimal(18,6)
4	IN	p_sColorSerial	varchar(255)
5	IN	p_dMachineQty	decimal(18,6)
6	IN	p_iPlate	int
7	IN	p_iFor	int
8	IN	p_ConstTie	varchar(50)
9	IN	p_iStick	int
10	IN	p_iFace	int
11	IN	p_iPrintMode	decimal(18,6)
12	IN	p_dPrintFaceQty	decimal(18,6)
13	IN	p_uPlanSlaveGuid	varchar(50)
14	IN	sBrId	varchar(50)
15	IN	sSuId	varchar(50)
16	IN	p_tCreateDate	datetime
17	IN	sLoginId	varchar(50)
18	IN	p_sType	varchar(10)
19	IN	p_sWorkOrderMaterialsTbId	varchar(50)
20	IN	p_sMaterialsId	varchar(50)
21	IN	p_sMaterialsStyle	varchar(50)
22	IN	p_dAuxiliaryQty	decimal(18,6)
23	IN	p_sTjMachineId	varchar(50)
24	IN	p_sTjAPSMemo	longtext
25	IN	p_uWorkOrderProcessGuid	varchar(50)
26	IN	p_uPlanGuid	varchar(50)
27	IN	p_uCustomerGuid	varchar(50)
28	IN	p_sManualNo	varchar(50)
29	IN	p_sCustomerOrderNo	varchar(50)
30	IN	p_uProductGuid	varchar(50)
31	IN	p_uProcessGuid	varchar(50)
32	IN	p_dProductQty	decimal(18,6)
33	IN	p_uControlGuid	varchar(50)
34	IN	p_sPartsName	varchar(255)
35	IN	p_uMachineGuid	varchar(50)
36	IN	p_dProductionReportQty	decimal(18,6)
37	IN	p_dQuotationHour	decimal(18,6)
38	IN	p_tStartDate	datetime
39	IN	p_tPlanDate	datetime
40	IN	p_uTeamGuid	varchar(50)
41	IN	p_sMaterialsNameTmp	varchar(100)
42	IN	p_sProcessMemo	varchar(250)
43	IN	p_sWorkOrderId	varchar(50)
44	IN	p_sWorkOrderNo	varchar(50)
45	IN	p_dNoArrangeQty	decimal(18,6)
46	IN	p_dProductPQty	decimal(18,6)
47	IN	p_sSrcSlaveMemo	longtext
48	IN	p_sWebOrderNo	varchar(50)
49	IN	p_sWebOrderId	varchar(50)
50	IN	p_sOrderId	varchar(50)
51	IN	p_sOrderNo	varchar(50)
52	IN	p_sWorkOrderSlaveId	varchar(50)
53	IN	p_sSReserve1	varchar(50)
54	IN	p_sSReserve2	varchar(50)
55	IN	p_sSReserve3	varchar(50)
56	IN	p_sSReserve4	varchar(50)
57	IN	p_sSReserve5	varchar(50)
58	IN	p_sSReserve6	varchar(50)
59	IN	p_dSReserve1	decimal(18,6)
60	IN	p_dSReserve2	decimal(18,6)
61	IN	p_dSReserve3	decimal(18,6)
62	IN	p_iSReserve1	int
63	IN	p_iSReserve2	int
64	IN	p_iSReserve3	int
65	IN	p_tSReserve1	datetime
66	IN	p_tSReserve2	datetime
67	IN	p_sCReserve1	varchar(255)
68	IN	p_sMReserve1	varchar(255)
69	IN	p_sMReserve2	varchar(255)
70	IN	p_sState	varchar(5)
71	IN	p_sFormId	varchar(50)
72	IN	p_sColorSerialMemo	longtext
73	IN	p_sAfterProcess	longtext
74	IN	p_sProcessRequire	longtext
75	IN	p_tDeliverDate	datetime
76	IN	p_iArrangeSrcValue	int
77	IN	p_sPReserve2	longtext
78	IN	p_dSinglePQty	decimal(18,6)
79	IN	p_sReportParams	longtext
80	IN	p_sWorkCenterId	varchar(255)
81	IN	p_sControlFaceName	longtext
82	IN	p_sPositiveColor	longtext
83	IN	p_sOppositeColor	longtext
84	OUT	sCode	int
85	OUT	sReturn	longtext

主体

主体未预缓存。如需查看： mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpManufacture_InsertMftPlanSlave'。_

说明

暂无人工说明。