# Companies: XAA 3.1 Companies The data in this table is partitioned by the value of the column COMPANY_NAME. - Catalog: `XAA` - Label: Companies - Retrieve: true - Topic: `auditfile` - Base XPath: `/xaa:auditfile` - XPath: `/xaa:company` ## Table Columns The columns of the table `Companies` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AUDIT_FILE_VERSION` | `string(240)` | Audit File Version | ☐ | | | `AUDITFILE_HEADER_COMPID` | `string(35)` | Header Company ID | | | | `AUDITFILE_HEADER_CURCODE` | `string(3)` | Header Currency Code | | | | `AUDITFILE_HEADER_DATECREATED` | `datetime` | Header Date Created | | | | `AUDITFILE_HEADER_ENDDATE` | `datetime` | Header End Date | | | | `AUDITFILE_HEADER_FISCALYEAR` | `string(9)` | Header Tax Year | | | | `AUDITFILE_HEADER_SOFTWAREDESC` | `string(50)` | Header Software Description | | | | `AUDITFILE_HEADER_SOFTWAREVERSION` | `string(20)` | Header Software Version | | | | `AUDITFILE_HEADER_STARTDATE` | `datetime` | Header Start Date | | | | `AUDITFILE_ID_ATTR` | `string` | ID | | | | `COMPANY_ADDRESS` | `string(240)` | Company Address | ☐ | | | `COMPANY_NAME` | `string(1000)` | Name | ☐ | | | `COMPANY_TAX_REG_IDENT` | `string(240)` | Tax Registration Identity | ☐ | | | `COMPANYIDENT` | `string(35)` | Identification | | | | `COMPANYNAME` | `string(999)` | Name | | | | `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 | ☐ | | | `GENERALLEDGER_RGSVERSION` | `string(10)` | General Ledger RGS Version | | | | `INTERFACE_URL` | `string(4000)` | Interface URL | ☑ | | | `TAXREGIDENT` | `string(30)` | Tax Registration Identity | | | | `TAXREGISTRATIONCOUNTRY` | `string(2)` | Tax Registration Country | | |