itgendoc001X
xMsg javascript has not been loaded.
XAA 3.1 Data Model|
LocationCashRegisterCashTransactions: XAA 3.1 Cash Register Transactions per Location |
Contents Previous Home Next More |
Catalog: XAA
Label: Cash Register Transactions 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/xaa:cashregister
XPath: /xaa:cashtransaction
Table Columns
The columns of the table LocationCashRegisterCashTransactions are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
AMNTTP |
string(1) |
Amount Type |
|
|
AUDIT_FILE_VERSION |
string(240) |
Audit File Version |
☐ |
|
BOOKDATE |
datetime |
Book Date |
|
|
BOOKTIME |
datetime |
Book Time |
|
|
CASHREGISTER_REGDESC |
string(999) |
Cashregister Description |
|
|
CASHREGISTER_REGISTERID |
string(35) |
Cashregister ID |
|
|
COMPANY_ADDRESS |
string(240) |
Company Address |
☐ |
|
COMPANY_NAME |
string(1000) |
Name |
☐ |
|
COMPANY_TAX_REG_IDENT |
string(240) |
Tax Registration Identity |
☐ |
|
CUSTSUPID |
string(35) |
ID |
|
|
DESC |
string |
Description |
|
|
EMPID |
string(35) |
Employee ID |
|
|
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 |
☑ |
|
INVOICEID |
string(35) |
Invoice ID |
|
|
JRNID |
string(35) |
Journal ID |
|
|
NR |
string(35) |
Number |
|
|
PERIODNUMBER |
int64 |
Period Number |
|
|
REFID |
string |
Reference ID |
|
|
ROUNDING_ACCID |
string(35) |
Rounding ID |
|
|
ROUNDING_ROUNDINGAMNT |
decimal |
Rounding Amount |
|
|
TRANSAMNTEX |
decimal |
Transaction Amount Excluding VAT |
|
|
TRANSAMNTIN |
decimal |
Transaction Amount Including VAT |
|
|
TRANSDATE |
datetime |
Transaction Date |
|
|
TRANSID |
string(35) |
ID |
|
|
TRANSTIME |
datetime |
Transaction Time |
|
|
TRANSTYPE |
string(35) |
Type |
|
|
12-12-2020 18:39 Version 20.1.301-BETA+3023
