Gst and Tax Expert


EWB CSV format definition

1  Table Name: E-way Bill Generation

S. No Column Name Column Description
Full Value Sample Value  
1 userGstin GSTIN   GSTIN of API User
2 supplyType Supply Supply whether it is outward/inward.
3 subSupplyType Sub types of Supply   Sub types of Supply
4 docType Document Type CHL  
5 docNo Document No    
6 docDate Document Date    
7 fromGstin GSTIN GSTIN of the Consignor
8 fromTrdName LegalName   LegalName of consignor
9 fromAddr1 Address Address of consignor - Line 1
10 fromAddr2 Address Address of consignor - Line 2
11 fromPlace Place   Place of consignor
12 fromPincode Pincode Pincode of consignor
13 fromStateCode State State of consignor
14 toGstin GSTIN GSTIN of consignee
15 toTrdname Legalname   Legalname of consignee
16 toAddr1 Address   Address of consignee - Line 1
17 toAddr2 Address   Address of consignee- Line 2
18 toPlace Place   Place of consignee
19 toPincode Pincode   Pincode of the consignee
20 toStateCode State of Supply  
21 totalValue Amount   Total Amount/ Taxable Amount
22 cgstValue Amount   CGST Amount
23 sgstValue Amount   SGST Amount
24 igstValue Amount   IGST Amount
25 cessValue Amount   CESS Amount
26 transMode Mode of transportation  
27 transDistance Distance of transportation  
28 transporterId Transporter Id  
29 transporterName Transporter Name  
30 transDocNo Transporter Doc No  
31 transDocDate Transporter Doc Date  
32 vehicleNo Vehicle No.  
33 productName Name of the Product  
34 productDesc Description of the Product  
35 hsnCode HSN Code   HSN Code of the Product
36 quantity Quantity   Quantity of Product in Numbers
37 qtyUnit Unit of the Product   Unit of the Product, like Liter,Kg etc
38 taxableAmount Amount   Total Amount/ Taxable Amount
39 cgstRate Rate   CGST Rate
40 sgstRate Rate   SGST Rate
41 igstRate Rate   IGST Rate
42 cessRate Rate   CESS Rate
43 Status Status code  
44 errorCodes Error Codes   Refer Error Codes
45 docNo Document number   Document number of EwayBill
46 ewayBillNo E-Way Bill No   Unique E-Way Bill No
47 ewayBillDate Date and Time of E-Way Bill   Date and Time of E-Way Bill Generation

2  Table Name: Consolidated E-way bill generation

S. No Column Name Column Description
Full Value Sample Value  
1 vehicleNo vehicle number  
2 fromPlace from place from place of consignor
3 transMode Mode of Transportation  
4 transDocNo Transporter Document number    
5 transDocDate Transporter Document Date    
6 fromState State   State of Consignor
7 ewbNo E-way bill Number generated    

3  Table Name: Update Vehicle number

S. No Column Name Column Description
Full Value Sample Value  
1 EwbNo E-way bill Generated  
2 VehicleNo Vehicle number  
3 FromPlace Place   Place of Consignor
4 FromState State   State of Consignor
5 ReasonCode Reason code Reason code for vehicle updation
6 ReasonRem Reason   Reason for Vehicle Updation
7 TransDocNo Transporter Document number
8 TransDocDate Transporter Document Date    
9 TransMode Mode of Transport  

4  Table Name: Cancel E-way bill

S. No Column Name Column Description
Full Value Sample Value  
1 ewbNo E-way bill Generated  
2 cancelRsnCode Reason code for cancelling   Reason code for cancelling eway bill
3 cancelRmrk Reason for - cancelling   Reason for - cancelling eway bill

5  Table Name: Reject e-way bill

S. No Column Name Column Description
Full Value Sample Value  
1 ewbNo E-way bill Generated