Please enable JavaScript to view this site.

Navigation: Schema:  > Tables

TransactionJournals

Catalog: XAF

The data in this table is partitioned per value of the COMPANY_NAME column.

Retrieve: true

Topic: auditfile

Base XPath: /xaf:auditfile/xaf:company/xaf:transactions

XPath: /xaf:journal

Table Columns

The columns of the table TransactionJournals are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

AUDIT_FILE_VERSION

string(240)

 

 

BANKACCNR

string(240)

 

 

 

COMPANY_ADDRESS

string(240)

 

 

COMPANY_CITY

string(240)

 

 

COMPANY_ID

string(240)

 

 

COMPANY_NAME

string(1000)

 

 

COMPANY_POSTAL_CODE

string(240)

 

 

COMPANY_TAX_REG_IDENT

string(240)

 

 

DESCRIPTION

string

 

 

 

FILE_CURRENCY_CODE

string(240)

 

 

FILE_DATE_CREATED

string(240)

 

 

FISCAL_YEAR_END_DATE

datetime

 

 

FISCAL_YEAR_NUMBER

string(240)

 

 

FISCAL_YEAR_START_DATE

datetime

 

 

INTERFACE_URL

string(4000)

 

 

JRNID

string(240)

 

 

 

JRNTP

string(240)

 

 

 

OFFSETACCID

string(240)

 

 

 

PRODUCT_ID

string(240)

 

 

PRODUCT_VERSION

string(240)

 

 

TRANSACTIONS_LINESCOUNT

int64

Verhandlung Lines Count

 

 

TRANSACTIONS_TOTALCREDIT

decimal

Verhandlung Gesamtguthaben

 

 

TRANSACTIONS_TOTALDEBIT

decimal

Verhandlung Total Debit

 

 

 

29-05-2022 00:55 Version 22.0.196-PROD+3400