# LocationCashRegisterEvents: XAA 3.1 Cash Register Events by Location The data in this table is partitioned by the value of the column COMPANY_NAME. - Catalog: `XAA` - Label: Cash Register Events by Location - Retrieve: true - Topic: `auditfile` - Base XPath: `/xaa:auditfile/xaa:company/xaa:location/xaa:cashregister` - XPath: `/xaa:event` ## Table Columns The columns of the table `LocationCashRegisterEvents` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AUDIT_FILE_VERSION` | `string(240)` | Audit File Version | ☐ | | | `CASHREGISTER_REGDESC` | `string(999)` | Cash Register Description | | | | `CASHREGISTER_REGISTERID` | `string(35)` | Cash Register ID | | | | `COMPANY_ADDRESS` | `string(240)` | Company Address | ☐ | | | `COMPANY_NAME` | `string(1000)` | Name | ☐ | | | `COMPANY_TAX_REG_IDENT` | `string(240)` | Tax Registration Identity | ☐ | | | `EMPID` | `string(35)` | Employee ID | | | | `EVENTDATE` | `datetime` | Event Date | | | | `EVENTID` | `string(35)` | Event ID | | | | `EVENTTEXT` | `string` | Event Text | | | | `EVENTTIME` | `datetime` | Event Time | | | | `EVENTTYPE` | `string(35)` | Event Type | | | | `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 | ☑ | | | `TRANSID` | `string(35)` | ID | | |