INSERT [dbo].[Sys_Fields] ([IdEntidad], [IdCampo], [Descripcion], [TipoDato], [LongMax], [Requerido], [PmryKey], [FmtValue], [DftValue], [AliasFld], [AliasQry2], [IndField], [TipoEntidad], [LstTipo], [LstClnaValor], [LstClnaLista], [LstQuery], [Inactivo]) VALUES (N'paQrytm_NiifMov', N'C.IdCCosto', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'CdCenCosto', N'IdCCosto', 16, N'SP', N'QRY', N'IdCCosto', N'CCosto+'' ''+IdCCosto', N'CentroCosto WHERE Inactivo=0 ORDER BY Ccosto', 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'paQrytm_NiifMov', N'C.IdCia', N'', N'CHAR', 2, 0, 0, N'', N'', N'CdCia', N'IdCia', 6, 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'paQrytm_NiifMov', N'C.IdCuenta', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'CdCuenta', N'IdCuenta', 1, N'SP', N'QRY', N'IdCuenta', N'IdCuenta+'' ''+NomCuenta', N'PucNiif WHERE Movimiento<>0 ORDER BY IdCuenta', 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'paQrytm_NiifMov', N'C.IdSubCos', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'CdSubcentro', N'IdSubCos', 18, N'SP', N'QRY', N'IdSubCos', N'SubCosto+'' ''+IdSubCos', N'SubCentros WHERE Inactivo=0 ORDER BY SubCosto', 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'paQrytm_NiifMov', N'C.IdTercero', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'NitTercero', N'IdTercero', 13, 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'paQrytm_NiifMov', N'CiuOrigen', N'', N'VARCHAR', 8, 0, 0, N'', N'', N'', N'', 48, 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'paQrytm_NiifMov', N'CodAgencia', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'', N'', 100, 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'paQrytm_NiifMov', N'CodAgncia', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'', N'', 50, 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'paQrytm_NiifMov', N'CodCargo', N'', N'VARCHAR', 4, 0, 0, N'', N'', N'', N'', 43, N'SP', N'QRY', N'IdCargo', N'Cargo', N'Cargos ORDER BY Cargo', 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'paQrytm_NiifMov', N'CodConce', N'', N'VARCHAR', 4, 0, 0, N'', N'', N'', N'', 26, N'SP', N'QRY', N'IdConcepto', N'Concepto+'' (''+IdDoc+'')''+IdConcepto', N'Conceptos ORDER BY IdDoc,Concepto', 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'paQrytm_NiifMov', N'CodCta', N'', N'VARCHAR', 4, 0, 0, N'', N'', N'', N'', 35, N'SP', N'QRY', N'IdCta', N'NumeroCta+'' ''+Banco', N'CtasCorrientes INNER JOIN Bancos ON CtasCorrientes.IdBanco=Bancos.IdBanco ORDER BY NumeroCta', 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'paQrytm_NiifMov', N'CodCuentaCG', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'', N'', 57, N'SP', N'QRY', N'IdCuenta', N'IdCuenta+'' ''+NomCuenta', N'Puc WHERE Movimiento<>0 ORDER BY IdCuenta', 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'paQrytm_NiifMov', N'CodSubgpo', N'', N'VARCHAR', 8, 0, 0, N'', N'', N'', N'', 46, N'SP', N'QRY', N'IdSubgrupo', N'Subgrupo+'' (''+Grupo+'')''', N'SubGrupos INNER JOIN Grupos ON SubGrupos.IdGrupo=Grupos.IdGrupo ORDER BY Subgrupo', 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'paQrytm_NiifMov', N'Comprobante', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'', N'', 5, 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'paQrytm_NiifMov', N'Consolida', N'', N'BOOLEAN', 0, 0, 0, N'YES/NO', N'0', N'', N'', 42, 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'paQrytm_NiifMov', N'CTE.IdBanco', N'', N'VARCHAR', 4, 0, 0, N'', N'', N'CodBanco', N'IdBanco', 37, N'SP', N'QRY', N'IdBanco', N'IdBanco+'' ''+Banco', N'Bancos WHERE Inactivo=0 ORDER BY IdBanco', 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'paQrytm_NiifMov', N'Detalle', N'', N'VARCHAR', 250, 0, 0, N'', N'', N'', N'', 10, 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'paQrytm_NiifMov', N'DocRef', 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'paQrytm_NiifMov', N'Documento', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'', N'', 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'paQrytm_NiifMov', N'Factura', N'', N'VARCHAR', 15, 0, 0, N'', N'', N'', N'', 31, 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'paQrytm_NiifMov', N'Fecha', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'', N'', 9, 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'paQrytm_NiifMov', N'FecVence', N'', N'DATETIME', 0, 0, 0, N'dd/mm/yyyy', N'', N'', N'', 34, 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'paQrytm_NiifMov', N'IdCiaDoc', N'', N'CHAR', 2, 0, 0, N'', N'', N'', N'', 25, 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'paQrytm_NiifMov', N'IdCiaFac', N'', N'CHAR', 2, 0, 0, N'', N'', N'', N'', 32, 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'paQrytm_NiifMov', N'IdCiaRef', 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'paQrytm_NiifMov', N'IdVehiculo', N'', N'VARCHAR', 10, 0, 0, N'', N'', N'', N'', 15, 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'paQrytm_NiifMov', N'Integrado', N'', N'BOOLEAN', 0, 0, 0, N'YES/NO', N'0', 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'paQrytm_NiifMov', N'Item', N'', N'INTEGER', 0, 0, 0, N'', N'0', 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'paQrytm_NiifMov', N'ItemFac', N'', N'INTEGER', 0, 0, 0, N'', N'0', N'', N'', 33, 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'paQrytm_NiifMov', N'L.IdDep', N'', N'VARCHAR', 8, 0, 0, N'', N'', N'CdDep', N'IdDep', 96, N'SP', N'QRY', N'IdDep', N'Departamento', N'Departamentos ORDER BY Departamento', 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'paQrytm_NiifMov', N'NitDoc', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'', N'', 28, 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'paQrytm_NiifMov', N'NitOtros', N'', N'VARCHAR', 16, 0, 0, N'', N'', N'', N'', 44, 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'paQrytm_NiifMov', N'NumCheque', N'', N'VARCHAR', 20, 0, 0, N'', 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'paQrytm_NiifMov', N'NumeroCta', N'', N'VARCHAR', 20, 0, 0, N'', N'', N'', N'', 36, 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'paQrytm_NiifMov', N'Referencia', N'', N'VARCHAR', 50, 0, 0, N'', N'', N'', N'', 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'paQrytm_NiifMov', N'Referncia', N'', N'VARCHAR', 50, 0, 0, N'', N'', 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'paQrytm_NiifMov', N'T.IdLocal', N'', N'VARCHAR', 8, 0, 0, N'', N'', N'TercCdCiudad', N'IdLocal', 94, 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'paQrytm_NiifMov', N'T.Telefono', N'', N'VARCHAR', 20, 0, 0, N'', N'', N'TercTelefono', N'Telefono', 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'paQrytm_NiifMov', N'T.TipEnte', N'', N'CHAR', 1, 0, 0, N'', N'', N'TercTipEnte', N'TipEnte', 99, N'SP', N'LIST', N'', N'', N'J;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'paQrytm_NiifMov', N'T.TipoId', N'', N'CHAR', 1, 0, 0, N'', N'', N'TercTipo', N'TipoId', 89, 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'paQrytm_NiifMov', N'TarifaBase', N'', N'DECIMAL', 0, 0, 0, N'', N'0', N'', N'', 21, 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'paQrytm_NiifMov', N'TC.IdDiario', N'', N'VARCHAR', 4, 0, 0, N'', N'', N'CdDiario', N'IdDiario', 87, N'SP', N'QRY', N'IdDiario', N'Diario', N'Diarios ORDER BY Diario', 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'paQrytm_NiifMov', N'TipCom', N'', N'VARCHAR', 3, 0, 0, N'', N'', N'', N'', 3, N'SP', N'QRY', N'IdCom', N'IdCom+'' ''+TipoCom', N'TiposCom ORDER BY IdCom', 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'paQrytm_NiifMov', N'TipDoc', N'', N'VARCHAR', 3, 0, 0, N'', N'', N'', N'', 22, N'SP', N'QRY', N'IdDoc', N'IdDoc+'' ''+TipoDoc', N'Sys_TiposDoc WHERE Inactivo=0 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'paQrytm_NiifMov', N'TipDocRef', N'', N'VARCHAR', 3, 0, 0, N'', N'', N'', N'', 54, N'SP', N'QRY', N'IdDoc', N'IdDoc+'' ''+TipoDoc', N'Sys_TiposDoc WHERE Inactivo=0 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'paQrytm_NiifMov', N'TipFac', N'', N'VARCHAR', 3, 0, 0, N'', N'', N'', N'', 30, N'SP', N'QRY', N'IdDoc', N'IdDoc+'' ''+TipoDoc', N'Sys_TiposDoc WHERE Inactivo=0 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'paQrytm_NiifMov', N'TipoAplica', N'', N'CHAR', 1, 0, 0, N'', N'', N'', N'', 41, N'SP', N'LIST', N'', N'', N'N;A;C', 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'paQrytm_NiifMov', N'VehPropio', 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'paQrytm_NiifMov', N'VrBase', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 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'paQrytm_NiifMov', N'VrCredito', N'', N'MONEY', 0, 0, 0, N'', N'0', 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'paQrytm_NiifMov', N'VrDebito', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 11, 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'paQrytm_NiifMov', N'VrSanCc', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 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'paQrytm_NiifMov', N'VrSanCcCia', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 65, 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'paQrytm_NiifMov', N'VrSanCcSub', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 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'paQrytm_NiifMov', N'VrSanCcSubCia', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 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'paQrytm_NiifMov', N'VrSanCue', N'', N'MONEY', 0, 0, 0, N'', N'0', 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'paQrytm_NiifMov', N'VrSanCueCia', N'', N'MONEY', 0, 0, 0, N'', N'0', 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'paQrytm_NiifMov', N'VrSanNit', N'', N'MONEY', 0, 0, 0, N'', N'0', 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'paQrytm_NiifMov', N'VrSanNitAge', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 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'paQrytm_NiifMov', N'VrSanNitAgeCc', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 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'paQrytm_NiifMov', N'VrSanNitAgeCcCia', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 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'paQrytm_NiifMov', N'VrSanNitAgeCcSub', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 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'paQrytm_NiifMov', N'VrSanNitAgeCcSubCia', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 77, 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'paQrytm_NiifMov', N'VrSanNitAgeCia', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 73, 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'paQrytm_NiifMov', N'VrSanNitCc', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 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'paQrytm_NiifMov', N'VrSanNitCcCia', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 69, 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'paQrytm_NiifMov', N'VrSanNitCcSub', N'', N'MONEY', 0, 0, 0, N'', N'0', 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'paQrytm_NiifMov', N'VrSanNitCcSubCia', N'', N'MONEY', 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'paQrytm_NiifMov', N'VrSanNitCia', N'', N'MONEY', 0, 0, 0, N'', N'0', 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'paQrytm_NiifMov', N'VrSanNitVeh', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 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'paQrytm_NiifMov', N'VrSanNitVehCc', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 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'paQrytm_NiifMov', N'VrSanNitVehCcCia', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 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'paQrytm_NiifMov', N'VrSanNitVehCia', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 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'paQrytm_NiifMov', N'VrSanVeh', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 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'paQrytm_NiifMov', N'VrSanVehCc', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 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'paQrytm_NiifMov', N'VrSanVehCcCia', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 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'paQrytm_NiifMov', N'VrSanVehCcSub', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 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'paQrytm_NiifMov', N'VrSanVehCcSubCia', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 85, 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'paQrytm_NiifMov', N'VrSanVehCia', N'', N'MONEY', 0, 0, 0, N'', N'0', N'', N'', 63, N'SP', N'N', N'', N'', N'', 0)