txn_mobile_collection_detail.sql
| 1 |
--insert into txn_mobile_collection_detail
|
|---|---|
| 2 |
|
| 3 |
select
|
| 4 |
newid() as [col_dtl_id]
|
| 5 |
,'BB979566-87B6-4356-819B-66CDF723ECC3' as [col_id] |
| 6 |
,'Cash' as [doc_type] |
| 7 |
,'Cash' as [doc_no] |
| 8 |
,'53.00' as [doc_amt] |
| 9 |
,'2024-02-15'[doc_date]
|
| 10 |
,'0.00' as [doc_unpaid] |
| 11 |
,'Auto-Approved' as [status] |
| 12 |
,'' as [remark] |
| 13 |
,'GOLDCREST' as [org_id] |
| 14 |
,'GOLDCREST' as [tenant_id] |
| 15 |
,'2024-02-15' as [created_date] |
| 16 |
,'dc954dfdc1db4e2aaf9d2759a1522725' as [created_by] |
| 17 |
,'2024-02-15' as [updated_date] |
| 18 |
,'dc954dfdc1db4e2aaf9d2759a1522725' as [updated_by] |
| 19 |
,null as [mobile_remark] |
| 20 |
,null as [web_remark] |
| 21 |
,'53.00' as [mobile_paid] |
| 22 |
,'53.00' as [web_paid] |
| 23 |
,'' as [bank] |
| 24 |
,'' as [journal_notation] |
| 25 |
,'' as [payment_narration] |
| 26 |
,'' as [temporary_receipt] |