Shipment and Container Import Format

NOTE For general information on using imports, see Imports FAQ.

The following tables list the format for importing a shipment, shipment charge, shipment file, container, container contents, and container lot details record in Shipment and Container Import.

Shipment Record

Column

Position

Field

Maximum Length

Format

Required

Description

A

1

Record Type

8

Character

Yes

Enter Shipment to specify a shipment record.

B

2

Shipment Number

25

Character

Yes

Enter a unique number for the shipment. This represents the shipment tracking number that associates purchase orders and containers.

C

3

Shipper ID

12

Character

No

Enter a valid shipper ID for the shipment (the carrier). For information on setting up shipper ID's, see Shipper Maintenance.

D

4

Originating Country

10

Character

No

Enter a valid country of origin for the shipment. For information on setting up countries, see Country Maintenance.

E

5

Scheduled Delivery Date

10

99/99/9999

Yes, only if importing a new shipment

Enter the scheduled delivery date for the shipment.

F

6

Scheduled Delivery Time

7

HH:MM(AM/PM)

No

Enter the scheduled delivery time for the shipment.

G

7

Scheduled Ship Date

10

99/99/9999

No

Enter the date of the shipment.

H

8

Shipment Status

20

Character

No

Enter a valid status for the shipment.

Example At the consolidator, on the water, in port, in customs, or in route to the warehouse

For information on setting up shipment statuses, see Shipment Status Maintenance.

I

9

Vessel Name

40

Character

No

Enter the name of the vessel transporting the shipment.

J

10

From Port

15

Character

No

Enter a valid port of origin for the shipment.

K

11

To Port

15

Character

No

Enter a valid destination port for the shipment.

L

12

Ship-to Country

10

Character

Yes, only if the shipment does not have a container assigned to it

Enter the country to which the shipment is going. If this field is blank, this defaults to the ship-to country of the first purchase order of the first container for the shipment.

M

13

User Defined 1

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the shipment. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

N

14

User Defined 2

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the shipment. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

O

15

User Defined 3

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the shipment. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

P

16

User Defined 4

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the shipment. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

Q

17

User Defined 5

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the shipment. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

R

18

User Defined 6

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the shipment. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

S

19

User Defined 7

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the shipment. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

T

20

User Defined 8

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the shipment. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

U

21

User Defined 9

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the shipment. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

V

22

User Defined 10

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the shipment. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

W

23

User Defined 11

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the shipment. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

X

24

User Defined 12

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the shipment. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

Y

25

User Defined 13

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the shipment. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

Z

26

User Defined 14

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the shipment. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AA

27

User Defined 15

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the shipment. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AB

28

User Defined 16

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the shipment. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AC

29

User Defined 17

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the shipment. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AD

30

User Defined 18

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the shipment. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AE

31

User Defined 19

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the shipment. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AF

32

User Defined 20

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the shipment. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AG

33

Allow Receipt with No Charges

3

Yes/No

No

Enter Yes if there are no additional charges associated with the selected shipment and you want to allow containers on the shipment to be received. If you leave this field blank, it defaults to No. If this field is No for a shipment with no additional charges and the No radio button is selected for the Allow Receipt If No Charges Are Added to Shipment option in Purchasing Control Maintenance, the shipment cannot be received or counted.

Shipment Charge Record

Column

Position

Field

Maximum Length

Format

Required

Description

A

1

Record Type

12

Character

Yes

Enter Shipment Chg to specify a shipment charge record.

B

2

Shipment Number

25

Character

Yes

Enter the number of the shipment for the shipment charge.

C

3

Additional Charge Type

10

Character

Yes

Enter a valid purchase additional charge type for the shipment charge. For information on setting up purchase additional charges, see Purchase Additional Charge Maintenance.

D

4

Sign

1

Character

Yes

Enter either + or - to indicate whether the shipment charge is positive or negative.

E

5

Amount

13

>>,>>>,>>9.99

Yes

Enter the amount of the charge in the currency entered for the Currency field. If VAT is assessed for the shipment charge, you can enter this amount with or without VAT included. If you enter the amount with VAT included, enter Yes or Y for the Amount Includes VAT field.

F

6

Base Quantity

13

>>,>>>,>>9.99

Yes, only if importing a per unit or per unit weight shipment charge

Enter the base quantity for the shipment charge (if applicable).

G

7

Supplier Code

15

Character

Yes, only if the additional charge is for a supplier other than the supplier for the purchase order, and the additional charge is not associated with a supplier

Enter a valid supplier code for the shipment charge. This field is only used if the additional charge is for a supplier other than the supplier for the purchase order. If this field is blank for an additional charge that is for a supplier other than the supplier for the purchase order, it defaults to the supplier entered for the additional charge.

H

8

Currency

8

Character

Yes

Enter a valid currency for the shipment charge. For information on setting up currencies, see Currency Maintenance.

I

9

Comment

64

Character

No

Enter a comment for the shipment charge.

J

10

VAT Taxable

3

Yes/No

No

Enter Yes or Y if VAT is assessed for the shipment charge.

Enter No or N if VAT is not assessed for the shipment charge.

K

11

VAT Exempt Reason Code

20

Character

Yes, only if the ship-to country for the shipment is VAT taxable and No or N is entered for the VAT Taxable field

If the shipment charge is not VAT taxable and the shipment is being shipped to a VAT-taxable country, enter a valid VAT exempt reason code to explain why the shipment charge is exempt from VAT. For information on setting up VAT exempt reason codes, see VAT Exempt Reason Maintenance.

L

12

VAT Class Code

20

Character

Yes, only if Yes or Y is entered for the VAT Taxable field

If the shipment charge is VAT taxable, enter a valid VAT class code associated with the shipment charge. For information on setting up VAT class codes, see VAT Class Maintenance.

M

13

VAT Supplier Code

15

Character

Yes, only if Yes or Y is entered for the VAT Taxable field

If the shipment charge is VAT taxable, enter a valid supplier code for the supplier collecting VAT for the shipment charge. For information on setting up supplier codes, see Supplier Maintenance.

N

14

VAT Supplier Name

30

Character

Yes, only if Yes or Y is entered for the VAT Taxable field

If the shipment charge is VAT taxable, enter the supplier name of the supplier collecting VAT for the shipment charge.

O

15

Amount Includes VAT

3

Yes/No

No

Enter Yes or Y if the shipment charge amount entered in the Amount field includes VAT.

Enter No or N if the shipment charge amount entered in the Amount field does not include VAT.

Shipment File Record

Column

Position

Field

Maximum Length

Format

Required

Description

A

1

Record Type

13

Character

Yes

Enter Shipment File to specify a shipment file record.

B

2

Shipment Number

25

Character

Yes

Enter the shipment number of the shipment to which you want to attach the file.

C

3

Attachment File

255

Character

Yes

Enter the full path and file name of the file you want to attach to the shipment.

D

4

Allow Email

3

Yes/No

No

Enter Yes or Y to allow the attachment to be emailed. If this field is blank, it defaults to No.

E

5

Attachment Group

12

Character

Yes

Enter a valid group for the attachment. For information on setting up attachment groups, see Attachment Group Maintenance.

F

6

Attachment Type

12

Character

Yes

Enter a valid type for the attachment. For information on setting up attachment types, see Attachment Type Maintenance.

G

7

Attachment Subject

40

Character

Yes

Enter a unique description of the subject matter of the attachment.

Container Record

Column

Position

Field

Maximum Length

Format

Required

Description

A

1

Record Type

9

Character

Yes

Enter Container to specify a container record.

B

2

Shipment Number

25

Character

No

Enter the shipment number if the container is assigned to a shipment.

C

3

Container Code

13

Character

Yes, only if updating an existing container

Enter the container code for the container you want to update. You cannot create a container with a specific code because the software automatically generates it.

D

4

Container Name

25

Character

Yes

Enter the container's name.

E

5

Scheduled Delivery Date

10

99/99/9999

Yes, only if creating a new container

Enter the scheduled delivery date for the container.

Note The container delivery date may not always be equal to the shipment delivery date. For example, if one container on a shipment is being inspected by customs for several weeks, the delivery date for the container may be different than the delivery date for the other containers on the shipment.

F

6

Scheduled Delivery Time

7

HH:MM(AM/PM)

No

Enter the scheduled delivery time for the container.

G

7

Seal Number

20

Character

No

Enter the seal number for the container.

H

8

Bill of Lading Number

30

Character

No

Enter the container bill of lading number.

I

9

BIC Code

15

Character

No

Enter the BIC code for the container.

J

10

Container Owner

20

Character

No

Enter a valid owner for the container.

K

11

Container Type

20

Character

No

Enter a valid type for the container. For information on setting up container types, see Container Type Maintenance.

L

12

Shipper ID

12

Character

No

Enter a valid shipper ID for the container. For information on setting up shipper ID's, see Shipper Maintenance.

M

13

 

 

 

 

Leave this field blank. It is not used.

N

14

Container Status

20

Character

No

Enter a valid status for the container.

Example At the consolidator, on the water, in port, in customs, or in route to the warehouse

For information on setting up container statuses, see Shipment Status Maintenance.

O

15

Track Demurrage

3

Yes/No

No

Enter Yes to track demurrage for the container.

P

16

Demurrage Date

10

99/99/9999

No

Enter the last date the container can remain at the port before fees are assessed. This field is only used if Yes is entered for the Track Demurrage field (position 15).

Q

17

Track Detention

3

Yes/No

No

Enter Yes to track detention for the container.

R

18

Detention Date

10

99/99/9999

No

Enter the last date you can keep the container after it has been delivered before fees are assessed. This field is only used if Yes is entered for the Track Detention field (position 17).

S

19

Pickup Scheduled

3

Yes/No

No

Enter Yes if the container is scheduled for pick up.

T

20

Pickup Scheduled Date

10

99/99/9999

No

Enter the date the container is scheduled for pick up. This field is only used if Yes is entered for the Pickup Scheduled field (position 19).

U

21

Left Port

3

Yes/No

No

Enter Yes if the container has left the port.

V

22

Left Port Date

10

99/99/9999

No

Enter the date the container left the port. This field is only used if Yes is entered for the Left Port field (position 21).

W

23

Return Scheduled

3

Yes/No

No

Enter Yes if the container is scheduled to be returned.

X

24

Return Scheduled Date

10

99/99/9999

No

Enter the date the container is scheduled to be returned. This field is only used if Yes is entered for the Return Scheduled field (position 23).

Y

25

Container Returned

3

Yes/No

No

Enter Yes if the container was returned to the container owner.

Z

26

Date Returned

10

99/99/9999

No

Enter the date the container was returned to the container owner. This field is only used if Yes is entered for the Container Returned field (position 25).

AA

27

User Defined 1

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the container. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AB

28

User Defined 2

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the container. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AC

29

User Defined 3

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the container. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AD

30

User Defined 4

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the container. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AE

31

User Defined 5

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the container. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AF

32

User Defined 6

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the container. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AG

33

User Defined 7

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the container. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AH

34

User Defined 8

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the container. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AI

35

User Defined 9

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the container. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AJ

36

User Defined 10

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the container. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AK

37

User Defined 11

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the container. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AL

38

User Defined 12

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the container. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AM

39

User Defined 13

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the container. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AN

40

User Defined 14

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the container. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AO

41

User Defined 15

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the container. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AP

42

User Defined 16

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the container. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AQ

43

User Defined 17

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the container. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AR

44

User Defined 18

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the container. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AS

45

User Defined 19

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the container. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

AT

46

User Defined 20

400

Character, Date, Decimal, Integer, or Logical

No

Enter the appropriate user-defined information for the container. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

Container Contents Record

Column

Position

Field

Maximum Length

Format

Required

Description

A

1

Record Type

18

Character

Yes

Enter Container Contents to specify a container contents record.

B

2

Purchase Order Number

12

Character

Yes

Enter a valid purchase order number to add to the container.

C

3

Purchase Order Line Number

4

>>>9

Yes, only if the Product Code field (position 21) is blank

Enter the purchase order line number.

D

4

Purchase Order Quantity

13

>>,>>>,>>9.99

Yes

Enter the purchase order quantity.

E

5

Lot

40

Character

Yes, only if entering a record for a purchase order line number or release line number for which lots were previously entered

If the record is for a lot-tracked product, enter the lot. The total quantity of all lots for a purchase order line number/release line number must not exceed the quantity ordered (or released) minus the quantity on shipments.

NOTE If this field is blank, you cannot enter another record with the same purchase order line number.

F

6

Expiration Date

10

99/99/9999

Yes, only if the product is tracked by lot

Enter the expiration date of the lot for the container line item.

G

7

Best Before Date

10

99/99/9999

No

Enter the date that the container line item is best consumed before. This field is only used for lot-tracked products. It is typically used for food products.

H

8

Release Number

4

>>>9

Yes, only if the record is for a blanket purchase order release

Enter a valid blanket purchase order release number for the container line item.

Note You can only enter one release per purchase order associated with a container, and the quantity in the container must equal the quantity of the release.

I

9

Release Line Number

4

>>>9

Yes, only if the record is for a blanket purchase order release

Enter a valid blanket purchase order line number for the container line item.

J

10

Lot Description

40

Character

No

If the record is for a lot-tracked product, enter a description of the lot.

K

11

Lot User Defined 1

400

Character, Date, Decimal, Integer, or Logical

No

If the record is for a lot-tracked product, enter the appropriate user-defined information for the lot. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

L

12

Lot User Defined 2

400

Character, Date, Decimal, Integer, or Logical

No

If the record is for a lot-tracked product, enter the appropriate user-defined information for the lot. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

M

13

Lot User Defined 3

400

Character, Date, Decimal, Integer, or Logical

No

If the record is for a lot-tracked product, enter the appropriate user-defined information for the lot. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

N

14

Lot User Defined 4

400

Character, Date, Decimal, Integer, or Logical

No

If the record is for a lot-tracked product, enter the appropriate user-defined information for the lot. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

O

15

Lot User Defined 5

400

Character, Date, Decimal, Integer, or Logical

No

If the record is for a lot-tracked product, enter the appropriate user-defined information for the lot. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

P

16

Lot User Defined 6

400

Character, Date, Decimal, Integer, or Logical

No

If the record is for a lot-tracked product, enter the appropriate user-defined information for the lot. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

Q

17

Lot User Defined 7

400

Character, Date, Decimal, Integer, or Logical

No

If the record is for a lot-tracked product, enter the appropriate user-defined information for the lot. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

R

18

Lot User Defined 8

400

Character, Date, Decimal, Integer, or Logical

No

If the record is for a lot-tracked product, enter the appropriate user-defined information for the lot. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

S

19

Lot User Defined 9

400

Character, Date, Decimal, Integer, or Logical

No

If the record is for a lot-tracked product, enter the appropriate user-defined information for the lot. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

T

20

Lot User Defined 10

400

Character, Date, Decimal, Integer, or Logical

No

If the record is for a lot-tracked product, enter the appropriate user-defined information for the lot. The labels, formats, and validations for this field are set up in User Defined Fields Maintenance.

U

21

Product Code

40

Character

Yes, only if the Purchase Order Line Number field (position 3) is blank

Enter the product code for the container contents record. If you enter a value in this field, enter a value in the Purchase Order Line Number field (position 3), and the product is on multiple purchase order lines, it is imported in sequence with the delivery date. In this case, the quantity is used first by lines with earliest delivery dates, and a single container contents record may create more than one record on the container.

Note If the total quantity of the container contents record cannot be filled based on unreceived quantities not already on a container for the purchase order and product, an import error will occur.

Container Lot Details Record

Column

Position

Field

Maximum Length

Format

Required

Description

A

1

Record Type

21

Character

Yes

Enter Container Lot Details to specify a container lot details record.

B

2

Manufacturer Lot

30

Character

Yes

Enter a manufacturer lot associated with the selected lot.

C

3

Original Quantity

13

>>,>>>,>>9.99

No

Enter a product quantity associated with the manufacturer lot.

D

4

Other Information 1

20

Character

No

Enter additional information associated with the manufacturer lot.

E

5

Other Information 2

20

Character

No

Enter additional information associated with the manufacturer lot.

F

6

Other Information 3

20

Character

No

Enter additional information associated with the manufacturer lot.

G

7

Other Information 4

20

Character

No

Enter additional information associated with the manufacturer lot.

Import Format Notes