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.
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
A container contents record must be directly after the associated container record in the import file.