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