# VAT code in transaction line **URL:** \ **Category:** Templates\ **Created:** [April 24, 2020, 11:41am UTC](https://community.silverfin.com/t/vat-code-in-transaction-line/1769 "2020-04-24T11:41:23Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![ronald\_groot\_RSF](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/ronald_groot_rsf/32/1019_2.png) [@ronald\_groot\_RSF](https://community.silverfin.com/u/ronald_groot_RSF)\ **Post date:** [April 24, 2020, 11:41am UTC](https://community.silverfin.com/t/vat-code-in-transaction-line/1769/1 "2020-04-24T11:41:23Z")
I was wondering if it is possible to get the VAT code (or VAT amount) of a transaction. I cannot seem to find it. Where can I view all possible fields for a transaction? ---
**Author:** ![Wouter\_Bruynsteen](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/wouter_bruynsteen/32/1196_2.png) [@Wouter\_Bruynsteen](https://community.silverfin.com/u/Wouter_Bruynsteen)\ **Post date:** [April 24, 2020, 12:58pm UTC](https://community.silverfin.com/t/vat-code-in-transaction-line/1769/2 "2020-04-24T12:58:30Z")
Hi Ronald If the VAT code or VAT amount is data that you upload to Silverfin, then you should be able to see it as a column when you open the ledger of an account, if it’s there, you can access it through the transaction drop: ![Schermafbeelding 2018-08-28 om 08.36.05](https://canada1.discourse-cdn.com/flex030/uploads/getsilverfin/original/1X/cd713fc955e92aae056901b6e47ff86f908df591.png) Two things to bear in mind here when accessing non-standard columns are: 1. You should replace spaces (’ ‘) and points (’.’) by underscores (’\_’). 2. The spelling of the column header you want, needs to be respected. In the view of a ledger everything is capital but when you want to access it in the transaction drop, it needs to written with the same capitalization as it was originally uploaded. _For example_ If I want to target a column that was uploaded as ‘Doc. Nr.’ , then it will appear as DOC. NR. in Silverfin, but I’ll need to call Doc\_\_Nr\_ on the transaction. You can read more about how to use the custom columns in the transaction drop here: [https://developer.silverfin.com/docs/transaction](https://developer.silverfin.com/docs/transaction) Kind regards Wouter ---
**Author:** ![ronald\_groot\_RSF](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/ronald_groot_rsf/32/1019_2.png) [@ronald\_groot\_RSF](https://community.silverfin.com/u/ronald_groot_RSF)\ **Post date:** [April 24, 2020, 1:25pm UTC](https://community.silverfin.com/t/vat-code-in-transaction-line/1769/3 "2020-04-24T13:25:58Z")
Thanks @Wouter_Bruynsteen, we are using the Exact Online connection that was build by Silverfin, so I’m not uploading my own data. Therefore I do not know which fields are available. So the question is more, is it in the transaction line that is fetched from Exact in the standard connection. ---
**Author:** ![Wouter\_Bruynsteen](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/wouter_bruynsteen/32/1196_2.png) [@Wouter\_Bruynsteen](https://community.silverfin.com/u/Wouter_Bruynsteen)\ **Post date:** [April 24, 2020, 2:25pm UTC](https://community.silverfin.com/t/vat-code-in-transaction-line/1769/4 "2020-04-24T14:25:54Z")
The columns that are being synced in a standard Exact Online connection are Boekingsdatum, Comm., Relatie, Doc.Nr., Dagb. and Waarde. So unfortunately you won’t be able to access the VAT code or amount directly based on these columns. ---
**Author:** ![ronald\_groot\_RSF](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/ronald_groot_rsf/32/1019_2.png) [@ronald\_groot\_RSF](https://community.silverfin.com/u/ronald_groot_RSF)\ **Post date:** [April 28, 2020, 7:08am UTC](https://community.silverfin.com/t/vat-code-in-transaction-line/1769/5 "2020-04-28T07:08:06Z")
Hi @Wouter_Bruynsteen, Thanks for clearing that up. This is what I thought, but just wanted to make sure.