Please enable JavaScript to view this site.

Navigation: Schema:  > Tables

TransactionRegisters

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

XPath: /xaf:transactions

Table Columns

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

Name

Data Type

Label

Required

Documentation

AUDIT_FILE_VERSION

string(240)

 

 

COMPANY_ADDRESS

string(240)

 

 

COMPANY_CITY

string(240)

 

 

COMPANY_COMPANYIDENT

string(240)

Firma Firmenkennung

 

 

COMPANY_COMPANYNAME

string(999)

Firma Firmenname

 

 

COMPANY_ID

string(240)

 

 

COMPANY_NAME

string(1000)

 

 

COMPANY_POSTAL_CODE

string(240)

 

 

COMPANY_TAX_REG_IDENT

string(240)

 

 

COMPANY_TAXREGIDENT

string(240)

Firma Tax Registration Identification

 

 

COMPANY_TAXREGISTRATIONCOUNTRY

string(240)

Firma Tax Registration Country

 

 

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)

 

 

LINESCOUNT

int64

 

 

 

PRODUCT_ID

string(240)

 

 

PRODUCT_VERSION

string(240)

 

 

TOTALCREDIT

decimal

 

 

 

TOTALDEBIT

decimal

 

 

 

 

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