Please enable JavaScript to view this site.

Navigation: Schema:  > Tables

Transactions: XAF 3.2 Transactions

Contents Previous Home Next More

Catalog: XAF

Label: Transactions

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/xaf:transaction

Table Columns

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

Name

Data Type

Label

Required

Documentation

AMNT

decimal

Amount

 

 

AMNTTP

string(240)

Amount Type

 

 

AUDIT_FILE_VERSION

string(240)

Audit File Version

 

COMPANY_ADDRESS

string(240)

Company Address

 

COMPANY_CITY

string(240)

Company City

 

COMPANY_ID

string(240)

Company ID

 

COMPANY_NAME

string(1000)

Company Name

 

COMPANY_POSTAL_CODE

string(240)

Company Postal Code

 

COMPANY_TAX_REG_IDENT

string(240)

Tax Registration Identification

 

DESC

string

Description

 

 

DESCRIPTION

string

Journal Description

 

 

FILE_CURRENCY_CODE

string(240)

File Currency Code

 

FILE_DATE_CREATED

string(240)

File Creation Date

 

FISCAL_YEAR_END_DATE

datetime

Fiscal Year End Date

 

FISCAL_YEAR_NUMBER

string(240)

Fiscal Year Number

 

FISCAL_YEAR_START_DATE

datetime

Fiscal Year Start Date

 

INTERFACE_URL

string(4000)

Interface URL

 

JOURNAL_BANKACCNR

string(240)

Journal Bank Account Number

 

 

JOURNAL_JRNID

string(240)

Journal Journal ID

 

 

JOURNAL_JRNTP

string(240)

Journal Journal Type

 

 

JOURNAL_OFFSETACCID

string(240)

Journal Offset Account ID

 

 

JOURNAL_TRANSACTIONS_LINESCOUNT

int64

Transaction Lines Count

 

 

JOURNAL_TRANSACTIONS_TOTALCREDIT

decimal

Transaction Total Credit

 

 

JOURNAL_TRANSACTIONS_TOTALDEBIT

decimal

Transaction Total Debit

 

 

NR

string(240)

Number

 

 

PERIODNUMBER

int64

Period Number

 

 

PRODUCT_ID

string(240)

Product ID

 

PRODUCT_VERSION

string(240)

Product Version

 

SOURCEID

string(240)

Source ID

 

 

TRDT

datetime

Date

 

 

USERID

string(240)

User ID

 

 

 

27-12-2021 11:01 Version 20.2.169-PROD+3633