Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Reprocess Submit POS, for POS with Termin Payment (Piutang)
- -- cek process_message
- SELECT A.*
- FROM t_process_message A
- WHERE A.tenant_id = 10 AND
- A.process_name = 'i_ho_process_pos_shop' AND
- A.process_no = '280221041310400002'
- -- execute func reprocess
- BEGIN;
- SELECT i_ho_process_pos_shop_temp_for_fix(10, 'reprocess_pos_20210420', '280221041310400002');
- -- ROLLBACK;
- -- END;
- -- cek header journal
- SELECT * FROM gl_journal_trx WHERE doc_no = '280221041310400002';
- -- cek detail item journal
- SELECT B.doc_no, A.*
- FROM vw_gl_journal_trx_details A
- INNER JOIN gl_journal_trx B ON A.journal_trx_id = B.journal_trx_id
- WHERE B.doc_no = '280221041310400002';
- -------------------------------------------------------------------------------------------------------
- --Document list (total 31 records):
- /*
- docNo / process No docDate ou_id
- "280221041310400002" "20210413" 33
- "280221041311150006" "20210413" 33
- "280221041315160016" "20210413" 33
- "280821041309220002" "20210413" 15
- "280821041309370003" "20210413" 15
- "280821041309440004" "20210413" 15
- "280821041309530005" "20210413" 15
- "280821041310070008" "20210413" 15
- "280821041311150012" "20210413" 15
- "280821041312190020" "20210413" 15
- "280821041313140021" "20210413" 15
- "280821041313520025" "20210413" 15
- "280821041314150026" "20210413" 15
- "280821041314190027" "20210413" 15
- "280821041314300029" "20210413" 15
- "280521041411040001" "20210414" 39
- "280521041411100002" "20210414" 39
- "280521041411120003" "20210414" 39
- "280521041411150004" "20210414" 39
- "280821041410020002" "20210414" 15
- "280821041410430007" "20210414" 15
- "280821041411000011" "20210414" 15
- "280821041414080023" "20210414" 15
- "280821041414090024" "20210414" 15
- "280821041415050028" "20210414" 15
- "280821041415270030" "20210414" 15
- "283421041416310007" "20210414" 28
- "280221041510510003" "20210415" 33
- "280821041509070008" "20210415" 15
- "280821041510170012" "20210415" 15
- "283421041509470002" "20210415" 28
- */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement