Laddawn.com : Programming Spec - DB - Assign Label Descriptions

Created by User c0361, last modified on Mar 19, 2014

Purpose:

This program will build the Laddawn UPLR Compliant Product Description that currently prints only on Brandit labels from Clippership.

Overview:

Last year we changed the Laddawn description on our Brandit labels to meet UPLR standards. The web will now display these same UPLR descriptions when displaying Laddawn items on the Save Items page and the Brandit Label pages in Checkout. The change will allow the customer to see exactly what will print on the Brandit label and applies to both stock and MOD items.

NOTE:  It may help to read the design for the UPLR changes done last year (see lad-des-UPLR-LabelCompliance) to gain a global understanding of UPLR. 

Modify Web program:  LD.INCLUDES PRODUCTITEM.READ

Modify the global program PRODUCTITEM.READ to build an array of product information needed to build the label descriptions.

Label Array (1) = Generic Name

Label Array (2)  = Width (DIM1)

Label Array (3) = Width UOM (Dim1UOM) * calculated

Label Array (4) = Depth (DIM2)

Label Array (5) = Depth UOM (Dim2UOM) * calculated

Label Array (6)  =  Length (DIM3)

Label Array (7) = Length UOM (Dim3UOM) * calculated

Label Array (8) = Gauge (DIM4)

Label Array (9) = Gauge UOM (Dim4UOM) ** calculated

Label Array (9) = Pack Out

Label Array (10) = Pack Out (continuous roll flag) - set to ' if continuous

Label Array (11) = Pack Out UOM  (CS/RL case/roll, ie 500'/RL)

Label Array (12) = Volume

Label Array (13) = Weight

MOD variables

GENERIC.NAME, SHOP.WIDTH,  SHOP.DEPTH,  SHOP.LENGTH, SHOP.GAUGE, GAUGE.UOM, SHOP.PACKOUT

Stock variables

GENERIC.NAME, PRODUCTITEM.REC<117>,  PRODUCTITEM.REC<118>, PRODUCTITEM.REC<119>, PRODUCTITEM.REC<123>, GAUGE.UOM, SHOP.PACKOUT

To calculate the dimention UOM.,,

        • * DimUOM's (1,2 and 3) - assume "in" (inches) unless...
          • if ITMMST<8> = " (double quote) then DIM3UOM = "ft"
          • if ITMMST <8> = ' (single quote) then DIM1UOM and DIM3UOM = 'ft'
        • ** Dim4UOM = If ITMMST<12> = 'HDL' then 'mic' ELSE 'mil'

 Packout Continuous flag is in flied <15> of the CATALOG.CD.USR, if 1 then set to ' (for foot), use product type for key to that file 

The volume is calculated based on closure type of 1 2 or 3

  • 1 =  Open (bag, furn, sleeve)
  • 2 = Recloseable (ziptops)
  • 3 = None (sheeting, tubing, pkg, NS Buy)

Closure type = ITEMMST.USR<8>

For MOD items,  use quote number to get the config part CPN QUDET<1> (ie BAGS, FURN etc), if there is no quote number then you can get it from any quote that is associated with that MOD item (MOD.ITMMST.USR <7> any quote)  and read closure type from ITEMMST.USR<8>

The calculations for CUBIC.INCHES and VOLUME UOM  can be found in BP SOPS4007.2, they should be done the same way here (look at 1930 to 1942).  I believe this is all you will need but let me know if not.

Call BP - WEB.ASSIGN.LABELDESC(INPUT ARRAY, LABEL.DESC1,LABEL.DESC2)

Create a subroutine (WEB.ASSIGN.LABELDESC) to build 2 lines of label descriptions. This should be a stand alone program called from LD.INCLUDES PRODUCTITEM.READ which will pass the 2 lines of label description back to the calling program in variables LABEL.DESC1 and LABEL.DESC2. 

Label Desc1

The format of LABEL.DESC1 (UPLR Description line 1) is:

BAGS 30in X 28in X 36in (76.2cm X 70.4cm X 91.4cm) 1.5mil

Generic Name : Widith: Width UOM : X : Depth: Depth UOM : X : Length: Length UOM : X : (metric conversion) : Gauge: Gauge UOM

    • If GenericName is null or empty then set LABEL.DESC1 to Item Master Desc1 and LABEL.DESC2 to Item Master Desc2
    • If either Dim1, 2 or 3 is empty then don’t show that dimension and unit of measure at all.
    • Conversion: First convert each dimension (in.2.54 or ft. 30.48) to cm. After that, any dimension > 100cm (greater than 1 meter) convert to meters (divide by 100 and change uom from cm to m). If a dimension is blank then its conversion will not show either.
    •  Label Desc 2

The format of LABEL.DESC2 (UPLR Description line 1) is:

250/CS 22.3gal (84.5l) 24.3lbs (11kg)

Pack Out : / : Packout UOM : Volume: (metric volume) : Weight : (metric weight)

            • Conversions:
              • Weight will always be in lbs in avante, convert to kg. (0.453592).
              • Volume will always be in cubic inches in avante, convert to ml. (16.3871).
              • If necessary up-convert to liters (divide by 1000 change ml to l).
              • Also, up-convert volume from cubic inches to gallons (0.004329) if volume is >= 231 (231 ci in a gal) or to oz (0.554113) if < 231