Shipment Delivery Specification (Export from Gravity)

1.1

Mar 22, 2024

XSD Update

• removed ExternalReference element from BookingItem

BookingReference

A unique booking reference assigned to the shipment delivery job

Y

nvarchar

PUA-1585

DateBooked

Date when the pick-up instruction was submitted

Y

dateTime

2024-01-20

BookedBy

Username of the user who submitted the instruction (for Export only)

Y

nvarchar

Peter.Chan

CustomerCode

Customer Code

Y

nvarchar

ABCD

HaulierCode

Haulier Code

Y

nvarchar

TR1234

ShipmentPickUpLocation

Place where the shipment is ready to be picked up for the delivery

N

nvarchar

PlannedShipmentPickUpDate

Expected date time when the shipment pick-up should be performed

N

dateTime

2024-02-19T07:49:03

CargoDeliveryLocationNode

Place where the shipment should be delivered to

N

See section Node Elements

CargoDeliveryLocationName

Name of the place where the shipment should be delivered to

Y

nvarchar

CargoDeliveryLocationContactPerson

Contact person name of the place where the shipment should be delivered to

N

nvarchar

CargoDeliveryLocationPhone

Contact phone number of the place where the shipment should be delivered to

N

nvarchar

CargoDeliveryLocationEmail

Contact email of the place where the shipment should be delivered to

N

nvarchar

CargoDeliveryLocationAddress

Address of the place where the shipment should be delivered to

N

nvarchar

PlannedInDCDate

Expected date time when the shipment should be delivered to

Y

dateTime

2024-02-19T07:49:03

EmptyContainerPickUpLocationNode

Node where the empty container is ready to be picked up for the return to carrier premises

N

See section Node Elements

EmptyContainerPickUpLocationName

Place name where the empty container is ready to be picked up for the return to carrier premises

N

nvarchar

EmptyContainerPickUpLocationContactPerson

Contact person name for the empty container pick-up

N

nvarchar

EmptyContainerPickUpLocationPhone

Contact phone number for the empty container pick-up

N

nvarchar

EmptyContainerPickUpLocationEmail

Contact email for the empty container pick-up

N

nvarchar

EmptyContainerPickUpLocationAddress

Address where the empty container is ready to be picked up for the return to carrier premises

N

nvarchar

PlannedEmptyContainerPickUpDate

Expected date time when the empty container should be picked up

N

dateTime

2024-02-19T07:49:03

EmptyContainerDeliveryLocation

Place where the empty container should be delivered to

N

nvarchar

PlannedEmptyContainerDeliveryDate

Expected date time when the empty container should be delivered to

N

dateTime

2024-02-19T07:49:03

EmptyContainerReturnDeadline

Deadline of returning the empty container

N

dateTime

2024-02-19T07:49:03

BookingOrders

List of 3PL Shipment Booking included in the scheduled pick-up

Y

See section Booking Order Elements

Number

When Sea Freight then Container Number
When Air Freight then MAWB
When Road Freight then Trailer number

Y

nvarchar

250

ABCD1234567

OrderNumber

Purchase Order Number

Y

nvarchar

250

PO01230213812

Identifier

Purchase Order Call-Off Reference

N

nvarchar

50

ID8901238123

BookingItems

List of order items included

Y

See section Booking Item Elements

VendorBookingReference

A unique reference represents a vendor shipment booking created in the system

N

nvarchar

250

VEN-1234

ItemCode

Product number/Item Code

Y

nvarchar

50

100013344

Description

Item / Product Description

N

nvarchar

500

T-Shirts

SKU

SKU (if available)

N

nvarchar

100

80018839298

Colour

Colour of item (if available)

N

nvarchar

50

Blue

Size

Size of item (if available)

N

nvarchar

50

Large

Quantity

Pieces

Y

decimal

68

PackType

Pack Type

N

nvarchar

Refer to PackType

Cartons

Cartons

N

int

12

CBM

Cubic Metres

N

decimal

18,2

65.32

Weight

Weight

N

decimal

18,2

32.46

Cancelled

Cancelled flag

N

bool

false

Code

Code of Node

nvarchar

1000

MCRN

Name

Node name which is the UI display value in GRA

nvarchar

1000

MACARON

Description

Description of the Node

nvarchar

200

Food

Address

Address of Node

See Node Address Elements section

Line1

Line1

nvarchar

100

Rm 801-807, 8/F, Hoplite Industrial Building

Line2

Line2

nvarchar

100

3-5 Wang Tai Road, Shenzhen Bay

Line3

City

nvarchar

100

Shenzhen

Line4

State/Province

nvarchar

100

Guandong

PostCode

Postcode/Zip

nvarchar

50

31515412

Email

Email

nvarchar

250

Tim.R@mlogistics.com

Fax

Fax

nvarchar

20

+854423512

Telephone

Telephone

nvarchar

20

+8432173475

Longitude

Longitude

decimal

12

121.45806

Latitude

Latitude

decimal

12

31.22222

Contact

Contact Name

nvarchar

100

Tim R

CountryCode

Country Code

nvarchar

50

CN