# CounterParties - Catalog: `XAF` - Retrieve: true - Topic: `auditfile` - Base XPath: `/xaf:auditfile/xaf:company/xaf:customersSuppliers` - XPath: `/xaf:customerSupplier` The data in this table is partitioned per value of the COMPANY_NAME column. ## Table Columns The columns of the table `CounterParties` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AUDIT_FILE_VERSION` | `string(240)` | | ☐ | | | `CHANGEINFO_CHANGEDATETIME` | `datetime` | Change Information Date/Time | | | | `CHANGEINFO_CHANGEDESCRIPTION` | `string(999)` | Change Information Description | | | | `CHANGEINFO_USERID` | `string(240)` | Change Information User ID | | | | `COMMERCENR` | `string(999)` | | | | | `COMPANY_ADDRESS` | `string(240)` | | ☐ | | | `COMPANY_CITY` | `string(240)` | | ☐ | | | `COMPANY_ID` | `string(240)` | | ☐ | | | `COMPANY_NAME` | `string(1000)` | | ☐ | | | `COMPANY_POSTAL_CODE` | `string(240)` | | ☐ | | | `COMPANY_TAX_REG_IDENT` | `string(240)` | | ☐ | | | `CONTACT` | `string(240)` | | | | | `CUSTCREDITLIMIT` | `decimal` | | | | | `CUSTSUPGRPID` | `string(240)` | | | | | `CUSTSUPID` | `string(240)` | | | | | `CUSTSUPNAME` | `string(240)` | | | | | `CUSTSUPTP` | `string(240)` | | | | | `EMAIL` | `string` | | | | | `FAX` | `string(240)` | | | | | `FILE_CURRENCY_CODE` | `string(240)` | | ☐ | | | `FILE_DATE_CREATED` | `string(240)` | | ☐ | | | `FISCAL_YEAR_END_DATE` | `datetime` | | ☐ | | | `FISCAL_YEAR_NUMBER` | `string(240)` | | ☑ | | | `FISCAL_YEAR_START_DATE` | `datetime` | | ☐ | | | `INTERFACE_URL` | `string(4000)` | | ☑ | | | `PRODUCT_ID` | `string(240)` | | ☐ | | | `PRODUCT_VERSION` | `string(240)` | | ☐ | | | `RELATIONSHIPID` | `string(240)` | | | | | `SUPPLIERLIMIT` | `decimal` | | | | | `TAXREGIDENT` | `string(240)` | | | | | `TAXREGISTRATIONCOUNTRY` | `string(240)` | | | | | `TELEPHONE` | `string(240)` | | | | | `WEBSITE` | `string` | | | |