Validation functions for SAP Reltio's velocity pack for Retail
Learn what validation functions are preconfigured in entity types for SAP Reltio's velocity pack for Retail.
SAP Reltio's velocity pack for Retail data model includes validation functions for some entity types. Use validation functions to ensure data accuracy and improve data quality by checking data ingested into the Reltio platform against a set of validation functions defined for an entity type and then report the correctness of the data.
For general information on validation functions, see topic Define Data Validation Functions. For details on the preconfigured entity types that come with SAP Reltio's velocity pack for Retail, see Entity types for SAP Reltio's velocity pack for Retail .
Individual entity type validation functions
This table identifies the SAP Reltio's velocity pack for Retail validation functions for the Individual entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| Consent.WithdrawalDate | A consent marked withdrawn also carries a withdrawal date. | Withdrawn Consent Without a Withdrawal Date |
| Consent.LegalBasis | Every consent purpose states a lawful basis for processing. | Consent Purpose Without a Legal Basis |
| Identifiers.Type | Every identifier value also states its identifier type. | Identifier Without a Type |
| SSN | The SSN is nine digits, with or without hyphens. | Invalid SSN Format |
| FirstName | The person record has a first name and a last name. | Missing First or Last Name |
| FirstName | Neither the first nor the last name contains a digit. | Name Contains Numbers |
| DoB | The date of birth is not earlier than 1 January 1920. | Suspicious Date of Birth |
| Consent.WithdrawalDate | Consent was not withdrawn before it was granted. | Consent Withdrawn Before It Was Granted |
Location entity type validation functions
This table identifies the SAP Reltio's velocity pack for Retail validation functions for the Location entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| Country | The address has a country. | Missing Country |
Organization entity type validation functions
This table identifies the SAP Reltio's velocity pack for Retail validation functions for the Organization entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| FinancialTerms.CreditLimitCurrency | Every credit limit amount is accompanied by a currency. | Credit Limit Without a Currency |
| DUNSNumber | The D-U-N-S Number is exactly nine digits. | Invalid D-U-N-S Number Format |
| GLN | The Global Location Number is exactly thirteen digits. | Invalid GLN Format |
| LEI | The Legal Entity Identifier is twenty alphanumeric characters. | Invalid LEI Format |
| VATNumber | The VAT number is two country letters followed by 2 to 13 alphanumerics. | Invalid VAT Number Format |
| Name | The organization name is longer than three characters. | Suspiciously Short Name |
LoyaltyProgram entity type validation functions
This table identifies the SAP Reltio's velocity pack for Retail validation functions for the LoyaltyProgram entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| EndDate | The loyalty program end date is not before its start date. | End Date Before Start Date |
| MembershipFeeCurrency | A membership fee amount is accompanied by a currency. | Membership Fee Without Currency |
Store entity type validation functions
This table identifies the SAP Reltio's velocity pack for Retail validation functions for the Store entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| DistributionChain | A distribution chain assignment ends after it starts. | Distribution Chain End Before Start |
| DistributionChain | A sales organisation assignment names its distribution channel. | Incomplete Distribution Chain |
| Territory.Region | A store with a district also has a region. | Incomplete Territory Hierarchy |
| CompanyCode | Every site states the company code it posts to. | Missing Company Code |
| DistributionChain | Every site states at least one sales organisation. | Missing Distribution Chain |
| StoreNumber | The store has a store number. | Missing Store Number |
| StoreType | The store has a store type. | Missing Store Type |
Product entity type validation functions
This table identifies the SAP Reltio's velocity pack for Retail validation functions for the Product entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| TradeCompliance | A dangerous goods classification includes its packing group. | Dangerous Goods Without Packing Group |
| GTIN | A generic article does not carry a GTIN. | Generic Article With GTIN |
| TradeCompliance | An article flagged hazardous carries a transport hazard class. | Hazardous Without Hazard Class |
| TradeCompliance | An article flagged hazardous carries a UN dangerous goods number. | Hazardous Without UN Number |
| CountryOfOrigin | Country of origin is a two-letter ISO country code. | Invalid Country of Origin |
| GTIN | The GTIN is 8, 12, 13, or 14 digits. | Invalid GTIN Format |
| PackagingIdentifiers | Packaging GTINs are 8, 12, 13 or 14 digits. | Invalid Packaging GTIN Format |
| TradeCompliance | UN numbers are four digits, optionally prefixed with UN. | Invalid UN Number Format |
| UPC | The UPC is exactly twelve digits. | Invalid UPC Format |
| TradeCompliance | A marketability decision names the market it applies to. | Marketability Status Without Country |
| ArticleType | Every article states whether it is Single, Generic, Variant, Structured or Reference. | Missing Article Type |
| SKU | The product has a SKU. | Missing SKU |
| UnitOfMeasure | The product has a unit of measure. | Missing Unit of Measure |
| PackagingIdentifiers | Every packaging barcode states the unit of measure it identifies. | Packaging GTIN Without Unit of Measure |
| PackagingIdentifiers | Every declared packaging level carries its barcode. | Packaging Unit of Measure Without GTIN |
| Pricing.Currency | Every price amount is accompanied by a currency. | Price Without a Currency |
| IsPricingReference | Only a variant article is flagged as the pricing reference. | Pricing Reference On Non-Variant |
| TradeCompliance | A safety data sheet version is accompanied by its issue date. | SDS Version Without Issue Date |
| VariantAxis | A variant article carries at least one characteristic value. | Variant Without Variant Axis |
Promotion entity type validation functions
This table identifies the SAP Reltio's velocity pack for Retail validation functions for the Promotion entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| Discount.Unit | Every discount value states whether it is a percentage or a currency amount. | Discount Without a Unit |
| PromotionType | The promotion has a promotion type. | Missing Promotion Type |
| EndDate | The promotion end date is not before its start date. | End Date Before Start Date |
Supplier entity type validation functions
This table identifies the SAP Reltio's velocity pack for Retail validation functions for the Supplier entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| DUNS | The supplier D-U-N-S Number is exactly nine digits. | Invalid D-U-N-S Number Format |
| GLN | The supplier Global Location Number is exactly thirteen digits. | Invalid GLN Format |
| OnboardingStatus | The supplier has an onboarding status. | Missing Onboarding Status |
| PaymentTerms | The supplier has payment terms. | Missing Payment Terms |
| SupplierName | The supplier has a name. | Missing Supplier Name |
| PerformanceScore | Vendor evaluation scores fall between 0 and 100. | Performance Score Out Of Range |
| PerformanceScore | A vendor evaluation score records when it was calculated. | Performance Score Without Evaluated Date |
RegulatoryDocument entity type validation functions
This table identifies the SAP Reltio's velocity pack for Retail validation functions for the RegulatoryDocument entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| ExpirationDate | The document does not expire before it takes effect. | Expiration Before Effective Date |
| IssuingAuthority | The regulatory document has an issuing authority. | Missing Issuing Authority |
| Jurisdiction | The regulatory document has a jurisdiction. | Missing Jurisdiction |
Warranty entity type validation functions
This table identifies the SAP Reltio's velocity pack for Retail validation functions for the Warranty entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| CoverageType | The warranty has a coverage type. | Missing Coverage Type |
| SerialNumber | The warranty has a serial number. | Missing Serial Number |
| WarrantyId | The warranty has a warranty identifier. | Missing Warranty ID |
| EndDate | The warranty end date is not before its start date. | End Date Before Start Date |
Campaign entity type validation functions
This table identifies the SAP Reltio's velocity pack for Retail validation functions for the Campaign entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| BudgetCurrency | A campaign budget amount is accompanied by a currency. | Budget Without Currency |
| EndDate | The campaign end date is not before its start date. | End Date Before Start Date |
| CampaignId | The campaign has a campaign identifier. | Missing Campaign ID |
| TargetSegment | The campaign has a target segment. | Missing Target Segment |
ProductCategory entity type validation functions
This table identifies the SAP Reltio's velocity pack for Retail validation functions for the ProductCategory entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| CategoryID | Every category node carries its identifier. | Missing Category ID |
| Name | Every category node carries a name. | Missing Category Name |
| HierarchyLevel | Every category node states its depth in the hierarchy. | Missing Hierarchy Level |
| SAPCategoryCode | Every category node carries the source merchandise category code. | Missing SAP Category Code |
StoreStocksProduct relationship type validation functions
This table identifies the SAP Reltio's velocity pack for Retail validation functions for the StoreStocksProduct relationship type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| ListingEndDate | A listing ends after it starts. | Listing End Before Start |
| MRPType | Reorder point planning is accompanied by a reorder point. | Reorder Point Planning Without Reorder Point |
| GRProcessingDays | Goods receipt processing time is not negative. | Negative Goods Receipt Processing Days |
| MinOrderQty | Minimum order quantity is not negative. | Negative Minimum Order Quantity |
| ReorderPoint | The reorder point sits at or above safety stock. | Reorder Point Below Safety Stock |
ProducttoProduct relationship type validation functions
This table identifies the SAP Reltio's velocity pack for Retail validation functions for the ProducttoProduct relationship type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| ComponentQuantity | A structured article component states its quantity. | Component Without Quantity |
| VariantType | Every product-to-product link states its nature. | Missing Variant Type |
PromotionValidAtStore relationship type validation functions
This table identifies the SAP Reltio's velocity pack for Retail validation functions for the PromotionValidAtStore relationship type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| StoreEndDate | The store-level promotion window does not end before it starts. | Store Promotion Window Ends Before It Starts |
SupplierSuppliesProduct relationship type validation functions
This table identifies the SAP Reltio's velocity pack for Retail validation functions for the SupplierSuppliesProduct relationship type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| ContractedPriceCurrency | Every contracted price is accompanied by a currency. | Contracted Price Without a Currency |
| LeadTimeDays | Lead time is between 0 and 365 days. | Implausible Lead Time |
| MinOrderQty | A contracted minimum order quantity is at least one unit. | Minimum Order Quantity Not Positive |
CategorytoCategory relationship type validation functions
This table identifies the SAP Reltio's velocity pack for Retail validation functions for the CategorytoCategory relationship type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| EndDate | A hierarchy link ends after it starts. | Category Link End Before Start |
CategorytoProduct relationship type validation functions
This table identifies the SAP Reltio's velocity pack for Retail validation functions for the CategorytoProduct relationship type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| EndDate | A category assignment ends after it starts. | Category Assignment End Before Start |
| CategoryPath | Every category assignment carries the resolved hierarchy path. | Missing Category Path |