txn_mobile_collection_header.sql
| 1 |
--insert into txn_mobile_collection_header
|
|---|---|
| 2 |
|
| 3 |
select
|
| 4 |
'BB979566-87B6-4356-819B-66CDF723ECC3' as [col_id] |
| 5 |
,'CCWWX000171-240215' as [col_no] |
| 6 |
,'a30de924-d967-4148-8559-b65b29f282f7' as [txn_id] |
| 7 |
,53.00 as [total_cheque_amt] |
| 8 |
,0.00 as [total_cn_amt] |
| 9 |
,53.00 as [total_col_amt] |
| 10 |
,'Auto-Approved' as [status] |
| 11 |
,'GOLDCREST' as [org_id] |
| 12 |
,'GOLDCREST' as [tenant_id] |
| 13 |
,'2024-02-15' as [created_date] |
| 14 |
,'dc954dfdc1db4e2aaf9d2759a1522725' as [created_by] |
| 15 |
,'2024-02-15' as [updated_date] |
| 16 |
,'dc954dfdc1db4e2aaf9d2759a1522725' as [updated_by] |
| 17 |
,null as [bank] |
| 18 |
,null as [journal_notation] |
| 19 |
,null as [payment_narration] |
| 20 |
,null as [approver_id] |
| 21 |
,null as [remark] |
| 22 |
,null as [temporary_receipt] |
| 23 |
,'2024-02-15 22:05:49.090' as [sync_date] |
| 24 |
,'' as [reason_id] |