EFECTIVO AL RECIBIR
Run to view results
ORDENES COMPLETADAS EFECTIVO AL RECIBIR
Run to view results
ORDENES CANCELADAS CON EFECTIVO AL RECIBIR
Run to view results
Base General
Run to view results
EFECTIVO AL RECIBIR SIN CREDITO
Run to view results
SELECT DATE_TRUNC('WEEK', ost."CREATED_AT") AS "CREATED_AT",
ost."SOURCE_COUNTRY" AS "SOURCE_COUNTRY",
ost."CLIENT_TUL_CODE" AS "CLIENT_TUL_CODE",
ost."ORDERS_TUL_CODE" AS "ORDERS_TUL_CODE",
ost."ORDERS_STATUS" AS "ORDERS_STATUS",
ost."ORDER_PAYMENT" AS "ORDER_PAYMENT",
ost."SELLER" AS "SELLER",
cl."TIME_LAST_ORDER" AS "TIME_LAST_ORDER",
sum(ost."GMV_CREADO") AS "SUM(GMV_CREADO)",
MAX(ofc.product_limit_approved_amount) AS product_limit_approved_amount
FROM prod_modeled.official_sale_transactions ost
LEFT JOIN analytics.prod_modeled.clients as cl
ON ost."CLIENT_UUID" = cl."UUID"
LEFT JOIN ANALYTICS.PARADIME_AHERNANDEZ_MODELED.OFFICIAL_FINTECH_CONTROL ofc
ON ost."CLIENT_TUL_CODE" = ofc."CLIENT_TUL_CODE"
WHERE ost."CREATED_AT" >= TO_DATE('2024-07-01')
AND ost."CREATED_AT" < TO_DATE('2024-12-24')
AND ost."SOURCE_COUNTRY" IN ('MEXICO')
AND ost."SELLER" NOT IN ('bodega Fontibon')
AND ost."ORDER_PAYMENT" IN ('Efectivo al recibir')
GROUP BY DATE_TRUNC('WEEK', ost."CREATED_AT"),
ost."SOURCE_COUNTRY",
ost."CLIENT_TUL_CODE",
ost."ORDERS_TUL_CODE",
ost."ORDERS_STATUS",
ost."ORDER_PAYMENT",
ost."SELLER",
cl."TIME_LAST_ORDER"
Run to view results
select source_country, order_payment
from prod_modeled.official_sale_transactions ost
group by source_country , order_payment
order by source_country
Run to view results
Run to view results