Power BI Connector for SAP Ariba Source

Build 24.0.9060

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 NameTypeRequired Description
UniqueId stringFalse 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 stringFalse 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 stringFalse The provider of the compliance data for the supplier. Your provider can have evidence data from multiple sources.
PenaltyAmount decimalFalse The currency amount of any penalty applied to the supplier for the violation.
IsoCurrencyCode stringFalse The ISO 4217 currency code that represents the alphabetic currency for the penaltyAmount.
Url stringFalse The URL used to provide proof of the evidence. The URL is a clickable link. An example is a link to an article.
EffectiveStartDate dateFalse The date the compliance violation started.
EffectiveEndDate dateFalse The date the compliance violation ended.
SupportingIndicatorStatus stringFalse The fields from the risk configurations such as sanction and watchlist.
Note stringFalse 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.

The allowed values are VIOLATION_FOUND, VIOLATION_NOT_FOUND, VIOLATION_EXPIRED, NOT_SCREENED.

WatchlistIndicatorStatus String The status that tells you if the supplier is on a watchlist.

The allowed values are 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060