Manual

Appendix A
Data Structure
377
The Inventory by Location Table holds actual quantity, sites and locations.
Shows where items are stored.
Lot Yes/PKey Text 15 Lot (Empty field allowed if not using
Lots)
ExpDate Yes/PKey Date/
Time
8 Expiration Date (#1/1/20#) is not using
ItemID Yes/PKey Text 25 ID for Check Out Item (Empty if not
using)
QTY Yes Cur-
rency
8 Quantity Stocked Location
ID No Text 12 ID of Last Physical Inventory or Move
DATE No Date/
Time
8 Last Physical Count or Move Date
TIME No Date/
Time
8 Time of Last Logged Transaction
IMP QTY No Cur-
rency
8 Used with the Import & Compare Func-
tion
CheckOutItem No Yes/No 2 Is This a Check Out Item?
CheckedOut No Yes/No 2 Is This item Checked Out?
CheckOutDate Yes Date/
Time
8 Date item was Checked Out
CheckOutTime No Date/
Time
8 Time item was Checked Out
DueBackDate No Date/
Time
8 Date Item is Due Back (i.e., 10/15/96))
DueBackTime No Date/
Time
8 Time Item is Due Back (i.e., 04:15 PM)
SerialNumber No Text 30 Serial Number of Check Out Item
User1 No Text 25 User Defined Field 1
User2 No Text 25 User Defined Field 2
User3 No Text 25 User Defined Field 3
User4 No Text 25 User Defined Field 4
Account No Text 20 Account Checked Out to
Department No Text 20 Department Checked Out To
TABLE 14. Inventory by Location Table
Field Name Req’d
Data
Type
Field
Size Description
2283.book Page 377 Thursday, July 9, 2009 11:26 AM