TransactionLines: 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/xaf:trLine
Table Columns
The columns of the table TransactionLines 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 |
||||
ARTGRPID |
varchar2 |
||||
AUDIT_ |
varchar2 |
||||
BALANCE |
decimal |
||||
BANKACCNR |
varchar2 |
||||
BANKIDCD |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COSTID |
varchar2 |
||||
CURRENCY_ |
decimal |
Currency Amount | |||
CURRENCY_ |
varchar2 |
Currency Currency Code | |||
CUSTSUPID |
varchar2 |
||||
DESCRIPTION |
varchar2 |
||||
DOCREF |
varchar2 |
||||
EFFDATE |
datetime |
||||
FILE_ |
varchar2 |
||||
FILE_ |
varchar2 |
||||
FISCAL_ |
datetime |
||||
FISCAL_ |
varchar2 |
||||
FISCAL_ |
datetime |
||||
INTERFACE_ |
varchar2 |
||||
INVREF |
varchar2 |
||||
MATCHKEYID |
varchar2 |
||||
NR |
varchar2 |
||||
ORDERREF |
varchar2 |
||||
PRODID |
varchar2 |
||||
PRODUCT_ |
varchar2 |
||||
PRODUCT_ |
varchar2 |
||||
PROJID |
varchar2 |
||||
QNTITY |
int64 |
||||
QNTITYID |
varchar2 |
||||
RECEIVINGDOCREF |
varchar2 |
||||
RECREF |
varchar2 |
||||
SHIPDOCREF |
varchar2 |
||||
TRANSACTION_ |
decimal |
Transaction Amount | |||
TRANSACTION_ |
varchar2 |
Transaction Amount Type | |||
TRANSACTION_ |
varchar2 |
Transaction Description | |||
TRANSACTION_ |
varchar2 |
Journal Bank Account Number | |||
TRANSACTION_ |
varchar2 |
Journal Description | |||
TRANSACTION_ |
varchar2 |
Journal Journal ID | |||
TRANSACTION_ |
varchar2 |
Journal Journal Typ | |||
TRANSACTION_ |
varchar2 |
Journal Offset Account ID | |||
TRANSACTION_ |
int64 |
Transaction Lines Count | |||
TRANSACTION_ |
decimal |
Transaction Total Credit | |||
TRANSACTION_ |
decimal |
Transaction Total Debit | |||
TRANSACTION_ |
varchar2 |
Transaction Number | |||
TRANSACTION_ |
int64 |
Transaction Period Number | |||
TRANSACTION_ |
varchar2 |
Transaction Source ID | |||
TRANSACTION_ |
datetime |
Transaction Date | |||
TRANSACTION_ |
varchar2 |
Transaction User ID | |||
WORKCOSTARRREF |
varchar2 |