Please enable JavaScript to view this site.

itgendoc001X

xMsg javascript has not been loaded.

XAA 3.1 Data Model

Navigation: Schema:  > Tables

Periods: XAA 3.1 Periods

Contents Previous Home Next More

Catalog: XAA

Label: Periods

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

This is a read-only table. The XAA 3.1 API may not support changing the data or the Invantive SQL driver for XAA 3.1 does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the XAA 3.1 API.

Topic: auditfile

Base XPath: /xaa:auditfile/xaa:company/xaa:periods

XPath: /xaa:period

Table Columns

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

Name

Data Type

Label

Required

Documentation

AUDIT_FILE_VERSION

string(240)

Audit File Version

 

COMPANY_ADDRESS

string(240)

Company Address

 

COMPANY_NAME

string(1000)

Name

 

COMPANY_TAX_REG_IDENT

string(240)

Tax Registration Identity

 

ENDDATEPERIOD

datetime

End Date Period

 

 

ENDTIMEPERIOD

datetime

End Time Period

 

 

FILE_CURRENCY_CODE

string(240)

File Currency Code

 

FILE_DATE_CREATED

string(240)

File Creation Date

 

FISCAL_YEAR_END_DATE

datetime

File End Date

 

FISCAL_YEAR_START_DATE

datetime

File Start Date

 

INTERFACE_URL

string(4000)

Interface URL

 

PERIODDESC

string(50)

Period Description

 

 

PERIODNUMBER

int64

Period Number

 

 

STARTDATEPERIOD

datetime

Start Date Period

 

 

STARTTIMEPERIOD

datetime

Start Time Period

 

 

 

12-12-2020 18:39 Version 20.1.301-BETA+3023