Scribd
Upload
29 views4 pages

SQL Queries for Document Management

The document contains 3 SQL queries: 1. The first query retrieves manual journal entries without support documents from the last 7 days. 2. The second query lists related documents for purchase orders, including order, purchase order, receipt, and invoice numbers. 3. The third query lists related documents for sales orders, including order, delivery, and invoice numbers as well as their statuses and whether they were canceled.

Uploaded by

jose plasencia
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
29 views4 pages

SQL Queries for Document Management

The document contains 3 SQL queries: 1. The first query retrieves manual journal entries without support documents from the last 7 days. 2. The second query lists related documents for purchase orders, including order, purchase order, receipt, and invoice numbers. 3. The third query lists related documents for sales orders, including order, delivery, and invoice numbers as well as their statuses and whether they were canceled.

Uploaded by

jose plasencia
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

QUERY MANAGER

Alertas>Asientos Manuales sin sustento

SELECT
[Link] as NRO_ASIENTO,[Link] as NRO_ORIGEN,[Link] AS
FECHA_CREACION,[Link] AS FECHA_DOC,
--[Link] AS NRO_ACTIVIDAD,
--[Link] AS NRO_ANEXO,
--[Link] AS TIPO_ACT,
t2.u_name as USUARIO
FROM OJDT T0 LEFT JOIN OCLG T1 ON [Link]=[Link] and [Link] ='30' LEFT join
OUSR t2 on [Link]=[Link]
where (DATEDIFF(day, [Link] , GETDATE() ))<=7 AND [Link]='I' AND
[Link] IN (391,392) and [Link] = 30
and [Link] is null
COSTOS Y PRESUPUESTOS>COST009 Listado de Documentos Relacionados COMPRAS

select distinct [Link] as OV_NroPedido,[Link] as OV_CodCli,[Link] as


OV_NomClien,[Link] as Nro_OC,[Link] as OC_Num_Prove,[Link] as
OC_Nomb_Prove,[Link] as OC_Fecha_Doc ,[Link] as OC_Estado,[Link] as
OC_CodArt,[Link] as OC_Cantid,[Link] as OC_PreecUnit,[Link] as
OC_IndImpuest,[Link] as OC_TipCamb,[Link] as OC_Moneda,[Link] as
OC_TotalLinea,[Link] as Nro_EM,[Link] as EM_FechaContab,[Link] as
EM_Estado,[Link] as Nro_FP,[Link] as FP_FechaContab,[Link] as FP_Estado
from ordr t0 left join rdr1 t1 on [Link]=[Link]
left join POR1 t2 on [Link]=[Link] and [Link]=17
left join opor t3 on [Link]=[Link]
left join pdn1 t4 on [Link]=[Link] and [Link]=22
left join opdn t5 on [Link]=[Link]
left join PCH1 t6 on [Link]=[Link] and [Link]=20
left join opch t7 on [Link]=[Link]
where [Link]=[%0]
COSTOS Y PRESUPUESTOS>COST010 Listado De Documentos Relacionados VENTAS

select distinct [Link] as OV_NroPedido,[Link] as OV_CodCli,[Link] as


OV_NomClien,[Link] as OV_Cancelado,[Link] as Nro_E,[Link] as
E_FechaContab,[Link] as E_Estado,[Link] as E_Cancelado,[Link] as
Nro_FD,[Link] as Nro_Sunat,[Link] as FD_FechaContab,[Link] as
FD_Estado,[Link] as FD_Cancelado
from ORDR t0 left join RDR1 t1 on [Link]=[Link]
left join DLN1 t2 on [Link]=[Link] and [Link]=17
left join ODLN t3 on [Link]=[Link]
left join INV1 t4 on [Link]=[Link] and [Link]=15
left join OINV t5 on [Link]=[Link]
where [Link]=[%0]
GENERAL>CUENTAS POR COBRAR CON DETALLE DE COBROS CARLOS

declare @fecini datetime


declare @fecfin datetime

set @fecini=(SELECT top 1 [Link] from [dbo].[OINV] T0 where [Link]='[%0]')


set @fecfin=(SELECT top 1 [Link] from [dbo].[OINV] T1 where [Link]='[%1]')

EXEC STR_SP_CXC_DETALLE_PAGOS_2 @fecini,@fecfin

You might also like