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 |
||||
AMNT |
decimal |
||||
AMNTTP |
varchar2 |
||||
AUDIT_ |
varchar2 |
||||
BALANCE |
decimal |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
FILE_ |
varchar2 |
||||
FILE_ |
varchar2 |
||||
FISCAL_ |
datetime |
||||
FISCAL_ |
varchar2 |
||||
FISCAL_ |
datetime |
||||
INTERFACE_ |
varchar2 |
||||
NR |
varchar2 |
||||
OPENINGBALANCE_ |
varchar2 |
Company ID | |||
OPENINGBALANCE_ |
varchar2 |
Company Name | |||
OPENINGBALANCE_ |
varchar2 |
Company Tax Registration Identification | |||
OPENINGBALANCE_ |
varchar2 |
Company Tax Registration Country | |||
OPENINGBALANCE_ |
int64 |
Transaction Lines Count | |||
OPENINGBALANCE_ |
decimal |
Transaction Total Credit | |||
OPENINGBALANCE_ |
decimal |
Transaction Total Debit | |||
OPENINGBALANCE_ |
int64 |
Opening Balance Lines Count | |||
OPENINGBALANCE_ |
datetime |
Opening Balance Date | |||
OPENINGBALANCE_ |
varchar2 |
Opening Balance Description | |||
OPENINGBALANCE_ |
decimal |
Opening Balance Total Credit | |||
OPENINGBALANCE_ |
decimal |
Opening Balance Total Debit | |||
PRODUCT_ |
varchar2 |
||||
PRODUCT_ |
varchar2 |