Bin location table, Field types, Bin location table field types – IntelliTrack Stockroom Inventory User Manual

Page 337: Bin location table 309, Field types 309

Advertising
background image

Appendix A

Data Structure

309

Bin Location Table

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

Field Types

Following is a brief summary of the field types and size settings for fields
associated with your database tables::

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 13.

Inventory by Location Table (Continued)

Field Name

Req’d

Data Type

Field Size

Description

TABLE 14.

Bin Location Table

Field Name

Req’d

Data

Type

Field

Size

Description

Site

Yes/PKey

Text

18

Site of this Location

BINLOC

Yes/PKey

Text

15

Bin Location Code (Location)

Description

No

Text

25

Description of this Location

UDF1

No

Text

25

User Defined Field Number 1

UDF2

No

Text

25

User Defined Field Number 2

UDF3

No

Text

25

User Defined Field Number 3

UDF4

No

Text

25

User Defined Field Number 4

2289.book Page 309 Thursday, July 9, 2009 2:35 PM

Advertising