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

Candidate

Lar Pk

N

Y
Expression: LAR_PK
Collate: MACHINE

lar_xxxfk

Regular

Lar Xxxfk

N

Y
Expression: LAR_XXXFK
Collate: MACHINE

Free Table: lotlabel

Tag Type Caption Desc Sel

lot_del

Regular

Lot Del

N

N
Expression: DELETED()
Collate: MACHINE

lot_pk

Candidate

Lot Pk

N

Y
Expression: LOT_PK
Collate: MACHINE

lot_xxxfk

Regular

Lot Xxxfk

N

Y
Expression: LOT_XXXFK
Collate: MACHINE

Field Definitions

Field Definitions

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

Table: au!accttype

# Field Name Type Len Dec Null

1

acc_pk

Integer

4

0

N
Caption: Accout Type Primary Key

2

acc_code

Character

4

0

N
Caption: Code

3

acc_descr

Character

30

0

N
Caption: Account Type Description

4

acc_ref

Character

20

0

N
Caption: Sub Code

5

acc_arcode

Character

6

0

N
Caption: AR Code to total Invoice Payments Into

6

acc_apcode

Character

6

0

N
Caption: AP Code to total Consignor Payments Into

7

acc_glcode

Character

10

0

N
Caption: Acc Glcode

8

last_edit

Date

8

0

N
Caption: Last Edit

9

last_time

Character

6

0

N
Caption: Last Time

10

operator

Character

10

0

N
Caption: Operator

Total record size: 105

Table: au!address

# Field Name Type Len Dec Null

1

add_pk

Integer

4

0

N

2

add_type

Character

4

0

N
Caption: Address Type

3

cust_no

Character

6

0

N
Caption: Customer Number

4

acct_num

Character

8

0

N
Caption: Account Number

5

add_cusfk

Integer

4

0

N
Caption: Customer FK

6

salutation

Character

15

0

N
Caption: Salutation

7

cust_lname

Character

30

0

N
Caption: Last Name

8

cust_fname

Character

20

0

N
Caption: First Name

9

company

Character

40

0

N
Caption: Company

10

attention

Character

40

0

N
Caption: Attention

11

addr1

Character

42

0

N
Caption: Address 1

12

addr2

Character

42

0

N
Caption: Address 2

13

addr3

Character

42

0

N
Caption: Address 3

14

city

Character

25

0

N
Caption: City

15

state

Character

3

0

N
Caption: State

16

county

Character

3

0

N
Caption: County

17

zip

Character

10

0

N
Caption: Zip Code

18

wphone

Character

17

0

N
Caption: Work Phone

19

hphone

Character

17

0

N
Caption: Home Phone

20

fphone

Character

17

0

N
Caption: Fax Phone

21

ophone

Character

17

0

N
Caption: Other Phone

22

cphone

Character

17

0

N
Caption: Cell Phone

23

country

Character

25

0

N
Caption: Country

24

notes

Character

10

0

N
Caption: Notes

25

operator

Character

10

0

N
Caption: Operator

26

last_edit

Date

8

0

N
Caption: Last Edit

27

last_time

Character

6

0

N
Caption: Last Time

28

acct_ship

Character

1

0

N
Caption: Address is Account (A) or Shipping (S)

29

flip_date

Date

8

0

N
Caption: Flip this address on this date

30

old_addr

Character

1

0

N
Caption: This is an Old Address? [Y/N]

31

suffix

Character

25

0

N
Caption: Suffix

32

fullsal

Character

66

0

N
Caption: Fullsal

33

cou_ab

Character

3

0

N
Caption: Country Abbreviation

34

add_coufk

Integer

4

0

N
Caption: Country Foriegn Key

Total record size: 591

Table: au!ap

# Field Name Type Len Dec Null

1

ap_pk

Integer

4

0

N

2

cust_no

Character

6

0

N
Caption: Cust No

3

ap_confk

Integer

4

0

N
Caption: Consignor FK into customer table

4

sale_no

Character

5

0

N
Caption: Sale No

5

ap_salfk

Integer

4

0

N
Caption: Sale Foreign Key

6

date

Date

8

0

N
Caption: Date

7

subamount

Numeric

11

2

N
Caption: SubTotal

8

vat_offer

Character

4

0

N
Caption: Vat Offered

9

vat_refund

Numeric

11

2

N
Caption: Vat Refund

10

vat_lot

Numeric

10

2

N
Caption: VAT Paid on Hammer

11

vat_com

Numeric

11

2

N
Caption: Vat Commission

12

vat_ins

Numeric

11

2

N
Caption: VAT Insurance

13

vat_fees

Numeric

10

2

N
Caption: VAT Charged on Fees

14

buyvattax

Numeric

10

2

N
Caption: Sum of the Vat on Hammer Charged the Buyer

15

consfee

Numeric

10

2

N
Caption: Consignor Fee

16

insfee

Numeric

12

2

N
Caption: Insurance Fee

17

miscfee

Numeric

10

2

N
Caption: Misc Fee

18

amount

Numeric

11

2

N
Caption: Amount

19

paid

Character

1

0

N
Caption: Paid

20

inv_nums

Character

30

0

N
Caption: Invoice Numbers

21

inv_sales

Character

12

0

N
Caption: Inv Sales

22

inv_amount

Numeric

11

2

N
Caption: Inv Amount

23

adv_amount

Numeric

11

2

N
Caption: Advance Amount

24

pay_amount

Numeric

11

2

N
Caption: Pay Amount

25

authorize

Character

20

0

N
Caption: Authorize

26

comments

Memo

4

0

N
Caption: Comments

27

how_paid

Character

20

0

N
Caption: How Paid

28

last_edit

Date

8

0

N
Caption: Last Edit

29

extension

Numeric

11

2

N
Caption: Amount on Extension

30

paidtodate

Numeric

11

2

N
Caption: Paid to Date

31

adjustment

Numeric

11

2

N
Caption: Adjustment Total (Sum of ADJ)

32

netdue

Numeric

11

2

N
Caption: Net Due

33

misccharge

Numeric

11

2

N
Caption: Misccharge (Sum of MISC)

34

int_amount

Numeric

11

2

N
Caption: Interest Amount

35

ref_num

Character

12

0

N
Caption: Reference Number

36

signed

Logical

1

0

N
Caption: Signed

37

cccust_no1

Character

6

0

N
Caption: CC Custno1

38

cccust_no2

Character

6

0

N
Caption: CC Custno2

39

cccust_no3

Character

6

0

N
Caption: CC Custno3

40

cccust_no4

Character

6

0

N
Caption: CC Custno4

41

cccust_no5

Character

6

0

N
Caption: CC Custno5

42

cctype1

Character

1

0

N
Caption: CC Type1

43

cctype2

Character

1

0

N
Caption: CC Type2

44

cctype3

Character

1

0

N
Caption: CC Type3

45

cctype4

Character

1

0

N
Caption: CC Type4

46

cctype5

Character

1

0

N
Caption: CC Type5

47

ap_trans

Character

2

0

N
Caption: AP Trans

48

net_resv

Character

1

0

N
Caption: Net Reserve?

49

cons_perc

Numeric

5

1

N
Caption: Consignor Percentage

50

cons_fixed

Numeric

5

2

N
Caption: Fixed Consignment

51

min_commp

Numeric

6

2

N
Caption: Min Comm Public

52

min_commm

Numeric

6

2

N
Caption: Min Comm Mail

53

no_fees

Logical

1

0

N
Caption: Do not Charge any fees

54

ccons_type

Character

1

0

N
Caption: Consignor Type

55

zero_ins

Character

1

0

N
Caption: Zero Insurance

56

cons_zero

Character

1

0

N
Caption: Consignor Zero

57

waive_fee

Logical

1

0

N
Caption: Waive Fees?

58

min_unsold

Character

1

0

N
Caption: Min Comm for Unsolds

59

ccon_lev1

Numeric

8

0

N
Caption: Con Level 1

60

ccon_perc0

Numeric

5

1

N
Caption: Cons Percent 0

61

ccon_perc1

Numeric

5

1

N
Caption: Cons Percent 0

62

tax_exempt

Logical

1

0

N
Caption: Tax Exempt

63

operator

Character

10

0

N
Caption: Operator

64

last_time

Character

6

0

N
Caption: Last Time

65

last_cons

Date

8

0

N
Caption: Last Cons

66

spec_terms

Character

25

0

N
Caption: Special Terms

67

dealer

Character

1

0

N
Caption: Dealer

68

cons_note

Memo

4

0

N
Caption: Consignment Note

69

contract

Logical

1

0

N
Caption: Contract Signed

70

id_checked

Logical

1

0

N
Caption: Id Checked

71

paymeonce

Logical

1

0

N
Caption: Pay Consignor Only Once

72

percresv

Numeric

3

0

N
Caption: When lotting, Reserve is this Percent of ...

73

releaseno

Character

10

0

N
Caption: Release Order Number

74

released

Character

1

0

N
Caption: Released? [Y/N]

75

rel_date

Date

8

0

N
Caption: Released Date

76

shipped

Character

1

0

N
Caption: Shipped? [Y/N]

77

shipdate

Date

8

0

N
Caption: Shipped Date

78

finder

Character

6

0

N
Caption: Finder Customer No.

79

finder_fee

Numeric

5

1

N
Caption: Finder Fee

80

ret_via

Character

10

0

N
Caption: Ret Via

81

ret_reason

Character

30

0

N
Caption: Ret Reason

82

apwhse

Character

6

0

N
Caption: Default Warehouse Code for this Consignment

83

num_lots

Numeric

5

0

N
Caption: Number of Lots

84

num_cases

Numeric

10

2

N
Caption: Number of Cases

85

sum_low

Numeric

12

2

N
Caption: Sum Low Estimate

86

sum_real

Numeric

12

2

N
Caption: Sum High Estimate

87

sum_rsrv

Numeric

12

2

N
Caption: Sum of the Reserve

88

prop_num

Character

8

0

N
Caption: Property Number

89

ins_perc

Numeric

6

2

N
Caption: Consignor Insurace Percentage

90

unsold_perc

Numeric

6

2

N
Caption: Unsold Commission Percentage

91

min_commpu

Numeric

8

2

N
Caption: Minimum Commission Public Unsold Lot

92

min_commmu

Numeric

8

2

N
Caption: Minimum Commission Mail Unsold Lot

93

chk_paid

Character

1

0

N
Caption: Pay Consignor Only After Invoice has been paid

94

preparer

Character

30

0

N
Caption: Prepared By

95

constosale

Character

5

0

N
Caption: Consigned to Sale

96

revised

Date

8

0

N
Caption: Revised

97

revision

Numeric

3

0

N
Caption: Revision

98

cons_code

Character

4

0

N
Caption: Consignor Type

99

cons_inss

Numeric

5

2

N
Caption: Insurance Percentage for Sold Lots

100

cons_insu

Numeric

5

2

N
Caption: Insurance Percentage for Unsold Lots

101

has_ins

Logical

1

0

N
Caption: Has Own Insurance

102

paycons

Character

1

0

N
Caption: Method of Payment

103

payinstr

Memo

4

0

N
Caption: Payment Instructions

104

internal

Memo

4

0

N
Caption: Internal Notes

105

appraisal

Logical

1

0

N
Caption: Appraisal

106

payafter

Date

8

0

N
Caption: Pay After

107

shipagent

Character

6

0

N
Caption: Shipping Agent (lookup in Customer)

108

aplocked

Character

1

0

N
Caption: AP Record is Locked - Can not be reccalculated

109

manualchk

Logical

1

0

N
Caption: Manual Payment - Do not create automatic transactions

110

sumestcons

Numeric

12

2

N
Caption: Total Estimate to the Consignor

111

sumprice3

Numeric

12

2

N
Caption: Total Cost

112

sumretail

Numeric

12

2

N
Caption: Total Retail Price

113

po

Logical

1

0

N
Caption: Purchase Order

114

vendorinv

Character

20

0

N
Caption: Vendor Invoice Number

115

originalpo

Integer

4

0

N
Caption: Original PO/AP Number

116

daysafter

Numeric

3

0

N
Caption: Pay Days After

117

cntsold

Integer

4

0

N
Caption: Number of Lots Sold

118

cntunsold

Integer

4

0

N
Caption: Number of Lots Unsold

119

cntpassed

Integer

4

0

N
Caption: Number of Passed/Bought In

120

sumpassed

Numeric

12

2

N
Caption: Sum of Passed Lots

121

collfrom

Character

6

0

N
Caption: Collect From

122

cons_percb

Numeric

10

2

N
Caption: Consignor Percentage Break

123

futamount

Numeric

12

2

N
Caption: Future Inventory

124

niwamount

Numeric

12

2

N
Caption: NIW Inventory

125

allowperc

Logical

1

0

N
Caption: Allow Consignor Percent on lots to be different

Total record size: 894

Table: au!apnotes

# Field Name Type Len Dec Null

1

apn_pk

Integer

4

0

N
Caption: Primary Key

2

apn_apfk

Integer

4

0

N
Caption: AP Foreign Key

3

date

Date

8

0

N
Caption: Date

4

note

Character

200

0

N
Caption: Note

5

type

Character

4

0

N
Caption: Type

6

operator

Character

10

0

N
Caption: Operator

7

last_edit

Date

8

0

N
Caption: Last Edit

8

last_time

Character

6

0

N
Caption: Last Time

Total record size: 245

Table: au!appel

# Field Name Type Len Dec Null

1

app_pk

Integer

4

0

N
Caption: Appellation Primary Key

2

app_code

Character

4

0

N
Caption: Appellation Code

3

app_descr

Character

60

0

N
Caption: Appellation Description

4

last_edit

Date

8

0

N
Caption: Last Edit

5

last_time

Character

6

0

N
Caption: Last Time

6

operator

Character

10

0

N
Caption: Operator

7

recdelete

Character

1

0

N
Caption: Recdelete

8

mergeto

Character

4

0

N
Caption: Mergeto

Total record size: 98

Table: au!appinfo

# Field Name Type Len Dec Null

1

app_item

Character

40

0

N
Comments: Application setup/configuration item (Primary Key-no duplicates)

2

app_itemdatatype

Character

1

0

N
Comments: Data type for App_Item (C,N,L,D,T)

3

app_itemvalue

Character

254

0

N
Comments: App_Item value

4

app_itemdescription

Character

254

0

N
Comments: Description of App_Item

5

app_type

Character

1

0

N

6

app_dformat

Character

2

0

N
Caption: Division

Total record size: 553

Table: au!apsort

# Field Name Type Len Dec Null

1

aps_pk

Integer

4

0

N
Caption: AP Sort Primary Key

2

ap_sort

Numeric

4

0

N
Caption: AP Sort for Catalog

3

aps_apfk

Integer

4

0

N
Caption: AP Foreign Key

4

num_lots

Numeric

5

0

N
Caption: Number Lots

5

sum_low

Numeric

12

2

N
Caption: Sum Low

6

sum_real

Numeric

12

2

N
Caption: Sum Real

7

sum_rsrv

Numeric

12

2

N
Caption: Sum Rsrv

8

cat_update

DateTime

8

0

N
Caption: Last Catalog Sort Update

9

cat_oper

Character

8

0

N
Caption: Catalog Update Operator

10

cons_id

Character

10

0

N
Caption: Consignor ID

Total record size: 80

Table: au!araptran

# Field Name Type Len Dec Null

1

ara_pk

Integer

4

0

N

2

ara_apfk

Integer

4

0

N
Caption: AP FK

3

cust_no

Character

6

0

N
Caption: Cust No

4

ara_cusfk

Integer

4

0

N
Caption: Customer FK

5

invoice

Character

6

0

N
Caption: Invoice

6

ara_invfk

Integer

4

0

N
Caption: Invoice FK

7

sale_no

Character

5

0

N
Caption: Sale No

8

ara_salfk

Integer

4

0

N
Caption: Sale Foreign Key

9

jr_type

Character

2

0

N
Caption: Journal Type

10

date

Date

8

0

N
Caption: Date

11

subamount

Numeric

11

2

N

12

buyfee

Numeric

10

2

N
Caption: Buyer's Fee

13

tax

Numeric

9

2

N
Caption: Tax

14

freight

Numeric

9

2

N
Caption: Freight

15

cc_fee

Numeric

9

2

N
Caption: CC Fee

16

consfee

Numeric

11

2

N
Caption: Cons Fee

17

miscfee

Numeric

11

2

N
Caption: Misc Fee

18

amount

Numeric

11

2

N
Caption: Amount

19

late_pay

Numeric

11

2

N
Caption: Late Pay

20

how_paid

Character

40

0

N
Caption: How Paid

21

trseqno

Character

4

0

N
Caption: TR Sequence Number

22

tran_code

Character

4

0

N
Caption: Transaction Code

23

operator

Character

10

0

N
Caption: Operator

24

last_edit

Date

8

0

N
Caption: Last Edit

25

last_time

Character

6

0

N
Caption: Last Time

Total record size: 212

Table: au!bids

# Field Name Type Len Dec Null

1

bid_pk

Integer

4

0

N
Caption: Primary Key

2

bid_salbfk

Integer

4

0

N
Caption: SaleBids Foreign Key

3

cust_no

Character

6

0

N
Caption: Cust No

4

bid_cusfk

Integer

4

0

N
Caption: Customer Foreign Key

5

lot_no

Character

5

0

N
Caption: Lot No

6

bid_lotfk

Integer

4

0

N
Caption: Lots Foreign Key

7

sale_no

Character

5

0

N
Caption: Sale No

8

bid_salfk

Integer

4

0

N
Caption: Sale Foreign Key

9

amount

Numeric

11

2

N
Caption: Amount

10

or_ind

Character

3

0

N
Caption: OR Indicator

11

ignore

Logical

1

0

N
Caption: Ignore

12

comments

Character

40

0

N
Caption: Comments

13

bid

Numeric

11

2

N
Caption: Bid Amount

14

drop

Logical

1

0

N
Caption: Drop

15

date_rcvd

Date

8

0

N
Caption: Date Received

16

time_rcvd

Character

6

0

N
Caption: Time Received

17

rank

Numeric

3

0

N
Caption: Rank

18

last_edit

Date

8

0

N
Caption: Last Edit

19

last_time

Character

6

0

N
Caption: Last Time

20

misc_info

Character

2

0

N
Caption: Misc. Info

21

oth_phone

Character

60

0

N
Caption: Phone Bidder No.

22

operator

Character

10

0

N
Caption: Operator

23

priorbook

Logical

1

0

N
Caption: Priorbook

Total record size: 208

Table: au!btype

# Field Name Type Len Dec Null

1

btp_pk

Integer

4

0

N
Caption: Bottle Type Primary Key

2

btp_code

Character

4

0

N
Caption: Bottle Type Code

3

btp_descr

Character

40

0

N
Caption: Bottle Type Description

4

last_edit

Date

8

0

N
Caption: Last Edit

5

last_time

Character

6

0

N
Caption: Last Time

6

operator

Character

10

0

N
Caption: Operator

Total record size: 73

Table: au!casetype

# Field Name Type Len Dec Null

1

cas_pk

Integer

4

0

N
Caption: Case Type Primary Key

2

cas_code

Character

4

0

N
Caption: Case Type Code

3

cas_descr

Character

40

0

N
Caption: Case Type Description

4

last_edit

Date

8

0

N
Caption: Last Edit

5

last_time

Character

6

0

N
Caption: Last Time

6

operator

Character

10

0

N
Caption: Operator

Total record size: 73

Table: au!category

# Field Name Type Len Dec Null

1

cat_pk

Integer

4

0

N
Caption: Primary Key

2

category

Character

8

0

N
Caption: Category

3

supgroup

Character

40

0

N
Caption: Super Group

4

majgroup

Character

100

0

N
Caption: Major Group

5

descrip

Character

100

0

N
Caption: Description

6

subgroup

Character

100

0

N
Caption: Sub Group

7

last_edit

Date

8

0

N
Caption: Last Edit

8

new_code

Character

7

0

N
Caption: New Code

9

old_code

Character

7

0

N
Caption: Old Code

10

ebay_cat

Character

7

0

N
Caption: eBAY Category

11

ebay_desc

Character

40

0

N
Caption: eBAY Category Description

12

ebay_cat2

Character

7

0

N
Caption: eBAY 2nd Category

13

operator

Character

10

0

N
Caption: Operator

14

last_time

Character

6

0

N
Caption: Last Time

15

perc_alcoh

Numeric

6

2

N
Caption: Percent Alcohol

16

sort_code

Character

10

0

N
Caption: Sort Code

17

webmajgrp

Character

40

0

N
Caption: Category Description to use in Web and Catalog

18

recdelete

Character

1

0

N
Caption: Delete

19

mergeto

Character

7

0

N
Caption: Merge To

20

winecolor

Character

10

0

N
Caption: Wine Color

21

cat_origin

Character

4

0

N
Caption: Country of Origin

22

tasting

Memo

4

0

N
Caption: Tasting note

23

vintage

Character

4

0

N
Caption: Vintage

24

dutyperlit

Numeric

8

4

N
Caption: Duty Per Litre

25

link_to

Character

7

0

N
Caption: Link To

26

longname

Character

100

0

N
Caption: Longname

27

price

Numeric

9

2

N
Caption: Price

Total record size: 655

Table: au!cbserver

# Field Name Type Len Dec Null

1

cbs_pk

Integer

4

0

N
Caption: CBS Server

2

cbs_lotfk

Integer

4

0

N
Caption: Cbs Lotpk

3

sale_no

Character

5

0

N
Caption: Sale No

4

lot_no

Character

5

0

N
Caption: Lot No

5

done

Character

1

0

N
Caption: Done

Total record size: 20

Table: au!conslog

# Field Name Type Len Dec Null

1

con_pk

Integer

4

0

N

2

cust_no

Character

6

0

N
Caption: Customer No.

3

con_cusfk

Integer

4

0

N

4

sale_no

Character

5

0

N
Caption: Sale No.

5

con_salfk

Integer

4

0

N
Caption: Sale Foreign Key

6

cons_num

Character

8

0

N
Caption: Consignment No.

7

date

Date

8

0

N
Caption: Date

8

how_ship

Character

15

0

N
Caption: How Ship

9

size

Character

30

0

N
Caption: Size

10

ins_value

Numeric

9

2

N
Caption: Insurance Value

11

given_to

Character

20

0

N
Caption: Given to

12

last_edit

Date

8

0

N
Caption: Last Edit

13

cons_perc

Numeric

5

1

N
Caption: Consignor Percent

14

date_sale

Character

15

0

N
Caption: Date of Sale

15

owner

Numeric

12

2

N
Caption: Owner

16

estimate

Numeric

12

2

N
Caption: Estimate

17

describe1

Character

40

0

N
Caption: Description of Property

18

charge1

Numeric

11

2

N
Caption: Charges (1)

19

describe2

Character

30

0

N
Caption: Name on Property

20

charge2

Numeric

11

2

N

21

describe3

Character

30

0

N

22

charge3

Numeric

11

2

N

23

describe4

Character

30

0

N

24

charge4

Numeric

11

2

N

25

describe5

Character

30

0

N

26

charge5

Numeric

11

2

N

27

comp_date

Date

8

0

N
Caption: Comp Date

28

cost

Numeric

11

2

N
Caption: Cost

29

est_low

Numeric

11

2

N
Caption: Sum of Price 1

30

est_real

Numeric

11

2

N
Caption: Sum of Price 2

31

est_cons

Numeric

11

2

N
Caption: Sum of Estimate to the Consignor

32

opening

Numeric

11

2

N
Caption: Sum of Opening

33

high_bid

Numeric

11

2

N
Caption: Sum of High Bid

34

realized

Numeric

11

2

N
Caption: Sum of Realized

35

num_lots

Numeric

6

0

N
Caption: Sum of Number of Lots

36

reserve

Numeric

11

2

N
Caption: Sum of Reserve

37

hand_fee

Numeric

11

2

N

38

ttl_sold

Numeric

11

2

N

39

ttl_fees

Numeric

11

2

N

40

real_ytd

Numeric

11

2

N

41

max_bid

Numeric

11

2

N

42

ttl_weight

Numeric

11

2

N

43

operator

Character

10

0

N
Caption: Operator

44

last_time

Character

6

0

N
Caption: Last Time

45

prop_num

Character

8

0

N
Caption: Property Number

46

cons_code

Character

10

0

N
Caption: Consignor Code

47

cat_name

Character

120

0

N
Caption: Catalog Name

48

lot_instr

Memo

4

0

N
Caption: Lotting Instructions

49

sett_instr

Memo

4

0

N
Caption: Settlement Instructions

50

rcvd_by

Character

20

0

N
Caption: Received By

51

prop_notes

Memo

4

0

N
Caption: Internal Property Notes

52

cstatus

Character

2

0

N
Caption: Status

53

cquality

Character

1

0

N
Caption: Quality

54

location

Character

10

0

N
Caption: Location

55

cusfilter

Character

1

0

N
Caption: Custom Filter

56

cost_perc

Numeric

5

1

N
Caption: Last Percentage used to Calculate Cost

57

cost_left

Numeric

12

2

N
Caption: Cost Left

58

cost_fixed

Numeric

12

2

N
Caption: Cost Fixed

59

profitable

Character

1

0

N
Caption: Profitable

Total record size: 779

Table: au!conslogd

# Field Name Type Len Dec Null

1

cld_pk

Integer

4

0

N

2

cust_no

Character

6

0

N
Caption: Customer No.

3

cld_cusfk

Integer

4

0

N

4

cld_confk

Integer

4

0

N
Caption: Consignor Log Foreign Key

5

line_no

Character

5

0

N
Caption: Line No.

6

descrip

Character

60

0

N
Caption: Description

7

prop_num

Character

8

0

N
Caption: Property Number

8

estimate

Numeric

12

2

N
Caption: Estimate

9

reserve

Numeric

11

2

N
Caption: Sum of Reserve

10

sale_type

Character

10

0

N
Caption: Sale Type

11

sale_no

Character

5

0

N
Caption: Actual Sale Number Assigned

12

operator

Character

10

0

N
Caption: Operator

13

last_time

Character

6

0

N
Caption: Last Time

14

last_edit

Date

8

0

N
Caption: Last Edit

15

date_in

Date

8

0

N
Caption: Date In

16

describer

Character

12

0

N
Caption: Describer

Total record size: 174

Table: au!consstat

# Field Name Type Len Dec Null

1

cst_pk

Integer

4

0

N

2

sale_no

Character

5

0

N

3

cst_salfk

Integer

4

0

N
Caption: Sale Foreign Key

4

consignor

Character

6

0

N

5

cst_confk

Integer

4

0

N
Caption: Consignor Foreign Key

6

lots_ttl

Numeric

5

0

N

7

lots_sold

Numeric

5

0

N

8

lots_unsld

Numeric

5

0

N

9

realized

Numeric

11

2

N

10

commission

Numeric

11

2

N

11

clearing

Numeric

11

2

N

12

insurance

Numeric

11

2

N

13

bi_fee

Numeric

11

2

N

14

misc_adj

Numeric

11

2

N

15

shipping

Numeric

11

2

N

16

paidtodate

Numeric

11

2

N

17

amount_pd

Numeric

11

2

N

18

sb_ttl

Numeric

11

2

N

19

sb_sold

Numeric

11

2

N

20

sb_unsold

Numeric

11

2

N

Total record size: 171

Table: au!contacts

# Field Name Type Len Dec Null

1

cts_pk

Integer

4

0

N

2

cts_cusfk

Integer

4

0

N

3

cust_no

Character

6

0

N
Caption: Cust No.

4

date

Date

8

0

N
Caption: Date

5

doneby

Character

10

0

N
Caption: Doneby - Operator who entered this record

6

type

Character

12

0

N
Caption: Type - Via

7

method

Character

12

0

N
Caption: Method of Communication

8

project

Character

8

0

N
Caption: Project

9

descrip

Memo

4

0

N
Caption: Description - Comments

10

next_step

Character

40

0

N
Caption: Next Step - Text Description

11

next_date

Date

8

0

N
Caption: Next Step Date

12

next_time

Character

5

0

N
Caption: Next Step Time

13

complete

Logical

1

0

N
Caption: Complete

14

reason

Character

40

0

N
Caption: Reason for Contact

15

last_edit

Date

8

0

N
Caption: Last Edit

16

last_time

Character

6

0

N
Caption: Last Time

17

operator

Character

10

0

N
Caption: Operator

Total record size: 187

Table: au!country

# Field Name Type Len Dec Null

1

cou_pk

Integer

4

0

N
Caption: Country Primary Key

2

cou_ab

Character

3

0

N
Caption: Country Abbrev.

3

cou_name

Character

25

0

N
Caption: Country Name

4

tax_rate

Numeric

6

3

N
Caption: Tax Rate

5

taxable

Character

1

0

N
Caption: Taxable

6

post_code

Character

10

0

N

7

region

Character

2

0

N
Caption: Region

8

eu

Character

1

0

N
Caption: Eu

9

www_code

Character

10

0

N
Caption: Default WWW Country Suffix

10

language

Character

20

0

N
Caption: Default Language Spoken

11

recdelete

Character

1

0

N
Caption: Delete

12

mergeto

Character

3

0

N
Caption: Mergeto

13

operator

Character

10

0

N
Caption: Operator

14

last_edit

Date

8

0

N
Caption: Last Edit

15

last_time

Character

6

0

N
Caption: Last Time

Total record size: 111

Table: au!credcard

# Field Name Type Len Dec Null

1

cre_pk

Integer

4

0

N

2

cust_no

Character

6

0

N
Caption: Cust No.

3

cre_cusfk

Integer

4

0

N

4

cred_type

Character

5

0

N
Caption: Credit Card Type

5

cred_no

Character

24

0

N
Caption: Card Number

6

cred_name

Character

20

0

N
Caption: Name

7

cred_init

Character

5

0

N
Caption: Init Date

8

cred_exp

Character

5

0

N
Caption: Expiration Date

9

cred_limit

Numeric

7

0

N
Caption: Credit Limit

10

current

Character

1

0

N
Caption: Current?

11

operator

Character

10

0

N
Caption: Operator

12

last_edit

Date

8

0

N
Caption: Last Edit

13

last_time

Character

6

0

N
Caption: Last Time

Total record size: 106

Table: au!credin

# Field Name Type Len Dec Null

1

cin_pk

Integer

4

0

N

2

merchant

Character

12

0

N

3

trans_id

Character

10

0

N

4

card_num

Character

22

0

N

5

exp_date

Character

4

0

N

6

amount1

Character

12

0

N

7

amount2

Character

12

0

N

8

appr_code

Character

6

0

N

9

comments

Character

30

0

N

10

response

Character

16

0

N

11

resp_code

Character

2

0

N

12

trans_num

Character

4

0

N

13

trans_date

Character

6

0

N

14

trans_time

Character

4

0

N

15

trans_code

Character

2

0

N

16

ser_number

Character

8

0

N

17

auth_sourc

Character

1

0

N

18

add_ver

Character

1

0

N

19

trancode

Character

1

0

N

20

acct_sourc

Character

1

0

N

21

id_source

Character

1

0

N

22

void_flag

Character

1

0

N

23

auth_ph

Character

30

0

N

24

auth_sh

Character

30

0

N

25

dep_ph

Character

30

0

N

26

dep_sh

Character

30

0

N

27

card_type

Character

4

0

N

28

key

Character

30

0

N

29

cust_name

Character

30

0

N

30

address

Character

30

0

N

31

city

Character

30

0

N

32

state

Character

2

0

N

33

zipcode

Character

10

0

N

34

phone

Character

20

0

N

35

posted

Logical

1

0

N

Total record size: 438

Table: au!credpost

# Field Name Type Len Dec Null

1

cpo_pk

Integer

4

0

N

2

merchant

Character

10

0

N

3

trans_id

Character

10

0

N

4

card_num

Character

22

0

N

5

exp_date

Character

4

0

N

6

amount1

Character

12

0

N

7

amount2

Character

12

0

N

8

appr_code

Character

6

0

N

9

comments

Character

30

0

N

10

response

Character

16

0

N

11

resp_code

Character

2

0

N

12

trans_num

Character

4

0

N

13

trans_date

Character

6

0

N

14

trans_time

Character

4

0

N

15

trans_code

Character

2

0

N

16

ser_number

Character

8

0

N

17

auth_sourc

Character

1

0

N

18

add_ver

Character

1

0

N

19

trancode

Character

1

0

N

20

acct_sourc

Character

1

0

N

21

id_source

Character

1

0

N

22

void_flag

Character

1

0

N

23

auth_ph

Character

30

0

N

24

auth_sh

Character

30

0

N

25

dep_ph

Character

30

0

N

26

dep_sh

Character

30

0

N

27

card_type

Character

4

0

N

28

key

Character

30

0

N

29

cust_name

Character

30

0

N

30

address

Character

30

0

N

31

city

Character

30

0

N

32

state

Character

2

0

N

33

zipcode

Character

10

0

N

34

phone

Character

20

0

N

35

posted

Logical

1

0

N

Total record size: 436

Table: au!currency

# Field Name Type Len Dec Null

1

cur_pk

Integer

4

0

N
Caption: Primary Key

2

cat_name

Character

40

0

N
Caption: Cat Name

3

code

Character

10

0

N
Caption: Code

4

abbr

Character

10

0

N
Caption: Abbreviation

5

conv_rate

Numeric

10

4

N
Caption: Conversion Rate

6

currency

Character

25

0

N
Caption: Currency

7

lead

Character

1

0

N
Caption: Lead or Trailing

8

operator

Character

10

0

N
Caption: Operator

9

last_edit

Date

8

0

N
Caption: Last Edit

10

last_time

Character

6

0

N
Caption: Last Time

11

beforecat

Character

10

0

N
Caption: # or Other Symbol before Catalog Number

Total record size: 135

Table: au!custarch

# Field Name Type Len Dec Null

1

cus_pk

Integer

4

0

N
Caption: Primary Key

2

cust_no

Character

6

0

N
Caption: Cust No

3

salutation

Character

5

0

N
Caption: Salutation

4

cust_fname

Character

20

0

N
Caption: First Name

5

cust_lname

Character

30

0

N
Caption: Last Name

6

suffix

Character

25

0

N
Caption: Suffix

7

attention

Character

40

0

N
Caption: Attention

8

addr1

Character

42

0

N
Caption: Address Line 1

9

addr2

Character

42

0

N
Caption: Address Line 2

10

addr3

Character

42

0

N
Caption: Address Line 3

11

city

Character

25

0

N
Caption: City

12

state

Character

3

0

N
Caption: State

13

county

Character

3

0

N
Caption: County

14

zip

Character

10

0

N
Caption: Zip

15

wphone

Character

22

0

N
Caption: Work Phone

16

hphone

Character

22

0

N
Caption: Home Phone

17

fphone

Character

22

0

N
Caption: Fax Phone

18

ophone

Character

22

0

N
Caption: Other Phone

19

country

Character

20

0

N
Caption: Country

20

cphone

Character

22

0

N
Caption: Cell Phone

21

cred_no

Character

20

0

N
Caption: Credit Card Number

22

cred_name

Character

20

0

N
Caption: Name on Credit Card

23

cred_init

Character

5

0

N
Caption: Credit Card Init Date

24

cred_exp

Character

5

0

N
Caption: Credit Card Exp Date

25

cred_type

Character

5

0

N
Caption: VISA, MasterCard, etc...

26

cred_limit

Numeric

7

0

N
Caption: Credit Limit

27

ib_number

Character

10

0

N

28

hand_fee

Numeric

11

2

N
Caption: Shipping Fee

29

ttl_weight

Numeric

11

2

N
Caption: Total Weight

30

total_real

Numeric

11

2

N
Caption: Total Realized

31

ttl_sold

Numeric

11

2

N
Caption: Total Sold

32

ttl_fees

Numeric

11

2

N
Caption: Total Fees

33

comments

Memo

4

0

N
Caption: Comments

34

comments2

Memo

4

0

N
Caption: Additional Comments

35

notes

Memo

4

0

N
Caption: Notes

36

cons_note

Memo

4

0

N
Caption: Consignor Note

37

terms

Character

1

0

N
Caption: Payment Terms

38

ship_via

Character

30

0

N
Caption: Ship Via

39

sub_date

Date

8

0

N
Caption: Subscription Date

40

sub_info

Character

6

0

N
Caption: Subscription Information

41

date_real

Date

8

0

N
Caption: Last Date Realized

42

resale_no

Character

12

0

N
Caption: Tax Exempt Resale Number

43

resale_st

Character

3

0

N
Caption: Resale ID State

44

resale_exp

Date

8

0

N
Caption: Resale Number Expiration Date

45

taxable

Character

1

0

N
Caption: Taxable

46

credit1

Character

60

0

N
Caption: Reference 1

47

credit2

Character

60

0

N
Caption: Reference 2

48

credit3

Character

60

0

N
Caption: Reference 3

49

credit4

Character

60

0

N
Caption: Reference 4

50

net_list

Date

8

0

N
Caption: Net Price List Date

51

real_ytd

Numeric

11

2

N
Caption: Bought to Date

52

sold_ytd

Numeric

11

2

N
Caption: Sold to Date

53

interest

Character

54

0

N

54

last_edit

Date

8

0

N
Caption: Last Edited

55

last_time

Character

6

0

N
Caption: Last Time Edited

56

operator

Character

10

0

N
Caption: Operator who last edited

57

creator

Character

10

0

N
Caption: Record Created by

58

spec_info

Character

10

0

N
Caption: Special Info

59

credit

Numeric

9

2

N
Caption: Credit Balance

60

tax_rate

Numeric

6

3

N
Caption: Tax Rate

61

net_resv

Character

1

0

N
Caption: Net Reserve

62

cons_perc

Numeric

4

1

N
Caption: Consignor Percentage

63

add_date

Date

8

0

N
Caption: Added to File

64

ship1

Character

40

0

N
Caption: Shipping Lable Line 1

65

ship2

Character

40

0

N
Caption: Shipping Lable Line 2

66

ship3

Character

40

0

N
Caption: Shipping Lable Line 3

67

ship4

Character

40

0

N
Caption: Shipping Lable Line 4

68

ship5

Character

40

0

N
Caption: Shipping Lable Line 5

69

date_under

Date

8

0

N
Caption: Last Date was an Underbidder

70

mail_flag

Character

4

0

N
Caption: Mail Flag

71

email_flag

Character

4

0

N
Caption: eMail Flag

72

cons_fixed

Numeric

5

2

N
Caption: ?

73

min_commp

Numeric

6

2

N
Caption: Minimum Commission Public Sale

74

min_commm

Numeric

6

2

N
Caption: Minimum Commission Mail Sale

75

no_fees

Logical

1

0

N
Caption: Do Not Charge Any Consignor Fees

76

ccons_type

Character

1

0

N
Caption: Consignor Type

77

zero_ins

Character

1

0

N
Caption: Do not charge for Insurance

78

busaddr

Character

1

0

N
Caption: Address is Business

79

tax_exempt

Logical

1

0

N
Caption: Tax Exempt

80

password

Character

8

0

N
Caption: Topspeed Password

81

email

Character

65

0

N
Caption: eMail Address

82

email2

Character

65

0

N
Caption: 2nd eMail Address

83

remove

Character

1

0

N
Caption: Remove from eMail Lists

84

ph_atten

Character

40

0

N
Caption: Phone Attention

85

house

Character

1

0

N
Caption: Customer is House Bidder

86

balcur

Numeric

10

2

N
Caption: Current Balance

87

bal30

Numeric

10

2

N
Caption: 30 Day Balance

88

bal60

Numeric

10

2

N
Caption: 60 Day Balance

89

bal90

Numeric

10

2

N
Caption: 90 Day Balance

90

bal91

Numeric

10

2

N
Caption: Over 90 day balance

91

flag_hist

Character

50

0

N
Caption: Mail Flag History

92

ttl_netdue

Numeric

12

2

N

93

handle

Character

20

0

N
Caption: SAN Handle

94

approved

Character

1

0

N
Caption: SAN Approved

95

cus_recst

Character

1

0

N
Caption: Record State

96

bbr_number

Character

10

0

N
Caption: 2nd Interface Number

97

cus_coufk

Integer

4

0

N
Caption: Country Foreign Key

98

cou_ab

Character

3

0

N
Caption: Country Code

99

email_type

Character

1

0

N
Caption: Email Type

100

mark_type

Character

1

0

N
Caption: Promotional Materials Type

101

fullsal

Character

65

0

N
Caption: Full Salutation (Complete Replacement)

102

finder

Character

6

0

N
Caption: Finder Customer Number

103

finder_fee

Numeric

5

1

N
Caption: Finder Fee

104

ship_state

Character

3

0

N
Caption: Ship State

105

company

Character

65

0

N
Caption: Company

106

position

Character

65

0

N
Caption: Position

107

vat_number

Character

15

0

N
Caption: Vat Number

108

cons_code

Character

4

0

N
Caption: Consignor Fee Struction Type

109

agent

Character

35

0

N
Caption: Bidding Agent

110

fedtaxid

Character

12

0

N
Caption: Federal Tax ID

111

cons_inss

Numeric

5

2

N
Caption: Insurance Percentage Sold Lots

112

cons_insu

Numeric

5

2

N
Caption: Insurance Percentage Unsold Lots

113

ins_waived

Logical

1

0

N
Caption: Insurance Waived

114

sh_city

Character

25

0

N
Caption: Shipping City

115

sh_state

Character

3

0

N
Caption: Shipping State

116

sh_zip

Character

10

0

N
Caption: Shipping Zip

117

sh_country

Character

20

0

N
Caption: Shipping Country

118

sh_cou_ab

Character

3

0

N
Caption: Shipping Country Abbreviation

119

sh_coufk

Integer

4

0

N
Caption: Shipping Country Foreign Key

120

sub_cost

Numeric

6

2

N
Caption: Subscription Cost

121

sh_county

Character

3

0

N
Caption: Shipping County

Total record size: 1975

Table: au!custdict

# Field Name Type Len Dec Null

1

cd_pk

Integer

4

0

N
Caption: Cust.Dict. PK

2

word

Character

30

0

N
Caption: Word

3

lastupdt

DateTime

8

0

N
Caption: Last Updated

4

operator

Character

10

0

N
Caption: User ID

Total record size: 53

Table: au!custlog

# Field Name Type Len Dec Null

1

cul_pk

Integer

4

0

N

2

cul_cusfk

Integer

4

0

N

3

cust_no

Character

6

0

N

4

date

Date

8

0

N

5

name

Character

30

0

N

6

credit

Numeric

10

2

N

7

balance

Numeric

10

2

N

8

operator

Character

10

0

N

9

custact

Character

8

0

N

Total record size: 91

Table: au!customer

# Field Name Type Len Dec Null

1

cus_pk

Integer

4

0

N
Caption: Primary Key

2

cust_no

Character

6

0

N
Caption: Cust No

3

salutation

Character

20

0

N
Caption: Salutation

4

cust_fname

Character

20

0

N
Caption: First Name

5

cust_lname

Character

30

0

N
Caption: Last Name

6

suffix

Character

40

0

N
Caption: Suffix

7

attention

Character

40

0

N
Caption: Attention

8

addr1

Character

42

0

N
Caption: Address Line 1

9

addr2

Character

42

0

N
Caption: Address Line 2

10

addr3

Character

42

0

N
Caption: Address Line 3

11

city

Character

25

0

N
Caption: City

12

state

Character

3

0

N
Caption: State

13

county

Character

3

0

N
Caption: County

14

zip

Character

10

0

N
Caption: Zip

15

wphone

Character

22

0

N
Caption: Work Phone

16

hphone

Character

22

0

N
Caption: Home Phone

17

fphone

Character

22

0

N
Caption: Fax Phone

18

ophone

Character

22

0

N
Caption: Other Phone

19

country

Character

25

0

N
Caption: Country

20

cphone

Character

22

0

N
Caption: Cell Phone

21

cred_no

Character

24

0

N
Caption: Credit Card Number

22

cred_name

Character

20

0

N
Caption: Name on Credit Card

23

cred_init

Character

5

0

N
Caption: Credit Card Init Date

24

cred_exp

Character

5

0

N
Caption: Credit Card Exp Date

25

cred_type

Character

5

0

N
Caption: VISA, MasterCard, etc...

26

cred_limit

Numeric

8

0

N
Caption: Credit Limit

27

ib_number

Character

10

0

N

28

hand_fee

Numeric

11

2

N
Caption: Shipping Fee

29

ttl_weight

Numeric

11

2

N
Caption: Total Weight

30

total_real

Numeric

11

2

N
Caption: Total Realized

31

ttl_sold

Numeric

11

2

N
Caption: Total Sold

32

ttl_fees

Numeric

11

2

N
Caption: Total Fees

33

comments

Memo

4

0

N
Caption: Comments

34

comments2

Memo

4

0

N
Caption: Additional Comments

35

notes

Memo

4

0

N
Caption: Notes

36

cons_note

Memo

4

0

N
Caption: Consignor Note

37

terms

Character

1

0

N
Caption: Payment Terms

38

ship_via

Character

30

0

N
Caption: Ship Via

39

sub_date

Date

8

0

N
Caption: Subscription Date

40

sub_info

Character

8

0

N
Caption: Subscription Information

41

date_real

Date

8

0

N
Caption: Last Date Realized

42

resale_no

Character

16

0

N
Caption: Tax Exempt Resale Number

43

resale_st

Character

3

0

N
Caption: Resale ID State

44

resale_exp

Date

8

0

N
Caption: Resale Number Expiration Date

45

taxable

Character

1

0

N
Caption: Taxable

46

credit1

Character

60

0

N
Caption: Reference 1

47

credit2

Character

60

0

N
Caption: Reference 2

48

credit3

Character

60

0

N
Caption: Reference 3

49

credit4

Character

60

0

N
Caption: Reference 4

50

net_list

Date

8

0

N
Caption: Net Price List Date

51

real_ytd

Numeric

11

2

N
Caption: Bought to Date

52

sold_ytd

Numeric

11

2

N
Caption: Sold to Date

53

interest

Character

54

0

N

54

real_12

Numeric

11

2

N
Caption: Bought Last 12 Months

55

sold_12

Numeric

11

2

N
Caption: Sold Last 12 Months

56

last_edit

Date

8

0

N
Caption: Last Edited

57

last_time

Character

6

0

N
Caption: Last Time Edited

58

operator

Character

10

0

N
Caption: Operator who last edited

59

creator

Character

10

0

N
Caption: Record Created by

60

spec_info

Character

10

0

N
Caption: Special Info

61

credit

Numeric

9

2

N
Caption: Credit Balance

62

tax_rate

Numeric

6

3

N
Caption: Tax Rate

63

tax_gst

Numeric

6

3

N
Caption: Tax Gst

64

net_resv

Character

1

0

N
Caption: Net Reserve

65

cons_perc

Numeric

4

1

N
Caption: Consignor Percentage

66

add_date

Date

8

0

N
Caption: Added to File

67

ship1

Character

40

0

N
Caption: Shipping Lable Line 1

68

ship2

Character

40

0

N
Caption: Shipping Lable Line 2

69

ship3

Character

40

0

N
Caption: Shipping Lable Line 3

70

ship4

Character

40

0

N
Caption: Shipping Lable Line 4

71

ship5

Character

40

0

N
Caption: Shipping Lable Line 5

72

date_under

Date

8

0

N
Caption: Last Date was an Underbidder

73

mail_flag

Character

4

0

N
Caption: Mail Flag

74

email_flag

Character

4

0

N
Caption: eMail Flag

75

cons_fixed

Numeric

5

2

N
Caption: ?

76

min_commp

Numeric

6

2

N
Caption: Minimum Commission Public Sale

77

min_commm

Numeric

6

2

N
Caption: Minimum Commission Mail Sale

78

no_fees

Logical

1

0

N
Caption: Do Not Charge Any Consignor Fees

79

ccons_type

Character

1

0

N
Caption: Consignor Type

80

zero_ins

Character

1

0

N
Caption: Do not charge for Insurance

81

busaddr

Character

1

0

N
Caption: Address is Business

82

tax_exempt

Logical

1

0

N
Caption: Tax Exempt

83

password

Character

8

0

N
Caption: Topspeed Password

84

email

Character

65

0

N
Caption: eMail Address

85

email2

Character

65

0

N
Caption: 2nd eMail Address

86

remove

Character

1

0

N
Caption: Remove from eMail Lists

87

ph_atten

Character

40

0

N
Caption: Phone Attention

88

house

Character

1

0

N
Caption: Customer is House Bidder

89

balcur

Numeric

10

2

N
Caption: Current Balance

90

bal30

Numeric

10

2

N
Caption: 30 Day Balance

91

bal60

Numeric

10

2

N
Caption: 60 Day Balance

92

bal90

Numeric

10

2

N
Caption: 90 Day Balance

93

bal91

Numeric

10

2

N
Caption: Over 90 day balance

94

flag_hist

Character

50

0

N
Caption: Mail Flag History

95

ttl_netdue

Numeric

12

2

N

96

handle

Character

40

0

N
Caption: SAN Handle

97

approved

Character

1

0

N
Caption: SAN Approved

98

cus_recst

Character

1

0

N
Caption: Record State

99

bbr_number

Character

10

0

N
Caption: 2nd Interface Number

100

cus_coufk

Integer

4

0

N
Caption: Country Foreign Key

101

cou_ab

Character

3

0

N
Caption: Country Code

102

email_type

Character

1

0

N
Caption: Email Type

103

mark_type

Character

1

0

N
Caption: Promotional Materials Type

104

fullsal

Character

65

0

N
Caption: Full Salutation (Complete Replacement)

105

finder

Character

6

0

N
Caption: Finder Customer Number

106

finder_fee

Numeric

5

1

N
Caption: Finder Fee

107

ship_state

Character

3

0

N
Caption: Ship State

108

company

Character

65

0

N
Caption: Company

109

position

Character

65

0

N
Caption: Position

110

vat_number

Character

20

0

N
Caption: Vat Number

111

cons_code

Character

4

0

N
Caption: Consignor Fee Struction Type

112

agent

Character

35

0

N
Caption: Bidding Agent

113

fedtaxid

Character

12

0

N
Caption: Federal Tax ID

114

cons_inss

Numeric

5

2

N
Caption: Insurance Percentage Sold Lots

115

cons_insu

Numeric

5

2

N
Caption: Insurance Percentage Unsold Lots

116

ins_waived

Logical

1

0

N
Caption: Insurance Waived

117

sh_city

Character

25

0

N
Caption: Shipping City

118

sh_state

Character

3

0

N
Caption: Shipping State

119

sh_county

Character

3

0

N
Caption: Shipping County

120

sh_zip

Character

10

0

N
Caption: Shipping Zip

121

sh_country

Character

25

0

N
Caption: Shipping Country

122

sh_cou_ab

Character

3

0

N
Caption: Shipping Country Abbreviation

123

sh_coufk

Integer

4

0

N
Caption: Shipping Country Foreign Key

124

sub_cost

Numeric

6

2

N
Caption: Subscription Cost

125

unsold_perc

Numeric

7

2

N
Caption: Unsold Commision Percentage

126

min_commpu

Numeric

7

2

N
Caption: Minimum Commission Public Unsold

127

min_commmu

Numeric

7

2

N
Caption: Minimum Commision Mail Unsold

128

ccon_lev1

Numeric

5

0

N
Caption: Break Commission at this Amount

129

ccon_perc0

Numeric

5

1

N
Caption: Consignor Percent Up to this level

130

ccon_perc1

Numeric

5

1

N
Caption: Consignor Percent After this level

131

custom1

Character

20

0

N
Caption: Custom Field 1

132

sales_mgr

Character

20

0

N
Caption: Sales Mgr

133

sales_rep

Character

20

0

N
Caption: Sales Rep

134

emessage

Memo

4

0

N
Caption: email Message

135

dns_all

Logical

1

0

N
Caption: Do Not Send Anything

136

dns_a

Logical

1

0

N
Caption: Do Not Send Announcements

137

dns_cc

Logical

1

0

N
Caption: Do Not Send Consignor Correspondence

138

dns_cats

Logical

1

0

N
Caption: Do Not Send Catalogs / Custom Catalogs

139

dns_bid

Logical

1

0

N
Caption: Do Not Send Bid Confirmations

140

dns_ob

Logical

1

0

N
Caption: Do Not Send Out Bid Notices

141

dns_inv

Logical

1

0

N
Caption: Do Not Send Invoices

142

dns_invp

Logical

1

0

N
Caption: DNS Paper Invoice

143

dns_pr

Logical

1

0

N
Caption: Do Not Send Prices Realized (General)

144

dns_cpr

Logical

1

0

N
Caption: Do Not Send Custom Prices Realized

145

dns_s

Logical

1

0

N
Caption: Do Not Send Statements / Dunning Letters

146

id_checked

Logical

1

0

N
Caption: Id Checked

147

sh_wphone

Character

22

0

N
Caption: Shipping Address Phone

148

sh_fphone

Character

22

0

N
Caption: Shipping Fax Phone

149

cusfilter

Character

1

0

N
Caption: Customer Filter

150

birthdate

Date

8

0

N
Caption: Birth Date

151

cust_idno

Character

12

0

N
Caption: Customer ID Number (Drivers Licence/Passport)

152

ship_zone

Character

4

0

N
Caption: Ship Zone

153

website

Character

60

0

N
Caption: Website

154

source

Character

20

0

N
Caption: Source

155

rating

Character

2

0

N
Caption: Rating of Client/Prospect

156

cust_type

Character

30

0

N
Caption: Customer Type

157

cust_stat

Character

20

0

N
Caption: Cust Stat

158

events

Character

10

0

N
Caption: Events

159

subsource

Character

10

0

N
Caption: Subsource

160

gifting

Character

20

0

N
Caption: Gifting

161

max_invoice

Numeric

11

2

N
Caption: Largest Invoice

162

sales_hist

Memo

4

0

N
Caption: Sales History

163

last_bid

Date

8

0

N
Caption: Last Bid

164

last_buy

Date

8

0

N
Caption: Last Buy

165

last_cons

Date

8

0

N
Caption: Last Cons

166

div1

Logical

1

0

N
Caption: Division 1

167

div2

Logical

1

0

N
Caption: Division 2

168

div3

Logical

1

0

N
Caption: Division 3

169

div4

Logical

1

0

N
Caption: Division 4

170

pnotes

Memo

4

0

N
Caption: Partner Notes

171

pconfident

Memo

4

0

N
Caption: Partner Confidential Notes

172

btotal

Numeric

12

2

N
Caption: Partner Buying Total

173

stotal

Numeric

12

2

N
Caption: Partner Selling Total

Total record size: 2507

Table: au!ebayfees

# Field Name Type Len Dec Null

1

eba_pk

Integer

4

0

N

2

sale_no

Character

5

0

N

3

lot_no

Character

5

0

N

4

ebay_id

Character

10

0

N

5

date

Date

8

0

N

6

amount

Numeric

9

2

N

7

type

Character

20

0

N

8

consignor

Character

6

0

N

Total record size: 68

Table: au!ebayinv

# Field Name Type Len Dec Null

1

ein_pk

Integer

4

0

N

2

item

Character

10

0

N

3

price

Numeric

8

2

N

4

descrip

Character

50

0

N

5

email

Character

60

0

N

6

date

Date

8

0

N

7

ebay_id

Character

80

0

N

8

sold

Character

1

0

N

Total record size: 222

Table: au!expcntrl

# Field Name Type Len Dec Null

1

exp_pk

Integer

4

0

N

2

sale1

Character

4

0

N

3

sale2

Character

4

0

N

4

sale3

Character

4

0

N

5

sale4

Character

4

0

N

6

sale5

Character

4

0

N

7

sale6

Character

4

0

N

8

open1

Character

1

0

N

9

open2

Character

1

0

N

10

open3

Character

1

0

N

11

open4

Character

1

0

N

12

open5

Character

1

0

N

13

open6

Character

1

0

N

14

iweb_date

Date

8

0

N
Caption: Iweb Date

15

iweb_time

Character

6

0

N
Caption: Iweb Time

16

uweb_date

Date

8

0

N
Caption: Uweb Date

17

uweb_time

Character

6

0

N
Caption: Uweb Time

18

dformat

Character

2

0

N
Caption: Division

Total record size: 65

Table: au!filcond

# Field Name Type Len Dec Null

1

fc_pk

Integer

4

0

N

2

fc_filfk

Integer

4

0

N

3

fc_seq

Numeric

2

0

N

4

fc_join

Character

8

0

N

5

fc_alias

Character

20

0

N

6

fc_fname

Character

40

0

N

7

fc_fdesc

Character

40

0

N

8

fc_ftype

Character

1

0

N

9

fc_not

Logical

1

0

N

10

fc_case

Logical

1

0

N

11

fc_oper

Character

1

0

N

12

fc_values

Memo

4

0

N

13

fc_close

Character

10

0

N

Total record size: 137

Table: au!filters

# Field Name Type Len Dec Null

1

fil_pk

Integer

4

0

N

2

fil_type

Character

1

0

N

3

fil_name

Character

50

0

N
Caption: Filter Name

4

fil_alias

Character

20

0

N
Caption: Primary Alias

5

fil_heading

Memo

4

0

N
Caption: Fil Heading

6

fil_usehdg

Logical

1

0

N
Caption: Fil Usehdg

7

fil_notes

Memo

4

0

N

8

fil_advanced

Memo

4

0

N
Caption: Advanced Filter Condition

Total record size: 89

Table: au!generatepk

# Field Name Type Len Dec Null

1

gpk_pk

Character

128

0

N
Caption: Primary Key
Comments: TableName for which to generate PKs

2

gpk_currentnumber

Integer

4

0

N
Caption: Current PK
Comments: Current PK Number in use

3

gpk_currentalpha

Character

5

0

N
Caption: Current AlphaNumeric PK
Comments: Current AlphaNumeric PK in use

Total record size: 138

Table: au!grower

# Field Name Type Len Dec Null

1

gro_pk

Integer

4

0

N
Caption: Grower Primary Key

2

gro_code

Character

4

0

N
Caption: Grower Code

3

gro_descr

Character

60

0

N
Caption: Grower Description

4

last_edit

Date

8

0

N
Caption: Last Edit

5

last_time

Character

6

0

N
Caption: Last Time

6

operator

Character

10

0

N
Caption: Operator

7

notes

Memo

4

0

N
Caption: Grower Notes

8

gcat_note

Memo

4

0

N
Caption: Grower Catalog Note

9

recdelete

Character

1

0

N
Caption: Delete

10

mergeto

Character

4

0

N
Caption: Mergeto

11

link_to

Character

7

0

N
Caption: Link To Other Field

Total record size: 113

Table: au!handheld

# Field Name Type Len Dec Null

1

oid

Integer

4

0

N
Caption: Handheld Unique ID

2

cust_no

Character

6

0

N

3

consignor

Character

6

0

N

4

category

Character

8

0

N

5

sale_no

Character

5

0

N

6

invoice

Character

6

0

N

7

lot_no

Character

5

0

N

8

win_code

Character

5

0

N

9

photo

Character

1

0

N

10

est_low

Numeric

11

2

N

11

est_real

Numeric

11

2

N

12

price3

Numeric

11

4

N

13

est_code

Character

1

0

N

14

est_cons

Numeric

11

2

N

15

seq_num

Character

6

0

N

16

prop_num

Character

8

0

N

17

cons_num

Character

12

0

N

18

number_lot

Numeric

6

0

N

19

qty2

Numeric

5

0

N

20

qty3

Numeric

6

0

N

21

loc1

Character

6

0

N

22

loc2

Character

5

0

N

23

loc3

Character

5

0

N

24

add_date

Date

8

0

N

25

operator

Character

10

0

N

26

last_edit

Date

8

0

N

27

last_time

Character

6

0

N

28

ref_num

Character

30

0

N

29

case_no

Character

10

0

N

30

location

Character

10

0

N

Total record size: 233

Table: au!history

# Field Name Type Len Dec Null

1

his_pk

Integer

4

0

N

2

cust_no

Character

6

0

N

3

his_buyfk

Integer

4

0

N
Caption: Buyer FK

4

consignor

Character

6

0

N

5

his_confk

Integer

4

0

N
Caption: Consignor FK

6

category

Character

8

0

N

7

his_catfk

Integer

4

0

N
Caption: Category Foreign Key

8

sale_no

Character

5

0

N

9

his_salfk

Integer

4

0

N
Caption: Sale Foreign Key

10

lot_no

Character

5

0

N

11

his_lotfk

Integer

4

0

N
Caption: Lot Foreign Key

12

condition

Character

8

0

N

13

cons_num

Character

6

0

N

14

descrip

Character

250

0

N

15

notes

Character

20

0

N

16

srtorder

Character

20

0

N

17

est_low

Numeric

11

2

N

18

est_real

Numeric

11

2

N

19

realized

Numeric

11

2

N

20

high_bid

Numeric

11

2

N

21

topics

Character

56

0

N

22

reserve

Numeric

11

2

N

23

date_sold

Date

8

0

N

24

seq_num

Character

6

0

N

25

ref_num

Character

15

0

N

26

his_imagef

Character

25

0

N
Caption: Image File Name

Total record size: 524

Table: au!index

# Field Name Type Len Dec Null

1

ind_pk

Integer

4

0

N
Caption: Ind Pk

2

lin_pk

Integer

4

0

N

3

lot_no

Character

5

0

N

4

lin_lotfk

Integer

4

0

N

5

sale_no

Character

5

0

N

6

lin_salfk

Integer

4

0

N
Caption: Sale Foreign Key

7

category

Character

7

0

N

8

lin_catfk

Integer

4

0

N
Caption: Category Foreign Key

9

index_type

Character

1

0

N

10

keyword

Character

40

0

N

11

seq_num

Character

7

0

N

12

last_edit

Date

8

0

N

Total record size: 94

Table: au!interest

# Field Name Type Len Dec Null

1

int_pk

Integer

4

0

N

2

cust_no

Character

6

0

N
Caption: Cust No

3

int_cusfk

Integer

4

0

N
Caption: Customer FK

4

collects

Character

30

0

N
Caption: Collects

5

last_edit

Date

8

0

N
Caption: Last Edit

6

level

Character

1

0

N
Caption: Level

7

num_lots

Numeric

5

0

N
Caption: Number of Lots

8

buy_total

Numeric

9

0

N
Caption: Total Purchased

9

ib_number

Character

6

0

N

10

operator

Character

10

0

N
Caption: Operator

11

last_time

Character

6

0

N
Caption: Last Time

12

int_type

Character

1

0

N
Caption: Interest Type M-Mail, C-Collects, W-Want

Total record size: 91

Table: au!invoice

# Field Name Type Len Dec Null

1

inv_pk

Integer

4

0

N
Caption: Invoice Primary Key

2

invoice

Character

6

0

N
Caption: Invoice No.

3

cust_no

Character

6

0

N
Caption: Customer No.

4

inv_cusfk

Integer

4

0

N
Caption: Customer Foreign Key

5

sale_no

Character

5

0

N
Caption: Sale No.

6

inv_salfk

Integer

4

0

N
Caption: Sale Foreign Key

7

date

Date

8

0

N
Caption: Invoice Date

8

subamount

Numeric

11

2

N
Caption: Sub Total of Hammer

9

cogsamount

Numeric

11

2

N
Caption: Cost of Goods Sold

10

cocmamount

Numeric

12

2

N
Caption: Cost of Consigned Material

11

returns

Numeric

11

2

N
Caption: Returns Subtotal

12

ret_qty

Numeric

4

0

N
Caption: Returns Quantity

13

texempt

Numeric

11

2

N
Caption: Tax Exempt Total

14

bidder_fee

Numeric

11

2

N
Caption: Bidders Premium Percentage

15

buyfee

Numeric

11

2

N
Caption: Amount of the Buyer's Premium

16

tax

Numeric

11

2

N
Caption: Tax Amount (or Sum of Hammer Vats)

17

tax_unpaid

Numeric

11

2

N
Caption: Tax Unpaid

18

taxgst

Numeric

11

2

N
Caption: Taxgst

19

prem_tax

Numeric

11

2

N
Caption: VAT Tax on Buyer's Premium (sum of Lots.Prem_Tax)

20

vat_taxs

Numeric

11

2

N
Caption: Vat Tax on Shipping

21

duty

Numeric

11

2

N
Caption: Duty

22

zero_tax

Logical

1

0

N
Caption: Zero Tax

23

freight

Numeric

11

2

N
Caption: Freight (Shipping and Handling)

24

cc_fee

Numeric

10

2

N
Caption: Credit Card Fee

25

expert

Numeric

11

2

N
Caption: Expert Fees

26

late_pay

Numeric

10

2

N
Caption: Late Payment Charge

27

discount

Numeric

6

2

N
Caption: Invoice Discount

28

ins_perc

Numeric

6

3

N
Caption: Insurance Percentage

29

insurance

Numeric

11

2

N
Caption: Insurance Amount

30

buyer_misc

Numeric

11

2

N
Caption: Sum of Miscellaneous Buyer Charges

31

credit

Numeric

11

2

N
Caption: Credit Amount

32

amount

Numeric

11

2

N
Caption: Total Amount of Invoice

33

paid

Character

1

0

N
Caption: Paid Status

34

amount_pd

Numeric

11

2

N
Caption: Total Amount Paid

35

date_paid

Date

8

0

N
Caption: Date Paid

36

how_paid

Character

20

0

N
Caption: How Paid

37

authorize

Character

20

0

N
Caption: Authorized by

38

comments

Memo

4

0

N
Caption: Comments to Print on Invoice

39

sales_rep

Character

20

0

N
Caption: Sales Rep

40

last_edit

Date

8

0

N
Caption: Last Edited

41

notes

Memo

4

0

N
Caption: Notes (Internal Use)

42

pickedup

Character

1

0

N
Caption: Picked Up

43

paddle

Character

4

0

N
Caption: Paddle No.

44

export

Character

1

0

N
Caption: Import Export

45

combo

Logical

1

0

N
Caption: Combination Invoice (has miscellaneous)

46

soldtime

Character

14

0

N
Caption: Sold Time

47

terms

Character

2

0

N
Caption: Payment Terms

48

cred_no

Character

24

0

N
Caption: Credit Card No.

49

cred_exp

Character

5

0

N
Caption: Credit Card Expiration Date

50

cred_type

Character

5

0

N
Caption: Credit Card Type

51

lineitems

Numeric

4

0

N
Caption: Line Items

52

weight

Numeric

7

1

N
Caption: Total Weight

53

ttlcases

Numeric

10

2

N
Caption: Ttlcases

54

ship_via

Character

30

0

N
Caption: Ship Via (Shipping Method)

55

operator

Character

10

0

N
Caption: Operator

56

last_time

Character

6

0

N
Caption: Last Time

57

shipspec

Character

20

0

N
Caption: Special Shipping

58

released

Character

1

0

N
Caption: Released

59

rel_date

Date

8

0

N
Caption: Release Date

60

rel_by

Character

20

0

N
Caption: Released By

61

rel_prntd

Character

1

0

N
Caption: Release Order Printed

62

shipped

Character

1

0

N
Caption: Shipped

63

ship_date

Date

8

0

N
Caption: Ship Date

64

tax_rate

Numeric

6

3

N
Caption: Tax Rate

65

tax_gst

Numeric

6

3

N
Caption: Tax Gst

66

taxable

Character

1

0

N
Caption: Taxable

67

ship1

Character

50

0

N
Caption: Ship to Address 1

68

ship2

Character

50

0

N
Caption: Ship to Address 2

69

ship3

Character

50

0

N
Caption: Ship to Address 3

70

ship4

Character

50

0

N
Caption: Ship to Address 4

71

ship5

Character

50

0

N
Caption: Ship to Address 5

72

tax_state

Character

3

0

N
Caption: Tax State

73

tax_cntry

Character

20

0

N
Caption: Tax Country

74

sh_city

Character

25

0

N
Caption: Sh City

75

sh_county

Character

3

0

N
Caption: Shipping County

76

sh_state

Character

3

0

N
Caption: Ship State

77

sh_zip

Character

10

0

N
Caption: Sh Zip

78

sh_cou_ab

Character

3

0

N
Caption: Shipping Country Abreviation

79

sh_country

Character

25

0

N
Caption: Ship Country

80

outside

Logical

1

0

N
Caption: Outside the Scheme

81

takeasib

Logical

1

0

N
Caption: Take IBDPA as IB

82

zerorated

Logical

1

0

N
Caption: Zero Rated

83

specflag

Logical

1

0

N
Caption: Special Flag for Invoices

84

addship

Logical

1

0

N
Caption: