xMsg javascript has not been loaded.
Catalog: XAA
Label: Companies
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
XPath: /xaa:company
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) |
Audit File Version |
☐ |
|
AUDITFILE_HEADER_COMPID |
string(35) |
|
|
|
AUDITFILE_HEADER_CURCODE |
string(3) |
Header Currency Code |
|
|
AUDITFILE_HEADER_DATECREATED |
datetime |
Header Date Created |
|
|
AUDITFILE_HEADER_ENDDATE |
datetime |
Header End Date |
|
|
AUDITFILE_HEADER_FISCALYEAR |
string(9) |
Header Fiscal Year |
|
|
AUDITFILE_HEADER_SOFTWAREDESC |
string(50) |
Header Software Description |
|
|
AUDITFILE_HEADER_SOFTWAREVERSION |
string(20) |
Header Software Version |
|
|
AUDITFILE_HEADER_STARTDATE |
datetime |
Header Start Date |
|
|
AUDITFILE_ID_ATTR |
string |
ID |
|
|
COMPANY_ADDRESS |
string(240) |
Company Address |
☐ |
|
COMPANY_NAME |
string(1000) |
Name |
☐ |
|
COMPANY_TAX_REG_IDENT |
string(240) |
Tax Registration Identity |
☐ |
|
COMPANYIDENT |
string(35) |
Identification |
|
|
COMPANYNAME |
string(999) |
Name |
|
|
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 |
☐ |
|
GENERALLEDGER_RGSVERSION |
string(10) |
General Ledger RGS Version |
|
|
INTERFACE_URL |
string(4000) |
Interface URL |
☑ |
|
TAXREGIDENT |
string(30) |
Tax Registration Identity |
|
|
TAXREGISTRATIONCOUNTRY |
string(2) |
Tax Registration Country |
|
|
12-12-2020 18:39 Version 20.1.301-BETA+3023