KS_WAREHOUSE_ITEMS
|
Ordinal |
Data Description |
Data Type |
Data Length |
Required |
Check |
Comments |
|---|---|---|---|---|---|---|
|
1 |
Item ID |
string |
25 |
Y |
|
The part number in the ERP system |
|
2 |
Warehouse ID |
string |
5 |
Y |
|
The site ID (warehouse/branch) in which customers relate and inventory is tracked |
|
3 |
Warehouse Name |
string |
50 |
|
|
If the Warehouse ID passed does not exist, it will be created automatically and use this field for the warehouse name. |
|
4 |
Price Sheet |
string |
30 |
|
|
The pricing system stores base prices by price sheet and by basis. Some ERP systems (e.g. Eclipse) reference a price sheet for each branch (warehouse site) and customers are assigned to the branch. |
|
5 |
Standard Cost |
money |
|
|
|
|
|
6 |
Average Cost |
money |
|
|
|
|
|
7 |
Last Cost |
money |
|
|
|
|
|
8 |
Landed Cost |
money |
|
|
|
|
|
9 |
Average Landed Cost |
money |
|
|
|
|
|
10 |
Frozen Average Cost |
money |
|
|
|
|
|
11 |
Frozen Last Cost |
money |
|
|
|
|
|
12 |
Frozen Average Last Cost |
money |
|
|
|
|
|
13 |
Frozen Landed Cost |
money |
|
|
|
|
|
14 |
Cost UOM Factor |
integer |
|
|
|
Default value is (1). |
|
15 |
Cost Per UOM |
string |
10 |
|
|
Default value is ('EA'). |
|
16 |
Frozen Cost UOM Factor |
integer |
|
|
|
|
|
17 |
Frozen Cost Per UOM |
string |
10 |
|
|
|