Please enable JavaScript to view this site.

itgendoc001X

xMsg javascript has not been loaded.

XAA 3.1 Data Model

Navigation: Schema:  > Tables

Locations: XAA 3.1 Locations

 Contents Previous Home Next More

Catalog: XAA

Label: Locations

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

XPath: /xaa:location

Table Columns

The columns of the table Locations 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_COMPANYIDENT

string(35)

Company Identification

 

 

COMPANY_COMPANYNAME

string(999)

Company Name

 

 

COMPANY_GENERALLEDGER_RGSVERSION

string(10)

General Ledger RGS Version

 

 

COMPANY_NAME

string(1000)

Name

☐

 

COMPANY_TAX_REG_IDENT

string(240)

Tax Registration Identity

☐

 

COMPANY_TAXREGIDENT

string(30)

Company Tax Registration Identity

 

 

COMPANY_TAXREGISTRATIONCOUNTRY

string(2)

Company Tax Registration Country

 

 

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

☑

 

NAME

string(100)

Name

 

 

STREETADDRESS_CITY

string(50)

Street Address City

 

 

STREETADDRESS_COUNTRY

string(2)

Street Address Country

 

 

STREETADDRESS_NUMBER

string(15)

Street Address Number

 

 

STREETADDRESS_NUMBEREXTENSION

string(999)

Street Address Number Extension

 

 

STREETADDRESS_POSTALCODE

string(10)

Street Address Postal Code

 

 

STREETADDRESS_PROPERTY

string(50)

Street Address Property

 

 

STREETADDRESS_REGION

string(50)

Street Address Region

 

 

STREETADDRESS_STREETNAME

string(999)

Street Address Street Name

 

 

 

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