Expression Editor Functions - Despatch Order/Despatch Category

Actual berthing date at the destination location.

Format: ActualBerthingDateDestination()

Actual berthing date at the origin location.

Format: ActualBerthingDateOrigin()

Actual loading date.

If the actual loading date is not available, the date is estimated by using the first available date out of the following dates: planned end loading, actual start loading and planned start loading.

Format: ActualLoadingDate()

Actual unberthing date at the destination location.

Format: ActualUnberthingDateDestination()

Actual unberthing date at the origin location.

Format: ActualUnberthingDateOrigin()

Actual unloading date.

If the actual loading date is not available, the planned end loading date is used.

Format: ActualUnloadingDate()

Actual time of arrival of the first despatch at the destination location.

Format: ATADestinationFirstDespatch()

Actual time of arrival of the last despatch at the destination location.

Format: ATADestinationLastDespatch()

Actual time of arrival of the first despatch at the loading location.

Format: ATALoadingFirstDespatch()

Actual time of arrival of the last despatch at the loading location.

Format: ATALoadingLastDespatch()

Actual time of departure of the first despatch from the destination location.

Format: ATDDestinationFirstDespatch()

Actual time of departure of the last despatch from the destination location.

Format: ATDDestinationLastDespatch()

Actual time of departure of the first despatch from the loading location.

Format: ATDLoadingFirstDespatch()

Actual time of departure of the last despatch from the loading location.

Format: ATDLoadingLastDespatch()

Bill of lading date of the despatch order.

If the bill of lading date is not available, the date is estimated by using the first available date out of the following dates: ATD at origin; ETD at origin; ATA at origin; ETA at origin; or planned despatch date of the despatch order. The Estimated Bill Of Lading Date field of the despatch order is not used.

If this function is used in mark-to-market calculations, the function returns the bill of lading date of the physical despatch order.

Format: BillOfLadingDate()

Contractual month.

Format: ContractualMonth()

Date on which control passed for the despatch order.

Format: ControlPassedDate()

Control passed status for the despatch order.

Format: ControlPassedStatus()

Port draft at the loading port, as specified for the port location.

Format: CurrentLoadPortDraft()

Port draft at the unloading port, as specified for the port location.

Format: CurrentUnloadPortDraft()

Dead weight of the vessel associated with the shipment.

Format: DeadWeight()

Despatched date, determined as the bill of lading date if it is available, or if not, as the despatch loading date when not a shipment, or the loading departure date when a shipment.

Format: DespatchedDate()

Date of the scheduled arrival at the destination location.

Format: DespatchETADestination()

Date of the scheduled arrival at loading location.

Format: DespatchETALoading()

Date of the scheduled departure from the destination location.

Format: DespatchETDDestination()

Date of the scheduled departure from the loading location.

Format: DespatchETDLoading()

Number of wagons used to fulfil the despatch order.

Format: DespatchOrderUsedWagons()

Despatch destination arrival date.

Format: DestinationArrival()

Despatch destination departure date.

Format: DestinationDeparture()

End of loading of the first despatch.

Format: EndLoadingDateFirstDespatch()

End of loading of the last despatch.

Format: EndLoadingDateLastDespatch()

End of unloading of the first despatch.

Format: EndUnLoadingDateFirstDespatch()

End of unloading of the last despatch.

Format: EndUnLoadingDateLastDespatch()

Estimated assay exchange completion date from additional dates/info of contract fulfilment.

Format: EstimatedAssayExchangeCompletionDate()

Estimated time of arrival of the first despatch at the destination location.

Format: ETADestinationFirstDespatch()

Estimated time of arrival of the last despatch at the loading location.

Format: ETADestinationLastDespatch()

Estimated time of arrival of the first despatch at the loading location.

Format: ETALoadingFirstDespatch()

Estimated time of arrival of the last despatch at the loading location.

Format: ETALoadingLastDespatch()

Estimated time of departure of the first despatch from the destination location.

Format: ETDDestinationFirstDespatch()

Estimated time of departure of the last despatch from the destination location.

Format: ETDDestinationLastDespatch()

Estimated time of departure of the first despatch from the loading location.

Format: ETDLoadingFirstDespatch()

Estimated time of departure of the last despatch from the loading location.

Format: ETDLoadingLastDespatch()

Event date at the destination location.

Format: EventDateDestination()

Event date at the loading location.

Format: EventDateLoading()

Final assay agreement date from additional dates/info of contract fulfilment.

Format: FinalAssayAgreementDate()

Tests whether the despatch order has an estimated assay exchange completion date.

Format: HasEstimatedAssayExchangeCompletionDate()

Tests whether the despatch order has a final assay agreement date.

Format: HasFinalAssayAgreementDate()

Latest sample date.

Format: LatestSampleDate()

End date of the laycan at the destination location.

Format: LaycanEndDateDestination()

End date of the laycan at the origin location.

Format: LaycanEndDateOrigin()

Start date of the laycan at the destination location.

Format: LaycanStartDateDestination()

End date of the laycan at the origin location.

Format: LaycanStartDateOrigin()

Length of the cargo area of the vessel associated with the shipment.

Format: LengthOfCargoArea()

Despatch loading departure date.

Format: LoadingDeparture()

Loading rate at the loading port, as specified for the shipment route point.

Format: LoadingPortLR()

Mark-to-market date.

Format: MTMDate()

Date the note of readiness was tendered, as specified in the Vessel NOR Tendered field on the Shipment screen.

Format: NORTendered()

Number of barges used to fulfil the despatch order.

Format: NumberOfBarges()

Number of composite samples associated with the despatch order.

Format: NumberOfCompositeSamples()

Number of composite samples less than a specified weight that are associated with the despatch order.

Format: NumberOfCompositeSamplesLessThan()

Number of package groups (and child package groups at any level) that are associated with a container, or have a container type specified, optionally limited to a specified container type.

Format: NumberOfContainers([ContainerType])

Number of lot samples associated with the despatch order.

Format: NumberOfLotSamples()

Number of lot samples less than a specified weight that are associated with the despatch order.

Format: NumberOfLotSamplesLessThan()

Number of shipments used to fulfil the despatch order.

Format: NumberOfShipments()

Number of trains used to fulfil the despatch order.

Format: NumberOfTrains()

Number of trucks used to fulfil the despatch order.

Format: NumberOfTrucks()

Number of wagons on the train associated with the despatch.

Format: NumberOfWagons()

Planned despatch date of the parent despatch order (PDO).

Format: ParentOrderPlannedDespatchDate()

Planned berthing date at the destination location.

Format: PlannedBerthingDateDestination()

Planned berthing date at the origin location.

Format: PlannedBerthingDateOrigin()

Planned despatch date.

Format: PlannedDespatchDate()

Planned loading date.

Format: PlannedLoadingDate()

Planned unberthing date at the destination location.

Format: PlannedUnberthingDateDestination()

Planned unberthing date at the origin location.

Format: PlannedUnberthingDateOrigin()

Planned unloading date.

Format: PlannedUnloadingDate()

Sample date of the first despatch.

Format: SampleDateFirstDespatch()

Sample date of the last despatch.

Format: SampleDateLastDespatch()

Start of loading of the first despatch.

Format: StartLoadingDateFirstDespatch()

Start of loading of the last despatch.

Format: StartLoadingDateLastDespatch()

Start of unloading of the first despatch.

Format: StartUnLoadingDateFirstDespatch()

Start of unloading of the last despatch.

Format: StartUnLoadingDateLastDespatch()

Tonnes delivered.

Format: TonnesDelivered()

Loading rate at the unloading port, as specified for the shipment route point.

Format: UnloadingPortLR()

Build year of the vessel of the shipment.

Format: VesselBuildYear()