# SubledgerTransactionLines
- Catalog: `XAF`
- Retrieve: true
- Topic: `auditfile`
- Base XPath: `/xaf:auditfile/xaf:company/xaf:transactions/xaf:subledgers/xaf:subledger`
- XPath: `/xaf:sbLine`
The data in this table is partitioned per value of the COMPANY_NAME column.
## Table Columns
The columns of the table `SubledgerTransactionLines` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `AMNT` | `decimal` | | | |
| `AMNTTP` | `string(240)` | | | |
| `ARTGRPID` | `string(240)` | | | |
| `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)` | | ☐ | |
| `COSTID` | `string(240)` | | | |
| `CURRENCY_CURAMNT` | `decimal` | Currency Amount | | |
| `CURRENCY_CURCODE` | `string(240)` | Currency Currency Code | | |
| `CUSTSUPID` | `string(240)` | | | |
| `DESC` | `string` | | | |
| `DOCREF` | `string(999)` | | | |
| `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)` | | ☑ | |
| `INVDT` | `datetime` | | | |
| `INVDUEDT` | `datetime` | | | |
| `INVPURSALTP` | `string(240)` | | | |
| `INVREF` | `string(999)` | | | |
| `INVTP` | `string(240)` | | | |
| `JRNID` | `string(240)` | | | |
| `MATCHKEYID` | `string(240)` | | | |
| `MUTTP` | `string(240)` | | | |
| `NR` | `string(240)` | | | |
| `PRODID` | `string(240)` | | | |
| `PRODUCT_ID` | `string(240)` | | ☐ | |
| `PRODUCT_VERSION` | `string(240)` | | ☐ | |
| `PROJID` | `string(240)` | | | |
| `QNTITY` | `int64` | | | |
| `QNTITYID` | `string(240)` | | | |
| `RECREF` | `string(999)` | | | |
| `SUBLEDGER_LINESCOUNT` | `int64` | Subledger Lines Count | | |
| `SUBLEDGER_SBDESC` | `string` | Subledger Description | | |
| `SUBLEDGER_SBTYPE` | `string(240)` | Subledger Type | | |
| `SUBLEDGER_TOTALCREDIT` | `decimal` | Subledger Total Credit | | |
| `SUBLEDGER_TOTALDEBIT` | `decimal` | Subledger Total Debit | | |
| `TRLINENR` | `string(240)` | | | |
| `TRNR` | `string(240)` | | | |