Difference between revisions of "Reference for Labels For Catchweight Station"

From coolearthwiki
Jump to: navigation, search
(Created page with "== Label Setup - Catchweight Station == === Label Variables === *<b>Variable:</b> <b><i>GTIN</i></b> : <i>Description:</i> The GTIN for the item. GTIN is initially built fr...")
 
 
(2 intermediate revisions by the same user not shown)
Line 48: Line 48:
  
 
*<b>Variable:</b> <b><i>CustomerAddress1</i></b>
 
*<b>Variable:</b> <b><i>CustomerAddress1</i></b>
: <i>Description:</i> Address from order customer.
+
: <i>Description:</i> Address line 1 + Address Line 2 from order shipTo. (Deprecated - use the ShipTo*)
  
 
*<b>Variable:</b> <b><i>CustomerAddress2</i></b>
 
*<b>Variable:</b> <b><i>CustomerAddress2</i></b>
: <i>Description:</i> Address 2 from order customer.
+
: <i>Description:</i> City, State, Postal from shipto.  (Deprecated - use the ShipTo*)
 +
 
 +
*<b>Variable:</b> <b><i>CustomerAddress3</i></b>
 +
: <i>Description:</i> Address 3 from order customer shipto. (Deprecated - use the ShipTo*)
  
 
*<b>Variable:</b> <b><i>CustomerItem</i></b>
 
*<b>Variable:</b> <b><i>CustomerItem</i></b>
 
: <i>Description:</i> The customer item code from the customer item table.
 
: <i>Description:</i> The customer item code from the customer item table.
 +
 +
*<b>Variable:</b> <b><i>ShipToAddress1</i></b>
 +
: <i>Description:</i> Ship To block from Order.
 +
 +
*<b>Variable:</b> <b><i>ShipToAddress2</i></b>
 +
: <i>Description:</i> Ship To block from Order.
 +
 +
*<b>Variable:</b> <b><i>ShipToAddress3</i></b>
 +
: <i>Description:</i> Ship To block from Order.
 +
 +
*<b>Variable:</b> <b><i>ShipToCity</i></b>
 +
: <i>Description:</i> Ship To block from Order.
 +
 +
*<b>Variable:</b> <b><i>ShipToState</i></b>
 +
: <i>Description:</i> Ship To block from Order.
 +
 +
*<b>Variable:</b> <b><i>ShipToPostal</i></b>
 +
: <i>Description:</i> Ship To block from Order.
 +
 +
*<b>Variable:</b> <b><i>ShipToCountry</i></b>
 +
: <i>Description:</i> Ship To block from Order.
  
 
*<b>Variable:</b> <b><i>CustomerItemHeading</i></b>
 
*<b>Variable:</b> <b><i>CustomerItemHeading</i></b>
Line 151: Line 175:
 
: <i>Description:</i> From the order.itemGroupDescription field.
 
: <i>Description:</i> From the order.itemGroupDescription field.
  
For produce to order items this comes from the Item Category table.
+
This field comes from the legalese description which as been computed for this item, order and lot (see legalese maintenance in studio).
 
+
For produce to stock items this comes from the studio config variable <b><i>defaultGroupDescription</i></b>.
+
  
 
*<b>Variable:</b> <b><i>LabelReqNumber</i></b>
 
*<b>Variable:</b> <b><i>LabelReqNumber</i></b>
Line 190: Line 212:
  
 
*<b>Variable:</b> <b><i>ExtShipToAddress2</i></b>
 
*<b>Variable:</b> <b><i>ExtShipToAddress2</i></b>
 +
: <i>Description:</i> Extended Ship To block from Order.
 +
 +
*<b>Variable:</b> <b><i>ExtShipToAddress3</i></b>
 
: <i>Description:</i> Extended Ship To block from Order.
 
: <i>Description:</i> Extended Ship To block from Order.
  

Latest revision as of 11:19, 16 February 2018

Label Setup - Catchweight Station

Label Variables

  • Variable: GTIN
Description: The GTIN for the item.

GTIN is initially built from a hardcoded manufacturer id, an packaging indicator of 1 and the rightmost zero padded 5 characters of the item number.

GTIN is overridden by the Order.customerItem if the length is 13 or 14 (if it's a number).

GTIN is then overriden by the Order.customerGTIN (if 13 or 14 in length).

  • Variable: Product
Description: Item number.
  • Variable: ProductDescription
Description: Product Description

This is set by default to the item's Item Description.

If set, this is overriden by the orders customer item description (in the customer item table).

  • Variable: PeiceCount [sic]
Description: Number of pieces in his case.
  • Variable: NetWeightLbs
Description: Net Weight (Scale Gross - Tare) in pounds.
  • Variable: NetWeightKgs
Description: Net Weight (Scall Gross - Tare) in Kilograms.
  • Variable: CaseNumber
Description: The case serial number.
  • Variable: SerialNumber
Description: The case serial zero padded to a 6 character string.

This is used to build case fields in EAN-128 barcodes. If your cases are more than 6 characters it's better to use the CaseNumber and user the zero padding feature in bartender.

  • Variable: LotNumber
Description: The lot code.
  • Variable: CustomerComment (deprecated)
  • Variable: Customer
Description: Set to the order customer.
  • Variable: CustomerAddress1
Description: Address line 1 + Address Line 2 from order shipTo. (Deprecated - use the ShipTo*)
  • Variable: CustomerAddress2
Description: City, State, Postal from shipto. (Deprecated - use the ShipTo*)
  • Variable: CustomerAddress3
Description: Address 3 from order customer shipto. (Deprecated - use the ShipTo*)
  • Variable: CustomerItem
Description: The customer item code from the customer item table.
  • Variable: ShipToAddress1
Description: Ship To block from Order.
  • Variable: ShipToAddress2
Description: Ship To block from Order.
  • Variable: ShipToAddress3
Description: Ship To block from Order.
  • Variable: ShipToCity
Description: Ship To block from Order.
  • Variable: ShipToState
Description: Ship To block from Order.
  • Variable: ShipToPostal
Description: Ship To block from Order.
  • Variable: ShipToCountry
Description: Ship To block from Order.
  • Variable: CustomerItemHeading
Description: The string "Customer Item".

If Canada Ship-To then "/Article Client" appended.

  • Variable: DateCode (deprecated)
  • Variable: SellByDateYYMMDD
Description: The Sell-By/Expire/Pull-Date in YYMMDD format.

This is typically used for building EAN-128 barcodes.

  • Variable: SellByDateUFmt
Description: Sell-By/Expire/Pull-Date in the user defined format.

For produce to order items the formatting mask comes from the wmCustomer.LabelSellDateFmt field.

For produce to stock items this comes from the studio config variable labelStockSellDateFormat.

The number of sell-by days is determined by the setting for in the customer table. This can be overridden by the customer item table.

If this is zero, it will be overridden by the sell-by-days in the catchweight table.

The formatting mask for sell by date comes from the order.labelSellDateFmt field. A setting here of NONE can be used to suppress the sell-by date.

There is no default. If this is blank, then the sell-by date will also be blank.

  • Variable: SellByHeading
Description: This comes from the order.sellByDateDesc field. It's usually set to something like 'Sell By', or 'Expire Date'.

For produce to order items, this comes from the wmCustomer.SellByDateDesc field.

For produce to stock items this comes from the studio config variable defaultSellByDesc.

  • Variable: PackagingDateYYMMDD
Description: Prod Date/Packaging date in YYMMDD format.

This is typically used for building EAN-128 barcodes.

  • Variable: PackagingDateUFmt
Description: The Prod Date/Packaging date in user specified format.

Format comes from the order.labelProdDateFmr field.

For produce to order items the formatting mask comes from the wmCustomer.LabelProdDateFmr field.

For produce to stock items this comes from the studio config variable labelStockProdDateFormat.

If this field is blank it defaults to the "yJJJ" format (14123).

  • Variable: PackagingHeading
Description: String Containing "Packed On".

If ship-to is CDN, then "/Emballe Le" is appended.

  • Variable: SalesOrder
Description: Sales Order Number from current order. For stock this will be blank.
  • Variable: SalesOrderHeading
Description: The string "Sales Order".

If destination ship-to is Canada, then "/Commande" is appended.

  • Variable: CountryOfOrigin (same as LotCOO)
Description: The COO from the lot.
  • Variable: LabelLegalese
Description: The Legalese for the label.

Legalese is determined by a series of rules in the Legalese Map maintenance. Legalese can vary by many different dimensions, such as the Country of Origin, the item category and such.

  • Variable: CustomerItemDescription (deprecated)
  • Variable: CustomerHeading
Description: The String "Ship To".

If destination is Canada then "/Expedier A" is appended.

  • Variable: HandlingInstructions
Description: Handling instructions for the item.

Defaults to the handling instructions from the catchweight table.

Then is set to any country level overrides from the catchweight configuration.

If these are unset then it ultimately defaults to the defaultHandlingInstructions from the config.

  • Variable: CustomerGTIN
Description: Customer GTIN from the order customerGTIN field (ultimately from the customer item table)
  • Variable: ItemGroupDescription
Description: From the order.itemGroupDescription field.

This field comes from the legalese description which as been computed for this item, order and lot (see legalese maintenance in studio).

  • Variable: LabelReqNumber
Description: From the warehouse registration code. From the labelReqNumber config variable in the catchweight (since this is generally a by warehouse/station level setting).
  • Variable: NetWeightOz
Description: Net Weight (Scale Gross-Tare) in Oz.
  • Variable: NetWeightGrams
Description: Net Weight (Scale Gross-Tare) in Grams.
  • Variable: CaseTareLbs
Description: Current Tare in Lbs.
  • Variable: CaseTareKgs
Description: Current Tare in Kgs.
  • Variable: CaseTareOz
Description: Current Tare on Oz.
  • Variable: CaseTareGrams
Description: Current Tare in Grams.
  • Variable: CustomerPackedByAddress
Description: Comes from the order.customerPackedByAddress.

If unset it comes from the defaultCustomerPackedByAddress in the configuration file.

  • Variable: ExtShipToCustomer
Description: Extended Ship To block from Order.

These default to the defaultPackedBy info from the configuration file if they're unset.

  • Variable: ExtShipToAddress1
Description: Extended Ship To block from Order.
  • Variable: ExtShipToAddress2
Description: Extended Ship To block from Order.
  • Variable: ExtShipToAddress3
Description: Extended Ship To block from Order.
  • Variable: ExtShipToCity
Description: Extended Ship To block from Order.
  • Variable: ExtShipToState
Description: Extended Ship To block from Order.
  • Variable: ExtShipToPostal
Description: Extended Ship To block from Order.
  • Variable: ExtShipToCountry
Description: Extended Ship To block from Order.
  • Variable: LotVessel
Description: Vessel field from the current lot.
  • Variable: LotCertifications
Description: List of certification codes from the current lot.
  • Variable: LotCOO
Description: Country of Origin field from the current lot.
  • Variable: LotHarvest
Description: Harvest date from the current lot. Formatted with the date formatter used by the prod/packaging date.
  • Variable: LotReceived
Description: Receive date from the current lot. Formatted with the date formatter used by the prod/packaging date.