Creating a trade item template

Each Trade Item Template contains 56 standard fields in the Validation tab provided by the @DFLT. When you create a new trade item template and add a new field in the Validation tab, the new field is considered a non-standard field.

  1. Open the Trade Item Template form.
  2. Click Create New Object.
  3. Specify this information in the Main tab:
    Description
    Specify the description for the Trade Item Template.
    Source Symbol
    Select the source symbol. The choices are:
    • Label Content
    • Formula
    • Item
    • Specification
    Calculated
    Optional. Use this to specify a script that is generally applicable to the whole template when used to create a Trade Item. For very complex sourcing requirements, this can improve performance over having separate field specific calculates equation scripts. Select an equation to associate with the Trade Item Template.
  4. Specify this information in the Validation tab:
    Tooltip
    Provides information to you when working with the Trade Item fields. Click Tooltip Translation to open the dialog box. Enter the tooltip text for the desired languages for the caption.
    Caption
    Specify the description of the GDSN attribute.
    GDSN Attribute
    Displays the primary tag for the XML and API that will be exported to the data pool. Click Language Translations to open the dialog box. Enter the language labels for the caption. You will see the captions and tooltips in labels when their browsers are set to the language pack options.
    Source Symbol
    For a field that you want to default from the Source Object, select a Source Symbol. For a field that you want to be calculated using an equation, select Source Symbol: Calculated. Source Symbol fields require listing in the Enumerated Lists C_GS1_SOURCEFIELD<OBJECT>.
    Source Field
    For a field that you want to default from the Source Object, select the Source Field. For a field that you want to be calculated using an equation, select an equation for the Source Field. Source Fields are defined in Enumerated Lists C_GS1SOURCEFIELDItem, Formula, Specification, and Label Content. See Sourcing trade item information for more details.
    Data Type

    Select the type of data the column stores.

    The choices are integer, long, double, date and string.

    Length

    Enter the total number of characters the column can accept and store. The length of numbers and dates is determined by the data type. Once a template is used the length cannot be reduced.

    For multi-value (multiple) value fields, the data length is restricted to 70 characters.

    Read Only
    This column indicates whether you can edit the field.
    • Select False to allow users to enter data for the custom field.
    • Select Read Only to allow users to only view data.
    Required

    Indicate whether the field must have a value prior to saving the object.

    The choices are Required and Not Required.

    Multi Lang Source
    For fields that do not need multi-language support, select Non multi-language field. Select these choices if multi-language support is needed:
    • Multi Language Field (Load Language Code from LANGUAGE table): Language Translations dialog in the Trade Item will display the list of languages from the Language table.
    • Multi language field (Load Language Code from enum list C_LABELLANGUAGE): Language Translations dialog in the Trade Item will display the list of languages from the C_LANGUAGELABEL enum list.

    Use the multi-language function to store language text for reporting.

    Sourced data that has multi-language values, such as handling instructions from label content, will automatically copy all languages from the source to the trade item.

    Set Ind
    Defines a validated type:
    • None
    • Minmax
    • Composite - When you select Composite, you can create a child field with a parent field. You must create and save the parent field first. Then a child field is displayed under the parent field and you can specify the values for the child field. You cannot create multiple children for a parent field, or create a child field for another child field. Use Composite when associating UOM to Area-type fields.
    • Enum Query - SQL Query
    • Enum Val List - Optiva or custom enumerated list
    • Lookup Code - Lookup
    Set Style
    Select a set style for the field:
    • None
    • Lookup
    • Droplist
    • Date
    • Check box
    • Multi-value lookup
    • Multi-value droplist
    • Lazy-load droplist
    • Grid
    Select Grid to create a code list in the Trade Item where you can present allergen information. The Grid set style is defined as a lookup. You must specify Lookup Code in the Set Ind column and specify a lookup in the Set Ind Code droplist to use the Grid set style.
    For enhanced performance, select Lazy-load droplist. Lazy-load droplist loads a specific list of values that loads in the Enumerated List instead of the entire list of values. Set style Lazy-load droplist can either have enum query or enum value list for the Set Ind.
    Set Ind Code
    Select a set ind code. Set ind code choices depend on the Set Ind value. For example, if Set Ind = Enum Query, then Set Ind code will display a list of enum queries. If Set Ind = Enum Val list, then Ind Set Code will display a list of enum lists. If Set Ind = Lookup Code, then Set Ind Code will display a list of lookups.
    Min Val
    If the Set Ind column entry is min max, this is the minimum allowable value for this column.
    Max Val
    If the Set Ind column entry is min max, this is the maximum allowable value for this column.
    Format Code
    Use the Format Code to format numeric values and date formats. For numeric values, use # for the number of places and 0 for the leading or trailing zeros.
  5. Click Save.
    Note: Once a Trade Item Template column has data from a Trade Item that used the template, the column is no longer editable in the Trade Item Template form, except for caption/tooltips, format/min/max. Once a Trade Item Template is used for by the Trade Item, it cannot be deleted. Standard fields cannot be deleted from the Trade Item Template.
    Note: None of the column behaviors are specific to standard or non- standard fields.