itgendoc001X
xMsg javascript has not been loaded.
XAA 3.1 Data Model|
LocationCashRegisterCashTransactionLines: XAA 3.1 Cash Register Transaction Lines per Location |
Contents Previous Home Next More |
Catalog: XAA
Label: Cash Register Transaction Lines 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/xaa:cashtransaction
XPath: /xaa:ctLine
Table Columns
The columns of the table LocationCashRegisterCashTransactionLines are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
AMNTTP |
string(1) |
Amount Type |
|
|
ARTGROUPID |
string(35) |
Group ID |
|
|
ARTID |
string(35) |
ID |
|
|
AUDIT_FILE_VERSION |
string(240) |
Audit File Version |
☐ |
|
CASHTRANSACTION_AMNTTP |
string(1) |
Location Cash Register Transaction Amount Type |
|
|
CASHTRANSACTION_BOOKDATE |
datetime |
Location Cash Register Transaction Book Date |
|
|
CASHTRANSACTION_BOOKTIME |
datetime |
Location Cash Register Transaction Book Time |
|
|
CASHTRANSACTION_CUSTSUPID |
string(35) |
Location Cash Register Transaction ID |
|
|
CASHTRANSACTION_DESC |
string |
Location Cash Register Transaction Description |
|
|
CASHTRANSACTION_EMPID |
string(35) |
Location Cash Register Transaction Employee ID |
|
|
CASHTRANSACTION_INVOICEID |
string(35) |
Location Cash Register Transaction Invoice ID |
|
|
CASHTRANSACTION_JRNID |
string(35) |
Location Cash Register Transaction Journal ID |
|
|
CASHTRANSACTION_NR |
string(35) |
Location Cash Register Transaction Number |
|
|
CASHTRANSACTION_PERIODNUMBER |
int64 |
Location Cash Register Transaction Period Number |
|
|
CASHTRANSACTION_REFID |
string |
Location Cash Register Transaction Reference ID |
|
|
CASHTRANSACTION_ROUNDING_ACCID |
string(35) |
Rounding ID |
|
|
CASHTRANSACTION_ROUNDING_ROUNDINGAMNT |
decimal |
Rounding Amount |
|
|
CASHTRANSACTION_TRANSAMNTEX |
decimal |
Location Cash Register Transaction Transaction Amount Excluding VAT |
|
|
CASHTRANSACTION_TRANSAMNTIN |
decimal |
Location Cash Register Transaction Transaction Amount Including VAT |
|
|
CASHTRANSACTION_TRANSDATE |
datetime |
Location Cash Register Transaction Transaction Date |
|
|
CASHTRANSACTION_TRANSID |
string(35) |
Location Cash Register Transaction ID |
|
|
CASHTRANSACTION_TRANSTIME |
datetime |
Location Cash Register Transaction Transaction Time |
|
|
CASHTRANSACTION_TRANSTYPE |
string(35) |
Location Cash Register Transaction Type |
|
|
CASHTRANSLINEDESCR |
string |
Description |
|
|
COMPANY_ADDRESS |
string(240) |
Company Address |
☐ |
|
COMPANY_NAME |
string(1000) |
Name |
☐ |
|
COMPANY_TAX_REG_IDENT |
string(240) |
Tax Registration Identity |
☐ |
|
COSTID |
string(35) |
Cost ID |
|
|
COSTOBJID |
string(35) |
Cost Object ID |
|
|
COSTPRICE |
decimal |
Cost Price |
|
|
COSTPRICEACCID |
string(35) |
Account ID for Cost Price |
|
|
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 |
☑ |
|
JRNID |
string(35) |
Journal ID |
|
|
LINEAMNTEX |
decimal |
Amount Excluding VAT |
|
|
LINEAMNTIN |
decimal |
Amount Including VAT |
|
|
LINEAMNTINACCID |
string(35) |
Account ID for Line Amount Including VAT |
|
|
LINEDATE |
datetime |
Date |
|
|
LINEID |
string(35) |
Line ID |
|
|
LINETIME |
datetime |
Time |
|
|
LINETYPE |
string(35) |
Line Type |
|
|
NR |
string(35) |
Number |
|
|
PPU |
decimal |
Price per Unit |
|
|
PROJID |
string(35) |
Project ID |
|
|
QNT |
decimal |
Quantity |
|
|
RGSREFEXT |
string(999) |
|
|
|
STOCKACCID |
string(35) |
Account ID for Stock |
|
|
VAT_ACCID |
string(35) |
VAT ID |
|
|
VAT_VATAMNT |
decimal |
VAT VAT Amount |
|
|
VAT_VATAMNTTP |
string(1) |
VAT VAT Amount Type |
|
|
VAT_VATBASAMNT |
decimal |
VAT VAT Base Amount |
|
|
VAT_VATCODE |
string(15) |
VAT VAT Code |
|
|
VAT_VATID |
string(35) |
VAT VAT ID |
|
|
VAT_VATPERC |
decimal |
VAT Percentage |
|
|
12-12-2020 18:39 Version 20.1.301-BETA+3023
