AffectedParties
Retrieve contract workspace affected parties.
View-Specific Information
Select
The add-in uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The add-in processes other filters client-side within the add-in.
- ContractId supports the '=' comparison operator.
SELECT * FROM AffectedParties WHERE ContractId = 'CW0001'
Columns
Name | Type | References | Description |
ContractId [KEY] | String |
Workspaces.ContractId | ID of the contract. |
SystemID [KEY] | String | The System ID of the affected party. | |
SmVendorID | String | A unique ID that SAP Ariba assigns automatically. | |
Name | String | The name of the affected party. | |
IsBlocked | Bool | Whether this record is blocked. | |
OrganizationIDs | String | The organization IDs for the affected party. | |
AddressName | String | Name associated with the address. | |
AddressUniqueName | String | Unique name associated with the address. | |
AddressPhone | String | Phone number associated with the address. | |
AddressFax | String | Fax number associated with the address. | |
AddressLines | String | Lines in the address. | |
AddressCity | String | City in the address. | |
AddressState | String | State in the address. | |
AddressCountry | String | Country in the address. | |
AddressPostalCode | String | Postal code in the address. |