# LocationCashRegisterCashTransactionLogistics: XAA 3.1 Cash Register Transaction Logistics Movements by Location The data in this table is partitioned by the value of the column COMPANY_NAME. - Catalog: `XAA` - Label: Cash Register Transaction Logistics Movements by Location - Retrieve: true - Topic: `auditfile` - Base XPath: `/xaa:auditfile/xaa:company/xaa:location/xaa:cashregister/xaa:cashtransaction` - XPath: `/xaa:logistics` ## Table Columns The columns of the table `LocationCashRegisterCashTransactionLogistics` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ARTCD` | `string(999)` | Article Code | | | | `ARTSTTPCD` | `string(35)` | Article Type Code | | | | `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 Posting Date | | | | `CASHTRANSACTION_BOOKTIME` | `datetime` | Location Cash Register Transaction Posting 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 Amount excl. VAT | | | | `CASHTRANSACTION_TRANSAMNTIN` | `decimal` | Location Cash Register Transaction Amount incl. VAT | | | | `CASHTRANSACTION_TRANSDATE` | `datetime` | Location Cash Register Transaction Date | | | | `CASHTRANSACTION_TRANSID` | `string(35)` | Location Cash Register Transaction ID | | | | `CASHTRANSACTION_TRANSTIME` | `datetime` | Location Cash Register Transaction Time | | | | `CASHTRANSACTION_TRANSTYPE` | `string(35)` | Location Cash Register Transaction Type | | | | `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 | ☑ | | | `LOC` | `string(999)` | Location | | | | `MOVID` | `string(35)` | Movement ID | | | | `QNT` | `decimal` | Quantity | | | | `QNTID` | `string(35)` | Quantity ID | | | | `WRHS` | `string(999)` | Warehouse | | |