# LocationCashRegisterCashTransactionLineDiscounts: XAA 3.1 Cash Register Transaction Line Discounts by Location The data in this table is partitioned by the value of the column COMPANY_NAME. - Catalog: `XAA` - Label: Cash Register Transaction Line Discounts by Location - Retrieve: true - Topic: `auditfile` - Base XPath: `/xaa:auditfile/xaa:company/xaa:location/xaa:cashregister/xaa:cashtransaction/xaa:ctLine` - XPath: `/xaa:discount` ## Table Columns The columns of the table `LocationCashRegisterCashTransactionLineDiscounts` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACCID` | `string(35)` | ID | | | | `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 | ☐ | | | `CTLINE_AMNTTP` | `string(1)` | Amount Type | | | | `CTLINE_ARTGROUPID` | `string(35)` | Group ID | | | | `CTLINE_ARTID` | `string(35)` | ID | | | | `CTLINE_CASHTRANSLINEDESCR` | `string` | Description | | | | `CTLINE_COSTID` | `string(35)` | Cost ID | | | | `CTLINE_COSTOBJID` | `string(35)` | Cost Object ID | | | | `CTLINE_COSTPRICE` | `decimal` | Cost Price | | | | `CTLINE_COSTPRICEACCID` | `string(35)` | Account ID for Cost Price | | | | `CTLINE_EMPID` | `string(35)` | Employee ID | | | | `CTLINE_JRNID` | `string(35)` | Journal ID | | | | `CTLINE_LINEAMNTEX` | `decimal` | Amount excluding VAT | | | | `CTLINE_LINEAMNTIN` | `decimal` | Quantity including VAT | | | | `CTLINE_LINEAMNTINACCID` | `string(35)` | Account ID for Line Amount including VAT | | | | `CTLINE_LINEDATE` | `datetime` | Date | | | | `CTLINE_LINEID` | `string(35)` | Line ID | | | | `CTLINE_LINETIME` | `datetime` | Time | | | | `CTLINE_LINETYPE` | `string(35)` | Line Type | | | | `CTLINE_NR` | `string(35)` | Number | | | | `CTLINE_PPU` | `decimal` | Price per Unit | | | | `CTLINE_PROJID` | `string(35)` | Project ID | | | | `CTLINE_QNT` | `decimal` | Quantity | | | | `CTLINE_RGSREFEXT` | `string(999)` | RGS Reference Extension | | | | `CTLINE_STOCKACCID` | `string(35)` | Account ID for Inventory | | | | `CTLINE_VAT_ACCID` | `string(35)` | | | | | `CTLINE_VAT_VATAMNT` | `decimal` | | | | | `CTLINE_VAT_VATAMNTTP` | `string(1)` | | | | | `CTLINE_VAT_VATBASAMNT` | `decimal` | | | | | `CTLINE_VAT_VATCODE` | `string(15)` | | | | | `CTLINE_VAT_VATID` | `string(35)` | | | | | `CTLINE_VAT_VATPERC` | `decimal` | | | | | `DSCAMNT` | `decimal` | Amount | | | | `DSCTP` | `string(35)` | Type | | | | `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 | ☑ | |