You can create custom label fields and associate them with label formats. This enables you to have additional control over the values that are listed on a label. You can write a custom SQL statement to create the custom label field. For example, if you have a requirement to show the carrier PRO number, and the system does not seed this field, then you can write a custom SQL statement that creates this field. For more information about creating the custom SQL statement and SQL restrictions see Custom Label Fields in the Oracle Warehouse Management Implementation Guide.
The custom label field that you create appears in the Define Label Fields window along with the seeded values. You should restrict this window from certain responsibilities; only users with knowledge of SQL should have access to this window. You can use any field that you create on this window in a label. To define custom label fields:
Navigate to the Define Custom Labels window.
Select the label type. This associates the fields with the appropriate label type.
Enter the field name, description, and SQL query statement.
Save your work.