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. |
|
| remoteaddr
(new in 4.15) |
CHAR( 50 ) |
4.15: The IP address of the administrator for whom the unique session was created. |
|
Index
| Index |
Index File |
Expression |
Flags |
| Index1 |
ads_sess.mvx |
AdminSessions.d.session_id 4.15: AdminSessions.d.session_id $ ':' $ AdminSessions.d.remoteaddr |
nounique, ascending, string |
Affiliate
Affiliates
File: affil.dbf
Module: features\aff\aff_db.mv
| Fields |
Type |
Field Description |
Related Database/Field |
| id |
NUMBER |
Unique identifier of affiliate generated by the system. |
|
| code |
CHAR(50) |
Login |
|
| password |
CHAR(40) |
Password |
|
| lpasseml |
CHAR(254) |
Lost Password Email |
|
| site_name |
CHAR(254) |
Name of affiliate's site |
|
| site_url |
CHAR(254) |
URL of affiliate's site |
|
| con_name |
CHAR(254) |
Contact name |
|
| email |
CHAR(254) |
Email address |
|
| company |
CHAR(50) |
Company |
|
| phone |
CHAR(50) |
Telephone number |
|
| fax |
CHAR(50) |
Fax number |
|
| addr |
CHAR(100) |
Physical address |
|
| city |
CHAR(50) |
City |
|
| state |
CHAR(50) |
State |
|
| zip |
CHAR(50) |
Zip code |
|
| cntry |
CHAR(50) |
Country |
|
| hits |
NUMBER(10.4) |
Commission Per Referral |
|
| percent |
NUMBER(10.2) |
Commission Percent of Order |
|
| flat |
NUMBER(10.2) |
Commission Flat Fee per Order |
|
| lstpay_id |
NUMBER |
User ID who entered most recent payout. |
|
| lstpay_amt |
NUMBER(10.2) |
Amount of most recent payout. |
|
| lstpay_dt |
NUMBER |
Date of most recent payout |
|
| lstpay_by |
NUMBER |
Administrative User ID. |
|
| balance |
NUMBER(10.4) |
Current Balance |
|
| status |
CHAR(10) |
Application Status (Approved, Pending, Disabled). |
|
| status_dt |
NUMBER |
Status Date |
|
| status_by |
NUMBER |
status entered by User ID. |
|
| session_id |
CHAR(40) |
Affiliate Session ID. |
affsess.dbf/session_id |
Index: Affiliates
| Index |
Index File |
Expression |
Flags |
| Index1 |
affil_i.mvx |
Affiliates.d.id |
unique, ascending |
| Index2 |
affil_c.mvx |
toupper( Affiliates.d.code ) |
nounique, ascending, string |
| Index3 |
affil_s.mvx |
Affiliates.d.session_id |
nounique, ascending, string |
AffiliateEarnings
Database: affern.dbf
Module: features\aff\aff_db.mv
| Fields |
Type |
Field Description |
Related Database/Field |
| id |
NUMBER |
Unique identifier, generated by the system. |
|
| aff_id |
NUMBER |
Affiliate ID. |
affil.dbf/id |
| date |
NUMBER |
Date of transaction |
|
| type |
CHAR(10) |
Type of transaction (hit, percent, flat, payout) |
|
| order_id |
NUMBER |
Order number of transaction. |
|
| order_amt |
NUMBER (10.2) |
Amount of order. |
|
| percent |
NUMBER (10.2) |
Commission Percent of Order. |
|
| amount |
NUMBER (10.4) |
Amount earned or paid out. |
|
| void |
BOOL |
Whether or not earning is void |
|
| void_reasn |
CHAR(250) |
Reason entered for voiding earnings. |
|
| void_by |
NUMBER |
Voided by User ID. |
|
| adjst_reas |
CHAR(250) |
Reason entered for adjusting earnings. |
|
| adjst_by |
NUMBER |
Adjusted by User ID. |
|
| payout_id |
NUMBER |
Unique identifier, generated by the system |
|
| ip_address |
CHAR(50) |
IP_Address of Customer sent via affiliate. |
|
Index: Affiliate Earnings
| Index |
Index File |
Expression |
Flags |
| Index1 |
affern_i.mvx |
AffiliateEarnings.d.id |
unique, ascending |
| Index2 |
affern_a.mvx |
AffiliateEarnings.d.aff_id $ ':' $ padl( AffiliateEarnings.d.date, 10, 0 ) |
nounique, ascending |
| Index3 |
affern_p.mvx |
AffiliateEarnings.d.payout_id $ ':' $ padl( AffiliateEarnings.d.aff_id, 10, 0 ) |
nounique, ascending |
AffiliateEmail
Database: afileml.dbf
Module: features\aff\aff_db.mv
| Fields |
Type |
Field Description |
Related Database/Field |
| from |
CHAR(254) |
From |
|
| cc |
CHAR(254) |
CC: |
|
| subject |
CHAR(254) |
Subject |
|
| header |
MEMO |
Header, precedes account information. |
|
(Lost Password Email)
AffiliateManage
Database: afilmng.dbf
Module: features\aff\aff_db.mv
| Fields |
Type |
Field Description |
Related Database/Field |
| active |
BOOL |
Whether or not to activate New Affiliates Email. |
|
| useto |
BOOL |
Whether or not to use Affiliate's Email address. |
|
| usefrom |
BOOL |
Whether or not to use Affiliate's Email address. |
|
| usecc |
BOOL |
Whether or not to use Affiliate's Email address. |
|
| from |
CHAR(254) |
From other |
|
| to |
CHAR(254) |
To other |
|
| cc |
CHAR(254) |
cc other |
|
| subject |
CHAR(254) |
Subject |
|
| header |
MEMO |
Header |
|
AffiliateOptions
Database: afilopt.dbf
Module: features\aff\aff_db.mv
| Fields |
Type |
Field Description |
Related Database/Field |
| active |
BOOL |
Whether or not Affiliate program is active. |
|
| signup |
CHAR(10) |
Default Application Status (A = Approved;
R = Pending; I = Disabled). |
|
| hits |
NUMBER
(10.4) |
Default Commission Per Referral (hit). |
|
| percent |
NUMBER
(10.2) |
Default Commission Percent of Order. |
|
| pct_slt |
CHAR( 10 ) |
4.1x & above: Subtotal (S) or |
|
| flat |
NUMBER
(10.2) |
Default Commission Flat Fee Per Order. |
|
| terms |
MEMO |
Terms. |
|
| pay_thresh |
NUMBER
(10.2) |
Payout Threshold. |
|
| link_image |
CHAR(254) |
Image for affiliate's website to be linked to store. |
|
| link_text |
CHAR(254) |
Text for affiliate's website to be linked to store. |
|
AffiliatePayouts
Database: affpay.dbf
Module: features\aff\aff_db.mv
| Fields |
Type |
Field Description |
Related Database/Field |
| id |
NUMBER |
Unique identifier, generated by the system. |
|
| date |
NUMBER |
Date of payout |
|
| amount |
NUMBER(10.2) |
Amount of payout. |
|
| count |
NUMBER |
Number of payouts. |
|
| user_id |
NUMBER |
User ID. |
|
| pay_by |
NUMBER |
Paid by User ID. |
|
| processed |
BOOL |
Whether or not Payout has been processed. |
|
| proc_by |
NUMBER |
Processed by User ID. |
|
| proc_date |
NUMBER |
Date processed. |
|
| void |
BOOL |
Whether or not payout is voided. |
|
| void_reasn |
CHAR(250) |
Reason entered for voiding earnings. |
|
| void_date |
NUMBER |
Date voided. |
|
| void_by |
NUMBER |
Voided by User ID. |
|
Index: AffiliatePayouts
| Index |
Index File |
Expression |
Flags |
| Index1 |
affpay_i.mvx |
AffiliatePayouts.d.id |
unique, ascending |
| Index2 |
affpay_d.mvx |
AffiliatePayouts.d.date |
nounique, ascending |
| Index3 |
affpay_u.mvx |
AffiliatePayouts.d.user_id $ ':' $ padl( AffiliatePayouts.d.date, 10, '0' ) |
nounique, ascending |
AffiliateSession
Database: affsess.dbf
Module: features\aff\aff_db.mv
| Fields |
Type |
Field Description |
Related Database/Field |
| session_id |
CHAR(40) |
Unique identifier, generated by the system. |
|
| affil_code |
CHAR(50) |
Affiliate's Login |
affil.dbf/code |
Index: AffiliateSession
| Index |
Index File |
Expression |
Flags |
| Index1 |
aff_cod.mvx |
AffiliateSession.d.affil_code |
nounique, ascending, string |
| Index2 |
aff_sid.mvx |
AffiliateSession.d.session_id |
nounique, ascending, string |
Attribute
Attributes 
Database: attr.dbf
Module: lib\db.mv
| 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), text area (memo), or template. |
|
| attemp_id |
NUMBER |
Attribute Template ID. |
attempl.dbf/id |
| 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: Attributes
| 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 |
| Index4 |
atr_at_p.mvx |
Attributes.d.product_id $ ':' $ padl( Attributes.d.attemp_id, 10, '0' ) $ ':' $ padl( Attributes.d.order, 10, '0' ) |
nounique, ascending |
| Index5 |
atr_at_i.mvx |
Attributes.d.attemp_id |
nounique, ascending |
AttributeTemplates
Database: attempl.dbf
Module: features\att\att_db.mv
| Fields |
Type |
Field Description |
Related Database/Field |
| id |
NUMBER |
Unique identifier for the attribute template. |
|
| code |
CHAR( 50) |
Attribute template code, entered by a store manager (or user with appropriate rights). |
|
| prompt |
CHAR( 50) |
Internal prompt for Administrative Interface. |
|
| inactive |
BOOL |
4.00 (for future use); 4.1: removed |
|
| refcount |
NUMBER |
Number of products to which template is assigned. |
|
Index: AttributeTemplates
| Index |
Index File |
Expression |
Flags |
| Index1 |
attempli.mvx |
AttributeTemplates.d.id |
nounique, ascending |
| Index2 |
attemplc.mvx |
AttributeTemplates.d.code |
nounique, ascending |
AttributeTemplateAttributes 
Database: atmpatt.dbf
Module: features\att\att_db.mv
| Fields |
Type |
Field Description |
Related Database/Field |
| id |
NUMBER |
Unique identifier for the attribute, generated by the system. |
|
| attemp_ID |
NUMBER |
Unique identifier for the Attribute Template, generated by the system. |
attempl.dbf/id |
| default_ID |
NUMBER |
ID of default option for this attribute. |
|
| order |
NUMBER |
Order of appearance of this attribute. |
|
| code |
CHAR( 50) |
Attribute Template Attribute code, entered by a store manager (or user with appropriate rights). |
|
| type |
CHAR( 20) |
Type of selector: radio (Radio button), select (drop-down list), checkbox, text (text field), or memo (text area). |
|
| prompt |
MEMO |
Text describing the attribute for the shopper, entered by a store manager (or user with appropriate rights). |
|
| price |
NUMBER( 10.2) |
Additional price for this attribute. |
|
| cost |
NUMBER( 10.2) |
Additional cost for this attribute. |
|
| required |
BOOL |
Whether or not this is a required attribute. |
|
| image |
CHAR( 254) |
Path for an image. |
|
Index: AttributeTemplateAttributes
| Index |
Index File |
Expression |
Flags |
| Index1 |
atmpatti.mvx |
AttributeTemplateAttributes.d.id |
unique, ascending |
| Index 2 |
atmpattc.mvx |
AttributeTemplateAttributes.d.attemp_id $ ':' $ toupper( AttributeTemplateAttributes.d.code ) |
nounique, ascending |
| Index3 |
atmpatta.mvx |
AttributeTemplateAttributes.d.attemp_id $ ':' $ padl( AttributeTemplateAttributes.d.order, 10, '0' ) |
nounique, ascending |
AttributeTemplateOptions 
Database: attmpop.dbf
Module: features\att\att_db.mv
| Fields |
Type |
Field Description |
Related Database/Field |
| id |
NUMBER |
Unique option identifier generated by the system. |
|
| attmpat_id |
NUMBER |
Attribute Template Attribute ID to which this option belongs. |
atmpatt.dbf/id |
| order |
NUMBER |
Order of appearance of this option. |
|
| code |
CHAR( 50 ) |
Option code entered by a store manager (or user with appropriate privileges). |
|
| prompt |
MEMO |
Text describing the option for the shopper, entered by a store manager (or user with appropriate privileges). |
|
| price |
NUMBER( 10.2 ) |
Additional price for this option. |
|
| cost |
NUMBER( 10.2 ) |
Additional cost (e.g. wholesale) for this option. |
|
| image |
CHAR( 254 ) |
Path for an image. |
|
Index: AttributeTemplateOptions
| Index |
Index File |
Expression |
Flags |
| Index1 |
attmpopi.mvx |
AttributeTemplateOptions.d.id |
unique, ascending |
| Index 2 |
attmpopc.mvx |
AttributeTemplateOptions.d.attmpat_id $ ':' $ toupper( AttributeTemplateOptions.d.code ) |
nounique, ascending |
| Index3 |
attmpopa.mvx |
AttributeTemplateOptions.d.attmpat_id $ ':' $ padl( AttributeTemplateOptions.d.order, '10', '0' ) |
nounique, ascending |
Availability
AvailabilityGroups 
File: avlgrps.dbf
Module: features\agr\agr_db.mv
| 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: AvailabilityGroups
| 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: features\agr\agr_db.mv
| 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: AvailabilityGroupXCategory
| 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: features\agr\agr_db.mv
| 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: AvailabilityGroupXCustomer
| 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: features\agr\agr_db.mv
| 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: AvailabilityGroupXProduct
| 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.mv
| 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.3 ) |
Amount of this charge (which is added to Total). |
|
| disp_amt |
NUMBER( 10.3 ) |
Amount displayed only, and not added to total. |
|
| tax_exempt |
BOOL |
Whether or not this charge is tax exempt. |
|
Index: BasketCharges
| 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 |
BasketLastUpdate (4.1x)
File: basklupd.dbf
Module: features\agr\agr_db.mv
| Fields |
Type |
Field Description |
Related Database/Field |
| session_id |
CHAR( 40 ) |
Unique identifier generated by the system. |
|
| lastupdate |
CHAR( 10 ) |
A unique time identifier generated by the system (used with Basket Timeout). |
|
Index: BasketLastUpdate
| Index |
Index File |
Expression |
Flags |
| Index1 |
blup_ses.mvx |
BasketLastUpdate.d.session_id |
nounique, ascending, string |
BasketList
Database: basklist.dbf
Module: lib\db.mv
| 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 ) |
4.00: A unique time identifier generated by the system (used with Basket Timeout). 4.1x: See BasketLastUpdate (basklupd.dbf) |
|
| 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. |
|
| pay_data
(4.14) |
MEMO |
Values provided by the payment module. |
|
| pay_sectyp
(4.14) |
NUMBER |
Type of encryption. |
ncrypt.dbf/id |
| pay_seckey
(4.14) |
MEMO |
Data used to decrypt data. |
|
| pay_secdat
(4.14) |
MEMO |
The secure payment data. |
|
| total |
NUMBER( 10.2 ) |
Total price of all charges. |
|
Index: BasketList
| Index |
Index File |
Expression |
Flags |
| Index1 |
blst_ses.mvx |
BasketList.d.session_id |
nounique, ascending, string |
BasketOptions
Database: baskopts.dbf
Module: lib\db.mv
| 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: BasketOptions
| 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.mv
| 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
| 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.mv
| 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: Batches
| 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.mv
| 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: Categories
| 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.mv
| 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: CategoryXProduct
| 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.mv
| 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: Countries
| Index |
Index File |
Expression |
Flags |
| Index1 |
cntry_i.mvx |
countries.d.id |
unique, ascending |
| 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: features\cus\cus_db.mv
| 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 |
|
