OpeningBalances: XAF 3.2
read only per partition XML
- Catalog:
XAF
Can only retrieve data.
API Source
- XML topic:
auditfile - XML path:
/xaf:openingBalance
Table Columns
The columns of the table OpeningBalances 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 |
|---|---|---|---|---|---|
AUDIT_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
Company ID | |||
COMPANY_ |
varchar2 |
Company Name | |||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
Company Tax Registration Identification | |||
COMPANY_ |
varchar2 |
Company Tax Registration Country | |||
COMPANY_ |
int64 |
Transaction Lines Count | |||
COMPANY_ |
decimal |
Transaction Total Credit | |||
COMPANY_ |
decimal |
Transaction Total Debit | |||
FILE_ |
varchar2 |
||||
FILE_ |
varchar2 |
||||
FISCAL_ |
datetime |
||||
FISCAL_ |
varchar2 |
||||
FISCAL_ |
datetime |
||||
INTERFACE_ |
varchar2 |
||||
LINESCOUNT |
int64 |
||||
OPBALDATE |
datetime |
||||
OPBALDESC |
varchar2 |
||||
PRODUCT_ |
varchar2 |
||||
PRODUCT_ |
varchar2 |
||||
TOTALCREDIT |
decimal |
||||
TOTALDEBIT |
decimal |