Sovos.com Contact Support

Data and Analytics

Sovos Intelligence

SAF-T source group

Tables and columns available in the SAF-T source group.

Overview

The SAF-T source group has six models:

  • SAFT_COUNTERPARTS

  • SAFT_GENERAL_LEDGER_ACCOUNTS

  • SAFT_INVOICES

  • SAFT_INVOICES_LINES

  • SAFT_INVOICES_LINES_TAX_INFORMATION

  • SAFT_TRANSACTIONS

All are available in the query builder's Database panel and in Data > All Data.

SAFT_COUNTERPARTS (14 columns)

Column Type
DIRECTION TEXT
COUNTERPARTID TEXT
COUNTERPARTNAME TEXT
REGISTRATIONNUMBER TEXT
ACCOUNTID TEXT
OPENINGDEBITBALANCE NUMBER
OPENINGCREDITBALANCE NUMBER
CLOSINGDEBITBALANCE NUMBER
CLOSINGCREDITBALANCE NUMBER
SELFBILLINGINDICATOR TEXT
COUNTRY TEXT
SOURCECOMPANYID TEXT
COMPANYID TEXT
DATASOURCE TEXT

SAFT_GENERAL_LEDGER_ACCOUNTS (17 columns)

Column Type
ACCOUNTID TEXT
ACCOUNTDESCRIPTION TEXT
STANDARDACCOUNTID TEXT
ACCOUNTTYPE TEXT
GROUPINGCATEGORY TEXT
GROUPINGCODE TEXT
ACCOUNTCREATIONDATE DATE
OPENINGDEBITBALANCE NUMBER
OPENINGCREDITBALANCE NUMBER
CLOSINGDEBITBALANCE NUMBER
CLOSINGCREDITBALANCE NUMBER
STARTDATE DATE
ENDDATE DATE
COUNTRY TEXT
SOURCECOMPANYID TEXT
COMPANYID TEXT
DATASOURCE TEXT

SAFT_INVOICES (58 columns)

Column Type
DIRECTION TEXT
INVOICENUMBER TEXT
INVOICEDATE DATE
INVOICETYPE TEXT
SELFBILLINGINDICATOR TEXT
COUNTERPARTID TEXT
COUNTERPARTNAME TEXT
NETTOTAL NUMBER
SIGNEDNETTOTAL NUMBER
GROSSTOTAL NUMBER
SIGNEDGROSSTOTAL NUMBER
AMOUNT NUMBER
SIGNEDAMOUNT NUMBER
CURRENCYAMOUNT NUMBER
CURRENCYCODE TEXT
EXCHANGERATE NUMBER
SHIPPINGCOSTSAMOUNTTOTAL NUMBER
ACCOUNTID TEXT
GLPOSTINGDATE DATE
PERIOD NUMBER
PERIODYEAR NUMBER
BATCHID TEXT
PAYMENTTERMS TEXT
PAYMENTMECHANISM TEXT
RECEIPTNUMBERS TEXT
SHIPFROMCOUNTRY TEXT
SHIPFROMREGION TEXT
SHIPFROMCITY TEXT
SHIPFROMPOSTALCODE TEXT
SHIPFROMSTREETNAME TEXT
SHIPFROMBUILDING TEXT
SHIPFROMNUMBER TEXT
SHIPFROMLOCATIONID TEXT
SHIPFROMADDITIONALADDRESSDETAIL TEXT
SHIPFROMWAREHOUSEID TEXT
SHIPFROMUCR TEXT
SHIPFROMDELIVERYID TEXT
SHIPFROMDELIVERYDATE DATE
SHIPFROMADDRESSTYPE TEXT
SHIPTOCOUNTRY TEXT
SHIPTOREGION TEXT
SHIPTOCITY TEXT
SHIPTOPOSTALCODE TEXT
SHIPTOSTREETNAME TEXT
SHIPTOBUILDING TEXT
SHIPTONUMBER TEXT
SHIPTOLOCATIONID TEXT
SHIPTOADDITIONALADDRESSDETAIL TEXT
SHIPTODELIVERYID TEXT
SHIPTODELIVERYDATE DATE
SHIPTOADDRESSTYPE TEXT
BRANCHSTORENUMBER TEXT
SETTLEMENTDATE DATE
SETTLEMENTDISCOUNT TEXT
COUNTRY TEXT
SOURCECOMPANYID TEXT
COMPANYID TEXT
DATASOURCE TEXT

SAFT_INVOICES_LINES (60 columns)

Column Type
DIRECTION TEXT
INVOICENUMBER TEXT
INVOICELINENUMBER TEXT
INVOICEDATE DATE
INVOICETYPE TEXT
INVOICELINEAMOUNT NUMBER
INVOICELINECURRENCYAMOUNT NUMBER
INVOICELINECURRENCYCODE TEXT
INVOICELINEEXCHANGERATE NUMBER
INVOICEUOM TEXT
DEBITCREDITINDICATOR TEXT
DESCRIPTION TEXT
GOODSSERVICESID TEXT
QUANTITY NUMBER
PRODUCTCODE TEXT
PRODUCTDESCRIPTION TEXT
PERIOD NUMBER
PERIODYEAR NUMBER
PARENTACCOUNTID TEXT
ACCOUNTID TEXT
COUNTERPARTID TEXT
SHIPFROMADDITIONALADDRESSDETAIL TEXT
SHIPFROMADDRESSTYPE TEXT
SHIPFROMBUILDING TEXT
SHIPFROMCITY TEXT
SHIPFROMCOUNTRY TEXT
SHIPFROMDELIVERYDATE DATE
SHIPFROMDELIVERYID TEXT
SHIPFROMLOCATIONID TEXT
SHIPFROMNUMBER TEXT
SHIPFROMPOSTALCODE TEXT
SHIPFROMREGION TEXT
SHIPFROMSTREETNAME TEXT
SHIPFROMUCR TEXT
SHIPFROMWAREHOUSEID TEXT
SHIPPINGCOSTSAMOUNT NUMBER
SHIPPINGCOSTSCURRENCYAMOUNT NUMBER
SHIPPINGCOSTSCURRENCYCODE TEXT
SHIPPINGCOSTSEXCHANGERATE NUMBER
SHIPTOADDITIONALADDRESSDETAIL TEXT
SHIPTOADDRESSTYPE TEXT
SHIPTOBUILDING TEXT
SHIPTOCITY TEXT
SHIPTOCOUNTRY TEXT
SHIPTODELIVERYDATE DATE
SHIPTODELIVERYID TEXT
SHIPTOLOCATIONID TEXT
SHIPTONUMBER TEXT
SHIPTOPOSTALCODE TEXT
SHIPTOREGION TEXT
SHIPTOSTREETNAME TEXT
SHIPTOUCR TEXT
SHIPTOWAREHOUSEID TEXT
TAXPOINTDATE DATE
CREDITNOTEREASON TEXT
CREDITNOTEREFERENCE TEXT
COUNTRY TEXT
SOURCECOMPANYID TEXT
COMPANYID TEXT
DATASOURCE TEXT

SAFT_INVOICES_LINES_TAX_INFORMATION (24 columns)

Column Type
DIRECTION TEXT
INVOICENUMBER TEXT
INVOICELINENUMBER TEXT
INVOICEDATE DATE
INVOICETYPE TEXT
TAXTYPE TEXT
TAXCODE TEXT
TAXPERCENTAGE NUMBER
TAXBASE NUMBER
TAXBASEDESCRIPTION TEXT
TAXAMOUNT NUMBER
TAXEXEMPTIONREASON TEXT
TAXDECLARATIONPERIOD TEXT
TAXCURRENCYCODE TEXT
TAXCURRENCYAMOUNT NUMBER
TAXEXCHANGERATE NUMBER
ACCOUNTID TEXT
COUNTERPARTID TEXT
PERIOD NUMBER
PERIODYEAR NUMBER
COUNTRY TEXT
SOURCECOMPANYID TEXT
COMPANYID TEXT
DATASOURCE TEXT

SAFT_TRANSACTIONS (19 columns)

Column Type
TRANSACTIONID TEXT
JOURNALID TEXT
DEBITAMOUNT NUMBER
CREDITAMOUNT NUMBER
TRANSACTIONDATE DATE
GLPOSTINGDATE DATE
DESCRIPTION TEXT
TRANSACTIONTYPE TEXT
PERIOD NUMBER
PERIODYEAR NUMBER
CUSTOMERID TEXT
SUPPLIERID TEXT
SOURCEID TEXT
BATCHID TEXT
SYSTEMENTRYDATE DATE
SYSTEMID TEXT
COMPANYID TEXT
DATASOURCE TEXT
COUNTRY TEXT

Last updated: July 24, 2026