Add Inventory Items
Use this service to import Inventory Items information.
WSDL: AddInv_Req.jws
Method: AddInv_Req
Underlying File Maintenance
Prior to importing Inventory Items information, the following file maintenance areas must be completed:
Assumptions and Dependencies
The Inventory module must be set up.
The Inventory Item Master cost center flag is shared. The Inventory Items import will validate that the company has the cost center option set to Pending or Yes and will set the default for the new Inventory Items to Shared.
The Inventory Item status will default to (A)ctive if left blank.
The Location field is required if the Inventory Control Installation screen is set to validate. Otherwise it is a data entry field.
Warehouse_Code hierarchy
If populated then validate and set up the warehouse.
If the Inventory Control Installation screen option 'One Warehouse' is selected, the default warehouse is defined and the field is blank then the field is required. If the default warehouse is defined then set up the item for the defined warehouse code.
If the Inventory Control Installation screen option 'One Warehouse' is NOT selected and the field is blank then set up the item for ALL warehouses.
Field Descriptions
Use the table below for reference when using this service.
Excel |
Element Name |
Description |
Req |
Type |
Max |
Format |
Validation |
---|---|---|---|---|---|---|---|
Authorization_ID |
Authorization ID to access the server |
YES |
Text |
20 |
Data Exchange Installation Screen |
||
GUID |
Unique reference number created by programming |
Text |
36 |
** See GUID definition |
|||
B |
Company_Code |
Company Code |
YES |
Text |
3 |
Valid Company in Spectrum. |
|
C |
Item_Code |
Item Code |
YES |
Text |
15 |
Unique identifier |
No dashes if using Traser. |
D |
Item_Description |
Item Description |
YES |
Text |
35 |
||
E |
Item_Category |
Category |
YES |
Text |
4 |
Category File Maintenance |
|
F |
ABC_Class |
ABC Class |
Text |
3 |
|||
G |
Alternate_Item_Code1 |
EDP Part # |
Text |
15 |
|||
H |
Standard_Cost |
Standard Cost |
Numeric |
11 |
Format = 6.4. Enter decimals but no $ or commas. Positive numbers only. |
||
I |
Unit_Of_Measure_Conversion |
Purchase Conversion Factor |
YES |
Numeric |
9 |
Format = 4.4. Positive numbers only. |
|
J |
Purchase_Unit_Of_Measure1 |
Purchase Unit of Measure |
YES |
Text |
2 |
||
K |
Price_List1 |
Sell Price 1 |
Numeric |
11 |
Enter decimals but no $ or commas. Positive only. |
||
L |
Price_List2 |
Sell Price 2 |
Numeric |
11 |
Enter decimals but no $ or commas. Positive only. |
||
M |
Price_List3 |
Sell Price 3 |
Numeric |
11 |
Enter decimals but no $ or commas. Positive only. |
||
N |
Price_List4 |
Sell Price 4 |
Numeric |
11 |
Enter decimals but no $ or commas. Positive only. |
||
O |
Price_List5 |
Sell Price 5 |
Numeric |
11 |
Enter decimals but no $ or commas. Positive only. |
||
P |
Price_Per_Factor |
Price Per Factor |
Numeric |
10 |
Defaults to 1 if left blank. Format = 4.4- |
||
Q |
Sell_Unit_Of_Measure2 |
Sell Unit of Measure |
YES |
Text |
2 |
||
R |
Vendor_Part_Number |
Vendor Part # |
Text |
15 |
|||
S |
Vendor_Code_List1 |
Primary Vendor |
Text |
10 |
Vendor Maintenance |
||
T |
Vendor_Code_List2 |
Alternate Vendor |
Text |
10 |
Vendor Maintenance |
||
U |
Markup_Price |
Markup % |
Numeric |
7 |
Example: Enter 10.55% as 10.55. Defaults to 0.0% if left blank. Format = 3.2- |
||
V |
Phase_Code |
Default Item Phase |
Text |
20 |
No Dashes |
||
W |
Cost_Type |
Default Cost Type |
Text |
3 |
Cost Type Maintenance |
||
X |
Default_Cost_Category |
Default Equip Cost Category |
Text |
4 |
Equipment Cost Category Maintenance |
||
Y |
Discount_Code |
Promotional Discount Code |
Text |
2 |
Discount File Maintenance |
||
Z |
Unit_Weight |
Weight |
Numeric |
9 |
Format = 3.4- |
||
AA |
Taxable_Flag |
Subject to Sales Tax? |
Text |
1 |
(Y)es or (N)o only. |
||
AB |
Use_Tax_Flag |
Subject to Use Tax? |
Text |
1 |
(Y)es or (N)o only. |
||
AC |
Commission_Flag |
Commissions? |
Text |
1 |
(Y)es or (N)o only. |
||
AD |
Mix_Flag |
Auto-create Mix? |
Text |
1 |
(Y)es or (N)o only. |
||
AE |
Status_Discontinue_Flag |
Status |
Text |
1 |
(A)ctive, (D)iscontinued or (N)ot used. Defaults to Active if blank. |
||
AF |
Date_Discontinued |
Discontinued Date |
Date |
10 |
Enter as: MM/DD/CCYY (that is, 01/05/00) |
||
AG |
Warehouse_Code |
Default Warehouse |
Text |
10 |
If Installation option 'One warehouse' is not selected and field is left blank then all warehouses will be setup. If 'One warehouse' selected and no default warehouse then field is required. |
Warehouse File Maintenance |
|
AH |
Location |
Item Location |
Text |
10 |
Required if I/C Installation screen is set to Y to Validate Item Location. Otherwise this is a user-defined field. |
||
AI |
Reorder_Point |
Item Reorder Point |
Numeric |
7 |
No decimals. Whole numbers. |
||
AJ |
Reorder_Quantity |
Item Suggested Quantity |
Numeric |
7 |
No decimals. Whole numbers. |
||
AK |
Exclude_SI_Ticket |
Exclude from scale ticket quantity? |
Text |
1 |
(Y)es or (N)o only. |
||
AL |
Exclude_SI_Freight |
Exclude from freight quantity? |
Text |
1 |
(Y)es or (N)o only. |