CounterPartyHistoryStreetAddresses |
Catalog: XAF
The data in this table is partitioned per value of the COMPANY_NAME column.
Retrieve: true
Topic: auditfile
Base XPath: /xaf:auditfile/xaf:company/xaf:customersSuppliers/xaf:customerSupplier
XPath: /xaf:customerSupplierHistory/xaf:customerSupplier/xaf:streetAddress
Table Columns
The columns of the table CounterPartyHistoryStreetAddresses are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
AUDIT_FILE_VERSION |
string(240) |
|
☐ |
|
CITY |
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) |
|
☐ |
|
COUNTRY |
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 Datum/Zeit |
|
|
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CHANGEINFO_CHANGEDESCRIPTION |
string(999) |
Counter Party Change Information Beschreibung |
|
|
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CHANGEINFO_USERID |
string(240) |
Counter Party Change Information Benutzer-Kennung |
|
|
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_COMMERCENR |
string(999) |
Gegenpartei Commerce Number |
|
|
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CONTACT |
string(240) |
Gegenpartei Kontaktperson |
|
|
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CUSTCREDITLIMIT |
decimal |
Gegenpartei Customer Credit Limit |
|
|
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CUSTSUPGRPID |
string(240) |
Gegenpartei Gruppen-ID |
|
|
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CUSTSUPID |
string(240) |
Gegenpartei Identifikation |
|
|
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CUSTSUPNAME |
string(240) |
Gegenpartei Name |
|
|
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CUSTSUPTP |
string(240) |
Gegenpartei Art |
|
|
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_EMAIL |
string |
Gegenpartei E-Mail |
|
|
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_FAX |
string(240) |
Gegenpartei Telefax |
|
|
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_RELATIONSHIPID |
string(240) |
Gegenpartei ID der Beziehung |
|
|
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_SUPPLIERLIMIT |
decimal |
Gegenpartei Supplier Credit Limit |
|
|
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_TAXREGIDENT |
string(240) |
Gegenpartei Tax Registration Identification |
|
|
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_TAXREGISTRATIONCOUNTRY |
string(240) |
Gegenpartei Tax Registration Country |
|
|
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_TELEPHONE |
string(240) |
Gegenpartei Telefon |
|
|
CUSTOMERSUPPLIER_CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_WEBSITE |
string |
Gegenpartei 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) |
|
☑ |
|
NUMBER |
string(240) |
|
|
|
NUMBEREXTENSION |
string(999) |
|
|
|
POSTALCODE |
string(240) |
|
|
|
PRODUCT_ID |
string(240) |
|
☐ |
|
PRODUCT_VERSION |
string(240) |
|
☐ |
|
PROPERTY |
string(240) |
|
|
|
REGION |
string(240) |
|
|
|
STREETNAME |
string(999) |
|
|
|
29-05-2022 00:55 Version 22.0.196-PROD+3400