Calculated fields

Calculated fields are created from other data fields. The tables that contain calculated fields start with xx*. The fields are calculated if the xx table is retrieved for the label type. For example, the xxbinmst.bin_num_formatted field is available and calculated if the binmst table is retrieved for the label type.

This list shows the tables that contain calculated fields:

  • Binmst (xxbinmst)

    • bin_num_formatted: Formatted binmst.bin_num field that is based on System Parameter 2702.
    • prim_pick_type_string: Description of binmst.prim_pick_type instead of a single character. For example, S = Split, F = Full, C = Counter, P = Pallet, else = Unknown.
    • loc_type_string: Description of binmst.loc_type instead of a single character. For example, T = Stage, S = Shelf, P = Pallet, F = Flow Rack, B = Bulk, else = Unknown.

  • Item (xxitem)

    These formatted bin fields are based on System Parameter 2702:

    • bin_num_counter and bin_num_counter_formatted: Counter primary pick location for the item.
    • bin_num_full and bin_num_full_formatted: Full primary pick location for the item.
    • bin_num_pallet and bin_num_pallet_formatted: Pallet primary pick location for the item.
    • bin_num_split and bin_num_split_formatted: Split primary pick location for the item.

  • ordhdr (xxordhdr)

    When an address line does not contain a value, it is not shown as a blank line on the label. Instead, the subsequent lines are moved up. For example, if the address line C does not contains a value, address line D is printed in the address line C position on the label.

    When you use an address_line_E_*_always field, the country is always displayed even if it matches the SASC country. Otherwise, the country is not displayed if the country matches the SASC country.

    • address_line_A and address_line_A_uppercase
    • address_line_B and address_line_B_uppercase
    • address_line_C and address_line_C_uppercase
    • address_line_D and address_line_D_uppercase
    • address_line_E_country and address_line_E_country_uppercase
    • address_line_E_country_always and address_line_E_country_uppercase_always
    • carrier_service: ordhdr.carrier
    • order_number_and_suffix: Order and suffix with a dash to separate the values. For example, o123123123-01.
    • ship_city_state_zip: City, state and zip code on one line. For example, City, ST 99999.
    • ship_city_state: city and state on one line. For example, City, ST.
    • line_count: Count of all lines on the order in TWL.
    • item_count: Sum of requested quantity on all lines on the order in TWL
    • pick_count: Number of picks for the order.
    • pick_zone_aisles: List of zones/aisles for existing picks.
    • scm_prod: Shipping Container Marking (SCM) product, based on carton and customer (ARSC) data. It can be a combination of values.
    • scm_desc: SCM descriptions, based on carton and product (ICSP) data.
    • scm_upc: SCM UPC, based on carton, product (ICSP), warehouse product (ICSW), and UPC number (ICSV) data.
    • scm_qty: SCM quantity, based on carton quantity.
    • wttierush_or_custpo: Tied order with rush indicator if a warehouse transfer, otherwise the customer purchase order.

  • whmst (xxwhmst)

    When an address line does not contain a value, it is not shown as a blank line on the label. Instead, the subsequent lines are moved up. For example, if the address line C does not contains a value, address line D is printed in the address line C position on the label.

    When you use an address_line_E_*_always field, the country is always displayed even if it matches the SASC country. Otherwise, the country is not displayed if the country matches the SASC country.

    • address_line_A and address_line_A_uppercase
    • address_line_B and address_line_B_uppercase
    • address_line_C and address_line_C_uppercase
    • address_line_D and address_line_D_uppercase
    • address_line_E_country and address_line_E_country_uppercase
    • address_line_E_country_always and address_line_E_country_uppercase_always
    • ship_city_state_zip: City, state and zip code on one line. For example, City, ST 99999.
    • ship_city_state: city and state on one line. For example, City, ST.