# CounterPartyStreetAddresses: XAA 3.1 Counterparty Street Addresses The data in this table is partitioned by the value of the column COMPANY_NAME. - Catalog: `XAA` - Label: Counterparty Street Addresses - Retrieve: true - Topic: `auditfile` - Base XPath: `/xaa:auditfile/xaa:company/xaa:customersSuppliers/xaa:customerSupplier` - XPath: `/xaa:streetAddress` ## Table Columns The columns of the table `CounterPartyStreetAddresses` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AUDIT_FILE_VERSION` | `string(240)` | Audit File Version | ☐ | | | `CITY` | `string(50)` | City | | | | `COMPANY_ADDRESS` | `string(240)` | Company Address | ☐ | | | `COMPANY_NAME` | `string(1000)` | Name | ☐ | | | `COMPANY_TAX_REG_IDENT` | `string(240)` | Tax Registration Identity | ☐ | | | `COUNTRY` | `string(2)` | Country | | | | `CUSTOMERSUPPLIER_CONTACT` | `string(50)` | Counterparty Contact Person | | | | `CUSTOMERSUPPLIER_CUSTSUPID` | `string(35)` | Counterparty ID | | | | `CUSTOMERSUPPLIER_EMAIL` | `string` | Counterparty Email | | | | `CUSTOMERSUPPLIER_FAX` | `string(30)` | Counterparty Fax | | | | `CUSTOMERSUPPLIER_TAXREGIDENT` | `string(30)` | Counterparty Tax Registration Identity | | | | `CUSTOMERSUPPLIER_TAXREGISTRATIONCOUNTRY` | `string(2)` | Counterparty Tax Registration Country | | | | `CUSTOMERSUPPLIER_TELEPHONE` | `string(30)` | Counterparty Telephone | | | | `CUSTOMERSUPPLIER_WEBSITE` | `string` | Counterparty Website | | | | `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 | ☑ | | | `NUMBER` | `string(15)` | Number | | | | `NUMBEREXTENSION` | `string(999)` | Extension Number | | | | `POSTALCODE` | `string(10)` | Postcode | | | | `PROPERTY` | `string(50)` | Property | | | | `REGION` | `string(50)` | Region | | | | `STREETNAME` | `string(999)` | Street Name | | |