Table Definitions

System: c:\auction\data\
Date: 4/29/2008

Name AutoOpen Updateable NoUpdate

au!accttype
Y
Y
N
Path: C:\AUCTION\DATA\ACCTTYPE.DBF
Caption: AcctType
Validation Rule: wwrepldto()
Primary Key: acc_pk
Code Page: 1252 - Windows ANSI

au!address
Y
Y
N
Path: C:\AUCTION\DATA\ADDRESS.DBF
Caption: Address
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Primary Key: add_pk
Code Page: 1252 - Windows ANSI

au!ap
Y
Y
N
Path: C:\AUCTION\DATA\AP.DBF
Caption: Ap
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Update Trigger: vmp_ri("UPDATE")
Delete Trigger: vmp_ri("DELETE")
Primary Key: AP_PK
Code Page: 1252 - Windows ANSI

au!apnotes
Y
Y
N
Path: C:\AUCTION\DATA\APNOTES.DBF
Caption: APnotes
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Primary Key: apn_pk
Code Page: 1252 - Windows ANSI

au!appel
Y
Y
N
Path: C:\AUCTION\DATA\APPEL.DBF
Caption: Appel
Validation Rule: wwrepldto()
Update Trigger: vmp_ri("UPDATE")
Delete Trigger: vmp_ri("DELETE")
Primary Key: app_pk
Code Page: 1252 - Windows ANSI

au!appinfo
Y
Y
N
Path: C:\AUCTION\DATA\AUSYSTEM.DBF
Caption: Appinfo
Comments: Application-level setup/configuration information
Code Page: 1252 - Windows ANSI

au!apsort
Y
Y
N
Path: C:\AUCTION\DATA\APSORT.DBF
Caption: Apsort
Primary Key: aps_pk
Code Page: 1252 - Windows ANSI

au!araptran
Y
Y
N
Path: C:\AUCTION\DATA\ARAPTRAN.DBF
Caption: Araptran
Validation Rule: wwrepldto()
Primary Key: ARA_PK
Code Page: 1252 - Windows ANSI

au!bids
Y
Y
N
Path: C:\AUCTION\DATA\BIDS.DBF
Caption: Bids
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Primary Key: BID_PK
Code Page: 1252 - Windows ANSI

au!btype
Y
Y
N
Path: C:\AUCTION\DATA\BTYPE.DBF
Caption: Btype
Validation Rule: wwrepldto()
Primary Key: btp_pk
Code Page: 1252 - Windows ANSI

au!casetype
Y
Y
N
Path: C:\AUCTION\DATA\CASETYPE.DBF
Caption: CaseType
Validation Rule: wwrepldto()
Primary Key: cas_pk
Code Page: 1252 - Windows ANSI

au!category
Y
Y
N
Path: C:\AUCTION\DATA\CATEGORY.DBF
Caption: Category
Validation Rule: wwrepldto()
Update Trigger: vmp_ri("UPDATE")
Delete Trigger: vmp_ri("DELETE")
Primary Key: cat_pk
Code Page: 1252 - Windows ANSI

au!cbserver
Y
Y
N
Path: C:\AUCTION\DATA\CBSERVER.DBF
Caption: Cbserver
Primary Key: CBS_PK
Code Page: 1252 - Windows ANSI

au!conslog
Y
Y
N
Path: C:\AUCTION\DATA\CONSLOG.DBF
Caption: Conslog
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Update Trigger: vmp_ri("UPDATE")
Delete Trigger: vmp_ri("DELETE")
Primary Key: CON_PK
Code Page: 1252 - Windows ANSI

au!conslogd
Y
Y
N
Path: C:\AUCTION\DATA\CONSLOGD.DBF
Caption: Conslogd
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Primary Key: CLD_PK
Code Page: 1252 - Windows ANSI

au!consstat
Y
Y
N
Path: C:\AUCTION\DATA\CONSSTAT.DBF
Caption: Consstat
Primary Key: CST_PK
Code Page: 1252 - Windows ANSI

au!contacts
Y
Y
N
Path: C:\AUCTION\DATA\CONTACTS.DBF
Caption: Shiphist
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Primary Key: cts_pk
Code Page: 1252 - Windows ANSI

au!country
Y
Y
N
Path: C:\AUCTION\DATA\COUNTRY.DBF
Caption: Country
Validation Rule: wwrepldto()
Update Trigger: vmp_ri("UPDATE")
Delete Trigger: vmp_ri("DELETE")
Primary Key: cou_pk
Code Page: 1252 - Windows ANSI

au!credcard
Y
Y
N
Path: C:\AUCTION\DATA\CREDCARD.DBF
Caption: Credcard
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Primary Key: cre_pk
Code Page: 1252 - Windows ANSI

au!credin
Y
Y
N
Path: C:\AUCTION\DATA\CREDIN.DBF
Caption: Credin
Primary Key: cin_pk
Code Page: 1252 - Windows ANSI

au!credpost
Y
Y
N
Path: C:\AUCTION\DATA\CREDPOST.DBF
Caption: Credpost
Primary Key: cpo_pk
Code Page: 1252 - Windows ANSI

au!currency
Y
Y
N
Path: C:\AUCTION\DATA\CURRENCY.DBF
Caption: Currency
Validation Rule: wwrepldto()
Primary Key: cur_pk
Code Page: 1252 - Windows ANSI

au!custarch
Y
Y
N
Path: C:\AUCTION\DATA\CUSTARCH.DBF
Caption: CustArch
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Primary Key: cus_pk
Code Page: 1252 - Windows ANSI

au!custdict
Y
Y
N
Path: C:\AUCTION\DATA\CUSTDICT.DBF
Caption: Custdict
Primary Key: cd_pk
Code Page: 1252 - Windows ANSI

au!custlog
Y
Y
N
Path: C:\AUCTION\DATA\CUSTLOG.DBF
Caption: Custlog
Primary Key: cul_pk
Code Page: 1252 - Windows ANSI

au!customer
Y
Y
N
Path: C:\AUCTION\DATA\CUSTOMER.DBF
Caption: Customer
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Update Trigger: vmp_ri("UPDATE")
Delete Trigger: vmp_ri("DELETE")
Primary Key: cus_pk
Code Page: 1252 - Windows ANSI

au!ebayfees
Y
Y
N
Path: C:\AUCTION\DATA\EBAYFEES.DBF
Caption: Ebayfees
Primary Key: EBA_PK
Code Page: 1252 - Windows ANSI

au!ebayinv
Y
Y
N
Path: C:\AUCTION\DATA\EBAYINV.DBF
Caption: Ebayinv
Primary Key: ein_pk
Code Page: 1252 - Windows ANSI

au!expcntrl
Y
Y
N
Path: C:\AUCTION\DATA\EXPCNTRL.DBF
Caption: Expcntrl
Primary Key: EXP_PK
Code Page: 1252 - Windows ANSI

au!filcond
Y
Y
N
Path: C:\AUCTION\DATA\FILCOND.DBF
Caption: Filcond
Primary Key: fc_pk
Code Page: 1252 - Windows ANSI

au!filters
Y
Y
N
Path: C:\AUCTION\DATA\FILTERS.DBF
Caption: Filters
Primary Key: fil_pk
Code Page: 1252 - Windows ANSI

au!generatepk
Y
Y
N
Path: C:\AUCTION\DATA\AUGENPK.DBF
Caption: Generatepk
Comments: System-generated Primary Keys
Primary Key: gpk_pk
Code Page: 1252 - Windows ANSI

au!grower
Y
Y
N
Path: C:\AUCTION\DATA\GROWER.DBF
Caption: Grower
Validation Rule: wwrepldto()
Update Trigger: vmp_ri("UPDATE")
Delete Trigger: vmp_ri("DELETE")
Primary Key: gro_pk
Code Page: 1252 - Windows ANSI

au!handheld
Y
Y
N
Path: C:\AUCTION\DATA\HANDHELD.DBF
Caption: Handheld
Code Page: 1252 - Windows ANSI

au!history
Y
Y
N
Path: C:\AUCTION\DATA\HISTORY.DBF
Caption: History
Primary Key: HIS_PK
Code Page: 1252 - Windows ANSI

au!index
Y
Y
N
Path: C:\AUCTION\DATA\INDEX.DBF
Caption: Index
Primary Key: IND_PK
Code Page: 1252 - Windows ANSI

au!interest
Y
Y
N
Path: C:\AUCTION\DATA\INTEREST.DBF
Caption: Interest
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Primary Key: int_pk
Code Page: 1252 - Windows ANSI

au!invoice
Y
Y
N
Path: C:\AUCTION\DATA\INVOICE.DBF
Caption: Invoice
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Update Trigger: vmp_ri("UPDATE")
Delete Trigger: vmp_ri("DELETE")
Primary Key: INV_PK
Code Page: 1252 - Windows ANSI

au!invpmts
Y
Y
N
Path: C:\AUCTION\DATA\INVPMTS.DBF
Caption: Invpmts
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Primary Key: inp_pk
Code Page: 1252 - Windows ANSI

au!lablset
Y
Y
N
Path: C:\AUCTION\DATA\LABLSET.DBF
Caption: Lablset
Primary Key: lab_pk
Code Page: 1252 - Windows ANSI

au!larchive
Y
Y
N
Path: C:\AUCTION\DATA\LARCHIVE.DBF
Caption: Larchive
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Update Trigger: vmp_ri("UPDATE")
Delete Trigger: vmp_ri("DELETE")
Primary Key: LOT_PK
Code Page: 1252 - Windows ANSI

au!lindex
Y
Y
N
Path: C:\AUCTION\DATA\LINDEX.DBF
Caption: Lindex
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Primary Key: LIN_PK
Code Page: 1252 - Windows ANSI

au!loggedinusers
Y
Y
N
Path: C:\AUCTION\DATA\AUUSYSCL.DBF
Caption: Loggedinusers
Code Page: 1252 - Windows ANSI

au!loginhistory
Y
Y
N
Path: C:\AUCTION\DATA\AUUSYSLH.DBF
Caption: Loginhistory
Comments: Optional table to log each user login/logout
Validation Rule: .NOT.EMPTY(ulh_pk).AND..NOT.EMPTY(ulh_in).AND.(ISNULL(ulh_out).OR..NOT.EMPTY(ulh_out)).AND..NOT.EMPTY(ulh_outflag)
Validation Text: xxfwruleerrortext("RR_LoginHistory","Primary Key, In, Out, and Logout Flag must all be entered")
Insert Trigger: vmp_ri("INSERT")
Update Trigger: vmp_ri("UPDATE")
Delete Trigger: vmp_ri("DELETE")
Primary Key: ulh_pk
Code Page: 1252 - Windows ANSI

au!lots
Y
Y
N
Path: C:\AUCTION\DATA\LOTS.DBF
Caption: Lots
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Update Trigger: vmp_ri("UPDATE")
Delete Trigger: vmp_ri("DELETE")
Primary Key: LOT_PK
Code Page: 1252 - Windows ANSI

au!mailhist
Y
Y
N
Path: C:\AUCTION\DATA\MAILHIST.DBF
Caption: Mailhist
Code Page: 1252 - Windows ANSI

au!mailing
Y
Y
N
Path: C:\AUCTION\DATA\MAILING.DBF
Caption: Mailing
Primary Key: mai_pk
Code Page: 1252 - Windows ANSI

au!memoae
Y
Y
N
Path: C:\AUCTION\DATA\AUMEMOAE.DBF
Caption: Memoae
Comments: AutoExpand 'dictionary' table for editboxes
Code Page: 1252 - Windows ANSI

au!miscinv
Y
Y
N
Path: C:\AUCTION\DATA\MISCINV.DBF
Caption: Miscinv
Validation Rule: wwrepldto()
Primary Key: MIS_PK
Code Page: 1252 - Windows ANSI

au!moreap
Y
Y
N
Path: C:\AUCTION\DATA\MOREAP.DBF
Caption: Moreap
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Primary Key: API_PK
Code Page: 1252 - Windows ANSI

au!mxlot
Y
Y
N
Path: C:\AUCTION\DATA\MXLOT.DBF
Caption: Mxlot
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Primary Key: mxl_pk
Code Page: 1252 - Windows ANSI

au!newcust
Y
Y
N
Path: C:\AUCTION\DATA\NEWCUST.DBF
Caption: Newcust
Primary Key: new_pk
Code Page: 1252 - Windows ANSI

au!nextlot
Y
Y
N
Path: C:\AUCTION\DATA\NEXTLOT.DBF
Caption: Nextlot
Primary Key: NEX_PK
Code Page: 1252 - Windows ANSI

au!outbid
Y
Y
N
Path: C:\AUCTION\DATA\OUTBID.DBF
Caption: Outbid
Primary Key: OUT_PK
Code Page: 1252 - Windows ANSI

au!paddle
Y
Y
N
Path: C:\AUCTION\DATA\PADDLE.DBF
Caption: Paddle
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Primary Key: PAD_PK
Code Page: 1252 - Windows ANSI

au!pbcalls
Y
Y
N
Path: C:\AUCTION\DATA\PBCALLS.DBF
Caption: Pbcalls
Primary Key: PBC_PK
Code Page: 1252 - Windows ANSI

au!pbfailed
Y
Y
N
Path: C:\AUCTION\DATA\PBFAILED.DBF
Caption: Pbfailed
Primary Key: pbf_pk
Code Page: 1252 - Windows ANSI

au!pfexport
Y
Y
N
Path: C:\AUCTION\DATA\PFEXPORT.DBF
Caption: Pfexport
Validation Rule: wwrepldto()
Primary Key: PFE_PK
Code Page: 1252 - Windows ANSI

au!phonebid
Y
Y
N
Path: C:\AUCTION\DATA\PHONEBID.DBF
Caption: Phonebid
Primary Key: PHO_PK
Code Page: 1252 - Windows ANSI

au!phrases
Y
Y
N
Path: C:\AUCTION\DATA\PHRASES.DBF
Caption: Phrases
Comments: Phrases to be inserted into textbox and memo fields
Primary Key: phr_pk
Code Page: 1252 - Windows ANSI

au!postview
Y
Y
N
Path: C:\AUCTION\DATA\POSTVIEW.DBF
Caption: Postview
Primary Key: POS_PK
Code Page: 1252 - Windows ANSI

au!profiles
Y
Y
N
Path: C:\AUCTION\DATA\PROFILES.DBF
Caption: Profiles
Primary Key: PRO_PK
Code Page: 1252 - Windows ANSI

au!profit
Y
Y
N
Path: C:\AUCTION\DATA\PROFIT.DBF
Caption: Profit
Primary Key: pro_pk
Code Page: 1252 - Windows ANSI

au!prtype
Y
Y
N
Path: C:\AUCTION\DATA\PRTYPE.DBF
Caption: Prtype
Primary Key: prtype
Code Page: 1252 - Windows ANSI

au!qrystore
Y
Y
N
Path: C:\AUCTION\DATA\QRYSTORE.DBF
Caption: TxtStore
Primary Key: qry_pk
Code Page: 1252 - Windows ANSI

au!readme
Y
Y
N
Path: C:\AUCTION\DATA\README.DBF
Caption: Readme
Primary Key: rea_pk
Code Page: 1252 - Windows ANSI

au!release
Y
Y
N
Path: C:\AUCTION\DATA\RELEASE.DBF
Caption: Release
Comments: Mail Merge documents
Primary Key: rel_pk
Code Page: 1252 - Windows ANSI

au!reportcatalog
Y
Y
N
Path: C:\AUCTION\DATA\AUREPCAT.DBF
Caption: Reportcatalog
Comments: Report Catalog
Primary Key: rep_pk
Code Page: 1252 - Windows ANSI

au!returns
Y
Y
N
Path: C:\AUCTION\DATA\RETURNS.DBF
Caption: Returns
Validation Rule: wwrepldto()
Primary Key: RET_PK
Code Page: 1252 - Windows ANSI

au!salebids
Y
Y
N
Path: C:\AUCTION\DATA\SALEBIDS.DBF
Caption: Salebids
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Update Trigger: vmp_ri("UPDATE")
Delete Trigger: vmp_ri("DELETE")
Primary Key: SALB_PK
Code Page: 1252 - Windows ANSI

au!sales
Y
Y
N
Path: C:\AUCTION\DATA\SALES.DBF
Caption: Sales
Validation Rule: wwrepldto()
Update Trigger: vmp_ri("UPDATE")
Delete Trigger: vmp_ri("DELETE")
Primary Key: SAL_PK
Code Page: 1252 - Windows ANSI

au!securityaccess
Y
Y
N
Path: C:\AUCTION\DATA\AUUSYSAC.DBF
Caption: Securityaccess
Comments: This is an optional table used in the VMP user-security system, defining access restrictions per UserGroup on individual SecuredItems (many-to-many)
Validation Rule: .NOT.EMPTY(acc_pk).AND..NOT.EMPTY(acc_ugrfk).AND..NOT.EMPTY(acc_sitfk).AND.INLIST(acc_access,1,8,9)
Validation Text: xxfwruleerrortext("RR_SecurityAccess","Primary Key, Group, SecuredItem, and Access must all be entered")
Insert Trigger: vmp_ri("INSERT")
Update Trigger: vmp_ri("UPDATE")
Delete Trigger: vmp_ri("DELETE")
Primary Key: acc_pk
Code Page: 1252 - Windows ANSI

au!shiphist
Y
Y
N
Path: C:\AUCTION\DATA\SHIPHIST.DBF
Caption: Shiphist
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Primary Key: SHI_PK
Code Page: 1252 - Windows ANSI

au!shipping
Y
Y
N
Path: C:\AUCTION\DATA\SHIPPING.DBF
Caption: Shipping
Validation Rule: wwrepldto()
Primary Key: shi_pk
Code Page: 1252 - Windows ANSI

au!size
Y
Y
N
Path: C:\AUCTION\DATA\SIZE.DBF
Caption: Size
Validation Rule: wwrepldto()
Update Trigger: vmp_ri("UPDATE")
Delete Trigger: vmp_ri("DELETE")
Primary Key: siz_pk
Code Page: 1252 - Windows ANSI

au!specinfo
Y
Y
N
Path: C:\AUCTION\DATA\SPECINFO.DBF
Caption: Specinfo
Validation Rule: wwrepldto()
Primary Key: spe_pk
Code Page: 1252 - Windows ANSI

au!stamps
Y
Y
N
Path: C:\AUCTION\DATA\STAMPS.DBF
Caption: Stamps
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Primary Key: sta_pk
Code Page: 1252 - Windows ANSI

au!state
Y
Y
N
Path: C:\AUCTION\DATA\STATE.DBF
Caption: State
Validation Rule: wwrepldto()
Primary Key: sta_pk
Code Page: 1252 - Windows ANSI

au!tasting
Y
Y
N
Path: C:\AUCTION\DATA\TASTING.DBF
Caption: Tasting
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Primary Key: tas_pk
Code Page: 1252 - Windows ANSI

au!taxtbl
Y
Y
N
Path: C:\AUCTION\DATA\TAXTBL.DBF
Caption: Taxtbl
Validation Rule: wwrepldto()
Primary Key: tax_pk
Code Page: 1252 - Windows ANSI

au!tranxtn
Y
Y
N
Path: C:\AUCTION\DATA\TRANXTN.DBF
Caption: Tranxtn
Validation Rule: wwrepldto()
Primary Key: TRX_PK
Code Page: 1252 - Windows ANSI

au!txtstore
Y
Y
N
Path: C:\AUCTION\DATA\TXTSTORE.DBF
Caption: TxtStore
Primary Key: txt_pk
Code Page: 1252 - Windows ANSI

au!upszone
Y
Y
N
Path: C:\AUCTION\DATA\UPSZONE.DBF
Caption: Upszone
Validation Rule: wwrepldto()
Primary Key: ups_pk
Code Page: 1252 - Windows ANSI

au!useraccexceptions
Y
Y
N
Path: C:\AUCTION\DATA\AUUSYSAE.DBF
Caption: Useraccexceptions
Comments: This is an optional table used in the VMP user-security system, defining access restrictions per User on individual SecuredItems (many-to-many), overriding group membership security
Validation Rule: .NOT.EMPTY(uae_pk).AND..NOT.EMPTY(uae_usrfk).AND..NOT.EMPTY(uae_sitfk).AND.INLIST(uae_access,1,8,9)
Validation Text: xxfwruleerrortext("RR_UserAccExceptions","Primary Key, Group, SecuredItem, and Access must all be entered")
Insert Trigger: vmp_ri("INSERT")
Update Trigger: vmp_ri("UPDATE")
Delete Trigger: vmp_ri("DELETE")
Primary Key: uae_pk
Code Page: 1252 - Windows ANSI

au!usergroups
Y
Y
N
Path: C:\AUCTION\DATA\AUUSYSG.DBF
Caption: Usergroups
Comments: This is an optional table used in the VMP user-security system, containing one record per UserGroup
Validation Rule: .NOT.EMPTY(ugr_pk).AND..NOT.EMPTY(ugr_group).AND..NOT.EMPTY(ugr_description).AND..NOT.EMPTY(ugr_system)
Validation Text: xxfwruleerrortext("RR_UserGroups","Primary Key, Group, Description, and Rights must all be entered")
Insert Trigger: vmp_ri("INSERT")
Update Trigger: vmp_ri("UPDATE")
Delete Trigger: vmp_ri("DELETE")
Primary Key: ugr_pk
Code Page: 1252 - Windows ANSI

au!userprefs
Y
Y
N
Path: C:\AUCTION\DATA\AUUSRPRF.DBF
Caption: Userprefs
Comments: User Preferences
Insert Trigger: vmp_ri("INSERT")
Code Page: 1252 - Windows ANSI

au!users
Y
Y
N
Path: C:\AUCTION\DATA\AUUSYS.DBF
Caption: Users
Comments: Users
Validation Rule: .NOT.EMPTY(usr_pk).AND..NOT.EMPTY(usr_firstname).AND..NOT.EMPTY(usr_lastname).AND..NOT.EMPTY(usr_lanid).AND..NOT.EMPTY(usr_password).AND..NOT.x3ed("D",usr_password)=usr_lanid
Validation Text: xxfwruleerrortext("RR_USERS","Primary Key, First Name, Last Name, UserName/ID, Password, and Rights must all be entered, and Password may not be the same as UserName/ID")
Insert Trigger: vmp_ri("INSERT")
Update Trigger: vmp_ri("UPDATE")
Delete Trigger: vmp_ri("DELETE")
Primary Key: USR_PK
Code Page: 1252 - Windows ANSI

au!usrgrpxref
Y
Y
N
Path: C:\AUCTION\DATA\AUUSYSGX.DBF
Caption: Usrgrpxref
Comments: This is an optional table used in the VMP user-security system, containing one record per user per group (many-to-many link table)
Insert Trigger: vmp_ri("INSERT")
Update Trigger: vmp_ri("UPDATE")
Delete Trigger: vmp_ri("DELETE")
Primary Key: ugx_pk
Code Page: 1252 - Windows ANSI

au!vatcode
Y
Y
N
Path: C:\AUCTION\DATA\VATCODE.DBF
Caption: VatCode
Validation Rule: wwrepldto()
Primary Key: vat_pk
Code Page: 1252 - Windows ANSI

au!vmpri
Y
Y
N
Path: C:\AUCTION\DATA\AURI.DBF
Caption: Vmpri
Comments: Referential Integrity
Code Page: 1252 - Windows ANSI

au!wantlist
Y
Y
N
Path: C:\AUCTION\DATA\WANTLIST.DBF
Caption: Lindex
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Primary Key: wl_pk
Code Page: 1252 - Windows ANSI

au!wbids
Y
Y
N
Path: C:\AUCTION\DATA\WBIDS.DBF
Caption: Wbids
Code Page: 1252 - Windows ANSI

au!wbidsin
Y
Y
N
Path: C:\AUCTION\DATA\WBIDSIN.DBF
Caption: Wbidsin
Code Page: 1252 - Windows ANSI

au!wbidsout
Y
Y
N
Path: C:\AUCTION\DATA\WBIDSOUT.DBF
Caption: Wbidsout
Code Page: 1252 - Windows ANSI

au!wclass
Y
Y
N
Path: C:\AUCTION\DATA\WCLASS.DBF
Caption: WClass
Validation Rule: wwrepldto()
Update Trigger: vmp_ri("UPDATE")
Delete Trigger: vmp_ri("DELETE")
Primary Key: cla_pk
Code Page: 1252 - Windows ANSI

au!wconvert
Y
Y
N
Path: C:\AUCTION\DATA\WCONVERT.DBF
Caption: Wregi
Code Page: 1252 - Windows ANSI

au!weights
Y
Y
N
Path: C:\AUCTION\DATA\WEIGHTS.DBF
Caption: Weights
Validation Rule: wwrepldto()
Primary Key: wgt_pk
Code Page: 1252 - Windows ANSI

au!whse
Y
Y
N
Path: C:\AUCTION\DATA\WHSE.DBF
Caption: Whse
Validation Rule: wwrepldto()
Primary Key: whs_pk
Code Page: 1252 - Windows ANSI

au!wine
Y
Y
N
Path: C:\AUCTION\DATA\WINE.DBF
Caption: Wine
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Update Trigger: vmp_ri("UPDATE")
Delete Trigger: vmp_ri("DELETE")
Primary Key: win_pk
Code Page: 1252 - Windows ANSI

au!winehx
Y
Y
N
Path: C:\AUCTION\DATA\WINEHX.DBF
Caption: Winehx
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Primary Key: whx_pk
Code Page: 1252 - Windows ANSI

au!wineprx
Y
Y
N
Path: C:\AUCTION\DATA\WINEPRX.DBF
Caption: Wineprx
Validation Rule: wwrepldto()
Insert Trigger: vmp_ri("INSERT")
Primary Key: wpx_pk
Code Page: 1252 - Windows ANSI

au!wlots
Y
Y
N
Path: C:\AUCTION\DATA\WLOTS.DBF
Caption: Wlots
Primary Key: wlo_pk
Code Page: 1252 - Windows ANSI

au!wreal
Y
Y
N
Path: C:\AUCTION\DATA\WREAL.DBF
Caption: Wreal
Code Page: 1252 - Windows ANSI

au!wrealout
Y
Y
N
Path: C:\AUCTION\DATA\WREALOUT.DBF
Caption: Wrealout
Code Page: 1252 - Windows ANSI

au!wregi
Y
Y
N
Path: C:\AUCTION\DATA\WREGI.DBF
Caption: Wregi
Code Page: 1252 - Windows ANSI

au!wregiin
Y
Y
N
Path: C:\AUCTION\DATA\WREGIIN.DBF
Caption: Wregiin
Code Page: 1252 - Windows ANSI

au!wregiout
Y
Y
N
Path: C:\AUCTION\DATA\WREGIOUT.DBF
Caption: Wregiout
Code Page: 1252 - Windows ANSI

au!wureg
Y
Y
N
Path: C:\AUCTION\DATA\WUREG.DBF
Caption: Wureg
Primary Key: wur_pk
Code Page: 1252 - Windows ANSI

catalog
Y
Y
N
Path: C:\AUCTION\DATA\CATALOG.DBF
Caption: Catalog
Code Page: 1252 - Windows ANSI

largelot
Y
Y
N
Path: C:\AUCTION\DATA\LARGELOT.DBF
Caption: Largelot
Code Page: 1252 - Windows ANSI

lotlabel
Y
Y
N
Path: C:\AUCTION\DATA\LOTLABEL.DBF
Caption: Lotlabel
Code Page: 1252 - Windows ANSI

lotstat
Y
Y
N
Path: C:\AUCTION\DATA\LOTSTAT.DBF
Caption: Lotstat
Code Page: 0 - No Code Page
Index Definitions

Index Definitions

System: c:\auction\data\
Date: 4/29/2008

Table: au!accttype

Tag Type Caption Desc Sel

acc_code
Regular
Account Type Code
N
Y
Expression: ACC_CODE
Collate: MACHINE

acc_del
Regular
Deleted
N
Y
Expression: DELETED()
Collate: MACHINE

acc_descr
Regular
Account Type Description
N
Y
Expression: UPPER(ACC_DESCR)
Collate: MACHINE

acc_pk
Primary
Grower Primary Key
N
Y
Expression: ACC_PK
Collate: MACHINE

Table: au!address

Tag Type Caption Desc Sel

acct_num
Regular
Account Number
N
Y
Expression: ACCT_NUM
Collate: MACHINE

add_coufk
Regular
Country Foriegn Key
N
Y
Expression: ADD_COUFK
Collate: MACHINE

add_cusfk
Regular
Customer FK
N
Y
Expression: ADD_CUSFK
Collate: MACHINE

add_del
Regular
Add Del
N
N
Expression: DELETED()
Collate: MACHINE

add_pk
Primary
Add Pk
N
N
Expression: ADD_PK
Collate: MACHINE

add_type
Regular
Address Type
N
Y
Expression: ADD_TYPE
Collate: MACHINE

address
Regular

N
Y
Expression: CUST_NO
Collate: MACHINE

country
Regular
Country
N
Y
Expression: UPPER(COUNTRY)
Collate: MACHINE

Table: au!ap

Tag Type Caption Desc Sel

ap1
Regular

N
Y
Expression: SALE_NO+CUST_NO+REF_NUM
Collate: MACHINE

ap2
Regular

N
Y
Expression: CUST_NO+SALE_NO+REF_NUM
Collate: MACHINE

ap_confk
Regular
Consignor FK into customer table
N
Y
Expression: AP_CONFK
Collate: MACHINE

ap_del
Regular
Ap Del
N
N
Expression: DELETED()
Collate: MACHINE

ap_pk
Primary
Ap Pk
N
N
Expression: AP_PK
Collate: MACHINE

ap_salfk
Regular
Sale Foreign Key
N
Y
Expression: AP_SALFK
Collate: MACHINE

apwhse
Regular
Default Warehouse Code for this Consignment
N
Y
Expression: APWHSE
Collate: MACHINE

cons_code
Regular
Consignor Type
N
Y
Expression: CONS_CODE
Collate: MACHINE

cust_no
Regular
Cust No
N
Y
Expression: CUST_NO
Collate: MACHINE

originalpo
Regular
Original PO/AP Number
N
Y
Expression: ORIGINALPO
Collate: MACHINE

prop_num
Regular
Property Number
N
Y
Expression: PROP_NUM
Collate: MACHINE

ref_num
Regular
Reference Number
N
Y
Expression: REF_NUM
Collate: MACHINE

releaseno
Regular
Release Order Number
N
Y
Expression: RELEASENO
Collate: MACHINE

Table: au!apnotes

Tag Type Caption Desc Sel

apn_apfk
Regular
Api Apfk
N
Y
Expression: APN_APFK
Collate: MACHINE

apn_del
Regular
Api Del
N
N
Expression: DELETED()
Collate: MACHINE

apn_pk
Primary
Mor Pk
N
Y
Expression: APN_PK
Collate: MACHINE

Table: au!appel

Tag Type Caption Desc Sel

app_code
Regular
Appellation Code
N
Y
Expression: APP_CODE
Collate: MACHINE

app_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

app_descr
Regular
Appellation Description
N
Y
Expression: UPPER(REPLFOREIGN(APP_DESCR))
Collate: MACHINE

app_pk
Primary

N
Y
Expression: APP_PK
Collate: MACHINE

Table: au!apsort

Tag Type