1 192.168.133.85
2 HANSHOTEL
3 sa
4 Sql-Winsar!40@
5 1

Here is the information on the sandbox account setup for your business:
 
--Portal link : https://einv-sandbox.internal.cleartax.co/
USER ID : harinder.kumar@anyahotels.com
Password:    Cleartax@2022
Dummy GSTN:   07AAFCD5862R007
Owner ID :   460d42a5-dadd-4a0f-90eb-d985c8ea56d9
Auth token:  1.b57e67e2-34b4-4c44-890e-ca4c2fb08ecd_fbaef9e87d847d1680c9af468be8c2dbff481a9bff3f3a75504e876de01856d5

--Live Links 
https://einvoicing.internal.cleartax.co/v2/
https://api-einv.cleartax.in/v2/eInvoice/cancel

--Banquet Module E-Invoice Enable Script
Alter table BN_CONTROL Add S4_IND numeric(1,0) null
GO
Update BN_CONTROL set S4_ind=1

--FO MISC - BILL NO - Backend
http://mobile.wincloudpms.net:9011/ClearTax_E_Invoice.aspx?BILLNO=72&CMPID=WS&REQTY=GST_E_INVOICE&TRNTYPE=FOMISC

--POS BILL - BILL NO AND OUTLET ID 
http://mobile.wincloudpms.net:9011/ClearTax_E_Invoice.aspx?BILLNO=29445&CMPID=WS&REQTY=GST_E_INVOICE&TRNTYPE=PSBILL&OUTID=RS
http://mobile.wincloudpms.net:9011/ClearTax_E_Invoice.aspx?BILLNO=78611&CMPID=WS&REQTY=GST_E_INVOICE&TRNTYPE=PSBILL&OUTID=DAK

-- FO CHECKOUT BILL - BILL NO 
http://mobile.wincloudpms.net:9011/ClearTax_E_Invoice.aspx?BILLNO=1193&CMPID=WS&REQTY=GST_E_INVOICE&TRNTYPE=FOBILL

--bq bill 
http://mobile.wincloudpms.net:9011/ClearTax_E_Invoice.aspx?BILLNO=1598&CMPID=WS&REQTY=GST_E_INVOICE&TRNTYPE=BQBILL

http://mobile.wincloudpms.net:9011/ClearTax_E_Invoice.aspx?BILLNO=43146&CMPID=WS&REQTY=GST_E_INVOICE&TRNTYPE=FOBILL

FO_LK_ST URL 
--http://mobile.wincloudpms.net:9011/ClearTax_E_Invoice.aspx?


--Data Selection Query 
SELECT * FROM FC_BILL WHERE GS_NO =
SELECT * FROM PS_BILL WHERE GS_NO =
SELECT * FROM BN_BILL WHERE GS_NO =
SELECT * FROM aamm0t0800
SELECT INV_REF,QR_CD_ID,GS_BILL,* FROM BN_BILL where PTX_RG_NO is not null and bill_dt > = '01/01/2021' and BILL_STATUS <> '9'

-- Checkout
http://mobile.wincloudpms.net:9011/ClearTax_E_Invoice.aspx?PN=HANSTEST&TRNTYPE=FOBILL&BILLNO=1193&REQTY=GST_E_INVOICE&CMPID=WS
http://mobile.wincloudpms.net:9011/ClearTax_E_Invoice.aspx?PN=HANSTEST&TRNTYPE=FOMISC&OUTID=TP&BILLNO=3&REQTY=GST_E_INVOICE&CMPID=WS