NOTE For general information on using imports, see Imports FAQ.
The following table lists the format for importing a record in Inventory Reservation Import.
|
Column |
Position |
Field |
Maximum Length |
Format |
Required |
Description |
|
A |
1 |
Reservation Type |
14 |
Character |
Yes |
Enter one of the following reservation types for the reservation:
|
|
B |
2 |
Reserved by |
16 |
Character |
Yes |
Enter one of the following to specify the entity for which the reservation is being created:
|
|
C |
3 |
Location Prefix |
3 |
Character |
Yes |
Enter a valid location prefix for the inventory reservation. For information on setting up locations, see Location Maintenance. |
|
D |
4 |
Product Code |
40 |
Character |
Yes |
Enter a valid product code for the inventory reservation. For information on setting up products, see Product Maintenance. |
|
E |
5 |
Customer Code |
12 |
Character |
Yes, only for a customer reservation |
Enter the customer code for the inventory reservation if Customer is entered for the Reserved by field. For information on setting up customers, see Customer Maintenance. |
|
F |
6 |
Customer Division |
12 |
Character |
Yes, only for a customer division reservation |
Enter the customer division ID for the inventory reservation if Division is entered for the Reserved by field. For information on setting up customer divisions, see Customer Division Maintenance. |
|
G |
7 |
Billing Customer Code |
12 |
Character |
Yes, only for a billing customer reservation |
Enter the billing customer code for the inventory reservation if Billing Customer is entered for the Reserved by field. For information on setting up billing customers, see Customer Maintenance. |
|
H |
8 |
Quantity Allocated |
12 |
>,>>>,>>9.99 |
Yes, only for a reserve now reservation |
Enter the quantity to reserve for the inventory reservation. |
|
I |
9 |
Quantity Future |
12 |
>,>>>,>>9.99 |
Yes, only for a future receipt reservation |
Enter the future quantity to reserve for the inventory reservation. |
|
J |
10 |
Unit of Measure |
8 |
Character |
No |
Enter the unit of measure for reserved quantities. This must be a valid unit of measure for the product for which you are creating the reservation. For information on setting up units of measure, see Unit of Measure Maintenance. |
|
K |
11 |
Start Date |
10 |
99/99/9999 |
Yes, only for a future receipt reservation |
Enter the start date for the inventory reservation. |
|
L |
12 |
Expiration Date |
10 |
99/99/9999 |
Yes, only for a future receipt reservation that is not associated with a specific purchase order |
Enter the expiration date for the inventory reservation. This date is only for reference, and is only used for future receipt reservations for which the Purchase Order Number field (position 14) is blank. |
|
M |
13 |
Priority |
2 |
Integer |
No |
Enter a priority for the inventory reservation (between 0 and 99) if it is a future receipt reservation. |
|
N |
14 |
Purchase Order Number |
12 |
Character |
No |
Enter a purchase order number you want to associate with the inventory reservation if it is a future receipt reservation. Note If you enter a purchase order number, inventory is automatically allocated from available bins when the purchase order is received. If you do not enter a purchase order number, you must allocate inventory in Future Receipt Reservation Allocate. |
|
O |
15 |
Reserve Transfers |
3 |
Yes/No |
No |
Enter Yes if you want to reserve inventory from transfer orders for a future receipt inventory reservation. |
|
P |
16 |
User-Defined Field 1 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter additional information about the inventory reservation in this user-defined field. |
|
Q |
17 |
User-Defined Field 2 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter additional information about the inventory reservation in this user-defined field. |
|
R |
18 |
User-Defined Field 3 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter additional information about the inventory reservation in this user-defined field. |
|
S |
19 |
User-Defined Field 4 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter additional information about the inventory reservation in this user-defined field. |
|
T |
20 |
User-Defined Field 5 |
400 |
Character, Date, Decimal, Integer, or Logical |
No |
Enter additional information about the inventory reservation in this user-defined field. |
|
U |
21 |
Reallocation Allowed |
3 |
Yes/No |
No |
Enter Yes if you want to allow users to reallocate inventory for the reservation to other orders in Order Allocation Update. |
Before using this import, the following must be set up:
locations
products