# SubledgerOpeningBalanceLines - Catalog: `XAF` - Retrieve: true - Topic: `auditfile` - Base XPath: `/xaf:auditfile/xaf:company/xaf:openingBalance` - XPath: `/xaf:obSubledgers/xaf:obSubledger/xaf:obSbLine` The data in this table is partitioned per value of the COMPANY_NAME column. ## Table Columns The columns of the table `SubledgerOpeningBalanceLines` 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)` | | | | | `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)` | | | | | `MATCHKEYID` | `string(240)` | | | | | `MUTTP` | `string(240)` | | | | | `NR` | `string(240)` | | | | | `OBLINENR` | `string(240)` | | | | | `OBSUBLEDGER_LINESCOUNT` | `int64` | Opening Balance Subledger Lines Count | | | | `OBSUBLEDGER_OBSUBLEDGERS_OPENINGBALANCE_LINESCOUNT` | `int64` | Opening Balance Lines Count | | | | `OBSUBLEDGER_OBSUBLEDGERS_OPENINGBALANCE_OPBALDATE` | `datetime` | Opening Balance Date | | | | `OBSUBLEDGER_OBSUBLEDGERS_OPENINGBALANCE_OPBALDESC` | `string(999)` | Opening Balance Description | | | | `OBSUBLEDGER_OBSUBLEDGERS_OPENINGBALANCE_TOTALCREDIT` | `decimal` | Opening Balance Total Credit | | | | `OBSUBLEDGER_OBSUBLEDGERS_OPENINGBALANCE_TOTALDEBIT` | `decimal` | Opening Balance Total Debit | | | | `OBSUBLEDGER_SBDESC` | `string` | Opening Balance Subledger Description | | | | `OBSUBLEDGER_SBTYPE` | `string(240)` | Opening Balance Subledger Type | | | | `OBSUBLEDGER_TOTALCREDIT` | `decimal` | Opening Balance Subledger Total Credit | | | | `OBSUBLEDGER_TOTALDEBIT` | `decimal` | Opening Balance Subledger Total Debit | | | | `PRODID` | `string(240)` | | | | | `PRODUCT_ID` | `string(240)` | | ☐ | | | `PRODUCT_VERSION` | `string(240)` | | ☐ | | | `PROJID` | `string(240)` | | | | | `QNTITY` | `int64` | | | | | `QNTITYID` | `string(240)` | | | | | `RECREF` | `string(999)` | | | |