Skip to content
  • There are no suggestions because the search field is empty.

Document Template Placeholders - Consignment Proof of Delivery

Placeholder Description
$ORGANISATION_NAME$ The name of your company
$COMPANY_NAME$ The name of your customer
$REFERENCE$ The Reference Number for the consignment
$BARCODE$ The Barcode Number of the consignment
$DATE_ADDED$ The date the Consignment was added to the system
$DATE_DELIVERED$ The date the Consignment was delivered
$PRODUCT_TYPE$ The Product Type that the Consignment is for
$CON_ID$ Consignment ID 
$DELIVERY_ADDRESS$ The Delivery Address for the Consignment
$DELIVERY_ADDRESS_STREET_2$ The second line of the delivery address (e.g suite, apartment number)
$SPECIAL_INSTRUCTIONS$ The Special Instructions
$CON_IS_CASH_ON_DELIVERY$ If Consignment is cash on delivery 
$CONSIGNMENT_QUANTITY$ An aggregation of all your Consignment Fields, and the Consignment Value, for example:
Cartons: 5 | Pallets: 3 | Ties: 0 | Value: $156.10
$CONSIGNMENT_STATUS$

Status of the consignment
$CON_DELIVERY_RUN_DATE$ Consignment delivery run date 
$CON_CHARGE_TO$ Consignment customer charge to 
$DRIVER$ Name of the driver on Run Sheet associated to the consignment.
$VEHICLE$ Name of vehicle on Run Sheet associated to the consignment.
$MANIFEST_CUSTOMER_REFERENCE$ Customer reference on the Consignment's manifest. Blank if no manifest is attached.
$MAN_ID$ Manifest ID 
$CONSIGNMENT_TYPE$ Type of Consignment, eg; Delivery, Pickup, etc
$REQUIRED_DELIVERY_DATE$ Required date of delivery of the Consignment. If no date is specified this will default to 'ASAP'
$ON_FORWARDER_ADDRESS$ The On Forwarder Address for the Consignment, if one is specified.
$ONFORWARDER_ADDRESS_STREET_2$ The second line of the onforwarder address (e.g suite, apartment number)
$ON_FORWARDER_NAME$ The Contact Name specified in the On Forwarder Address for the Consignment, if one is specified.
$CARRIER_NAME$ Name of the Carrier attached to this Consignment.

$CON_HISTORY_SIGNED_FOR$

 Displays POD signing information

$CON_HISTORY_SIGNED_FOR_BY$

$CON_HISTORY_SIGNED_FOR_DATE$

$FIELD_1$

...

$FIELD_30$

 The configured name for the Custom Field on the Consignment. Numbered 1 through to 30.

$FIELD_1_VAL$

...

$FIELD_30_VAL$

 The value set for this Custom Field on this Consignment. Numbered 1 through to 30.

$DATA_CUSTOM_FIELD_1$

...

$DATA_CUSTOM_FIELD_30$

 The configured name for this Data Custom Field on the Consignment. Numbered 1 through to 30.

$DATA_CUSTOM_FIELD_1_VAL$

...

$DATA_CUSTOM_FIELD_30_VAL$

 The value set for this Data Custom Field on this Consignment. Numbered 1 through to 30.
Sale Order Product Fields: If the Consignment was generated from a Sale Order, then you can make it show the associated Sale Order Product fields:
$SOP_CODE$ = The Product Code

$SOP_NAME$ = The Products Name

$SOP_CUSTOM_FIELD_1$ = The Purchase Order Products Custom field 1, ie the Batch number (there are 10 custom fields in total)

$SOP_PRODUCT_TYPE$ = The type of the product, ie: Frozen, Chilled, Ambient etc.

$SOP_EXPIRY_DATE$

$SOP_PRODUCT_STATUS$ = The status of the product: "OK", "Quarantine", "Damaged" etc.

$SOP_LOCATION_NAME$ = The Warehouse Location Name

$SOP_QTY$ = The quantity of the product, always provided in the Base Unit of Measure

$SOP_MEAS$ = The Unit Of Measure of the Product, as Base.

$SOP_PRODUCT_CUSTOM_FIELD_1$ = The Products Custom Field 1, ie: Supplier Code
Pickup Address Fields 

$PICKUP_ADDRESS$

$PICKUP_ADDRESS_COMPANY$

$PICKUP_ADDRESS_STREET$

$PICKUP_ADDRESS_STREET_1$

$PICKUP_ADDRESS_STREET_2$

$PICKUP_ADDRESS_SUBURB$

$PICKUP_ADDRESS_CITY$

$PICKUP_ADDRESS_STATE$

$PICKUP_ADDRESS_CODE$

$PICKUP_ADDRESS_PHONE$

$PICKUP_ADDRESS_CONTACT$

$PICKUP_ADDRESS_EMAIL$
Delivery Address Fields 

$DELIVERY_ADDRESS$

$DELIVERY_ADDRESS_COMPANY$

$DELIVERY_ADDRESS_STREET$

$DELIVERY_ADDRESS_STREET_1$

$DELIVERY_ADDRESS_STREET_2$

$DELIVERY_ADDRESS_SUBURB$

$DELIVERY_ADDRESS_CITY$

$DELIVERY_ADDRESS_STATE$

$DELIVERY_ADDRESS_CODE$

$DELIVERY_ADDRESS_PHONE$

$DELIVERY_ADDRESS_CONTACT$
Onforwarder Address Fields 

$ONFORWARDER_ADDRESS$

$ONFORWARDER_ADDRESS_COMPANY$

$ONFORWARDER_ADDRESS_STREET$

$ONFORWARDER_ADDRESS_STREET_1$

$ONFORWARDER_ADDRESS_STREET_2$

$ONFORWARDER_ADDRESS_SUBURB$

$ONFORWARDER_ADDRESS_CITY$

$ONFORWARDER_ADDRESS_STATE$

$ONFORWARDER_ADDRESS_CODE$

$ONFORWARDER_ADDRESS_PHONE$

$ONFORWARDER_ADDRESS_CONTACT$
Sale Order fields 

$SO_ID$

$SO_REFERENCE$

$SO_FINISH_PACK_TIME$

$SO_DATE_ADDED$

$SO_REQUIRED_SHIP_DATE$

$SO_REQUIRED_DELIVERY_DATE$

$SO_URGENT$

$SO_QTY_TOTAL_SUMMARY$

$SO_VALUE$

$SO_ATTACH_INVOICE_TO_GOODS$

$SO_CF_1_VALUE$

$SO_CF_1_NAME$
CONSIGNMENT ITEM FIELDS:

$BLOCK_ITEMS$ = Replaces the placeholders inside the Items table

$ITEM_CODE$ = The code of the Item

$ITEM_DESCRIPTION$ = The description of the Item

$ITEM_QUANTITY$ = The quantity of the Item

$ITEM_PALLETS$ = The pallets of the Item

$ITEM_SPACES$ = The spaces of the Item

$ITEM_CUBIC$ = The cubic of the Item

$ITEM_WEIGHT$ = The weight of the Item

$ITEM_LENGTH$ = The length of the Item

$ITEM_WIDTH$ = The width of the Item

$ITEM_HEIGHT$ = The height of the Item

$TOTAL_QUANTITY$ = The total quantity of all the Items

$TOTAL_PALLETS$ = The total pallets of all the Items

$TOTAL_SPACES$ = The total spaces of all the Items

$TOTAL_CUBIC$ = The total cubic of all the Items 

$TOTAL_WEIGHT$ = The total weight of all the Items

$TOTAL_HOURS$ = The number of hours it took to deliver the Consignment

$TOTAL_DISTANCE$ = The number of kilometres to deliver the Consignment

$TOTAL_{CF_MAP_FIELD_NAME}$ = The total of the Consignment Item custom field. The MAP_FIELD_NAME is the name of the Custom Field, for example, $TOTAL_CHEP$.

$ITEM_[uppercase_map_field_name goes here]$ = 

The value of Item Custom Field stored against the Item. The map field name needs to be inserted, (eg BATCH). If your map field name is batch then the replacement

tag would be $ITEM_BATCH$

AGGREGATE PRODUCT FIELDS 

Please Note a template cannot have conflicting place holders.

An Example of this would be if a template had the Individual 'Product Field' of The Product Name ($NAME$) and also used the 'Aggregate Product Field' of the product name ($AGGREGATE_SOP_PRODUCT_NAME$).

This would cause a template placeholder error and would not allow template to be uploaded.

$AGGREGATE_SOP_PRODUCT_NAME$ = Displays the Product Name for aggregated Products

$AGGREGATE_SOP_PRODUCT_DESCRIPTION$ = Displays the Product Description for aggregated Products

$AGGREGATE_SOP_PRODUCT_QTY$ = Displays the aggregate quantity of Sale Order Products which are aggregated

$AGGREGATE_SOP_PRODUCT_MEASURE$ = Displays the Base Unit of Measure for the aggregated Product

$AGGREGATE_SOP_PRODUCT_TYPE$ = Displays the type of the aggregated product, ie: Frozen, Chilled, Ambient etc.

$AGGREGATE_SOP_PRODUCT_CODE$ = Displays the Product Code for aggregated Products

$AGGREGATE_PRODUCT_CF_(1-10)_VALUE:SUM$ = This sums up all the aggregated POP custom field numeric values only. If there is a non-numeric value, it will be omitted.

Date Format
 To change the date format on any document template, you need to add a date suffix the date placeholder. 


$EXPIRY_DATE:DD-MM-YYYY$


Different formats can be used on the same document template for different placeholders. Remember to add the colon between the date placeholder and date format. These are the current accepted date formats:

Suffix

Example of date

DD-MM-YYYY

22/03/2019

DD-MM-YY

22/03/19

MM-DD-YYYY

03/22/2019

MM-DD-YY

03/22/19

Grouping 
To add grouping configurations to your template, use the below placeholders and place them above the Product table's header as pictured. 

Placeholder

Description

$GROUP_BY_PRODUCT_AND_POP_EXPIRY_DATE$

Groups SOPs in the table by expiry date only

$GROUP_BY_PRODUCT_AND_POP_EXPIRY_DATE_AND_POP_CF_(1-10)_VALUE$

Groups SOPs  in the table by expiry date and pop custom field values

$GROUP_BY_PRODUCT_AND_POP_CF_(1-10)_VALUE$

Groups SOPs in the table by pop custom field values only

$AGGREGATE_PRODUCT_CF_(1-10)_VALUE:SUM$

This sums up all the aggregated POP custom field numeric values only. If there is a non-numeric value, it will be omitted.