beautypg.com

IntelliTrack Stockroom Inventory User Manual

Page 318

background image

I

NTELLI

T

RACK

S

TOCKROOM

V

8.1

User Manual

290

ItemID

Yes/PKey

Text

25

ID for Check Out
Item (Empty if
not using)

QTY

Yes

Currency

8

Quantity
Stocked Loca-
tion

ID

No

Text

12

ID of Last Physi-
cal 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

TABLE 12.

Inventory by Location Table (Continued)

Field Name

Req’d

Data Type

Field Size

Description

2289.book Page 290 Thursday, July 7, 2011 5:10 PM