| INVENTORY |
| |
Inventory items are the physical entities used in the repair or servicing of the items. They can be stocked or non-stocked. Each time and inventory item is used, the reorder point is checked (reord) and if needed the user is prompted to issue a purchase order. If they choose to do this, an entry is made into the purchord file.
Likewise, when inventory arrives the purchord file is checked and the purchase order received information updated.
Memos are available for notes about the the use of the item. For items that can expire, a useby date is available for each item.
|
| |
| INVENTORY |
1 record for each item used, stock or nonstock |
|
item |
c |
20 |
|
|
item name |
|
descrip |
c |
200 |
|
|
if needed further description of item |
|
notes |
m |
|
|
|
Memo for longer explanations, hints, … |
|
stock |
c |
|
|
|
YES/NO |
|
qoh |
n |
9 |
2 |
|
Quantity On Hand |
|
orderqty |
n |
9 |
2 |
|
typical order quantity |
|
cost |
n |
9 |
2 |
|
cost per unit |
|
price |
n |
9 |
2 |
|
price charged to client |
|
unit |
c |
5 |
|
|
unit type: each, pair, sq.inch |
|
useby |
d |
|
|
|
must be used by date |
|
vendor |
c |
20 |
|
|
default vendor |
|
altvendor |
c |
20 |
|
|
alternate vendor |
|
reord |
n |
9 |
2 |
|
reorder point |
|
location |
c |
20 |
|
|
storage location |
| notes |
|
|
|
|
|
|
field layout will changes as we get deeper into field best needed |
|
| |
| PURCHORD |
Purchase order info for this system, can point to outside system |
|
item |
c |
20 |
|
|
relates to INVENTORY |
|
orderno |
n |
6 |
|
|
order number |
|
outordno |
c |
20 |
|
|
Order number for outside PO System |
|
vendor |
c |
20 |
|
|
|
|
|
qty |
n |
9 |
2 |
|
quantity ordered |
|
date |
d |
|
|
|
date ordered |
|
expected |
d |
|
|
|
date expected |
|
daterecv |
d |
|
|
|
date received |
|
placedby |
c |
10 |
|
|
order placed by loginid |
| notes |
|
|
|
|
|
|
|
we'll track expected dates and received dates to predict inventory levels |
|
| |
|