viw_zmainplan_mftmaterials (view)

• Updatable: YES

Columns

#	Name	Type	Null
1	iIncrement	int	NO
2	sId	varchar(100)	NO
3	sBrandsId	varchar(100)	NO
4	sSubsidiaryId	varchar(100)	NO
5	iOrder	int	NO
6	sParentId	varchar(100)	NO
7	sControlId	varchar(100)	NO
8	sType	varchar(255)	NO
9	sMaterialsId	varchar(100)	NO
10	sMaterialsStyle	varchar(255)	NO
11	dAuxiliaryQty	decimal(18,6)	NO
12	sAuxiliaryUnit	varchar(255)	NO
13	dMaterialsQty	decimal(18,6)	NO
14	iReelPaper	int	NO
15	dConversionQty	decimal(18,6)	NO
16	dCostMaterialsPrice	decimal(18,6)	NO
17	dCostMaterialsMoney	decimal(18,6)	NO
18	dMaterialsPrice	decimal(18,6)	NO
19	dMaterialsMoney	decimal(18,6)	NO
20	dMaterialsKQty	decimal(18,6)	NO
21	bPurchaseApplyComplete	bit(1)	NO
22	dPurchaseApplyAuxiliaryQty	decimal(18,6)	NO
23	dPurchaseApplyQty	decimal(18,6)	NO
24	bPurchaseComplete	bit(1)	NO
25	dPurchaseAuxiliaryQty	decimal(18,6)	NO
26	dPurchaseQty	decimal(18,6)	NO
27	dProductionAuxiliaryQty	decimal(18,6)	NO
28	dProductionQty	decimal(18,6)	NO
29	bProductionComplete	bit(1)	NO
30	bComMaterials	bit(1)	NO
31	bOutsideBandMaterials	bit(1)	NO
32	sProcessId	varchar(100)	NO
33	sProcessTbId	varchar(100)	NO
34	sSelectProcess	varchar(255)	NO
35	sSrcId	varchar(100)	NO
36	sMaterialsMemo	text	YES
37	sAReserve1	varchar(255)	YES
38	sAReserve2	varchar(255)	YES
39	sAReserve3	varchar(255)	YES
40	sAReserve4	varchar(255)	YES
41	sAReserve5	varchar(255)	YES
42	sAReserve6	varchar(255)	YES
43	dAReserve1	decimal(18,6)	YES
44	dAReserve2	decimal(18,6)	YES
45	dAReserve3	decimal(18,6)	YES
46	iAReserve1	int	YES
47	iAReserve2	int	YES
48	iAReserve3	int	YES
49	tAReserve1	datetime	YES
50	tAReserve2	datetime	YES
51	bComComplete	bit(1)	NO
52	dComAuxiliaryQty	decimal(18,6)	NO
53	dComQty	decimal(18,6)	NO
54	bCutComplete	bit(1)	NO
55	dCutAuxiliaryQty	decimal(18,6)	NO
56	dCutQty	decimal(18,6)	NO
57	bMarginalComplete	bit(1)	NO
58	dMarginalAuxiliaryQty	decimal(18,6)	NO
59	dMarginalQty	decimal(18,6)	NO
60	bNotAuto	bit(1)	NO
61	sMakePerson	varchar(255)	NO
62	tCreateDate	datetime	NO
63	sSrcControlId	varchar(100)	NO
64	sSrcMaterialsTbId	varchar(100)	NO
65	bPlanMaterialCheck	bit(1)	NO
66	bPlanMaterialCheckResult	bit(1)	NO
67	sWorkOrderId	varchar(100)	NO
68	sSrcNo	varchar(255)	NO
69	sState	varchar(255)	NO
70	dCheckQty	decimal(18,6)	YES
71	tPurchaseDate	datetime	YES
72	tMcDate	datetime	YES
73	sMcMemo	varchar(500)	YES
74	imorder	int	YES
75	splanId	varchar(100)	NO
76	sCustomerId	varchar(100)	NO
77	sProductId	varchar(100)	NO
78	bFrozen	bit(1)	NO

Definition

select `mm`.`iIncrement` AS `iIncrement`,`mm`.`sId` AS `sId`,`mm`.`sBrandsId` AS `sBrandsId`,`mm`.`sSubsidiaryId` AS `sSubsidiaryId`,`mm`.`iOrder` AS `iOrder`,`mm`.`sParentId` AS `sParentId`,`mm`.`sControlId` AS `sControlId`,`mm`.`sType` AS `sType`,`mm`.`sMaterialsId` AS `sMaterialsId`,`mm`.`sMaterialsStyle` AS `sMaterialsStyle`,`mm`.`dAuxiliaryQty` AS `dAuxiliaryQty`,`mm`.`sAuxiliaryUnit` AS `sAuxiliaryUnit`,`mm`.`dMaterialsQty` AS `dMaterialsQty`,`mm`.`iReelPaper` AS `iReelPaper`,`mm`.`dConversionQty` AS `dConversionQty`,`mm`.`dCostMaterialsPrice` AS `dCostMaterialsPrice`,`mm`.`dCostMaterialsMoney` AS `dCostMaterialsMoney`,`mm`.`dMaterialsPrice` AS `dMaterialsPrice`,`mm`.`dMaterialsMoney` AS `dMaterialsMoney`,`mm`.`dMaterialsKQty` AS `dMaterialsKQty`,`mm`.`bPurchaseApplyComplete` AS `bPurchaseApplyComplete`,`mm`.`dPurchaseApplyAuxiliaryQty` AS `dPurchaseApplyAuxiliaryQty`,`mm`.`dPurchaseApplyQty` AS `dPurchaseApplyQty`,`mm`.`bPurchaseComplete` AS `bPurchaseComplete`,`mm`.`dPurchaseAuxiliaryQty` AS `dPurchaseAuxiliaryQty`,`mm`.`dPurchaseQty` AS `dPurchaseQty`,`mm`.`dProductionAuxiliaryQty` AS `dProductionAuxiliaryQty`,`mm`.`dProductionQty` AS `dProductionQty`,`mm`.`bProductionComplete` AS `bProductionComplete`,`mm`.`bComMaterials` AS `bComMaterials`,`mm`.`bOutsideBandMaterials` AS `bOutsideBandMaterials`,`mm`.`sProcessId` AS `sProcessId`,`mm`.`sProcessTbId` AS `sProcessTbId`,`mm`.`sSelectProcess` AS `sSelectProcess`,`mm`.`sSrcId` AS `sSrcId`,`mm`.`sMaterialsMemo` AS `sMaterialsMemo`,`mm`.`sAReserve1` AS `sAReserve1`,`mm`.`sAReserve2` AS `sAReserve2`,`mm`.`sAReserve3` AS `sAReserve3`,`mm`.`sAReserve4` AS `sAReserve4`,`mm`.`sAReserve5` AS `sAReserve5`,`mm`.`sAReserve6` AS `sAReserve6`,`mm`.`dAReserve1` AS `dAReserve1`,`mm`.`dAReserve2` AS `dAReserve2`,`mm`.`dAReserve3` AS `dAReserve3`,`mm`.`iAReserve1` AS `iAReserve1`,`mm`.`iAReserve2` AS `iAReserve2`,`mm`.`iAReserve3` AS `iAReserve3`,`mm`.`tAReserve1` AS `tAReserve1`,`mm`.`tAReserve2` AS `tAReserve2`,`mm`.`bComComplete` AS `bComComplete`,`mm`.`dComAuxiliaryQty` AS `dComAuxiliaryQty`,`mm`.`dComQty` AS `dComQty`,`mm`.`bCutComplete` AS `bCutComplete`,`mm`.`dCutAuxiliaryQty` AS `dCutAuxiliaryQty`,`mm`.`dCutQty` AS `dCutQty`,`mm`.`bMarginalComplete` AS `bMarginalComplete`,`mm`.`dMarginalAuxiliaryQty` AS `dMarginalAuxiliaryQty`,`mm`.`dMarginalQty` AS `dMarginalQty`,`mm`.`bNotAuto` AS `bNotAuto`,`mm`.`sMakePerson` AS `sMakePerson`,`mm`.`tCreateDate` AS `tCreateDate`,`mm`.`sSrcControlId` AS `sSrcControlId`,`mm`.`sSrcMaterialsTbId` AS `sSrcMaterialsTbId`,`mm`.`bPlanMaterialCheck` AS `bPlanMaterialCheck`,`mm`.`bPlanMaterialCheckResult` AS `bPlanMaterialCheckResult`,`mp`.`sWorkOrderId` AS `sWorkOrderId`,`mp`.`sSrcNo` AS `sSrcNo`,`mp`.`sState` AS `sState`,`mm`.`dCheckQty` AS `dCheckQty`,`mm`.`tPurchaseDate` AS `tPurchaseDate`,`mm`.`tMCDate` AS `tMcDate`,`mm`.`sMcMemo` AS `sMcMemo`,`mp`.`imorder` AS `imorder`,`mp`.`sId` AS `splanId`,`mp`.`sCustomerId` AS `sCustomerId`,`mp`.`sProductId` AS `sProductId`,`mp`.`bFrozen` AS `bFrozen` from (`mftworkordermaterials` `mm` join (select `w`.`sCustomerId` AS `sCustomerId`,`w`.`sProductId` AS `sProductId`,`w`.`sParentId` AS `sParentId`,`mp`.`sWorkOrderId` AS `sWorkOrderId`,`mp`.`sSrcNo` AS `sSrcNo`,`mp`.`sState` AS `sState`,`mp`.`imorder` AS `imorder`,`mp`.`sid` AS `sId`,`mp`.`bFrozen` AS `bFrozen` from (`mftworkorderslave` `w` join `viw_mftproductionplan_workorder` `mp` on((`w`.`sParentId` = `mp`.`sWorkOrderId`))) group by `w`.`sParentId`) `mp` on((`mm`.`sParentId` = `mp`.`sWorkOrderId`))) order by `mp`.`sState` desc,`mp`.`imorder`

Narrative

No human-written narrative yet.