---
title: "OpeningBalanceLines (XAF 3.2)"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/xaf/XAF..OpeningBalanceLines
original: https://documentation.invantive.eu/en/datamodels/xaf/XAF..OpeningBalanceLines
updated: 2026-11-18T23:29:03Z
license: https://documentation.invantive.eu/en/
---

# OpeningBalanceLines: XAF 3.2

`read only` `per partition` `XML`

- Catalog: `XAF`

Can only retrieve data.

## API Source

- XML topic: `auditfile`
- XML path: `/xaf:openingBalance/xaf:obLine`

## Table Columns

The columns of the table `OpeningBalanceLines` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ACCID` | `varchar2(240)` |  | [ ] |  |  |
| `AMNT` | `decimal` |  | [ ] |  |  |
| `AMNTTP` | `varchar2(240)` |  | [ ] |  |  |
| `AUDIT_FILE_VERSION` | `varchar2(240)` |  | [ ] |  |  |
| `BALANCE` | `decimal` |  | [ ] |  |  |
| `COMPANY_ADDRESS` | `varchar2(240)` |  | [ ] |  |  |
| `COMPANY_CITY` | `varchar2(240)` |  | [ ] |  |  |
| `COMPANY_ID` | `varchar2(240)` |  | [ ] |  |  |
| `COMPANY_NAME` | `varchar2(1000)` |  | [ ] |  |  |
| `COMPANY_POSTAL_CODE` | `varchar2(240)` |  | [ ] |  |  |
| `COMPANY_TAX_REG_IDENT` | `varchar2(240)` |  | [ ] |  |  |
| `FILE_CURRENCY_CODE` | `varchar2(240)` |  | [ ] |  |  |
| `FILE_DATE_CREATED` | `varchar2(240)` |  | [ ] |  |  |
| `FISCAL_YEAR_END_DATE` | `datetime` |  | [ ] |  |  |
| `FISCAL_YEAR_NUMBER` | `varchar2(240)` |  | [x] |  |  |
| `FISCAL_YEAR_START_DATE` | `datetime` |  | [ ] |  |  |
| `INTERFACE_URL` | `varchar2(4000)` |  | [x] |  |  |
| `NR` | `varchar2(240)` |  | [ ] |  |  |
| `OPENINGBALANCE_COMPANY_COMPANYIDENT` | `varchar2(240)` | Company ID | [ ] |  |  |
| `OPENINGBALANCE_COMPANY_COMPANYNAME` | `varchar2(999)` | Company Name | [ ] |  |  |
| `OPENINGBALANCE_COMPANY_TAXREGIDENT` | `varchar2(240)` | Company Tax Registration Identification | [ ] |  |  |
| `OPENINGBALANCE_COMPANY_TAXREGISTRATIONCOUNTRY` | `varchar2(240)` | Company Tax Registration Country | [ ] |  |  |
| `OPENINGBALANCE_COMPANY_TRANSACTIONS_LINESCOUNT` | `int64` | Transaction Lines Count | [ ] |  |  |
| `OPENINGBALANCE_COMPANY_TRANSACTIONS_TOTALCREDIT` | `decimal` | Transaction Total Credit | [ ] |  |  |
| `OPENINGBALANCE_COMPANY_TRANSACTIONS_TOTALDEBIT` | `decimal` | Transaction Total Debit | [ ] |  |  |
| `OPENINGBALANCE_LINESCOUNT` | `int64` | Opening Balance Lines Count | [ ] |  |  |
| `OPENINGBALANCE_OPBALDATE` | `datetime` | Opening Balance Date | [ ] |  |  |
| `OPENINGBALANCE_OPBALDESC` | `varchar2(999)` | Opening Balance Description | [ ] |  |  |
| `OPENINGBALANCE_TOTALCREDIT` | `decimal` | Opening Balance Total Credit | [ ] |  |  |
| `OPENINGBALANCE_TOTALDEBIT` | `decimal` | Opening Balance Total Debit | [ ] |  |  |
| `PRODUCT_ID` | `varchar2(240)` |  | [ ] |  |  |
| `PRODUCT_VERSION` | `varchar2(240)` |  | [ ] |  |  |

