DATA HACH TOAN.txt
| 1 |
??S E L E C T A . R E F _ N O , A . T R N _ I D , A . A C C T , C A S E W H E N A . D R C R = ' D ' T H E N N ' N ? ' E L S E N ' C ? ' E N D A S N ' N ? / C ? ' , A . A M T , A . T R N _ D E S C , B . B R A N C H _ C O D E , C . B R A N C H _ C O D E A S D V _ C H I U _ C P , A . C H E C K E R _ I D , A . T R N _ D A T E F R O M P A Y _ E N T R I E S _ P O S T A |
|---|---|
| 2 |
L E F T J O I N C M _ B R A N C H B O N A . D O _ B R N = B . B R A N C H _ I D |
| 3 |
L E F T J O I N C M _ B R A N C H C O N A . B R N _ I D = C . B R A N C H _ I D |
| 4 |
|
| 5 |
U P D A T E P A Y _ E N T R I E S _ P O S T S E T R E F _ N O = ' 0 3 6 0 0 0 0 2 0 2 3 2 0 0 0 0 1 ' W H E R E T R N _ D E S C = ' T A M U N G C H I P H I T I E N D I E N S I N H H O A T C H O B V B C A M A U ( T U N G A Y 1 2 / 0 7 / 2 0 2 0 D E N 1 1 / 0 8 / 2 0 2 0 T H E O G D N T U N C C . 2 0 2 0 . 0 0 0 0 1 3 ' |