By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
function_code | reverse_reason | reason_code | policy_no | agent_code | tran_date |
---|---|---|---|---|---|
CA | UR | ***** | X22****875 | 102/11/01 | |
CA | 2 | UR | ***** | R12****296 | 112/04/01 |
CA | UR | ***** | B22****899 | 106/12/01 | |
CA | UR | ***** | B12****650 | 102/11/01 | |
CA | UR | ***** | Q22****296 | 106/12/01 | |
CA | UR | ***** | L12****081 | 106/12/01 | |
CA | UG | ***** | S22****735 | 103/10/01 | |
CA | UG | ***** | N22****610 | 106/12/01 | |
CA | T4 | ***** | Q22****171 | 102/09/01 | |
CC | T4 | TW0***** | F22****895 | 109/12/31 | |
CC | T4 | TW0***** | B12****269 | 111/08/31 | |
CC | T4 | TW0***** | H22****456 | 108/09/30 | |
CC | T4 | TW0***** | L12****267 | 108/12/31 | |
F1 | 20 | 160*****9897 | T12****600 | 108/03/07 | |
F1 | 2 | 20 | 176*****2974 | Q12****583 | 108/03/07 |
F1 | 3 | 20 | 171*****0666 | T12****286 | 108/03/07 |
F1 | 10 | 178*****3835 | T22****421 | 112/07/24 | |
F1 | 16 | 147*****7693 | X12****674 | 103/07/14 |
No | function_code | reverse_reason | reason_code | policy_no | agent_code | tran_date |
---|---|---|---|---|---|---|
1 | CA | T4 | ***** | Q22****171 | 102/09/01 | |
1 | CA | UG | ***** | N22****610 | 106/12/01 | |
1 | CA | UR | ***** | B22****899 | 106/12/01 | |
1 | CA | 2 | UR | ***** | R12****296 | 112/04/01 |
1 | CC | T4 | TW0***** | B12****269 | 111/08/31 | |
1 | F1 | 10 | 178*****3835 | T22****421 | 112/07/24 | |
1 | F1 | 16 | 147*****7693 | X12****674 | 103/07/14 | |
1 | F1 | 20 | 160*****9897 | T12****600 | 108/03/07 | |
1 | F1 | 2 | 20 | 176*****2974 | Q12****583 | 108/03/07 |
1 | F1 | 3 | 20 | 171*****0666 | T12****286 | 108/03/07 |