4 location table properties, Inventory – Wasp Barcode Inventory Control User Manual

Page 287

Advertising
background image

InventoryControl Printable Help

Pallet (Track By?)

char

1

PO (Required?)

char

1

Reorder Qty

decimal

9(15,4)

Sale Price

money

8

Serial Number (Track

By?)

char

1

Supplier (Required?)

char

1

Supplier Code

varchar

30

Supplier Name

varchar

50

Unit of Measure

varchar

10

Weight

varchar

50

Weight Unit

varchar

50

Width

varchar

50

16.4.4 Location Table Properties:

Field Name

Data Type

Size (Precision,

Scale)

Custom Date 1

datetime

8

Custom Date 2

datetime

8

Custom Date 3

datetime

8

Custom Date 4

datetime

8

Custom Date 5

datetime

8

Custom Number 1

decimal

9(15,4)

Custom Number 2

decimal

9(15,4)

Custom Number 3

decimal

9(15,4)

Custom Number 4

decimal

9(15,4)

Custom Number 5

decimal

9(15,4)

Custom Text 1

varchar

100

Custom Text 2

varchar

100

Custom Text 3

varchar

100

Custom Text 4

varchar

100

Custom Text 5

varchar

100

Custom Text 6

varchar

100

Custom Text 7

varchar

100

Custom Text 8

varchar

100

Custom Text 9

varchar

100

Custom Text 10

varchar

100

Description

varchar

255

Location

varchar

30

Notes

varchar

1000

Site

varchar

50

272

Advertising