itgendoc001X
xMsg javascript has not been loaded.
XAF 3.2 Data ModelCatalog: XAF
Label: Counter Party Histories
The data in this table is partitioned per value of the COMPANY_NAME column.
This is a read-only table. The XAF 3.2 API may not support changing the data or the Invantive SQL driver for XAF 3.2 does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the XAF 3.2 API.
Topic: auditfile
Base XPath: /xaf:auditfile/xaf:company/xaf:customersSuppliers/xaf:customerSupplier
XPath: /xaf:customerSupplierHistory/xaf:customerSupplier
Table Columns
The columns of the table CounterPartyHistories are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
AUDIT_FILE_VERSION |
string(240) |
Audit File Version |
☐ |
|
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) |
Commerce Number |
|
|
COMPANY_ADDRESS |
string(240) |
Company Address |
☐ |
|
COMPANY_CITY |
string(240) |
Company City |
☐ |
|
COMPANY_ID |
string(240) |
Company ID |
☐ |
|
COMPANY_NAME |
string(1000) |
Company Name |
☐ |
|
COMPANY_POSTAL_CODE |
string(240) |
Company Postal Code |
☐ |
|
COMPANY_TAX_REG_IDENT |
string(240) |
Tax Registration Identification |
☐ |
|
CONTACT |
string(240) |
Contact Person |
|
|
CUSTCREDITLIMIT |
decimal |
Customer Credit Limit |
|
|
CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CHANGEINFO_CHANGEDATETIME |
datetime |
Counter Party Change Information Date/Time |
|
|
CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CHANGEINFO_CHANGEDESCRIPTION |
string(999) |
Counter Party Change Information Description |
|
|
CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CHANGEINFO_USERID |
string(240) |
Counter Party Change Information User ID |
|
|
CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_COMMERCENR |
string(999) |
Counter Party Commerce Number |
|
|
CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CONTACT |
string(240) |
Counter Party Contact Person |
|
|
CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CUSTCREDITLIMIT |
decimal |
Counter Party Customer Credit Limit |
|
|
CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CUSTSUPGRPID |
string(240) |
Counter Party Group ID |
|
|
CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CUSTSUPID |
string(240) |
Counter Party ID |
|
|
CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CUSTSUPNAME |
string(240) |
Counter Party Name |
|
|
CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_CUSTSUPTP |
string(240) |
Counter Party Type |
|
|
CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_EMAIL |
string |
Counter Party Email |
|
|
CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_FAX |
string(240) |
Counter Party Fax |
|
|
CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_RELATIONSHIPID |
string(240) |
Counter Party Relationship ID |
|
|
CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_SUPPLIERLIMIT |
decimal |
Counter Party Supplier Credit Limit |
|
|
CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_TAXREGIDENT |
string(240) |
Counter Party Tax Registration Identification |
|
|
CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_TAXREGISTRATIONCOUNTRY |
string(240) |
Counter Party Tax Registration Country |
|
|
CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_TELEPHONE |
string(240) |
Counter Party Telephone |
|
|
CUSTOMERSUPPLIERHISTORY_CUSTOMERSUPPLIER_WEBSITE |
string |
Counter Party Website |
|
|
CUSTSUPGRPID |
string(240) |
Group ID |
|
|
CUSTSUPID |
string(240) |
ID |
|
|
CUSTSUPNAME |
string(240) |
Name |
|
|
CUSTSUPTP |
string(240) |
Type |
|
|
string |
|
|
||
FAX |
string(240) |
Fax |
|
|
FILE_CURRENCY_CODE |
string(240) |
File Currency Code |
☐ |
|
FILE_DATE_CREATED |
string(240) |
File Creation Date |
☐ |
|
FISCAL_YEAR_END_DATE |
datetime |
Fiscal Year End Date |
☐ |
|
FISCAL_YEAR_NUMBER |
string(240) |
Fiscal Year Number |
☑ |
|
FISCAL_YEAR_START_DATE |
datetime |
Fiscal Year Start Date |
☐ |
|
INTERFACE_URL |
string(4000) |
Interface URL |
☑ |
|
PRODUCT_ID |
string(240) |
Product ID |
☐ |
|
PRODUCT_VERSION |
string(240) |
Product Version |
☐ |
|
RELATIONSHIPID |
string(240) |
Relationship ID |
|
|
SUPPLIERLIMIT |
decimal |
Supplier Credit Limit |
|
|
TAXREGIDENT |
string(240) |
Tax Registration Identification |
|
|
TAXREGISTRATIONCOUNTRY |
string(240) |
Tax Registration Country |
|
|
TELEPHONE |
string(240) |
Telephone |
|
|
WEBSITE |
string |
Website |
|
|
12-12-2020 18:41 Version 20.1.301-BETA+3023
