Sovos.com
Contact SupportVAT Filing source group
Tables and columns available in the VAT Filing source group.
Overview
The VAT Filing source group has two models:
-
VAT_INVOICES
-
VAT_TAX_CODES
Both are available in the query builder's Database panel and in Data > All Data.
VAT_INVOICES (112 columns)
| Column | Type |
|---|---|
DIRECTION |
TEXT |
COUNTRY |
TEXT |
COMPANYCODE |
TEXT |
DOCUMENTTYPE |
TEXT |
INVOICENUMBER |
TEXT |
INVOICEDATE |
DATE |
REPORTINGDATE |
DATE |
REFERENCEID |
TEXT |
ORIGINALINVOICENUMBER |
TEXT |
ADDITIONALDOCUMENTREFERENCE |
TEXT |
ERPDOCUMENT |
TEXT |
INVOICECORRECTIONTYPE |
TEXT |
CREDITINDICATOR |
TEXT |
ISSUERID |
TEXT |
OPERATIONTYPE |
TEXT |
TRANSACTIONCODE |
TEXT |
TRANSACTIONTYPE |
NUMBER |
SALESBOOKSEQUENTIALNUMBER |
TEXT |
PURCHASEBOOKSEQUENTIALNUMBER |
TEXT |
COUNTERPARTNAME |
TEXT |
COUNTERPARTREGISTRATIONNUMBER |
TEXT |
CUSTOMERID |
TEXT |
CUSTOMERNAME |
TEXT |
CUSTOMERVATNUMBER |
TEXT |
CUSTOMERCOUNTRYVATNUMBER |
TEXT |
CUSTOMERDELIVERYID |
TEXT |
CUSTOMERBILLTOSTREET |
TEXT |
CUSTOMERBILLTOCITY |
TEXT |
CUSTOMERBILLTOREGION |
TEXT |
CUSTOMERBILLTOPOSTALCODE |
TEXT |
CUSTOMERBILLTOCOUNTRY |
TEXT |
SUPPLIERID |
TEXT |
SUPPLIERNAME |
TEXT |
SUPPLIERVATNUMBER |
TEXT |
SUPPLIERCOUNTRYVATNUMBER |
TEXT |
SUPPLIERLOCALTAXNUMBER |
TEXT |
SUPPLIERBILLTOSTREET |
TEXT |
SUPPLIERBILLTOCITY |
TEXT |
SUPPLIERBILLTOREGION |
TEXT |
SUPPLIERBILLTOPOSTALCODE |
TEXT |
SUPPLIERBILLTOCOUNTRY |
TEXT |
TRANSACTIONDATE |
DATE |
CUSTOMERDELIVERYDATE |
DATE |
SUPPLIERDELIVERYDATE |
DATE |
GLPOSTINGDATE |
DATE |
UTILIZATIONDATE |
DATE |
INTRASTATDATE |
DATE |
FISCALYEAR |
TEXT |
FISCALPERIOD |
TEXT |
ERPFISCALYEAR |
TEXT |
ERPFISCALPERIOD |
TEXT |
GROSSTOTAL |
NUMBER |
NETTOTAL |
NUMBER |
VATTOTAL |
NUMBER |
TAXABLEBASISCREDIT |
NUMBER |
TAXABLEBASISDEBIT |
NUMBER |
VALUEVATCREDIT |
NUMBER |
VALUEVATDEBIT |
NUMBER |
TOTALVALUELINE |
NUMBER |
CURRENCYCODE |
TEXT |
EXCHANGERATE |
NUMBER |
CURRENCYCODE2 |
TEXT |
TAXABLEBASISCURRENCY2 |
NUMBER |
VALUEVATCURRENCY2 |
NUMBER |
COMMERCIALVALUECURRENCY2 |
NUMBER |
TOTALVALUE2 |
NUMBER |
TAXCODE |
TEXT |
TAXCODEDESCRIPTION |
TEXT |
TAXRATE |
NUMBER |
ORIGINALTAXRATEAPPLIED |
TEXT |
ORIGINALTAXCODE |
TEXT |
ORIGINALTAXCODEDESCRIPTION |
TEXT |
TRANSACTIONKEY |
TEXT |
CHARGETYPE |
TEXT |
INVOICELINENUMBER |
TEXT |
ITEMCODE |
TEXT |
ITEMDESCRIPTION |
TEXT |
ADDITIONALDESCRIPTION |
TEXT |
GLDESCRIPTION |
TEXT |
ADGESTIONALITEXT |
TEXT |
PLANTCODE |
TEXT |
UOM |
TEXT |
DELIVERYCONDITIONS |
TEXT |
INTRASTATCODE |
TEXT |
EXTRASTATCODE |
TEXT |
STATISTICALPROCEDURE |
TEXT |
STATISTICALVALUE |
NUMBER |
WEIGHT |
NUMBER |
QUANTITY |
NUMBER |
MODEOFTRANSPORT |
NUMBER |
CUSTOMSNUMBER |
TEXT |
COUNTRYORIGIN |
TEXT |
COUNTRYARRIVAL |
TEXT |
COUNTRYDISPATCH |
TEXT |
REGIONARRIVAL |
TEXT |
REGIONDISPATCH |
TEXT |
BUSINESSAREA |
TEXT |
GENERALLEDGERID |
TEXT |
TRANSACTIONID |
NUMBER |
ADMINISTRATIONID |
NUMBER |
BATCHID |
NUMBER |
ACCOUNTID |
NUMBER |
PURCHASEEXTRA1 |
TEXT |
PURCHASEEXTRA2 |
TEXT |
PURCHASEEXTRA3 |
TEXT |
PURCHASEEXTRA4 |
TEXT |
PURCHASEEXTRA5 |
TEXT |
PURCHASEEXTRA6 |
TEXT |
PURCHASEEXTRA7 |
TEXT |
SOURCECOMPANYID |
TEXT |
COMPANYID |
TEXT |
DATASOURCE |
TEXT |
VAT_TAX_CODES (17 columns)
| Column | Type |
|---|---|
INTERNALVATCODE |
TEXT |
DESCRIPTION |
TEXT |
VATRATETYPE |
TEXT |
COUNTRYCODE |
TEXT |
COUNTRYNAME |
TEXT |
ISEUCOUNTRY |
BOOLEAN |
ISOUTGOING |
BOOLEAN |
ISACTIVE |
BOOLEAN |
SALESLEDGER |
BOOLEAN |
PURCHASELEDGER |
BOOLEAN |
EUREPORT |
BOOLEAN |
ESLGOODS |
BOOLEAN |
ESLSERVICES |
BOOLEAN |
INTRASTATARRIVAL |
BOOLEAN |
INTRASTATDISPATCH |
BOOLEAN |
MOSS |
BOOLEAN |
EXEMPTREASONCODE |
TEXT |