[an error occurred while processing this directive]

Chapter 2

Core Databases

Administration

AdminSessions
File: admsess.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
session_id
CHAR( 40 )
Unique identifier generated by the system.

user_id
NUMBER
Unique identifier generated by the system.

lastupdate
CHAR( 10 )
A unique time identifier generated by the system.

Index
Index
Index File
Expression
Flags
Index1
ads_sess.mvx
AdminSessions.d.session_id
nounique, ascending, string

Attributes

Database: attr.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
id
NUMBER
Unique attribute identifier generated by the system.
baskopts.dbf/attr_id
opts.dbf/attr_id
ordopts.dbf/attr_id
product_id
NUMBER
Unique product identifier to which this attribute belongs.
products.dbf/id
default_id
NUMBER
Unique identifier for the default option.

order
NUMBER
Order of appearance of this attribute.

code
CHAR( 50 )
Attribute code entered by a store manager (or user with appropriate privileges).
baskopts.dbf/attr_code
type
CHAR( 20 )
Type of selector: Radio button (radio), drop-down list (select), checkbox, text field (text), or text area (memo).

prompt
MEMO
Text entered as customer prompt by a store manager (or user with appropriate privileges).

price
NUMBER (10.2 )
Additional price for this attribute.

cost
NUMBER (10.2 )
Attribute cost (e.g. wholesale).

required
BOOL
Whether or not this is a required attribute.

image
CHAR( 254)
Path for an image.

Index: attr.dbf
Index
Index File
Expression
Flags
Index1
atr_id.mvx
Attributes.d.id
unique, ascending
Index2
atr_code.mvx
Attributes.d.product_id $ ':' $ toupper( Attributes.d.code )
nounique, ascending
Index3
atr_prod.mvx
Attributes.d.product_id $ ':' $ padl( Attributes.d.order, 10, '0' )
nounique, ascending

Availability

AvailabilityGroups

File: avlgrps.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
id
NUMBER
Unique identifier generated by the system.
agpxcat.dbf/agrp_id
agpxcst.dbf/agrp_id
agpxprod.dbf/agrp_id
name
CHAR( 40 )
Availability Group Name

Index
Index
Index File
Expression
Flags
Index1
agrp_id.mvx
AvailabilityGroups.d.id
unique, ascending
Index2
agrp_nm.mvx
toupper( AvailabilityGroups.d.name )
nounique, ascending, string

AvailabilityGroupXCategory

File: agpxcat.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
agrp_id
NUMBER
Unique identifier generated by the system.
avlgrps.dbf/id
cat_id
NUMBER
Unique identifier generated by the system.
cats.dbf/id

Index
Index
Index File
Expression
Flags
Index1
agxc_grp.mvx
AvailabilityGroupXCategory.d.agrp_id $ ':' $ padl( AvailabilityGroupXCategory.d.cat_id, 10, '0' )
nounique, ascending
Index2
agxc_cat.mvx
AvailabilityGroupXCategory.d.cat_id
nounique, ascending
Index3
agxc_gct.mvx
AvailabilityGroupXCategory.d.agrp_id $ ':' $ AvailabilityGroupXCategory.d.cat_id
nounique, ascending

AvailabilityGroupXCustomer

File: agpxcst.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
agrp_id
NUMBER
Unique identifier generated by the system.
avlgrps.dbf/id
cust_id
NUMBER
Unique identifier generated by the system.
customer.dbf/id

Index
Index
Index File
Expression
Flags
Index1
agxct_ct.mvx
AvailabilityGroupXCustomer.d.cust_id
nounique, ascending
Index2
agxct_gp.mvx
AvailabilityGroupXCustomer.d.agrp_id $ ':' $ padl( AvailabilityGroupXCustomer.d.cust_id,10, '0' )
nounique, ascending

AvailabilityGroupXProduct

File: agpxprod.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
agrp_id
NUMBER
Unique identifier generated by the system.
avlgrps.dbf/id
product_id
NUMBER
Unique identifier generated by the system.
products.dbf/id

Index
Index
Index File
Expression
Flags
Index1
agxp_grp.mvx
AvailabilityGroupXProduct.d.agrp_id $ ':' $ padl( AvailabilityGroupXProduct.d.product_id,10, '0' )
nounique, ascending
Index2
agxp_prd.mvx
AvailabilityGroupXProduct.d.product_id
nounique, ascending
Index3
agxp_gpd.mvx
AvailabilityGroupXProduct.d.agrp_id $ ':' $ AvailabilityGroupXProduct.d.product_id
nounique, ascending

Baskets

BasketCharges

Database: baskchrg.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
basket_id
NUMBER
Unique basket identifier generated by the system.
baskets.dbf/id
charge_id
NUMBER
Unique identifier generated by the system.

module_id
NUMBER
Unique identifier of the module that created that created the record.

type
CHAR( 50 )
Classification of this charge. (For example "shipping" or "tax." )

desc
CHAR( 100 )
Description of this charge.

amount
NUMBER( 10.2 )
Amount of this charge (which is added to Total).

disp_amt
NUMBER( 10.2 )
Amount displayed only, and not added to total.

tax_exempt
BOOL
Whether or not this charge is tax exempt.

Index: baskchrg.dbf
Index
Index File
Expression
Flags
Index1
bchg_bid.mvx
BasketCharges.d.basket_id $ ':' $ padl(BasketCharges.d.charge_id, 10, '0')
unique, ascending, string
Index2
bchg_typ.mvx
BasketCharges.d.basket_id $ ':' $ BasketCharges.d.type $ ':' $ padl(BasketCharges.d.charge_id, 10, '0')
unique, ascending, string
Index3
bchg_mod.mvx
BasketCharges.d.basket_id $ ':' $ BasketCharges.d.module_id $ ':' $ padl(BasketCharges.d.charge_id, 10, '0')
unique, ascending, string

BasketList

Database: basklist.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
session_id
CHAR( 40 )
Unique identifier generated by the system.

cust_id
NUMBER
Unique identifier generated by the system.
customer.dbf/id
basket_id
NUMBER
Unique identifier generated by the system.
baskets.dbf/id
lastupdate
CHAR( 10 )
A unique time identifier generated by the system (used with Basket Timeout).

order_id
NUMBER
Unique identifier generated by the system.

order_proc
BOOL
Whether or not the order has been processed.

ship_fname
CHAR( 50 )
First Name

ship_lname
CHAR( 50 )
Last Name

ship_email
CHAR( 50 )
Email Address

ship_comp
CHAR( 50 )
Company

ship_phone
CHAR( 50 )
Phone Number

ship_fax
CHAR( 50 )
Fax Number

ship_addr
CHAR( 100 )
Address

ship_city
CHAR( 50 )
City

ship_state
CHAR( 50 )
State/Province or Other State/Province

ship_zip
CHAR( 50 )
Zip/Postal Code

ship_cntry
CHAR( 50 )
Country

bill_fname
CHAR( 50 )
First Name

bill_lname
CHAR( 50 )
Last Name:

bill_email
CHAR( 50 )
Email Address

bill_comp
CHAR( 50 )
Company

bill_phone
CHAR( 50 )
Phone Number

bill_fax
CHAR( 50 )
Fax Number

bill_addr
CHAR( 100 )
Address

bill_city
CHAR( 50 )
City

bill_state
CHAR( 50 )
State/Province or Other State/Province

bill_zip
CHAR( 50 )
Zip/Postal Code

bill_cntry
CHAR( 50 )
Country

tax
NUMBER( 10.2 )
Enter State/County Sales Tax

shipping
NUMBER( 10.2 )
Identifier for the shipping type (UPS, etc.)

ship_id
NUMBER
Unique shipping module identifier.

ship_data
CHAR( 100 )
Value provided by the shipping module.

pay_id
NUMBER
Unique payment module identifier.

pay_data
CHAR( 100 )
Value provided by the payment module.

total
NUMBER( 10.2 )
Total price of all charges.

Index
Index
Index File
Expression
Flags
Index1
blst_ses.mvx
BasketList.d.session_id
nounique, ascending, string

BasketOptions

Database: baskopts.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
line_id
NUMBER
Line number identifier of the product within the basket.
baskets.dbf/line_id
attr_id
NUMBER
Unique attribute identifier generated by the system.
attributes.dbf/id
attr_code
CHAR( 50 )
Attribute code entered by a Store manager (or user with appropriate privileges).
attributes.dbf/code
option_id
NUMBER
Unique option identifier generated by the system.
opts.dbf/id
opt_code
CHAR( 50 )
Option code entered by a Store manager (or user with appropriate privileges).
opts.dbf/code
price
NUMBER( 10.2 )
Options price.

data
CHAR( 254 )
Data entered by customer for options (such as text for a monogram, name on a T-shirt, etc.) into the Text field.

data_long
MEMO
Data entered by customer for options into the Text Area.

Index
Index
Index File
Expression
Flags
Index1
bopt_ln.mvx
BasketOptions.d.line_id $ ':' $ padl( BasketOptions.d.attr_id, 10, '0' )
nounique, ascending

Baskets

Database: baskets.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
id
NUMBER
Unique basket identifier generated by the system.
baskchrg.dbf/basket_id
basklist.dbf/basket_id
line_id
NUMBER
Identifier for the line number of product within the basket.
baskopts.dbf/line_id
product_id
NUMBER
Unique identifier generated by the system.
products.dbf/id
code
CHAR( 50 )
Product Code (entered by a Store manager (or user with appropriate privileges).

name
CHAR( 100 )
Product Name.

price
NUMBER( 10.2 )
Product Price.

weight
NUMBER( 10.2 )
Product Weight.

taxable
BOOL
Identifies whether or not the product is taxable.

upsold
BOOL
Identifies whether or not the product is an upsale.

quantity
NUMBER
Quantity (of this product) added to basket

Index: baskets.dbf
Index
Index File
Expression
Flags
Index1
bsk_id.mvx
Baskets.d.id $ ':' $ padl( Baskets.d.line_id, 10, '0' )
nounique, ascending
Index2
bsk_line.mvx
Baskets.d.line_id
unique, ascending

Batches

Batches
Database: batches.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
id
NUMBER
Unique identifier generated by the system.

date
CHAR( 10 )
Date on which a Store manager (or user with appropriate privileges) created batch.

name
CHAR( 100 )
Name of batch entered by a Store manager (or user with appropriate privileges).

closed
BOOL
Identifies whether or not the batch has been processed.

Index
Index
Index File
Expression
Flags
Index1
bch_id.mvx
Batches.d.id
unique, ascending
Index2
bch_clsd.mvx
Batches.d.closed $ ':' $ padl( Batches.d.id, 10, '0' )
nounique, ascending

Category

Categories

Database: cats.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
id
NUMBER
Unique category identifier generated by the system.
catxprod.dbf/cat_id
agpxcat.dbf/cat_id
parent_id
NUMBER
Unique parent category identifier generated by the system.

agrpcount
NUMBER
Number of availability groups to which this category belongs.

order
NUMBER
Order of appearance for category.

code
CHAR (50 )
Category code assigned by store manager (or user with appropriate privileges).

name
CHAR (100 )
Category name.

active
BOOL
Whether or not the category is active, as identified by store manager (or user with appropriate rights).

Index: cats.dbf
Index
Index File
Expression
Flags
Index1
cat_id.mvx
Categories.d.id
unique, ascending
Index2
cat_code.mvx
toupper (Categories.d.code)
nounique, ascending, string
Index3
cat_prnt.mvx
Categories.d.parent_id $ ':' $ padl (Categories.d.order, 10, '0')
nounique, ascending
Index4
cat_ord.mvx
padl (Categories.d.order, 10, '0')
nounique, ascending

CategoryXProduct

Database: catxprod.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
cat_id
NUMBER
Unique category identifier generated by the system.
cats.dbf/id
product_id
NUMBER
Unique product identifier generated by the system.
products.dbf/id
order
NUMBER
Order of appearance of this product within this category.

Index
Index
Index File
Expression
Flags
Index1
cxp_cat.mvx
CategoryXProduct.d.cat_id $ ':' $ padl( CategoryXProduct.d.order, 10, '0' )
nounique, ascending
Index2
cxp_prod.mvx
CategoryXProduct.d.product_id
nounique, ascending
Index3
cxp_cprd.mvx
CategoryXProduct.d.cat_id $ ':' $ CategoryXProduct.d.product_id
nounique, ascending

Countries

Countries
File: country.dbf
Module:lib\db.m
Fields
Type
Field Description
Related Database/Field
id
NUMBER
Unique identifier generated by the system.

name
CHAR( 50 )
Name of country.

alpha
CHAR( 2 )
Two-letter abbreviation.

numeric
NUMBER
ISO in country code.

Index
Index
Index File
Expression
Flags
Index1
cntry_i.mvx
countries.d.id
unique, ascending, string
Index2
cntry_a.mvx
countries.d.alpha
nounique, ascending, string
Index3
cntry_n.mvx
toupper( countries.d.name)
nounique, ascending, string

Customers

Customers

Database: customer.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
id
NUMBER
Unique product identifier generated by the system.
agpxcst.dbf/cust_id
pgpxcust.dbf/cust_id
orders.dbf/cust_id
basklist.dbf/cust_id
pgrpcount
NUMBER
Count of price groups to which this customer belongs.

login
CHAR( 50 )
Login name

pw_email
CHAR( 50 )
Email Lost Passwords To

password
CHAR( 40 )
Password name

ship_fname
CHAR( 50 )
First Name

ship_lname
CHAR( 50 )
Last Name

ship_email
CHAR( 50 )
Email Address

ship_comp
CHAR( 50 )
Company

ship_phone
CHAR( 50 )
Phone Number

ship_fax
CHAR( 50 )
Fax Number

ship_addr
CHAR( 100 )
Address

ship_city
CHAR( 50 )
City

ship_state
CHAR( 50 )
State/Province

ship_zip
CHAR( 50 )
Zip/Postal Code

ship_cntry
CHAR( 50 )
Country

bill_fname
CHAR( 50 )
First Name

bill_lname
CHAR( 50 )
Last Name

bill_email
CHAR( 50 )
Email Address

bill_comp
CHAR( 50 )
Company

bill_phone
CHAR( 50 )
Phone Number

bill_fax
CHAR( 50 )
Fax Number

bill_addr
CHAR( 100 )
Address

bill_city
CHAR( 50 )
City

bill_state
CHAR( 50 )
State/Province

bill_zip
CHAR( 50 )
Zip/Postal Code

bill_cntry
CHAR( 50 )
Country

Index: customer.dbf
Index
Index File
Expression
Flags
Index1
cust_id.mvx
Customers.d.id
unique, ascending
Index2
cust_lgn.mvx
toupper( Customers.d.login )
nounique, string, ascending

CustomerEmail
File: custeml.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
from
char( 254 )
From

cc
char( 254 )
CC:

subject
char( 254 )
Subject

header
memo
Header (Precedes Order Information):

Domain

Domain
File: domain.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
name
CHAR( 100 )
Domain name.

license
CHAR( 25 )
Miva Merchant's license for the domain.

version
CHAR( 10 )
Miva Merchant version.

owner
CHAR( 100 )
Store owner's name.

email
CHAR( 50 )
Store owner's email.

company
CHAR( 100 )
Store owner's company.

address
CHAR( 100 )
Store owner's address.

city
CHAR( 50 )
Store owner's city.

state
CHAR( 50 )
Store owner's state.

zip
CHAR( 50 )
Store owner's zip.

country
CHAR( 50 )
Store owner's country.

phone
CHAR( 50 )
Store owner's phone.

fax
CHAR( 50 )
Store owner's fax.

mm_url
CHAR( 254 )
Non-secure URL to Miva Merchant.

mm_surl
CHAR( 254 )
Secure URL to Miva Merchant.

admin_surl
CHAR( 254 )
Secure URL to Administration.

image_root
CHAR( 254 )
Root Directory for Graphics.

base_url
CHAR( 254 )
Base URL for Graphics.

base_surl
CHAR( 254 )
Secure Base URL for Graphics.

mod_root
CHAR( 254 )
Root Directory for Modules.

mod_sroot
CHAR( 254 )
Secure Root Directory for Modules.

admexp
NUMBER
Administration Session Timeout (in minutes).

mailhost
CHAR ( 254 )
Mail Server.

mail_angl
BOOL
Whether or not to add angle brackets to email addresses.

ui_id
NUMBER


Groups

Groups
File: groups.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
id
NUMBER
Unique group identifier generated by the system.
grppriv.dbf/group_id
usrxgrp.dbf/user_id
name
CHAR( 40 )
Group Name (of User Group).

Index
Index
Index File
Expression
Flags
Index1
grp_id.mvx
Groups.d.id
unique, ascending
Index2
grp_name.mvx
toupper( Groups.d.name )
nounique, ascending, string

GroupPrivileges
File: grppriv.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
group_id
NUMBER
Unique group identifier generated by the system.
groups.dbf/id
privilege
CHAR( 20 )
Abbreviated name of privilege.
privs.dbf/privilege
view
BOOL
Whether or not the user can view specified area.

add
BOOL
Whether or not the user can add to specified area.

modify
BOOL
Whether or not the user can modify specified area.

delete
BOOL
Whether or not the user can delete specified area.

Index: grppriv.dbf
Index
Index File
Expression
Flags
Index1
grppriv.mvx
GroupPrivileges.d.group_id $ ':' $ GroupPrivileges.d.privilege
nounique, ascending

Keys

Keys
File: keys.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
type
CHAR( 50 )
Unique identifier generated by the system.

maxvalue
NUMBER
Maximum number of the unique identifier generated by the system.

Index
Index
Index File
Expression
Flags
Index1
keys.mvx
Keys.d.type
unique, ascending

Modules

Modules
File: modules.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
id
NUMBER
Unique module identifier generated by the system.

type
CHAR( 15 )
Type of module (entered by module developer).

code
CHAR( 50 )
Code for module (entered by module developer).

name
CHAR( 100 )
Module name.

provider
CHAR( 100 )
Name of company/developer of module.

version
CHAR( 20 )
Module version.

module
CHAR( 100 )
File name.

refcount
NUMBER
Number of stores using this module, generated by the system.

Index
Index
Index File
Expression
Flags
Index1
mod_id.mvx
Modules.d.id
unique, ascending
Index2
mod_code.mvx
Modules.d.code
nounique, ascending, string
Index3
mod_type.mvx
Modules.d.type
nounique, ascending

Options

Options

Database: opts.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
id
NUMBER
Unique option identifier generated by the system.
attr.dbf/default_id
baskopts.dbf/id
ordopts.dbf/option_id
attr_id
NUMBER
Attribute ID to which this option belongs, generated by the system.
attr.dbf/id
baskopts.dbf/attr_id
order
NUMBER
Order of appearance of this option.

code
CHAR( 50 )
Option code entered by a store manager (or user with appropriate privileges).
baskopts.dbf/opt_code
prompt
MEMO
Text entered as customer prompt by a store manager (or user with appropriate privileges).

price
NUMBER (10.2 )
Additional price for this option.

cost
NUMBER (10.2 )
Option cost (e.g. wholesale).

image
CHAR( 254 )
Path for an image.

Index: opts.dbf
Index
Index File
Expression
Flags
Index1
opt_id.mvx
Options.d.id
unique, ascending
Index2
opt_code.mvx
Options.d.attr_id $ ':' $ toupper( Options.d.code )
nounique, ascending
Index3
opt_attr.mvx
Options.d.attr_id $ ':' $ padl( Options.d.order, 10, '0' )
nounique, ascending

Orders

Orders

Database: orders.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
id
NUMBER
Unique identification, entered by Miva Merchant
orditems.dbf/order_id
ordrchrg.dbf/order_id
batch_id
NUMBER
Unique batch identification
batches.dbf/id
processed
BOOL
Indicates whether Order has been processed or not.

date
CHAR( 10 )
Date order was placed

cust_id
NUMBER

customer.dbf/id
ship_fname
CHAR( 50 )
First Name

ship_lname
CHAR( 50 )
Last Name

ship_email
CHAR( 50 )
Email Address

ship_comp
CHAR( 50 )
Company

ship_phone
CHAR( 50 )
Phone Number

ship_fax
CHAR( 50 )
Fax Number

ship_addr
CHAR( 100 )
Address

ship_city
CHAR( 50 )
City

ship_state
CHAR( 50 )
State/Province or Other State/Province

ship_zip
CHAR( 50 )
Zip/Postal Code

ship_cntry
CHAR( 50 )
Country

bill_fname
CHAR( 50 )
First Name

bill_lname
CHAR( 50 )
Last Name

bill_email
CHAR( 50 )
Email Address

bill_comp
CHAR( 50 )
Company

bill_phone
CHAR( 50 )
Phone Number

bill_fax
CHAR( 50 )
Fax Number

bill_addr
CHAR( 100 )
Address

bill_city
CHAR( 50 )
City

bill_state
CHAR( 50 )
State/Province or Other State/Province

bill_zip
CHAR( 50 )
Zip/Postal Code

bill_cntry
CHAR( 50 )
Country

tax
NUMBER( 10.2 )
Enter State/County Sales Tax

shipping
NUMBER( 10.2 )
Identifier for the type of shipping

ship_id
NUMBER
Unique shipping module identifier.

ship_data
CHAR( 100 )
Value provided by the shipping module.

pay_id
NUMBER
Unique payment module identifier.

pay_data
CHAR( 100 )
Value provided by the payment module.

total
NUMBER( 10.2 )
Total (cost of order)

Index
Index
Index File
Expression
Flags
Index1
ord_id.mvx
Orders.d.id
unique, ascending
Index2
ord_btch.mvx
Orders.d.batch_id $ ':' $ padl( Orders.d.id, 10, '0' )
nounique, ascending
Index3
ord_prcd.mvx
Orders.d.batch_id $ ':' $ Orders.d.processed $ ':' $ padl( Orders.d.id, 10, '0' )
nounique, ascending

OrderCharges

Database: ordrchrg.dbf
Module:
Fields
Type
Field Description
Related Database/Field
order_id
NUMBER
Unique identifier generated by the system.
orders.dbf/id
charge_id
NUMBER
Unique identifier generated by the system.

module_id
NUMBER
Unique identifier of the module that created the record.

type
CHAR( 50 )
Classification of this charge. (For example "shipping" or "tax." )

desc
CHAR( 100 )
Description of this charge.

amount
NUMBER( 10.2 )
Amount of this charge (which is added to Total).

disp_amt
NUMBER( 10.2 )
Amount displayed only, and not added to Total.

tax_exempt
BOOL
Whether or not this charge is tax exempt.

Index
Index
Index File
Expression
Flags
Index1
ochg_oid.mvx
OrderCharges.d.order_id $ ':' $ padl(OrderCharges.d.charge_id, 10, '0')
unique, ascending, string
Index2
ochg_typ.mvx
OrderCharges.d.order_id $ ':' $ OrderCharges.d.type $ ':' $ padl(OrderCharges.d.charge_id, 10, '0')
unique, ascending, string
Index3
ochg_mod.mvx
OrderCharges.d.order_id $ ':' $ OrderCharges.d.module_id $ ':' $ padl(OrderCharges.d.charge_id, 10, '0')
unique, ascending, string

OrderItems

Database: orditems.dbf
Module: lib\db.m
Fields
Type
Field Description
Related Database/Field
order_id
NUMBER
Unique identifier.
ordopts.dbf/line_id
line_id
NUMBER
Identifier for line # within order.
orders.dbf/id
product_id
NUMBER
Unique identifier.

code
CHAR( 50 )
Product code entered by a store manager (or user with appropriate privileges).

name
CHAR( 100 )
Product name.

price
NUMBER( 10.2 )
Product unit price.

weight
NUMBER( 10.2 )
Product unit weight.

taxable
BOOL
Whether product is taxable or not.

upsold
BOOL
Whether product is an upsell or not.

quantity
NUMBER
Quantity of this product ordered.

Index (for orditems.dbf)
Index
Index File
Expression
Flags
Index1
oit_ord.mvx
OrderItems.d.order_id $ ':' $ padl( OrderItems.d.line_id, 10, '0' )
nounique, ascending

OrderOptions

</