Intellitrack Check In/Out Manual do Utilizador Página 405

  • Descarregar
  • Adicionar aos meus manuais
  • Imprimir
  • Página
    / 474
  • Índice
  • MARCADORES
  • Avaliado. / 5. Com base em avaliações de clientes
Vista de página 404
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
Vista de página 404
1 2 ... 400 401 402 403 404 405 406 407 408 409 410 ... 473 474

Comentários a estes Manuais

Sem comentários