

ALTER PROCEDURE [dbo].[reg_doc_subtipoDocumento]
	@p_id INT
AS
BEGIN
	SELECT 	[id] AS [id],
		[uid] AS [uid],
		[eid] AS [eid],
		[id_usuario_modifico] AS [id_usuario_modifico],
		[id_usuario_creo] AS [id_usuario_creo],
		[fechaModificacion] AS [fechaModificacion],
		[fechaCreacion] AS [fechaCreacion],
		[active] AS [active],
		[subtipoDocumento] AS [subtipoDocumento],
		[subtipoDocumento_codigo] AS [subtipoDocumento_codigo],
		[prefijo] AS [prefijo],
		[consecutivo] AS [consecutivo],
		[id_tipoDocumento] AS [id_tipoDocumento],
		[programarPlaneadas] AS [programarPlaneadas],
		[cargarSolicitante] AS [cargarSolicitante],
		[verCentroCosto] AS [verCentroCosto],
		[verIncoterm] AS [verIncoterm],
		[valUrgente] AS [valUrgente],
		[bloquearDespacho] AS [bloquearDespacho],
		[cerrarSol] AS [cerrarSol],
		[ejecutaDevolucion] AS [ejecutaDevolucion],
		[tipoCobro] AS [tipoCobro]

	FROM [doc_subtipoDocumento]
	WHERE	(id = @p_id)

END
GO


