Codelayer API Documentation

Update Audited entries

frontoffice/updateaudited

POST

application/json

application/json

Parameter	Data Type	Min	Max	M/O	Sample Value	Comments
key	String	32	32	M	hjO2OI4zlBPHUVLyaoBLPeyalTdUi9Cp	Key obtained from authentiaction.
customername	String			M	CUSTOMER NAME	Customer name
customercode	Integer			M	784	Customer code
baddress	String			M	ADDRESS	Customer billing address
cpin	Integer			M	695001	Customer pin code
accountto	String			M	45	Customer head for ledger posting
placeid	String			M	4	Place ID
placedetails	Array			M		Place details
place	String			M	PLACE	Customer place name
placecode	Integer			M	4	Place ID
stateid	String			M	KER	State ID
gststatecode	Integer			M	32	State code for GST
distance	String			M	150.00	Distance between Firm and Customer place
vcode	Integer			M	645	Vehicle code
vtype	String			M	X	Vehicle type, X - external vehicle, O - Own vehicle
vehicledetails	Array			M		Vehicle details
vcode	Integer			M	654	Vehicle code
rgno	String			M	KL 01 AA 1234	Registration number of the vehicle
vtype	String			M	X	Vehicle type, X - external vehicle, O - own vehicle
capacity	Decimal			M	800.00	Weight loading capacity of vehicle
ecapacity	Decimal			M	100.00	Extra weight loading capacity of vehicle
height	Decimal			M	8.00	Height of vehicle
length	Decimal			M	15.00	Length of vehicle
width	Decimal			M	5.00	Width of vehicle
constant	Decimal			M	45.00	Constant speed of vehicle
mtype	String			M	M	Metrics type, M - Meters, I - inches
freeze	String			M	F	Whether vehicle is active or not
drivercode	Integer			M	32	Driver code
taxcalcneeded	String			M	T	Whether tax calculation is needed or not
remarks	String			M	REMARKS	Remarks for the entry
itemdetails	Array			M		Product details
scheduleid	String			M	10	Schedule ID for tax calculation
uomid	Integer			M	7	Unit of Measurement ID
qty	Decimal			M	800	Product quantity
aqty	Decimal			M	100.00	Additional product quantity
uprice	Decimal			M	35.00	Rate of product per unit of product
discount	Decimal			M	100.00	Discount for sale
userenteredprice	Decimal			M	30.00	Price of product entered by Customer
taxpercent	Decimal			M	5.00	Percentage of tax
taxdetails	Array			M		Tax details
TaxPercentage	String			M	5.00	Pecentage of tax
TaxDisplayName	String			M	SGST	Name of tax
PostingHeadCode	Integer			M	110	Sales posting head
PostingAmount	Decimal			M	1100.00	Amount of tax
TaxFormulaCode	String			M	SGST	Formula code for GST calculation, SGST, CGST, IGST
taxrowid	String			M	5	Row index of tax rows
detslno	Integer			M	1	Serial number of entry in details table
itemcode	Integer			M	8	Product code
itemdetails	Array			M		Product details
hsncode	String			M	25171010	HSN code of product
pcode	Integer			M	8	Product code
hsnid	Integer			M	2661	HSN ID of product
stockunit	Integer			M	10	Stock unit of product in product master
ptype	String			M	P	Product type, P - Product, M - Material, S - Service
saleshead	Integer			M	1	Sales head
scheduleid	Integer			M	3	Schedule ID for tax calculation
productunitwiseratedet	Array			M		Unit wise rate of product
uomid	Integer			M	10	Unit of Measurement ID
pcode	Integer			M	789	Product code
prate	Decimal			M	53.00	Rate of product
pname	String			M	ITEM	Product name
fyear	Integer			M	23	Financial year
gstreferanceno	String			M	DC/23/230427002	GST referance number with ledger folio
eventtype	String			M	A	Event type, A - Add, E - Edit, C - Cancel
folio	String			M	DC	Ledger folio
invdata	String			M		Invoice data of the entry (used only in response for fetching invoice data)
iqmslno	String			M		Unique number generated for the entry(used only in web application)
iqmfyear	Integer			M		Financial year (used only in web application)
grossamt	Decimal			M	10000.00	Grand total amount of the entry
int_referanceno	String			M	nFc9ryddo2HknNLi4SNqvQ==	Encrypted GST referance number with leger folio (used only in web application)
ledgerdetails	Array			M		Ledger details
lfolio	String			M	DC	Ledger folio
laccode	Integer			M	8431	Ledger posting sales head account code
extype	String			M		Expense type (not used in Front Office API)
lremark	String			M	Sales - KL 01 AA 1234(PROD-AMT@RATE)	Ledger posting remarks of the entry
lamount	Decimal			M	10000.00	Ledger posting amount
dc	String			M	D	Mode of sale, D - Debit, C - Credit
einvirn	String			M		Unique Invoice Referance Number (used only in web application)
einvjson	String			M		E-Invoice data as JSON string (used only in web application)
einvqrcode	String			M		E-Invoice unique QR code (used only in web application)
einvcancdate	String			M		E-Invoice date of entry cancellation (used only in web application)
ewaybillno	String			M		Unique number generated for Eway bill (used only in web application)
ewbresult	String			M		Fetches the result whether generation of Eway bill is succes or not (used only in web application)
lcashrefno	String			M		Lorry cash referance number, if lorry cash is entered data will be fetched (used for add or edit event type on saving an invoice)
saddress	String			M	ADDRESS	Sundry address
agent	Integer			M	654	Agent code
autoroundoff	String			M	F	Auto roundoff needed or not
autoroundoffvalue	Integer			M	1	Value that will rounded off automatically
roundoff	Decimal			M	0.52	Round off amount
source	String			M	S	Source, S - Stock, B - Bunker, P - From Purchase
bank	Integer			M	2	Bank ID
lorrycash	Decimal			M	100.00	Lorry cash amount
gstrefno	String			M	2306010001	GST referance number
islno	Integer			M	12	Unique number generated for the entry
eventid	String			M	255	Event ID
invmode	String			M	D	Mode of transaction, D - Debit, C - Credit
invtype	String			M	BU	Transaction Type
edate	String			M	2023-4-27	Entry date
etime	String			M	2023-4-27 05:17AM	Time of bill entered
firmstateid	String			M	KER	State ID of firm
firmgstin	String			M	32AFJPK9650E1ZH	GSTIN of firm
firmid	Integer			M	1	Firm ID
einv_Client_Id	String			M	A19C0117AFDD4	E-Invoice Client ID
cancel	String			M	F	Whether entry is cancelled or not
customerdetails	Array			M		Customer details
sphone	String			M	9876543210	Customer phone number
baddress	String			M	CUSTOMER ADDRESS	Customer address
pan	String			M	ABCTY1234D	Customer PAN number
spin	Integer			M	695001	Customer Pin code
agentname	String			M	AGENT	Agent name
gstregistrationmode	Integer			M	1	GST registration mode, 1 - Normal, 2 - Compound, 3 - Unregistered, 4 - NotifiedServiceProviderWithReverseCharge
name	String			M	CUST	Customer name
code	Integer			M	879	Customer code
sundrytype	Integer			M	5	Sundry type
gstin	String			M	32AAGCK5138C1ZY	Customer GSTIN number
active	String			M	T	Whether sundry is active or not
agent	Integer			M	78	Agent code
iqmgstrefno	Integer			M		Unique number generated for the entry(used only in web application)

 

Name	Data Type	Min Length	Max Length	M/O	Sample Value	Comments
islno	Integer			M	12	Unique number generated for the entry
folio	String			M	DC	Ledger folio
gstrefno	String			M	202306010001	GSt referance number
fyear	Integer			M	23	Financial year
gstreferanceno	String			M	DC/23/2305220005	GST referance number with ledger folio
invdata	String			M	{"key":"AiKwioCpTUivXM0Cr2fl9A==", "eventid":"255", "invmode":"C", "invtype":"BU", "edate":"2023-4-27", "etime":"2023-4-27 07:18AM", "firmstateid":"KER", "firmgstin":"32AFJPK9650E1ZH", "firmid":1, "einv_Client_Id":"A19C0117AFDD4334857150D4370E1CB9", "cancel":"F", "customerdetails":null, "customername":"SAMYA, ", "customercode":0, "saddress":"", "agent":0, "baddress":"", "cpin":0, "accountto":0, "placeid":10, "placedetails":{"place":"MANJOOR","placecode":10,"stateid":"KER","gststatecode":32,"distance":40.00}, "vcode":6448,"vtype":"X", "vehicledetails":{"ccode":"","vcode":6448,"rgno":"KL3AF8010","vtype":"X","vehiclename":"","capacity":770.00,"ecapacity":0.00,"height":0.00,"length":0.00,"width":0.00,"constant":35.33,"mtype":"I","freeze":"F","mtypename":"Inches","vehiclecapacityStr":"770.00"}, "drivercode":0, "taxcalcneeded":"T", "remarks":""}	Invoice data of the entry (used only in response for fetching invoice data)

 

{
    "key": "QH7LlQ3wQMK9oYEKjeG5QOIVJQT4emeq",
    "customername": "CUSTOMER NAME",
    "customercode": "784",
    "baddress": "ADDRESS",
    "cpin": "695001",
    "accountto": "45",
    "placeid": "4",
    "placedetails": [
        {
            "place": "PLACE",
            "placecode": "4",
            "stateid": "KER",
            "gststatecode": "32",
            "distance": "150.00"
        }
    ],
    "vcode": "645",
    "vtype": "X",
    "vehicledetails": [
        {
            "vcode": "654",
            "rgno": "KL 01 AA 1234",
            "vtype": "X",
            "capacity": "800.00",
            "ecapacity": "100.00",
            "height": "8.00",
            "length": "15.00",
            "width": "5.00",
            "constant": "45.00",
            "mtype": "M",
            "freeze": "F"
        }
    ],
    "drivercode": "32",
    "taxcalcneeded": "T",
    "remarks": "REMARKS",
    "itemdetails": [
        {
            "scheduleid": "10",
            "uomid": "7",
            "qty": "800",
            "aqty": "100.00",
            "uprice": "35.00",
            "discount": "100.00",
            "userenteredprice": "30.00",
            "taxpercent": "5.00",
            "taxdetails": [
                {
                    "TaxPercentage": "5.00",
                    "TaxDisplayName": "SGST",
                    "PostingHeadCode": "110",
                    "PostingAmount": "1100.00",
                    "TaxFormulaCode": "SGST"
                }
            ],
            "taxrowid": "5",
            "detslno": "1",
            "itemcode": "8",
            "itemdetails": [
                {
                    "hsncode": "25171010",
                    "pcode": "8",
                    "hsnid": "2661",
                    "stockunit": "10",
                    "ptype": "P",
                    "saleshead": "1",
                    "scheduleid": "3",
                    "productunitwiseratedet": [
                        {
                            "uomid": "10",
                            "pcode": "789",
                            "prate": "53.00"
                        }
                    ],
                    "pname": "ITEM"
                }
            ]
        }
    ],
    "fyear": "23",
    "gstreferanceno": "DC/23/230427002",
    "eventtype": "A",
    "folio": "DC",
    "invdata": "",
    "iqmslno": "",
    "iqmfyear": "",
    "grossamt": "10000.00",
    "int_referanceno": "nFc9ryddo2HknNLi4SNqvQ==",
    "ledgerdetails": [
        {
            "lfolio": "DC",
            "laccode": "8431",
            "extype": "",
            "lremark": "Sales - KL 01 AA 1234(PROD-AMT@RATE)",
            "lamount": "10000.00",
            "dc": "D"
        }
    ],
    "einvirn": "",
    "einvjson": "",
    "einvqrcode": "",
    "einvcancdate": "",
    "ewaybillno": "",
    "ewbresult": "",
    "lcashrefno": "",
    "saddress": "ADDRESS",
    "agent": "654",
    "autoroundoff": "F",
    "autoroundoffvalue": "1",
    "roundoff": "0.52",
    "source": "S",
    "bank": "2",
    "lorrycash": "100.00",
    "gstrefno": "2306010001",
    "islno": "12",
    "eventid": "255",
    "invmode": "D",
    "invtype": "BU",
    "edate": "2023-4-27",
    "etime": "2023-4-27 05:17AM",
    "firmstateid": "KER",
    "firmgstin": "32AFJPK9650E1ZH",
    "firmid": "1",
    "einv_Client_Id": "A19C0117AFDD4",
    "cancel": "F",
    "customerdetails": [
        {
            "sphone": "9876543210",
            "baddress": "CUSTOMER ADDRESS",
            "pan": "ABCTY1234D",
            "spin": "695001",
            "agentname": "AGENT",
            "gstregistrationmode": "1",
            "name": "CUST",
            "code": "879",
            "sundrytype": "5",
            "gstin": "32AAGCK5138C1ZY",
            "active": "T",
            "agent": "78"
        }
    ],
    "iqmgstrefno": ""
}

{
    "islno": "12",
    "folio": "DC",
    "gstrefno": "202306010001",
    "fyear": "23",
    "gstreferanceno": "DC/23/2305220005",
    "invdata": "{"key":"AiKwioCpTUivXM0Cr2fl9A==",rn"eventid":"255",rn"invmode":"C",rn"invtype":"BU",rn"edate":"2023-4-27",rn"etime":"2023-4-27 07:18AM",rn"firmstateid":"KER",rn"firmgstin":"32AFJPK9650E1ZH",rn"firmid":1,rn"einv_Client_Id":"A19C0117AFDD4334857150D4370E1CB9",rn"cancel":"F",rn"customerdetails":null,rn"customername":"SAMYA, ",rn"customercode":0,rn"saddress":"",rn"agent":0,rn"baddress":"",rn"cpin":0,rn"accountto":0,rn"placeid":10,rn"placedetails":{"place":"MANJOOR","placecode":10,"stateid":"KER","gststatecode":32,"distance":40.00},rn"vcode":6448,"vtype":"X",rn"vehicledetails":{"ccode":"","vcode":6448,"rgno":"KL3AF8010","vtype":"X","vehiclename":"","capacity":770.00,"ecapacity":0.00,"height":0.00,"length":0.00,"width":0.00,"constant":35.33,"mtype":"I","freeze":"F","mtypename":"Inches","vehiclecapacityStr":"770.00"},rn"drivercode":0,rn"taxcalcneeded":"T",rn"remarks":""}",
    "e": 200,
    "msg": "Success"
}

{
    "e": 401,
    "msg": "Invalid authentication credentials."
}
{
    "e": 499,
    "msg": "Invalid Session"
}