1
|
select * from member where member_cd= 'jnm'; -- 7f8c3d45b01d4b948c1372e2c5644762 MemberId
|
2
|
select * from customer where customer_code='301k/156'; --1723B7E255864D7796A299B2CA4E6415 customer-id
|
3
|
select * from customer_to_user_relation where customer_id='1723B7E255864D7796A299B2CA4E6415'
|
4
|
--9A5046EB-7677-4EDA-8971-88586CA37C67 -- integration APi
|
5
|
|
6
|
select * from di_mobile_txn_collection_header where created_by= '7f8c3d45b01d4b948c1372e2c5644762';
|
7
|
select * from di_txn_invoice_history where member_id= '7f8c3d45b01d4b948c1372e2c5644762';
|
8
|
|
9
|
select * from txn_mobile_collection_invoice
|
10
|
|
11
|
|
12
|
select * from
|
13
|
|
14
|
|
15
|
|
16
|
|
17
|
-- Find invoice Id
|
18
|
SELECT
|
19
|
|
20
|
b.customer_code,
|
21
|
b.customer_name,
|
22
|
*
|
23
|
FROM
|
24
|
txn_invoice_history_header a
|
25
|
INNER JOIN
|
26
|
customer b ON a.customer_id = b.customer_id
|
27
|
WHERE
|
28
|
a.org_id ='goldcrest'
|
29
|
AND customer_code = '301k/156'
|
30
|
order by a.created_date desc
|
31
|
|
32
|
|
33
|
-- To get the Collection_id
|
34
|
SELECT *
|
35
|
FROM txn_mobile_collection_invoice
|
36
|
WHERE inv_id IN ('14c7824b-eaf7-4e7e-98be-597eaf9489b7', '27dfb513-fdda-44a1-b92f-4c74ea527158', '6A7CEFC0C1B04F44AA8F272F152551F4', 'd6be9ff8-da3c-408f-ba07-c46ea1670f2a', '8B9B0728C83641DFAFC119CCE587B4BB')
|
37
|
order by created_date desc
|
38
|
|
39
|
|
40
|
-- I could not find this collection invoice
|
41
|
select * from txn_mobile_collection_invoice WHERE inv_id ='14c7824b-eaf7-4e7e-98be-597eaf9489b7'
|
42
|
|
43
|
SELECT *
|
44
|
FROM txn_mobile_collection_invoice
|
45
|
WHERE inv_id='14c7824b-eaf7-4e7e-98be-597eaf9489b7'
|
46
|
|
47
|
|
48
|
|
49
|
-- collection header
|
50
|
select * from txn_mobile_collection_header where col_id IN ('33acd5b5-0663-4213-bc5b-24b4df727a85',
|
51
|
'f7f75de9-fc87-43f9-95fc-45c7f66fd13c',
|
52
|
'6A7CEFC0C1B04F44AA8F272F152551F4',
|
53
|
'639592ef-7488-48ba-a14a-1c7025f7e39c',
|
54
|
'4ccebc1a-ae61-46bd-b0c8-128a9cecfbfd',
|
55
|
'38cef976-84b8-4f15-b05f-1a7c63313f7e') order by created_date desc
|
56
|
|
57
|
-- get the collection detail
|
58
|
SELECT *
|
59
|
FROM txn_mobile_collection_detail
|
60
|
WHERE col_id IN ('33acd5b5-0663-4213-bc5b-24b4df727a85',
|
61
|
'f7f75de9-fc87-43f9-95fc-45c7f66fd13c',
|
62
|
'6A7CEFC0C1B04F44AA8F272F152551F4',
|
63
|
'639592ef-7488-48ba-a14a-1c7025f7e39c',
|
64
|
'4ccebc1a-ae61-46bd-b0c8-128a9cecfbfd',
|
65
|
'38cef976-84b8-4f15-b05f-1a7c63313f7e') order by created_date desc
|