Intellitrack Inventory Management Manual do Utilizador descarregar pdf (Página 265)

100

101

Appendix A

Data Structure

239

Bin Location Table

Definition table for Locations where items can be stored. Can be different

for each site.

ItemID Yes/PKey Text 25 ID for Check Out Item

(Empty if not using)

QTY Yes Currency 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 Trans-

action

IMP QTY No Currency 8 Used with the Import & Com-

pare Function

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 12. Inventory by Location Table (Continued)

Field Name Req’d Data Type Field Size Description

2287.book Page 239 Thursday, July 7, 2011 4:45 PM

1 2 ... 260 261 262 263 264 265 266 267 268 269 270 ... 365 366

Comentários a estes Manuais

Sem comentários

Intellitrack Inventory Management Manual do Utilizador Página 265

Comentários a estes Manuais

Manuais e produtos relacionados com Software Intellitrack Inventory Management