The following is useful information for more advanced uses of AnyOrder. It describes the structure of the Item Database. These are the items that are listed on the invoice.
Fields data for Orders.dbf. This is the file that holds the Items listed on the Invoice. It consists of quantities, catalog numbers, item descriptions and prices. It is related to Sales.dbf by Invoice Number.
Orders.dbf
Purpose: Holds the items which are listed on the invoice
Relation: Related to Sales.dbf by the field Invoice_No
|
|
|
|
|
|
|
|
|
|
|
|
Field
|
Field Name
|
Type
|
Length
|
Dec
|
Description
|
1
|
INVOICE_NO
|
NUMERIC
|
6
|
|
Invoice number - relates to Invoice_no in Sales.dbf
|
2
|
QUAN
|
NUMERIC
|
6
|
|
Quantity
|
3
|
CATALOG_NO
|
CHARACTER
|
13
|
|
Catalog number, SKU
|
4
|
STATUS
|
CHARACTER
|
1
|
|
S=Sale, R=Return, M=Credit Memo, D=Damaged, F=Fees, C=Consigned, B=Backordered, P=Promotional, X=Backorder Item Shipped N=No longer available,
|
5
|
ITEM
|
CHARACTER
|
36
|
|
Description of item
|
6
|
PRICE
|
NUMERIC
|
9
|
2
|
Price of item
|
7
|
TOTAL
|
NUMERIC
|
10
|
2
|
Quantity X Price
|
8
|
DISCOUNT
|
NUMERIC
|
10
|
7
|
Discount
|
9
|
PRICING
|
NUMERIC
|
1
|
|
Pricing Level
|
10
|
MEASURED
|
NUMERIC
|
10
|
3
|
Used for items that are sold by measured quantities: length, weight & volume
|
11
|
MARKED
|
LOGICAL
|
1
|
|
Internal use - used for selecting purposes
|
|
|
|
--------
|
|
|
|
Total
|
|
104
|
|
|
|