Transactions: XAF 3.2
read only per partition XML
- Catalog:
XAF
Can only retrieve data.
API Source
- XML topic:
auditfile - XML path:
/xaf:journal/xaf:transaction
Table Columns
The columns of the table Transactions 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 |
|---|---|---|---|---|---|
AMNT |
decimal |
||||
AMNTTP |
varchar2 |
||||
AUDIT_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
DESC |
varchar2 |
||||
FILE_ |
varchar2 |
||||
FILE_ |
varchar2 |
||||
FISCAL_ |
datetime |
||||
FISCAL_ |
varchar2 |
||||
FISCAL_ |
datetime |
||||
INTERFACE_ |
varchar2 |
||||
JOURNAL_ |
varchar2 |
Journal Bank Account Number | |||
JOURNAL_ |
varchar2 |
Journal Description | |||
JOURNAL_ |
varchar2 |
Journal Journal ID | |||
JOURNAL_ |
varchar2 |
Journal Journal Typ | |||
JOURNAL_ |
varchar2 |
Journal Offset Account ID | |||
JOURNAL_ |
int64 |
Transaction Lines Count | |||
JOURNAL_ |
decimal |
Transaction Total Credit | |||
JOURNAL_ |
decimal |
Transaction Total Debit | |||
NR |
varchar2 |
||||
PERIODNUMBER |
int64 |
||||
PRODUCT_ |
varchar2 |
||||
PRODUCT_ |
varchar2 |
||||
SOURCEID |
varchar2 |
||||
TRDT |
datetime |
||||
USERID |
varchar2 |