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: Additional Shipping Flag

85

revised

Date

8

0

N
Caption: Revised

86

revision

Numeric

3

0

N
Caption: Revision

87

eutransfer

Logical

1

0

N
Caption: EU Transfer

88

ishipper

Character

6

0

N
Caption: Invoice Shipper (Address from Customer)

89

vexport

Logical

1

0

N
Caption: Verified Exported

90

sh_coufk

Integer

4

0

N
Caption: Shipping Country Foreign Key

91

invlocked

Character

1

0

N
Caption: Invoice is Locked - Can not be Recalculated

92

resale_no

Character

12

0

N
Caption: Resale No.

93

shipverify

Character

1

0

N
Caption: Ship Verification Done?

94

ver_date

Date

8

0

N
Caption: Ship Verification Date

95

ver_by

Character

10

0

N
Caption: Ship Verified by

96

recalcship

Logical

1

0

N
Caption: Recalculate Shipping and Insurance

97

recalcins

Logical

1

0

N
Caption: Recalcins

98

pickship

Logical

1

0

N
Caption: Pickship

99

operator_pd

Character

10

0

N
Caption: Operator that marked the invoice paid

100

vat_bond

Numeric

11

2

N
Caption: Bond Clearing Charges

101

vat_manual

Logical

1

0

N
Caption: Override VAT Outcomes Manually

102

cc_perc

Numeric

6

3

N
Caption: Credit Card Percent

103

source

Character

10

0

N
Caption: Source

104

pr_list

Character

20

0

N
Caption: From Price List

105

icurrency

Character

8

0

N
Caption: Pay in Currency

106

inv_type

Character

25

0

N
Caption: Type of Invoice

107

manualship

Logical

1

0

N
Caption: Calculate Shipping/Delivery Charges Manually

108

sh_wphone

Character

22

0

N
Caption: Shipping Work Phone

109

sh_fphone

Character

22

0

N
Caption: Shipping Fax Phone

110

inv_cat1

Character

20

0

N
Caption: Inv Cat1

111

inv_cat2

Character

20

0

N
Caption: Inv Cat2

112

rcvd_date

Date

8

0

N
Caption: Date Items on Invoice were Received and are ready for Shipment

113

buy_split

Numeric

10

0

N
Caption: Buy Split

114

buy_perc2

Numeric

10

2

N
Caption: Buy Perc2

115

futamount

Numeric

12

2

N
Caption: Future Sales

116

niwamount

Numeric

12

2

N
Caption: Not in Warehouse

117

salamount

Numeric

12

2

N
Caption: SALAmount

118

cogsfuture

Numeric

12

2

N
Caption: Future Cost of Goods Sole

119

cogsniw

Numeric

12

2

N
Caption: NIW Cost of Goods Sold

120

ests_date

Date

8

0

N
Caption: Estimated Ship Date

121

ttlnecks

Numeric

8

0

N
Caption: Total Necks

122

col_date

Date

8

0

N
Caption: Collection Payment Date

123

invd_date

Date

8

0

N
Caption: Invoiced Date

124

pull_date

Date

8

0

N
Caption: Pull Date

125

pulled_by

Character

15

0

N
Caption: Pulled By

126

short_term

Character

15

0

N
Caption: Short Term Storage Location

127

inv_status

Character

30

0

N
Caption: Inv Status

128

pack_date

Date

8

0

N
Caption: Pack Date

129

packer

Character

15

0

N
Caption: Packer

130

pack_loc

Character

15

0

N
Caption: Pack Location

131

amount_bill

Numeric

12

2

N
Caption: Amount Bill

132

weather

Logical

1

0

N
Caption: Weather Watch

Total record size: 1397

Table: au!invpmts

# Field Name Type Len Dec Null

1

inp_pk

Integer

4

0

N

2

invoice

Character

6

0

N
Caption: Invoice Number

3

inp_invfk

Integer

4

0

N

4

cust_no

Character

6

0

N
Caption: Customer Number

5

inp_cusfk

Integer

4

0

N
Caption: Customer Foreign Key

6

date_paid

Date

8

0

N
Caption: Date Paid

7

amount_pd

Numeric

11

2

N
Caption: Amount Paid

8

how_paid

Character

30

0

N
Caption: How Paid

9

operator

Character

10

0

N
Caption: Operator

10

last_edit

Date

8

0

N
Caption: Last Edit

11

last_time

Character

6

0

N
Caption: Last Time

12

pay_type

Character

4

0

N
Caption: Pay Type

13

ref_num

Character

10

0

N
Caption: Sub Code

14

check_no

Character

20

0

N
Caption: Check No

15

checkcashed

Logical

1

0

N
Caption: Check Cashed

16

partialamt

Logical

1

0

N
Caption: Partialamt

17

paypalfee

Numeric

7

2

N
Caption: Paypalfee

18

exported

Logical

1

0

N
Caption: Exported

Total record size: 142

Table: au!lablset

# Field Name Type Len Dec Null

1

lab_pk

Integer

4

0

N

2

label_code

Character

4

0

N

3

descrip

Character

20

0

N

4

s_lab_las

Character

1

0

N

5

label_top

Character

1

0

N

6

s_lab_len

Numeric

2

0

N

7

s_lab_col

Numeric

2

0

N

8

s_lab_mar

Numeric

2

0

N

9

s_lab_row

Numeric

2

0

N

10

prnt_bar_c

Character

1

0

N

11

s_lab_wid

Numeric

2

0

N

12

s_lab_ex

Numeric

2

0

N

13

format

Character

2

0

N

14

lot_rept

Character

15

0

N

15

s_orient

Character

1

0

N

Total record size: 62

Table: au!larchive

# Field Name Type Len Dec Null

1

lot_pk

Integer

4

0

N
Caption: Primary Key

2

cust_no

Character

6

0

N
Caption: Buyer

3

lot_buyfk

Integer

4

0

N
Caption: Buyer FK

4

consignor

Character

6

0

N
Caption: Consignor

5

lot_confk

Integer

4

0

N
Caption: Consignor FK

6

category

Character

8

0

N
Caption: Category Code

7

lot_catfk

Integer

4

0

N
Caption: Category Foreign Key

8

sale_no

Character

5

0

N
Caption: Sale No.

9

lot_salfk

Integer

4

0

N
Caption: Sale Foreign Key

10

invoice

Character

6

0

N
Caption: Invoice No.

11

lot_invfk

Integer

4

0

N
Caption: Invoice Foreign Key

12

lot_no

Character

5

0

N
Caption: Lot No.

13

lot_apfk

Integer

4

0

N
Caption: AP record Foreign Key

14

lot_apsfk

Integer

4

0

N
Caption: AP Sort Foreign Key

15

win_code

Character

5

0

N
Caption: Wine Code

16

lot_winfk

Integer

4

0

N
Caption: Wine Foreign Key

17

lot_grofk

Integer

4

0

N
Caption: Grower Foreign Key

18

descrip

Character

250

0

N
Caption: not used (Now in Lot_Descr)

19

photo

Character

1

0

N
Caption: Photo

20

est_low

Numeric

11

2

N
Caption: Price 1

21

est_real

Numeric

11

2

N
Caption: Price 2

22

price3

Numeric

11

3

N
Caption: Price 3

23

est_code

Character

1

0

N
Caption: Est Code

24

est_cons

Numeric

11

2

N
Caption: Consignor Estimate

25

srtorder

Character

25

0

N
Caption: Catalog No.

26

seq_num

Character

7

0

N
Caption: Sequence No.

27

prop_num

Character

8

0

N
Caption: Property No.

28

cons_num

Character

12

0

N
Caption: Consignor Reference No.

29

cons_perc

Numeric

4

1

N
Caption: Consignor Percent

30

misc_fee

Numeric

8

2

N
Caption: Misc Fee

31

lott_fee

Numeric

7

2

N
Caption: Lotting Fee

32

cons_fee

Numeric

11

2

N
Caption: Consignor Fee

33

ins_fee

Numeric

10

2

N
Caption: Insurance Fee

34

underbid

Numeric

11

2

N
Caption: Underbid

35

opening

Numeric

11

2

N
Caption: Opening

36

man_open

Character

1

0

N
Caption: Manual Open

37

realized

Numeric

11

2

N
Caption: Realized

38

reserve

Numeric

12

3

N
Caption: Reserve

39

number_lot

Numeric

6

0

N
Caption: Number of Lots

40

qty2

Numeric

5

0

N
Caption: Qty2

41

qty3

Numeric

6

0

N
Caption: Qty3

42

loc1

Character

6

0

N
Caption: Location 1

43

loc2

Character

5

0

N
Caption: Location 2

44

loc3

Character

5

0

N
Caption: Location 3

45

duplicate

Logical

1

0

N
Caption: Duplicate Lot

46

est_weight

Numeric

7

2

N
Caption: Estimated Weight

47

high_bid

Numeric

11

2

N
Caption: High Bid

48

discount

Numeric

5

1

N
Caption: Discount %

49

bid

Numeric

11

2

N
Caption: Bid

50

symbol

Character

8

0

N
Caption: Symbol

51

condition

Character

8

0

N
Caption: Condition

52

pr_type

Character

1

0

N
Caption: PR Type

53

finder_fee

Numeric

5

1

N
Caption: Finder's Fee %

54

finder

Character

6

0

N
Caption: Finder No.

55

insurance

Numeric

7

3

N
Caption: Insurance %

56

expert_fee

Numeric

7

2

N
Caption: Expertization Fee

57

photo_fee

Numeric

7

2

N
Caption: Photo Fee

58

notes

Character

64

0

N
Caption: Notes

59

currency

Character

3

0

N
Caption: Currency

60

catalog

Character

15

0

N
Caption: Catalog

61

box_lot

Character

1

0

N
Caption: Box Lot

62

spill

Memo

4

0

N
Caption: Rest of Description (now in Lot_Descr)

63

bidder

Character

6

0

N
Caption: High Bidder No.

64

creator

Character

10

0

N
Caption: Created By

65

add_date

Date

8

0

N
Caption: Added Date

66

operator

Character

10

0

N
Caption: Last Changed by

67

last_edit

Date

8

0

N
Caption: Last Date Edited

68

last_time

Character

6

0

N
Caption: Last Time Edited

69

ref_num

Character

30

0

N
Caption: Reference No.

70

topics

Character

56

0

N
Caption: Topics

71

gum

Character

5

0

N
Caption: Gum

72

plate

Character

10

0

N
Caption: Plate

73

num_bids

Numeric

4

0

N
Caption: Number of Bids

74

net_resv

Character

1

0

N
Caption: Net Reserve?

75

lot_notes

Memo

4

0

N
Caption: Lotting Notes

76

date_sold

Date

8

0

N
Caption: Date Sold

77

date_buy

Date

8

0

N
Caption: Date Bought

78

extension

Character

5

0

N
Caption: On Extension

79

country

Character

120

0

N
Caption: Country

80

paddle

Character

4

0

N
Caption: Won by Paddle No.

81

tax_exempt

Logical

1

0

N
Caption: Tax Exempt

82

header

Memo

4

0

N
Caption: Header

83

footer

Memo

4

0

N
Caption: Footer

84

ceiling

Logical

1

0

N
Caption: Ceiling Bid on this lot

85

sale_hist

Character

60

0

N
Caption: Sale History

86

errata

Memo

4

0

N
Caption: Errata

87

added

Numeric

5

0

N
Caption: Added (labels)

88

lot_flag

Character

4

0

N
Caption: Lot Flag

89

soldtime

Character

14

0

N
Caption: Sold Time

90

image

Character

1

0

N
Caption: Image

91

pull

Character

1

0

N
Caption: Pull

92

deskkey

Character

1

0

N
Caption: Deskkey (multiple images)

93

buyer_misc

Numeric

11

2

N
Caption: Buyer Misc Fee

94

cons_misc

Numeric

11

2

N
Caption: Consignor Misc Fee

95

lot_descr

Memo

4

0

N
Caption: Description

96

vat_offer

Character

4

0

N
Caption: VAT Offered as Status

97

vat_taken

Character

4

0

N
Caption: VAT Taken Status

98

vat_tax

Numeric

11

2

N
Caption: Vat Tax

99

vat_prem

Numeric

12

2

N
Caption: Vat on Buyers Premium

100

duty

Numeric

12

2

N
Caption: Duty/Excise Tax

101

freecirc

Character

1

0

N
Caption: Free Circulation (default="Y")

102

cases

Numeric

4

0

N
Caption: Cases

103

ship_fee

Numeric

8

2

N
Caption: Shipping Fee per Case

104

lotclear

Character

1

0

N
Caption: Lot has been Cleared for Payment to the Consignor

105

nest_low

Numeric

10

2

N
Caption: New Low Estimate

106

nest_real

Numeric

10

2

N
Caption: New High Estimate

107

nreserve

Numeric

10

2

N
Caption: New Reserve

108

agent

Character

3

0

N
Caption: Agent

109

delivery

Logical

1

0

N
Caption: Delivery

110

lshipper

Character

6

0

N
Caption: Shipper for this Lot

111

reoffered

Numeric

3

0

N
Caption: Number of time lot has been reoffered

112

vat_bond

Numeric

11

2

N
Caption: Bond Clearing Charges

113

cvat_lot

Numeric

10

2

N
Caption: Consignors VAT on Lot Hammer

114

cvat_com

Numeric

10

2

N
Caption: Consignors VAT on LOT commision

115

cvat_ins

Numeric

10

2

N
Caption: Consignors VAT on Insurance

116

cvat_fees

Numeric

10

2

N
Caption: Consignors VAT on Lot Fees

117

parcel

Logical

1

0

N
Caption: Parcel

118

par_lotfk

Integer

4

0

N
Caption: Parcel Lot Foreign Key

119

retail

Numeric

12

2

N
Caption: Retail Price

120

newarrival

Character

1

0

N
Caption: New Arrival

121

special

Character

1

0

N
Caption: Special

122

number_bo

Numeric

6

0

N
Caption: Number Backordered

123

allow_bo

Character

1

0

N
Caption: Allow Backorders

124

addlotpk

Integer

4

0

N
Caption: PK in Invoices File (same as Lot_PK)

125

origlotpk

Integer

4

0

N
Caption: Original Lot_PK from Inventory

126

clr_date

Date

8

0

N
Caption: Date Lot was first Cleared for Payment

Total record size: 1342

Table: au!lindex

# Field Name Type Len Dec Null

1

lin_pk

Integer

4

0

N

2

lot_no

Character

5

0

N
Caption: Lot No.

3

lin_lotfk

Integer

4

0

N
Caption: Lot FK

4

sale_no

Character

5

0

N
Caption: Sale No.

5

lin_salfk

Integer

4

0

N
Caption: Sale Foreign Key

6

category

Character

8

0

N
Caption: Category Code

7

lin_catfk

Integer

4

0

N
Caption: Category Foreign Key

8

index_type

Character

1

0

N
Caption: Index Type

9

keyword

Character

40

0

N
Caption: Keyword

10

seq_num

Character

7

0

N
Caption: Sequence Number

11

last_edit

Date

8

0

N
Caption: Last Edit

12

operator

Character

10

0

N
Caption: Operator

13

last_time

Character

6

0

N
Caption: Last Time

Total record size: 107

Table: au!loggedinusers

# Field Name Type Len Dec Null

1

clu_fk

Character

5

0

N

2

clu_mk

Character

20

0

N

3

clu_dt

DateTime

8

0

N
Default: DATETIME()

4

clu_mk1

Character

12

0

N

5

clu_fk1

Character

5

0

N

Total record size: 51

Table: au!loginhistory

# Field Name Type Len Dec Null

1

ulh_pk

Integer

4

0

N
Default: x3genpk("LOGINHISTORY","AU")

2

ulh_usrfk

Integer

4

0

N
Comments: Foreign key to the USERS table
Validation Rule: IIF(_triggerlevel>0,.T.,x3seek("AU",ulh_usrfk,"USERS","Usr_PK",.T.))
Validation Text: xxfwruleerrortext("FR_ULH_UsrFK","The User you have entered is not on file in the Users reference file")

3

ulh_in

DateTime

8

0

N
Validation Rule: .NOT.EMPTY(ulh_in).AND.ulh_in<=DATETIME()
Validation Text: xxfwruleerrortext("FR_ULH_In","Login may not be in the future.")

4

ulh_out

DateTime

8

0

Y
Default: .NULL.
Validation Rule: ISNULL(ulh_out).OR.(.NOT.EMPTY(ulh_out).AND.ulh_out<=DATETIME())
Validation Text: xxfwruleerrortext("FR_ULH_Out","Logout may not be in the future.")

5

ulh_outflag

Character

1

0

N
Comments: Indicates how the logout occurred. See XXFW.VCX/cusUser.LogLoginLogout()
Default: "U"
Validation Rule: INLIST(ulh_outflag,"A","E","N","S","T","U")
Validation Text: xxfwruleerrortext("FR_ULH_OutFlag","Logout flag must be one of the following: 'A', 'E', 'N', 'S', 'T', 'U'")

6

ulh_machine

Character

20

0

N
Default: SYS(0)

7

ulh_uuidna

Character

12

0

N
Comments: Universal Unique ID/Network Address from the Registry (HKEY_LocalMachine/Software/Description/Microsoft/RPC/UuidTemporaryData) see X3UUIDNA.PRG
Default: x3uuidna()

8

ulh_wstfk

Integer

4

0

N

Total record size: 62

Table: au!lots

# Field Name Type Len Dec Null

1

lot_pk

Integer

4

0

N
Caption: Primary Key

2

cust_no

Character

6

0

N
Caption: Buyer

3

lot_buyfk

Integer

4

0

N
Caption: Buyer FK

4

consignor

Character

6

0

N
Caption: Consignor

5

lot_confk

Integer

4

0

N
Caption: Consignor FK

6

category

Character

8

0

N
Caption: Category Code

7

lot_catfk

Integer

4

0

N
Caption: Category Foreign Key

8

sale_no

Character

5

0

N
Caption: Sale No.

9

lot_salfk

Integer

4

0

N
Caption: Sale Foreign Key

10

invoice

Character

6

0

N
Caption: Invoice No.

11

lot_invfk

Integer

4

0

N
Caption: Invoice Foreign Key

12

lot_no

Character

5

0

N
Caption: Lot No.

13

lot_apfk

Integer

4

0

N
Caption: AP record Foreign Key

14

lot_apsfk

Integer

4

0

N
Caption: AP Sort Foreign Key

15

win_code

Character

5

0

N
Caption: Wine Code

16

lot_winfk

Integer

4

0

N
Caption: Wine Foreign Key

17

lot_grofk

Integer

4

0

N
Caption: Grower Foreign Key

18

descrip

Character

250

0

N
Caption: not used (Now in Lot_Descr)

19

photo

Character

1

0

N
Caption: Photo

20

est_low

Numeric

11

2

N
Caption: Price 1

21

est_real

Numeric

11

2

N
Caption: Price 2

22

price3

Numeric

11

4

N
Caption: Price 3

23

est_code

Character

1

0

N
Caption: Est Code

24

est_cons

Numeric

11

2

N
Caption: Consignor Estimate

25

srtorder

Character

40

0

N
Caption: Catalog No.

26

seq_num

Character

7

0

N
Caption: Sequence No.

27

prop_num

Character

8

0

N
Caption: Property No.

28

cons_num

Character

12

0

N
Caption: Consignor Reference No.

29

cons_perc

Numeric

5

1

N
Caption: Consignor Percent

30

misc_fee

Numeric

8

2

N
Caption: Misc Fee

31

lott_fee

Numeric

7

2

N
Caption: Lotting Fee

32

cons_fee

Numeric

11

2

N
Caption: Consignor Fee

33

ins_fee

Numeric

10

2

N
Caption: Insurance Fee

34

underbid

Numeric

11

2

N
Caption: Underbid

35

opening

Numeric

11

2

N
Caption: Opening

36

man_open

Character

1

0

N
Caption: Manual Open

37

realized

Numeric

12

3

N
Caption: Realized

38

reserve

Numeric

12

3

N
Caption: Reserve

39

number_lot

Numeric

9

2

N
Caption: Number of Lots

40

qty2

Numeric

6

0

N
Caption: Qty2

41

qty3

Numeric

6

0

N
Caption: Qty3

42

loc1

Character

12

0

N
Caption: Location 1

43

loc2

Character

12

0

N
Caption: Location 2

44

loc3

Character

12

0

N
Caption: Location 3

45

loc4

Character

12

0

N
Caption: Loc4

46

duplicate

Logical

1

0

N
Caption: Duplicate Lot

47

grade1

Character

12

0

N
Caption: Grade1

48

grade2

Character

12

0

N
Caption: Grade2

49

est_weight

Numeric

7

2

N
Caption: Estimated Weight

50

high_bid

Numeric

11

2

N
Caption: High Bid

51

discount

Numeric

9

5

N
Caption: Discount %

52

bid

Numeric

11

2

N
Caption: Bid

53

symbol

Character

8

0

N
Caption: Symbol

54

condition

Character

8

0

N
Caption: Condition

55

pr_type

Character

1

0

N
Caption: PR Type

56

finder_fee

Numeric

5

1

N
Caption: Finder's Fee %

57

finder

Character

6

0

N
Caption: Finder No.

58

insurance

Numeric

7

3

N
Caption: Insurance %

59

expert_fee

Numeric

7

2

N
Caption: Expertization Fee

60

photo_fee

Numeric

7

2

N
Caption: Photo Fee

61

notes

Character

64

0

N
Caption: Notes

62

currency

Character

3

0

N
Caption: Currency

63

catalog

Character

15

0

N
Caption: Catalog

64

box_lot

Character

1

0

N
Caption: Box Lot

65

spill

Memo

4

0

N
Caption: Rest of Description (now in Lot_Descr)

66

bidder

Character

6

0

N
Caption: High Bidder No.

67

creator

Character

10

0

N
Caption: Created By

68

add_date

Date

8

0

N
Caption: Added Date

69

operator

Character

10

0

N
Caption: Last Changed by

70

last_edit

Date

8

0

N
Caption: Last Date Edited

71

last_time

Character

6

0

N
Caption: Last Time Edited

72

ref_num

Character

50

0

N
Caption: Reference No.

73

topics

Character

56

0

N
Caption: Topics

74

gum

Character

12

0

N
Caption: Gum

75

plate

Character

12

0

N
Caption: Plate

76

num_bids

Numeric

4

0

N
Caption: Number of Bids

77

net_resv

Character

1

0

N
Caption: Net Reserve?

78

lot_notes

Memo

4

0

N
Caption: Lotting Notes

79

date_sold

Date

8

0

N
Caption: Date Sold

80

date_buy

Date

8

0

N
Caption: Date Bought

81

extension

Character

20

0

N
Caption: On Extension

82

country

Character

120

0

N
Caption: Country

83

paddle

Character

4

0

N
Caption: Won by Paddle No.

84

tax_exempt

Logical

1

0

N
Caption: Tax Exempt

85

header

Memo

4

0

N
Caption: Header

86

footer

Memo

4

0

N
Caption: Footer

87

ceiling

Logical

1

0

N
Caption: Ceiling Bid on this lot

88

sale_hist

Character

240

0

N
Caption: Sale History

89

errata

Memo

4

0

N
Caption: Errata

90

added

Numeric

5

0

N
Caption: Added (labels)

91

lot_flag

Character

4

0

N
Caption: Lot Flag

92

soldtime

Character

14

0

N
Caption: Sold Time

93

image

Character

1

0

N
Caption: Image

94

pull

Character

1

0

N
Caption: Pull

95

deskkey

Character

1

0

N
Caption: Deskkey (multiple images)

96

buyer_misc

Numeric

11

2

N
Caption: Buyer Misc Fee

97

cons_misc

Numeric

11

2

N
Caption: Consignor Misc Fee

98

lot_descr

Memo

4

0

N
Caption: Description

99

vat_offer

Character

4

0

N
Caption: VAT Offered as Status

100

vat_taken

Character

4

0

N
Caption: VAT Taken Status

101

vat_tax

Numeric

11

2

N
Caption: Vat Tax

102

vat_prem

Numeric

12

2

N
Caption: Vat on Buyers Premium

103

duty

Numeric

12

2

N
Caption: Duty/Excise Tax

104

freecirc

Character

1

0

N
Caption: Free Circulation (default="Y")

105

cases

Numeric

4

0

N
Caption: Cases

106

ship_fee

Numeric

8

2

N
Caption: Shipping Fee per Case

107

lotclear

Character

1

0

N
Caption: Lot has been Cleared for Payment to the Consignor

108

nest_low

Numeric

10

2

N
Caption: New Low Estimate

109

nest_real

Numeric

10

2

N
Caption: New High Estimate

110

nreserve

Numeric

10

2

N
Caption: New Reserve

111

agent

Character

3

0

N
Caption: Agent

112

delivery

Logical

1

0

N
Caption: Delivery

113

lshipper

Character

6

0

N
Caption: Shipper for this Lot

114

reoffered

Numeric

3

0

N
Caption: Number of time lot has been reoffered

115

vat_bond

Numeric

11

2

N
Caption: Bond Clearing Charges

116

cvat_lot

Numeric

10

2

N
Caption: Consignors VAT on Lot Hammer

117

cvat_com

Numeric

10

2

N
Caption: Consignors VAT on LOT commision

118

cvat_ins

Numeric

10

2

N
Caption: Consignors VAT on Insurance

119

cvat_fees

Numeric

10

2

N
Caption: Consignors VAT on Lot Fees

120

parcel

Logical

1

0

N
Caption: Parcel

121

par_lotfk

Integer

4

0

N
Caption: Parcel Lot Foreign Key

122

retail

Numeric

12

2

N
Caption: Retail Price

123

clr_date

Date

8

0

N
Caption: Date Lot was first Cleared for Payment

124

newarrival

Character

3

0

N
Caption: New Arrival

125

special

Character

3

0

N
Caption: Special

126

number_bo

Numeric

6

0

N
Caption: Number Backordered

127

allow_bo

Character

1

0

N
Caption: Allow Backorders

128

addlotpk

Integer

4

0

N
Caption: PK in Invoices File (same as Lot_PK)

129

origlotpk

Integer

4

0

N
Caption: Original Lot_PK from Inventory

Total record size: 1651

Table: au!mailhist

# Field Name Type Len Dec Null

1

cust_no

Character

6

0

N
Caption: Cust No

2

mail_flag

Character

4

0

N
Caption: Mail Flag

3

add_date

Date

8

0

N
Caption: Add Date

Total record size: 19

Table: au!mailing

# Field Name Type Len Dec Null

1

mai_pk

Integer

4

0

N

2

cust_no

Character

6

0

N

3

salutation

Character

5

0

N

4

cust_lname

Character

30

0

N

Total record size: 46

Table: au!memoae

# Field Name Type Len Dec Null

1

mae_code

Character

5

0

N
Caption: Code

2

mae_text

Memo

4

0

N
Caption: Expanded text

3

mae_usrfk

Integer

4

0

N

Total record size: 14

Table: au!miscinv

# Field Name Type Len Dec Null

1

mis_pk

Integer

4

0

N

2

invoice

Character

6

0

N
Caption: Invoice No.

3

mis_invfk

Integer

4

0

N

4

sale_no

Character

5

0

N
Caption: Sale No.

5

lot_no

Character

6

0

N
Caption: Lot No.

6

qty

Numeric

5

0

N
Caption: Quantity

7

descrip

Character

150

0

N
Caption: Description

8

cust_no

Character

6

0

N
Caption: Customer No.

9

seq_num

Character

6

0

N
Caption: Sequence No.

10

consignor

Character

6

0

N
Caption: Consignor No.

11

realized

Numeric

11

2

N
Caption: Realized

12

est_weight

Numeric

6

1

N
Caption: Estimate Weight

13

percent

Numeric

4

0

N
Caption: Percent Discount

14

last_edit

Date

8

0

N
Caption: Last Edited

15

srtorder

Character

10

0

N
Caption: Catalog Number

16

cachet

Character

3

0

N
Caption: Cachet

17

operator

Character

10

0

N
Caption: Operator

18

last_time

Character

6

0

N
Caption: Last Time

Total record size: 257

Table: au!moreap

# Field Name Type Len Dec Null

1

api_pk

Integer

4

0

N
Caption: Primary Key

2

api_apfk

Integer

4

0

N
Caption: AP Foreign Key

3

cust_no

Character

6

0

N
Caption: Cust No.

4

api_confk

Integer

4

0

N
Caption: Consignor Foreign Key

5

sale_no

Character

5

0

N
Caption: Sale No.

6

api_salfk

Integer

4

0

N
Caption: Sale Foreign Key

7

amount_pd

Numeric

11

2

N
Caption: Amount Paid

8

date

Date

8

0

N
Caption: Date

9

note

Character

40

0

N
Caption: Note

10

type

Character

4

0

N
Caption: Type

11

sort

Character

2

0

N
Caption: Sort

12

ref_num

Character

10

0

N
Caption: Reference No.

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

16

check_no

Character

10

0

N
Caption: Check Number

17

checkcashed

Logical

1

0

N
Caption: Check Cashed

18

partialamt

Logical

1

0

N
Caption: Partial Amount

19

exported

Logical

1

0

N
Caption: Exported

Total record size: 140

Table: au!mxlot

# Field Name Type Len Dec Null

1

mxl_pk

Integer

4

0

N
Caption: Mixed Lot Primary Key

2

mxl_lotfk

Integer

4

0

N
Caption: Lot Foreign Key

3

page_no

Character

3

0

N
Caption: Page No

4

line_no

Character

3

0

N
Caption: Line No

5

mxl_winfk

Integer

4

0

N
Caption: Wine Foreign Key

6

mxl_grofk

Integer

4

0

N
Caption: Grower Foreign Key

7

vintage

Character

4

0

N
Caption: Vintage

8

bottles

Numeric

3

0

N
Caption: Bottles

9

mxl_sizfk

Integer

4

0

N
Caption: Bottle Size Foreign Key

10

mxl_size

Character

4

0

N
Caption: Bottle Size

11

act_liter

Numeric

6

1

N
Caption: Actual Literage

12

mxest_low

Numeric

12

2

N
Caption: Low Estimate

13

mxest_real

Numeric

12

2

N
Caption: High Estimate

14

mxreserve

Numeric

12

2

N
Caption: Reserve

15

case_no

Character

10

0

N
Caption: Case No

16

inv_loc

Character

15

0

N
Caption: Warehouse Location

17

mxref_num

Character

10

0

N
Caption: Client Ref. No

18

rec_date

Date

8

0

N
Caption: Receipt Date

19

ship_date

Date

8

0

N
Caption: Ship Date

20

tracking

Character

10

0

N
Caption: Tracking No

21

last_edit

Date

8

0

N
Caption: Last Edit

22

last_time

Character

6

0

N
Caption: Last Time

23

operator

Character

10

0

N
Caption: Operator

24

cas_code

Character

4

0

N
Caption: Case Type Code

25

mxl_casfk

Numeric

10

0

N
Caption: Case Type Foreign Key

26

vat_off

Character

4

0

N
Caption: VAT Status

27

whse

Character

6

0

N
Caption: WareHouse

28

mxl_note

Character

120

0

N
Caption: Short Note

29

condition

Memo

4

0

N
Caption: Condition

30

case_cond

Character

80

0

N
Caption: Case Condition

31

usegrower

Logical

1

0

N
Caption: Use Grower Note?

32

donotusetn

Logical

1

0

N
Caption: Do Not Use Tasting Note.

33

donotupdt

Logical

1

0

N
Caption: Do Not Update Price Table

34

mxretail

Numeric

12

2

N
Caption: Retail Price

35

number_lot

Numeric

6

0

N
Caption: Number of Lots

36

mxprice3

Numeric

12

4

N
Caption: Cost

37

mxest_cons

Numeric

11

2

N
Caption: Estimate to the Consignor

38

islbottle

Logical

1

0

N
Caption: ISL Bottled

Total record size: 438

Table: au!newcust

# Field Name Type Len Dec Null

1

new_pk

Integer

4

0

N

2

new_xxxfk

Integer

4

0

N

3

field_db

Character

8

0

N

4

field_name

Character

10

0

N

5

field_type

Character

1

0

N

6

field_len

Numeric

3

0

N

7

field_dec

Numeric

3

0

N

8

field_txt1

Character

80

0

N

9

field_txt2

Character

80

0

N

10

descrip

Character

30

0

N

11

context

Memo

4

0

N

12

help_scr

Numeric

2

0

N

13

help_numb

Numeric

2

0

N

Total record size: 232

Table: au!nextlot

# Field Name Type Len Dec Null

1

nex_pk

Integer

4

0

N

2

nex_xxxfk

Integer

4

0

N

3

seq_num

Character

7

0

N

4

cur_row

Numeric

2

0

N

5

cur_col

Numeric

2

0

N

6

invoice

Character

6

0

N

7

cust_no

Character

6

0

N

8

last_edit

Date

8

0

N

9

line_num

Character

6

0

N

10

sale_no

Character

5

0

N

11

salecode

Character

1

0

N

12

cleared

Logical

1

0

N

13

saledate

Character

15

0

N

14

descrip

Character

40

0

N

15

saletype

Character

1

0

N

16

cons_num

Character

4

0

N

17

active

Character

1

0

N

18

last_lotd

Date

8

0

N

19

last_lott

Character

6

0

N

20

uweb_date

Date

8

0

N

21

uweb_time

Character

6

0

N

22

iweb_date

Date

8

0

N

23

iweb_time

Character

6

0

N

24

sal_pk

Integer

4

0

N
Caption: Sal Pk

25

check_no

Character

6

0

N
Caption: Next Check Number

26

stk_sale

Character

5

0

N
Caption: Sale where Stock is Kept

27

srv_sale

Character

5

0

N
Caption: Sale where Services are Kept

28

curr_misc

Character

5

0

N
Caption: Sale where Sales of Stock and Services are Kept

29

po_sale

Character

5

0

N
Caption: Purchase Order Sale

30

rel_numb

Character

6

0

N
Caption: Last Release Number

31

prop_numb

Character

6

0

N
Caption: Prop Numb

32

curr_misc2

Character

5

0

N
Caption: Curr Misc2

33

retail_no

Character

6

0

N
Caption: Retail No

Total record size: 209

Table: au!outbid

# Field Name Type Len Dec Null

1

out_pk

Integer

4

0

N
Caption: Primary Key

2

out_xxxfk

Integer

4

0

N

3

sale_no

Character

5

0

N
Caption: Sale No.

4

cust_no

Character

6

0

N
Caption: Cust No.

5

lot_no

Character

5

0

N
Caption: Lot No.

Total record size: 25

Table: au!paddle

# Field Name Type Len Dec Null

1

pad_pk

Integer

4

0

N
Caption: Paddle primary key

2

cust_no

Character

6

0

N
Caption: Cust No.

3

pad_cusfk

Integer

4

0

N
Caption: Customer foreign key

4

sale_no

Character

5

0

N
Caption: Sale No.

5

pad_salfk

Integer

4

0

N
Caption: Sale Foreign Key

6

pad_salbfk

Integer

4

0

N
Caption: Salebid foreign key

7

paddle

Character

4

0

N
Caption: Paddle No.

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

Total record size: 56

Table: au!pbcalls

# Field Name Type Len Dec Null

1

pbc_pk

Integer

4

0

N

2

pbc_xxxfk

Integer

4

0

N

3

sale_no

Character

5

0

N

4

calls

Numeric

10

0

N

5

startbids

Numeric

10

0

N

6

bids

Numeric

10

0

N

Total record size: 44

Table: au!pbfailed

# Field Name Type Len Dec Null

1

pbf_pk

Integer

4

0

N

2

pbf_xxxfk

Integer

4

0

N

3

cust_no

Character

6

0

N

4

zip

Character

10

0

N

5

date

Date

8

0

N

6

time

Character

8

0

N

7

added

Character

1

0

N

Total record size: 42

Table: au!pfexport

# Field Name Type Len Dec Null

1

pfe_pk

Integer

4

0

N
Caption: Pfe Pk

2

date_appl

Date

8

0

N
Caption: Date Appl

3

subtype

Character

2

0

N
Caption: Subtype

4

typedby

Character

12

0

N
Caption: Typedby

5

priority

Logical

1

0

N
Caption: Priority

6

pfe_coufk

Integer

4

0

N
Caption: Pfe Coufk

7

country

Character

25

0

N
Caption: Country

8

catalog_no

Character

20

0

N
Caption: Catalog No

9

issued

Character

4

0

N
Caption: Issued

10

denom

Character

15

0

N
Caption: Denom

11

appcolor

Character

35

0

N
Caption: Appcolor

12

appdescrip

Memo

4

0

N
Caption: Appdescrip

13

subvalue

Numeric

11

2

N
Caption: Subvalue

14

reconsider

Character

1

0

N
Caption: Reconsider

15

pickup

Logical

1

0

N
Caption: Pickup

16

firm_id

Character

2

0

N
Caption: Firm Id

17

sale_no

Character

5

0

N
Caption: Sale No

18

lot_no

Character

5

0

N
Caption: Lot No

19

seq_num

Character

7

0

N
Caption: Seq Num

20

app_lotfk

Integer

4

0

N
Caption: App Lotfk

21

cust_no

Character

6

0

N
Caption: Cust No

22

invoice

Character

6

0

N
Caption: Customer Invoice No.

23

pfe_cusfk

Integer

4

0

N
Caption: Pfe Cusfk

24

lot_descr

Memo

4

0

N
Caption: Lot Descr

25

symbol

Character

2

0

N
Caption: Symbol

26

prev_no

Character

7

0

N
Caption: Prev No

27

othername

Character

40

0

N
Caption: Othername

28

imagefile

Character

50

0

N
Caption: Imagefile

29

appl_no

Character

7

0

N
Caption: Appl No

30

feevalue

Numeric

11

2

N
Caption: Feevalue

31

finalfee

Numeric

7

2

N
Caption: Finalfee

32

final

Memo

4

0

N
Caption: Final

33

issuedate

Date

8

0

N
Caption: Issuedate

34

invoiceno

Character

7

0

N
Caption: Invoiceno

35

last_edit

Date

8

0

N
Caption: Last Edit

36

last_time

Character

6

0

N
Caption: Last Time

37

operator

Character

10

0

N
Caption: Operator

38

catalog

Character

20

0

N
Caption: Catalog

39

buyer

Character

40

0

N
Caption: Buyer

40

seller

Character

40

0

N
Caption: Seller

41

use_other

Logical

1

0

N
Caption: Use Other

42

graded

Logical

1

0

N
Caption: Graded

43

mingrade

Numeric

3

0

N
Caption: Minimum Grade

44

grade

Numeric

3

0

N
Caption: Grade

45

gradechar

Character

15

0

N
Caption: Grade Text

46

gradenote

Character

10

0

N
Caption: Gradenote

47

remarks

Character

50

0

N
Caption: Remarks

48

returndate

Date

8

0

N
Caption: Date Return

49

buyerdate

Date

8

0

N
Caption: Buyerdate

50

consdate

Date

8

0

N
Caption: Consdate

Total record size: 565

Table: au!phonebid

# Field Name Type Len Dec Null

1

pho_pk

Integer

4

0

N

2

pho_xxxfk

Integer

4

0

N

3

sale_no

Character

5

0

N

4

lot_no

Character

4

0

N

5

dummy

Character

1

0

N

6

cust_no

Character

6

0

N

7

amount

Numeric

11

2

N

8

pr_type

Character

1

0

N

Total record size: 37

Table: au!phrases

# Field Name Type Len Dec Null

1

phr_pk

Integer

4

0

N

2

code

Character

20

0

N
Caption: Code

3

allowtxt

Logical

1

0

N
Caption: Allow Textbox Insert

4

txtphrase

Character

40

0

N
Caption: Phrase for textbox

5

allowedt

Logical

1

0

N
Caption: Allow Memo field Insertion

6

edtphrase

Memo

4

0

N
Caption: Phrase for Memo field

7

hotkey

Character

20

0

N
Caption: Hot key assignment

8

autotype

Character

20

0

N
Caption: Spell Check Autotype

Total record size: 111

Table: au!postview

# Field Name Type Len Dec Null

1

pos_pk

Integer

4

0

N

2

sale_no

Character

5

0

N
Caption: Sale No.

3

lot_no

Character

5

0

N
Caption: Lot No.

4

pos_lotfk

Integer

4

0

N
Caption: Lot Foreign Key

5

cust_no

Character

6

0

N
Caption: Cust No.

6

pos_cusfk

Integer

4

0

N
Caption: Customer Foeign Key

7

invoice

Character

6

0

N
Caption: Invoice

8

pos_invfk

Integer

4

0

N
Caption: Invoice Foreign Key

9

date_out

Date

8

0

N
Caption: Date Out

10

date_in

Date

8

0

N
Caption: Date In

Total record size: 55

Table: au!profiles

# Field Name Type Len Dec Null

1

pro_pk

Integer

4

0

N

2

pro_xxxfk

Integer

4

0

N

3

sale_no

Character

5

0

N

4

pre_sale

Memo

4

0

N

5

post_sale

Memo

4

0

N

6

descrip

Character

65

0

N

7

date

Date

8

0

N

8

title1

Character

50

0

N

9

bill1

Character

50

0

N

10

bill2

Character

50

0

N

11

bill3

Character

50

0

N

12

bill4

Character

50

0

N

13

phone

Character

20

0

N

14

fax

Character

20

0

N

15

s_email

Character

50

0

N

16

s_webpage

Character

120

0

N

17

version

Character

8

0

N

18

slot1

Character

5

0

N

19

slot2

Character

5

0

N

20

slot3

Character

5

0

N

21

slot4

Character

5

0

N

22

slot5

Character

5

0

N

23

slot6

Character

5

0

N

24

elot1

Character

5

0

N

25

elot2

Character

5

0

N

26

elot3

Character

5

0

N

27

elot4

Character

5

0

N

28

elot5

Character

5

0

N

29

elot6

Character

5

0

N

30

cl_date1

Date

8

0

N

31

cl_date2

Date

8

0

N

32

cl_date3

Date

8

0

N

33

cl_date4

Date

8

0

N

34

cl_date5

Date

8

0

N

35

cl_date6

Date

8

0

N

36

cl_time1

Character

8

0

N

37

cl_time2

Character

8

0

N

38

cl_time3

Character

8

0

N

39

cl_time4

Character

8

0

N

40

cl_time5

Character

8

0

N

41

cl_time6

Character

8

0

N

42

spread1

Numeric

3

0

N

43

spread2

Numeric

3

0

N

44

spread3

Numeric

3

0

N

45

spread4

Numeric

3

0

N

46

spread5

Numeric

3

0

N

47

spread6

Numeric

3

0

N

Total record size: 737

Table: au!profit

# Field Name Type Len Dec Null

1

pro_pk

Integer

4

0

N

2

pro_xxxfk

Integer

4

0

N

3

range

Numeric

7

0

N

4

numlots

Numeric

6

0

N

5

totalest

Numeric

8

0

N

6

aveest

Numeric

11

2

N

7

lotssold

Numeric

6

0

N

8

totalpr

Numeric

8

0

N

9

avepr

Numeric

11

2

N

10

totalfees

Numeric

8

0

N

11

avefees

Numeric

11

2

N

Total record size: 85

Table: au!prtype

# Field Name Type Len Dec Null

1

prtype

Character

1

0

N
Caption: Prtype

2

prdesc

Character

20

0

N
Caption: Description

Total record size: 22

Table: au!qrystore

# Field Name Type Len Dec Null

1

qry_pk

Integer

4

0

N
Caption: Text Storage Primary Key

2

qrydescrip

Character

75

0

N
Caption: Description of Text

3

sqlquery

Memo

4

0

N
Caption: Contents

Total record size: 84

Table: au!readme

# Field Name Type Len Dec Null

1

rea_pk

Integer

4

0

N
Caption: Rea Pk

2

descrip

Character

120

0

N
Caption: Descrip

3

readme

Memo

4

0

N
Caption: Readme

Total record size: 129

Table: au!release

# Field Name Type Len Dec Null

1

rel_pk

Integer

4

0

N
Caption: Rel Pk

2

code

Character

3

0

N
Caption: Code

3

descrip

Character

60

0

N
Caption: Description

4

prtext

Memo

4

0

N
Caption: Text

5

prout

Memo

4

0

N

6

margin

Numeric

3

0

N

7

width

Numeric

3

0

N

8

type

Character

10

0

N
Caption: Type of Document

9

template

Character

30

0

N
Caption: Template for Document

10

user

Character

8

0

N
Caption: User ID

Total record size: 130

Table: au!reportcatalog

# Field Name Type Len Dec Null

1

rep_pk

Integer

4

0

N
Caption: Primary Key
Default: x3genpk("REPORTCATALOG","AU")

2

rep_name

Character

80

0

N
Caption: Name

3

rep_description

Memo

4

0

N
Caption: Description

4

rep_frx

Character

25

0

N
Caption: .FRX Filename
Comments: Required if EMPTY(Rep_Class) and EMPTY(Rep_Dialog), optional otherwise, specifies the name of the .FRX to be run

5

rep_class

Character

100

0

N
Caption: Class
Comments: Required if EMPTY(Rep_FRX) and EMPTY(Rep_Dialog), ignored if !EMPTY(Rep_Dialog), specifies [ClassName,VCXFile] of a report object inheriting from XXFWMISC.VCX/frmReport

6

rep_type

Character

1

0

N
Caption: Type
Comments: "R"eport or "L"abel or any character you want, to provide a filter for XXFWFRM.VCX/frmReportCatalog

7

rep_dialog

Character

100

0

N
Caption: Dialog
Comments: Required if EMPTY(Rep_Class) and EMPTY(Rep_FRX), if set takes precedence over Rep_Class and specifies an .SCX or [ClassName,VCXFile] dialog that ultimately runs a frmReport object

Total record size: 315

Table: au!returns

# Field Name Type Len Dec Null

1

ret_pk

Integer

4

0

N

2

sale_no

Character

5

0

N
Caption: Sale No.

3

lot_no

Character

5

0

N
Caption: Lot No.

4

ret_lotfk

Integer

4

0

N
Caption: Lot Foreign Key

5

cust_no

Character

6

0

N
Caption: Cust No.

6

seq_num

Character

7

0

N
Caption: Inventory No.

7

realized

Numeric

11

2

N
Caption: Realized

8

invoice

Character

6

0

N
Caption: Invoice No.

9

date_sold

Date

8

0

N
Caption: Date Sold

10

bidder_fee

Numeric

6

3

N
Caption: Bidder Fee

11

freight

Numeric

9

2

N
Caption: Freight

12

cons_misc

Numeric

10

2

N
Caption: Cert Fee

13

last_edit

Date

8

0

N
Caption: Last Edit

14

last_time

Character

5

0

N
Caption: Last Time

15

operator

Character

10

0

N
Caption: Operator

16

posted

Logical

1

0

N
Caption: Posted

17

reason

Character

80

0

N
Caption: Reason

18

cert

Character

1

0

N
Caption: Certificate

19

date_ret

Date

8

0

N
Caption: Date Ret

20

consignor

Character

6

0

N
Caption: Consignor

21

number_lot

Numeric

6

0

N
Caption: Number Lot

Total record size: 207

Table: au!salebids

# Field Name Type Len Dec Null

1

salb_pk

Integer

4

0

N

2

cust_no

Character

6

0

N
Caption: Cust No.

3

salb_cusfk

Integer

4

0

N
Caption: Customer foreign key

4

sale_no

Character

5

0

N
Caption: Sale No.

5

salb_salfk

Integer

4

0

N
Caption: Sale Foreign Key

6

max_bid

Numeric

8

0

N
Caption: Limit Bids to

7

incr_by

Numeric

3

0

N
Caption: Increase Bids By

8

cred_no

Character

20

0

N
Caption: Credit Card No.

9

cred_name

Character

20

0

N
Caption: Name on Credit Card

10

cred_init

Character

5

0

N
Caption: CC Init Date

11

cred_exp

Character

5

0

N
Caption: Expiration Date

12

cred_type

Character

5

0

N
Caption: Card Type

13

cred_limit

Numeric

7

0

N
Caption: Credit Limit

14

hand_fee

Numeric

11

2

N
Caption: Freight

15

ttl_weight

Numeric

11

2

N
Caption: Total Weight

16

total_real

Numeric

11

2

N
Caption: Realized

17

terms

Character

1

0

N
Caption: Terms

18

ship_via

Character

30

0

N
Caption: Ship Via

19

break_tie

Logical

1

0

N
Caption: Break Tie?

20

incr_bid

Logical

1

0

N
Caption: Increment Bid?

21

numb_incr

Numeric

1

0

N
Caption: Number of Increments

22

date_rcvd

Date

8

0

N
Caption: Date Rcvd

23

time_rcvd

Character

6

0

N
Caption: Time Bids Received

24

last_edit

Date

8

0

N
Caption: Last Edit

25

last_time

Character

5

0

N
Caption: Last Time

26

operator

Character

10

0

N
Caption: Operator

27

lots_won

Integer

4

0

N
Caption: Lots Won

28

outside

Logical

1

0

N
Caption: Take Outside the VAT Scheme

29

takeasib

Logical

1

0

N
Caption: Take IBDPA as IB (In Bond)

30

zerorated

Logical

1

0

N
Caption: Zero Rated

31

shipspec

Character

20

0

N
Caption: Special Shipping Instructions

32

language

Character

20

0

N
Caption: Language Spoken

33

specflag

Logical

1

0

N
Caption: Special Flag for Invoices

34

id_checked

Logical

1

0

N
Caption: Id Checked

35

phone_note

Memo

4

0

N
Caption: Phone Bid Notes

36

approved

Character

3

0

N
Caption: Approved to Bid

37

bidsheet

Numeric

6

0

N
Caption: Bidsheet Id

Total record size: 263

Table: au!sales

# Field Name Type Len Dec Null

1

sal_pk

Integer

4

0

N

2

sale_no

Character

5

0

N
Caption: Sale No.
Validation Rule: proclist(sale_no)

3

salecode

Character

1

0

N
Caption: 1 Char Code for Sale (eBAY)

4

cleared

Logical

1

0

N
Caption: Sale has been Cleared

5

omitinpb

Logical

1

0

N
Caption: Omit in Property Distribution Unsold Summary

6

omitinpbu

Logical

1

0

N
Caption: Omit in Property Distribution Unsolds

7

saledate

Character

25

0

N
Caption: Text Description of Sale Date

8

saletype

Character

1

0

N
Caption: Public or Mail

9

descrip

Character

65

0

N
Caption: Sale Description

10

active

Character

1

0

N
Caption: Active

11

pre_sale

Memo

4

0

N
Caption: Pre Sale Paragraph Description of Sale

12

post_sale

Memo

4

0

N
Caption: Post Sale Prices Realized Description

13

date

Date

8

0

N
Caption: Start Date of Sale

14

date2

Date

8

0

N
Caption: Ending Date of Sale

15

date_settle

Date

8

0

N
Caption: Settlement Date

16

title1

Character

50

0

N
Caption: (internal use only)

17

bill1

Character

50

0

N
Caption: (internal use only)

18

bill2

Character

50

0

N
Caption: (internal use only)

19

bill3

Character

50

0

N
Caption: (internal use only)

20

bill4

Character

50

0

N
Caption: (internal use only)

21

phone

Character

20

0

N
Caption: (internal use only)

22

fax

Character

20

0

N
Caption: (internal use only)

23

s_email

Character

50

0

N
Caption: eMail

24

s_webpage

Character

120

0

N
Caption: Web Page

25

version

Character

8

0

N
Caption: Version

26

slot1

Character

5

0

N
Caption: Session Lot From

27

slot2

Character

5

0

N
Caption: Session Lot From

28

slot3

Character

5

0

N
Caption: Session Lot From

29

slot4

Character

5

0

N
Caption: Session Lot From

30

slot5

Character

5

0

N
Caption: Session Lot From

31

slot6

Character

5

0

N
Caption: Session Lot From

32

elot1

Character

5

0

N
Caption: Session Lot to

33

elot2

Character

5

0

N
Caption: Session Lot to

34

elot3

Character

5

0

N
Caption: Session Lot to

35

elot4

Character

5

0

N
Caption: Session Lot to

36

elot5

Character

5

0

N
Caption: Session Lot to

37

elot6

Character

5

0

N
Caption: Session Lot to

38

cl_date1

Date

8

0

N
Caption: Session Close Date

39

cl_date2

Date

8

0

N
Caption: Session Close Date

40

cl_date3

Date

8

0

N
Caption: Session Close Date

41

cl_date4

Date

8

0

N
Caption: Session Close Date

42

cl_date5

Date

8

0

N
Caption: Session Close Date

43

cl_date6

Date

8

0

N
Caption: Session Close Date

44

cl_time1

Character

8

0

N
Caption: Session Close Time

45

cl_time2

Character

8

0

N
Caption: Session Close Time

46

cl_time3

Character

8

0

N
Caption: Session Close Time

47

cl_time4

Character

8

0

N
Caption: Session Close Time

48

cl_time5

Character

8

0

N
Caption: Session Close Time

49

cl_time6

Character

8

0

N
Caption: Session Close Time

50

spread1

Numeric

3

0

N
Caption: Spread Time

51

spread2

Numeric

3

0

N
Caption: Spread Time

52

spread3

Numeric

3

0

N
Caption: Spread Time

53

spread4

Numeric

3

0

N
Caption: Spread Time

54

spread5

Numeric

3

0

N
Caption: Spread Time

55

spread6

Numeric

3

0

N
Caption: Spread Time

56

operator

Character

10

0

N
Caption: Operator

57

last_edit

Date

8

0

N
Caption: Last Edit

58

last_time

Character

6

0

N
Caption: Last Time

59

room

Character

20

0

N
Caption: Room

60

location

Character

50

0

N
Caption: Location

61

viewing

Character

50

0

N
Caption: Viewing

62

buyperc

Numeric

7

4

N
Caption: Buyer's Premium

63

taxstate

Character

3

0

N
Caption: Tax State

64

staxrate

Numeric

7

4

N
Caption: Sales Tax Rate

65

staxzip

Character

5

0

N
Caption: Sales Tax Zipcode

66

staxmethod

Character

1

0

N
Caption: Sales Tax Method (1=System State Only, 2=State Tax Table, 3=Zip Tax Table)

67

staxcity

Character

25

0

N
Caption: Staxcity

68

converted

Character

1

0

N
Caption: Converted

69

simage_dir

Character

40

0

N
Caption: Image Directory (If not System)

70

simage_typ

Character

3

0

N
Caption: Image Type

71

simage_nam

Character

1

0

N
Caption: Sequence No. or Lot No.

72

ins_percb

Numeric

6

2

N
Caption: Buyer Insurance Percentage

73

cat_cost

Numeric

10

2

N
Caption: Catalog Cost

74

mail_cost

Numeric

10

2

N
Caption: Mailing Cost

75

prntqty

Numeric

6

0

N
Caption: Print Quantity

76

mailqty

Numeric

6

0

N
Caption: Mailing Quantity

77

dformat

Character

2

0

N
Caption: Division

78

exporttype

Character

1

0

N
Caption: Export to Database Type

79

inventory

Logical

1

0

N
Caption: Inventory

80

notinvent

Logical

1

0

N
Caption: Notinvent

Total record size: 1060

Table: au!securityaccess

# Field Name Type Len Dec Null

1

acc_pk

Integer

4

0

N
Caption: Primary Key
Default: x3genpk("SECURITYACCESS","AU")

2

acc_ugrfk

Integer

4

0

N
Caption: Group
Validation Rule: IIF(_triggerlevel>0,.T.,x3seek("AU",acc_ugrfk,"USERGROUPS","UGr_PK",.T.)).OR.IIF(_triggerlevel>0,.T.,x3seek("AU",acc_ugrfk,"USERGROUPS","UGr_PK"))
Validation Text: xxfwruleerrortext("FR_Acc_UGrFK","The Group you have entered is not on file in the UserGroups reference file")

3

acc_sitfk

Integer

4

0

N
Caption: Secured Item
Validation Rule: IIF(_triggerlevel>0,.T.,x3seek("",acc_sitfk,"SECUREDITEMS","SIt_PK"))
Validation Text: xxfwruleerrortext("FR_Acc_SItFK","Either the SecuredItem you have entered is not on file in the SecuredItems reference file, or the SecuredItems table is unavailable")

4

acc_access

Numeric

1

0

N
Caption: Access
Comments: Indicates the level of access for this group+secured item: 1=Full 8=Readonly 9=None
Default: 1
Validation Rule: INLIST(acc_access,1,8,9)
Validation Text: xxfwruleerrortext("FR_Acc_Access","The Access code you have entered is invalid")

Total record size: 14

Table: au!shiphist

# Field Name Type Len Dec Null

1

shi_pk

Integer

4

0

N

2

shi_cusfk

Integer

4

0

N

3

shi_invfk

Integer

4

0

N
Caption: Shi Invfk

4

invoice

Character

6

0

N
Caption: Invoice No.

5

cust_no

Character

6

0

N
Caption: Cust No.

6

date

Date

8

0

N
Caption: Date

7

method

Character

40

0

N
Caption: Method

8

sale_no

Character

5

0

N
Caption: Sale No.

9

last_edit

Date

8

0

N
Caption: Last Edit

10

last_time

Character

6

0

N
Caption: Last Time

11

operator

Character

10

0

N
Caption: Operator

12

track_num

Character

25

0

N
Caption: Tracking No.

13

shi_salfk

Integer

4

0

N
Caption: Sale Foreign Key

14

case_no

Character

10

0

N
Caption: Case No

15

ship_value

Numeric

10

2

N
Caption: Value

16

ship_fee

Numeric

10

2

N
Caption: Ship Fee

17

postage

Numeric

8

2

N
Caption: Postage

18

prntlabels

Numeric

1

0

N
Caption: Prntlabels

19

ship_type

Character

1

0

N
Caption: Ship Type

Total record size: 171

Table: au!shipping

# Field Name Type Len Dec Null

1

shi_pk

Integer

4

0

N

2

carrier

Character

10

0

N
Caption: Carrier

3

weight

Numeric

4

0

N
Caption: Weight

4

zone1

Numeric

8

2

N
Caption: Zone1

5

zone2

Numeric

8

2

N
Caption: UPS Zone 2

6

zone3

Numeric

8

2

N
Caption: UPS Zone 3

7

zone4

Numeric

8

2

N
Caption: UPS Zone 4

8

zone5

Numeric

8

2

N
Caption: UPS Zone 5

9

zone6

Numeric

8

2

N
Caption: UPS Zone 6

10

zone7

Numeric

8

2

N
Caption: UPS Zone 7

11

zone8

Numeric

8

2

N
Caption: UPS Zone 8

12

operator

Character

10

0

N
Caption: Operator

13

last_edit

Date

8

0

N
Caption: Last Edit

14

last_time

Character

6

0

N
Caption: Last Time

15

min_fee

Numeric

8

2

N
Caption: Minimum Fee

16

max_fee

Numeric

8

2

N
Caption: Maximum Fee

17

spec_fee

Numeric

8

2

N
Caption: Special Fee

18

shipper

Character

6

0

N
Caption: Shipper

19

ins_perc

Numeric

7

4

N
Caption: Insurance Percentage

Total record size: 144

Table: au!size

# Field Name Type Len Dec Null

1

siz_pk

Integer

4

0

N
Caption: Bottle Size Primary Key

2

siz_code

Character

4

0

N
Caption: Bottle Size Code

3

siz_descr

Character

40

0

N
Caption: Bottle Size Description

4

literage

Numeric

9

1

N
Caption: Literage

5

siz_text

Character

20

0

N
Caption: Size Text

6

conv_factor

Numeric

8

2

N
Caption: Conversion Factor from Bottles

7

upercase

Numeric

3

0

N
Caption: Bottles per case

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

11

recdelete

Character

1

0

N
Caption: Delete

12

mergeto

Character

4

0

N
Caption: Mergeto

13

link_to

Character

7

0

N
Caption: Link To

Total record size: 125

Table: au!specinfo

# Field Name Type Len Dec Null

1

spe_pk

Integer

4

0

N
Caption: Primary Key

2

spec_info

Character

10

0

N
Caption: Code

3

descrip

Character

40

0

N
Caption: Description

4

s1

Character

1

0

N

5

s2

Character

1

0

N

6

operator

Character

10

0

N

7

last_edit

Date

8

0

N

8

last_time

Character

6

0

N

Total record size: 81

Table: au!stamps

# Field Name Type Len Dec Null

1

sta_pk

Integer

4

0

N

2

category

Character

8

0

N
Caption: Category

3

sta_catfk

Integer

4

0

N
Caption: Category Foreign Key

4

srtorder

Character

40

0

N
Caption: Catalog Number

5

descrip

Character

250

0

N
Caption: Description

6

year

Character

4

0

N
Caption: Year

7

scottnum

Character

30

0

N
Caption: Scott No.

8

gibbons

Character

30

0

N
Caption: Gibbons

9

topics

Character

80

0

N
Caption: Topics

10

last_edit

Date

8

0

N
Caption: Last Edit

11

value0

Numeric

8

2

N
Caption: Value

12

value1

Numeric

8

2

N
Caption: Value

13

value2

Numeric

8

2

N
Caption: Value

14

value3

Numeric

8

2

N
Caption: Value

15

value4

Numeric

8

2

N
Caption: Value

16

value5

Numeric

8

2

N
Caption: Value

17

value6

Numeric

8

2

N
Caption: Value

18

value7

Numeric

8

2

N
Caption: Value

19

value8

Numeric

8

2

N
Caption: Value

20

value9

Numeric

8

2

N
Caption: Value

21

value10

Numeric

8

2

N
Caption: Value10

22

value11

Numeric

8

2

N
Caption: Value11

23

loc0

Character

5

0

N
Caption: Location

24

loc1

Character

5

0

N
Caption: Location

25

loc2

Character

5

0

N
Caption: Location

26

loc3

Character

5

0

N
Caption: Location

27

loc4

Character

5

0

N
Caption: Location

28

loc5

Character

5

0

N
Caption: Location

29

loc6

Character

5

0

N
Caption: Location

30

loc7

Character

5

0

N
Caption: Location

31

loc8

Character

5

0

N
Caption: Location

32

loc9

Character

5

0

N
Caption: Location

33

loc10

Character

5

0

N
Caption: Loc10

34

loc11

Character

5

0

N
Caption: Loc11

35

qty0

Numeric

5

0

N
Caption: Quantity

36

qty1

Numeric

5

0

N
Caption: Quantity

37

qty2

Numeric

5

0

N
Caption: Quantity

38

qty3

Numeric

5

0

N
Caption: Quantity

39

qty4

Numeric

5

0

N
Caption: Quantity

40

qty5

Numeric

5

0

N
Caption: Quantity

41

qty6

Numeric

5

0

N
Caption: Quantity

42

qty7

Numeric

5

0

N
Caption: Quantity

43

qty8

Numeric

5

0

N
Caption: Quantity

44

qty9

Numeric

5

0

N
Caption: Quantity

45

qty10

Numeric

5

0

N
Caption: Qty10

46

qty11

Numeric

11

0

N
Caption: Qty11

47

notes0

Character

10

0

N
Caption: Notes

48

notes1

Character

10

0

N
Caption: Notes

49

notes2

Character

10

0

N
Caption: Notes

50

notes3

Character

10

0

N
Caption: Notes

51

notes4

Character

10

0

N
Caption: Notes

52

notes5

Character

10

0

N
Caption: Notes

53

notes6

Character

10

0

N
Caption: Notes

54

notes7

Character

10

0

N
Caption: Notes

55

notes8

Character

10

0

N
Caption: Notes

56

notes9

Character

10

0

N
Caption: Notes

57

notes10

Character

10

0

N
Caption: Notes10

58

notes11

Character

10

0

N
Caption: Notes11

59

notes

Memo

4

0

N
Caption: Notes

60

fdccities

Numeric

3

0

N
Caption: FDC Cities

61

operator

Character

10

0

N
Caption: Operator

62

last_time

Character

6

0

N
Caption: Last Time

63

perc0

Numeric

4

0

N
Caption: Perc0

64

perc1

Numeric

4

0

N
Caption: Perc1

65

perc2

Numeric

4

0

N
Caption: Perc2

66

perc3

Numeric

4

0

N
Caption: Perc3

67

perc4

Numeric

4

0

N
Caption: Perc4

68

perc5

Numeric

5

0

N
Caption: Perc5

69

perc6

Numeric

4

0

N
Caption: Perc6

70

perc7

Numeric

4

0

N
Caption: Perc7

71

perc8

Numeric

4

0

N
Caption: Perc8

72

perc9

Numeric

4

0

N
Caption: Perc9

73

perc10

Numeric

4

0

N
Caption: Perc10

74

perc11

Numeric

4

0

N
Caption: Perc11

75

mint_add

Character

250

0

N
Caption: Mint Add

76

used_add

Character

250

0

N
Caption: Used Add

77

full_text

Memo

4

0

N
Caption: Full Text

78

shortdesc

Character

100

0

N
Caption: Shortdesc

79

variant

Character

1

0

N
Caption: Variant

80

refcopy

Character

10

0

N
Caption: Refcopy

81

stocked

Character

1

0

N
Caption: Stocked

82

setcont

Character

150

0

N
Caption: Set

Total record size: 1639

Table: au!state

# Field Name Type Len Dec Null

1

sta_pk

Integer

4

0

N

2

st_ab

Character

3

0

N
Caption: State Abbrev.

3

st_name

Character

25

0

N
Caption: State Name

4

st_type

Character

1

0

N
Caption: State or County

5

tax_rate

Numeric

6

3

N
Caption: Tax Rate

6

taxable

Character

1

0

N
Caption: Taxable

7

post_code

Character

10

0

N

8

eff_date

Date

8

0

N
Caption: Eff Date

9

operator

Character

10

0

N
Caption: Operator

10

last_edit

Date

8

0

N
Caption: Last Edit

11

last_time

Character

6

0

N
Caption: Last Time

Total record size: 83

Table: au!tasting

# Field Name Type Len Dec Null

1

tas_pk

Integer

4

0

N
Caption: Tasting Primary Key

2

tas_winfk

Integer

4

0

N
Caption: Wine Foreign Key

3

tas_grofk

Integer

4

0

N
Caption: Grower Foreign Key

4

vintage

Character

4

0

N
Caption: Vintage

5

note

Memo

4

0

N
Caption: Tasting Note

6

last_edit

Date

8

0

N
Caption: Last Edit

7

last_time

Character

6

0

N
Caption: Last Time

8

operator

Character

20

0

N
Caption: Operator

9

date_note

Date

8

0

N
Caption: Date of Note

10

note_by

Character

5

0

N
Caption: Note By

11

rating

Numeric

6

2

N
Caption: Rating

12

drink_from

Character

6

0

N
Caption: Drink From

13

drink_to

Character

6

0

N
Caption: Drink To

14

perf_with

Character

40

0

N
Caption: Perfect With

15

reference

Memo

4

0

N
Caption: Reference Note

16

ratingtxt

Character

10

0

N
Caption: Rating Text

17

shortnote

Character

150

0

N
Caption: Short Note

18

production

Memo

4

0

N
Caption: Production Note

19

longnote

Memo

4

0

N
Caption: Longnote

Total record size: 298

Table: au!taxtbl

# Field Name Type Len Dec Null

1

tax_pk

Numeric

8

0

N
Caption: Primary Key

2

zip1

Character

8

0

N
Caption: Starting Zip Range

3

city

Character

28

0

N
Caption: City

4

county

Character

25

0

N
Caption: County

5

state

Character

19

0

N
Caption: State Name

6

zip2

Character

5

0

N
Caption: Ending Zip Range

7

tax_rate

Numeric

7

4

N
Caption: Tax Rate (Total)

8

tax_gst

Numeric

7

4

N
Caption: Tax Gst

9

last_edit

Date

8

0

N
Caption: Last Edit

10

last_time

Character

6

0

N
Caption: Last Time

11

operator

Character

10

0

N
Caption: Operator

12

tax_state

Numeric

7

4

N
Caption: State Component

13

tax_county

Numeric

7

4

N
Caption: County Component

14

tax_city

Numeric

7

4

N
Caption: City Component

Total record size: 153

Table: au!tranxtn

# Field Name Type Len Dec Null

1

trx_pk

Integer

4

0

N
Caption: Primary Key

2

cust_no

Character

6

0

N
Caption: Cust No.

3

trx_cusfk

Integer

4

0

N
Caption: Consignor or Customer Foreign Key

4

invoice

Character

6

0

N
Caption: Invoice

5

trx_invfk

Integer

4

0

N
Caption: Invoice Foreign Key

6

trx_apfk

Integer

4

0

N
Caption: AP Foreign Key

7

sale_no

Character

5

0

N
Caption: Sale No.

8

trx_salfk

Integer

4

0

N
Caption: Sale Foreign Key

9

trx_amount

Numeric

11

2

N
Caption: Amount Paid

10

trx_date

Date

8

0

N
Caption: Date

11

trx_ref

Character

20

0

N
Caption: Reference No.

12

trx_type

Character

12

0

N
Caption: Trx Type

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

16

sort_code

Character

3

0

N
Caption: Sort Code

17

exported

Logical

1

0

N
Caption: Exported

Total record size: 117

Table: au!txtstore

# Field Name Type Len Dec Null

1

txt_pk

Integer

4

0

N
Caption: Text Storage Primary Key

2

txt_code

Character

30

0

N
Caption: Text File Message Code

3

txtdescrip

Character

75

0

N
Caption: Description of Text

4

textfile

Memo

4

0

N
Caption: Contents

5

dformat

Character

2

0

N
Caption: Division Code

Total record size: 116

Table: au!upszone

# Field Name Type Len Dec Null

1

ups_pk

Integer

4

0

N
Caption: Shipping Zones Primary Key

2

zip1

Character

5

0

N

3

zip2

Character

5

0

N

4

zone

Character

2

0

N

5

last_time

Character

6

0

N
Caption: Last Time

6

last_edit

Date

8

0

N
Caption: Last Edit

7

operator

Character

10

0

N
Caption: Operator

8

allowship

Character

1

0

N
Caption: Shipping is Allowed to this Zip Code Range

9

ucarrier

Character

10

0

N
Caption: Suggested Shipping Method

Total record size: 52

Table: au!useraccexceptions

# Field Name Type Len Dec Null

1

uae_pk

Integer

4

0

N
Caption: Primary Key
Default: x3genpk("USERACCEXCEPTIONS","AU")

2

uae_usrfk

Integer

4

0

N
Caption: User
Validation Rule: IIF(_triggerlevel>0,.T.,x3seek("AU",uae_usrfk,"USERS","Usr_PK",.T.))
Validation Text: xxfwruleerrortext("FR_UAE_USrFK","The User you have entered is not on file in the Users reference file")

3

uae_sitfk

Integer

4

0

N
Caption: Secured Item
Validation Rule: IIF(_triggerlevel>0,.T.,x3seek("",uae_sitfk,"SECUREDITEMS","SIt_PK"))
Validation Text: xxfwruleerrortext("FR_Acc_SItFK","Either the SecuredItem you have entered is not on file in the SecuredItems reference file, or the SecuredItems table is unavailable")

4

uae_access

Numeric

1

0

N
Caption: Access
Comments: Indicates the level of access for this user+secured item: 1=Full 8=Readonly 9=None
Default: 9
Validation Rule: INLIST(uae_access,1,8,9)
Validation Text: xxfwruleerrortext("FR_Acc_Access","The Access code you have entered is invalid")

Total record size: 14

Table: au!usergroups

# Field Name Type Len Dec Null

1

ugr_pk

Integer

4

0

N
Caption: Primary Key
Default: x3genpk("USERGROUPS","AU")

2

ugr_group

Character

20

0

N
Caption: Group

3

ugr_description

Character

60

0

N
Caption: Description

4

ugr_system

Character

1

0

N
Caption: System
Comments: Set to "Y", indicates that this user is a 'hidden' group, and does not show up on any form/control interfaces
Default: "N"
Validation Rule: INLIST(ugr_system,"Y","N")
Validation Text: xxfwruleerrortext("FR_UGr_System",'System indicator must be "Y"es or "N"o')

5

ugr_type

Character

1

0

N
Caption: Master Group Type

Total record size: 87

Table: au!userprefs

# Field Name Type Len Dec Null

1

prf_usrfk

Integer

4

0

N
Comments: Foreign key to the USERS table

2

prf_item

Character

115

0

N
Comments: Preference item

3

prf_itemdatatype

Character

1

0

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

4

prf_itemvalue

Character

254

0

Y
Comments: Prf_Item value

5

prf_itemdescription

Character

254

0

N
Comments: Description of Prf_Item

6

prf_designedvalue

Character

254

0

Y

Total record size: 883

Table: au!users

# Field Name Type Len Dec Null

1

usr_pk

Integer

4

0

N
Caption: Primary Key
Comments: System-generated Primary Key
Default: x3genpk("USERS","AU")

2

usr_lanid

Character

10

0

N
Caption: UserName
Comments: User's UserName/ID (login UserID)

3

usr_password

Character

8

0

N
Caption: Password
Comments: User's Password
Default: x3ed("E",PADR("PASSWORD",8))
Validation Rule: x3ed("D",usr_password)#usr_lanid.AND..NOT.SPACE(1)$ALLTRIM(x3ed("D",usr_password)).AND..NOT.EMPTY(CHRTRANC(ALLTRIM(x3ed("D",usr_password)),LEFTC(x3ed("D",usr_password),1),SPACE(0)))
Validation Text: xxfwruleerrortext("FR_Usr_Password","Password may not: 1) be the same as UserName/UserID; 2) contain embedded spaces/blanks; 3) consist of all the same character/number. The Password you have entered violates one or more of these rules.")

4

usr_rights

Numeric

1

0

N
Caption: Rights
Comments: Ignored if optional VMP user-security system is installed (XXFWSEC.VCX/cusUserSecurity). Global app-specific user rights: 1=Administrator, 5=User (RW), 8=Guest (RO), any additional values specified in XXFW.VCX/cusUserSec.SetRightsArray()
Default: 5
Validation Rule: INLIST(usr_rights,0,1,5,8)
Validation Text: xxfwruleerrortext("FR_Usr_Rights","User Rights must be specified: 1=Administrator, 5=User, or 8=Guest")

5

usr_system

Character

1

0

N
Caption: System
Comments: Set to "Y", indicates that this user is a 'hidden' user, and does not show up on any form/control interfaces
Default: "N"
Validation Rule: INLIST(usr_system,"Y","N")
Validation Text: xxfwruleerrortext("FR_Usr_System",'System indicator must be "Y"es or "N"o')

6

usr_active

Character

1

0

N
Caption: Active
Comments: Indicates whether this user is an Active account or not (if inactive, that UserID+Password will not be able to successfully login
Default: "Y"
Validation Rule: INLIST(usr_active,"Y","N")
Validation Text: xxfwruleerrortext("FR_Usr_Active",'Active indicator must be "Y"es or "N"o')

7

usr_lastlogin

DateTime

8

0

Y
Caption: Last Login
Comments: Indicates the last time this user logged into the app (see oUser.LogLoginLogout). Optional field, can be deleted, VMP framework will ignore it, including removing from XXFWSEC.VCXctrUsersBoundControls at runtime
Default: .NULL.

8

usr_firstname

Character

15

0

N
Caption: First Name

9

usr_middleinitial

Character

1

0

N
Caption: Middle Initial

10

usr_lastname

Character

20

0

N
Caption: Last Name

11

usr_phone

Character

12

0

N
Caption: Phone Number
Comments: Optional field, can be deleted ignored in the VMP framework, including removal in XXFWSEC.VCX/ctrUsersBoundControls

12

usr_phoneext

Character

4

0

N
Caption: Ext
Comments: Optional field, can be deleted ignored in the VMP framework, including removal in XXFWSEC.VCX/ctrUsersBoundControls

13

usr_fax

Character

12

0

N
Caption: Fax Number
Comments: Optional field, can be deleted ignored in the VMP framework, including removal in XXFWSEC.VCX/ctrUsersBoundControls

14

usr_enableprefs

Character

1

0

N
Caption: Preferences?
Comments: Indicates whether this user wants preferences saved/restored by default
Default: "Y"

15

usr_intllanguage

Character

20

0

N
Caption: Language
Comments: Language of preference for this user, requires Steven Black's INTL Toolkit
Default: "Original"

16

usr_notes

Memo

4

0

N
Caption: Notes
Comments: Optional field, can be deleted ignored in the VMP framework, including removal in XXFWSEC.VCX/frmDEUsers and XXFWSEC.VCX/frmUserProperties

17

usr_sale

Character

5

0

N
Caption: Last sale number

18

usr_emailserver

Character

50

0

N
Caption: User Outgoing Email Server

19

usr_emailname

Character

50

0

N
Caption: eMail Authentication Name

20

usr_emailpassword

Character

20

0

N
Caption: User eMail Authentication Password

21

usr_email

Character

60

0

N
Caption: User Email Address

22

usr_seqnum

Character

7

0

N
Caption: Usr Seqnum

23

usr_dformat

Character

2

0

N
Caption: Division

24

usr_lastseq

Character

7

0

N
Caption: Usr Lastseq

25

usr_prntlbl

Character

1

0

N
Caption: User Print Label

Total record size: 325

Table: au!usrgrpxref

# Field Name Type Len Dec Null

1

ugx_pk

Integer

4

0

N
Caption: Primary Key
Default: x3genpk("USRGRPXREF","AU")

2

ugx_ugrfk

Integer

4

0

N
Caption: Group
Validation Rule: IIF(_triggerlevel>0,.T.,x3seek("AU",ugx_ugrfk,"USERGROUPS","UGr_PK",.T.))
Validation Text: xxfwruleerrortext("FR_UGX_UGrFK","The Group you have entered is not on file in the UserGroups reference file")

3

ugx_memberfk

Integer

4

0

N
Caption: Member
Comments: User/Group

4

ugx_membertype

Character

1

0

N
Caption: Member Type "U"ser or "G"roup
Default: "U"
Validation Rule: INLIST(ugx_membertype,"U","G")
Validation Text: xxfwruleerrortext("FR_UGX_MemberType","Member Type must be 'U' or 'G'.")

Total record size: 14

Table: au!vatcode

# Field Name Type Len Dec Null

1

vat_pk

Integer

4

0

N
Caption: Vat Code Primary Key

2

vat_code

Character

4

0

N
Caption: Vat Code

3

vat_descr

Character

40

0

N
Caption: Vat Code Description

4

vat_cat

Character

3

0

N
Caption: Code Used in Catalog

5

vat_sort

Character

2

0

N
Caption: Vat Sort in Catalog

6

last_edit

Date

8

0

N
Caption: Last Edit

7

last_time

Character

6

0

N
Caption: Last Time

8

operator

Character

10

0

N
Caption: Operator

Total record size: 78

Table: au!vmpri

# Field Name Type Len Dec Null

1

xri_parent_tablename

Character

128

0

N

2

xri_child_tablename

Character

128

0

N

3

xri_child_index_tag

Character

10

0

N

4

xri_insert_type

Character

1

0

N
Comments: Valid values are: 'I'nsert-Allow insert, 'R'estrict-No insert unless parent exists

5

xri_update_type

Character

1

0

N
Comments: Valid values are: 'I'gnore-Allow update, 'C'ascade-Post changes to the parent PK to child FKs, 'R'estrict - Prevents update if child records exist related to parent record.

6

xri_delete_type

Character

1

0

N
Comments: Valid values are: 'I'gnore - Allows delete, 'C'ascade-Deletes child records with a FK matching the parent PK, 'R'estrict-Prevents deletion if child records exist related to parent record.

Total record size: 270

Table: au!wantlist

# Field Name Type Len Dec Null

1

wl_pk

Integer

4

0

N

2

category

Character

8

0

N
Caption: Category Code

3

wl_catfk

Integer

4

0

N
Caption: Category Foreign Key

4

cust_no

Character

6

0

N
Caption: Cust No

5

wl_cusfk

Integer

4

0

N
Caption: Customer Foreign Key

6

symbol

Character

8

0

N
Caption: Symbol

7

level

Character

4

0

N
Caption: Level

8

condition

Character

8

0

N
Caption: Condition

9

srtorder

Character

40

0

N
Caption: Srtorder

10

est_real

Numeric

11

2

N
Caption: Est Real

11

ref_num

Character

30

0

N
Caption: Ref Num

12

est_low

Numeric

11

2

N
Caption: Est Low

13

catalog

Character

15

0

N
Caption: Catalog

14

catalog_no

Character

30

0

N
Caption: Catalog No

15

cat_value

Numeric

11

2

N
Caption: Cat Value

16

notes

Character

64

0

N
Caption: Notes

17

gum

Character

12

0

N
Caption: Gum

18

last_edit

Date

8

0

N
Caption: Last Edit

19

operator

Character

10

0

N
Caption: Operator

20

last_time

Character

6

0

N
Caption: Last Time

21

sgyr

Character

4

0

N
Caption: Sgyr

22

sgval

Character

4

0

N
Caption: Sgval

23

scyr

Character

4

0

N
Caption: Scyr

24

scval

Character

4

0

N
Caption: Scval

25

exyr

Character

4

0

N
Caption: Exyr

26

exval

Character

4

0

N
Caption: Exval

Total record size: 319

Table: au!wbids

# Field Name Type Len Dec Null

1

firm_id

Character

2

0

N
Caption: Firm Identifier

2

sale_no

Character

4

0

N
Caption: Sale No.

3

lot_no

Character

5

0

N
Caption: Lot No.

4

cust_no

Character

6

0

N
Caption: Customer No.

5

handle

Character

20

0

N
Caption: Web Unique Id

6

amount

Numeric

11

2

N
Caption: Amount of Bid

7

or_ind

Character

2

0

N
Caption: OR Indicator

8

ignore

Logical

1

0

N
Caption: not used

9

comments

Character

40

0

N
Caption: not used

10

bid

Numeric

11

2

N
Caption: Bid Amount (same as or greater than Amount)

11

drop

Logical

1

0

N

12

date_rcvd

Date

8

0

N
Caption: Date Received

13

rank

Numeric

3

0

N
Caption: not used

14

last_edit

Date

8

0

N
Caption: Last Changed

15

last_time

Character

6

0

N
Caption: Last Time

16

misc_info

Character

2

0

N
Caption: "IB" if Internet Bid, "IF" if Live Floor Bid

17

oth_phone

Character

60

0

N
Caption: not used

18

update

Character

1

0

N
Caption: not used

19

limit_amt

Numeric

11

2

N
Caption: Limit Amt

20

bidsheet

Numeric

6

0

N
Caption: Bidsheet Id

Total record size: 209

Table: au!wbidsin

# Field Name Type Len Dec Null

1

firm_id

Character

2

0

N

2

sale_no

Character

4

0

N

3

lot_no

Character

5

0

N

4

cust_no

Character

6

0

N

5

handle

Character

20

0

N

6

amount

Numeric

11

2

N

7

or_ind

Character

2

0

N

8

ignore

Logical

1

0

N

9

comments

Character

40

0

N

10

bid

Numeric

11

2

N

11

drop

Logical

1

0

N

12

date_rcvd

Date

8

0

N

13

rank

Numeric

3

0

N

14

last_edit

Date

8

0

N

15

last_time

Character

6

0

N

16

misc_info

Character

2

0

N

17

oth_phone

Character

60

0

N

18

update

Character

1

0

N

19

limit_amt

Numeric

11

2

N
Caption: Limit Amt

20

bidsheet

Numeric

6

0

N
Caption: Bidsheet Id

Total record size: 209

Table: au!wbidsout

# Field Name Type Len Dec Null

1

firm_id

Character

2

0

N

2

sale_no

Character

4

0

N

3

lot_no

Character

5

0

N

4

cust_no

Character

6

0

N

5

handle

Character

20

0

N

6

amount

Numeric

11

2

N

7

or_ind

Character

2

0

N

8

ignore

Logical

1

0

N

9

comments

Character

40

0

N

10

bid

Numeric

11

2

N

11

drop

Logical

1

0

N

12

date_rcvd

Date

8

0

N

13

rank

Numeric

3

0

N

14

last_edit

Date

8

0

N

15

last_time

Character

6

0

N

16

misc_info

Character

2

0

N

17

oth_phone

Character

60

0

N

18

update

Character

1

0

N

19

limit_amt

Numeric

11

2

N
Caption: Limit Amt

20

bidsheet

Numeric

6

0

N
Caption: Bidsheet Id

Total record size: 209

Table: au!wclass

# Field Name Type Len Dec Null

1

cla_pk

Integer

4

0

N
Caption: Classification Primary Key

2

cla_code

Character

4

0

N
Caption: Classification Code

3

cla_descr

Character

40

0

N
Caption: Classification Description

4

last_edit

Date

8

0

N
Caption: Last Date

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: Delete

8

mergeto

Character

4

0

N
Caption: Mergeto

9

sort_code

Character

5

0

N
Caption: Sort Code

Total record size: 83

Table: au!wconvert

# Field Name Type Len Dec Null

1

cust_no

Character

6

0

N
Caption: Customer Number (AMS/WMS sets this value)

2

cust_lname

Character

30

0

N
Caption: Last Name

3

cust_fname

Character

20

0

N
Caption: First Name and Middle Initial

4

attention

Character

40

0

N
Caption: Attention Line

5

addr1

Character

42

0

N
Caption: Address Line 1 (Account)

6

addr2

Character

42

0

N
Caption: Address Line 2 (Account)

7

addr3

Character

42

0

N
Caption: Address Line 3 (Account)

8

city

Character

25

0

N
Caption: City

9

state

Character

3

0

N
Caption: State

10

county

Character

3

0

N
Caption: County Code (not country)

11

zip

Character

10

0

N
Caption: Zip Code

12

wphone

Character

22

0

N
Caption: Work Phone

13

hphone

Character

22

0

N
Caption: Home Phone

14

fphone

Character

22

0

N
Caption: Fax Phone

15

ophone

Character

22

0

N
Caption: Other Phone

16

country

Character

25

0

N
Caption: Country

17

cred_no

Character

24

0

N
Caption: Credit Card Number

18

cred_name

Character

20

0

N
Caption: Name on Card

19

cred_init

Character

5

0

N
Caption: Init Date

20

cred_exp

Character

5

0

N
Caption: Expiration Date

21

cred_type

Character

5

0

N
Caption: Type of Card (VISA, MC, AMEX, etc...)

22

credit1

Character

60

0

N
Caption: Credit References

23

credit2

Character

60

0

N
Caption: Credit References

24

credit3

Character

60

0

N
Caption: Credit References

25

credit4

Character

60

0

N
Caption: Credit References

26

last_edit

Date

8

0

N
Caption: Date Stamped when Last Edited

27

last_time

Character

6

0

N
Caption: Time Stamped when Last Edited

28

operator

Character

10

0

N
Caption: Who Last Edited

29

creator

Character

10

0

N
Caption: Who Created the record

30

add_date

Date

8

0

N
Caption: Date Created

31

break_tie

Logical

1

0

N
Caption: Break Tie

32

incr_bid

Logical

1

0

N
Caption: Increase Bid

33

email

Character

65

0

N
Caption: Primary Email Address

34

wre_cusfk

Integer

4

0

N
Caption: Primary Key of Customer in AMS/WMS System

35

cou_ab

Character

3

0

N
Caption: Country Code

36

company

Character

65

0

N
Caption: Company (if the account is a company)

37

fullsal

Character

20

0

N
Caption: Fullsal

38

position

Character

20

0

N
Caption: Position

39

sales_mgr

Character

20

0

N
Caption: Sales Mgr

40

source

Character

10

0

N
Caption: Source

41

sales_rep

Character

10

0

N
Caption: Sales Rep

42

bbr_number

Character

6

0

N
Caption: Bbr Number

43

cred_limit

Numeric

6

0

N
Caption: Cred Limit

44

resale_no

Character

20

0

N
Caption: Resale No

45

sub_info

Character

10

0

N
Caption: Sub Info

46

notes

Memo

4

0

N
Caption: Notes

47

fedtaxid

Character

11

0

N
Caption: Fedtaxid

48

custom1

Character

20

0

N
Caption: Custom1

49

interest

Character

30

0

N
Caption: Interest

50

div2

Logical

1

0

N
Caption: Div2

51

div3

Logical

1

0

N
Caption: Div3

52

ib_number

Character

10

0

N
Caption: Ib Number

53

cou_coufk

Integer

4

0

N
Caption: Cou Coufk

54

spec_info

Character

10

0

N
Caption: Spec Info

55

matchon

Character

10

0

N
Caption: Matchon

56

ship_via

Character

30

0

N
Caption: Ship Via

57

pnotes

Memo

4

0

N
Caption: Partner Internal Notes

58

pconfident

Memo

4

0

N
Caption: Partner Confidential Notes

59

btotal

Numeric

12

2

N
Caption: Partner Buying Total

60

stotal

Numeric

12

2

N
Caption: Partner Selling Total

61

ourcustno

Character

6

0

N
Caption: Our Customer Number for reverse Matching

Total record size: 1148

Table: au!weights

# Field Name Type Len Dec Null

1

wgt_pk

Integer

4

0

N
Caption: Primary Key

2

code

Character

15

0

N
Caption: Code

3

weight

Numeric

6

2

N
Caption: Weight

4

operator

Character

10

0

N

5

last_edit

Date

8

0

N

6

last_time

Character

6

0

N

Total record size: 50

Table: au!whse

# Field Name Type Len Dec Null

1

whs_pk

Integer

4

0

N

2

whs_code

Character

6

0

N
Caption: Warehouse Code

3

whs_cntry

Character

20

0

N
Caption: Country

4

whs_coufk

Integer

4

0

N
Caption: Country Foreign Key

5

whs_name

Character

40

0

N
Caption: Warehouse Name

6

whs_catnm

Character

40

0

N
Caption: Warehouse Name used in Catalog

7

whs_addr1

Character

42

0

N
Caption: Address 1

8

whs_addr2

Character

42

0

N
Caption: Address 2

9

whs_addr3

Character

42

0

N
Caption: Address 3

10

whs_city

Character

25

0

N
Caption: City

11

whs_state

Character

3

0

N
Caption: State

12

whs_zip

Character

10

0

N
Caption: Zip Code

13

whs_phone

Character

17

0

N
Caption: Work Phone

14

whs_email

Character

50

0

N
Caption: eMail

15

whs_fax

Character

17

0

N
Caption: Fax Phone

16

operator

Character

10

0

N
Caption: Operator

17

last_edit

Date

8

0

N
Caption: Last Edit

18

last_time

Character

6

0

N
Caption: Last Time

19

wshipper

Character

6

0

N
Caption: Default Shipper

20

cou_ab

Character

3

0

N
Caption: Country Code

Total record size: 396

Table: au!wine

# Field Name Type Len Dec Null

1

win_pk

Integer

4

0

N
Caption: Wine Primary Key

2

win_code

Character

5

0

N
Caption: Wine Code

3

win_descr

Character

80

0

N
Caption: Wine Description

4

perc_alcoh

Numeric

6

2

N
Caption: Percent Alcohol

5

win_catfk

Integer

4

0

N
Caption: Foreign Key from Category

6

win_appfk

Integer

4

0

N
Caption: Appellation Foreign Key

7

win_clafk

Integer

4

0

N
Caption: Wine Classification Foreign Key

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

11

win_note

Memo

4

0

N
Caption: Win Note

12

wcat_note

Memo

4

0

N
Caption: Wine Catalog Note

13

recdelete

Character

1

0

N
Caption: Delete

14

mergeto

Character

5

0

N
Caption: Mergeto

15

link_to

Character

9

0

N
Caption: Link To

Total record size: 155

Table: au!winehx

# Field Name Type Len Dec Null

1

whx_pk

Integer

4

0

N
Caption: Wine Pricing Primary Key

2

whx_winfk

Integer

4

0

N
Caption: Wine Foreign Key

3

whx_grofk

Integer

4

0

N
Caption: Grower Foreign Key

4

vintage

Character

4

0

N
Caption: Vintage

5

siz_code

Character

4

0

N
Caption: Siz Code

6

whx_sizfk

Integer

4

0

N
Caption: Price History Size Foreign Key

7

date

Date

8

0

N
Caption: Date

8

sale_no

Character

8

0

N
Caption: Sale No

9

whx_salfk

Integer

4

0

N
Caption: Sale Foreign Key

10

lot_no

Character

5

0

N
Caption: Lot No

11

pr_type

Character

4

0

N
Caption: Pr Type

12

realized

Numeric

11

2

N
Caption: Realized

13

um

Character

10

0

N
Caption: Um

14

upercase

Numeric

8

2

N
Caption: Bottles Per Case

15

cases

Numeric

4

0

N
Caption: Cases

16

bottles

Numeric

4

0

N
Caption: Bottles

17

tax_status

Character

5

0

N
Caption: Tax Status

18

est_low

Numeric

12

2

N
Caption: Low Estimate

19

est_real

Numeric

12

2

N
Caption: High Estimate

20

last_time

Character

6

0

N
Caption: Last Time

21

last_edit

Date

8

0

N
Caption: Last Edit

22

operator

Character

10

0

N
Caption: Operator

23

source

Character

6

0

N
Caption: Source

24

category

Character

8

0

N
Caption: Category

25

srtorder

Character

4

0

N
Caption: Srtorder

26

lot_catfk

Integer

4

0

N
Caption: Lot Catfk

27

consignor

Character

6

0

N
Caption: Consignor

28

lot_confk

Integer

4

0

N
Caption: Lot Confk

29

cust_no

Character

6

0

N
Caption: Cust No

30

lot_buyfk

Integer

4

0

N
Caption: Lot Buyfk

31

est_cons

Numeric

11

2

N
Caption: Est Cons

32

lot_descr

Memo

4

0

N
Caption: Lot Descr

33

reserve

Numeric

11

2

N
Caption: Reserve

34

retail

Numeric

11

2

N
Caption: Retail

35

number_lot

Numeric

6

0

N
Caption: Number Lot

Total record size: 229

Table: au!wineprx

# Field Name Type Len Dec Null

1

wpx_pk

Integer

4

0

N
Caption: Wine Pricing Primary Key

2

wpx_winfk

Integer

4

0

N
Caption: Wine Foreign Key

3

wpx_grofk

Integer

4

0

N
Caption: Grower Foreign Key

4

vintage

Character

4

0

N
Caption: Vintage

5

est_low

Numeric

12

2

N
Caption: Low Estimate

6

est_real

Numeric

12

2

N
Caption: High Estimate

7

reserve

Numeric

12

2

N
Caption: Reserve

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

11

retail

Numeric

12

2

N
Caption: Retail

12

est_cons

Numeric

11

2

N
Caption: Estimate to the Consignor

13

price3

Numeric

11

2

N
Caption: Cost

14

vendor

Character

6

0

N
Caption: Vendor

15

wpx_cusfk

Integer

4

0

N
Caption: Vendor Foreign Key

16

allow_bo

Character

10

0

N
Caption: Allow Back Order and Timing

17

number_bo

Numeric

6

0

N
Caption: Qty that can be Backordered

Total record size: 137

Table: au!wlots

# Field Name Type Len Dec Null

1

wlo_pk

Integer

4

0

N

2

wlo_xxxfk

Integer

4

0

N

3

firm_id

Character

2

0

N

4

sale_no

Character

4

0

N

5

lot_no

Character

5

0

N

6

category

Character

8

0

N

7

majgroup

Character

50

0

N

8

catdescr

Character

50

0

N

9

subgroup

Character

50

0

N

10

order

Character

25

0

N

11

symbol

Character

5

0

N

12

condition

Character

8

0

N

13

gum

Character

5

0

N

14

shrttext

Character

60

0

N

15

htmltext

Memo

4

0

N

16

htmlfile

Character

20

0

N

17

inlineimg

Character

100

0

N

18

linkedimg

Character

100

0

N

19

descrip

Character

250

0

N

20

est_low

Numeric

11

2

N

21

est_real

Numeric

11

2

N

22

price3

Numeric

11

2

N

23

est_code

Character

1

0

N

24

seq_num

Character

6

0

N

25

opening

Numeric

11

2

N

26

man_open

Character

1

0

N

27

realized

Numeric

11

2

N

28

reserve

Numeric

11

2

N

29

number_lot

Numeric

5

0

N

30

high_bid

Numeric

11

2

N

31

bid

Numeric

11

2

N

32

notes

Character

64

0

N

33

currency

Character

3

0

N

34

catalog

Character

15

0

N

35

box_lot

Character

1

0

N

36

spill

Memo

4

0

N

37

bidder

Character

6

0

N

38

last_edit

Date

8

0

N

39

last_time

Character

6

0

N

40

num_bids

Numeric

4

0

N

41

net_resv

Character

1

0

N

42

ceiling

Logical

1

0

N

43

soldtime

Character

14

0

N

44

image

Character

1

0

N

45

deskkey

Character

1

0

N

46

update

Character

1

0

N

47

close_date

Date

8

0

N

48

start_date

Date

8

0

N

49

close_ch14

Character

17

0

N

50

start_ch14

Character

17

0

N

51

cust_no

Character

6

0

N

52

paddle

Character

4

0

N

53

lot_value

Character

40

0

N

54

primarykey

Character

11

0

N

Total record size: 1097

Table: au!wreal

# Field Name Type Len Dec Null

1

firm_id

Character

2

0

N

2

sale_no

Character

4

0

N

3

lot_no

Character

5

0

N

4

realized

Numeric

11

2

N

5

bidder

Character

6

0

N

6

cust_no

Character

6

0

N

7

paddle

Character

4

0

N

8

opening

Numeric

11

2

N

9

reserve

Numeric

11

2

N

Total record size: 61

Table: au!wrealout

# Field Name Type Len Dec Null

1

firm_id

Character

2

0

N

2

sale_no

Character

4

0

N

3

lot_no

Character

5

0

N

4

realized

Numeric

11

2

N

5

bidder

Character

6

0

N

6

cust_no

Character

6

0

N

7

paddle

Character

4

0

N

8

opening

Numeric

11

2

N

9

reserve

Numeric

11

2

N

Total record size: 61

Table: au!wregi

# Field Name Type Len Dec Null

1

cust_no

Character

6

0

N
Caption: Customer Number (AMS/WMS sets this value)

2

firm_id

Character

2

0

N

3

handle

Character

20

0

N
Caption: unique id for Web Customer, use Web Key Field

4

approved

Character

1

0

N
Caption: Approved for Bidding

5

bid_anony

Character

1

0

N
Caption: not used

6

paddle

Character

4

0

N
Caption: Paddle Number

7

cust_lname

Character

30

0

N
Caption: Last Name

8

cust_fname

Character

20

0

N
Caption: First Name and Middle Initial

9

attention

Character

40

0

N
Caption: Attention Line

10

addr1

Character

42

0

N
Caption: Address Line 1 (Account)

11

addr2

Character

42

0

N
Caption: Address Line 2 (Account)

12

addr3

Character

42

0

N
Caption: Address Line 3 (Account)

13

city

Character

25

0

N
Caption: City

14

state

Character

3

0

N
Caption: State

15

county

Character

3

0

N
Caption: County Code (not country)

16

zip

Character

10

0

N
Caption: Zip Code

17

max_bid

Numeric

8

0

N
Caption: Limit Total Winnings to this amount

18

incr_by

Numeric

3

0

N
Caption: Increase my bids by this percentage

19

wphone

Character

22

0

N
Caption: Work Phone

20

hphone

Character

22

0

N
Caption: Home Phone

21

fphone

Character

22

0

N
Caption: Fax Phone

22

ophone

Character

22

0

N
Caption: Other Phone

23

country

Character

25

0

N
Caption: Country

24

cred_no

Character

24

0

N
Caption: Credit Card Number

25

cred_name

Character

20

0

N
Caption: Name on Card

26

cred_init

Character

5

0

N
Caption: Init Date

27

cred_exp

Character

5

0

N
Caption: Expiration Date

28

cred_type

Character

5

0

N
Caption: Type of Card (VISA, MC, AMEX, etc...)

29

credit1

Character

60

0

N
Caption: Credit References

30

credit2

Character

60

0

N
Caption: Credit References

31

credit3

Character

60

0

N
Caption: Credit References

32

credit4

Character

60

0

N
Caption: Credit References

33

last_edit

Date

8

0

N
Caption: Date Stamped when Last Edited

34

last_time

Character

6

0

N
Caption: Time Stamped when Last Edited

35

operator

Character

10

0

N
Caption: Who Last Edited

36

creator

Character

10

0

N
Caption: Who Created the record

37

add_date

Date

8

0

N
Caption: Date Created

38

break_tie

Logical

1

0

N
Caption: Break Tie

39

incr_bid

Logical

1

0

N
Caption: Increase Bid

40

email

Character

65

0

N
Caption: Primary Email Address

41

email2

Character

65

0

N
Caption: Second Email Address

42

remove

Character

1

0

N
Caption: Y = Remove from email distribution Lists

43

update

Character

1

0

N
Caption: not used

44

wre_cusfk

Integer

4

0

N
Caption: Primary Key of Customer in AMS/WMS System

45

sale_no

Character

4

0

N
Caption: Sale No

46

cou_ab

Character

3

0

N
Caption: Country Code

47

ship1

Character

40

0

N
Caption: Shipping Address (Starts with Name)

48

ship2

Character

40

0

N
Caption: Shipping Address

49

ship3

Character

40

0

N
Caption: Shipping Address

50

ship4

Character

40

0

N
Caption: Shipping Address

51

ship5

Character

40

0

N
Caption: Shipping Address

52

sh_city

Character

25

0

N
Caption: Shipping City

53

sh_state

Character

3

0

N
Caption: Shipping State

54

sh_zip

Character

10

0

N
Caption: Shipping Zip

55

sh_country

Character

25

0

N
Caption: Shipping Country

56

sh_cou_ab

Character

3

0

N
Caption: Shipping Country Abreviation

57

company

Character

65

0

N
Caption: Company (if the account is a company)

Total record size: 1233

Table: au!wregiin

# Field Name Type Len Dec Null

1

cust_no

Character

6

0

N

2

firm_id

Character

2

0

N

3

handle

Character

20

0

N

4

approved

Character

1

0

N

5

bid_anony

Character

1

0

N

6

paddle

Character

4

0

N

7

cust_lname

Character

30

0

N

8

cust_fname

Character

20

0

N

9

attention

Character

40

0

N

10

addr1

Character

42

0

N

11

addr2

Character

42

0

N

12

addr3

Character

42

0

N

13

city

Character

25

0

N

14

state

Character

3

0

N

15

county

Character

3

0

N

16

zip

Character

10

0

N

17

max_bid

Numeric

8

0

N

18

incr_by

Numeric

3

0

N

19

wphone

Character

17

0

N

20

hphone

Character

17

0

N

21

fphone

Character

17

0

N

22

ophone

Character

17

0

N

23

country

Character

25

0

N

24

cred_no

Character

24

0

N

25

cred_name

Character

20

0

N

26

cred_init

Character

5

0

N

27

cred_exp

Character

5

0

N

28

cred_type

Character

5

0

N

29

credit1

Character

60

0

N

30

credit2

Character

60

0

N

31

credit3

Character

60

0

N

32

credit4

Character

60

0

N

33

last_edit

Date

8

0

N

34

last_time

Character

6

0

N

35

operator

Character

10

0

N

36

creator

Character

10

0

N

37

add_date

Date

8

0

N

38

break_tie

Logical

1

0

N

39

incr_bid

Logical

1

0

N

40

email

Character

65

0

N

41

email2

Character

65

0

N

42

remove

Character

1

0

N

43

update

Character

1

0

N

44

sale_no

Character

4

0

N
Caption: Sale No

45

cou_ab

Character

3

0

N
Caption: Cou Ab

46

ship1

Character

40

0

N
Caption: Ship1

47

ship2

Character

40

0

N
Caption: Ship2

48

ship3

Character

40

0

N
Caption: Ship3

49

ship4

Character

40

0

N
Caption: Ship4

50

ship5

Character

40

0

N
Caption: Ship5

51

sh_city

Character

25

0

N
Caption: Sh City

52

sh_state

Character

3

0

N
Caption: Sh State

53

sh_country

Character

25

0

N
Caption: Sh Country

54

sh_cou_ab

Character

3

0

N
Caption: Sh Cou Ab

55

company

Character

65

0

N
Caption: Company

Total record size: 1199

Table: au!wregiout

# Field Name Type Len Dec Null

1

cust_no

Character

6

0

N

2

firm_id

Character

2

0

N

3

handle

Character

20

0

N

4

approved

Character

1

0

N

5

bid_anony

Character

1

0

N

6

paddle

Character

4

0

N

7

cust_lname

Character

30

0

N

8

cust_fname

Character

20

0

N

9

attention

Character

40

0

N

10

addr1

Character

42

0

N

11

addr2

Character

42

0

N

12

addr3

Character

42

0

N

13

city

Character

25

0

N

14

state

Character

3

0

N

15

county

Character

3

0

N

16

zip

Character

10

0

N

17

max_bid

Numeric

8

0

N

18

incr_by

Numeric

3

0

N

19

wphone

Character

17

0

N

20

hphone

Character

17

0

N

21

fphone

Character

17

0

N

22

ophone

Character

17

0

N

23

country

Character

25

0

N

24

cred_no

Character

24

0

N

25

cred_name

Character

20

0

N

26

cred_init

Character

5

0

N

27

cred_exp

Character

5

0

N

28

cred_type

Character

5

0

N

29

credit1

Character

60

0

N

30

credit2

Character

60

0

N

31

credit3

Character

60

0

N

32

credit4

Character

60

0

N

33

last_edit

Date

8

0

N

34

last_time

Character

6

0

N

35

operator

Character

10

0

N

36

creator

Character

10

0

N

37

add_date

Date

8

0

N

38

break_tie

Logical

1

0

N

39

incr_bid

Logical

1

0

N

40

email

Character

65

0

N

41

email2

Character

65

0

N

42

remove

Character

1

0

N

43

update

Character

1

0

N

44

sale_no

Character

4

0

N
Caption: Sale No

45

cou_ab

Character

3

0

N
Caption: Cou Ab

46

ship1

Character

40

0

N
Caption: Ship1

47

ship2

Character

40

0

N
Caption: Ship2

48

ship3

Character

40

0

N
Caption: Ship3

49

ship4

Character

40

0

N
Caption: Ship4

50

ship5

Character

40

0

N
Caption: Ship5

51

sh_city

Character

25

0

N
Caption: Sh City

52

sh_state

Character

3

0

N
Caption: Sh State

53

sh_zip

Character

10

0

N
Caption: Sh Zip

54

sh_country

Character

25

0

N
Caption: Sh Country

55

sh_cou_ab

Character

3

0

N
Caption: Sh Cou Ab

56

company

Character

65

0

N
Caption: Company

Total record size: 1209

Table: au!wureg

# Field Name Type Len Dec Null

1

wur_pk

Integer

4

0

N

2

wur_xxxfk

Integer

4

0

N

3

handle

Character

20

0

N

4

password

Character

20

0

N

5

bid_anony

Character

1

0

N

6

cust_lname

Character

30

0

N

7

cust_fname

Character

20

0

N

8

attention

Character

40

0

N

9

addr1

Character

42

0

N

10

addr2

Character

42

0

N

11

addr3

Character

42

0

N

12

city

Character

25

0

N

13

state

Character

3

0

N

14

county

Character

3

0

N

15

zip

Character

10

0

N

16

wphone

Character

17

0

N

17

hphone

Character

17

0

N

18

fphone

Character

17

0

N

19

ophone

Character

17

0

N

20

country

Character

20

0

N

21

credit1

Character

60

0

N

22

credit2

Character

60

0

N

23

credit3

Character

60

0

N

24

credit4

Character

60

0

N

25

last_edit

Date

8

0

N

26

last_time

Character

6

0

N

27

last_sign

Date

8

0

N

28

operator

Character

10

0

N

29

creator

Character

10

0

N

30

add_date

Date

8

0

N

31

email

Character

65

0

N

32

email2

Character

65

0

N

33

remove

Character

1

0

N

34

update

Character

1

0

N

Total record size: 817

Free Table: catalog

# Field Name Type Len Dec Null

1

clg_pk

Integer

4

0

N
Caption: Clg Pk

2

auctionco

Character

20

0

N
Caption: Auctionco

3

sale_no

Character

5

0

N
Caption: Sale No

4

category

Character

7

0

N
Caption: Category

5

lot_no

Character

5

0

N
Caption: Lot No

6

descrip

Character

250

0

N
Caption: Descrip

7

price3

Numeric

11

2

N
Caption: Price3

8

est_low

Numeric

11

2

N
Caption: Est Low

9

est_real

Numeric

11

2

N
Caption: Est Real

10

est_code

Character

10

0

N
Caption: Est Code

11

order

Character

20

0

N
Caption: Order

12

realized

Numeric

11

2

N
Caption: Realized

13

symbol

Character

5

0

N
Caption: Symbol

14

condition

Character

8

0

N
Caption: Condition

15

notes

Character

15

0

N
Caption: Notes

16

currency

Character

3

0

N
Caption: Currency

17

majgroup

Character

50

0

N
Caption: Majgroup

18

catdescr

Character

50

0

N
Caption: Catdescr

19

subgroup

Character

50

0

N
Caption: Subgroup

20

saledate

Character

15

0

N
Caption: Saledate

21

catalog

Character

10

0

N
Caption: Catalog

22

format

Character

2

0

N
Caption: Format

23

spill

Memo

4

0

N
Caption: Spill

24

country

Character

120

0

N
Caption: Country

25

photo

Character

1

0

N
Caption: Photo

26

seq_num

Character

6

0

N
Caption: Seq Num

27

plate

Character

10

0

N
Caption: Plate

28

header

Memo

4

0

N
Caption: Header

29

footer

Memo

4

0

N
Caption: Footer

30

ref_num

Character

15

0

N
Caption: Ref Num

31

gum

Character

5

0

N
Caption: Gum

32

loc2

Character

5

0

N
Caption: Loc2

Total record size: 748

Free Table: largelot

# Field Name Type Len Dec Null

1

lar_pk

Integer

4

0

N
Caption: Lar Pk

2

lar_xxxfk

Integer

4

0

N
Caption: Lar Xxxfk

3

lot_no

Character

5

0

N
Caption: Lot No

4

symbol

Character

5

0

N
Caption: Symbol

5

condition

Character

8

0

N
Caption: Condition

6

descrip

Character

250

0

N
Caption: Descrip

7

est_low

Numeric

11

2

N
Caption: Est Low

8

est_real

Numeric

11

2

N
Caption: Est Real

9

realized

Numeric

11

2

N
Caption: Realized

10

reserve

Numeric

11

2

N
Caption: Reserve

11

sale_no

Character

5

0

N
Caption: Sale No

12

seq_num

Character

6

0

N
Caption: Seq Num

13

ref_num

Character

15

0

N
Caption: Ref Num

14

plate

Character

10

0

N
Caption: Plate

15

category

Character

7

0

N
Caption: Category

16

consignor

Character

6

0

N
Caption: Consignor

Total record size: 370

Free Table: lotlabel

# Field Name Type Len Dec Null

1

lot_pk

Integer

4

0

N
Caption: Lot Pk

2

lot_xxxfk

Integer

4

0

N
Caption: Lot Xxxfk

3

sale_no

Character

5

0

N
Caption: Sale No

4

lot_no

Character

5

0

N
Caption: Lot No

5

descrip

Character

250

0

N
Caption: Descrip

6

photo

Character

1

0

N
Caption: Photo

7

est_low

Numeric

11

2

N
Caption: Est Low

8

est_real

Numeric

11

2

N
Caption: Est Real

9

price3

Numeric

11

2

N
Caption: Price3

10

est_code

Character

1

0

N
Caption: Est Code

11

order

Character

20

0

N
Caption: Order

12

seq_num

Character

6

0

N
Caption: Seq Num

13

category

Character

7

0

N
Caption: Category

14

prop_num

Character

4

0

N
Caption: Prop Num

15

consignor

Character

6

0

N
Caption: Consignor

16

cons_num

Character

12

0

N
Caption: Cons Num

17

realized

Numeric

11

2

N
Caption: Realized

18

reserve

Numeric

11

2

N
Caption: Reserve

19

number_lot

Numeric

5

0

N
Caption: Number Lot

20

symbol

Character

5

0

N
Caption: Symbol

21

condition

Character

8

0

N
Caption: Condition

22

notes

Character

64

0

N
Caption: Notes

23

currency

Character

3

0

N
Caption: Currency

24

catalog

Character

15

0

N
Caption: Catalog

25

box_lot

Character

1

0

N
Caption: Box Lot

26

spill

Memo

4

0

N
Caption: Spill

27

ref_num

Character

15

0

N
Caption: Ref Num

28

topics

Character

56

0

N
Caption: Topics

29

gum

Character

5

0

N
Caption: Gum

30

plate

Character

10

0

N
Caption: Plate

31

lot_notes

Memo

4

0

N
Caption: Lot Notes

32

date_buy

Date

8

0

N
Caption: Date Buy

33

country

Character

120

0

N
Caption: Country

34

header

Memo

4

0

N
Caption: Header

35

footer

Memo

4

0

N
Caption: Footer

36

year

Character

6

0

N
Caption: Year

37

postmark

Character

25

0

N
Caption: Postmark

38

price

Character

10

0

N
Caption: Price

Total record size: 753

Free Table: lotstat

# Field Name Type Len Dec Null

1

sort

Character

35

0

N
Caption: Sort

2

descrip

Character

30

0

N
Caption: Descrip

3

sale_no

Character

5

0

N
Caption: Sale No

4

est_low

Numeric

11

2

N
Caption: Est Low

5

est_real

Numeric

11

2

N
Caption: Est Real

6

order

Character

20

0

N
Caption: Order

7

category

Character

7

0

N
Caption: Category

8

consignor

Character

6

0

N
Caption: Consignor

9

realized

Numeric

11

2

N
Caption: Realized

10

reserve

Numeric

11

2

N
Caption: Reserve

11

box_lot

Character

1

0

N
Caption: Box Lot

12

ref_num

Character

15

0

N
Caption: Ref Num

13

plate

Character

6

0

N
Caption: Plate

14

num_lots

Numeric

5

0

N
Caption: Num Lots

15

sold_lots

Numeric

5

0

N
Caption: Sold Lots

16

sum_est

Numeric

11

2

N
Caption: Sum Est

17

sum_real

Numeric

11

2

N
Caption: Sum Real

18

sum_sold

Numeric

11

2

N
Caption: Sum Sold

19

num_bids

Numeric

4

0

N
Caption: Num Bids

Total record size: 217