Gst and Tax Expert


GSTR2B CSV format definition

4  Table Name: B2B Documents

Table Code: b2b

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 ctin GSTIN   GSTIN of the Supplier
2 trdnm Trade/Legal name of the supplier GSTN
3 supfildt Date of filing GSTR1/5 of supplier
4 supprd Filing period of GSTR1/5 of supplier
5 inum Number Invoice
6 typ Invoice Type
7 dt Invoice Date
8 val Invoice Value  
9 pos Place of supply
10 itcavl ITC Availability Y,N,T
11 rev Supply attracts reverse charge Y,N
12 rsn Reason for ITC Unavailability P,C
13 diffprcnt Applicable % of tax rate
14 srctyp Source Type of IRN
15 irn IRN number
16 irngendate IRN generation Date
17 num item number ITEM
18 rt Tax Rate  
19 txval Taxable value of Goods or Service as per invoice  
20 igst Amount   IGST
21 cgst Amount   CGST
22 sgst Amount   SGST
23 cess Amount   CESS

5  Table Name: B2BA Documents

Table Code: b2ba

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 ctin GSTIN   GSTIN of the Supplier
2 trdnm Trade/Legal name of the supplier GSTN
3 supfildt Date of filing GSTR1/5 of supplier
4 supprd Filing period of GSTR1/5 of supplier
5 inum Number Invoice
6 typ Invoice Type
7 dt Invoice Date
8 val Invoice Value  
9 pos Place of supply
10 itcavl ITC Availability Y,N,T
11 rev Supply attracts reverse charge Y,N
12 rsn Reason for ITC Unavailability P,C
13 diffprcnt Applicable % of tax rate
14 srctyp Source Type of IRN
15 oinum Original Invoice Number
16 oidt Original Invoice Date
17 num item number ITEM
18 rt Tax Rate  
19 txval Taxable value of Goods or Service as per invoice  
20 igst Amount   IGST
21 cgst Amount   CGST
22 sgst Amount   SGST
23 cess Amount   CESS

6  Table Name: CDNR Documents

Table Code: CDNR

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 ctin GSTIN   GSTIN of the Supplier
2 trdnm Trade/Legal name of the supplier GSTN
3 supfildt Date of filing GSTR1/5 of supplier
4 supprd Filing period of GSTR1/5 of supplier
5 ntnum Note Number Invoice
6 typ Note Type
7 suptyp Note Supply Type
8 dt Note Date
9 val Note Value  
10 pos Place of supply
11 itcavl ITC Availability Y,N,T
12 rev Supply attracts reverse charge Y,N
13 rsn Reason for ITC Unavailability P,C
14 diffprcnt Applicable % of tax rate
15 srctyp Source Type of IRN
16 irn IRN number
17 irngendate IRN generation Date
18 num item number ITEM
19 rt Tax Rate  
20 txval Taxable value of Goods or Service as per invoice  
21 igst Amount   IGST
22 cgst Amount   CGST
23 sgst Amount   SGST
24 cess Amount   CESS

7  Table Name: CDNRA Documents

Table Code: CDNRA

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 ctin GSTIN   GSTIN of the Supplier
2 trdnm Trade/Legal name of the supplier GSTN
3 supfildt Date of filing GSTR1/5 of supplier
4 supprd Filing period of GSTR1/5 of supplier
5 ontdt Original Note Date Invoice
6 onttyp Original Note type
7 ntnum Note Number
8 typ Note Type  
9 suptyp Note Supply Type
10 dt Note Date
11 rev Supply attracts reverse charge Y,N
12 rsn Reason for ITC Unavailability P,C
13 itcavl ITC Availability Y,N,T
14 diffprcnt Applicable % of tax rate
15 val Note Value
16 pos Place of supply
17 num item number ITEM
18 rt Tax Rate  
19 txval Taxable value of Goods or Service as per invoice  
20 igst Amount   IGST
21 cgst Amount   CGST
22 sgst Amount   SGST
23 cess Amount   CESS

8  Table Name: ISD Documents

Table Code: ISD

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 ctin GSTIN   GSTIN of the Supplier
2 trdnm Trade/Legal name of the supplier GSTN
3 supfildt Date of filing GSTR1/5 of supplier
4 supprd Filing period of GSTR1/5 of supplier
5 doclist ISD Document Details Details
6 doctyp ISD Document Type ISDI,ISDC
7 docnum ISD Document Number
8 docdt ISD Document Date
9 oinvnum Original Invoice Number    
10 oinvdt Original Invoice date
11 itcelg Eligible for ITC  
12 igst Amount   IGST
13 cgst Amount   CGST
14 sgst Amount   SGST
15 cess Amount   CESS

9  Table Name: ISDA Documents

Table Code: ISDA

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 ctin GSTIN   GSTIN of the Supplier
2 trdnm Trade/Legal name of the supplier GSTN
3 supfildt Date of filing GSTR1/5 of supplier
4 supprd Filing period of GSTR1/5 of supplier
5 doclist ISDA Document Details Details
6 odoctyp Original ISD Document Type ISDI,ISDC
7 odocnum Original ISD Document Number
8 odocdt Original ISD Document Date
9 doctyp ISD Document Type ISDI,ISDC
10 docnum ISD Document Number
11 docdt ISD Document Date
12 oinvnum Original Invoice Number    
13 oinvdt Original Invoice date
14 itcelg Eligible for ITC  
15 igst Amount   IGST
16 cgst Amount   CGST
17 sgst Amount   SGST
18 cess Amount   CESS

10  Table Name: IMPG Response

Table Code: IMPG

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 refdt ICEGATE Reference Date
2 recdt Received Date in the GST System Y/N
3 portcode Port Code
4 boenum Bill of Entry Number
5 boedt Bill of Entry Date
6 isamd Is Amended (Yes)
7 txval Total Taxable value
8 igst Total IGST value
9 cess Total CESS value

11  Table Name : IMPGSEZ Document Data

Table Code: IMPGSEZ

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 ctin Gstin of the Supplier
2 trdnm Trade/Legal name of the supplier
3 boe Bill of Entry Details Details
4 refdt ICEGATE Reference Date
5 recdt Received Date in the GST System Y/N
6 portcode Port Code
7 boenum Bill of Entry Number
8 boedt Bill of Entry Date
9 isamd Is Amended (Yes)
10 txval Total Taxable value
11 igst Total IGST value
12 cess Total CESS value