KS_WAREHOUSE_ITEMS

Ordinal

Data Description

Data Type

Data Length

Required

Check
Constraints

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.