--Insertar mas filtros Informes Ordenes de Servicio Especial
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'Cantkms', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'', N'', 55, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'CM.Cantidad', N'', N'DECIMAL', 0, 0, 0, N'', N'0', N'CantCump', N'Cantidad', 79, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'CM.Cumplido', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'NumCumplido', N'Cumplido', 72, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'CM.Descripcion', N'', N'VARCHAR', 250, 0, 0, N'', N'', N'DescripCump', N'Descripcion', 78, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'CM.DescServicio', N'', N'VARCHAR', 100, 0, 0, N'', N'', N'CumpServicio', N'DescServicio', 75, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'CM.Fecha', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'FechaCump', N'Fecha', 74, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'CM.IdCia', N'', N'CHAR', 2, 0, 0, N'', N'', N'CiaCump', N'IdCia', 73, N'SP', N'QRY', N'IdCia', N'IdCia+''  ''+Compania', N'Companias WHERE  Inactivo=0 ORDER BY IdCia', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'CM.IdMercancia', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'CdMercanciaCump', N'IdMercancia', 77, N'SP', N'QRY', N'IdMercancia', N'DescripMcia+'' ''+IdMercancia', N'Mercancias WHERE Inactivo=0 ORDER BY DescripMcia', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'CM.Observacion', N'', N'VARCHAR', 1000, 0, 0, N'', N'', N'ObservCump', N'Observacion', 76, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'CM.TarifaPago', N'', N'MONEY', 0, 0, 0, N'', N'0', N'TarifPagoCump', N'TarifaPago', 83, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'CM.UndMed', N'', N'VARCHAR', 10, 0, 0, N'', N'', N'UndMedCump', N'UndMed', 80, N'SP', N'QRY', N'UndMed', N'Unidad', N'Sys_Um ORDER BY Unidad', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'CM.VrUnitario', N'', N'MONEY', 0, 0, 0, N'', N'0', N'TarifCump', N'VrUnitario', 82, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'D.Cantidad', N'', N'DECIMAL', 0, 0, 0, N'', N'0', N'Cantidad', N'Cantidad', 23, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'D.Descripcion', N'', N'VARCHAR', 250, 0, 0, N'', N'', N'Descripcion', N'Descripcion', 22, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'D.DocCliente', N'', N'VARCHAR', 30, 0, 0, N'', N'', N'DocCliente', N'DocCliente', 28, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'D.IdMercancia', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'CdMercancia', N'IdMercancia', 21, N'SP', N'QRY', N'IdMercancia', N'DescripMcia+'' ''+IdMercancia', N'Mercancias WHERE Inactivo=0 ORDER BY DescripMcia', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'D.Item', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'Item', N'Item', 20, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'D.TarifaPago', N'', N'MONEY', 0, 0, 0, N'', N'0', N'TarifaPago', N'TarifaPago', 27, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'D.UndMed', N'', N'VARCHAR', 10, 0, 0, N'', N'', N'UndMed', N'UndMed', 24, N'SP', N'QRY', N'UndMed', N'Unidad', N'Sys_Um ORDER BY Unidad', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'D.VrUnitario', N'', N'MONEY', 0, 0, 0, N'', N'0', N'VrUnitario', N'VrUnitario', 26, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'EstCumplido', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'', N'', 71, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'FactCant', N'', N'DECIMAL', 0, 0, 0, N'', N'0', N'', N'', 112, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'FactCosto', N'', N'DECIMAL', 0, 0, 0, N'', N'0', N'', N'', 117, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'FactFecha', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'', N'', 111, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'FactIdCli', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'', N'', 118, N'SP', N'QRY', N'IdTercero', N'RazonSocial+'' ''+IdTercero', N'Terceros WHERE EsCliente=1 ORDER BY RazonSocial', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'FactIva', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 115, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'FactTarifClie', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 113, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'FactTarifIVA', N'', N'DECIMAL', 0, 0, 0, N'', N'0', N'', N'', 116, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'FactTotal', N'', N'DECIMAL', 0, 0, 0, N'', N'0', N'', N'', 114, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'FecAprob', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'', N'', 58, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'FecSoat', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'', N'', 140, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'IdCiaApr', N'', N'CHAR', 2, 0, 0, N'', N'', N'', N'', 57, N'SP', N'QRY', N'IdCia', N'IdCia+''  ''+Compania', N'Companias WHERE  Inactivo=0 ORDER BY IdCia', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'kmtFinal', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'', N'', 54, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'kmtInicial', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'', N'', 53, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'L.Cantidad', N'', N'DECIMAL', 0, 0, 0, N'', N'0', N'LiqCantidad', N'Cantidad', 99, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'L.Fecha', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'FecLiquida', N'Fecha', 88, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'L.Referencia', N'', N'VARCHAR', 50, 0, 0, N'', N'', N'Referencia', N'Referencia', 105, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'L.TarifaIca', N'', N'DECIMAL', 0, 0, 0, N'', N'0', N'TarifaIca', N'TarifaIca', 103, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'L.TarifaImp', N'', N'DECIMAL', 0, 0, 0, N'', N'0', N'TarifaImp', N'TarifaImp', 101, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'L.TarifaPago', N'', N'MONEY', 0, 0, 0, N'', N'0', N'LiqTarifaPago', N'TarifaPago', 100, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'L.TarifaRet', N'', N'DECIMAL', 0, 0, 0, N'', N'0', N'TarifaRet', N'TarifaRet', 102, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'L.TarifaRiv', N'', N'DECIMAL', 0, 0, 0, N'', N'0', N'TarifaRiv', N'TarifaRiv', 104, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'L.VrAnticipo', N'', N'MONEY', 0, 0, 0, N'', N'0', N'LiqAnticipo', N'VrAnticipo', 90, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'L.VrDescuento', N'', N'MONEY', 0, 0, 0, N'', N'0', N'VrDescuento', N'VrDescuento', 97, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'L.VrGastos', N'', N'MONEY', 0, 0, 0, N'', N'0', N'VrGastos', N'VrGastos', 106, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'L.VrIva', N'', N'MONEY', 0, 0, 0, N'', N'0', N'LiqIva', N'VrIva', 91, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'L.VrNeto', N'', N'MONEY', 0, 0, 0, N'', N'0', N'VrNeto', N'VrNeto', 98, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'L.VrOtros', N'', N'MONEY', 0, 0, 0, N'', N'0', N'VrOtros', N'VrOtros', 96, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'L.VrReteCREE', N'', N'MONEY', 0, 0, 0, N'', N'0', N'VrReteCREE', N'VrReteCREE', 94, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'L.VrReteIca', N'', N'MONEY', 0, 0, 0, N'', N'0', N'VrReteIca', N'VrReteIca', 93, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'L.VrReteIva', N'', N'MONEY', 0, 0, 0, N'', N'0', N'VrReteIva', N'VrReteIva', 95, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'L.VrRetencion', N'', N'MONEY', 0, 0, 0, N'', N'0', N'LiqRetencion', N'VrRetencion', 92, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'L.VrTotal', N'', N'MONEY', 0, 0, 0, N'', N'0', N'LiqTotal', N'VrTotal', 89, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'Modelo', N'', N'VARCHAR', 4, 0, 0, N'', N'', N'', N'', 132, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'NitEmpresa', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'', N'', 136, N'SP', N'QRY', N'IdTercero', N'RazonSocial+'' ''+IdTercero', N'Terceros ORDER BY RazonSocial', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'NitEmpSoat', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'', N'', 142, N'SP', N'QRY', N'IdTercero', N'RazonSocial+'' ''+IdTercero', N'Terceros ORDER BY RazonSocial', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'NomRecibido', N'', N'VARCHAR', 150, 0, 0, N'', N'', N'', N'', 46, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'NumAprob', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'', N'', 56, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'NumMotor', N'', N'VARCHAR', 30, 0, 0, N'', N'', N'', N'', 133, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'NumSerie', N'', N'VARCHAR', 30, 0, 0, N'', N'', N'', N'', 135, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'NumSoat', N'', N'VARCHAR', 30, 0, 0, N'', N'', N'', N'', 139, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'NumVeh', N'', N'VARCHAR', 10, 0, 0, N'', N'', N'', N'', 12, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.Anulado', N'', N'BOOLEAN', 0, 0, 0, N'YES/NO', N'0', N'Anulado', N'Anulado', 61, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.Cantidad', N'', N'DECIMAL', 0, 0, 0, N'', N'0', N'CantTotal', N'Cantidad', 18, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.CdCiaFact', N'', N'CHAR', 2, 0, 0, N'', N'', N'CdCiaFact', N'CdCiaFact', 110, N'SP', N'QRY', N'IdCia', N'IdCia+''  ''+Compania', N'Companias WHERE  Inactivo=0 ORDER BY IdCia', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.CdCiaLiq', N'', N'CHAR', 2, 0, 0, N'', N'', N'CdCiaLiq', N'CdCiaLiq', 87, N'SP', N'QRY', N'IdCia', N'IdCia+''  ''+Compania', N'Companias WHERE  Inactivo=0 ORDER BY IdCia', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.CdCiaRem', N'', N'CHAR', 2, 0, 0, N'', N'', N'CdCiaRem', N'CdCiaRem', 52, N'SP', N'QRY', N'IdCia', N'IdCia+''  ''+Compania', N'Companias WHERE  Inactivo=0 ORDER BY IdCia', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.CdRuta', N'', N'VARCHAR', 4, 0, 0, N'', N'', N'CdRuta', N'CdRuta', 31, N'SP', N'QRY', N'IdRuta', N'IdRuta+'' ''+Ruta', N'Rutas ORDER BY IdRuta', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.EstFactura', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'EstFactura', N'EstFactura', 107, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.EstOrden', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'EstOrden', N'EstOrden', 84, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.FecCertificado', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'FecCertificado', N'FecCertificado', 50, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.FecDespacho', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'FecDespacho', N'FecDespacho', 47, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.FecDev', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'FecDev', N'FecDev', 62, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.Fecha', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'Fecha', N'Fecha', 6, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.FecIngCertif', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'FecIngCertif', N'FecIngCertif', 49, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.FecRecibo', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'FecRecibo', N'FecRecibo', 48, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.FecUpdate', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'FechaModif', N'FecUpdate', 67, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.IdAgencia', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'CdAgencia', N'IdAgencia', 37, N'SP', N'QRY', N'IdAgencia', N'Agencia+'' ''+IdClie', N'Agencias ORDER BY Agencia', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.IdCia', N'', N'CHAR', 2, 0, 0, N'', N'', N'CdCia', N'IdCia', 4, N'SP', N'QRY', N'IdCia', N'IdCia+''  ''+Compania', N'Companias WHERE  Inactivo=0 ORDER BY IdCia', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.IdCiaCrea', N'', N'CHAR', 2, 0, 0, N'', N'', N'CdCiaCrea', N'IdCiaCrea', 68, N'SP', N'QRY', N'IdCia', N'IdCia+''  ''+Compania', N'Companias WHERE  Inactivo=0 ORDER BY IdCia', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.IdCliente', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'IdCliente', N'IdCliente', 8, N'SP', N'QRY', N'IdTercero', N'RazonSocial+'' ''+IdTercero', N'Terceros WHERE EsCliente=1 ORDER BY RazonSocial', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.IdConductor', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'CedConductor', N'IdConductor', 41, N'SP', N'QRY', N'IdTercero', N'RazonSocial+'' ''+IdTercero', N'Terceros WHERE EsConductor<>0 ORDER BY RazonSocial', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.IdDestino', N'', N'VARCHAR', 8, 0, 0, N'', N'', N'CdDestino', N'IdDestino', 35, N'SP', N'QRY', N'IdLocal', N'Localidad+ ''  (''+ Departamento + '')''', N'Localidades AS L INNER JOIN Departamentos AS D ON L.IdDep=D.IdDep WHERE L.Inactivo=0 ORDER BY Localidad', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.IdEstacion', N'', N'VARCHAR', 4, 0, 0, N'', N'', N'CdCampo', N'IdEstacion', 29, N'SP', N'QRY', N'IdEstacion', N'EstServicio', N'EdsServicio ORDER BY EstServicio', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.IdEstado', N'', N'VARCHAR', 4, 0, 0, N'', N'', N'CdEstado', N'IdEstado', 64, N'SP', N'QRY', N'IdEstado', N'Estado', N'EstadoDoc WHERE Inactivo=0 ORDER BY IdEstado', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.IdOrigen', N'', N'VARCHAR', 8, 0, 0, N'', N'', N'CdOrigen', N'IdOrigen', 33, N'SP', N'QRY', N'IdLocal', N'Localidad+ ''  (''+ Departamento + '')''', N'Localidades AS L INNER JOIN Departamentos AS D ON L.IdDep=D.IdDep WHERE L.Inactivo=0 ORDER BY Localidad', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.IdPoseedor', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'NitPoseedor', N'IdPoseedor', 39, N'SP', N'QRY', N'IdTercero', N'RazonSocial+'' ''+IdTercero', N'Terceros ORDER BY RazonSocial', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.IdUsuario', N'', N'VARCHAR', 11, 0, 0, N'', N'', N'CdUsuario', N'IdUsuario', 69, N'SP', N'QRY', N'IdUsuario', N'Usuario', N'adm_Usuarios WHERE Inactivo=0 ORDER BY Usuario', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.IdVehiculo', N'', N'VARCHAR', 10, 0, 0, N'', N'', N'PlacaVeh', N'IdVehiculo', 11, N'SP', N'QRY', N'IdVehiculo', N'IdVehiculo+'' ''+NumVeh', N'Vehiculos WHERE Inactivo=0 ORDER BY IdVehiculo', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.Modalidad', N'', N'VARCHAR', 10, 0, 0, N'', N'', N'Modalidad', N'Modalidad', 14, N'SP', N'LIST', N'', N'', N'ESPECIALES;TRATMIENTO', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.NumFactura', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'NumFactura', N'NumFactura', 109, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.NumLiquida', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'NumLiquida', N'NumLiquida', 86, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.NumOrden', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'Num_Orden', N'NumOrden', 3, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.NumRemesa', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'NumRemesa', N'NumRemesa', 51, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.Observacion', N'', N'VARCHAR', 1000, 0, 0, N'', N'', N'Observ', N'Observacion', 63, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.RemCliente', N'', N'VARCHAR', 30, 0, 0, N'', N'', N'RemCliente', N'RemCliente', 45, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.TimeSys', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'FechaCrea', N'TimeSys', 66, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.TipDoc', N'', N'VARCHAR', 3, 0, 0, N'', N'', N'IdTipDoc', N'TipDoc', 1, N'SP', N'QRY', N'IdDoc', N'IdDoc+'' ''+TipoDoc', N'Sys_TiposDoc ORDER BY IdDoc', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.TipFact', N'', N'VARCHAR', 3, 0, 0, N'', N'', N'TipFact', N'TipFact', 108, N'SP', N'QRY', N'IdDoc', N'IdDoc+'' ''+TipoDoc', N'Sys_TiposDoc ORDER BY IdDoc', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.TipLiq', N'', N'VARCHAR', 3, 0, 0, N'', N'', N'TipLiq', N'TipLiq', 85, N'SP', N'QRY', N'IdDoc', N'IdDoc+'' ''+TipoDoc', N'Sys_TiposDoc ORDER BY IdDoc', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.TipoAfiVehic', N'', N'VARCHAR', 10, 0, 0, N'', N'', N'TipoAfiVehic', N'TipoAfiVehic', 13, N'SP', N'LIST', N'', N'', N'PROPIO;AFILIADO;TERCEROS;OTRO', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.VrAnticipo', N'', N'MONEY', 0, 0, 0, N'', N'0', N'VrAnticipo', N'VrAnticipo', 19, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.VrCosto', N'', N'MONEY', 0, 0, 0, N'', N'0', N'TotalTercero', N'VrCosto', 17, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'O.VrTotal', N'', N'MONEY', 0, 0, 0, N'', N'0', N'ValorTotal', N'VrTotal', 16, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'ObservAprob', N'', N'VARCHAR', 250, 0, 0, N'', N'', N'', N'', 60, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'SerieChasis', N'', N'VARCHAR', 30, 0, 0, N'', N'', N'', N'', 134, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'T.IdLocal', N'', N'VARCHAR', 8, 0, 0, N'', N'', N'TercCdCiudad', N'IdLocal', 121, N'SP', N'QRY', N'IdLocal', N'Localidad+ ''  (''+ Departamento + '')''', N'Localidades AS L INNER JOIN Departamentos AS D ON L.IdDep=D.IdDep WHERE L.Inactivo=0 ORDER BY Localidad', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'T.Telefono', N'', N'VARCHAR', 20, 0, 0, N'', N'', N'TercTelefono', N'Telefono', 123, N'SP', N'N', N'', N'', N'', 0)
GO
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'T.TelMovil', N'', N'VARCHAR', 20, 0, 0, N'', N'', N'TelCelular', N'TelMovil', 124, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'T.TipoId', N'', N'CHAR', 1, 0, 0, N'', N'', N'ClieTipoId', N'TipoId', 7, N'SP', N'LIST', N'', N'', N'N;C;E;O;U;T;R;P;X', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'TipoAfil', N'', N'VARCHAR', 10, 0, 0, N'', N'', N'', N'', 138, N'SP', N'LIST', N'', N'', N'PROPIO;AFILIADO;TERCEROS;OTRO', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'TipoOrden', N'', N'VARCHAR', 10, 0, 0, N'', N'', N'', N'', 15, N'SP', N'LIST', N'', N'', N'EXTERNA;INTERNA', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'TipoResiduo', N'', N'VARCHAR', 100, 0, 0, N'', N'', N'', N'', 44, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'UsuAprob', N'', N'VARCHAR', 11, 0, 0, N'', N'', N'', N'', 59, N'SP', N'QRY', N'IdUsuario', N'Usuario', N'adm_Usuarios WHERE Inactivo=0 ORDER BY Usuario', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'V.Descripcion', N'', N'VARCHAR', 100, 0, 0, N'', N'', N'VehDescripcion', N'Descripcion', 144, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'V.IdColor', N'', N'VARCHAR', 4, 0, 0, N'', N'', N'CdColor', N'IdColor', 130, N'SP', N'QRY', N'IdColor', N'NomColor', N'TiposCol ORDER BY NomColor', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'V.IdMarca', N'', N'VARCHAR', 4, 0, 0, N'', N'', N'CdMarca', N'IdMarca', 128, N'SP', N'QRY', N'IdMarca', N'Marca', N'Marcas WHERE TipoMarca IN (''GENERAL'',''VEHICULOS'') ORDER BY Marca', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'V.IdTipoVeh', N'', N'VARCHAR', 4, 0, 0, N'', N'', N'CdTipVeh', N'IdTipoVeh', 126, N'SP', N'QRY', N'IdTipoVeh', N'TipoVehiculo', N'TiposVeh ORDER BY TipoVehiculo', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServFac', N'VigSoat', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'', N'', 141, N'SP', N'N', N'', N'', N'', 0)
GO
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'Cantkms', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'', N'', 52, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'CatLicencia', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'', N'', 119, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'CdCiaCum', N'', N'CHAR', 2, 0, 0, N'', N'', N'', N'', 45, N'SP', N'QRY', N'IdCia', N'IdCia+''  ''+Compania', N'Companias WHERE  Inactivo=0 ORDER BY IdCia', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'CdCiaFact', N'', N'CHAR', 2, 0, 0, N'', N'', N'', N'', 49, N'SP', N'QRY', N'IdCia', N'IdCia+''  ''+Compania', N'Companias WHERE  Inactivo=0 ORDER BY IdCia', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'CdCiaLiq', N'', N'CHAR', 2, 0, 0, N'', N'', N'', N'', 56, N'SP', N'QRY', N'IdCia', N'IdCia+''  ''+Compania', N'Companias WHERE  Inactivo=0 ORDER BY IdCia', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'CdCiaRem', N'', N'CHAR', 2, 0, 0, N'', N'', N'', N'', 42, N'SP', N'QRY', N'IdCia', N'IdCia+''  ''+Compania', N'Companias WHERE  Inactivo=0 ORDER BY IdCia', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'CdRemque', N'', N'VARCHAR', 10, 0, 0, N'', N'', N'', N'', 100, N'SP', N'QRY', N'IdRemque', N'IdRemque', N'VehRemolq WHERE Inactivo=0 ORDER BY IdRemque', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'CertJudicial', N'', N'VARCHAR', 25, 0, 0, N'', N'', N'', N'', 115, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'Config', N'', N'VARCHAR', 5, 0, 0, N'', N'', N'', N'', 94, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'CT.IdLugar', N'', N'VARCHAR', 8, 0, 0, N'', N'', N'CdLugar', N'IdLugar', 120, N'SP', N'QRY', N'IdLugar', N'LugarLic+'' (''+ Dpto + '')''', N'ExpLicencias WHERE Inactivo=0 ORDER BY LugarLic', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'EstCumplido', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'', N'', 43, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'EstFactura', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'', N'', 46, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'EstOrden', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'', N'', 53, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'FecAprob', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'', N'', 59, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'FecCertificado', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'', N'', 40, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'FecDespacho', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'', N'', 7, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'FecDev', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'', N'', 63, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'FecIngCertif', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'', N'', 39, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'FecJudicial', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'', N'', 116, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'FecLicencia', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'', N'', 122, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'FecRecibo', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'', N'', 8, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'FecSoat', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'', N'', 110, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'IdCiaApr', N'', N'CHAR', 2, 0, 0, N'', N'', N'', N'', 58, N'SP', N'QRY', N'IdCia', N'IdCia+''  ''+Compania', N'Companias WHERE  Inactivo=0 ORDER BY IdCia', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'kmtFinal', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'', N'', 51, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'kmtInicial', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'', N'', 50, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'Licencia', N'', N'VARCHAR', 25, 0, 0, N'', N'', N'', N'', 118, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'Modelo', N'', N'VARCHAR', 4, 0, 0, N'', N'', N'', N'', 93, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'NitEmpresa', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'', N'', 101, N'SP', N'QRY', N'IdTercero', N'RazonSocial+'' ''+IdTercero', N'Terceros ORDER BY RazonSocial', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'NitEmpSoat', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'', N'', 112, N'SP', N'QRY', N'IdTercero', N'RazonSocial+'' ''+IdTercero', N'Terceros ORDER BY RazonSocial', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'NomRecibido', N'', N'VARCHAR', 150, 0, 0, N'', N'', N'', N'', 38, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'nRemolque', N'', N'VARCHAR', 10, 0, 0, N'', N'', N'', N'', 19, N'SP', N'QRY', N'IdRemque', N'IdRemque', N'VehRemolq WHERE Inactivo=0 ORDER BY IdRemque', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'NumAprob', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'', N'', 57, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'NumCump', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'', N'', 44, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'NumFactura', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'', N'', 48, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'NumLiquida', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'', N'', 55, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'NumMotor', N'', N'VARCHAR', 30, 0, 0, N'', N'', N'', N'', 97, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'NumRemesa', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'', N'', 41, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'NumSerie', N'', N'VARCHAR', 30, 0, 0, N'', N'', N'', N'', 99, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'NumSoat', N'', N'VARCHAR', 30, 0, 0, N'', N'', N'', N'', 109, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'NumVeh', N'', N'VARCHAR', 10, 0, 0, N'', N'', N'', N'', 14, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.Anulado', N'', N'BOOLEAN', 0, 0, 0, N'YES/NO', N'0', N'Anulado', N'Anulado', 62, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.Cantidad', N'', N'DECIMAL', 0, 0, 0, N'', N'0', N'Cant_Total', N'Cantidad', 24, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.CdRuta', N'', N'VARCHAR', 4, 0, 0, N'', N'', N'CdRuta', N'CdRuta', 26, N'SP', N'QRY', N'IdRuta', N'IdRuta+'' ''+Ruta', N'Rutas ORDER BY IdRuta', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.Fecha', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'Fecha', N'Fecha', 6, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.FecUpdate', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'FechaModif', N'FecUpdate', 68, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.IdAgencia', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'CdAgencia', N'IdAgencia', 11, N'SP', N'QRY', N'IdAgencia', N'Agencia+'' ''+IdClie', N'Agencias ORDER BY Agencia', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.IdCia', N'', N'CHAR', 2, 0, 0, N'', N'', N'CdCia', N'IdCia', 4, N'SP', N'QRY', N'IdCia', N'IdCia+''  ''+Compania', N'Companias WHERE  Inactivo=0 ORDER BY IdCia', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.IdCiaCrea', N'', N'CHAR', 2, 0, 0, N'', N'', N'CdCiaCrea', N'IdCiaCrea', 69, N'SP', N'QRY', N'IdCia', N'IdCia+''  ''+Compania', N'Companias WHERE  Inactivo=0 ORDER BY IdCia', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.IdCliente', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'IdCliente', N'IdCliente', 9, N'SP', N'QRY', N'IdTercero', N'RazonSocial+'' ''+IdTercero', N'Terceros WHERE EsCliente=1 ORDER BY RazonSocial', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.IdConductor', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'CedConductor', N'IdConductor', 17, N'SP', N'QRY', N'IdTercero', N'RazonSocial+'' ''+IdTercero', N'Terceros WHERE EsConductor<>0 ORDER BY RazonSocial', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.IdDestino', N'', N'VARCHAR', 8, 0, 0, N'', N'', N'CdDestino', N'IdDestino', 30, N'SP', N'QRY', N'IdLocal', N'Localidad+ ''  (''+ Departamento + '')''', N'Localidades AS L INNER JOIN Departamentos AS D ON L.IdDep=D.IdDep WHERE L.Inactivo=0 ORDER BY Localidad', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.IdEstacion', N'', N'VARCHAR', 4, 0, 0, N'', N'', N'CdCampo', N'IdEstacion', 33, N'SP', N'QRY', N'IdEstacion', N'EstServicio', N'EdsServicio ORDER BY EstServicio', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.IdEstado', N'', N'VARCHAR', 4, 0, 0, N'', N'', N'CdEstado', N'IdEstado', 65, N'SP', N'QRY', N'IdEstado', N'Estado', N'EstadoDoc WHERE Inactivo=0 ORDER BY IdEstado', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.IdOrigen', N'', N'VARCHAR', 8, 0, 0, N'', N'', N'IdOrigen', N'IdOrigen', 28, N'SP', N'QRY', N'IdLocal', N'Localidad+ ''  (''+ Departamento + '')''', N'Localidades AS L INNER JOIN Departamentos AS D ON L.IdDep=D.IdDep WHERE L.Inactivo=0 ORDER BY Localidad', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.IdPoseedor', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'NitPoseedor', N'IdPoseedor', 15, N'SP', N'QRY', N'IdTercero', N'RazonSocial+'' ''+IdTercero', N'Terceros ORDER BY RazonSocial', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.IdUsuario', N'', N'VARCHAR', 11, 0, 0, N'', N'', N'CdUsuario', N'IdUsuario', 71, N'SP', N'QRY', N'IdUsuario', N'Usuario', N'adm_Usuarios WHERE Inactivo=0 ORDER BY Usuario', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.IdVehiculo', N'', N'VARCHAR', 10, 0, 0, N'', N'', N'PlacaVeh', N'IdVehiculo', 13, N'SP', N'QRY', N'IdVehiculo', N'IdVehiculo+'' ''+NumVeh', N'Vehiculos WHERE Inactivo=0 ORDER BY IdVehiculo', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.Modalidad', N'', N'VARCHAR', 10, 0, 0, N'', N'', N'Modalidad', N'Modalidad', 21, N'SP', N'LIST', N'', N'', N'ESPECIALES;TRATMIENTO', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.NumOrden', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'Num_Orden', N'NumOrden', 3, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.Observacion', N'', N'VARCHAR', 1000, 0, 0, N'', N'', N'Observ', N'Observacion', 64, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.TimeSys', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'FechaCrea', N'TimeSys', 67, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.TipDoc', N'', N'VARCHAR', 3, 0, 0, N'', N'', N'IdTipDoc', N'TipDoc', 1, N'SP', N'QRY', N'IdDoc', N'IdDoc+'' ''+TipoDoc', N'Sys_TiposDoc ORDER BY IdDoc', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.TipoAfiVehic', N'', N'VARCHAR', 10, 0, 0, N'', N'', N'TipoAfiVehic', N'TipoAfiVehic', 20, N'SP', N'LIST', N'', N'', N'PROPIO;AFILIADO;TERCEROS;OTRO', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.VrCosto', N'', N'MONEY', 0, 0, 0, N'', N'0', N'VrCosto', N'VrCosto', 23, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'O.VrTotal', N'', N'MONEY', 0, 0, 0, N'', N'0', N'VrTotal', N'VrTotal', 22, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'ObservAprob', N'', N'VARCHAR', 250, 0, 0, N'', N'', N'', N'', 61, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'OrigenAdd', N'', N'VARCHAR', 10, 0, 0, N'', N'', N'', N'', 70, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'PesoMax', N'', N'DECIMAL', 0, 0, 0, N'', N'0', N'', N'', 96, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'PesoVacio', N'', N'DECIMAL', 0, 0, 0, N'', N'0', N'', N'', 95, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'RemCliente', N'', N'VARCHAR', 30, 0, 0, N'', N'', N'', N'', 37, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'SerieChasis', N'', N'VARCHAR', 30, 0, 0, N'', N'', N'', N'', 98, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'T.IdLocal', N'', N'VARCHAR', 8, 0, 0, N'', N'', N'TercCdCiudad', N'IdLocal', 78, N'SP', N'QRY', N'IdLocal', N'Localidad+ ''  (''+ Departamento + '')''', N'Localidades AS L INNER JOIN Departamentos AS D ON L.IdDep=D.IdDep WHERE L.Inactivo=0 ORDER BY Localidad', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'T.Telefono', N'', N'VARCHAR', 20, 0, 0, N'', N'', N'TercTelefono', N'Telefono', 80, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'T.TelMovil', N'', N'VARCHAR', 20, 0, 0, N'', N'', N'TelCelular', N'TelMovil', 81, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'T.TipoId', N'', N'CHAR', 1, 0, 0, N'', N'', N'TercTipId', N'TipoId', 73, N'SP', N'LIST', N'', N'', N'N;C;E;O;U;T;R;P;X', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'TipFact', N'', N'VARCHAR', 3, 0, 0, N'', N'', N'', N'', 47, N'SP', N'QRY', N'IdDoc', N'IdDoc+'' ''+TipoDoc', N'Sys_TiposDoc ORDER BY IdDoc', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'TipLiq', N'', N'VARCHAR', 3, 0, 0, N'', N'', N'', N'', 54, N'SP', N'QRY', N'IdDoc', N'IdDoc+'' ''+TipoDoc', N'Sys_TiposDoc ORDER BY IdDoc', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'TipoAfil', N'', N'VARCHAR', 10, 0, 0, N'', N'', N'', N'', 108, N'SP', N'LIST', N'', N'', N'PROPIO;AFILIADO;TERCEROS;OTRO', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'TipoOrden', N'', N'VARCHAR', 10, 0, 0, N'', N'', N'', N'', 32, N'SP', N'LIST', N'', N'', N'EXTERNA;INTERNA', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'TipoResiduo', N'', N'VARCHAR', 100, 0, 0, N'', N'', N'', N'', 36, N'SP', N'N', N'', N'', N'', 0)
GO
print 'Processed 15300 total records'
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'UsuAprob', N'', N'VARCHAR', 11, 0, 0, N'', N'', N'', N'', 60, N'SP', N'QRY', N'IdUsuario', N'Usuario', N'adm_Usuarios WHERE Inactivo=0 ORDER BY Usuario', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'V.IdColor', N'', N'VARCHAR', 4, 0, 0, N'', N'', N'CdColor', N'IdColor', 89, N'SP', N'QRY', N'IdColor', N'NomColor', N'TiposCol ORDER BY NomColor', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'V.IdCrceria', N'', N'VARCHAR', 4, 0, 0, N'', N'', N'CdCarr', N'IdCrceria', 91, N'SP', N'QRY', N'IdCrceria', N'TipoCar', N'TiposCar ORDER BY TipoCar', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'V.IdLinea', N'', N'VARCHAR', 10, 0, 0, N'', N'', N'CdLinVeh', N'IdLinea', 87, N'SP', N'QRY', N'IdLinea', N'LineaVeh', N'MarcasLin WHERE Inactivo=0 ORDER BY LineaVeh', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'V.IdMarca', N'', N'VARCHAR', 4, 0, 0, N'', N'', N'CdMarca', N'IdMarca', 85, N'SP', N'QRY', N'IdMarca', N'Marca', N'Marcas WHERE TipoMarca IN (''GENERAL'',''VEHICULOS'') ORDER BY Marca', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'V.IdPpd', N'', N'VARCHAR', 4, 0, 0, N'', N'', N'CdTipProp', N'IdPpd', 105, N'SP', N'QRY', N'IdPpd', N'TipoProp', N'TiposPpt ORDER BY TipoProp', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'V.IdTipoVeh', N'', N'VARCHAR', 4, 0, 0, N'', N'', N'CdTipVeh', N'IdTipoVeh', 83, N'SP', N'QRY', N'IdTipoVeh', N'TipoVehiculo', N'TiposVeh ORDER BY TipoVehiculo', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'VehPropio', N'', N'BOOLEAN', 0, 0, 0, N'YES/NO', N'0', N'', N'', 107, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'VigJudicial', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'', N'', 117, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'VigLicencia', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'', N'', 123, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'VigSoat', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'', N'', 111, N'SP', N'N', N'', N'', N'', 0)
INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQryTraOrdenServRel', N'VrAnticipo', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 25, N'SP', N'N', N'', N'', N'', 0)