# SubledgerTransactionLineVats - Catalog: `XAF` - Retrieve: true - Topic: `auditfile` - Base XPath: `/xaf:auditfile/xaf:company/xaf:transactions/xaf:subledgers/xaf:subledger/xaf:sbLine` - XPath: `/xaf:vat` The data in this table is partitioned per value of the COMPANY_NAME column. ## Table Columns The columns of the table `SubledgerTransactionLineVats` 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)` | | ☐ | | | `SBLINE_AMNT` | `decimal` | Subledger Line Amount | | | | `SBLINE_AMNTTP` | `string(240)` | Subledger Line Amount Type | | | | `SBLINE_ARTGRPID` | `string(240)` | Subledger Line Article Group ID | | | | `SBLINE_COSTID` | `string(240)` | Subledger Line Cost ID | | | | `SBLINE_CURRENCY_CURAMNT` | `decimal` | | | | | `SBLINE_CURRENCY_CURCODE` | `string(240)` | | | | | `SBLINE_CUSTSUPID` | `string(240)` | Subledger Line Identification | | | | `SBLINE_DESC` | `string` | Subledger Line Description | | | | `SBLINE_DOCREF` | `string(999)` | Subledger Line Document Reference | | | | `SBLINE_INVDT` | `datetime` | Subledger Line Invoice Date | | | | `SBLINE_INVDUEDT` | `datetime` | Subledger Line Invoice Due Date | | | | `SBLINE_INVPURSALTP` | `string(240)` | Subledger Line Purchase/Sales Type | | | | `SBLINE_INVREF` | `string(999)` | Subledger Line Invoice Reference | | | | `SBLINE_INVTP` | `string(240)` | | | | | `SBLINE_JRNID` | `string(240)` | Subledger Line Journal ID | | | | `SBLINE_MATCHKEYID` | `string(240)` | Subledger Line Match Key ID | | | | `SBLINE_MUTTP` | `string(240)` | Subledger Line Mutation Type | | | | `SBLINE_NR` | `string(240)` | Subledger Line Number | | | | `SBLINE_PRODID` | `string(240)` | Subledger Line Product ID | | | | `SBLINE_PROJID` | `string(240)` | Subledger Line Project ID | | | | `SBLINE_QNTITY` | `int64` | Subledger Line Quantity | | | | `SBLINE_QNTITYID` | `string(240)` | Subledger Line Quantity ID | | | | `SBLINE_RECREF` | `string(999)` | Subledger Line Record Reference | | | | `SBLINE_TRLINENR` | `string(240)` | | | | | `SBLINE_TRNR` | `string(240)` | | | | | `VATAMNT` | `decimal` | | | | | `VATAMNTTP` | `string(240)` | | | | | `VATID` | `string(240)` | | | | | `VATPERC` | `decimal` | | | |