ReportName = Work Order List With Estimates ReportGroup = Maintenance object ppReport1: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.WoMaster NoDataBehaviors = [ndBlankReport] PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Work Orders List With Estimates' PrinterSetup.PaperName = 'Letter' PrinterSetup.PrinterName = 'HP LaserJet 1022' PrinterSetup.mmMarginBottom = 6350 PrinterSetup.mmMarginLeft = 6350 PrinterSetup.mmMarginRight = 6350 PrinterSetup.mmMarginTop = 6350 PrinterSetup.mmPaperHeight = 279401 PrinterSetup.mmPaperWidth = 215900 PrinterSetup.PaperSize = 1 SaveAsTemplate = True Template.DatabaseSettings.DataPipeline = dpReports Template.DatabaseSettings.Name = 'Work Order List With Estimates' Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.FileName = 'Work Orders List With Estimates.rtm' Template.SaveTo = stDatabase Template.Format = ftASCII AllowPrintToFile = True DeviceType = 'Screen' EmailSettings.ReportFormat = 'PDF' EmailSettings.Enabled = True EmailSettings.PreviewInEmailClient = False EmailSettings.ShowEmailDialog = True OutlineSettings.CreateNode = True OutlineSettings.CreatePageNodes = True OutlineSettings.Enabled = False OutlineSettings.Visible = False PreviewFormSettings.ZoomSetting = zs100Percent SavePrinterSetup = True TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = True Left = 218 Top = 155 Version = '10.05' mmColumnWidth = 0 DataPipelineName = 'WoMaster' object ppTitleBand1: TppTitleBand mmBottomOffset = 0 mmHeight = 10848 mmPrintPosition = 0 object ppLabel1: TppLabel UserName = 'Label1' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Work Order List With Estimates' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 20 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 8202 mmLeft = 1323 mmTop = 1323 mmWidth = 100542 BandType = 1 end end object ppHeaderBand1: TppHeaderBand mmBottomOffset = 0 mmHeight = 7408 mmPrintPosition = 0 object ppLine1: TppLine UserName = 'Line1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Pen.Color = clNavy Pen.Width = 2 Weight = 1.500000000000000000 mmHeight = 3969 mmLeft = 1323 mmTop = 6085 mmWidth = 200555 BandType = 0 end object ppLabel2: TppLabel UserName = 'Label2' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'WO #' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 1323 mmTop = 1323 mmWidth = 9525 BandType = 0 end object ppLabel3: TppLabel UserName = 'Label3' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = ' Unit Name' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 34131 mmTop = 1323 mmWidth = 57944 BandType = 0 end object ppLabel4: TppLabel UserName = 'Label4' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Scheduled' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 12171 mmTop = 1323 mmWidth = 21960 BandType = 0 end object ppLabel5: TppLabel UserName = 'Label5' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Employee' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 93927 mmTop = 1323 mmWidth = 20638 BandType = 0 end object ppLabel6: TppLabel UserName = 'Label6' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Service Description' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 118269 mmTop = 1323 mmWidth = 40746 BandType = 0 end object ppLabel7: TppLabel UserName = 'Label7' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Est. Labor' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 4530 mmLeft = 162984 mmTop = 1323 mmWidth = 19844 BandType = 0 end object ppLabel8: TppLabel UserName = 'Label8' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Est. Cost' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 4530 mmLeft = 184150 mmTop = 1323 mmWidth = 17198 BandType = 0 end end object ppDetailBand1: TppDetailBand mmBottomOffset = 0 mmHeight = 4763 mmPrintPosition = 0 object ppDBText5: TppDBText UserName = 'DBText5' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Description' DataPipeline = daADOQueryDataView1.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3175 mmLeft = 88900 mmTop = 529 mmWidth = 72231 BandType = 4 end object ppDBText6: TppDBText UserName = 'DBText6' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'LaborEstimate' DataPipeline = daADOQueryDataView1.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3260 mmLeft = 169598 mmTop = 529 mmWidth = 13229 BandType = 4 end object ppDBText7: TppDBText UserName = 'DBText7' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'CostEstimate' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3260 mmLeft = 189707 mmTop = 529 mmWidth = 11642 BandType = 4 end end object ppFooterBand1: TppFooterBand mmBottomOffset = 0 mmHeight = 6350 mmPrintPosition = 0 object ppLine2: TppLine UserName = 'Line2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Pen.Color = clGray Pen.Width = 2 Weight = 1.500000000000000000 mmHeight = 3969 mmLeft = 1323 mmTop = 5027 mmWidth = 200555 BandType = 8 end object ppSystemVariable1: TppSystemVariable UserName = 'SystemVariable1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False VarType = vtPrintDateTime Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 3725 mmLeft = 1323 mmTop = 1323 mmWidth = 29125 BandType = 8 end object ppSystemVariable2: TppSystemVariable UserName = 'SystemVariable2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False VarType = vtPageNoDesc Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3725 mmLeft = 193411 mmTop = 1323 mmWidth = 8594 BandType = 8 end end object ppSummaryBand1: TppSummaryBand mmBottomOffset = 0 mmHeight = 8467 mmPrintPosition = 0 object ppLabel10: TppLabel UserName = 'Label10' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Grand Totals' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True mmHeight = 3260 mmLeft = 123825 mmTop = 2910 mmWidth = 16383 BandType = 7 end object ppLine4: TppLine UserName = 'Line4' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Weight = 0.750000000000000000 mmHeight = 2381 mmLeft = 123031 mmTop = 794 mmWidth = 79375 BandType = 7 end object ppDBCalc3: TppDBCalc UserName = 'DBCalc3' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'LaborEstimate' DataPipeline = daADOQueryDataView1.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3175 mmLeft = 166688 mmTop = 2910 mmWidth = 17198 BandType = 7 end object ppDBCalc4: TppDBCalc UserName = 'DBCalc4' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'CostEstimate' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3175 mmLeft = 185209 mmTop = 2910 mmWidth = 17198 BandType = 7 end end object ppGroup1: TppGroup BreakName = 'Numbered' DataPipeline = daADOQueryDataView1.WoMaster KeepTogether = True OutlineSettings.CreateNode = True UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'WoMaster' object ppGroupHeaderBand1: TppGroupHeaderBand mmBottomOffset = 0 mmHeight = 6615 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'DBText1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Numbered' DataPipeline = daADOQueryDataView1.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3175 mmLeft = 2117 mmTop = 2117 mmWidth = 9525 BandType = 3 GroupNo = 0 end object ppDBText3: TppDBText UserName = 'DBText3' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'ScheduledDate' DataPipeline = daADOQueryDataView1.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3175 mmLeft = 13758 mmTop = 2117 mmWidth = 13494 BandType = 3 GroupNo = 0 end object ppDBText2: TppDBText UserName = 'DBText2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'UnitName' DataPipeline = daADOQueryDataView1.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3175 mmLeft = 33867 mmTop = 2117 mmWidth = 57415 BandType = 3 GroupNo = 0 end object ppDBText4: TppDBText UserName = 'DBText4' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Employee' DataPipeline = daADOQueryDataView1.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3175 mmLeft = 93927 mmTop = 2117 mmWidth = 29369 BandType = 3 GroupNo = 0 end end object ppGroupFooterBand1: TppGroupFooterBand mmBottomOffset = 0 mmHeight = 10583 mmPrintPosition = 0 object ppLine3: TppLine UserName = 'Line3' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Weight = 0.750000000000000000 mmHeight = 2381 mmLeft = 122767 mmTop = 2117 mmWidth = 79375 BandType = 5 GroupNo = 0 end object ppLabel9: TppLabel UserName = 'Label9' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Work Order Totals' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True mmHeight = 3260 mmLeft = 122767 mmTop = 4233 mmWidth = 23283 BandType = 5 GroupNo = 0 end object ppDBCalc1: TppDBCalc UserName = 'DBCalc1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'LaborEstimate' DataPipeline = daADOQueryDataView1.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3175 mmLeft = 165629 mmTop = 4233 mmWidth = 17198 BandType = 5 GroupNo = 0 end object ppDBCalc2: TppDBCalc UserName = 'DBCalc2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'CostEstimate' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3175 mmLeft = 184150 mmTop = 4233 mmWidth = 17198 BandType = 5 GroupNo = 0 end end end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_WoMaster' Height = 360 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 264 AutoSearchTabOrder = 0 object WoMaster: TppChildDBPipeline AutoCreateFields = False UserName = 'WoMaster' object ppField1: TppField FieldAlias = 'CompletedDate' FieldName = 'CompletedDate' FieldLength = 0 DataType = dtDateTime DisplayWidth = 0 Position = 0 TableName = 'WoMaster' end object ppField2: TppField FieldAlias = 'Employee' FieldName = 'Employee' FieldLength = 35 DisplayWidth = 35 Position = 1 TableName = 'WoMaster' end object ppField3: TppField FieldAlias = 'Unit' FieldName = 'Unit' FieldLength = 0 DataType = dtDouble DisplayWidth = 0 Position = 2 TableName = 'WoMaster' end object ppField4: TppField FieldAlias = 'UnitName' FieldName = 'UnitName' FieldLength = 80 DisplayWidth = 80 Position = 3 TableName = 'WoMaster' end object ppField5: TppField FieldAlias = 'ScheduledDate' FieldName = 'ScheduledDate' FieldLength = 0 DataType = dtDateTime DisplayWidth = 0 Position = 4 TableName = 'WoMaster' end object ppField6: TppField FieldAlias = 'CostEstimate' FieldName = 'CostEstimate' FieldLength = 5 IsDetail = True DataType = dtDouble DisplayWidth = 5 Position = 5 TableName = 'WoServices' end object ppField7: TppField FieldAlias = 'CostCenter' FieldName = 'CostCenter' FieldLength = 15 IsDetail = True DisplayWidth = 15 Position = 6 TableName = 'WoServices' end object ppField8: TppField FieldAlias = 'Description' FieldName = 'Description' FieldLength = 60 IsDetail = True DisplayWidth = 60 Position = 7 TableName = 'WoServices' end object ppField9: TppField FieldAlias = 'LaborEstimate' FieldName = 'LaborEstimate' FieldLength = 5 IsDetail = True DataType = dtDouble DisplayWidth = 5 Position = 8 TableName = 'WoServices' end object ppField10: TppField FieldAlias = 'Numbered' FieldName = 'Numbered' FieldLength = 0 DataType = dtDouble DisplayWidth = 0 Position = 9 TableName = 'WoMaster' end end object daSQL1: TdaSQL GuidCollationType = gcMSSQLServer DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'WoMaster' LinkColor = clMaroon MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT WoMaster.CompletedDate, WoMaster.Employee, ' ' WoMaster.Unit, WoMaster.UnitName, ' ' WoMaster.ScheduledDate, ' ' WoServices.CostEstimate, ' ' WoServices.CostCenter, ' ' WoServices.Description, ' ' WoServices.LaborEstimate, WoMaster.Numbered' 'FROM WoMaster WoMaster' ' INNER JOIN WoServices WoServices ON ' ' (WoServices.WorkOrder = WoMaster.Numbered)' 'WHERE ( WoMaster.CompletedDate IS NULL )' 'ORDER BY WoMaster.ScheduledDate, ' ' WoMaster.Numbered, WoServices.ItemSeq, ' ' WoServices.RecordNumber') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Operator = dacoBlank object TdaField Alias = 'CompletedDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'CompletedDate' FieldLength = 0 FieldName = 'CompletedDate' SQLFieldName = 'CompletedDate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end end object daField1: TdaField Alias = 'CompletedDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'CompletedDate' FieldLength = 0 FieldName = 'CompletedDate' SQLFieldName = 'CompletedDate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField2: TdaField Alias = 'Employee' DisplayWidth = 35 FieldAlias = 'Employee' FieldLength = 35 FieldName = 'Employee' SQLFieldName = 'Employee' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField3: TdaField Alias = 'Unit' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Unit' FieldLength = 0 FieldName = 'Unit' SQLFieldName = 'Unit' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField4: TdaField Alias = 'UnitName' DisplayWidth = 80 FieldAlias = 'UnitName' FieldLength = 80 FieldName = 'UnitName' SQLFieldName = 'UnitName' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField5: TdaField Alias = 'ScheduledDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'ScheduledDate' FieldLength = 0 FieldName = 'ScheduledDate' SQLFieldName = 'ScheduledDate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField6: TdaField Alias = 'CostEstimate' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'CostEstimate' FieldLength = 5 FieldName = 'CostEstimate' IsDetail = True SQLFieldName = 'CostEstimate' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField7: TdaField Alias = 'CostCenter' DisplayWidth = 15 FieldAlias = 'CostCenter' FieldLength = 15 FieldName = 'CostCenter' IsDetail = True SQLFieldName = 'CostCenter' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField8: TdaField Alias = 'Description' DisplayWidth = 60 FieldAlias = 'Description' FieldLength = 60 FieldName = 'Description' IsDetail = True SQLFieldName = 'Description' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField9: TdaField Alias = 'LaborEstimate' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'LaborEstimate' FieldLength = 5 FieldName = 'LaborEstimate' IsDetail = True SQLFieldName = 'LaborEstimate' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField10: TdaField Alias = 'Numbered' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Numbered' FieldLength = 0 FieldName = 'Numbered' SQLFieldName = 'Numbered' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField11: TdaField ChildType = 2 Alias = 'ScheduledDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'ScheduledDate' FieldLength = 0 FieldName = 'ScheduledDate' SQLFieldName = 'ScheduledDate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField12: TdaField ChildType = 2 Alias = 'Numbered' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Numbered' FieldLength = 0 FieldName = 'Numbered' SQLFieldName = 'Numbered' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField13: TdaField ChildType = 2 Alias = 'ItemSeq' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'ItemSeq' FieldLength = 0 FieldName = 'ItemSeq' SQLFieldName = 'ItemSeq' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField14: TdaField ChildType = 2 Alias = 'RecordNumber' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'RecordNumber' FieldLength = 0 FieldName = 'RecordNumber' SQLFieldName = 'RecordNumber' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daTable1: TdaTable ChildType = 5 Alias = 'WoMaster' JoinType = dajtNone SQLAlias = 'WoMaster' TableAlias = 'WoMaster' TableName = 'WoMaster' end object daTable2: TdaTable ChildType = 5 Alias = 'WoServices' SQLAlias = 'WoServices' TableAlias = 'WoServices' TableName = 'WoServices' object daTableJoin1: TdaTableJoin ChildType = 6 object daField16: TdaField ChildType = 3 Alias = 'WorkOrder' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'WorkOrder' FieldLength = 0 FieldName = 'WorkOrder' SQLFieldName = 'WorkOrder' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField15: TdaField ChildType = 4 Alias = 'Numbered' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Numbered' FieldLength = 0 FieldName = 'Numbered' SQLFieldName = 'Numbered' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end end end end end end object ppParameterList1: TppParameterList end end