Gst and Tax Expert


GSTR6A CSV format definition

4  Table Name: B2B Invoices

Table Code: b2b

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 inv Invoice Details Invoice
2 inum Number
3 idt Supplier Invoice Date
4 val Supplier Invoice Value  
5 iamt Amount IGST
6 camt Amount CGST
7 samt Amount SGST
8 csamt Amount CESS
9 txval Taxable value of Goods or Service as per invoice
10 inv_typ Invoice Type
11 pos Place of Supply
12 rchrg Reverse Charge
13 srctyp Source Type of IRN
14 irn IRN number
15 irngendate IRN generation Date
16 cfp counter party filing period
17 cfs counter party filing status
18 chksum Invoice Check sum value
19 item_det Items ITEM
20 num Serial no
21 rt Tax Rate  
22 txval Taxable value of Goods or Service as per invoice  
23 iamt Amount   IGST
24 camt Amount   CGST
25 samt Amount   SGST
26 csamt Amount   CESS

5  Table Name: B2BA Invoices

Table Code: b2ba

S. No Column Name
(Color Code - Mandatory or Optional)
Column Description
Full Value Sample Value  
1 ctin GSTIN/UID of the Receiver taxpayer/UN, Govt Bodies Invoice
2 inv Invoice Details Invoice
3 inum Number
4 oinum Original Invoice Number
5 idt Supplier Invoice Date
6 oidt Original Invoice Date
7 val Supplier Invoice Value  
8 iamt Amount IGST
9 camt Amount CGST
10 samt Amount SGST
11 csamt Amount CESS
12 txval Taxable value of Goods or Service as per invoice
13 inv_typ Invoice Type
14 pos Place of Supply
15 rchrg Reverse Charge
16 cfp counter party filing period
17 cfs counter party filing status
18 chksum Invoice Check sum value
19 item_det Items ITEM
20 num Serial no
21 rt Tax Rate  
22 txval Taxable value of Goods or Service as per invoice  
23 iamt Amount   IGST
24 camt Amount   CGST
25 samt Amount   SGST
26 csamt 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 Counter party GSTIN
2 nt Credit/Debit Notes Details Invoice
3 inum Number
4 idt Supplier Invoice Date
5 nt_num Debit/Credit Note number  
6 nt_dt Credit date  
7 val Supplier Invoice Value  
8 iamt Amount IGST
9 camt Amount CGST
10 samt Amount SGST
11 csamt Amount CESS
12 txval Taxable value of Goods or Service as per invoice
13 ntty Note type
14 pos Place of Supply
15 p_gst
16 d_flag delink flag
17 srctyp Source Type of IRN
18 irn IRN number
19 irngendate IRN generation Date
20 cfp counter party filing period
21 cfs counter party filing status
22 chksum Invoice Check sum value
23 item_det Items ITEM
24 num Serial no
25 rt Tax Rate  
26 txval Taxable value of Goods or Service as per invoice  
27 iamt Amount   IGST
28 camt Amount   CGST
29 samt Amount   SGST
30 csamt 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 Counter party GSTIN
2 nt Credit/Debit Notes Details Invoice
3 inum Number
4 idt Supplier Invoice Date
5 nt_num Debit/Credit Note number  
6 ont_num original Note number  
7 nt_dt Credit date  
8 ont_dt original note date  
9 val Supplier Invoice Value  
10 iamt Amount IGST
11 camt Amount CGST
12 samt Amount SGST
13 csamt Amount CESS
14 txval Taxable value of Goods or Service as per invoice
15 ntty Note type
16 pos Place of Supply
17 p_gst
18 d_flag delink flag
19 chksum Invoice Check sum value
20 cfp counter party filing period
21 cfs counter party filing status
22 chksum Invoice Check sum value
23 item_det Items ITEM
24 num Serial no
25 rt Tax Rate  
26 txval Taxable value of Goods or Service as per invoice  
27 iamt Amount   IGST
28 camt Amount   CGST
29 samt Amount   SGST
30 csamt Amount   CESS