Generar Reporte con Generador de Consultas

[djesussap]

Buenas tardes.
Ayuda, quiero generar un reporte de Notas de Crédio que me arroje los siguientes campos:

1. Numero de Documento
2. Fecha de Contabilización
3. Folio Fiscal (CFDI)
4. Cadena Original
   Con los campos 1 y 2 no tengo problema, sin embargo no se como generar los campos 1 y 4
   Tengo lo siguiente:

SELECT T0.[DocNum], T0.[DocDate] FROM ORIN T0 WHERE T0.[DocDate] >‘20221231’

Gracias!

[lxrealmtz]

Hola buenos dias, yo ya tengo algo sobre eso el lunes o martes lo publico.

Saludos

[lxrealmtz]

Tengo este espero tre ayude.

SELECT T0.DocEntry,
‘NC’ as ‘Documento’,
T0.[DocNum],
T0.[DocDate],
T0.[DocDueDate],
T0.CardCode,
T0.CardName,
T1.OcrCode as ‘Centro de Costo’,
T2.[U_Estado] as ‘ZG’,
T2.[PrcName] as ‘Nombre Centro de Costo’,
T0.Numatcard,
sum(T1.[LineTotal]) as ‘Subtotal’,
T0.VatSum as ‘IVA’,
T0.WTSumSC as ‘Retención 6%’,
sum(T1.[LineTotal])+T0.VatSum as ‘Total’,
T0.[CANCELED],
T3.Code as ‘Periodo Contable’,
T1.[U_Monto],
T1.[U_Cantidad],
T1.[U_MES_A],
T1.[U_ANIO_A],
T4.ReportID

FROM ORIN T0
INNER JOIN RIN1 T1 ON T0.[DocEntry] = T1.[DocEntry]
INNER JOIN OPRC T2 ON T1.OcrCode = T2.PrcCode
INNER JOIN OFPR T3 ON T0.[FinncPriod] = T3.[AbsEntry]
LEFT JOIN ECM2 T4 ON T4.SrcObjType=14 and T4.SrcObjAbs = T0.DocEntry
WHERE T0.[DocDate] between [%0] and [%1]

GROUP BY T0.DocEntry, T0.[DocNum], T0.Numatcard, T0.[DocDate],T0.[DocDueDate], T0.CardCode,T0.CardName,T2.[U_Estado],
T0.VatSum, T0.WTSumSC,T1.OcrCode, T2.[PrcName], T0.[CANCELED],T3.Code,T1.[U_Monto], T1.[U_Cantidad],
T1.[U_MES_A], T1.[U_ANIO_A], T4.ReportID ORDER BY T0.[DocNum]