invantive documentation
Invantive Support ForumsLog In / Sign Up

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(240)
AMNT decimal
AMNTTP varchar2(240)
ARTGRPID varchar2(240)
AUDIT_FILE_VERSION varchar2(240)
BALANCE decimal
BANKACCNR varchar2(240)
BANKIDCD varchar2(240)
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)
COSTID varchar2(240)
CURRENCY_CURAMNT decimal Currency Amount
CURRENCY_CURCODE varchar2(240) Currency Currency Code
CUSTSUPID varchar2(240)
DESCRIPTION varchar2
DOCREF varchar2(999)
EFFDATE datetime
FILE_CURRENCY_CODE varchar2(240)
FILE_DATE_CREATED varchar2(240)
FISCAL_YEAR_END_DATE datetime
FISCAL_YEAR_NUMBER varchar2(240)
FISCAL_YEAR_START_DATE datetime
INTERFACE_URL varchar2(4000)
INVREF varchar2(999)
MATCHKEYID varchar2(240)
NR varchar2(240)
ORDERREF varchar2(999)
PRODID varchar2(240)
PRODUCT_ID varchar2(240)
PRODUCT_VERSION varchar2(240)
PROJID varchar2(240)
QNTITY int64
QNTITYID varchar2(240)
RECEIVINGDOCREF varchar2(999)
RECREF varchar2(999)
SHIPDOCREF varchar2(999)
TRANSACTION_AMNT decimal Transaction Amount
TRANSACTION_AMNTTP varchar2(240) Transaction Amount Type
TRANSACTION_DESC varchar2 Transaction Description
TRANSACTION_JOURNAL_BANKACCNR varchar2(240) Journal Bank Account Number
TRANSACTION_JOURNAL_DESCRIPTION varchar2 Journal Description
TRANSACTION_JOURNAL_JRNID varchar2(240) Journal Journal ID
TRANSACTION_JOURNAL_JRNTP varchar2(240) Journal Journal Typ
TRANSACTION_JOURNAL_OFFSETACCID varchar2(240) Journal Offset Account ID
TRANSACTION_JOURNAL_TRANSACTIONS_LINESCOUNT int64 Transaction Lines Count
TRANSACTION_JOURNAL_TRANSACTIONS_TOTALCREDIT decimal Transaction Total Credit
TRANSACTION_JOURNAL_TRANSACTIONS_TOTALDEBIT decimal Transaction Total Debit
TRANSACTION_NR varchar2(240) Transaction Number
TRANSACTION_PERIODNUMBER int64 Transaction Period Number
TRANSACTION_SOURCEID varchar2(240) Transaction Source ID
TRANSACTION_TRDT datetime Transaction Date
TRANSACTION_USERID varchar2(240) Transaction User ID
WORKCOSTARRREF varchar2(999)