CounterPartyHistories: XAF 3.2
read only per partition XML
- Catalog:
XAF
Can only retrieve data.
API Source
- XML topic:
auditfile - XML path:
/xaf:customerSupplierHistory/xaf:customerSupplier
Table Columns
The columns of the table CounterPartyHistories are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
AUDIT_ |
varchar2 |
||||
CHANGEINFO_ |
datetime |
Change Information Date/Time | |||
CHANGEINFO_ |
varchar2 |
Change Information Description | |||
CHANGEINFO_ |
varchar2 |
Change Information User ID | |||
COMMERCENR |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
COMPANY_ |
varchar2 |
||||
CONTACT |
varchar2 |
||||
CUSTCREDITLIMIT |
decimal |
||||
CUSTOMERSUPPLIERHISTORY_ |
datetime |
Counter Party Change Information Date/Time | |||
CUSTOMERSUPPLIERHISTORY_ |
varchar2 |
Counter Party Change Information Description | |||
CUSTOMERSUPPLIERHISTORY_ |
varchar2 |
Counter Party Change Information User ID | |||
CUSTOMERSUPPLIERHISTORY_ |
varchar2 |
Counterparty Commerce Number | |||
CUSTOMERSUPPLIERHISTORY_ |
varchar2 |
Counterparty Contact Person | |||
CUSTOMERSUPPLIERHISTORY_ |
decimal |
Counterparty Customer Credit Limit | |||
CUSTOMERSUPPLIERHISTORY_ |
varchar2 |
Counterparty Group ID | |||
CUSTOMERSUPPLIERHISTORY_ |
varchar2 |
Counterparty Identification | |||
CUSTOMERSUPPLIERHISTORY_ |
varchar2 |
Counterparty Name | |||
CUSTOMERSUPPLIERHISTORY_ |
varchar2 |
Counterparty Type | |||
CUSTOMERSUPPLIERHISTORY_ |
varchar2 |
Counterparty Email | |||
CUSTOMERSUPPLIERHISTORY_ |
varchar2 |
Counterparty Fax | |||
CUSTOMERSUPPLIERHISTORY_ |
varchar2 |
Counterparty Relationship ID | |||
CUSTOMERSUPPLIERHISTORY_ |
decimal |
Counterparty Supplier Credit Limit | |||
CUSTOMERSUPPLIERHISTORY_ |
varchar2 |
Counterparty Tax Registration Identification | |||
CUSTOMERSUPPLIERHISTORY_ |
varchar2 |
Counterparty Tax Registration Country | |||
CUSTOMERSUPPLIERHISTORY_ |
varchar2 |
Counterparty Telephone | |||
CUSTOMERSUPPLIERHISTORY_ |
varchar2 |
Counterparty Website | |||
CUSTSUPGRPID |
varchar2 |
||||
CUSTSUPID |
varchar2 |
||||
CUSTSUPNAME |
varchar2 |
||||
CUSTSUPTP |
varchar2 |
||||
EMAIL |
varchar2 |
||||
FAX |
varchar2 |
||||
FILE_ |
varchar2 |
||||
FILE_ |
varchar2 |
||||
FISCAL_ |
datetime |
||||
FISCAL_ |
varchar2 |
||||
FISCAL_ |
datetime |
||||
INTERFACE_ |
varchar2 |
||||
PRODUCT_ |
varchar2 |
||||
PRODUCT_ |
varchar2 |
||||
RELATIONSHIPID |
varchar2 |
||||
SUPPLIERLIMIT |
decimal |
||||
TAXREGIDENT |
varchar2 |
||||
TAXREGISTRATIONCOUNTRY |
varchar2 |
||||
TELEPHONE |
varchar2 |
||||
WEBSITE |
varchar2 |