3PL Shipment Booking Specification (Import to Gravity)

Element

Description

Mandatory?

Data Type

Max Length

Example

Generated

Time File generated

Y

datetime

2018-07-05T00:00:00

BookingReference

Booking reference

Y

nvarchar

250

EXREF-12-32

CustomerCode

Customer Code

Y

nvarchar

1000

MCRN

CYCFSCutOffDate

CY/CFS Cut-off date

N

date

2018-07-05T00:00:00

SICutOffDate

Shipping Instruction Cut-off date

N

date

2018-07-05T00:00:00

VGMCutOffDate

VGM Cut-off date

N

date

2018-07-05T00:00:00

PlaceOfReceipt

Place of Receipt

N

nvarchar

100

Brisbane

CargoReadyDate

Cargo Loading/Ready Date

N

date

2018-07-05T00:00:00

ActualPickUpDate

Actual Pick Up Date

N

datetime

2018-07-05T00:00:00

FinalDestinationETA

Estimated Final Destination Arrival Date

N

date

2018-07-05T00:00:00

DateBooked

Date Cargo Booking Created

Y

datetime

2018-07-05T00:00:00

BookedBy

Booked by user (for Export only)

N

nvarchar

250

D.Smith

LoadType

Load Type

Y

nvarchar

 Refer to LoadType

BookingOrders

Purchase Orders

Y

See section 5.2

BookingEquipments

Booking Equipment

N

See section 5.4

BookingLegs

Shipment legs

Y

See section 5.5

Element

Description

Mandatory?

Data Type

Max Length

Example

ExternalReference

External Reference

N

nvarchar

250

EXREF-191

OrderNumber

Purchase Order Number

Y

nvarchar

250

PO11234

Identifier

CallOff reference (line number)

N

nvarchar

50

1

BookingItems

Array of Purchase Order Items

Y

See section 5.3

Element

Description

Mandatory?

Data Type

Max Length

Example

VendorBookingReference

A unique reference represents a vendor shipment booking created in the system and it must be supplied if created

N*

nvarchar

250

VEN-1234

ExternalReference

Reference

N

nvarchar

250

EXRef-345443

ItemCode

Product number/Item Code

Y

nvarchar

50

100013344

Description

Item / Product Description

N

nvarchar

500

T-Shirts

Quantity

Pieces

Y

decimal

68

PackType

Pack Type

N

enum

Outers

Outers

N

int

12

Inners

Inners

N

int

6

Cbm

Cubic Metres

N

decimal

18,2

65.32

Weight

Weight

N

decimal

18,2

32.46

Sku

SKU (if available)

N

nvarchar

100

80018839298

CustomerReference

Customer Reference

N

nvarchar

100

CR-1232145

Colour

Colour of item (if available)

N

nvarchar

50

Blue

Size

Size of item (if available)

N

nvarchar

50

Large

Cancelled

Cancelled flag

N

bool

false

Element

Description

Mandatory?

Data Type

Max Length

Example

Count

Number of containers

Y

int

1

Code

Container/Equipment type

Y

nvarchar

20

20GP

Name

Container/Equipment description

Y

nvarchar

250

20 General Purpose

Element

Description

Mandatory?

Data Type

Max Length

Example

Vessel

When Sea Freight then Vessel Name
When Air Freight then “Air”
When Road Freight then “Road” or Vehicle plate
When Rail Freight then “Rail” or Trailer number

Y

nvarchar

250

MSC Clara

Voyage

When Sea Freight then Voyage
When Air Freight then Flight number
When Rail or Road Freight then N/A

Y

nvarchar

250

FW831W

CarrierNode

Carrier Node

Y

See section 5.6

ETA

Expected Time of Arrival

Y

date

2018-07-24

ETD

Expected Time of Departure

Y

date

2018-07-24

PODCode

UN/LOCODE for SEA or IATA for AIR

Y

nvarchar

20

AUMEL

PODName

Port of Discharge Name

Y

nvarchar

250

Melbourne

POLCode

UN/LOCODE for SEA or IATA for AIR

Y

nvarchar

20

CNSNG

POLName

Port of Loading Name

Y

nvarchar

250

Shanghai

ModeOfTransportType

Mode of Transport

Y

enum

Sea

LegType

If ModeOfTransportType=Sea enum values = OriginFeeder, Mother (mandatory for at least one sea leg record) and DestinationFeeder

If ModeOfTransportType=Air, Road or Rail enum values=1,2,3, etc

Y

enum

Mother

Element

Description

Mandatory?

Data Type

Max Length

Example

Code

Code of the Node

Y

nvarchar

1000

MCRN

Name

Node name which is the UI display value in GRA

Y

nvarchar

1000

MACARON

Description

Description of the Node

N

nvarchar

200

Food

Address

Address of Node

N

See section 5.7

Element

Description

Mandatory?

Data Type

Max Length

Example

Line1

Line1

N

nvarchar

100

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

Line2

Line2

N

nvarchar

100

3-5 Wang Tai Road, Shenzhen Bay

Line3

City

N

nvarchar

100

Shenzhen

Line4

State/Province

N

nvarchar

100

Guandong

PostCode

Postcode/Zip

N

nvarchar

50

31515412

Email

Email

N

nvarchar

250

Tim.R@mlogistics.com

Fax

Fax

N

nvarchar

20

+854423512

Telephone

Telephone

N

nvarchar

20

+8432173475

Longitude

Longitude

N

decimal

12

121.45806

Latitude

Latitude

N

decimal

12

31.22222

Contact

Contact Name

N

nvarchar

100

Tim R

CountryCode

Country Code

N

nvarchar

50

CN