Validation functions for SAP Reltio's velocity pack for Mill Products & Mining
Learn what validation functions are preconfigured in entity types for SAP Reltio's velocity pack for Mill Products & Mining.
The SAP Reltio's velocity pack for Mill Products & Mining 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 Define Data Validation Functions. For details on the preconfigured entity types that come with SAP Reltio's velocity pack for Mill Products & Mining, see Entity types for SAP Reltio's velocity pack for Mill Products & Mining.
Organization entity type validation functions
This table identifies the SAP Reltio's velocity pack for Mill Products & Mining validation functions for the Organization entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| creditLimitCurrency | Reports an invalid format if creditLimitCurrency doesn't match the criteria ^[A-Z]{3}$. | Must be a 3-letter ISO 4217 code |
| dunsNumber | Reports an invalid format if dunsNumber doesn't match the criteria ^[0-9]{9}$. | DUNS number must be 9 numeric digits |
| gln | Reports an invalid format if gln doesn't match the criteria ^[0-9]{13}$. | GLN must be 13 numeric digits (GS1) |
| lei | Reports an invalid format if lei doesn't match the criteria ^[A-Z0-9]{20}$. | LEI must be 20 uppercase alphanumeric characters |
| Reports an invalid format if Email doesn't match the criteria ^[^@\s]+@[^@\s]+\.[^@\s]+$. | Email address must be valid | |
| Number | Reports an invalid format if Number doesn't match the criteria ^\+?[0-9][0-9\s\-()]{6,24}$. | Phone number must be valid |
| taxNumber | Reports an invalid format if taxNumber doesn't match the criteria ^[A-Za-z0-9 ./-]{4,32}$. | Tax Registration Number contains invalid characters |
| countryOfRegistration | Reports a missing value if countryOfRegistration is not provided. | Country of Registration is required |
| Name | Reports a missing value if Name is not provided. | Organization Name is required |
| creditLimit | Reports an invalid value for creditLimit. | Credit Limit must be non-negative |
| Name | Reports an invalid format if Name doesn't match the criteria ^.{1,3}$. | Suspiciously Short Name |
Supplier entity type validation functions
This table identifies the SAP Reltio's velocity pack for Mill Products & Mining validation functions for the Supplier entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| dunsNumber | Reports an invalid format if dunsNumber doesn't match the criteria ^[0-9]{9}$. | DUNS number must be 9 numeric digits |
| gln | Reports an invalid format if gln doesn't match the criteria ^[0-9]{13}$. | GLN must be 13 numeric digits (GS1) |
| lei | Reports an invalid format if lei doesn't match the criteria ^[A-Z0-9]{20}$. | LEI must be 20 uppercase alphanumeric characters |
| orderCurrency | Reports an invalid format if orderCurrency doesn't match the criteria ^[A-Z]{3}$. | Must be a 3-letter ISO 4217 code |
| Reports an invalid format if Email doesn't match the criteria ^[^@\s]+@[^@\s]+\.[^@\s]+$. | Email address must be valid | |
| Number | Reports an invalid format if Number doesn't match the criteria ^\+?[0-9][0-9\s\-()]{6,24}$. | Phone number must be valid |
| taxNumber | Reports an invalid format if taxNumber doesn't match the criteria ^[A-Za-z0-9 ./-]{4,32}$. | Tax Registration Number contains invalid characters |
| countryOfRegistration | Reports a missing value if countryOfRegistration is not provided. | Country of Registration is required |
| Name | Reports a missing value if Name is not provided. | Supplier Name is required |
Individual entity type validation functions
This table identifies the SAP Reltio's velocity pack for Mill Products & Mining validation functions for the Individual entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| FirstName | Reports an invalid format if FirstName doesn't match the criteria .*[0-9].*. | First Name Contains Numbers |
| Reports an invalid format if Email doesn't match the criteria ^[^@\s]+@[^@\s]+\.[^@\s]+$. | Email address must be valid | |
| Number | Reports an invalid format if Number doesn't match the criteria ^\+?[0-9][0-9\s\-()]{6,24}$. | Phone number must be valid |
| LastName | Reports an invalid format if LastName doesn't match the criteria .*[0-9].*. | Last Name Contains Numbers |
| FirstName | Reports a missing value if FirstName is not provided. | First Name is required |
| LastName | Reports a missing value if LastName is not provided. | Last Name is required |
| DoB | Reports an invalid value for DoB. | Suspicious Date of Birth |
CommunityGroup entity type validation functions
This table identifies the SAP Reltio's velocity pack for Mill Products & Mining validation functions for the CommunityGroup entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| Name | Reports a missing value if Name is not provided. | Community Name is required |
Location entity type validation functions
This table identifies the SAP Reltio's velocity pack for Mill Products & Mining validation functions for the Location entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| gln | Reports an invalid format if gln doesn't match the criteria ^[0-9]{13}$. | GLN must be 13 numeric digits (GS1) |
| GeoLocation | Reports an invalid date order for GeoLocation based on the configured rule. | Latitude must be between -90 and 90 |
| GeoLocation | Reports an invalid date order for GeoLocation based on the configured rule. | Longitude must be between -180 and 180 |
| AddressLine1 | Reports a missing value if AddressLine1 is not provided. | Address Line 1 is required |
| City | Reports a missing value if City is not provided. | City is required |
| Country | Reports a missing value if Country is not provided. | Country is required |
| VerificationStatus | Reports an invalid value for VerificationStatus. | Address verification is unverified or failed |
ForestRight entity type validation functions
This table identifies the SAP Reltio's velocity pack for Mill Products & Mining validation functions for the ForestRight entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| expiryDate | Reports an invalid value for expiryDate. | Expiry Date must be on or after Grant Date |
| jurisdiction | Reports a missing value if jurisdiction is not provided. | Forest Right Jurisdiction is required |
| rightNumber | Reports a missing value if rightNumber is not provided. | Forest Right Number is required |
| areaHectares | Reports an invalid value for areaHectares. | Area (hectares) must be non-negative |
Tenement entity type validation functions
This table identifies the SAP Reltio's velocity pack for Mill Products & Mining validation functions for the Tenement entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| expenditureCurrency | Reports an invalid format if expenditureCurrency doesn't match the criteria ^[A-Z]{3}$. | Must be a 3-letter ISO 4217 code |
| jurisdiction | Reports a missing value if jurisdiction is not provided. | Jurisdiction is required |
| tenementNumber | Reports a missing value if tenementNumber is not provided. | Tenement Number is required |
| areaHectares | Reports an invalid value for areaHectares. | Area (hectares) must be non-negative |
| expiryDate | Reports an invalid value for expiryDate. | Expiry Date must be on or after Grant Date |
LandParcel entity type validation functions
This table identifies the SAP Reltio's velocity pack for Mill Products & Mining validation functions for the LandParcel entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| parcelIdentifier | Reports a missing value if parcelIdentifier is not provided. | Parcel Identifier is required |
| jurisdiction | Reports a missing value if jurisdiction is not provided. | Jurisdiction is required |
| areaHectares | Reports an invalid value for areaHectares. | Area (hectares) must be non-negative |
OreBodyDeposit entity type validation functions
This table identifies the SAP Reltio's velocity pack for Mill Products & Mining validation functions for the OreBodyDeposit entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| GeoLocation | Reports an invalid date order for GeoLocation based on the configured rule. | Deposit Latitude must be between -90 and 90 |
| GeoLocation | Reports an invalid date order for GeoLocation based on the configured rule. | Deposit Longitude must be between -180 and 180 |
| depositCode | Reports a missing value if depositCode is not provided. | Deposit Code is required |
| depositName | Reports a missing value if depositName is not provided. | Deposit Name is required |
Site entity type validation functions
This table identifies the SAP Reltio's velocity pack for Mill Products & Mining validation functions for the Site entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| gln | Reports an invalid format if gln doesn't match the criteria ^[0-9]{13}$. | GLN must be 13 numeric digits (GS1) |
| siteCode | Reports a missing value if siteCode is not provided. | Site Code is required |
| siteName | Reports a missing value if siteName is not provided. | Site Name is required |
| decommissioningDate | Reports an invalid value for decommissioningDate. | Decommissioning Date must be on or after Commissioning Date |
Material entity type validation functions
This table identifies the SAP Reltio's velocity pack for Mill Products & Mining validation functions for the Material entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| materialNumber | Reports an invalid format if materialNumber doesn't match the criteria ^[A-Za-z0-9]{1,40}$. | Material number must be 1–40 alphanumeric characters |
| materialDiscontinuationDate | Reports an invalid value for materialDiscontinuationDate. | Discontinuation Date must be on or after Valid From |
| baseUnitOfMeasure | Reports a missing value if baseUnitOfMeasure is not provided. | Base Unit of Measure is required |
| millProductSegment | Reports a missing value if millProductSegment is not provided. | Mill Products Segment should be populated on Material |
| materialNumber | Reports a missing value if materialNumber is not provided. | Material Number is required |
| shortDescription | Reports a missing value if shortDescription is not provided. | Short description is required |
| materialType | Reports a missing value if materialType is not provided. | Material Type is required |
| grossWeight | Reports an invalid value for grossWeight. | Gross Weight must be non-negative |
| netWeight | Reports an invalid value for netWeight. | Net Weight must be non-negative |
| totalShelfLifeDays | Reports an invalid value for totalShelfLifeDays. | Total Shelf Life must be non-negative |
TradeItem entity type validation functions
This table identifies the SAP Reltio's velocity pack for Mill Products & Mining validation functions for the TradeItem entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| brandOwnerGln | Reports an invalid format if brandOwnerGln doesn't match the criteria ^[0-9]{13}$. | GLN must be 13 numeric digits (GS1) |
| gtin | Reports an invalid format if gtin doesn't match the criteria ^([0-9]{8}|[0-9]{12}|[0-9]{13}|[0-9]{14})$. | GTIN must be 8, 12, 13, or 14 numeric digits (GS1) |
| tradeItemDescription | Reports a missing value if tradeItemDescription is not provided. | Trade Item Description is required |
| tradeItemId | Reports a missing value if tradeItemId is not provided. | Trade Item ID is required |
| discontinuationDate | Reports an invalid value for discontinuationDate. | Discontinuation date is set but lifecycle status is missing |
MaterialLot entity type validation functions
This table identifies the SAP Reltio's velocity pack for Mill Products & Mining validation functions for the MaterialLot entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| expiryDate | Reports an invalid value for expiryDate. | Lot expiry date must be on or after production date |
| materialNumber | Reports a missing value if materialNumber is not provided. | Material Number is required on MaterialLot |
| millProductSegment | Reports a missing value if millProductSegment is not provided. | Mill Products Segment should be populated on MaterialLot |
| lotNumber | Reports a missing value if lotNumber is not provided. | Lot Number is required |
| plantCode | Reports a missing value if plantCode is not provided. | ERP Site / Plant Code or Site Code is required on MaterialLot |
| lotRole | Reports a missing value if lotRole is not provided. | Lot Role is required |
| quantity | Reports an invalid value for quantity. | Quantity must be non-negative |
| millCertificateNumber | Reports an invalid value for millCertificateNumber. | Produced metals lots should have a mill certificate number |
Agreement entity type validation functions
This table identifies the SAP Reltio's velocity pack for Mill Products & Mining validation functions for the Agreement entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| expiryDate | Reports an invalid value for expiryDate. | Expiry Date must be on or after Effective Date |
| terminationDate | Reports an invalid value for terminationDate. | Termination Date must be on or after Effective Date |
| currency | Reports an invalid format if currency doesn't match the criteria ^[A-Z]{3}$. | Must be a 3-letter ISO 4217 code |
| agreementNumber | Reports a missing value if agreementNumber is not provided. | Agreement Number is required |
| agreementType | Reports a missing value if agreementType is not provided. | Agreement Type is required |
| royaltyRate | Reports an invalid value for royaltyRate. | Royalty Rate must be non-negative |
| volumeCommitment | Reports an invalid value for volumeCommitment. | Volume Commitment must be non-negative |
RegulatoryAuthority entity type validation functions
This table identifies the SAP Reltio's velocity pack for Mill Products & Mining validation functions for the RegulatoryAuthority entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| internalRegRef | Reports a missing value if internalRegRef is not provided. | Authority Internal Reference is required |
| jurisdictionScope | Reports a missing value if jurisdictionScope is not provided. | Jurisdiction Scope is required |
| authorityName | Reports a missing value if authorityName is not provided. | Authority Name is required |
| regulatoryDomain | Reports a missing value if regulatoryDomain is not provided. | Regulatory Domain is required |
| authorityType | Reports a missing value if authorityType is not provided. | Authority Type is required |
| officialAuthorityId | Reports a missing value if officialAuthorityId is not provided. | Official Authority ID is required |
RegulatoryDocument entity type validation functions
This table identifies the SAP Reltio's velocity pack for Mill Products & Mining validation functions for the RegulatoryDocument entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| regulationId | Reports a missing value if regulationId is not provided. | Regulation ID is required |
| shortTitle | Reports a missing value if shortTitle is not provided. | Short Title is required |
| effectiveDate | Reports a missing value if effectiveDate is not provided. | Regulatory Document Effective Date is required |
| jurisdiction | Reports a missing value if jurisdiction is not provided. | Regulatory Document Jurisdiction is required |
| documentType | Reports a missing value if documentType is not provided. | Regulatory Document Type is required |
| enforcementDate | Reports an invalid value for enforcementDate. | Enforcement date must be on or after effective date |
ComplianceObligation entity type validation functions
This table identifies the SAP Reltio's velocity pack for Mill Products & Mining validation functions for the ComplianceObligation entity type.
| Attribute to validate | Description | Validation warning message |
|---|---|---|
| obligationCode | Reports a missing value if obligationCode is not provided. | Obligation Code is required |
| obligationId | Reports a missing value if obligationId is not provided. | Obligation ID is required |
| obligationName | Reports a missing value if obligationName is not provided. | Obligation Name is required |
| regulatoryDocumentRef | Reports a missing value if regulatoryDocumentRef is not provided. | Regulatory Document is required |
| regulatoryDomain | Reports a missing value if regulatoryDomain is not provided. | Regulatory Domain is required |
| obligationType | Reports a missing value if obligationType is not provided. | Obligation Type is required |