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 Caption Desc Sel

ap_sort
Regular
AP Sort for Catalog
N
Y
Expression: AP_SORT
Collate: MACHINE

aps_apfk
Regular
AP Foreign Key
N
Y
Expression: APS_APFK
Collate: MACHINE

aps_pk
Primary
AP Sort Primary Key
N
Y
Expression: APS_PK
Collate: MACHINE

Table: au!araptran

Tag Type Caption Desc Sel

apa_salfk
Regular
Sale Foreign Key
N
Y
Expression: ARA_SALFK
Collate: MACHINE

ara_apfk
Regular
AP FK
N
Y
Expression: ARA_APFK
Collate: MACHINE

ara_cusfk
Regular
Customer FK
N
Y
Expression: ARA_CUSFK
Collate: MACHINE

ara_del
Regular
Ara Del
N
N
Expression: DELETED()
Collate: MACHINE

ara_invfk
Regular
Invoice FK
N
Y
Expression: ARA_INVFK
Collate: MACHINE

ara_pk
Primary
Ara Pk
N
N
Expression: ARA_PK
Collate: MACHINE

araptran
Regular

N
Y
Expression: CUST_NO+INVOICE
Collate: MACHINE

Table: au!bids

Tag Type Caption Desc Sel

bid_cusfk
Regular
Customer Foreign Key
N
Y
Expression: BID_CUSFK
Collate: MACHINE

bid_del
Regular
Bid Del
N
N
Expression: DELETED()
Collate: MACHINE

bid_lotfk
Regular
Lots Foreign Key
N
Y
Expression: BID_LOTFK
Collate: MACHINE

bid_pk
Primary
Bid Pk
N
N
Expression: BID_PK
Collate: MACHINE

bid_salbfk
Regular
SaleBids Foreign Key
N
Y
Expression: BID_SALBFK
Collate: MACHINE

bid_salfk
Regular
Sale Foreign Key
N
Y
Expression: BID_SALFK
Collate: MACHINE

bids1
Regular

N
Y
Expression: SALE_NO+CUST_NO+SEEKLOT(LOT_NO)
Collate: MACHINE

bids2
Regular

N
Y
Expression: SALE_NO+SEEKLOT(LOT_NO)+STR(9999999-BID,10,2)+DTOS(DATE_RCVD)
Collate: MACHINE

bids3
Regular

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

bids4
Regular

N
Y
Expression: SALE_NO+MISC_INFO+CUST_NO+SEEKLOT(LOT_NO)
Collate: MACHINE

bids5
Regular

N
Y
Expression: SALE_NO+MISC_INFO+SEEKLOT(LOT_NO)+STR(9999999-BID,10,2)+DTOS(DATE_RCVD)
Collate: MACHINE

cust_no
Regular

N
Y
Expression: CUST_NO
Collate: MACHINE

lot_no
Regular
Lot No
N
Y
Expression: LOT_NO
Collate: MACHINE

or_ind
Regular
OR Indicator
N
Y
Expression: OR_IND
Collate: MACHINE

sale_no
Regular

N
Y
Expression: SALE_NO
Collate: MACHINE

seeklot
Regular
Lot No
N
Y
Expression: SEEKLOT(LOT_NO)
Collate: MACHINE

Table: au!btype

Tag Type Caption Desc Sel

btp_code
Regular
Bottle Type Code
N
Y
Expression: BTP_CODE
Collate: MACHINE

btp_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

btp_descr
Regular
Bottle Type Description
N
Y
Expression: UPPER(BTP_DESCR)
Collate: MACHINE

btp_pk
Primary
Bottle Type Primary Key
N
Y
Expression: BTP_PK
Collate: MACHINE

Table: au!casetype

Tag Type Caption Desc Sel

cas_code
Regular
Case Type Code
N
Y
Expression: CAS_CODE
Collate: MACHINE

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

cas_descr
Regular
Case Type Description
N
Y
Expression: UPPER(CAS_DESCR)
Collate: MACHINE

cas_pk
Primary
Case Type Primary Key
N
Y
Expression: CAS_PK
Collate: MACHINE

Table: au!category

Tag Type Caption Desc Sel

cat1
Regular

N
Y
Expression: CATEGORY
Collate: MACHINE

cat2
Regular

N
Y
Expression: LEFT(UPPER(MAJGROUP+DESCRIP+SUBGROUP),80)
Collate: MACHINE

cat3
Regular
Major Group
N
Y
Expression: UPPER(MAJGROUP)
Collate: MACHINE

cat4
Regular
Description
N
Y
Expression: UPPER(DESCRIP)
Collate: MACHINE

cat5
Regular
Sub Group
N
Y
Expression: UPPER(SUBGROUP)
Collate: MACHINE

cat6
Regular
Super Group
N
Y
Expression: UPPER(SUPGROUP)
Collate: MACHINE

cat_del
Regular
Cat Del
N
N
Expression: DELETED()
Collate: MACHINE

cat_pk
Primary
Cat Pk
N
N
Expression: CAT_PK
Collate: MACHINE

new_code
Regular
New Code
N
Y
Expression: NEW_CODE
Collate: MACHINE

sort_code
Regular
Sort Code
N
Y
Expression: SORT_CODE
Collate: MACHINE

webmajgrp
Regular
Category Description to use in Web and Catalog
N
Y
Expression: UPPER(WEBMAJGRP)
Collate: MACHINE

Table: au!cbserver

Tag Type Caption Desc Sel

cbs_pk
Primary

N
Y
Expression: CBS_PK
Collate: MACHINE

done
Regular
Done
N
Y
Expression: DONE
Collate: MACHINE

Table: au!conslog

Tag Type Caption Desc Sel

con_cusfk
Regular

N
Y
Expression: CON_CUSFK
Collate: MACHINE

con_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

con_pk
Primary

N
Y
Expression: CON_PK
Collate: MACHINE

con_salfk
Regular
Sale Foreign Key
N
Y
Expression: CON_SALFK
Collate: MACHINE

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

conslog1
Regular
Conslog1
N
Y
Expression: CONS_NUM
Collate: MACHINE

cost
Regular
Cost
N
Y
Expression: COST
Collate: MACHINE

cquality
Regular

N
Y
Expression: CQUALITY
Collate: MACHINE

cstatus
Regular
Status
N
Y
Expression: CSTATUS
Collate: MACHINE

cusfilter
Regular
Custom Filter
N
Y
Expression: CUSFILTER
Collate: MACHINE

cust_no
Regular
Customer No.
N
Y
Expression: CUST_NO
Collate: MACHINE

date
Regular
Date
N
Y
Expression: DATE
Collate: MACHINE

describe1
Regular
Description of Property
N
Y
Expression: DESCRIBE1
Collate: MACHINE

describe2
Regular
Name on Property
N
Y
Expression: DESCRIBE2
Collate: MACHINE

given_to
Regular
Given to
N
Y
Expression: UPPER(GIVEN_TO)
Collate: MACHINE

ins_value
Regular
Insurance Value
N
Y
Expression: INS_VALUE
Collate: MACHINE

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

reserve
Regular
Sum of Reserve
N
Y
Expression: RESERVE
Collate: MACHINE

sale_no
Regular
Sale No.
N
Y
Expression: SALE_NO
Collate: MACHINE

Table: au!conslogd

Tag Type Caption Desc Sel

cld_confk
Regular
Consignor Log Foreign Key
N
Y
Expression: CLD_CONFK
Collate: MACHINE

cld_cusfk
Regular

N
Y
Expression: CLD_CUSFK
Collate: MACHINE

cld_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

cld_pk
Primary

N
Y
Expression: CLD_PK
Collate: MACHINE

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

Table: au!consstat

Tag Type Caption Desc Sel

con_del
Regular
Con Del
N
N
Expression: DELETED()
Collate: MACHINE

cst_confk
Regular
Consignor Foreign Key
N
Y
Expression: CST_CONFK
Collate: MACHINE

cst_pk
Primary
CST_PK
N
N
Expression: CST_PK
Collate: MACHINE

cst_salfk
Regular
Sale Foreign Key
N
Y
Expression: CST_SALFK
Collate: MACHINE

Table: au!contacts

Tag Type Caption Desc Sel

cts_cusfk
Regular
Shi Xxxfk
N
Y
Expression: CTS_CUSFK
Collate: MACHINE

cts_del
Regular
Deletions
N
N
Expression: DELETED()
Collate: MACHINE

cts_pk
Primary
Shi Pk
N
N
Expression: CTS_PK
Collate: MACHINE

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

date
Regular

N
Y
Expression: DATE
Collate: MACHINE

doneby
Regular
Doneby
N
Y
Expression: UPPER(DONEBY)
Collate: MACHINE

method
Regular
Method
N
Y
Expression: UPPER(METHOD)
Collate: MACHINE

next_step
Regular
Next Step
N
Y
Expression: NEXT_STEP
Collate: MACHINE

Table: au!country

Tag Type Caption Desc Sel

cou_ab
Regular
State Abbrev.
N
Y
Expression: COU_AB
Collate: MACHINE

cou_del
Regular
Sta Del
N
N
Expression: DELETED()
Collate: MACHINE

cou_name
Regular
State Name
N
Y
Expression: UPPER(COU_NAME)
Collate: MACHINE

cou_pk
Primary
Sta Pk
N
N
Expression: COU_PK
Collate: MACHINE

region
Regular
Region
N
Y
Expression: REGION
Collate: MACHINE

Table: au!credcard

Tag Type Caption Desc Sel

cre_cusfk
Regular
Customer FK
N
Y
Expression: CRE_CUSFK
Collate: MACHINE

cre_del
Regular
Cre Del
N
N
Expression: DELETED()
Collate: MACHINE

cre_pk
Primary
Cre Pk
N
N
Expression: CRE_PK
Collate: MACHINE

credcard
Regular

N
Y
Expression: CUST_NO+CRED_TYPE
Collate: MACHINE

Table: au!credin

Tag Type Caption Desc Sel

cin_pk
Primary
CIN_PK
N
N
Expression: CIN_PK
Collate: MACHINE

comments
Regular
Invoice Number
N
Y
Expression: LEFT(COMMENTS,6)
Collate: MACHINE

cre_del
Regular
Cre Del
N
N
Expression: DELETED()
Collate: MACHINE

Table: au!credpost

Tag Type Caption Desc Sel

cpo_pk
Primary
Cre Pk
N
N
Expression: CPO_PK
Collate: MACHINE

cre_del
Regular
Cre Del
N
N
Expression: DELETED()
Collate: MACHINE

Table: au!currency

Tag Type Caption Desc Sel

abbr
Regular
Abbreviation
N
Y
Expression: ABBR
Collate: MACHINE

cat_name
Regular
Cat Name
N
Y
Expression: CAT_NAME
Collate: MACHINE

code
Regular
Code
N
Y
Expression: UPPER(CODE)
Collate: MACHINE

cur_del
Regular
Delete
N
N
Expression: DELETED()
Collate: MACHINE

cur_pk
Primary
Currency PK
N
N
Expression: CUR_PK
Collate: MACHINE

currency
Regular
Currency
N
Y
Expression: UPPER(CURRENCY)
Collate: MACHINE

Table: au!custarch

Tag Type Caption Desc Sel

city
Regular

N
Y
Expression: UPPER(CITY)
Collate: MACHINE

company
Regular

N
Y
Expression: UPPER(COMPANY)
Collate: MACHINE

country
Regular

N
Y
Expression: UPPER(COUNTRY)
Collate: MACHINE

cus_coufk
Regular
Country Foreign Key
N
Y
Expression: CUS_COUFK
Collate: MACHINE

cus_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

cus_pk
Primary
Primary Key
N
Y
Expression: CUS_PK
Collate: MACHINE

cus_recst
Regular

N
Y
Expression: CUS_RECST
Collate: MACHINE

cust1
Regular

N
Y
Expression: CUST_NO
Collate: MACHINE

cust2
Regular

N
Y
Expression: UPPER(CUST_LNAME+CUST_FNAME)
Collate: MACHINE

cust3
Regular

N
Y
Expression: UPPER(STATE+CITY)
Collate: MACHINE

cust4
Regular

N
Y
Expression: UPPER(ZIP+COUNTRY)
Collate: MACHINE

cust5
Regular

N
Y
Expression: WPHONE
Collate: MACHINE

cust_lname
Regular

N
Y
Expression: UPPER(CUST_LNAME)
Collate: MACHINE

email
Regular

N
Y
Expression: UPPER(EMAIL)
Collate: MACHINE

ib_number
Regular

N
Y
Expression: IB_NUMBER
Collate: MACHINE

sh_coufk
Regular
Shipping Country Foreign Key
N
Y
Expression: SH_COUFK
Collate: MACHINE

sh_country
Regular

N
Y
Expression: UPPER(SH_COUNTRY)
Collate: MACHINE

state
Regular

N
Y
Expression: UPPER(STATE)
Collate: MACHINE

zip
Regular

N
Y
Expression: UPPER(ZIP)
Collate: MACHINE

Table: au!custdict

Tag Type Caption Desc Sel

cd_pk
Primary
Cd Pk
N
Y
Expression: CD_PK
Collate: MACHINE

laststring
Regular
Last Updated String
N
Y
Expression: TTOC(LASTUPDT,1)
Collate: MACHINE

operator
Regular
User ID
N
Y
Expression: OPERATOR
Collate: MACHINE

word
Regular
Word
N
Y
Expression: WORD
Collate: MACHINE

wordupper
Regular
Uppercase Word
N
Y
Expression: UPPER(WORD)
Collate: MACHINE

Table: au!custlog

Tag Type Caption Desc Sel

cul_cusfk
Regular
Customer FK
N
Y
Expression: CUL_CUSFK
Collate: MACHINE

cul_pk
Primary
CUL_PK
N
N
Expression: CUL_PK
Collate: MACHINE

cus_del
Regular
Cus Del
N
N
Expression: DELETED()
Collate: MACHINE

Table: au!customer

Tag Type Caption Desc Sel

addr1
Regular
Address Line 1
N
Y
Expression: UPPER(ADDR1)
Collate: MACHINE

birthdate
Regular
Birth Date
N
Y
Expression: BIRTHDATE
Collate: MACHINE

city
Regular
City
N
Y
Expression: UPPER(CITY)
Collate: MACHINE

company
Regular

N
Y
Expression: UPPER(COMPANY)
Collate: MACHINE

country
Regular

N
Y
Expression: UPPER(COUNTRY)
Collate: MACHINE

cphone
Regular
Cell Phone
N
Y
Expression: CPHONE
Collate: MACHINE

cus_coufk
Regular
Country Foreign Key
N
Y
Expression: CUS_COUFK
Collate: MACHINE

cus_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

cus_pk
Primary
Primary Key
N
Y
Expression: CUS_PK
Collate: MACHINE

cus_recst
Regular

N
Y
Expression: CUS_RECST
Collate: MACHINE

cusfilter
Regular
Customer Filter
N
Y
Expression: CUSFILTER
Collate: MACHINE

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

cust_fname
Regular
First Name
N
Y
Expression: UPPER(CUST_FNAME)
Collate: MACHINE

cust_idno
Regular
Customer ID Number (Drivers Licence/Passport)
N
Y
Expression: CUST_IDNO
Collate: MACHINE

cust_lname
Regular
Last Name
N
Y
Expression: UPPER(CUST_LNAME)+UPPER(CUST_FNAME)
Collate: MACHINE

cust_no
Regular

N
Y
Expression: CUST_NO
Collate: MACHINE

custlname
Regular
Last Name
N
Y
Expression: UPPER(CUST_LNAME)
Collate: MACHINE

email
Regular

N
Y
Expression: UPPER(EMAIL)
Collate: MACHINE

email2
Regular
2nd eMail Address
N
Y
Expression: UPPER(EMAIL2)
Collate: MACHINE

fphone
Regular
Fax Phone
N
Y
Expression: FPHONE
Collate: MACHINE

handle
Regular
SAN Handle
N
Y
Expression: UPPER(HANDLE)
Collate: MACHINE

hphone
Regular
Home Phone
N
Y
Expression: HPHONE
Collate: MACHINE

ib_number
Regular

N
Y
Expression: UPPER(IB_NUMBER)
Collate: MACHINE

mail_flag
Regular
Mail Flag
N
Y
Expression: MAIL_FLAG
Collate: MACHINE

sales_rep
Regular
Sales Rep
N
Y
Expression: UPPER(SALES_REP)
Collate: MACHINE

sh_coufk
Regular
Shipping Country Foreign Key
N
Y
Expression: SH_COUFK
Collate: MACHINE

sh_country
Regular

N
Y
Expression: UPPER(SH_COUNTRY)
Collate: MACHINE

ship_zone
Regular
Ship Zone
N
Y
Expression: SHIP_ZONE
Collate: MACHINE

source
Regular
Source
N
Y
Expression: SOURCE
Collate: MACHINE

spec_info
Regular
Special Info
N
Y
Expression: UPPER(SPEC_INFO)
Collate: MACHINE

state
Regular

N
Y
Expression: UPPER(STATE)
Collate: MACHINE

total_real
Regular
Total Realized
N
Y
Expression: TOTAL_REAL
Collate: MACHINE

ttl_sold
Regular
Total Sold
N
Y
Expression: TTL_SOLD
Collate: MACHINE

wphone
Regular

N
Y
Expression: WPHONE
Collate: MACHINE

zip
Regular

N
Y
Expression: UPPER(ZIP)
Collate: MACHINE

Table: au!ebayfees

Tag Type Caption Desc Sel

eba_del
Regular
Eba Del
N
N
Expression: DELETED()
Collate: MACHINE

eba_pk
Primary
Eba Pk
N
N
Expression: EBA_PK
Collate: MACHINE

Table: au!ebayinv

Tag Type Caption Desc Sel

eba_del
Regular
Eba Del
N
N
Expression: DELETED()
Collate: MACHINE

ein_pk
Primary
EIN_PK
N
N
Expression: EIN_PK
Collate: MACHINE

Table: au!expcntrl

Tag Type Caption Desc Sel

exp_del
Regular
Exp Del
N
N
Expression: DELETED()
Collate: MACHINE

exp_pk
Primary
Exp Pk
N
N
Expression: EXP_PK
Collate: MACHINE

Table: au!filcond

Tag Type Caption Desc Sel

fc_filfk
Regular

N
Y
Expression: FC_FILFK
Collate: MACHINE

fc_pk
Primary

N
Y
Expression: FC_PK
Collate: MACHINE

Table: au!filters

Tag Type Caption Desc Sel

fil_alias
Regular

N
Y
Expression: FIL_ALIAS
Collate: MACHINE

fil_name
Regular

N
Y
Expression: FIL_NAME
Collate: MACHINE

fil_pk
Primary

N
Y
Expression: FIL_PK
Collate: MACHINE

Table: au!generatepk

Tag Type Caption Desc Sel

gpk_del
Regular
Gpk Del
N
N
Expression: DELETED()
Collate: MACHINE

gpk_pk
Primary
Gpk Pk
N
N
Expression: GPK_PK
Collate: MACHINE

Table: au!grower

Tag Type Caption Desc Sel

gro_code
Regular
Grower Code
N
Y
Expression: GRO_CODE
Collate: MACHINE

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

gro_descr
Regular
Grower Description
N
Y
Expression: UPPER(REPLFOREIGN(GRO_DESCR))
Collate: MACHINE

gro_pk
Primary
Grower Primary Key
N
Y
Expression: GRO_PK
Collate: MACHINE

Table: au!history

Tag Type Caption Desc Sel

his_buyfk
Regular
Buyer FK
N
Y
Expression: HIS_BUYFK
Collate: MACHINE

his_catfk
Regular
Category Foreign Key
N
Y
Expression: HIS_CATFK
Collate: MACHINE

his_confk
Regular
Consignor FK
N
Y
Expression: HIS_CONFK
Collate: MACHINE

his_del
Regular
His Del
N
N
Expression: DELETED()
Collate: MACHINE

his_lotfk
Regular
Lot Foreign Key
N
Y
Expression: HIS_LOTFK
Collate: MACHINE

his_pk
Primary
His Pk
N
N
Expression: HIS_PK
Collate: MACHINE

his_salfk
Regular
Sale Foreign Key
N
Y
Expression: HIS_SALFK
Collate: MACHINE

Table: au!index

Tag Type Caption Desc Sel

ind_pk
Primary

N
Y
Expression: IND_PK
Collate: MACHINE

Table: au!interest

Tag Type Caption Desc Sel

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

int_cusfk
Regular
Customer FK
N
Y
Expression: INT_CUSFK
Collate: MACHINE

int_del
Regular
Int Del
N
N
Expression: DELETED()
Collate: MACHINE

int_pk
Primary
Int Pk
N
N
Expression: INT_PK
Collate: MACHINE

int_type
Regular
Interest Type M-Mail, C-Collects, W-Want
N
Y
Expression: INT_TYPE
Collate: MACHINE

inter1
Regular

N
Y
Expression: CUST_NO+COLLECTS+LEVEL
Collate: MACHINE

inter2
Regular
Collects
N
Y
Expression: UPPER(COLLECTS)
Collate: MACHINE

Table: au!invoice

Tag Type Caption Desc Sel

amount
Regular
Total Amount of Invoice
N
Y
Expression: AMOUNT
Collate: MACHINE

cust_no
Regular
Customer No.
N
Y
Expression: CUST_NO
Collate: MACHINE

date
Regular
Invoice Date
N
Y
Expression: DATE
Collate: MACHINE

inv_cusfk
Regular
Customer FK
N
Y
Expression: INV_CUSFK
Collate: MACHINE

inv_del
Regular
Inv Del
N
N
Expression: DELETED()
Collate: MACHINE

inv_pk
Primary
Inv Pk
N
N
Expression: INV_PK
Collate: MACHINE

inv_salfk
Regular
Sale Foreign Key
N
Y
Expression: INV_SALFK
Collate: MACHINE

inv_status
Regular
Invoice Status
N
Y
Expression: INV_STATUS
Collate: MACHINE

inv_type
Regular
Type of Invoice
N
Y
Expression: INV_TYPE
Collate: MACHINE

invoice1
Regular

N
Y
Expression: INVOICE
Collate: MACHINE

invoice2
Regular

N
Y
Expression: CUST_NO+DTOS(DATE)+INVOICE
Collate: MACHINE

invoice3
Regular

N
Y
Expression: SALE_NO+CUST_NO
Collate: MACHINE

paddle
Regular
Paddle No.
N
Y
Expression: PADDLE
Collate: MACHINE

paid
Regular
Paid Status
N
Y
Expression: PAID
Collate: MACHINE

pickedup
Regular
Picked Up
N
Y
Expression: PICKEDUP
Collate: MACHINE

pull_date
Regular
Pull Date
N
Y
Expression: PULL_DATE
Collate: MACHINE

rcvd_date
Regular
Date Items on Invoice were Received and are ready for Shipment
N
Y
Expression: RCVD_DATE
Collate: MACHINE

rel_prntd
Regular
Release Printed
N
Y
Expression: REL_PRNTD
Collate: MACHINE

released
Regular
Released
N
Y
Expression: RELEASED
Collate: MACHINE

sale_no
Regular
Sale No.
N
Y
Expression: SALE_NO
Collate: MACHINE

sh_coufk
Regular
Shipping Country Foreign Key
N
Y
Expression: SH_COUFK
Collate: MACHINE

sh_country
Regular
Ship Country
N
Y
Expression: UPPER(SH_COUNTRY)
Collate: MACHINE

shipped
Regular
Shipped
N
Y
Expression: SHIPPED
Collate: MACHINE

source
Regular
Source
N
Y
Expression: SOURCE
Collate: MACHINE

Table: au!invpmts

Tag Type Caption Desc Sel

check_no
Regular
Check No
N
Y
Expression: CHECK_NO
Collate: MACHINE

cust_no
Regular
Customer Number
N
Y
Expression: CUST_NO
Collate: MACHINE

date_paid
Regular
Date Paid
N
Y
Expression: DATE_PAID
Collate: MACHINE

how_paid
Regular
How Paid
N
Y
Expression: UPPER(HOW_PAID)
Collate: MACHINE

inp_cusfk
Regular
Customer Foreign Key
N
Y
Expression: INP_CUSFK
Collate: MACHINE

inp_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

inp_invfk
Regular

N
Y
Expression: INP_INVFK
Collate: MACHINE

inp_pk
Primary

N
Y
Expression: INP_PK
Collate: MACHINE

invoice
Regular
Invoice Number
N
Y
Expression: INVOICE
Collate: MACHINE

pay_type
Regular
Pay Type
N
Y
Expression: PAY_TYPE+REF_NUM
Collate: MACHINE

ref_num
Regular
Sub Code
N
Y
Expression: REF_NUM
Collate: MACHINE

Table: au!lablset

Tag Type Caption Desc Sel

lab_del
Regular
Lab Del
N
N
Expression: DELETED()
Collate: MACHINE

lab_pk
Primary
Lab Pk
N
N
Expression: LAB_PK
Collate: MACHINE

Table: au!larchive

Tag Type Caption Desc Sel

buyer
Regular
Buyer
N
Y
Expression: UPPER(CUST_NO)
Collate: MACHINE

consignor
Regular
Consignor
N
Y
Expression: UPPER(CONSIGNOR)
Collate: MACHINE

date_sold
Regular
Date Sold
N
Y
Expression: DATE_SOLD
Collate: MACHINE

invoice
Regular
Invoice No.
N
Y
Expression: INVOICE
Collate: MACHINE

lot_apfk
Regular
AP record Foreign Key
N
Y
Expression: LOT_APFK
Collate: MACHINE

lot_buyfk
Regular
Lot Buyfk
N
Y
Expression: LOT_BUYFK
Collate: MACHINE

lot_catfk
Regular
Category Foreign Key
N
Y
Expression: LOT_CATFK
Collate: MACHINE

lot_confk
Regular
Lot Confk
N
Y
Expression: LOT_CONFK
Collate: MACHINE

lot_del
Regular
Lot Del
N
N
Expression: DELETED()
Collate: MACHINE

lot_invfk
Regular
Invoice Foreign Key
N
Y
Expression: LOT_INVFK
Collate: MACHINE

lot_no
Regular
Lot No
N
Y
Expression: UPPER(LOT_NO)
Comments: used in selects
Collate: MACHINE

lot_pk
Primary
Lot Pk
N
Y
Expression: LOT_PK
Collate: MACHINE

lot_salfk
Regular
Sale Foreign Key
N
Y
Expression: LOT_SALFK
Collate: MACHINE

lots3
Regular
Lots3
N
Y
Expression: SEEKLOT(LOT_NO)
Comments: Used to set order by LotNo to sort correctly. Note, must be filtered by Sale_No in order to work like DOS system. This one is being used.
Collate:

paddle
Regular
Won by Paddle No.
N
Y
Expression: PADDLE
Collate: MACHINE

sale_no
Regular
Sale No
N
Y
Expression: SALE_NO
Collate: MACHINE

seq_num
Regular
Seq Num
N
Y
Expression: SEQ_NUM
Collate: MACHINE

srtorder
Regular
Catalog No.
N
Y
Expression: UPPER(SRTORDER)
Collate: MACHINE

Table: au!lindex

Tag Type Caption Desc Sel

lin_catfk
Regular
Category Foreign Key
N
Y
Expression: LIN_CATFK
Collate: MACHINE

lin_del
Regular
Lin Del
N
N
Expression: DELETED()
Collate: MACHINE

lin_lotfk
Regular
Lin Lotfk
N
Y
Expression: LIN_LOTFK
Collate: MACHINE

lin_pk
Primary
Lin Pk
N
Y
Expression: LIN_PK
Collate: MACHINE

lin_salfk
Regular
Sale Foreign Key
N
Y
Expression: LIN_SALFK
Collate: MACHINE

lindex1
Regular
Lindex1
N
Y
Expression: SALE_NO+SEQ_NUM
Collate: MACHINE

lindex2
Regular
Lindex2
N
Y
Expression: SALE_NO+SEEKLOT(LOT_NO)
Collate: MACHINE

lindex3
Regular
Lindex3
N
Y
Expression: SALE_NO+CATEGORY+SEEKLOT(LOT_NO)
Collate: MACHINE

Table: au!loginhistory

Tag Type Caption Desc Sel

ulh_del
Regular
Ulh Del
N
N
Expression: DELETED()
Collate: MACHINE

ulh_pk
Primary
Ulh Pk
N
N
Expression: ULH_PK
Collate: MACHINE

ulh_usrfk
Regular
Ulh Usrfk
N
Y
Expression: ULH_USRFK
Collate: MACHINE

Table: au!lots

Tag Type Caption Desc Sel

addlotpk
Regular
PK in Invoices File (same as Lot_PK)
N
Y
Expression: ADDLOTPK
Collate: MACHINE

bidder
Regular
High Bidder No.
N
Y
Expression: UPPER(BIDDER)
Collate: MACHINE

buyer
Regular
Buyer
N
Y
Expression: UPPER(CUST_NO)
Collate: MACHINE

catalog
Regular
Catalog
N
Y
Expression: UPPER(CATALOG)
Collate: MACHINE

consignor
Regular
Consignor
N
Y
Expression: UPPER(CONSIGNOR)
Collate: MACHINE

date_sold
Regular
Date Sold
N
Y
Expression: DATE_SOLD
Collate: MACHINE

invoice
Regular
Invoice No.
N
Y
Expression: INVOICE
Collate: MACHINE

last_edit
Regular
Last Date Edited
N
Y
Expression: LAST_EDIT
Collate: MACHINE

lot_apfk
Regular
AP record Foreign Key
N
Y
Expression: LOT_APFK
Collate: MACHINE

lot_apsfk
Regular
AP Sort Foreign Key
N
Y
Expression: LOT_APSFK
Collate: MACHINE

lot_buyfk
Regular
Lot Buyfk
N
Y
Expression: LOT_BUYFK
Collate: MACHINE

lot_catfk
Regular
Category Foreign Key
N
Y
Expression: LOT_CATFK
Collate: MACHINE

lot_confk
Regular
Lot Confk
N
Y
Expression: LOT_CONFK
Collate: MACHINE

lot_del
Regular
Lot Del
N
N
Expression: DELETED()
Collate: MACHINE

lot_grofk
Regular
Grower Foreign Key
N
Y
Expression: LOT_GROFK
Collate: MACHINE

lot_invfk
Regular
Invoice Foreign Key
N
Y
Expression: LOT_INVFK
Collate: MACHINE

lot_no
Regular
Lot No
N
Y
Expression: UPPER(LOT_NO)
Comments: used in selects
Collate: MACHINE

lot_pk
Primary
Lot Pk
N
Y
Expression: LOT_PK
Collate: MACHINE

lot_salfk
Regular
Sale Foreign Key
N
Y
Expression: LOT_SALFK
Collate: MACHINE

lot_winfk
Regular
Wine Foreign Key
N
Y
Expression: LOT_WINFK
Collate: MACHINE

lots1
Regular
Lots1
N
Y
Expression: CATEGORY
Comments: Was upper(Sale_NO) + category, put taken out
Collate: MACHINE

lots3
Regular
Lots3
N
Y
Expression: SEEKLOT(LOT_NO)
Comments: Used to set order by LotNo to sort correctly. Note, must be filtered by Sale_No in order to work like DOS system. This one is being used.
Collate:

number_bo
Regular
Number Backordered
N
Y
Expression: NUMBER_BO
Collate: MACHINE

number_lot
Regular
Number of Lots
N
Y
Expression: NUMBER_LOT
Collate: MACHINE

origlotpk
Regular
Original Lot_PK from Inventory
N
Y
Expression: ORIGLOTPK
Collate: MACHINE

paddle
Regular
Won by Paddle No.
N
Y
Expression: PADDLE
Collate: MACHINE

par_lotfk
Regular
Parcel Lot Foreign Key
N
Y
Expression: PAR_LOTFK
Collate: MACHINE

pr_type
Regular
PR Type
N
Y
Expression: PR_TYPE
Collate: MACHINE

prop_num
Regular
Property No.
N
Y
Expression: PROP_NUM
Collate: MACHINE

realized
Regular
Realized
N
Y
Expression: REALIZED
Collate: MACHINE

ref_num
Regular
Reference No.
N
Y
Expression: REF_NUM
Collate: MACHINE

sale_no
Regular
Sale No
N
Y
Expression: SALE_NO
Collate: MACHINE

salelot
Regular

N
Y
Expression: SALE_NO+LOT_NO
Collate: MACHINE

seq_num
Regular
Seq Num
N
Y
Expression: SEQ_NUM
Collate: MACHINE

srtorder
Regular
Catalog No.
N
Y
Expression: UPPER(SRTORDER)
Collate: MACHINE

Table: au!mailhist

Tag Type Caption Desc Sel

cust_no
Regular

N
Y
Expression: CUST_NO
Collate: MACHINE

mail_flag
Regular
Mail Flag
N
Y
Expression: MAIL_FLAG
Collate: MACHINE

Table: au!mailing

Tag Type Caption Desc Sel

mai_del
Regular
Mai Del
N
N
Expression: DELETED()
Collate: MACHINE

mai_pk
Primary
Mai Pk
N
N
Expression: MAI_PK
Collate: MACHINE

Table: au!memoae

Tag Type Caption Desc Sel

mae_code
Candidate
Mae Code
N
Y
Expression: STR(MAE_USRFK)+UPPER(MAE_CODE)
Filter: .NOT.DELETED()
Collate: MACHINE

Table: au!miscinv

Tag Type Caption Desc Sel

mis_del
Regular
Mis Del
N
N
Expression: DELETED()
Collate: MACHINE

mis_invfk
Regular
Invoice Foreign Key
N
Y
Expression: MIS_INVFK
Collate: MACHINE

mis_pk
Primary
Mis Pk
N
N
Expression: MIS_PK
Collate: MACHINE

miscinv
Regular

N
Y
Expression: INVOICE+SEEKLOT(LOT_NO)+SEQ_NUM
Collate: MACHINE

Table: au!moreap

Tag Type Caption Desc Sel

api_apfk
Regular
Api Apfk
N
Y
Expression: API_APFK
Collate: MACHINE

api_confk
Regular
Conignor Foreign Key
N
Y
Expression: API_CONFK
Collate: MACHINE

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

api_pk
Primary
Mor Pk
N
Y
Expression: API_PK
Collate: MACHINE

api_salfk
Regular
Sale Foreign Key
N
Y
Expression: API_SALFK
Collate: MACHINE

check_no
Regular
Check Number
N
Y
Expression: CHECK_NO
Collate: MACHINE

moreap
Regular

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

Table: au!mxlot

Tag Type Caption Desc Sel

case_no
Regular
Case No
N
Y
Expression: CASE_NO
Collate: MACHINE

inv_loc
Regular
Warehouse Location
N
Y
Expression: INV_LOC
Collate: MACHINE

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

mxl_grofk
Regular
Grower Foreign Key
N
Y
Expression: MXL_GROFK
Collate: MACHINE

mxl_lotfk
Regular
Lot Foreign Key
N
Y
Expression: MXL_LOTFK
Collate: MACHINE

mxl_pk
Primary
Mixed Lot Primary Key
N
Y
Expression: MXL_PK
Collate: MACHINE

mxl_sizfk
Regular
Bottle Size Foreign Key
N
Y
Expression: MXL_SIZFK
Collate: MACHINE

mxl_winfk
Regular
Wine Foreign Key
N
Y
Expression: MXL_WINFK
Collate: MACHINE

mxref_num
Regular
Client Ref. No
N
Y
Expression: MXREF_NUM
Collate: MACHINE

rec_date
Regular
Receipt Date
N
Y
Expression: REC_DATE
Collate: MACHINE

ship_date
Regular
Ship Date
N
Y
Expression: SHIP_DATE
Collate: MACHINE

tracking
Regular
Tracking No
N
Y
Expression: TRACKING
Collate: MACHINE

vintage
Regular
Vintage
N
Y
Expression: VINTAGE
Collate: MACHINE

whse
Regular
WareHouse
N
Y
Expression: WHSE
Collate: MACHINE

Table: au!newcust

Tag Type Caption Desc Sel

new_del
Regular
New Del
N
N
Expression: DELETED()
Collate: MACHINE

new_pk
Primary
New Pk
N
N
Expression: NEW_PK
Collate: MACHINE

new_xxxfk
Regular
New Xxxfk
N
Y
Expression: NEW_XXXFK
Collate: MACHINE

Table: au!nextlot

Tag Type Caption Desc Sel

nex_del
Regular
Nex Del
N
N
Expression: DELETED()
Collate: MACHINE

nex_pk
Primary
Nex Pk
N
N
Expression: NEX_PK
Collate: MACHINE

nex_xxxfk
Regular
Nex Xxxfk
N
Y
Expression: NEX_XXXFK
Collate: MACHINE

Table: au!outbid

Tag Type Caption Desc Sel

out_del
Regular
Out Del
N
N
Expression: DELETED()
Collate: MACHINE

out_pk
Primary
Primary Key
N
Y
Expression: OUT_PK
Collate: MACHINE

out_xxxfk
Regular
Out Xxxfk
N
Y
Expression: OUT_XXXFK
Collate: MACHINE

outbid
Regular

N
Y
Expression: SALE_NO+CUST_NO+SEEKLOT(LOT_NO)
Collate: MACHINE

Table: au!paddle

Tag Type Caption Desc Sel

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

pad_cusfk
Regular

N
Y
Expression: PAD_CUSFK
Collate: MACHINE

pad_del
Regular

N
N
Expression: DELETED()
Collate: MACHINE

pad_pk
Primary

N
N
Expression: PAD_PK
Collate: MACHINE

pad_salbfk
Regular

N
Y
Expression: PAD_SALBFK
Collate: MACHINE

pad_salfk
Regular
Sale Foreign Key
N
Y
Expression: PAD_SALFK
Collate: MACHINE

paddle
Regular
Paddle No.
N
Y
Expression: PADDLE
Collate: MACHINE

sale_no
Regular
Sale No.
N
Y
Expression: SALE_NO
Collate: MACHINE

Table: au!pbcalls

Tag Type Caption Desc Sel

pbc_del
Regular
Pbc Del
N
N
Expression: DELETED()
Collate: MACHINE

pbc_pk
Primary
Pbc Pk
N
N
Expression: PBC_PK
Collate: MACHINE

pbc_xxxfk
Regular
Pbc Xxxfk
N
Y
Expression: PBC_XXXFK
Collate: MACHINE

Table: au!pbfailed

Tag Type Caption Desc Sel

pbf_del
Regular
Pbf Del
N
N
Expression: DELETED()
Collate: MACHINE

pbf_pk
Primary
Pbf Pk
N
N
Expression: PBF_PK
Collate: MACHINE

pbf_xxxfk
Regular
Pbf Xxxfk
N
Y
Expression: PBF_XXXFK
Collate: MACHINE

Table: au!pfexport

Tag Type Caption Desc Sel

app_lotfk
Regular
Primary Key of Lot
N
Y
Expression: APP_LOTFK
Collate: MACHINE

appl_no
Regular

N
Y
Expression: APPL_NO
Collate: MACHINE

catalog_no
Regular
Catalog No
N
Y
Expression: UPPER(CATALOG_NO)
Collate: MACHINE

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

cust_no
Regular

N
Y
Expression: CUST_NO
Collate: MACHINE

date_appl
Regular

N
Y
Expression: DATE_APPL
Collate: MACHINE

denom
Regular
Denom
N
Y
Expression: UPPER(DENOM)
Collate: MACHINE

invoiceno
Regular

N
Y
Expression: INVOICENO
Collate: MACHINE

issued
Regular

N
Y
Expression: ISSUED
Collate: MACHINE

issuedate
Regular

N
Y
Expression: ISSUEDATE
Collate: MACHINE

lot_no
Regular

N
Y
Expression: LOT_NO
Collate: MACHINE

othername
Regular
Othername
N
Y
Expression: UPPER(OTHERNAME)
Collate: MACHINE

pfe_pk
Primary

N
Y
Expression: PFE_PK
Collate: MACHINE

prev_no
Regular

N
Y
Expression: PREV_NO
Collate: MACHINE

sale_no
Regular

N
Y
Expression: SALE_NO
Collate: MACHINE

seq_num
Regular

N
Y
Expression: SEQ_NUM
Collate: MACHINE

subtype
Regular

N
Y
Expression: SUBTYPE
Collate: MACHINE

Table: au!phonebid

Tag Type Caption Desc Sel

pho_del
Regular
Pho Del
N
N
Expression: DELETED()
Collate: MACHINE

pho_pk
Primary
Pho Pk
N
N
Expression: PHO_PK
Collate: MACHINE

pho_xxxfk
Regular
Pho Xxxfk
N
Y
Expression: PHO_XXXFK
Collate: MACHINE

Table: au!phrases

Tag Type Caption Desc Sel

allowedt
Regular
Allowedt
N
Y
Expression: ALLOWEDT
Collate: MACHINE

allowtxt
Regular
Allowtxt
N
Y
Expression: ALLOWTXT
Collate: MACHINE

autotype
Regular
Spell Check Autotype
N
Y
Expression: AUTOTYPE
Collate: MACHINE

code
Regular
Code
N
Y
Expression: UPPER(CODE)
Collate: MACHINE

hotkey
Regular
Hotkey
N
Y
Expression: HOTKEY
Collate: MACHINE

phr_pk
Primary
Phr Pk
N
Y
Expression: PHR_PK
Collate: MACHINE

txtphrase
Regular
Txtphrase
N
Y
Expression: TXTPHRASE
Collate: MACHINE

Table: au!postview

Tag Type Caption Desc Sel

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

date_in
Regular
Date In
N
Y
Expression: DATE_IN
Collate: MACHINE

invoice
Regular
Invoice
N
Y
Expression: INVOICE
Collate: MACHINE

lot_no
Regular
Lot No.
N
Y
Expression: UPPER(LOT_NO)
Collate: MACHINE

pos_cusfk
Regular
Customer Foeign Key
N
Y
Expression: POS_CUSFK
Collate: MACHINE

pos_del
Regular
Pos Del
N
N
Expression: DELETED()
Collate: MACHINE

pos_lotfk
Regular
Lot Foreign Key
N
Y
Expression: POS_LOTFK
Collate: MACHINE

pos_pk
Primary
Pos Pk
N
N
Expression: POS_PK
Collate: MACHINE

sale_no
Regular
Sale No.
N
Y
Expression: SALE_NO
Collate: MACHINE

Table: au!profiles

Tag Type Caption Desc Sel

pro_del
Regular
Pro Del
N
N
Expression: DELETED()
Collate: MACHINE

pro_pk
Primary
Pro Pk
N
N
Expression: PRO_PK
Collate: MACHINE

pro_xxxfk
Regular
Pro Xxxfk
N
Y
Expression: PRO_XXXFK
Collate: MACHINE

sale_no
Regular

N
Y
Expression: SALE_NO
Collate: MACHINE

Table: au!profit

Tag Type Caption Desc Sel

pro_del
Regular
Pro Del
N
N
Expression: DELETED()
Collate: MACHINE

pro_pk
Primary
Pro Pk
N
N
Expression: PRO_PK
Collate: MACHINE

pro_xxxfk
Regular
Pro Xxxfk
N
Y
Expression: PRO_XXXFK
Collate: MACHINE

Table: au!prtype

Tag Type Caption Desc Sel

prdesc
Regular
Description
N
Y
Expression: UPPER(PRDESC)
Collate: MACHINE

prtype
Primary
Prtype
N
Y
Expression: PRTYPE
Collate: MACHINE

Table: au!qrystore

Tag Type Caption Desc Sel

qry_pk
Primary

N
Y
Expression: QRY_PK
Collate: MACHINE

qrydescrip
Regular
Description of Query
N
Y
Expression: UPPER(QRYDESCRIP)
Collate: MACHINE

txt_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

Table: au!readme

Tag Type Caption Desc Sel

rea_pk
Primary

N
Y
Expression: REA_PK
Collate: MACHINE

readme
Regular
Descrip
N
Y
Expression: UPPER(DESCRIP)
Collate: MACHINE

red_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

Table: au!release

Tag Type Caption Desc Sel

rel_pk
Primary
Rel Pk
N
Y
Expression: REL_PK
Collate: MACHINE

release1
Regular
Release1
N
Y
Expression: CODE
Collate: MACHINE

release2
Regular
Release2
N
Y
Expression: DESCRIP
Collate: MACHINE

Table: au!reportcatalog

Tag Type Caption Desc Sel

rep_frx
Regular
Rep Frx
N
Y
Expression: UPPER(REP_FRX)
Collate: MACHINE

rep_name
Regular
Rep Name
N
Y
Expression: UPPER(REP_NAME)
Collate: MACHINE

rep_pk
Primary
Rep Pk
N
N
Expression: REP_PK
Collate: MACHINE

Table: au!returns

Tag Type Caption Desc Sel

invoice
Regular
Invoice No.
N
Y
Expression: INVOICE
Collate: MACHINE

lot_no
Regular
Lot No.
N
Y
Expression: UPPER(LOT_NO)
Collate: MACHINE

ret_del
Regular
Ret Del
N
N
Expression: DELETED()
Collate: MACHINE

ret_lotfk
Regular
Lot Foreign Key
N
Y
Expression: RET_LOTFK
Collate: MACHINE

ret_pk
Primary
Ret Pk
N
N
Expression: RET_PK
Collate: MACHINE

sale_no
Regular
Sale Number
N
Y
Expression: SALE_NO+SEEKLOT(LOT_NO)
Collate: MACHINE

seeklot
Regular
Lot No.
N
Y
Expression: SEEKLOT(LOT_NO)
Collate: MACHINE

seq_num
Regular
Inventory No.
N
Y
Expression: SEQ_NUM
Collate: MACHINE

Table: au!salebids

Tag Type Caption Desc Sel

bidsheet
Regular
Bidsheet Id
N
Y
Expression: BIDSHEET
Collate: MACHINE

cred_no
Regular

N
Y
Expression: UPPER(CRED_NO)
Collate: MACHINE

cust_no
Regular

N
Y
Expression: CUST_NO
Collate: MACHINE

sal_del
Regular
Sal Del
N
N
Expression: DELETED()
Collate: MACHINE

salb_cusfk
Regular
Customer foreign key
N
Y
Expression: SALB_CUSFK
Collate: MACHINE

salb_pk
Primary
Sal Pk
N
N
Expression: SALB_PK
Collate: MACHINE

salb_salfk
Regular
Sale Foreign Key
N
Y
Expression: SALB_SALFK
Collate: MACHINE

sale_no
Regular

N
Y
Expression: SALE_NO
Collate: MACHINE

salebids
Regular
Customer Bids
N
Y
Expression: UPPER(CUST_NO+SALE_NO)
Collate: MACHINE

Table: au!sales

Tag Type Caption Desc Sel

active
Regular
Active
N
Y
Expression: ACTIVE+DBC_SORT(SALE_NO," "," ")
Collate: MACHINE

descrip
Regular
Description
N
Y
Expression: UPPER(DESCRIP)
Collate: MACHINE

dtosdate
Regular
Start Date of Sale
N
Y
Expression: DTOS(DATE)
Collate: MACHINE

sal_del
Regular
Sal Del
N
N
Expression: DELETED()
Collate: MACHINE

sal_pk
Primary
Sal Pk
N
N
Expression: SAL_PK
Collate: MACHINE

sale_no
Regular
Sale Number
N
Y
Expression: UPPER(SALE_NO)
Collate: MACHINE

salecode
Regular
Salecode
N
Y
Expression: UPPER(SALECODE)
Collate: MACHINE

saledate
Regular
Saledate
N
Y
Expression: UPPER(SALEDATE)
Collate: MACHINE

saleno
Regular
Sale No.
N
Y
Expression: DBC_SORT(SALE_NO," "," ")
Collate: MACHINE

Table: au!securityaccess

Tag Type Caption Desc Sel

acc_del
Regular
Acc Del
N
N
Expression: DELETED()
Collate: MACHINE

acc_pk
Primary
Acc Pk
N
N
Expression: ACC_PK
Collate: MACHINE

acc_sitfk
Regular
Acc Sitfk
N
Y
Expression: ACC_SITFK
Collate: MACHINE

acc_ugrfk
Regular
Acc Ugrfk
N
Y
Expression: ACC_UGRFK
Collate: MACHINE

Table: au!shiphist

Tag Type Caption Desc Sel

date
Regular

N
Y
Expression: DATE
Collate: MACHINE

invoice
Regular

N
Y
Expression: INVOICE
Collate: MACHINE

method
Regular
Method
N
Y
Expression: UPPER(METHOD)
Collate: MACHINE

shi_cusfk
Regular
Shi Xxxfk
N
Y
Expression: SHI_CUSFK
Collate: MACHINE

shi_del
Regular
Shi Del
N
N
Expression: DELETED()
Collate: MACHINE

shi_invfk
Regular
Shi Invfk
N
Y
Expression: SHI_INVFK
Collate: MACHINE

shi_pk
Primary
Shi Pk
N
N
Expression: SHI_PK
Collate: MACHINE

shi_salfk
Regular
Sale Foreign Key
N
Y
Expression: SHI_SALFK
Collate: MACHINE

shiphist
Regular

N
Y
Expression: CUST_NO+WWDESCEND(DTOS(DATE))
Collate: MACHINE

track_num
Regular
Tracking No.
N
Y
Expression: UPPER(TRACK_NUM)
Collate: MACHINE

Table: au!shipping

Tag Type Caption Desc Sel

carrier
Regular
Carrier
N
Y
Expression: CARRIER
Collate: MACHINE

shi_del
Regular
Shi Del
N
N
Expression: DELETED()
Collate: MACHINE

shi_pk
Primary
Shi Pk
N
N
Expression: SHI_PK
Collate: MACHINE

shipping
Regular

N
Y
Expression: WEIGHT
Collate: MACHINE

weight
Regular
Carrier, Weight
N
Y
Expression: CARRIER+STR(WEIGHT,4)
Collate: MACHINE

Table: au!size

Tag Type Caption Desc Sel

literage
Regular
Literage
N
Y
Expression: LITERAGE
Collate: MACHINE

siz_code
Regular
Bottle Size Code
N
Y
Expression: SIZ_CODE
Collate: MACHINE

siz_del
Regular
deleted
N
Y
Expression: DELETED()
Collate: MACHINE

siz_descr
Regular
Bottle Size Description
N
Y
Expression: UPPER(SIZ_DESCR)
Collate: MACHINE

siz_pk
Primary
Bottle Size Primary Key
N
Y
Expression: SIZ_PK
Collate: MACHINE

Table: au!specinfo

Tag Type Caption Desc Sel

descrip
Regular
Description
N
Y
Expression: UPPER(DESCRIP)
Collate: MACHINE

spe_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

spe_pk
Primary
Primary Key
N
Y
Expression: SPE_PK
Collate: MACHINE

spec_info
Regular
Code
N
Y
Expression: SPEC_INFO
Collate: MACHINE

Table: au!stamps

Tag Type Caption Desc Sel

catcode
Regular
Category
N
Y
Expression: CATEGORY
Collate: MACHINE

category
Regular

N
Y
Expression: CATEGORY+DBC_SORT(SRTORDER," "," ","STAMPS")
Collate: MACHINE

catsrtordr
Regular
candidate key check
N
Y
Expression: CATEGORY+SRTORDER
Collate: MACHINE

descrip
Regular
Description
N
Y
Expression: UPPER(LEFT(DESCRIP,100))
Collate: MACHINE

gibbons
Regular
Gibbons
N
Y
Expression: GIBBONS
Collate: MACHINE

scottnum
Regular
Scott No.
N
Y
Expression: SCOTTNUM
Collate: MACHINE

scottsort
Regular
Scott Sort
N
Y
Expression: DBC_SORT(SRTORDER," "," ","STAMPS")
Collate: MACHINE

srtorder
Regular
Catalog Number
N
Y
Expression: UPPER(SRTORDER)
Collate: MACHINE

sta_catfk
Regular
Category Foreign Key
N
Y
Expression: STA_CATFK
Collate: MACHINE

sta_del
Regular
Sta Del
N
N
Expression: DELETED()
Collate: MACHINE

sta_pk
Primary
Sta Pk
N
N
Expression: STA_PK
Collate: MACHINE

Table: au!state

Tag Type Caption Desc Sel

st_ab
Regular
State Abbrev.
N
Y
Expression: ST_AB
Collate: MACHINE

st_name
Regular
State Name
N
Y
Expression: UPPER(ST_NAME)
Collate: MACHINE

sta_del
Regular
Sta Del
N
N
Expression: DELETED()
Collate: MACHINE

sta_pk
Primary
Sta Pk
N
N
Expression: STA_PK
Collate: MACHINE

Table: au!tasting

Tag Type Caption Desc Sel

ckcheck
Regular
Candidate Key on Wine plus Grower
N
Y
Expression: STR(TAS_WINFK,10)+STR(TAS_GROFK,10)+VINTAGE+DTOS(DATE_NOTE)+NOTE_BY
Collate: MACHINE

date_note
Regular
Date of Note
N
Y
Expression: DATE_NOTE
Collate: MACHINE

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

tas_grofk
Regular

N
Y
Expression: TAS_GROFK
Collate: MACHINE

tas_pk
Primary
Tasting Primary Key
N
Y
Expression: TAS_PK
Collate: MACHINE

tas_winfk
Regular
Wine Foreign Key
N
Y
Expression: TAS_WINFK
Collate: MACHINE

vintage
Regular
Vintage
N
Y
Expression: VINTAGE
Collate: MACHINE

Table: au!taxtbl

Tag Type Caption Desc Sel

city
Regular
City
N
Y
Expression: UPPER(CITY)
Collate: MACHINE

county
Regular
County
N
Y
Expression: UPPER(COUNTY)
Collate: MACHINE

sta_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

state
Regular
State Name
N
Y
Expression: UPPER(STATE)
Collate: MACHINE

tax_pk
Primary
Primary Key
N
Y
Expression: TAX_PK
Collate: MACHINE

zip1
Regular
Starting Zip Range
N
Y
Expression: ZIP1
Collate: MACHINE

zip2
Regular
Ending Zip Range
N
Y
Expression: ZIP2
Collate: MACHINE

Table: au!tranxtn

Tag Type Caption Desc Sel

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

invoice
Regular
Invoice
N
Y
Expression: INVOICE
Collate: MACHINE

sale_no
Regular
Sale No.
N
Y
Expression: SALE_NO
Collate: MACHINE

trx_apfk
Regular
Api Apfk
N
Y
Expression: TRX_APFK
Collate: MACHINE

trx_cusfk
Regular
Conignor Foreign Key
N
Y
Expression: TRX_CUSFK
Collate: MACHINE

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

trx_invfk
Regular
Invoice Foreign Key
N
Y
Expression: TRX_INVFK
Collate: MACHINE

trx_pk
Primary
Mor Pk
N
Y
Expression: TRX_PK
Collate: MACHINE

trx_salfk
Regular
Sale Foreign Key
N
Y
Expression: TRX_SALFK
Collate: MACHINE

Table: au!txtstore

Tag Type Caption Desc Sel

txt_code
Regular
Descrip
N
Y
Expression: UPPER(TXT_CODE)
Collate: MACHINE

txt_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

txt_pk
Primary

N
Y
Expression: TXT_PK
Collate: MACHINE

txtdescrip
Regular
Description of Text
N
Y
Expression: UPPER(TXTDESCRIP)
Collate: MACHINE

Table: au!upszone

Tag Type Caption Desc Sel

ucarrier
Regular

N
Y
Expression: UCARRIER
Collate: MACHINE

ups_pk
Primary
Shipping Zones Primary Key
N
Y
Expression: UPS_PK
Collate: MACHINE

zip1
Regular
Zip Code
N
Y
Expression: ZIP1
Collate: MACHINE

Table: au!useraccexceptions

Tag Type Caption Desc Sel

uae_del
Regular
Uae Del
N
N
Expression: DELETED()
Collate: MACHINE

uae_pk
Primary
Uae Pk
N
N
Expression: UAE_PK
Collate: MACHINE

uae_sitfk
Regular
Uae Sitfk
N
Y
Expression: UAE_SITFK
Collate: MACHINE

uae_usrfk
Regular
Uae Usrfk
N
Y
Expression: UAE_USRFK
Collate: MACHINE

Table: au!usergroups

Tag Type Caption Desc Sel

ugr_del
Regular
Ugr Del
N
N
Expression: DELETED()
Collate: MACHINE

ugr_desc
Candidate
Ugr Desc
N
Y
Expression: UPPER(UGR_DESCRIPTION)
Filter: .NOT.DELETED()
Collate: MACHINE

ugr_group
Candidate
Ugr Group
N
Y
Expression: UPPER(UGR_GROUP)
Filter: .NOT.DELETED()
Collate: MACHINE

ugr_pk
Primary
Ugr Pk
N
N
Expression: UGR_PK
Collate: MACHINE

Table: au!userprefs

Tag Type Caption Desc Sel

prf_ck
Candidate
Prf Ck
N
Y
Expression: PADL(PRF_USRFK,10)+UPPER(PRF_ITEM)
Filter: .NOT.DELETED()
Collate: MACHINE

prf_del
Regular
Prf Del
N
N
Expression: DELETED()
Collate: MACHINE

prf_usrfk
Regular
Prf Usrfk
N
Y
Expression: PRF_USRFK
Collate: MACHINE

Table: au!users

Tag Type Caption Desc Sel

usr_del
Regular
Usr Del
N
N
Expression: DELETED()
Collate: MACHINE

usr_idpass
Regular
Usr Idpass
N
Y
Expression: UPPER(USR_LANID)+USR_PASSWORD
Collate: MACHINE

usr_lanid
Candidate
Usr Lanid
N
Y
Expression: UPPER(USR_LANID)
Filter: .NOT.DELETED()
Collate: MACHINE

usr_name
Candidate
Usr Name
N
Y
Expression: UPPER(USR_LASTNAME+USR_FIRSTNAME+USR_MIDDLEINITIAL)
Filter: .NOT.DELETED()
Collate: MACHINE

usr_pk
Primary
Usr Pk
N
N
Expression: USR_PK
Collate: MACHINE

Table: au!usrgrpxref

Tag Type Caption Desc Sel

ugx_del
Regular
Ugx Del
N
N
Expression: DELETED()
Collate: MACHINE

ugx_grpfk
Regular
Ugx Grpfk
N
Y
Expression: UGX_MEMBERFK
Filter: UGX_MEMBERTYPE="G"
Collate: MACHINE

ugx_mbrfk
Regular
Ugx Mbrfk
N
Y
Expression: UGX_MEMBERFK
Collate: MACHINE

ugx_mbrtyp
Regular
Ugx Mbrtyp
N
Y
Expression: UGX_MEMBERTYPE
Collate: MACHINE

ugx_pk
Primary
Ugx Pk
N
N
Expression: UGX_PK
Collate: MACHINE

ugx_ugrfk
Regular
Ugx Ugrfk
N
Y
Expression: UGX_UGRFK
Collate: MACHINE

ugx_usrfk
Regular
Ugx Usrfk
N
Y
Expression: UGX_MEMBERFK
Filter: UGX_MEMBERTYPE="U"
Collate: MACHINE

Table: au!vatcode

Tag Type Caption Desc Sel

vat_code
Regular
VAT Code
N
Y
Expression: VAT_CODE
Collate: MACHINE

vat_del
Regular
deleted
N
Y
Expression: DELETED()
Collate: MACHINE

vat_descr
Regular
VAT Description
N
Y
Expression: UPPER(VAT_DESCR)
Collate: MACHINE

vat_pk
Primary
VAT primary Key
N
Y
Expression: VAT_PK
Collate: MACHINE

vat_sort
Regular
Vat Sort in Catalog
N
Y
Expression: VAT_SORT
Collate: MACHINE

Table: au!vmpri

Tag Type Caption Desc Sel

xri_child
Regular
Xri Child
N
Y
Expression: UPPER(XRI_CHILD_TABLENAME)
Collate: MACHINE

xri_id
Candidate
Xri Id
N
Y
Expression: UPPER(LEFTC(XRI_PARENT_TABLENAME,115))+UPPER(LEFTC(XRI_CHILD_TABLENAME,115))+UPPER(XRI_CHILD_INDEX_TAG)
Filter: .NOT.DELETED()
Collate: MACHINE

xri_parent
Regular
Xri Parent
N
Y
Expression: UPPER(XRI_PARENT_TABLENAME)
Collate: MACHINE

Table: au!wantlist

Tag Type Caption Desc Sel

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

ref_num
Regular
Ref Num
N
Y
Expression: UPPER(REF_NUM)
Collate: MACHINE

srtorder
Regular
Srtorder
N
Y
Expression: UPPER(SRTORDER)
Collate: MACHINE

wl_catfk
Regular
Category Foreign Key
N
Y
Expression: WL_CATFK
Collate: MACHINE

wl_cusfk
Regular
Customer Foreign Key
N
Y
Expression: WL_CUSFK
Collate: MACHINE

wl_del
Regular
Deleted Records
N
N
Expression: DELETED()
Collate: MACHINE

wl_pk
Primary
Primary Key
N
Y
Expression: WL_PK
Collate: MACHINE

Table: au!wbids

Tag Type Caption Desc Sel

wbi_del
Regular
Wbi Del
N
N
Expression: DELETED()
Collate: MACHINE

Table: au!wclass

Tag Type Caption Desc Sel

cla_code
Regular
Classification Code
N
Y
Expression: CLA_CODE
Collate: MACHINE

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

cla_descr
Regular
Classification Description
N
Y
Expression: UPPER(REPLFOREIGN(CLA_DESCR))
Collate: MACHINE

cla_pk
Primary
Classification Primary Key
N
Y
Expression: CLA_PK
Collate: MACHINE

sort_code
Regular
Sort Code
N
Y
Expression: SORT_CODE
Collate: MACHINE

Table: au!wconvert

Tag Type Caption Desc Sel

city
Regular
City
N
Y
Expression: UPPER(CITY)
Collate: MACHINE

country
Regular

N
Y
Expression: COUNTRY
Collate: MACHINE

cust_lname
Regular
Last Name
N
Y
Expression: UPPER(CUST_LNAME)
Collate: MACHINE

cust_no
Regular

N
Y
Expression: CUST_NO
Collate: MACHINE

email
Regular
Primary Email Address
N
Y
Expression: UPPER(EMAIL)
Collate: MACHINE

ib_number
Regular

N
Y
Expression: IB_NUMBER
Collate: MACHINE

matchon
Regular

N
Y
Expression: MATCHON
Collate: MACHINE

state
Regular
State
N
Y
Expression: UPPER(STATE)
Collate: MACHINE

wre_del
Regular
Wre Del
N
N
Expression: DELETED()
Collate: MACHINE

zip
Regular

N
Y
Expression: ZIP
Collate: MACHINE

Table: au!weights

Tag Type Caption Desc Sel

code
Regular
Code
N
Y
Expression: CODE
Collate: MACHINE

wgt_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

wgt_pk
Primary
Primary Key
N
Y
Expression: WGT_PK
Collate: MACHINE

Table: au!whse

Tag Type Caption Desc Sel

whs_code
Regular
Warehouse Code
N
Y
Expression: WHS_CODE
Collate: MACHINE

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

whs_name
Regular
Warehouse Name
N
Y
Expression: UPPER(WHS_NAME)
Collate: MACHINE

whs_pk
Primary
Add Pk
N
N
Expression: WHS_PK
Collate: MACHINE

wshipper
Regular

N
Y
Expression: WSHIPPER
Collate: MACHINE

Table: au!wine

Tag Type Caption Desc Sel

win_appfk
Regular
Appellation Foreign Key
N
Y
Expression: WIN_APPFK
Collate: MACHINE

win_catfk
Regular
Foreign Key from Category
N
Y
Expression: WIN_CATFK
Collate: MACHINE

win_clafk
Regular
Wine Classification Foreign Key
N
Y
Expression: WIN_CLAFK
Collate: MACHINE

win_code
Regular
Wine Code
N
Y
Expression: WIN_CODE
Collate: MACHINE

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

win_descr
Regular
Wine Description
N
Y
Expression: UPPER(REPLFOREIGN(WIN_DESCR))
Collate: MACHINE

win_pk
Primary
Wine Primary Key
N
Y
Expression: WIN_PK
Collate: MACHINE

Table: au!winehx

Tag Type Caption Desc Sel

lot_no
Regular
Lot No
N
Y
Expression: LOT_NO
Collate: MACHINE

sale_no
Regular
Sale No
N
Y
Expression: SALE_NO
Collate: MACHINE

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

whx_grofk
Regular
Grower Foreign Key
N
Y
Expression: WHX_GROFK
Collate: MACHINE

whx_pk
Primary
Wine Pricing Primary Key
N
Y
Expression: WHX_PK
Collate: MACHINE

whx_salfk
Regular
Sale Foreign Key
N
Y
Expression: WHX_SALFK
Collate: MACHINE

whx_sizfk
Regular
Price History Size Foreign Key
N
Y
Expression: WHX_SIZFK
Collate: MACHINE

whx_winfk
Regular
Wine Foreign Key
N
Y
Expression: WHX_WINFK
Collate: MACHINE

Table: au!wineprx

Tag Type Caption Desc Sel

ckcheck
Regular
Candidate Key on Wine, Grower, Vintage and Vendor
N
Y
Expression: STR(WPX_WINFK,10)+STR(WPX_GROFK,10)+VINTAGE+VENDOR
Collate: MACHINE

vendor
Regular
Vendor
N
Y
Expression: VENDOR
Collate: MACHINE

wpx_cusfk
Regular
Vendor Foreign Key
N
Y
Expression: WPX_CUSFK
Collate: MACHINE

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

wpx_grofk
Regular
Grower Foreign Key
N
Y
Expression: WPX_GROFK
Collate: MACHINE

wpx_pk
Primary
Wine Pricing Primary Key
N
Y
Expression: WPX_PK
Collate: MACHINE

wpx_winfk
Regular
Wine Foreign Key
N
Y
Expression: WPX_WINFK
Collate: MACHINE

Table: au!wlots

Tag Type Caption Desc Sel

wlo_del
Regular
Wlo Del
N
N
Expression: DELETED()
Collate: MACHINE

wlo_pk
Primary
Wlo Pk
N
N
Expression: WLO_PK
Collate: MACHINE

wlo_xxxfk
Regular
Wlo Xxxfk
N
Y
Expression: WLO_XXXFK
Collate: MACHINE

Table: au!wreal

Tag Type Caption Desc Sel

wre_del
Regular
Wre Del
N
N
Expression: DELETED()
Collate: MACHINE

Table: au!wrealout

Tag Type Caption Desc Sel

wre_del
Regular
Wre Del
N
N
Expression: DELETED()
Collate: MACHINE

Table: au!wregi

Tag Type Caption Desc Sel

wre_del
Regular
Wre Del
N
N
Expression: DELETED()
Collate: MACHINE

Table: au!wureg

Tag Type Caption Desc Sel

wur_del
Regular
Wur Del
N
N
Expression: DELETED()
Collate: MACHINE

wur_pk
Primary
Wur Pk
N
N
Expression: WUR_PK
Collate: MACHINE

wur_xxxfk
Regular
Wur Xxxfk
N
Y
Expression: WUR_XXXFK
Collate: MACHINE

Free Table: catalog

Tag Type Caption Desc Sel

cat_del
Regular
Cat Del
N
N
Expression: DELETED()
Collate: MACHINE

clg_pk
Candidate
Clg Pk
N
Y
Expression: CLG_PK
Collate: MACHINE

Free Table: largelot

Tag Type Caption Desc Sel

lar_del
Regular
Lar Del
N
N
Expression: DELETED()
Collate: MACHINE

lar_pk