Verificar si una venta se cargo en RMS cuando el JOB POSUPLD queda en status ABORTED

validation-loadsales-rms.sql

-- To verify if a POSU file was successfully loaded even though the job "POSUPLD.PC" culminates in ABORTED, without errors or rejected items, verify the following query at the time it aborts:
select * from tran_data
where location=&idstore -- Store
and tran_date='&salesdate' -- Sales date
and pgm_name='posupld';

-- To verify the day after the batch
select * from if_tran_data
where location=&idstore -- Store
and tran_date='&salesdate' -- Sales date
and pgm_name='posupld';

-- To check in the historical:
select * from tran_data_history
where location=&idstore -- Store
and tran_date='&salesdate' -- Sales date
and pgm_name='posupld';
 
-- The STG_FIF_GL_DATA table, is the integration table with EBS-GL; and DAILY_DATA table is the STOCK LEDGER table day trading.