txn_mobile_collection_invoice.sql
| 1 |
--insert into txn_mobile_collection_invoice
|
|---|---|
| 2 |
|
| 3 |
SELECT newid() as [col_inv_id] |
| 4 |
,'BB979566-87B6-4356-819B-66CDF723ECC3' as [col_id] |
| 5 |
,'eed53741-83f5-4255-97eb-542527b46049' as [inv_id] |
| 6 |
,'' as [receipt_no] |
| 7 |
,53.00 as[previous_balance] |
| 8 |
,53.00 as[col_amt] |
| 9 |
,0.00 as [new_balance] |
| 10 |
,'Auto-Approved' as [status] |
| 11 |
,'2024-02-15' as [created_date] |
| 12 |
,'dc954dfdc1db4e2aaf9d2759a1522725' as [created_by] |
| 13 |
,'2024-02-15' as [updated_date] |
| 14 |
,'dc954dfdc1db4e2aaf9d2759a1522725' as [updated_by] |
| 15 |
,'GOLDCREST' as [org_id] |
| 16 |
,'GOLDCREST' as [tenant_id] |
| 17 |
,null as [mobile_remark] |
| 18 |
,null as [web_remark] |
| 19 |
,53.00 as[web_paid] |
| 20 |
,null as [web_new_balance] |