The following is useful information for more advanced uses of AnyOrder. It describes the structure of the Product Database.
Fields data for Cat_no.dbf, the product information database. It holds all the information that appears on the Product Information Screen including catalog numbers, item names, cost, etc.
Cat_no.dbf
Purpose: Product Database - holds all information related to products
|
|
|
|
|
|
|
|
|
|
|
|
Field
|
Field Name
|
Type
|
Length
|
Dec
|
Description
|
1
|
CATALOG_NO
|
CHARACTER
|
13
|
|
Catalog Number or SKU
|
2
|
ISBN
|
CHARACTER
|
15
|
|
ISBN Number (or part number)
|
3
|
ISBNYES
|
LOGICAL
|
1
|
|
If False, the number in the ISBN Number field is part number and not an ISBN Number
|
4
|
ITEM
|
CHARACTER
|
36
|
|
Description of the item
|
5
|
PRICE
|
NUMERIC
|
8
|
2
|
Retail price of the item
|
6
|
COST
|
NUMERIC
|
8
|
2
|
Cost of the item
|
7
|
CURRENT_YR
|
DATE
|
8
|
|
Not used
|
8
|
TEMPOUT
|
LOGICAL
|
1
|
|
If true, the item is temporarily out of stock
|
9
|
OUTFORGOOD
|
LOGICAL
|
1
|
|
if true, the item is permanently out of stock
|
10
|
INSTOCKBY
|
DATE
|
8
|
|
The item will be in stock by this date
|
11
|
CHANGED
|
LOGICAL
|
1
|
|
Not used
|
12
|
NOTES
|
MEMO
|
10
|
|
Memo field - user can write notes about the product here
|
13
|
WEIGHTLB
|
NUMERIC
|
3
|
|
Weight of one unit of the product in lbs
|
14
|
WEIGHTOZ
|
NUMERIC
|
2
|
|
Number of ounces
|
15
|
WEIGHTNA
|
LOGICAL
|
1
|
|
This product doesn't have weight
|
16
|
CASESIZE
|
NUMERIC
|
8
|
|
Number of units in a case
|
17
|
OTHERDESC
|
CHARACTER
|
5
|
|
Can be used for color, size, etc.
|
18
|
WEIGHTKG
|
NUMERIC
|
7
|
3
|
Weight in Kg's
|
19
|
RSELECTED
|
LOGICAL
|
1
|
|
Internally used by the program
|
20
|
PRICE1
|
NUMERIC
|
8
|
2
|
Price level 1 pricing
|
21
|
PRICE2
|
NUMERIC
|
8
|
2
|
Price level 2 pricing
|
22
|
PRICE3
|
NUMERIC
|
8
|
2
|
Price level 3 pricing
|
23
|
PRICE4
|
NUMERIC
|
8
|
2
|
Price level 4 pricing
|
24
|
PRICE5
|
NUMERIC
|
8
|
2
|
Price level 5 pricing
|
25
|
PRICE6
|
NUMERIC
|
8
|
2
|
Price level 6 pricing
|
26
|
LOW_LEVEL
|
NUMERIC
|
8
|
|
Trigger a warning message when inventory reaches this level
|
27
|
PKG_LENGTH
|
NUMERIC
|
4
|
|
Package demensions
|
28
|
PKG_WIDTH
|
NUMERIC
|
4
|
|
Package demensions
|
29
|
PKG_HEIGHT
|
NUMERIC
|
4
|
|
Package demensions
|
30
|
UNIT
|
CHARACTER
|
3
|
|
For products sold by weight, length, volume
|
31
|
BARCODE
|
CHARACTER
|
35
|
|
Barcode numbers
|
32
|
AT_LOW_LEV
|
LOGICAL
|
1
|
|
If true, product is at low level inventory
|
33
|
UDF1
|
CHARACTER
|
25
|
|
User Defined Field
|
34
|
UDF2
|
CHARACTER
|
25
|
|
User Defined Field
|
35
|
OTHERDESC2
|
CHARACTER
|
6
|
|
Not used
|
36
|
ITEM2
|
CHARACTER
|
36
|
|
A second description line
|
37
|
REALZERO
|
LOGICAL
|
1
|
|
Include this Product in Real Time Inventory Processing Even if There's No Starting Inventory. More Info
|
38
|
CPRICE1
|
CHARACTER
|
10
|
|
Breakpoint quantity
|
39
|
CPRICE2
|
CHARACTER
|
10
|
|
Breakpoint quantity
|
40
|
CPRICE3
|
CHARACTER
|
10
|
|
Breakpoint quantity
|
41
|
CPRICE4
|
CHARACTER
|
10
|
|
Breakpoint quantity
|
42
|
CPRICE5
|
CHARACTER
|
10
|
|
Breakpoint quantity
|
43
|
CPRICE6
|
CHARACTER
|
10
|
|
Breakpoint quantity
|
|
|
|
______
|
|
|
|
Total
|
|
398
|
|
|
|