itgendoc001X
xMsg javascript has not been loaded.
XAA 3.1 Data ModelCatalog: XAA
Label: Cash Registers per Location
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:location
XPath: /xaa:cashregister
Table Columns
The columns of the table LocationCashRegisters 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 |
☐ |
|
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 |
☑ |
|
LOCATION_NAME |
string(100) |
Location Name |
|
|
LOCATION_STREETADDRESS_CITY |
string(50) |
Company Location Street Address City |
|
|
LOCATION_STREETADDRESS_COUNTRY |
string(2) |
Company Location Street Address Country |
|
|
LOCATION_STREETADDRESS_NUMBER |
string(15) |
Company Location Street Address Number |
|
|
LOCATION_STREETADDRESS_NUMBEREXTENSION |
string(999) |
Company Location Street Address Number Extension |
|
|
LOCATION_STREETADDRESS_POSTALCODE |
string(10) |
Company Location Street Address Postal Code |
|
|
LOCATION_STREETADDRESS_PROPERTY |
string(50) |
Company Location Street Address Property |
|
|
LOCATION_STREETADDRESS_REGION |
string(50) |
Company Location Street Address Region |
|
|
LOCATION_STREETADDRESS_STREETNAME |
string(999) |
Company Location Street Address Street Name |
|
|
REGDESC |
string(999) |
Description |
|
|
REGISTERID |
string(35) |
ID |
|
|
12-12-2020 18:39 Version 20.1.301-BETA+3023
