# TransactionLineVats - Catalog: `XAF` - Retrieve: true - Topic: `auditfile` - Base XPath: `/xaf:auditfile/xaf:company/xaf:transactions` - XPath: `/xaf:journal/xaf:transaction/xaf:trLine/xaf:vat` The data in this table is partitioned per value of the COMPANY_NAME column. ## Table Columns The columns of the table `TransactionLineVats` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AUDIT_FILE_VERSION` | `string(240)` | | ☐ | | | `COMPANY_ADDRESS` | `string(240)` | | ☐ | | | `COMPANY_CITY` | `string(240)` | | ☐ | | | `COMPANY_ID` | `string(240)` | | ☐ | | | `COMPANY_NAME` | `string(1000)` | | ☐ | | | `COMPANY_POSTAL_CODE` | `string(240)` | | ☐ | | | `COMPANY_TAX_REG_IDENT` | `string(240)` | | ☐ | | | `FILE_CURRENCY_CODE` | `string(240)` | | ☐ | | | `FILE_DATE_CREATED` | `string(240)` | | ☐ | | | `FISCAL_YEAR_END_DATE` | `datetime` | | ☐ | | | `FISCAL_YEAR_NUMBER` | `string(240)` | | ☑ | | | `FISCAL_YEAR_START_DATE` | `datetime` | | ☐ | | | `INTERFACE_URL` | `string(4000)` | | ☑ | | | `PRODUCT_ID` | `string(240)` | | ☐ | | | `PRODUCT_VERSION` | `string(240)` | | ☐ | | | `TRLINE_ACCID` | `string(240)` | Transaction Line Account ID | | | | `TRLINE_AMNT` | `decimal` | Transaction Line Amount | | | | `TRLINE_AMNTTP` | `string(240)` | Transaction Line Amount Type | | | | `TRLINE_ARTGRPID` | `string(240)` | Transaction Line Article Group ID | | | | `TRLINE_BANKACCNR` | `string(240)` | Transaction Line Bank Account Number | | | | `TRLINE_BANKIDCD` | `string(240)` | Transaction Line Bank ID Code | | | | `TRLINE_COSTID` | `string(240)` | Transaction Line Cost ID | | | | `TRLINE_CURRENCY_CURAMNT` | `decimal` | | | | | `TRLINE_CURRENCY_CURCODE` | `string(240)` | | | | | `TRLINE_CUSTSUPID` | `string(240)` | Transaction Line Identification | | | | `TRLINE_DESCRIPTION` | `string` | Transaction Line Description | | | | `TRLINE_DOCREF` | `string(999)` | Transaction Line Document Reference | | | | `TRLINE_EFFDATE` | `datetime` | Transaction Line Effective Date | | | | `TRLINE_INVREF` | `string(999)` | Transaction Line Invoice Reference | | | | `TRLINE_MATCHKEYID` | `string(240)` | Transaction Line Match Key ID | | | | `TRLINE_NR` | `string(240)` | Transaction Line Number | | | | `TRLINE_ORDERREF` | `string(999)` | Transaction Line Order Reference | | | | `TRLINE_PRODID` | `string(240)` | Transaction Line Product ID | | | | `TRLINE_PROJID` | `string(240)` | Transaction Line Project ID | | | | `TRLINE_QNTITY` | `int64` | Transaction Line Quantity | | | | `TRLINE_QNTITYID` | `string(240)` | Transaction Line Quantity ID | | | | `TRLINE_RECEIVINGDOCREF` | `string(999)` | Transaction Line Receiving Document Reference | | | | `TRLINE_RECREF` | `string(999)` | Transaction Line Record Reference | | | | `TRLINE_SHIPDOCREF` | `string(999)` | Transaction Line Shipping Document Reference | | | | `TRLINE_TRANSACTION_AMNT` | `decimal` | Transaction Amount | | | | `TRLINE_TRANSACTION_AMNTTP` | `string(240)` | Transaction Amount Type | | | | `TRLINE_TRANSACTION_DESC` | `string` | Transaction Description | | | | `TRLINE_TRANSACTION_JOURNAL_BANKACCNR` | `string(240)` | Journal Bank Account Number | | | | `TRLINE_TRANSACTION_JOURNAL_DESCRIPTION` | `string` | Journal Description | | | | `TRLINE_TRANSACTION_JOURNAL_JRNID` | `string(240)` | Journal Journal ID | | | | `TRLINE_TRANSACTION_JOURNAL_JRNTP` | `string(240)` | Journal Journal Typ | | | | `TRLINE_TRANSACTION_JOURNAL_OFFSETACCID` | `string(240)` | Journal Offset Account ID | | | | `TRLINE_TRANSACTION_JOURNAL_TRANSACTIONS_LINESCOUNT` | `int64` | Transaction Lines Count | | | | `TRLINE_TRANSACTION_JOURNAL_TRANSACTIONS_TOTALCREDIT` | `decimal` | Transaction Total Credit | | | | `TRLINE_TRANSACTION_JOURNAL_TRANSACTIONS_TOTALDEBIT` | `decimal` | Transaction Total Debit | | | | `TRLINE_TRANSACTION_NR` | `string(240)` | Transaction Number | | | | `TRLINE_TRANSACTION_PERIODNUMBER` | `int64` | Transaction Period Number | | | | `TRLINE_TRANSACTION_SOURCEID` | `string(240)` | Transaction Source ID | | | | `TRLINE_TRANSACTION_TRDT` | `datetime` | Transaction Date | | | | `TRLINE_TRANSACTION_USERID` | `string(240)` | Transaction User ID | | | | `TRLINE_WORKCOSTARRREF` | `string(999)` | Transaction Line Work Cost Arrangement Reference | | | | `VATAMNT` | `decimal` | | | | | `VATAMNTTP` | `string(240)` | | | | | `VATID` | `string(240)` | | | | | `VATPERC` | `decimal` | | | |