AddComplianceData

This operation will add compliance data for a single supplier. If the supplier does not already have compliance data, the new data is created. If the supplier already has compliance data, it is updated.

Execute

This stored procedure includes a #TEMP table input. Below is an example execution.

The temporary table must be defined and used within the same connection. Closing the connection will clear out any temporary tables in memory.

INSERT INTO Evidences#TEMP (UniqueId, Source, Provider, PenaltyAmount, IsoCurrencyCode, Url, EffectiveStartDate, EffectiveEndDate, SupportingIndicatorStatus, Note) VALUES ('1', 'Test', 'providerName', '1000.5', 'USD', 'https://www.test.com', '2020-01-01', '2020-05-01', 'SANCTION', 'summary')
INSERT INTO Evidences#TEMP (UniqueId, Source, Provider, PenaltyAmount, IsoCurrencyCode, Url, EffectiveStartDate, EffectiveEndDate, SupportingIndicatorStatus, Note) VALUES ('2', 'example', 'anotherProvider', '750.25', 'EUR', 'https://www.test.com', '2021-03-15', '2021-08-15', 'WATCHLIST', 'description')

EXECUTE AddComplianceData
        SMVendorId               = 'S10666588',
        SanctionIndicatorStatus  = 'VIOLATION_FOUND',
        WatchlistIndicatorStatus = 'VIOLATION_NOT_FOUND',
        Note                     = 'Note.',
        Evidences                = 'Evidences#TEMP',

Evidences temporary table schema info:


Column Name	Type	Required	Description
UniqueId	string	False	An ID that you provide to uniquely identify the evidence data. This isn't a mandatory field. You only need to provide this ID if you want to have the ability to update it later.
Source	string	False	The source is the origin of the evidence about the supplier. An example is when there are multiple articles supporting the evidence about the supplier, only the most relevant source is shown. You can use the information in the source to find articles from other sources. The URL for a source must start with https or http.
Provider	string	False	The provider of the compliance data for the supplier. Your provider can have evidence data from multiple sources.
PenaltyAmount	decimal	False	The currency amount of any penalty applied to the supplier for the violation.
IsoCurrencyCode	string	False	The ISO 4217 currency code that represents the alphabetic currency for the penaltyAmount.
Url	string	False	The URL used to provide proof of the evidence. The URL is a clickable link. An example is a link to an article.
EffectiveStartDate	date	False	The date the compliance violation started.
EffectiveEndDate	date	False	The date the compliance violation ended.
SupportingIndicatorStatus	string	False	The fields from the risk configurations such as sanction and watchlist.
Note	string	False	Any note you add about the evidence of the supplier's violation. You can add a note of up to 3000 characters.

Input


Name	Type	Description
Realm	String	The requested realm.
SMVendorId	String	A unique ID that SAP Ariba assigns automatically.
SanctionIndicatorStatus	String	The status that tells you if a sanction was found for the supplier. 使用できる値は次のとおりです。VIOLATION_FOUND, VIOLATION_NOT_FOUND, VIOLATION_EXPIRED, NOT_SCREENED
WatchlistIndicatorStatus	String	The status that tells you if the supplier is on a watchlist. 使用できる値は次のとおりです。VIOLATION_FOUND, VIOLATION_NOT_FOUND, VIOLATION_EXPIRED, NOT_SCREENED
SupplierScreenedAt	Date	The date you screened the supplier for compliance data.
Note	String	Any note you add when you screen the supplier. You can add a note of up to 3000 characters.
Evidences	String	Evidence data.

Result Set Columns


Name	Type	Description
Success	String	Indicates whether or not the operation was successful.
Details	String	Any extra details on the operation's execution.

ADO.NET Provider for SAP Ariba Source

AddComplianceData

Execute

Evidences temporary table schema info:

Input

Result Set Columns