AlonsoYSal_FactuGES2/Source/Modulos/Comisiones/Data/uDataModuleComisiones.dfm

inherited DataModuleComisiones: TDataModuleComisiones
  OnCreate = DAClientDataModuleCreate
  Height = 414
  Width = 518
  object RORemoteService: TRORemoteService
    Message = dmConexion.ROMessage
    Channel = dmConexion.ROChannel
    ServiceName = 'srvComisiones'
    Left = 48
    Top = 24
  end
  object Bin2DataStreamer: TDABin2DataStreamer
    Left = 48
    Top = 84
  end
  object rda_Comisiones: TDARemoteDataAdapter
    GetSchemaCall.RemoteService = RORemoteService
    GetDataCall.RemoteService = RORemoteService
    UpdateDataCall.RemoteService = RORemoteService
    GetScriptsCall.RemoteService = RORemoteService
    RemoteService = RORemoteService
    DataStreamer = Bin2DataStreamer
    Left = 51
    Top = 143
  end
  object tbl_Comisiones: TDAMemDataTable
    RemoteUpdatesOptions = []
    Fields = <
      item
        Name = 'ID'
        DataType = datAutoInc
        GeneratorName = 'GEN_COMISIONES_LIQUID_ID'
        DisplayLabel = 'Id'
        ServerAutoRefresh = True
        DictionaryEntry = 'Comisiones_ID'
        InPrimaryKey = True
      end
      item
        Name = 'ID_EMPRESA'
        DataType = datInteger
        DisplayLabel = 'IdEmpresa'
        DictionaryEntry = 'Comisiones_ID_EMPRESA'
      end
      item
        Name = 'REFERENCIA'
        DataType = datString
        Size = 255
        DisplayLabel = 'Referencia'
        DictionaryEntry = 'Comisiones_REFERENCIA'
      end
      item
        Name = 'ID_AGENTE'
        DataType = datInteger
        DisplayLabel = 'IdAgente'
        DictionaryEntry = 'Comisiones_ID_AGENTE'
      end
      item
        Name = 'DESCRIPCION'
        DataType = datString
        Size = 255
        DisplayLabel = 'Descripci'#243'n'
        DictionaryEntry = 'Comisiones_DESCRIPCION'
      end
      item
        Name = 'FECHA'
        DataType = datDateTime
        DisplayLabel = 'Fecha'
        DictionaryEntry = 'Comisiones_FECHA'
      end
      item
        Name = 'IMPORTE_TOTAL'
        DataType = datCurrency
        DisplayLabel = 'Importe total'
        Alignment = taRightJustify
        DictionaryEntry = 'Comisiones_IMPORTE_TOTAL'
      end
      item
        Name = 'FECHA_ALTA'
        DataType = datDateTime
      end
      item
        Name = 'FECHA_MODIFICACION'
        DataType = datDateTime
      end
      item
        Name = 'USUARIO'
        DataType = datString
        Size = 20
        DisplayLabel = 'Usuario'
        DictionaryEntry = 'Comisiones_USUARIO'
      end>
    Params = <>
    StreamingOptions = [soDisableEventsWhileStreaming]
    RemoteDataAdapter = rda_Comisiones
    DetailOptions = [dtCascadeOpenClose, dtCascadeApplyUpdates, dtAutoFetch, dtCascadeDelete, dtCascadeUpdate, dtDisableLogOfCascadeDeletes, dtDisableLogOfCascadeUpdates, dtIncludeInAllInOneFetch]
    MasterOptions = [moCascadeOpenClose, moCascadeApplyUpdates, moCascadeDelete, moCascadeUpdate, moDisableLogOfCascadeDeletes, moDisableLogOfCascadeUpdates]
    LogicalName = 'Comisiones'
    IndexDefs = <>
    Left = 224
    Top = 112
  end
  object ds_Comisiones: TDADataSource
    DataSet = tbl_Comisiones.Dataset
    DataTable = tbl_Comisiones
    Left = 224
    Top = 56
  end
  object tbl_Facturas_Comision: TDAMemDataTable
    RemoteUpdatesOptions = []
    Fields = <
      item
        Name = 'ID'
        DataType = datInteger
        DisplayLabel = 'Facturas_Comision_ID'
        DictionaryEntry = 'Facturas_Comision_ID'
        InPrimaryKey = True
      end
      item
        Name = 'ID_EMPRESA'
        DataType = datInteger
        DisplayLabel = 'Facturas_Comision_ID_EMPRESA'
        DictionaryEntry = 'Facturas_Comision_ID_EMPRESA'
      end
      item
        Name = 'REFERENCIA'
        DataType = datString
        Size = 255
        DisplayLabel = 'Referencia'
        DictionaryEntry = 'Facturas_Comision_REFERENCIA'
      end
      item
        Name = 'TIPO'
        DataType = datString
        Size = 1
        DisplayLabel = 'Facturas_Comision_TIPO'
        DictionaryEntry = 'Facturas_Comision_TIPO'
      end
      item
        Name = 'ID_COMISION_LIQUIDADA'
        DataType = datInteger
        DisplayLabel = 'IdComision'
        ServerAutoRefresh = True
        DictionaryEntry = 'Facturas_Comision_ID_COMISION_LIQUIDADA'
      end
      item
        Name = 'FECHA_FACTURA'
        DataType = datDateTime
        DisplayLabel = 'Fecha'
        DictionaryEntry = 'Facturas_Comision_FECHA_FACTURA'
      end
      item
        Name = 'SITUACION'
        DataType = datString
        Size = 19
        DisplayLabel = 'Situaci'#243'n'
        DictionaryEntry = 'Facturas_Comision_SITUACION'
      end
      item
        Name = 'BASE_IMPONIBLE'
        DataType = datCurrency
        DisplayLabel = 'Base imponible'
        Alignment = taRightJustify
        DictionaryEntry = 'Facturas_Comision_BASE_IMPONIBLE'
      end
      item
        Name = 'DESCUENTO'
        DataType = datFloat
        DisplayLabel = 'Facturas_Comision_DESCUENTO'
        DictionaryEntry = 'Facturas_Comision_DESCUENTO'
      end
      item
        Name = 'IMPORTE_DESCUENTO'
        DataType = datCurrency
        DisplayLabel = 'Facturas_Comision_IMPORTE_DESCUENTO'
        DictionaryEntry = 'Facturas_Comision_IMPORTE_DESCUENTO'
      end
      item
        Name = 'IVA'
        DataType = datFloat
        DisplayLabel = 'Facturas_Comision_IVA'
        DictionaryEntry = 'Facturas_Comision_IVA'
      end
      item
        Name = 'IMPORTE_IVA'
        DataType = datCurrency
        DisplayLabel = 'Facturas_Comision_IMPORTE_IVA'
        DictionaryEntry = 'Facturas_Comision_IMPORTE_IVA'
      end
      item
        Name = 'RE'
        DataType = datFloat
        DisplayLabel = 'Facturas_Comision_RE'
        DictionaryEntry = 'Facturas_Comision_RE'
      end
      item
        Name = 'IMPORTE_RE'
        DataType = datCurrency
        DisplayLabel = 'Facturas_Comision_IMPORTE_RE'
        DictionaryEntry = 'Facturas_Comision_IMPORTE_RE'
      end
      item
        Name = 'IMPORTE_TOTAL'
        DataType = datCurrency
        DisplayLabel = 'Facturas_Comision_IMPORTE_TOTAL'
        DictionaryEntry = 'Facturas_Comision_IMPORTE_TOTAL'
      end
      item
        Name = 'OBSERVACIONES'
        DataType = datMemo
        DisplayLabel = 'Facturas_Comision_OBSERVACIONES'
        DictionaryEntry = 'Facturas_Comision_OBSERVACIONES'
      end
      item
        Name = 'ID_CLIENTE'
        DataType = datInteger
        DisplayLabel = 'IdCliente'
        DictionaryEntry = 'Facturas_Comision_ID_CLIENTE'
      end
      item
        Name = 'NOMBRE_CLIENTE'
        DataType = datString
        Size = 255
        DisplayLabel = 'Nombre cliente'
        DictionaryEntry = 'Facturas_Comision_NOMBRE_CLIENTE'
      end
      item
        Name = 'NOMBRE_COMERCIAL_CLIENTE'
        DataType = datString
        Size = 255
        DisplayLabel = 'Nombre comercial cliente'
        DictionaryEntry = 'Facturas_Comision_NOMBRE_COMERCIAL_CLIENTE'
      end
      item
        Name = 'NIF_CIF'
        DataType = datString
        Size = 15
        DisplayLabel = 'Facturas_Comision_NIF_CIF'
        DictionaryEntry = 'Facturas_Comision_NIF_CIF'
      end
      item
        Name = 'NOMBRE'
        DataType = datString
        Size = 255
        DisplayLabel = 'Raz'#243'n social'
        DictionaryEntry = 'Facturas_Comision_NOMBRE'
      end
      item
        Name = 'CALLE'
        DataType = datString
        Size = 255
        DisplayLabel = 'Facturas_Comision_CALLE'
        DictionaryEntry = 'Facturas_Comision_CALLE'
      end
      item
        Name = 'POBLACION'
        DataType = datString
        Size = 255
        DisplayLabel = 'Facturas_Comision_POBLACION'
        DictionaryEntry = 'Facturas_Comision_POBLACION'
      end
      item
        Name = 'PROVINCIA'
        DataType = datString
        Size = 255
        DisplayLabel = 'Facturas_Comision_PROVINCIA'
        DictionaryEntry = 'Facturas_Comision_PROVINCIA'
      end
      item
        Name = 'CODIGO_POSTAL'
        DataType = datString
        Size = 10
        DisplayLabel = 'Facturas_Comision_CODIGO_POSTAL'
        DictionaryEntry = 'Facturas_Comision_CODIGO_POSTAL'
      end
      item
        Name = 'FECHA_ALTA'
        DataType = datDateTime
        DisplayLabel = 'Facturas_Comision_FECHA_ALTA'
        DictionaryEntry = 'Facturas_Comision_FECHA_ALTA'
      end
      item
        Name = 'FECHA_MODIFICACION'
        DataType = datDateTime
        DisplayLabel = 'Facturas_Comision_FECHA_MODIFICACION'
        DictionaryEntry = 'Facturas_Comision_FECHA_MODIFICACION'
      end
      item
        Name = 'USUARIO'
        DataType = datString
        Size = 30
        DisplayLabel = 'Facturas_Comision_USUARIO'
        DictionaryEntry = 'Facturas_Comision_USUARIO'
      end
      item
        Name = 'ID_FORMA_PAGO'
        DataType = datInteger
        DisplayLabel = 'Facturas_Comision_ID_FORMA_PAGO'
        DictionaryEntry = 'Facturas_Comision_ID_FORMA_PAGO'
      end
      item
        Name = 'RECARGO_EQUIVALENCIA'
        DataType = datSmallInt
        DisplayLabel = 'Facturas_Comision_RECARGO_EQUIVALENCIA'
        DictionaryEntry = 'Facturas_Comision_RECARGO_EQUIVALENCIA'
      end
      item
        Name = 'ID_TIPO_IVA'
        DataType = datInteger
        DisplayLabel = 'Facturas_Comision_ID_TIPO_IVA'
        DictionaryEntry = 'Facturas_Comision_ID_TIPO_IVA'
      end
      item
        Name = 'IMPORTE_NETO'
        DataType = datCurrency
        DisplayLabel = 'Facturas_Comision_IMPORTE_NETO'
        DictionaryEntry = 'Facturas_Comision_IMPORTE_NETO'
      end
      item
        Name = 'IMPORTE_PORTE'
        DataType = datCurrency
        DisplayLabel = 'Facturas_Comision_IMPORTE_PORTE'
        DictionaryEntry = 'Facturas_Comision_IMPORTE_PORTE'
      end
      item
        Name = 'ID_AGENTE'
        DataType = datInteger
        DisplayLabel = 'Facturas_Comision_ID_AGENTE'
        DictionaryEntry = 'Facturas_Comision_ID_AGENTE'
      end
      item
        Name = 'REFERENCIA_COMISION'
        DataType = datString
        Size = 255
        DisplayLabel = 'Facturas_Comision_REFERENCIA_COMISION'
        DictionaryEntry = 'Facturas_Comision_REFERENCIA_COMISION'
      end
      item
        Name = 'IGNORAR_CONTABILIDAD'
        DataType = datSmallInt
        DisplayLabel = 'Facturas_Comision_IGNORAR_CONTABILIDAD'
        DictionaryEntry = 'Facturas_Comision_IGNORAR_CONTABILIDAD'
      end
      item
        Name = 'ID_TIENDA'
        DataType = datInteger
        DisplayLabel = 'Facturas_Comision_ID_TIENDA'
        DictionaryEntry = 'Facturas_Comision_ID_TIENDA'
      end
      item
        Name = 'TIENDA'
        DataType = datString
        Size = 255
        DisplayLabel = 'Facturas_Comision_TIENDA'
        DictionaryEntry = 'Facturas_Comision_TIENDA'
      end
      item
        Name = 'ID_SUBCUENTA'
        DataType = datInteger
        DisplayLabel = 'Facturas_Comision_ID_SUBCUENTA'
        DictionaryEntry = 'Facturas_Comision_ID_SUBCUENTA'
      end
      item
        Name = 'SUBCUENTA'
        DataType = datString
        Size = 255
        DisplayLabel = 'Facturas_Comision_SUBCUENTA'
        DictionaryEntry = 'Facturas_Comision_SUBCUENTA'
      end>
    Params = <>
    MasterMappingMode = mmWhere
    StreamingOptions = [soDisableEventsWhileStreaming]
    RemoteDataAdapter = rda_Comisiones
    MasterSource = ds_Comisiones
    MasterFields = 'ID'
    DetailFields = 'ID_COMISION_LIQUIDADA'
    DetailOptions = [dtCascadeOpenClose, dtCascadeApplyUpdates, dtAutoFetch, dtCascadeDelete, dtCascadeUpdate, dtDisableLogOfCascadeDeletes, dtDisableLogOfCascadeUpdates, dtIncludeInAllInOneFetch]
    MasterOptions = [moCascadeOpenClose, moCascadeApplyUpdates, moCascadeDelete, moCascadeUpdate, moDisableLogOfCascadeDeletes, moDisableLogOfCascadeUpdates]
    LogicalName = 'Facturas_Comision'
    IndexDefs = <>
    Left = 376
    Top = 104
  end
  object ds_Facturas_Comision: TDADataSource
    DataSet = tbl_Facturas_Comision.Dataset
    DataTable = tbl_Facturas_Comision
    Left = 376
    Top = 48
  end
  object tbl_Vendedores_Comision: TDAMemDataTable
    RemoteUpdatesOptions = []
    Fields = <
      item
        Name = 'ID'
        DataType = datAutoInc
        GeneratorName = 'GEN_COMISIONES_VENDEDORES_ID'
        DisplayLabel = 'Id'
        DictionaryEntry = 'Comisiones_vendedores_ID'
        InPrimaryKey = True
      end
      item
        Name = 'ID_COMISION'
        DataType = datInteger
        DisplayLabel = 'IdComision'
        ServerAutoRefresh = True
        DictionaryEntry = 'Comisiones_vendedores_ID_COMISION'
      end
      item
        Name = 'ID_VENDEDOR'
        DataType = datInteger
        DisplayLabel = 'IdVendedor'
        DictionaryEntry = 'Comisiones_vendedores_ID_VENDEDOR'
      end
      item
        Name = 'NOMBRE'
        DataType = datString
        Size = 255
        DisplayLabel = 'Vendedor'
        DictionaryEntry = 'Comisiones_vendedores_NOMBRE'
      end
      item
        Name = 'COMISION'
        DataType = datFloat
      end
      item
        Name = 'IMPORTE_TOTAL'
        DataType = datCurrency
        DisplayLabel = 'Importe'
        Alignment = taRightJustify
        DictionaryEntry = 'Comisiones_vendedores_IMPORTE_TOTAL'
      end>
    Params = <>
    MasterMappingMode = mmWhere
    StreamingOptions = [soDisableEventsWhileStreaming]
    RemoteDataAdapter = rda_Comisiones
    MasterSource = ds_Comisiones
    MasterFields = 'ID'
    DetailFields = 'ID_COMISION'
    DetailOptions = [dtCascadeOpenClose, dtCascadeApplyUpdates, dtAutoFetch, dtCascadeDelete, dtCascadeUpdate, dtDisableLogOfCascadeDeletes, dtDisableLogOfCascadeUpdates, dtIncludeInAllInOneFetch]
    MasterOptions = [moCascadeOpenClose, moCascadeApplyUpdates, moCascadeDelete, moCascadeUpdate, moDisableLogOfCascadeDeletes, moDisableLogOfCascadeUpdates]
    LogicalName = 'Vendedores_Comision'
    IndexDefs = <>
    Left = 384
    Top = 232
  end
  object ds_Vendedores_Comision: TDADataSource
    DataSet = tbl_Vendedores_Comision.Dataset
    DataTable = tbl_Vendedores_Comision
    Left = 384
    Top = 176
  end
end