Please enable JavaScript to view this site.

Navigation: Schema:  > Tables

Companies

Catalog: XAF

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

Retrieve: true

Topic: auditfile

Base XPath: /xaf:auditfile

XPath: /xaf:company

Table Columns

The columns of the table Companies 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_ID

string(240)

 

 

COMPANY_NAME

string(1000)

 

 

COMPANY_POSTAL_CODE

string(240)

 

 

COMPANY_TAX_REG_IDENT

string(240)

 

 

COMPANYIDENT

string(240)

 

 

 

COMPANYNAME

string(999)

 

 

 

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)

 

 

OPENINGBALANCE_LINESCOUNT

int64

Anfangsbestand Lines Count

 

 

OPENINGBALANCE_OPBALDATE

datetime

Anfangsbestand Datum

 

 

OPENINGBALANCE_OPBALDESC

string(999)

Anfangsbestand Beschreibung

 

 

OPENINGBALANCE_TOTALCREDIT

decimal

Anfangsbestand Gesamtguthaben

 

 

OPENINGBALANCE_TOTALDEBIT

decimal

Anfangsbestand Total Debit

 

 

PRODUCT_ID

string(240)

 

 

PRODUCT_VERSION

string(240)

 

 

TAXREGIDENT

string(240)

 

 

 

TAXREGISTRATIONCOUNTRY

string(240)

 

 

 

TRANSACTIONS_LINESCOUNT

int64

Transaktionen Lines Count

 

 

TRANSACTIONS_TOTALCREDIT

decimal

Transaktionen Gesamtguthaben

 

 

TRANSACTIONS_TOTALDEBIT

decimal

Transaktionen Total Debit

 

 

 

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