Product Code Validation Rules
Data quality rules that can be used specifically to validate product code specific norms.
Validate_GTIN
General description
Validates any given GTIN8, GTIN12, GTIN13 or GTIN14 number including length, check sum, etc.
Input ports
|
In_Field_Value |
Any data field with a GTIN. |
Output ports
|
Out_Status_Code |
Returns the overall Status Code after the rule execution (OK or Failed). (QualityStatusEntry.Status) |
|
Out_Status_Message |
Returns the overall Status Message after the rule execution. (QualityStatusEntry.Message) |
Meta data and reference tables
|
Error_messages_by_Language |
Contains a 4 digit error code plus a language to indicate the preferred error message to be output. |
Example usage
Check if the GTIN (In_Field_Value) of an item is valid and consistent.
Example output
|
Status_Code |
Failed |
|
Status_Message |
GTIN / EAN value is not valid. |
Validate_UPC
General description
Validates any given Universal Product Code (UPC) number.
Input ports
|
Field_Value |
Any data field with a UPC. |
Output ports
|
Status_Code |
Returns the overall Status Code after the rule execution (OK or Failed). (QualityStatusEntry.Status) |
|
Status_Message |
Returns the overall Status Message after the rule execution. (QualityStatusEntry.Message) |
Meta data and reference tables
|
Error_messages_by_Language |
Contains a 4 digit error code plus a language to indicate the preferred error message to be output. |
Example usage
Check if the UPC (Field_Value) of an item is valid and consistent.
Example output
|
Status_Code |
Failed |
|
Status_Message |
UPC value is not valid. |