# CounterPartyHistoryBankAccounts - Catalog: `XAF` - Retrieve: true - Topic: `auditfile` - Base XPath: `/xaf:auditfile/xaf:company/xaf:customersSuppliers/xaf:customerSupplier` - XPath: `/xaf:customerSupplierHistory/xaf:customerSupplier/xaf:bankAccount` The data in this table is partitioned per value of the COMPANY_NAME column. ## Table Columns The columns of the table `CounterPartyHistoryBankAccounts` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AUDIT_FILE_VERSION` | `string(240)` | | ☐ | | | `BANKACCNR` | `string(240)` | | | | | `BANKIDCD` | `string(240)` | | | | | `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)` | | ☐ | | | `CUSTOMERSUPPLIER_CHANGEINFO_CHANGEDATETIME` | `datetime` | | | | | `CUSTOMERSUPPLIER_CHANGEINFO_CHANGEDESCRIPTION` | `string(999)` | | | | | `CUSTOMERSUPPLIER_CHANGEINFO_USERID` | `string(240)` | | | | | `CUSTOMERSUPPLIER_COMMERCENR` | `string(999)` | | | | | `CUSTOMERSUPPLIER_CONTACT` | `string(240)` | | | | | `CUSTOMERSUPPLIER_CUSTCREDITLIMIT` | `decimal` | | | | | `CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CHANGEINFO_CHANGEDATETIME` | `datetime` | Counter Party Change Information Date/Time | | | | `CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CHANGEINFO_CHANGEDESCRIPTION` | `string(999)` | Counter Party Change Information Description | | | | `CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CHANGEINFO_USERID` | `string(240)` | Counter Party Change Information User ID | | | | `CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_COMMERCENR` | `string(999)` | Counterparty Commerce Number | | | | `CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CONTACT` | `string(240)` | Counterparty Contact Person | | | | `CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CUSTCREDITLIMIT` | `decimal` | Counterparty Customer Credit Limit | | | | `CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CUSTSUPGRPID` | `string(240)` | Counterparty Group ID | | | | `CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CUSTSUPID` | `string(240)` | Counterparty Identification | | | | `CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CUSTSUPNAME` | `string(240)` | Counterparty Name | | | | `CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CUSTSUPTP` | `string(240)` | Counterparty Type | | | | `CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_EMAIL` | `string` | Counterparty Email | | | | `CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_FAX` | `string(240)` | Counterparty Fax | | | | `CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_RELATIONSHIPID` | `string(240)` | Counterparty Relationship ID | | | | `CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_SUPPLIERLIMIT` | `decimal` | Counterparty Supplier Credit Limit | | | | `CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_TAXREGIDENT` | `string(240)` | Counterparty Tax Registration Identification | | | | `CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_TAXREGISTRATIONCOUNTRY` | `string(240)` | Counterparty Tax Registration Country | | | | `CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_TELEPHONE` | `string(240)` | Counterparty Telephone | | | | `CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_WEBSITE` | `string` | Counterparty Website | | | | `CUSTOMERSUPPLIER_CUSTSUPGRPID` | `string(240)` | | | | | `CUSTOMERSUPPLIER_CUSTSUPID` | `string(240)` | | | | | `CUSTOMERSUPPLIER_CUSTSUPNAME` | `string(240)` | | | | | `CUSTOMERSUPPLIER_CUSTSUPTP` | `string(240)` | | | | | `CUSTOMERSUPPLIER_EMAIL` | `string` | | | | | `CUSTOMERSUPPLIER_FAX` | `string(240)` | | | | | `CUSTOMERSUPPLIER_RELATIONSHIPID` | `string(240)` | | | | | `CUSTOMERSUPPLIER_SUPPLIERLIMIT` | `decimal` | | | | | `CUSTOMERSUPPLIER_TAXREGIDENT` | `string(240)` | | | | | `CUSTOMERSUPPLIER_TAXREGISTRATIONCOUNTRY` | `string(240)` | | | | | `CUSTOMERSUPPLIER_TELEPHONE` | `string(240)` | | | | | `CUSTOMERSUPPLIER_WEBSITE` | `string` | | | | | `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)` | | ☐ | |