ÿ
TREQMTSFORM0ì-TPF0TReqmtsForm
ReqmtsFormLeft¨Top�WidthHeight¸Caption
ReqmtsFormFont.CharsetDEFAULT_CHARSET
Font.ColorclWindowTextFont.Heightõ	Font.Name
MS Sans Serif
Font.StylePositionpoScreenCenterOnClose	FormCloseOnCreate
FormCreateOnShowFormShow
PixelsPerInch`
TextHeight
	TSplitter	Splitter1LeftTopWidthHeight€CursorcrHSplitAlignalRightTPanel	ToolPanelLeftTopWidthHeightAlignalTop
BevelOuterbvNoneTabOrderTSpeedButtonPrintButtonLeftxTopWidthBHeightCaption&PrintFlat	
Glyph.Data
zvBMvv( €€€€€€€€€¿¿¿ÿÿÿÿÿÿÿÿÿÿÿÿ0?ÿÿÿÿÿÿÿˆˆˆˆˆˆ€wwwwwwwˆˆˆˆˆˆ€wwwwwwwÿÿÿÿÿÿÿÿ������€wwwwwwwøøøøøùðwwwwwww������€wwwwwwwwwwwww30ÿÿÿÿ337óÿÿ?330ð337÷wss330ÿÿÿÿ337óÿ?ÿ330ð337÷swws330ÿÿð3337óÿ73330ð�3337÷ss3330ÿÿ33337ÿÿw3333033337wws333	NumGlyphsOnClickPrintButtonClickTSpeedButton
ExitButtonLeftºTopWidth?HeightCaptionE&xitFlat	
Glyph.Data
zvBMvv( ¿¿¿¿¿¿¿¿¿ÀÀÀ€€€ÿÿÿÿÿÿÿÿÿÿÿÿ3333333333ÿ333333p333333ÿ�33333wp33333ÿˆ?33330wwp33338ˆ3??ó33?wwpˆ3338ó3?ˆ333?wwpˆó338ó3?8ÿ33?wˆp�“338ó�???33?wðpù‘338ó8?ó?ÿ3?wwp™™™38ó3?333ó?wwpù““8ó3?ƒ?ƒó?wwp�“38ó3?8?8??wwpˆó318ó3ÿ8ƒ3�?wwðˆ3318óÿˆ8ó3�?wÿˆˆ3318ÿˆ38ó3�?ÿˆˆˆ338ˆÿÿøó8ó?ˆˆˆˆ3338ˆˆˆˆ333	NumGlyphsOnClickExitButtonClick	TCheckBox	LinkCheckLeftÈTopWidth1HeightCaption&LinkTabOrderVisibleOnClickLinkCheckClickTDBNavigatorNavBtnsLeftTopWidthpHeight
DataSource	ReqSourceVisibleButtonsnbFirstnbPriornbNextnbLastFlat	TabOrder	TCheckBox	YarnCheckLeftPTopWidthaHeightCaption
By &Yarn TypeTabOrderOnClick	ReqChange	TCheckBoxJobCheckLeftTopWidthAHeightCaptionBy &JobEnabledTabOrderOnClick	ReqChangeTDBGridRegGridLeftTopWidthHeight€AlignalClient
DataSource	ReqSourceTabOrderTitleFont.CharsetDEFAULT_CHARSETTitleFont.ColorclWindowTextTitleFont.HeightõTitleFont.Name
MS Sans SerifTitleFont.StyleOnEnterRegGridEnterTDBGridStkGridLeft TopWidthòHeight€AlignalRight
DataSource	StkSourceTabOrderTitleFont.CharsetDEFAULT_CHARSETTitleFont.ColorclWindowTextTitleFont.HeightõTitleFont.Name
MS Sans SerifTitleFont.StyleOnEnterStkGridEnterTDataSource	ReqSourceDataSetReqQueryLeftèTopàTQueryReqDateQueryOnCalcFieldsReqQueryCalcFieldsDatabaseNameSpinningSQL.StringsPselect sj.startdate, si.struct, si.twist, si.color, sum(si.weight) as yarnweightfrom spinjob sj, spinitem siCwhere sj.scenariono = :ScenarioNo and si.scenariono = sj.scenariono4group by sj.startdate, si.struct, si.twist, si.colorParams.Data

ScenarioNoLeft(TopøTDateTimeFieldReqDateQuerySTARTDATEDisplayLabel
Start DateDisplayWidth	FieldName	STARTDATETStringFieldReqDateQuerySTRUCTDisplayLabelStruct	FieldNameSTRUCTSizeTStringFieldReqDateQueryTWISTDisplayLabelTwist	FieldNameTWISTSizeTStringFieldReqDateQueryCOLORDisplayLabelColour	FieldNameCOLORSize
TIntegerFieldReqDateQueryYARNWEIGHT	FieldName
YARNWEIGHTVisibleTFloatFieldReqDateQueryFIBREWEIGHTDisplayLabelWeightDisplayWidth	FieldNameFIBREWEIGHT
Calculated	TQueryReqJobQueryOnCalcFieldsReqQueryCalcFieldsDatabaseNameSpinningSQL.StringsZselect sj.jobno, sj.startdate, si.struct, si.twist, si.color, sum(si.weight) as yarnweightfrom spinjob sj, spinitem siCwhere sj.scenariono = :ScenarioNo and si.scenariono = sj.scenariono>group by sj.jobno, sj.startdate, si.struct, si.twist, si.colorParams.Data

ScenarioNoLeft(Top
TIntegerFieldReqJobQueryJOBNODisplayLabelJob NoDisplayWidth	FieldNameJOBNOTDateTimeFieldReqJobQuerySTARTDATEDisplayLabel
Start DateDisplayWidth	FieldName	STARTDATETStringFieldReqJobQuerySTRUCTDisplayLabelStruct	FieldNameSTRUCTSizeTStringFieldReqJobQueryTWISTDisplayLabelTwist	FieldNameTWISTSizeTStringFieldReqJobQueryCOLORDisplayLabelColour	FieldNameCOLORSize
TIntegerFieldReqJobQueryYARNWEIGHT	FieldName
YARNWEIGHTVisibleTFloatFieldReqJobQueryFIBREWEIGHTDisplayLabelWeightDisplayWidth	FieldNameFIBREWEIGHT
Calculated	TQuery
FibreStkQueryDatabaseNameStockSQL.Strings>select ynstru, yntwist, yncol, lotno1||'/'||lotno2, sum(ynnet)from vbyarnrcptwhere batref = 0/group by ynstru, yntwist, yncol, lotno1, lotno2/order by ynstru, yntwist, yncol, lotno1, lotno2Left(TopTStringFieldFibreStkQueryYNSTRUDisplayLabelStruDisplayWidth	FieldNameYNSTRUSizeTStringFieldFibreStkQueryYNTWISTDisplayLabelTw	FieldNameYNTWISTSizeTStringFieldFibreStkQueryYNCOLDisplayLabelColDisplayWidth	FieldNameYNCOLSizeTStringFieldFibreStkQueryCOLUMN4DisplayLabelLot NoDisplayWidth	FieldNameCOLUMN4SizeTFloatFieldFibreStkQuerySUMDisplayLabelStk (Kg)DisplayWidth	FieldNameSUM
DisplayFormat0.0TDataSource	StkSourceLeftHTopTQueryAcrylicReqQueryDatabaseNameStockSQL.Stringsselect sum(rmperkg) acrylreqfrom ynstruwbsrmwhere ynstru=:ynstruand yntwist=:yntwistAand (ctrlacct='ACRWIP' or ctrlacct='ACRDOP' or ctrlacct='COTTON')Params.Data
&ynstruB090yntwist1Left`TopiTFloatFieldAcrylicReqQueryACRYLREQ	FieldNameACRYLREQ
DisplayFormat0.000TQueryTotalEndsQueryDatabaseNameStockSQL.Stringsselect sum(numends)
from yncolwbswhere yncol=:yncolParams.Data
YNCOLBU9Left Topi
TIntegerFieldTotalEndsQuerySUM	FieldNameSUMTQuery
YnColWBSQueryDatabaseNameStockSQL.Stringsselect fibre,numends
from yncolwbswhere yncol=:yncolParams.Data
yncolBU9Left€TopiTStringFieldYnColWBSQueryFIBRE	FieldNameFIBRESizeTSmallintFieldYnColWBSQueryNUMENDS	FieldNameNUMENDSTQueryReqQueryOnCalcFieldsReqQueryCalcFieldsDatabaseNameSpinningSQL.Stringsselect sj.startdate, yc.fibre,2  sum(si.weight) * sum(ys.rmperkg) * yc.numends / >    (select sum(numends) from yncolwbs where yncol = si.color)  as fibreweight9from spinjob sj, spinitem si, yncolwbs yc, ynstruwbsrm ysCwhere sj.scenariono = :ScenarioNo and si.scenariono = sj.scenariono  and si.color = yc.yncol5  and si.struct = ys.ynstru and si.twist = ys.yntwist1  and ys.ctrlacct in ("ACRWIP","ACRDOP","COTTON")group by sj.startdate, yc.fibreParams.Data

ScenarioNoLeft(TopØTQueryQuery1DatabaseNameSpinningSQL.Stringsselect sj.startdate, yc.fibre,#  (sum(si.weight) * sum(ys.rmperkg);    * (select numends from yncolwbs where fibre = yc.fibre)@    / (select sum(numends) from yncolwbs where yncol = si.color)  ) as fibrewgt9from spinjob sj, spinitem si, yncolwbs yc, ynstruwbsrm ysCwhere sj.scenariono = :ScenarioNo and si.scenariono = sj.scenariono  and si.color = yc.yncol5  and si.struct = ys.ynstru and si.twist = ys.yntwist1  and ys.ctrlacct in ("ACRWIP","ACRDOP","COTTON")group by sj.startdate, yc.fibreParams.Data

ScenarioNoLeftPTopTQueryOldFibreReqQueryOnCalcFieldsReqQueryCalcFieldsDatabaseNameSpinningSQL.Strings;select sj.startdate, yc.fibre, sum(si.weight) as yarnweight)from spinjob sj, spinitem si, yncolwbs ycCwhere sj.scenariono = :ScenarioNo and si.scenariono = sj.scenariono   and si.color = yc.yncolgroup by sj.startdate, yc.fibreParams.Data

ScenarioNoLeftxTop0TDateTimeFieldOldFibreReqQuerySTARTDATEDisplayLabelDateDisplayWidth	FieldName	STARTDATETStringFieldOldFibreReqQueryFIBREDisplayLabelFibre	FieldNameFIBRESize
TIntegerFieldOldFibreReqQueryYARNWEIGHT	FieldName
YARNWEIGHTVisibleTFloatFieldOldFibreReqQueryFIBREWEIGHTDisplayLabelWgtDisplayWidth	FieldNameFIBREWEIGHT
Calculated	TQueryOldYarnReqQueryOnCalcFieldsReqQueryCalcFieldsDatabaseNameSpinningSQL.StringsZselect sj.startdate, yc.fibre, si.struct, si.twist, si.color, sum(si.weight) as yarnweight)from spinjob sj, spinitem si, yncolwbs ycCwhere sj.scenariono = :ScenarioNo and si.scenariono = sj.scenariono   and si.color = yc.yncol>group by sj.startdate, yc.fibre, si.struct, si.twist, si.colorParams.Data

ScenarioNoLeftxTopPTDateTimeFieldOldYarnReqQuerySTARTDATEDisplayLabelDateDisplayWidth	FieldName	STARTDATETStringFieldOldYarnReqQueryFIBREDisplayLabelFibre	FieldNameFIBRESizeTStringFieldOldYarnReqQuerySTRUCTDisplayLabelStru	FieldNameSTRUCTSizeTStringFieldOldYarnReqQueryTWISTDisplayLabelTw	FieldNameTWISTSizeTStringFieldOldYarnReqQueryCOLORDisplayLabelCol	FieldNameCOLORSize
TIntegerFieldOldYarnReqQueryYARNWEIGHT	FieldName
YARNWEIGHTVisibleTFloatFieldOldYarnReqQueryFIBREWEIGHTDisplayLabelWgtDisplayWidth	FieldNameFIBREWEIGHT
Calculated	TQuery
FibreReqQueryOnCalcFieldsReqQueryCalcFieldsDatabaseNameSpinningSQL.Strings*select sj.startdate, yc.fibre, yc.numends,;  sum(si.weight) as yarnwgt, sum(ys.rmperkg) as totrmperkg,G  (select sum(numends) from yncolwbs where yncol = si.color) as totends9from spinjob sj, spinitem si, yncolwbs yc, ynstruwbsrm ysCwhere sj.scenariono = :ScenarioNo and si.scenariono = sj.scenariono  and si.color = yc.yncol5  and si.struct = ys.ynstru and si.twist = ys.yntwist1  and ys.ctrlacct in ("ACRWIP","ACRDOP","COTTON")+group by sj.startdate, yc.fibre, yc.numendsParams.Data

ScenarioNoLeftÈTopÐTDateTimeFieldFibreReqQuerySTARTDATEDisplayLabelDateDisplayWidth	FieldName	STARTDATETStringFieldFibreReqQueryFIBREDisplayLabelFibreDisplayWidth	FieldNameFIBRESizeTSmallintFieldFibreReqQueryNUMENDS	FieldNameNUMENDSVisible
TIntegerFieldFibreReqQueryYARNWGT	FieldNameYARNWGTVisibleTFloatFieldFibreReqQueryTOTRMPERKG	FieldName
TOTRMPERKGVisible
TIntegerFieldFibreReqQueryTOTENDS	FieldNameTOTENDSVisibleTFloatFieldFibreReqQueryFIBREWGTDisplayLabelWgtDisplayWidth	FieldNameFIBREWGT
Calculated	TQueryYarnReqQueryOnCalcFieldsReqQueryCalcFieldsDatabaseNameSpinningSQL.StringsIselect sj.startdate, yc.fibre, si.struct, si.twist, si.color, yc.numends,;  sum(si.weight) as yarnwgt, sum(ys.rmperkg) as totrmperkg,G  (select sum(numends) from yncolwbs where yncol = si.color) as totends9from spinjob sj, spinitem si, yncolwbs yc, ynstruwbsrm ysCwhere sj.scenariono = :ScenarioNo and si.scenariono = sj.scenariono  and si.color = yc.yncol5  and si.struct = ys.ynstru and si.twist = ys.yntwist1  and ys.ctrlacct in ("ACRWIP","ACRDOP","COTTON")Jgroup by sj.startdate, yc.fibre, yc.numends, si.struct, si.twist, si.colorParams.Data

ScenarioNoLeftÈTopðTDateTimeFieldYarnReqQuerySTARTDATEDisplayLabelDateDisplayWidth	FieldName	STARTDATETStringFieldYarnReqQueryFIBREDisplayLabelFibreDisplayWidth	FieldNameFIBRESizeTStringFieldYarnReqQuerySTRUCTDisplayLabelStruDisplayWidth	FieldNameSTRUCTSizeTStringFieldYarnReqQueryTWISTDisplayLabelTwDisplayWidth	FieldNameTWISTSizeTStringFieldYarnReqQueryCOLORDisplayLabelColDisplayWidth	FieldNameCOLORSizeTSmallintFieldYarnReqQueryNUMENDS	FieldNameNUMENDSVisible
TIntegerFieldYarnReqQueryYARNWGT	FieldNameYARNWGTVisibleTFloatFieldYarnReqQueryTOTRMPERKG	FieldName
TOTRMPERKGVisible
TIntegerFieldYarnReqQueryTOTENDS	FieldNameTOTENDSVisibleTFloatFieldYarnReqQueryFIBREWGTDisplayLabelWgtDisplayWidth	FieldNameFIBREWGT
Calculated	