object ppReport: TppReport
  AutoStop = False
  DataPipeline = daFIBQueryDataView2.DocumentosCompras
  PassSetting = psTwoPass
  PrinterSetup.BinName = 'Default'
  PrinterSetup.DocumentName = 'Report'
  PrinterSetup.PaperName = 'Letter'
  PrinterSetup.PrinterName = 'Default'
  PrinterSetup.mmMarginBottom = 12700
  PrinterSetup.mmMarginLeft = 6350
  PrinterSetup.mmMarginRight = 6350
  PrinterSetup.mmMarginTop = 6350
  PrinterSetup.mmPaperHeight = 279401
  PrinterSetup.mmPaperWidth = 215900
  PrinterSetup.PaperSize = 169
  SaveAsTemplate = True
  Template.DatabaseSettings.DataPipeline = plRBItem
  Template.DatabaseSettings.Name = 'Orden de Compra  en Reportes'
  Template.DatabaseSettings.NameField = 'NAME'
  Template.DatabaseSettings.TemplateField = 'TEMPLATE'
  Template.FileName = 
    'C:\Program Files\Microsip\2010\Reportes y formas muestra\Reporte' +
    's\orden de compras en Reportes.rtm'
  Template.Format = ftASCII
  Units = utScreenPixels
  AllowPrintToFile = True
  DeviceType = 'Screen'
  EmailSettings.ReportFormat = 'PDF'
  Language = lgSpanishMexico
  OutlineSettings.CreateNode = True
  OutlineSettings.CreatePageNodes = True
  OutlineSettings.Enabled = False
  OutlineSettings.Visible = False
  ShowAutoSearchDialog = True
  TextSearchSettings.DefaultString = '<HallarTexto>'
  TextSearchSettings.Enabled = False
  Left = 4
  Top = 208
  Version = '10.08'
  mmColumnWidth = 0
  DataPipelineName = 'DocumentosCompras'
  object ppHeaderBand1: TppHeaderBand
    mmBottomOffset = 1058
    mmHeight = 18785
    mmPrintPosition = 0
    object ppDBText1: TppDBText
      UserName = 'dbtNombreEmpresa'
      AutoSize = True
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'NOMBRE'
      DataPipeline = daFIBQueryDataView1.DatosEmpresa
      Font.Charset = ANSI_CHARSET
      Font.Color = clBlack
      Font.Name = 'Tahoma'
      Font.Size = 12
      Font.Style = []
      ParentDataPipeline = False
      TextAlignment = taCentered
      Transparent = True
      DataPipelineName = 'DatosEmpresa'
      mmHeight = 5027
      mmLeft = 93398
      mmTop = 0
      mmWidth = 16404
      BandType = 0
    end
    object ppLabel1: TppLabel
      UserName = 'lblTitulo'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'ORDEN DE COMPRA'
      Font.Charset = ANSI_CHARSET
      Font.Color = clBlack
      Font.Name = 'Tahoma'
      Font.Size = 16
      Font.Style = [fsBold]
      TextAlignment = taCentered
      Transparent = True
      mmHeight = 6773
      mmLeft = 73319
      mmTop = 6085
      mmWidth = 56303
      BandType = 0
    end
    object ppLabel3: TppLabel
      UserName = 'lblCol1'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Clave'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'Tahoma'
      Font.Size = 8
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 3440
      mmLeft = 0
      mmTop = 14552
      mmWidth = 26458
      BandType = 0
    end
    object ppLabel4: TppLabel
      UserName = 'lblCol2'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Precio Total'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'Tahoma'
      Font.Size = 8
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 3440
      mmLeft = 179388
      mmTop = 14552
      mmWidth = 17727
      BandType = 0
    end
    object ppLine1: TppLine
      UserName = 'linEncabezado'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Position = lpBottom
      Weight = 0.750000000000000000
      mmHeight = 1588
      mmLeft = 529
      mmTop = 17198
      mmWidth = 203200
      BandType = 0
    end
    object ppLabel2: TppLabel
      UserName = 'Label2'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Descripci'#243'n'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'Tahoma'
      Font.Size = 8
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 3440
      mmLeft = 39688
      mmTop = 14552
      mmWidth = 26458
      BandType = 0
    end
    object ppLabel5: TppLabel
      UserName = 'Label5'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'unidades'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'Tahoma'
      Font.Size = 8
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 3440
      mmLeft = 125942
      mmTop = 14552
      mmWidth = 14817
      BandType = 0
    end
    object ppLabel6: TppLabel
      UserName = 'Label6'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'precio'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'Tahoma'
      Font.Size = 8
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 3440
      mmLeft = 144992
      mmTop = 14552
      mmWidth = 12435
      BandType = 0
    end
    object ppLabel7: TppLabel
      UserName = 'Label7'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Desc.'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'Tahoma'
      Font.Size = 8
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 3440
      mmLeft = 165365
      mmTop = 14552
      mmWidth = 9260
      BandType = 0
    end
    object ppLabel8: TppLabel
      UserName = 'Label1'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Folio'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = 'Arial'
      Font.Size = 8
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 3387
      mmLeft = 2910
      mmTop = 5292
      mmWidth = 20108
      BandType = 0
    end
    object ppDBText8: TppDBText
      UserName = 'DBText7'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'FOLIO'
      DataPipeline = daFIBQueryDataView2.DocumentosCompras
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Name = 'Tahoma'
      Font.Size = 8
      Font.Style = []
      Transparent = True
      DataPipelineName = 'DocumentosCompras'
      mmHeight = 3440
      mmLeft = 2910
      mmTop = 9260
      mmWidth = 20108
      BandType = 0
    end
    object ppLabel9: TppLabel
      UserName = 'Label3'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Fecha del documento'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = 'Arial'
      Font.Size = 8
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 3440
      mmLeft = 161132
      mmTop = 5027
      mmWidth = 32279
      BandType = 0
    end
    object ppDBText9: TppDBText
      UserName = 'DBText8'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'FECHA'
      DataPipeline = daFIBQueryDataView2.DocumentosCompras
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Name = 'Tahoma'
      Font.Size = 8
      Font.Style = []
      Transparent = True
      DataPipelineName = 'DocumentosCompras'
      mmHeight = 3440
      mmLeft = 161132
      mmTop = 9260
      mmWidth = 28310
      BandType = 0
    end
  end
  object ppDetailBand1: TppDetailBand
    mmBottomOffset = 1058
    mmHeight = 3440
    mmPrintPosition = 0
    object ppDBText3: TppDBText
      UserName = 'DBText1'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'CLAVE_ARTICULO'
      DataPipeline = daFIBQueryDataView2.DocumentosCompras
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Name = 'Tahoma'
      Font.Size = 8
      Font.Style = []
      Transparent = True
      DataPipelineName = 'DocumentosCompras'
      mmHeight = 3440
      mmLeft = 0
      mmTop = 0
      mmWidth = 35983
      BandType = 4
    end
    object ppDBText2: TppDBText
      UserName = 'DBText2'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'UNIDADES'
      DataPipeline = daFIBQueryDataView2.DocumentosCompras
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Name = 'Tahoma'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = 'DocumentosCompras'
      mmHeight = 3429
      mmLeft = 125942
      mmTop = 0
      mmWidth = 9525
      BandType = 4
    end
    object ppDBText4: TppDBText
      UserName = 'DBText3'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'UMED'
      DataPipeline = daFIBQueryDataView2.DocumentosCompras
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Name = 'Tahoma'
      Font.Size = 8
      Font.Style = []
      Transparent = True
      DataPipelineName = 'DocumentosCompras'
      mmHeight = 3175
      mmLeft = 111125
      mmTop = 0
      mmWidth = 11642
      BandType = 4
    end
    object ppDBText5: TppDBText
      UserName = 'DBText4'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'PRECIO_UNITARIO'
      DataPipeline = daFIBQueryDataView2.DocumentosCompras
      DisplayFormat = '#,0.00;-#,0.00'
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Name = 'Tahoma'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = 'DocumentosCompras'
      mmHeight = 3440
      mmLeft = 137319
      mmTop = 0
      mmWidth = 16933
      BandType = 4
    end
    object ppDBText6: TppDBText
      UserName = 'DBText5'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'PRECIO_TOTAL_NETO'
      DataPipeline = daFIBQueryDataView2.DocumentosCompras
      DisplayFormat = '#,0.00;-#,0.00'
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Name = 'Tahoma'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = 'DocumentosCompras'
      mmHeight = 3440
      mmLeft = 178594
      mmTop = 0
      mmWidth = 20108
      BandType = 4
    end
    object ppDBText7: TppDBText
      UserName = 'DBText6'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'PCTJE_DSCTO'
      DataPipeline = daFIBQueryDataView2.DocumentosCompras
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Name = 'Tahoma'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = 'DocumentosCompras'
      mmHeight = 3440
      mmLeft = 161925
      mmTop = 0
      mmWidth = 12171
      BandType = 4
    end
    object ppDBText10: TppDBText
      UserName = 'DBText9'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'NOMBRE'
      DataPipeline = daFIBQueryDataView2.DocumentosCompras
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Name = 'Tahoma'
      Font.Size = 8
      Font.Style = []
      Transparent = True
      DataPipelineName = 'DocumentosCompras'
      mmHeight = 3440
      mmLeft = 39688
      mmTop = 0
      mmWidth = 67998
      BandType = 4
    end
  end
  object ppFooterBand1: TppFooterBand
    mmBottomOffset = 0
    mmHeight = 5821
    mmPrintPosition = 0
    object svFecha: TppSystemVariable
      UserName = 'svFecha'
      SaveOrder = 0
      Save = True
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      VarType = vtPrintDateTime
      DisplayFormat = 'd/mmmm/yyyy h:nn:ss AM/PM'
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Name = 'Tahoma'
      Font.Size = 7
      Font.Style = []
      Transparent = True
      mmHeight = 2910
      mmLeft = 1058
      mmTop = 2910
      mmWidth = 27781
      BandType = 8
    end
    object svPage: TppSystemVariable
      UserName = 'svPagina'
      SaveOrder = 1
      Save = True
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      VarType = vtPageNoDesc
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Name = 'Tahoma'
      Font.Size = 7
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 2963
      mmLeft = 190712
      mmTop = 2910
      mmWidth = 9313
      BandType = 8
    end
  end
  object daDataModule1: TdaDataModule
    object daFIBQueryDataView1: TdaFIBQueryDataView
      UserName = 'Query_DatosEmpresa'
      Height = 347
      Left = 10
      NameColumnWidth = 105
      SizeColumnWidth = 35
      SortMode = 0
      Top = 10
      TypeColumnWidth = 52
      Width = 200
      AutoSearchTabOrder = 0
      object DatosEmpresa: TppChildDBPipeline
        AutoCreateFields = False
        UserName = 'DatosEmpresa'
        object ppField1: TppField
          FieldAlias = 'NOMBRE'
          FieldName = 'NOMBRE'
          FieldLength = 100
          DisplayWidth = 100
          Position = 0
        end
        object ppField2: TppField
          FieldAlias = 'CALLE'
          FieldName = 'CALLE'
          FieldLength = 100
          DisplayWidth = 100
          Position = 1
        end
        object ppField3: TppField
          FieldAlias = 'CIUDAD'
          FieldName = 'CIUDAD'
          FieldLength = 50
          DisplayWidth = 50
          Position = 2
        end
        object ppField4: TppField
          FieldAlias = 'ESTADO'
          FieldName = 'ESTADO'
          FieldLength = 50
          DisplayWidth = 50
          Position = 3
        end
        object ppField5: TppField
          FieldAlias = 'CODIGO_POSTAL'
          FieldName = 'CODIGO_POSTAL'
          FieldLength = 10
          DisplayWidth = 10
          Position = 4
        end
        object ppField6: TppField
          FieldAlias = 'PAIS'
          FieldName = 'PAIS'
          FieldLength = 50
          DisplayWidth = 50
          Position = 5
        end
        object ppField7: TppField
          FieldAlias = 'TELEFONO1'
          FieldName = 'TELEFONO1'
          FieldLength = 35
          DisplayWidth = 35
          Position = 6
        end
        object ppField8: TppField
          FieldAlias = 'TELEFONO2'
          FieldName = 'TELEFONO2'
          FieldLength = 35
          DisplayWidth = 35
          Position = 7
        end
        object ppField9: TppField
          FieldAlias = 'FAX'
          FieldName = 'FAX'
          FieldLength = 35
          DisplayWidth = 35
          Position = 8
        end
        object ppField10: TppField
          FieldAlias = 'EMAIL'
          FieldName = 'EMAIL'
          FieldLength = 60
          DisplayWidth = 60
          Position = 9
        end
        object ppField11: TppField
          FieldAlias = 'RFC'
          FieldName = 'RFC'
          FieldLength = 18
          DisplayWidth = 18
          Position = 10
        end
        object ppField12: TppField
          FieldAlias = 'REG_IMSS'
          FieldName = 'REG_IMSS'
          FieldLength = 18
          DisplayWidth = 18
          Position = 11
        end
        object ppField13: TppField
          FieldAlias = 'REG_INFONAVIT'
          FieldName = 'REG_INFONAVIT'
          FieldLength = 18
          DisplayWidth = 18
          Position = 12
        end
        object ppField14: TppField
          FieldAlias = 'OTRO_REG1'
          FieldName = 'OTRO_REG1'
          FieldLength = 18
          DisplayWidth = 18
          Position = 13
        end
        object ppField15: TppField
          FieldAlias = 'OTRO_REG2'
          FieldName = 'OTRO_REG2'
          FieldLength = 18
          DisplayWidth = 18
          Position = 14
        end
      end
      object daSQL1: TdaSQL
        DatabaseName = 'dtbsMicrosip'
        DatabaseType = dtInterBase
        DataPipelineName = 'DatosEmpresa'
        EditSQLAsText = True
        LinkColor = clBlack
        MaxSQLFieldAliasLength = 0
        SQLText.Strings = (
          'SELECT * FROM DATOS_EMPRESA')
        SQLType = sqSQL2
        object daField1: TdaField
          Alias = 'NOMBRE'
          DisplayWidth = 100
          FieldAlias = 'NOMBRE'
          FieldLength = 100
          FieldName = 'NOMBRE'
          SQLFieldName = 'NOMBRE'
        end
        object daField2: TdaField
          Alias = 'CALLE'
          DisplayWidth = 100
          FieldAlias = 'CALLE'
          FieldLength = 100
          FieldName = 'CALLE'
          SQLFieldName = 'CALLE'
        end
        object daField3: TdaField
          Alias = 'CIUDAD'
          DisplayWidth = 50
          FieldAlias = 'CIUDAD'
          FieldLength = 50
          FieldName = 'CIUDAD'
          SQLFieldName = 'CIUDAD'
        end
        object daField4: TdaField
          Alias = 'ESTADO'
          DisplayWidth = 50
          FieldAlias = 'ESTADO'
          FieldLength = 50
          FieldName = 'ESTADO'
          SQLFieldName = 'ESTADO'
        end
        object daField5: TdaField
          Alias = 'CODIGO_POSTAL'
          DisplayWidth = 10
          FieldAlias = 'CODIGO_POSTAL'
          FieldLength = 10
          FieldName = 'CODIGO_POSTAL'
          SQLFieldName = 'CODIGO_POSTAL'
        end
        object daField6: TdaField
          Alias = 'PAIS'
          DisplayWidth = 50
          FieldAlias = 'PAIS'
          FieldLength = 50
          FieldName = 'PAIS'
          SQLFieldName = 'PAIS'
        end
        object daField7: TdaField
          Alias = 'TELEFONO1'
          DisplayWidth = 35
          FieldAlias = 'TELEFONO1'
          FieldLength = 35
          FieldName = 'TELEFONO1'
          SQLFieldName = 'TELEFONO1'
        end
        object daField8: TdaField
          Alias = 'TELEFONO2'
          DisplayWidth = 35
          FieldAlias = 'TELEFONO2'
          FieldLength = 35
          FieldName = 'TELEFONO2'
          SQLFieldName = 'TELEFONO2'
        end
        object daField9: TdaField
          Alias = 'FAX'
          DisplayWidth = 35
          FieldAlias = 'FAX'
          FieldLength = 35
          FieldName = 'FAX'
          SQLFieldName = 'FAX'
        end
        object daField10: TdaField
          Alias = 'EMAIL'
          DisplayWidth = 60
          FieldAlias = 'EMAIL'
          FieldLength = 60
          FieldName = 'EMAIL'
          SQLFieldName = 'EMAIL'
        end
        object daField11: TdaField
          Alias = 'RFC'
          DisplayWidth = 18
          FieldAlias = 'RFC'
          FieldLength = 18
          FieldName = 'RFC'
          SQLFieldName = 'RFC'
        end
        object daField12: TdaField
          Alias = 'REG_IMSS'
          DisplayWidth = 18
          FieldAlias = 'REG_IMSS'
          FieldLength = 18
          FieldName = 'REG_IMSS'
          SQLFieldName = 'REG_IMSS'
        end
        object daField13: TdaField
          Alias = 'REG_INFONAVIT'
          DisplayWidth = 18
          FieldAlias = 'REG_INFONAVIT'
          FieldLength = 18
          FieldName = 'REG_INFONAVIT'
          SQLFieldName = 'REG_INFONAVIT'
        end
        object daField14: TdaField
          Alias = 'OTRO_REG1'
          DisplayWidth = 18
          FieldAlias = 'OTRO_REG1'
          FieldLength = 18
          FieldName = 'OTRO_REG1'
          SQLFieldName = 'OTRO_REG1'
        end
        object daField15: TdaField
          Alias = 'OTRO_REG2'
          DisplayWidth = 18
          FieldAlias = 'OTRO_REG2'
          FieldLength = 18
          FieldName = 'OTRO_REG2'
          SQLFieldName = 'OTRO_REG2'
        end
      end
    end
    object daFIBQueryDataView2: TdaFIBQueryDataView
      UserName = 'Query_DocumentosCompras'
      Height = 497
      Left = 260
      NameColumnWidth = 195
      SizeColumnWidth = 35
      SortMode = 0
      Top = 10
      TypeColumnWidth = 52
      Width = 351
      AutoSearchTabOrder = 0
      object DocumentosCompras: TppChildDBPipeline
        AutoCreateFields = False
        UserName = 'DocumentosCompras'
        object ppField1: TppField
          FieldAlias = 'Docto Cm Id'
          FieldName = 'DOCTO_CM_ID'
          FieldLength = 0
          DataType = dtInteger
          DisplayWidth = 0
          Position = 0
          TableName = 'DOCTOS_CM_1'
        end
        object ppField2: TppField
          FieldAlias = 'Tipo de documento'
          FieldName = 'TIPO_DOCTO'
          FieldLength = 1
          DisplayWidth = 1
          Position = 1
          TableName = 'DOCTOS_CM_1'
        end
        object ppField3: TppField
          FieldAlias = 'Folio'
          FieldName = 'FOLIO'
          FieldLength = 9
          DisplayWidth = 9
          Position = 2
          TableName = 'DOCTOS_CM_1'
        end
        object ppField4: TppField
          FieldAlias = 'Fecha del documento'
          FieldName = 'FECHA'
          FieldLength = 0
          DataType = dtDate
          DisplayWidth = 0
          Position = 3
          TableName = 'DOCTOS_CM_1'
        end
        object ppField5: TppField
          FieldAlias = 'Clave del proveedor'
          FieldName = 'CLAVE_PROV'
          FieldLength = 20
          DisplayWidth = 20
          Position = 4
          TableName = 'DOCTOS_CM_1'
        end
        object ppField6: TppField
          FieldAlias = 'Proveedor Id'
          FieldName = 'PROVEEDOR_ID'
          FieldLength = 0
          DataType = dtInteger
          DisplayWidth = 0
          Position = 5
          TableName = 'DOCTOS_CM_1'
        end
        object ppField7: TppField
          FieldAlias = 'Folio del docto del proveedor'
          FieldName = 'FOLIO_PROV'
          FieldLength = 9
          DisplayWidth = 9
          Position = 6
          TableName = 'DOCTOS_CM_1'
        end
        object ppField8: TppField
          FieldAlias = 'Almacen Id'
          FieldName = 'ALMACEN_ID'
          FieldLength = 0
          DataType = dtInteger
          DisplayWidth = 0
          Position = 7
          TableName = 'DOCTOS_CM_1'
        end
        object ppField9: TppField
          FieldAlias = 'Clave del art'#237'culo'
          FieldName = 'CLAVE_ARTICULO'
          FieldLength = 20
          IsDetail = True
          DisplayWidth = 20
          Position = 8
          TableName = 'DOCTOS_CM_DET_1'
        end
        object ppField10: TppField
          FieldAlias = 'Art'#237'culo Id'
          FieldName = 'ARTICULO_ID'
          FieldLength = 0
          IsDetail = True
          DataType = dtInteger
          DisplayWidth = 0
          Position = 9
          TableName = 'DOCTOS_CM_DET_1'
        end
        object ppField11: TppField
          FieldAlias = 'Unidades'
          FieldName = 'UNIDADES'
          FieldLength = 0
          IsDetail = True
          DataType = dtDouble
          DisplayWidth = 0
          Position = 10
          TableName = 'DOCTOS_CM_DET_1'
        end
        object ppField12: TppField
          FieldAlias = 'Unidades recibidas/devueltas'
          FieldName = 'UNIDADES_REC_DEV'
          FieldLength = 0
          IsDetail = True
          DataType = dtDouble
          DisplayWidth = 0
          Position = 11
          TableName = 'DOCTOS_CM_DET_1'
        end
        object ppField13: TppField
          FieldAlias = 'Unidad de medida'
          FieldName = 'UMED'
          FieldLength = 5
          IsDetail = True
          DisplayWidth = 5
          Position = 12
          TableName = 'DOCTOS_CM_DET_1'
        end
        object ppField14: TppField
          FieldAlias = 'Contenido de la unidad de medida'
          FieldName = 'CONTENIDO_UMED'
          FieldLength = 0
          IsDetail = True
          DataType = dtDouble
          DisplayWidth = 0
          Position = 13
          TableName = 'DOCTOS_CM_DET_1'
        end
        object ppField15: TppField
          FieldAlias = 'Precio unitario'
          FieldName = 'PRECIO_UNITARIO'
          FieldLength = 0
          IsDetail = True
          DataType = dtDouble
          DisplayWidth = 0
          Position = 14
          TableName = 'DOCTOS_CM_DET_1'
        end
        object ppField16: TppField
          FieldAlias = 'Descuento (%)'
          FieldName = 'PCTJE_DSCTO'
          FieldLength = 0
          IsDetail = True
          DataType = dtDouble
          DisplayWidth = 0
          Position = 15
          TableName = 'DOCTOS_CM_DET_1'
        end
        object ppField17: TppField
          FieldAlias = 'Precio total neto'
          FieldName = 'PRECIO_TOTAL_NETO'
          FieldLength = 2
          IsDetail = True
          DataType = dtDouble
          DisplayWidth = 2
          Position = 16
          TableName = 'DOCTOS_CM_DET_1'
        end
        object ppField18: TppField
          FieldAlias = 'Unidades A Rec'
          FieldName = 'UNIDADES_A_REC'
          FieldLength = 0
          IsDetail = True
          DataType = dtDouble
          DisplayWidth = 0
          Position = 17
          TableName = 'DOCTOS_CM_DET_1'
        end
        object ppField19: TppField
          FieldAlias = 'Nombre del art'#237'culo'
          FieldName = 'NOMBRE'
          FieldLength = 100
          IsDetail = True
          DisplayWidth = 100
          Position = 18
          TableName = 'ARTICULOS_1'
        end
      end
      object daSQL2: TdaSQL
        CollationType = ctASCII
        DatabaseName = 'dtbsMicrosip'
        DatabaseType = dtInterBase
        DataPipelineName = 'DocumentosCompras'
        IsCaseSensitive = True
        LinkColor = clMaroon
        MaxSQLFieldAliasLength = 25
        SQLText.Strings = (
          'SELECT DOCTOS_CM_1.DOCTO_CM_ID, '
          '       DOCTOS_CM_1.TIPO_DOCTO, DOCTOS_CM_1.FOLIO, '
          '       DOCTOS_CM_1.FECHA, DOCTOS_CM_1.CLAVE_PROV, '
          '       DOCTOS_CM_1.PROVEEDOR_ID, '
          '       DOCTOS_CM_1.FOLIO_PROV, '
          '       DOCTOS_CM_1.ALMACEN_ID, '
          '       DOCTOS_CM_DET_1.CLAVE_ARTICULO, '
          '       DOCTOS_CM_DET_1.ARTICULO_ID, '
          '       DOCTOS_CM_DET_1.UNIDADES, '
          '       DOCTOS_CM_DET_1.UNIDADES_REC_DEV, '
          '       DOCTOS_CM_DET_1.UMED, '
          '       DOCTOS_CM_DET_1.CONTENIDO_UMED, '
          '       DOCTOS_CM_DET_1.PRECIO_UNITARIO, '
          '       DOCTOS_CM_DET_1.PCTJE_DSCTO, '
          '       DOCTOS_CM_DET_1.PRECIO_TOTAL_NETO, '
          '       DOCTOS_CM_DET_1.UNIDADES_A_REC, '
          '       ARTICULOS_1.NOMBRE'
          'FROM DOCTOS_CM DOCTOS_CM_1'
          '      INNER JOIN DOCTOS_CM_DET DOCTOS_CM_DET_1 ON '
          '     (DOCTOS_CM_DET_1.DOCTO_CM_ID = DOCTOS_CM_1.DOCTO_CM_ID)'
          '      INNER JOIN ARTICULOS ARTICULOS_1 ON '
          '     (ARTICULOS_1.ARTICULO_ID = DOCTOS_CM_DET_1.ARTICULO_ID)'
          'WHERE ('#39'c'#39' <> '#39'c'#39' ) AND ('
          '      ( DOCTOS_CM_1.TIPO_DOCTO = '#39'O'#39' )'
          '       AND ( DOCTOS_CM_1.FOLIO = '#39'000000296'#39' ))')
        SQLType = sqSQL2
        object daCriteria1: TdaCriteria
          ChildType = 7
          Level = 0
          Value = 'O'
          object TdaField
            Alias = 'Tipo de documento'
            DisplayWidth = 1
            FieldAlias = 'Tipo de documento'
            FieldLength = 1
            FieldName = 'TIPO_DOCTO'
            SQLFieldName = 'TIPO_DOCTO'
            TableAlias = 'DocumentosCompras'
            TableName = 'DOCTOS_CM'
            TableSQLAlias = 'DOCTOS_CM_1'
          end
        end
        object daCriteria2: TdaCriteria
          ChildType = 7
          Level = 0
          Value = '000000296'
          object TdaField
            Alias = 'Folio'
            AutoSearch = True
            DisplayWidth = 9
            FieldAlias = 'Folio'
            FieldLength = 9
            FieldName = 'FOLIO'
            Mandatory = True
            SQLFieldName = 'FOLIO'
            TableAlias = 'DocumentosCompras'
            TableName = 'DOCTOS_CM'
            TableSQLAlias = 'DOCTOS_CM_1'
          end
        end
        object daField1: TdaField
          Alias = 'Docto Cm Id'
          DataType = dtInteger
          DisplayWidth = 0
          FieldAlias = 'Docto Cm Id'
          FieldLength = 0
          FieldName = 'DOCTO_CM_ID'
          SQLFieldName = 'DOCTO_CM_ID'
          TableAlias = 'DocumentosCompras'
          TableName = 'DOCTOS_CM'
          TableSQLAlias = 'DOCTOS_CM_1'
        end
        object daField2: TdaField
          Alias = 'Tipo de documento'
          DisplayWidth = 1
          FieldAlias = 'Tipo de documento'
          FieldLength = 1
          FieldName = 'TIPO_DOCTO'
          SQLFieldName = 'TIPO_DOCTO'
          TableAlias = 'DocumentosCompras'
          TableName = 'DOCTOS_CM'
          TableSQLAlias = 'DOCTOS_CM_1'
        end
        object daField3: TdaField
          Alias = 'Folio'
          DisplayWidth = 9
          FieldAlias = 'Folio'
          FieldLength = 9
          FieldName = 'FOLIO'
          SQLFieldName = 'FOLIO'
          TableAlias = 'DocumentosCompras'
          TableName = 'DOCTOS_CM'
          TableSQLAlias = 'DOCTOS_CM_1'
        end
        object daField4: TdaField
          Alias = 'Fecha del documento'
          DataType = dtDate
          DisplayWidth = 0
          FieldAlias = 'Fecha del documento'
          FieldLength = 0
          FieldName = 'FECHA'
          SQLFieldName = 'FECHA'
          TableAlias = 'DocumentosCompras'
          TableName = 'DOCTOS_CM'
          TableSQLAlias = 'DOCTOS_CM_1'
        end
        object daField5: TdaField
          Alias = 'Clave del proveedor'
          DisplayWidth = 20
          FieldAlias = 'Clave del proveedor'
          FieldLength = 20
          FieldName = 'CLAVE_PROV'
          SQLFieldName = 'CLAVE_PROV'
          TableAlias = 'DocumentosCompras'
          TableName = 'DOCTOS_CM'
          TableSQLAlias = 'DOCTOS_CM_1'
        end
        object daField6: TdaField
          Alias = 'Proveedor Id'
          DataType = dtInteger
          DisplayWidth = 0
          FieldAlias = 'Proveedor Id'
          FieldLength = 0
          FieldName = 'PROVEEDOR_ID'
          SQLFieldName = 'PROVEEDOR_ID'
          TableAlias = 'DocumentosCompras'
          TableName = 'DOCTOS_CM'
          TableSQLAlias = 'DOCTOS_CM_1'
        end
        object daField7: TdaField
          Alias = 'Folio del docto del proveedor'
          DisplayWidth = 9
          FieldAlias = 'Folio del docto del proveedor'
          FieldLength = 9
          FieldName = 'FOLIO_PROV'
          SQLFieldName = 'FOLIO_PROV'
          TableAlias = 'DocumentosCompras'
          TableName = 'DOCTOS_CM'
          TableSQLAlias = 'DOCTOS_CM_1'
        end
        object daField8: TdaField
          Alias = 'Almacen Id'
          DataType = dtInteger
          DisplayWidth = 0
          FieldAlias = 'Almacen Id'
          FieldLength = 0
          FieldName = 'ALMACEN_ID'
          SQLFieldName = 'ALMACEN_ID'
          TableAlias = 'DocumentosCompras'
          TableName = 'DOCTOS_CM'
          TableSQLAlias = 'DOCTOS_CM_1'
        end
        object daField9: TdaField
          Alias = 'Clave del art'#237'culo'
          DisplayWidth = 20
          FieldAlias = 'Clave del art'#237'culo'
          FieldLength = 20
          FieldName = 'CLAVE_ARTICULO'
          IsDetail = True
          SQLFieldName = 'CLAVE_ARTICULO'
          TableAlias = 'DocumentosComprasDetalle'
          TableName = 'DOCTOS_CM_DET'
          TableSQLAlias = 'DOCTOS_CM_DET_1'
        end
        object daField10: TdaField
          Alias = 'Art'#237'culo Id'
          DataType = dtInteger
          DisplayWidth = 0
          FieldAlias = 'Art'#237'culo Id'
          FieldLength = 0
          FieldName = 'ARTICULO_ID'
          IsDetail = True
          SQLFieldName = 'ARTICULO_ID'
          TableAlias = 'DocumentosComprasDetalle'
          TableName = 'DOCTOS_CM_DET'
          TableSQLAlias = 'DOCTOS_CM_DET_1'
        end
        object daField11: TdaField
          Alias = 'Unidades'
          DataType = dtDouble
          DisplayWidth = 0
          FieldAlias = 'Unidades'
          FieldLength = 0
          FieldName = 'UNIDADES'
          IsDetail = True
          SQLFieldName = 'UNIDADES'
          TableAlias = 'DocumentosComprasDetalle'
          TableName = 'DOCTOS_CM_DET'
          TableSQLAlias = 'DOCTOS_CM_DET_1'
        end
        object daField12: TdaField
          Alias = 'Unidades recibidas/devueltas'
          DataType = dtDouble
          DisplayWidth = 0
          FieldAlias = 'Unidades recibidas/devueltas'
          FieldLength = 0
          FieldName = 'UNIDADES_REC_DEV'
          IsDetail = True
          SQLFieldName = 'UNIDADES_REC_DEV'
          TableAlias = 'DocumentosComprasDetalle'
          TableName = 'DOCTOS_CM_DET'
          TableSQLAlias = 'DOCTOS_CM_DET_1'
        end
        object daField13: TdaField
          Alias = 'Unidad de medida'
          DisplayWidth = 5
          FieldAlias = 'Unidad de medida'
          FieldLength = 5
          FieldName = 'UMED'
          IsDetail = True
          SQLFieldName = 'UMED'
          TableAlias = 'DocumentosComprasDetalle'
          TableName = 'DOCTOS_CM_DET'
          TableSQLAlias = 'DOCTOS_CM_DET_1'
        end
        object daField14: TdaField
          Alias = 'Contenido de la unidad de medida'
          DataType = dtDouble
          DisplayWidth = 0
          FieldAlias = 'Contenido de la unidad de medida'
          FieldLength = 0
          FieldName = 'CONTENIDO_UMED'
          IsDetail = True
          SQLFieldName = 'CONTENIDO_UMED'
          TableAlias = 'DocumentosComprasDetalle'
          TableName = 'DOCTOS_CM_DET'
          TableSQLAlias = 'DOCTOS_CM_DET_1'
        end
        object daField15: TdaField
          Alias = 'Precio unitario'
          DataType = dtDouble
          DisplayWidth = 0
          FieldAlias = 'Precio unitario'
          FieldLength = 0
          FieldName = 'PRECIO_UNITARIO'
          IsDetail = True
          SQLFieldName = 'PRECIO_UNITARIO'
          TableAlias = 'DocumentosComprasDetalle'
          TableName = 'DOCTOS_CM_DET'
          TableSQLAlias = 'DOCTOS_CM_DET_1'
        end
        object daField16: TdaField
          Alias = 'Descuento (%)'
          DataType = dtDouble
          DisplayWidth = 0
          FieldAlias = 'Descuento (%)'
          FieldLength = 0
          FieldName = 'PCTJE_DSCTO'
          IsDetail = True
          SQLFieldName = 'PCTJE_DSCTO'
          TableAlias = 'DocumentosComprasDetalle'
          TableName = 'DOCTOS_CM_DET'
          TableSQLAlias = 'DOCTOS_CM_DET_1'
        end
        object daField17: TdaField
          Alias = 'Precio total neto'
          DataType = dtDouble
          DisplayWidth = 2
          FieldAlias = 'Precio total neto'
          FieldLength = 2
          FieldName = 'PRECIO_TOTAL_NETO'
          IsDetail = True
          SQLFieldName = 'PRECIO_TOTAL_NETO'
          TableAlias = 'DocumentosComprasDetalle'
          TableName = 'DOCTOS_CM_DET'
          TableSQLAlias = 'DOCTOS_CM_DET_1'
        end
        object daField18: TdaField
          Alias = 'Unidades A Rec'
          DataType = dtDouble
          DisplayWidth = 0
          FieldAlias = 'Unidades A Rec'
          FieldLength = 0
          FieldName = 'UNIDADES_A_REC'
          IsDetail = True
          SQLFieldName = 'UNIDADES_A_REC'
          TableAlias = 'DocumentosComprasDetalle'
          TableName = 'DOCTOS_CM_DET'
          TableSQLAlias = 'DOCTOS_CM_DET_1'
        end
        object daField19: TdaField
          Alias = 'Nombre del art'#237'culo'
          DisplayWidth = 100
          FieldAlias = 'Nombre del art'#237'culo'
          FieldLength = 100
          FieldName = 'NOMBRE'
          IsDetail = True
          SQLFieldName = 'NOMBRE'
          TableAlias = 'Articulos'
          TableName = 'ARTICULOS'
          TableSQLAlias = 'ARTICULOS_1'
        end
        object daTable1: TdaTable
          ChildType = 5
          Alias = 'DocumentosCompras'
          JoinType = dajtNone
          SQLAlias = 'DOCTOS_CM_1'
          TableAlias = 'DocumentosCompras'
          TableName = 'DOCTOS_CM'
        end
        object daTable2: TdaTable
          ChildType = 5
          Alias = 'DocumentosComprasDetalle'
          SQLAlias = 'DOCTOS_CM_DET_1'
          TableAlias = 'DocumentosComprasDetalle'
          TableName = 'DOCTOS_CM_DET'
          object daTableJoin1: TdaTableJoin
            ChildType = 6
            object daField21: TdaField
              ChildType = 3
              Alias = 'Docto Cm Id'
              DataType = dtInteger
              DisplayWidth = 0
              FieldAlias = 'Docto Cm Id'
              FieldLength = 0
              FieldName = 'DOCTO_CM_ID'
              SQLFieldName = 'DOCTO_CM_ID'
              TableAlias = 'DocumentosComprasDetalle'
              TableName = 'DOCTOS_CM_DET'
              TableSQLAlias = 'DOCTOS_CM_DET_1'
            end
            object daField20: TdaField
              ChildType = 4
              Alias = 'Docto Cm Id'
              DataType = dtInteger
              DisplayWidth = 0
              FieldAlias = 'Docto Cm Id'
              FieldLength = 0
              FieldName = 'DOCTO_CM_ID'
              SQLFieldName = 'DOCTO_CM_ID'
              TableAlias = 'DocumentosCompras'
              TableName = 'DOCTOS_CM'
              TableSQLAlias = 'DOCTOS_CM_1'
            end
          end
        end
        object daTable3: TdaTable
          ChildType = 5
          Alias = 'Articulos'
          SQLAlias = 'ARTICULOS_1'
          TableAlias = 'Articulos'
          TableName = 'ARTICULOS'
          object daTableJoin2: TdaTableJoin
            ChildType = 6
            object daField23: TdaField
              ChildType = 3
              Alias = 'Art'#237'culo Id'
              DataType = dtInteger
              DisplayWidth = 0
              FieldAlias = 'Art'#237'culo Id'
              FieldLength = 0
              FieldName = 'ARTICULO_ID'
              SQLFieldName = 'ARTICULO_ID'
              TableAlias = 'Articulos'
              TableName = 'ARTICULOS'
              TableSQLAlias = 'ARTICULOS_1'
            end
            object daField22: TdaField
              ChildType = 4
              Alias = 'Art'#237'culo Id'
              DataType = dtInteger
              DisplayWidth = 0
              FieldAlias = 'Art'#237'culo Id'
              FieldLength = 0
              FieldName = 'ARTICULO_ID'
              SQLFieldName = 'ARTICULO_ID'
              TableAlias = 'DocumentosComprasDetalle'
              TableName = 'DOCTOS_CM_DET'
              TableSQLAlias = 'DOCTOS_CM_DET_1'
            end
          end
        end
      end
    end
  end
  object ppParameterList1: TppParameterList
  end
end