Table Definitions

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

Name AutoOpen Updateable NoUpdate

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Index Definitions

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

Table: au!accttype

Tag Type Caption Desc Sel

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

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

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

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

Table: au!address

Tag Type Caption Desc Sel

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

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

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

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

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

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

address
Regular

N
Y
Expression: CUST_NO
Collate: MACHINE

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

Table: au!ap

Tag Type Caption Desc Sel

ap1
Regular

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

ap2
Regular

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

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

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

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

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

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

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

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

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

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

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

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

Table: au!apnotes

Tag Type Caption Desc Sel

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

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

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

Table: au!appel

Tag Type Caption Desc Sel

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

app_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

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

app_pk
Primary

N
Y
Expression: APP_PK
Collate: MACHINE

Table: au!apsort

Tag Type Caption Desc Sel

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

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

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

Table: au!araptran

Tag Type Caption Desc Sel

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

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

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

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

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

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

araptran
Regular

N
Y
Expression: CUST_NO+INVOICE
Collate: MACHINE

Table: au!bids

Tag Type Caption Desc Sel

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

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

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

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

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

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

bids1
Regular

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

bids2
Regular

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

bids3
Regular

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

bids4
Regular

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

bids5
Regular

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

cust_no
Regular

N
Y
Expression: CUST_NO
Collate: MACHINE

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

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

sale_no
Regular

N
Y
Expression: SALE_NO
Collate: MACHINE

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

Table: au!btype

Tag Type Caption Desc Sel

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

btp_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

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

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

Table: au!casetype

Tag Type Caption Desc Sel

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

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

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

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

Table: au!category

Tag Type Caption Desc Sel

cat1
Regular

N
Y
Expression: CATEGORY
Collate: MACHINE

cat2
Regular

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

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

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

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

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

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

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

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

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

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

Table: au!cbserver

Tag Type Caption Desc Sel

cbs_pk
Primary

N
Y
Expression: CBS_PK
Collate: MACHINE

done
Regular
Done
N
Y
Expression: DONE
Collate: MACHINE

Table: au!conslog

Tag Type Caption Desc Sel

con_cusfk
Regular

N
Y
Expression: CON_CUSFK
Collate: MACHINE

con_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

con_pk
Primary

N
Y
Expression: CON_PK
Collate: MACHINE

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

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

conslog1
Regular
Conslog1
N
Y
Expression: CONS_NUM
Collate: MACHINE

cost
Regular
Cost
N
Y
Expression: COST
Collate: MACHINE

cquality
Regular

N
Y
Expression: CQUALITY
Collate: MACHINE

cstatus
Regular
Status
N
Y
Expression: CSTATUS
Collate: MACHINE

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

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

date
Regular
Date
N
Y
Expression: DATE
Collate: MACHINE

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

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

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

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

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

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

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

Table: au!conslogd

Tag Type Caption Desc Sel

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

cld_cusfk
Regular

N
Y
Expression: CLD_CUSFK
Collate: MACHINE

cld_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

cld_pk
Primary

N
Y
Expression: CLD_PK
Collate: MACHINE

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

Table: au!consstat

Tag Type Caption Desc Sel

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

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

cst_pk
Primary
CST_PK
N
N
Expression: CST_PK
Collate: MACHINE

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

Table: au!contacts

Tag Type Caption Desc Sel

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

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

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

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

date
Regular

N
Y
Expression: DATE
Collate: MACHINE

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

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

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

Table: au!country

Tag Type Caption Desc Sel

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

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

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

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

region
Regular
Region
N
Y
Expression: REGION
Collate: MACHINE

Table: au!credcard

Tag Type Caption Desc Sel

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

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

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

credcard
Regular

N
Y
Expression: CUST_NO+CRED_TYPE
Collate: MACHINE

Table: au!credin

Tag Type Caption Desc Sel

cin_pk
Primary
CIN_PK
N
N
Expression: CIN_PK
Collate: MACHINE

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

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

Table: au!credpost

Tag Type Caption Desc Sel

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

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

Table: au!currency

Tag Type Caption Desc Sel

abbr
Regular
Abbreviation
N
Y
Expression: ABBR
Collate: MACHINE

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

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

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

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

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

Table: au!custarch

Tag Type Caption Desc Sel

city
Regular

N
Y
Expression: UPPER(CITY)
Collate: MACHINE

company
Regular

N
Y
Expression: UPPER(COMPANY)
Collate: MACHINE

country
Regular

N
Y
Expression: UPPER(COUNTRY)
Collate: MACHINE

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

cus_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

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

cus_recst
Regular

N
Y
Expression: CUS_RECST
Collate: MACHINE

cust1
Regular

N
Y
Expression: CUST_NO
Collate: MACHINE

cust2
Regular

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

cust3
Regular

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

cust4
Regular

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

cust5
Regular

N
Y
Expression: WPHONE
Collate: MACHINE

cust_lname
Regular

N
Y
Expression: UPPER(CUST_LNAME)
Collate: MACHINE

email
Regular

N
Y
Expression: UPPER(EMAIL)
Collate: MACHINE

ib_number
Regular

N
Y
Expression: IB_NUMBER
Collate: MACHINE

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

sh_country
Regular

N
Y
Expression: UPPER(SH_COUNTRY)
Collate: MACHINE

state
Regular

N
Y
Expression: UPPER(STATE)
Collate: MACHINE

zip
Regular

N
Y
Expression: UPPER(ZIP)
Collate: MACHINE

Table: au!custdict

Tag Type Caption Desc Sel

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

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

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

word
Regular
Word
N
Y
Expression: WORD
Collate: MACHINE

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

Table: au!custlog

Tag Type Caption Desc Sel

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

cul_pk
Primary
CUL_PK
N
N
Expression: CUL_PK
Collate: MACHINE

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

Table: au!customer

Tag Type Caption Desc Sel

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

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

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

company
Regular

N
Y
Expression: UPPER(COMPANY)
Collate: MACHINE

country
Regular

N
Y
Expression: UPPER(COUNTRY)
Collate: MACHINE

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

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

cus_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

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

cus_recst
Regular

N
Y
Expression: CUS_RECST
Collate: MACHINE

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

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

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

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

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

cust_no
Regular

N
Y
Expression: CUST_NO
Collate: MACHINE

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

email
Regular

N
Y
Expression: UPPER(EMAIL)
Collate: MACHINE

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

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

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

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

ib_number
Regular

N
Y
Expression: UPPER(IB_NUMBER)
Collate: MACHINE

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

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

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

sh_country
Regular

N
Y
Expression: UPPER(SH_COUNTRY)
Collate: MACHINE

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

source
Regular
Source
N
Y
Expression: SOURCE
Collate: MACHINE

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

state
Regular

N
Y
Expression: UPPER(STATE)
Collate: MACHINE

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

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

wphone
Regular

N
Y
Expression: WPHONE
Collate: MACHINE

zip
Regular

N
Y
Expression: UPPER(ZIP)
Collate: MACHINE

Table: au!ebayfees

Tag Type Caption Desc Sel

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

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

Table: au!ebayinv

Tag Type Caption Desc Sel

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

ein_pk
Primary
EIN_PK
N
N
Expression: EIN_PK
Collate: MACHINE

Table: au!expcntrl

Tag Type Caption Desc Sel

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

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

Table: au!filcond

Tag Type Caption Desc Sel

fc_filfk
Regular

N
Y
Expression: FC_FILFK
Collate: MACHINE

fc_pk
Primary

N
Y
Expression: FC_PK
Collate: MACHINE

Table: au!filters

Tag Type Caption Desc Sel

fil_alias
Regular

N
Y
Expression: FIL_ALIAS
Collate: MACHINE

fil_name
Regular

N
Y
Expression: FIL_NAME
Collate: MACHINE

fil_pk
Primary

N
Y
Expression: FIL_PK
Collate: MACHINE

Table: au!generatepk

Tag Type Caption Desc Sel

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

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

Table: au!grower

Tag Type Caption Desc Sel

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

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

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

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

Table: au!history

Tag Type Caption Desc Sel

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

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

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

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

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

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

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

Table: au!index

Tag Type Caption Desc Sel

ind_pk
Primary

N
Y
Expression: IND_PK
Collate: MACHINE

Table: au!interest

Tag Type Caption Desc Sel

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

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

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

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

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

inter1
Regular

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

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

Table: au!invoice

Tag Type Caption Desc Sel

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

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

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

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

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

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

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

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

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

invoice1
Regular

N
Y
Expression: INVOICE
Collate: MACHINE

invoice2
Regular

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

invoice3
Regular

N
Y
Expression: SALE_NO+CUST_NO
Collate: MACHINE

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

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

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

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

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

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

released
Regular
Released
N
Y
Expression: RELEASED
Collate: MACHINE

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

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

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

shipped
Regular
Shipped
N
Y
Expression: SHIPPED
Collate: MACHINE

source
Regular
Source
N
Y
Expression: SOURCE
Collate: MACHINE

Table: au!invpmts

Tag Type Caption Desc Sel

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

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

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

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

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

inp_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

inp_invfk
Regular

N
Y
Expression: INP_INVFK
Collate: MACHINE

inp_pk
Primary

N
Y
Expression: INP_PK
Collate: MACHINE

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

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

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

Table: au!lablset

Tag Type Caption Desc Sel

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

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

Table: au!larchive

Tag Type Caption Desc Sel

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Table: au!lindex

Tag Type Caption Desc Sel

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

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

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

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

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

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

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

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

Table: au!loginhistory

Tag Type Caption Desc Sel

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

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

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

Table: au!lots

Tag Type Caption Desc Sel

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

realized
Regular
Realized
N
Y
Expression: REALIZED
Collate: MACHINE

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

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

salelot
Regular

N
Y
Expression: SALE_NO+LOT_NO
Collate: MACHINE

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

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

Table: au!mailhist

Tag Type Caption Desc Sel

cust_no
Regular

N
Y
Expression: CUST_NO
Collate: MACHINE

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

Table: au!mailing

Tag Type Caption Desc Sel

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

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

Table: au!memoae

Tag Type Caption Desc Sel

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

Table: au!miscinv

Tag Type Caption Desc Sel

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

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

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

miscinv
Regular

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

Table: au!moreap

Tag Type Caption Desc Sel

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

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

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

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

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

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

moreap
Regular

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

Table: au!mxlot

Tag Type Caption Desc Sel

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

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

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

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

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

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

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

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

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

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

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

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

vintage
Regular
Vintage
N
Y
Expression: VINTAGE
Collate: MACHINE

whse
Regular
WareHouse
N
Y
Expression: WHSE
Collate: MACHINE

Table: au!newcust

Tag Type Caption Desc Sel

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

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

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

Table: au!nextlot

Tag Type Caption Desc Sel

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

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

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

Table: au!outbid

Tag Type Caption Desc Sel

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

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

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

outbid
Regular

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

Table: au!paddle

Tag Type Caption Desc Sel

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

pad_cusfk
Regular

N
Y
Expression: PAD_CUSFK
Collate: MACHINE

pad_del
Regular

N
N
Expression: DELETED()
Collate: MACHINE

pad_pk
Primary

N
N
Expression: PAD_PK
Collate: MACHINE

pad_salbfk
Regular

N
Y
Expression: PAD_SALBFK
Collate: MACHINE

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

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

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

Table: au!pbcalls

Tag Type Caption Desc Sel

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

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

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

Table: au!pbfailed

Tag Type Caption Desc Sel

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

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

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

Table: au!pfexport

Tag Type Caption Desc Sel

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

appl_no
Regular

N
Y
Expression: APPL_NO
Collate: MACHINE

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

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

cust_no
Regular

N
Y
Expression: CUST_NO
Collate: MACHINE

date_appl
Regular

N
Y
Expression: DATE_APPL
Collate: MACHINE

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

invoiceno
Regular

N
Y
Expression: INVOICENO
Collate: MACHINE

issued
Regular

N
Y
Expression: ISSUED
Collate: MACHINE

issuedate
Regular

N
Y
Expression: ISSUEDATE
Collate: MACHINE

lot_no
Regular

N
Y
Expression: LOT_NO
Collate: MACHINE

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

pfe_pk
Primary

N
Y
Expression: PFE_PK
Collate: MACHINE

prev_no
Regular

N
Y
Expression: PREV_NO
Collate: MACHINE

sale_no
Regular

N
Y
Expression: SALE_NO
Collate: MACHINE

seq_num
Regular

N
Y
Expression: SEQ_NUM
Collate: MACHINE

subtype
Regular

N
Y
Expression: SUBTYPE
Collate: MACHINE

Table: au!phonebid

Tag Type Caption Desc Sel

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

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

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

Table: au!phrases

Tag Type Caption Desc Sel

allowedt
Regular
Allowedt
N
Y
Expression: ALLOWEDT
Collate: MACHINE

allowtxt
Regular
Allowtxt
N
Y
Expression: ALLOWTXT
Collate: MACHINE

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

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

hotkey
Regular
Hotkey
N
Y
Expression: HOTKEY
Collate: MACHINE

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

txtphrase
Regular
Txtphrase
N
Y
Expression: TXTPHRASE
Collate: MACHINE

Table: au!postview

Tag Type Caption Desc Sel

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

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

invoice
Regular
Invoice
N
Y
Expression: INVOICE
Collate: MACHINE

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

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

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

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

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

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

Table: au!profiles

Tag Type Caption Desc Sel

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

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

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

sale_no
Regular

N
Y
Expression: SALE_NO
Collate: MACHINE

Table: au!profit

Tag Type Caption Desc Sel

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

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

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

Table: au!prtype

Tag Type Caption Desc Sel

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

prtype
Primary
Prtype
N
Y
Expression: PRTYPE
Collate: MACHINE

Table: au!qrystore

Tag Type Caption Desc Sel

qry_pk
Primary

N
Y
Expression: QRY_PK
Collate: MACHINE

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

txt_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

Table: au!readme

Tag Type Caption Desc Sel

rea_pk
Primary

N
Y
Expression: REA_PK
Collate: MACHINE

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

red_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

Table: au!release

Tag Type Caption Desc Sel

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

release1
Regular
Release1
N
Y
Expression: CODE
Collate: MACHINE

release2
Regular
Release2
N
Y
Expression: DESCRIP
Collate: MACHINE

Table: au!reportcatalog

Tag Type Caption Desc Sel

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

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

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

Table: au!returns

Tag Type Caption Desc Sel

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

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

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

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

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

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

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

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

Table: au!salebids

Tag Type Caption Desc Sel

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

cred_no
Regular

N
Y
Expression: UPPER(CRED_NO)
Collate: MACHINE

cust_no
Regular

N
Y
Expression: CUST_NO
Collate: MACHINE

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

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

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

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

sale_no
Regular

N
Y
Expression: SALE_NO
Collate: MACHINE

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

Table: au!sales

Tag Type Caption Desc Sel

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

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

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

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

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

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

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

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

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

Table: au!securityaccess

Tag Type Caption Desc Sel

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

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

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

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

Table: au!shiphist

Tag Type Caption Desc Sel

date
Regular

N
Y
Expression: DATE
Collate: MACHINE

invoice
Regular

N
Y
Expression: INVOICE
Collate: MACHINE

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

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

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

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

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

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

shiphist
Regular

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

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

Table: au!shipping

Tag Type Caption Desc Sel

carrier
Regular
Carrier
N
Y
Expression: CARRIER
Collate: MACHINE

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

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

shipping
Regular

N
Y
Expression: WEIGHT
Collate: MACHINE

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

Table: au!size

Tag Type Caption Desc Sel

literage
Regular
Literage
N
Y
Expression: LITERAGE
Collate: MACHINE

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

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

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

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

Table: au!specinfo

Tag Type Caption Desc Sel

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

spe_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

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

spec_info
Regular
Code
N
Y
Expression: SPEC_INFO
Collate: MACHINE

Table: au!stamps

Tag Type Caption Desc Sel

catcode
Regular
Category
N
Y
Expression: CATEGORY
Collate: MACHINE

category
Regular

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

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

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

gibbons
Regular
Gibbons
N
Y
Expression: GIBBONS
Collate: MACHINE

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

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

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

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

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

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

Table: au!state

Tag Type Caption Desc Sel

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

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

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

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

Table: au!tasting

Tag Type Caption Desc Sel

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

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

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

tas_grofk
Regular

N
Y
Expression: TAS_GROFK
Collate: MACHINE

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

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

vintage
Regular
Vintage
N
Y
Expression: VINTAGE
Collate: MACHINE

Table: au!taxtbl

Tag Type Caption Desc Sel

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

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

sta_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

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

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

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

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

Table: au!tranxtn

Tag Type Caption Desc Sel

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

invoice
Regular
Invoice
N
Y
Expression: INVOICE
Collate: MACHINE

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

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

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

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

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

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

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

Table: au!txtstore

Tag Type Caption Desc Sel

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

txt_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

txt_pk
Primary

N
Y
Expression: TXT_PK
Collate: MACHINE

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

Table: au!upszone

Tag Type Caption Desc Sel

ucarrier
Regular

N
Y
Expression: UCARRIER
Collate: MACHINE

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

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

Table: au!useraccexceptions

Tag Type Caption Desc Sel

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

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

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

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

Table: au!usergroups

Tag Type Caption Desc Sel

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

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

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

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

Table: au!userprefs

Tag Type Caption Desc Sel

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

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

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

Table: au!users

Tag Type Caption Desc Sel

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

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

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

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

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

Table: au!usrgrpxref

Tag Type Caption Desc Sel

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

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

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

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

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

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

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

Table: au!vatcode

Tag Type Caption Desc Sel

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

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

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

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

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

Table: au!vmpri

Tag Type Caption Desc Sel

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

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

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

Table: au!wantlist

Tag Type Caption Desc Sel

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

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

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

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

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

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

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

Table: au!wbids

Tag Type Caption Desc Sel

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

Table: au!wclass

Tag Type Caption Desc Sel

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

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

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

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

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

Table: au!wconvert

Tag Type Caption Desc Sel

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

country
Regular

N
Y
Expression: COUNTRY
Collate: MACHINE

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

cust_no
Regular

N
Y
Expression: CUST_NO
Collate: MACHINE

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

ib_number
Regular

N
Y
Expression: IB_NUMBER
Collate: MACHINE

matchon
Regular

N
Y
Expression: MATCHON
Collate: MACHINE

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

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

zip
Regular

N
Y
Expression: ZIP
Collate: MACHINE

Table: au!weights

Tag Type Caption Desc Sel

code
Regular
Code
N
Y
Expression: CODE
Collate: MACHINE

wgt_del
Regular

N
Y
Expression: DELETED()
Collate: MACHINE

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

Table: au!whse

Tag Type Caption Desc Sel

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

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

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

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

wshipper
Regular

N
Y
Expression: WSHIPPER
Collate: MACHINE

Table: au!wine

Tag Type Caption Desc Sel

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

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

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

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

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

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

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

Table: au!winehx

Tag Type Caption Desc Sel

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

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

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

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

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

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

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

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

Table: au!wineprx

Tag Type Caption Desc Sel

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

vendor
Regular
Vendor
N
Y
Expression: VENDOR
Collate: MACHINE

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

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

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

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

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

Table: au!wlots

Tag Type Caption Desc Sel

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

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

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

Table: au!wreal

Tag Type Caption Desc Sel

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

Table: au!wrealout

Tag Type Caption Desc Sel

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

Table: au!wregi

Tag Type Caption Desc Sel

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

Table: au!wureg

Tag Type Caption Desc Sel

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

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

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

Free Table: catalog

Tag Type Caption Desc Sel

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

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

Free Table: largelot

Tag Type Caption Desc Sel

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

lar_pk
Candidate
Lar Pk
N
Y
Expression: LAR_PK
Collate: MACHINE

lar_xxxfk
Regular
Lar Xxxfk
N
Y
Expression: LAR_XXXFK
Collate: MACHINE

Free Table: lotlabel

Tag Type Caption Desc Sel

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

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

lot_xxxfk
Regular
Lot Xxxfk
N
Y
Expression: LOT_XXXFK
Collate: MACHINE
Field Definitions

Field Definitions

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

Table: au!accttype

# Field Name Type Len Dec Null

1
acc_pk
Integer
4
0
N
Caption: Accout Type Primary Key

2
acc_code
Character
4
0
N
Caption: Code

3
acc_descr
Character
30
0
N
Caption: Account Type Description

4
acc_ref
Character
20
0
N
Caption: Sub Code

5
acc_arcode
Character
6
0
N
Caption: AR Code to total Invoice Payments Into

6
acc_apcode
Character
6
0
N
Caption: AP Code to total Consignor Payments Into

7
acc_glcode
Character
10
0
N
Caption: Acc Glcode

8
last_edit
Date
8
0
N
Caption: Last Edit

9
last_time
Character
6
0
N
Caption: Last Time

10
operator
Character
10
0
N
Caption: Operator
Total record size: 105

Table: au!address

# Field Name Type Len Dec Null

1
add_pk
Integer
4
0
N

2
add_type
Character
4
0
N
Caption: Address Type

3
cust_no
Character
6
0
N
Caption: Customer Number

4
acct_num
Character
8
0
N
Caption: Account Number

5
add_cusfk
Integer
4
0
N
Caption: Customer FK

6
salutation
Character
15
0
N
Caption: Salutation

7
cust_lname
Character
30
0
N
Caption: Last Name

8
cust_fname
Character
20
0
N
Caption: First Name

9
company
Character
40
0
N
Caption: Company

10
attention
Character
40
0
N
Caption: Attention

11
addr1
Character
42
0
N
Caption: Address 1

12
addr2
Character
42
0
N
Caption: Address 2

13
addr3
Character
42
0
N
Caption: Address 3

14
city
Character
25
0
N
Caption: City

15
state
Character
3
0
N
Caption: State

16
county
Character
3
0
N
Caption: County

17
zip
Character
10
0
N
Caption: Zip Code

18
wphone
Character
17
0
N
Caption: Work Phone

19
hphone
Character
17
0
N
Caption: Home Phone

20
fphone
Character
17
0
N
Caption: Fax Phone

21
ophone
Character
17
0
N
Caption: Other Phone

22
cphone
Character
17
0
N
Caption: Cell Phone

23
country
Character
25
0
N
Caption: Country

24
notes
Character
10
0
N
Caption: Notes

25
operator
Character
10
0
N
Caption: Operator

26
last_edit
Date
8
0
N
Caption: Last Edit

27
last_time
Character
6
0
N
Caption: Last Time

28
acct_ship
Character
1
0
N
Caption: Address is Account (A) or Shipping (S)

29
flip_date
Date
8
0
N
Caption: Flip this address on this date

30
old_addr
Character
1
0
N
Caption: This is an Old Address? [Y/N]

31
suffix
Character
25
0
N
Caption: Suffix

32
fullsal
Character
66
0
N
Caption: Fullsal

33
cou_ab
Character
3
0
N
Caption: Country Abbreviation

34
add_coufk
Integer
4
0
N
Caption: Country Foriegn Key
Total record size: 591

Table: au!ap

# Field Name Type Len Dec Null

1
ap_pk
Integer
4
0
N

2
cust_no
Character
6
0
N
Caption: Cust No

3
ap_confk
Integer
4
0
N
Caption: Consignor FK into customer table

4
sale_no
Character
5
0
N
Caption: Sale No

5
ap_salfk
Integer
4
0
N
Caption: Sale Foreign Key

6
date
Date
8
0
N
Caption: Date

7
subamount
Numeric
11
2
N
Caption: SubTotal

8
vat_offer
Character
4
0
N
Caption: Vat Offered

9
vat_refund
Numeric
11
2
N
Caption: Vat Refund

10
vat_lot
Numeric
10
2
N
Caption: VAT Paid on Hammer

11
vat_com
Numeric
11
2
N
Caption: Vat Commission

12
vat_ins
Numeric
11
2
N
Caption: VAT Insurance

13
vat_fees
Numeric
10
2
N
Caption: VAT Charged on Fees

14
buyvattax
Numeric
10
2
N
Caption: Sum of the Vat on Hammer Charged the Buyer

15
consfee
Numeric
10
2
N
Caption: Consignor Fee

16
insfee
Numeric
12
2
N
Caption: Insurance Fee

17
miscfee
Numeric
10
2
N
Caption: Misc Fee

18
amount
Numeric
11
2
N
Caption: Amount

19
paid
Character
1
0
N
Caption: Paid

20
inv_nums
Character
30
0
N
Caption: Invoice Numbers

21
inv_sales
Character
12
0
N
Caption: Inv Sales

22
inv_amount
Numeric
11
2
N
Caption: Inv Amount

23
adv_amount
Numeric
11
2
N
Caption: Advance Amount

24
pay_amount
Numeric
11
2
N
Caption: Pay Amount

25
authorize
Character
20
0
N
Caption: Authorize

26
comments
Memo
4
0
N
Caption: Comments

27
how_paid
Character
20
0
N
Caption: How Paid

28
last_edit
Date
8
0
N
Caption: Last Edit

29
extension
Numeric
11
2
N
Caption: Amount on Extension

30
paidtodate
Numeric
11
2
N
Caption: Paid to Date

31
adjustment
Numeric
11
2
N
Caption: Adjustment Total (Sum of ADJ)

32
netdue
Numeric
11
2
N
Caption: Net Due

33
misccharge
Numeric
11
2
N
Caption: Misccharge (Sum of MISC)

34
int_amount
Numeric
11
2
N
Caption: Interest Amount

35
ref_num
Character
12
0
N
Caption: Reference Number

36
signed
Logical
1
0
N
Caption: Signed

37
cccust_no1
Character
6
0
N
Caption: CC Custno1

38
cccust_no2
Character
6
0
N
Caption: CC Custno2

39
cccust_no3
Character
6
0
N
Caption: CC Custno3

40
cccust_no4
Character
6
0
N
Caption: CC Custno4

41
cccust_no5
Character
6
0
N
Caption: CC Custno5

42
cctype1
Character
1
0
N
Caption: CC Type1

43
cctype2
Character
1
0
N
Caption: CC Type2

44
cctype3
Character
1
0
N
Caption: CC Type3

45
cctype4
Character
1
0
N
Caption: CC Type4

46
cctype5
Character
1
0
N
Caption: CC Type5

47
ap_trans
Character
2
0
N
Caption: AP Trans

48
net_resv
Character
1
0
N
Caption: Net Reserve?

49
cons_perc
Numeric
5
1
N
Caption: Consignor Percentage

50
cons_fixed
Numeric
5
2
N
Caption: Fixed Consignment

51
min_commp
Numeric
6
2
N
Caption: Min Comm Public

52
min_commm
Numeric
6
2
N
Caption: Min Comm Mail

53
no_fees
Logical
1
0
N
Caption: Do not Charge any fees

54
ccons_type
Character
1
0
N
Caption: Consignor Type

55
zero_ins
Character
1
0
N
Caption: Zero Insurance

56
cons_zero
Character
1
0
N
Caption: Consignor Zero

57
waive_fee
Logical
1
0
N
Caption: Waive Fees?

58
min_unsold
Character
1
0
N
Caption: Min Comm for Unsolds

59
ccon_lev1
Numeric
8
0
N
Caption: Con Level 1

60
ccon_perc0
Numeric
5
1
N
Caption: Cons Percent 0

61
ccon_perc1
Numeric
5
1
N
Caption: Cons Percent 0

62
tax_exempt
Logical
1
0
N
Caption: Tax Exempt

63
operator
Character
10
0
N
Caption: Operator

64
last_time
Character
6
0
N
Caption: Last Time

65
last_cons
Date
8
0
N
Caption: Last Cons

66
spec_terms
Character
25
0
N
Caption: Special Terms

67
dealer
Character
1
0
N
Caption: Dealer

68
cons_note
Memo
4
0
N
Caption: Consignment Note

69
contract
Logical
1
0
N
Caption: Contract Signed

70
id_checked
Logical
1
0
N
Caption: Id Checked

71
paymeonce
Logical
1
0
N
Caption: Pay Consignor Only Once

72
percresv
Numeric
3
0
N
Caption: When lotting, Reserve is this Percent of ...

73
releaseno
Character
10
0
N
Caption: Release Order Number

74
released
Character
1
0
N
Caption: Released? [Y/N]

75
rel_date
Date
8
0
N
Caption: Released Date

76
shipped
Character
1
0
N
Caption: Shipped? [Y/N]

77
shipdate
Date
8
0
N
Caption: Shipped Date

78
finder
Character
6
0
N
Caption: Finder Customer No.

79
finder_fee
Numeric
5
1
N
Caption: Finder Fee

80
ret_via
Character
10
0
N
Caption: Ret Via

81
ret_reason
Character
30
0
N
Caption: Ret Reason

82
apwhse
Character
6
0
N
Caption: Default Warehouse Code for this Consignment

83
num_lots
Numeric
5
0
N
Caption: Number of Lots

84
num_cases
Numeric
10
2
N
Caption: Number of Cases

85
sum_low
Numeric
12
2
N
Caption: Sum Low Estimate

86
sum_real
Numeric
12
2
N
Caption: Sum High Estimate

87
sum_rsrv
Numeric
12
2
N
Caption: Sum of the Reserve

88
prop_num
Character
8
0
N
Caption: Property Number

89
ins_perc
Numeric
6
2
N
Caption: Consignor Insurace Percentage

90
unsold_perc
Numeric
6
2
N
Caption: Unsold Commission Percentage

91
min_commpu
Numeric
8
2
N
Caption: Minimum Commission Public Unsold Lot

92
min_commmu
Numeric
8
2
N
Caption: Minimum Commission Mail Unsold Lot

93
chk_paid
Character
1
0
N
Caption: Pay Consignor Only After Invoice has been paid

94
preparer
Character
30
0
N
Caption: Prepared By

95
constosale
Character
5
0
N
Caption: Consigned to Sale

96
revised
Date
8
0
N
Caption: Revised

97
revision
Numeric
3
0
N
Caption: Revision

98
cons_code
Character
4
0
N
Caption: Consignor Type

99
cons_inss
Numeric
5
2
N
Caption: Insurance Percentage for Sold Lots

100
cons_insu
Numeric
5
2
N
Caption: Insurance Percentage for Unsold Lots

101
has_ins
Logical
1
0
N
Caption: Has Own Insurance

102
paycons
Character
1
0
N
Caption: Method of Payment

103
payinstr
Memo
4
0
N
Caption: Payment Instructions

104
internal
Memo
4
0
N
Caption: Internal Notes

105
appraisal
Logical
1
0
N
Caption: Appraisal

106
payafter
Date
8
0
N
Caption: Pay After

107
shipagent
Character
6
0
N
Caption: Shipping Agent (lookup in Customer)

108
aplocked
Character
1
0
N
Caption: AP Record is Locked - Can not be reccalculated

109
manualchk
Logical
1
0
N
Caption: Manual Payment - Do not create automatic transactions

110
sumestcons
Numeric
12
2
N
Caption: Total Estimate to the Consignor

111
sumprice3
Numeric
12
2
N
Caption: Total Cost

112
sumretail
Numeric
12
2
N
Caption: Total Retail Price

113
po
Logical
1
0
N
Caption: Purchase Order

114
vendorinv
Character
20
0
N
Caption: Vendor Invoice Number

115
originalpo
Integer
4
0
N
Caption: Original PO/AP Number

116
daysafter
Numeric
3
0
N
Caption: Pay Days After

117
cntsold
Integer
4
0
N
Caption: Number of Lots Sold

118
cntunsold
Integer
4
0
N
Caption: Number of Lots Unsold

119
cntpassed
Integer
4
0
N
Caption: Number of Passed/Bought In

120
sumpassed
Numeric
12
2
N
Caption: Sum of Passed Lots

121
collfrom
Character
6
0
N
Caption: Collect From

122
cons_percb
Numeric
10
2
N
Caption: Consignor Percentage Break

123
futamount
Numeric
12
2
N
Caption: Future Inventory

124
niwamount
Numeric
12
2
N
Caption: NIW Inventory

125
allowperc
Logical
1
0
N
Caption: Allow Consignor Percent on lots to be different
Total record size: 894

Table: au!apnotes

# Field Name Type Len Dec Null

1
apn_pk
Integer
4
0
N
Caption: Primary Key

2
apn_apfk
Integer
4
0
N
Caption: AP Foreign Key

3
date
Date
8
0
N
Caption: Date

4
note
Character
200
0
N
Caption: Note

5
type
Character
4
0
N
Caption: Type

6
operator
Character
10
0
N
Caption: Operator

7
last_edit
Date
8
0
N
Caption: Last Edit

8
last_time
Character
6
0
N
Caption: Last Time
Total record size: 245

Table: au!appel

# Field Name Type Len Dec Null

1
app_pk
Integer
4
0
N
Caption: Appellation Primary Key

2
app_code
Character
4
0
N
Caption: Appellation Code

3
app_descr
Character
60
0
N
Caption: Appellation Description

4
last_edit
Date
8
0
N
Caption: Last Edit

5
last_time
Character
6
0
N
Caption: Last Time

6
operator
Character
10
0
N
Caption: Operator

7
recdelete
Character
1
0
N
Caption: Recdelete

8
mergeto
Character
4
0
N
Caption: Mergeto
Total record size: 98

Table: au!appinfo

# Field Name Type Len Dec Null

1
app_item
Character
40
0
N
Comments: Application setup/configuration item (Primary Key-no duplicates)

2
app_itemdatatype
Character
1
0
N
Comments: Data type for App_Item (C,N,L,D,T)

3
app_itemvalue
Character
254
0
N
Comments: App_Item value

4
app_itemdescription
Character
254
0
N
Comments: Description of App_Item

5
app_type
Character
1
0
N

6
app_dformat
Character
2
0
N
Caption: Division
Total record size: 553

Table: au!apsort

# Field Name Type Len Dec Null

1
aps_pk
Integer
4
0
N
Caption: AP Sort Primary Key

2
ap_sort
Numeric
4
0
N
Caption: AP Sort for Catalog

3
aps_apfk
Integer
4
0
N
Caption: AP Foreign Key

4
num_lots
Numeric
5
0
N
Caption: Number Lots

5
sum_low
Numeric
12
2
N
Caption: Sum Low

6
sum_real
Numeric
12
2
N
Caption: Sum Real

7
sum_rsrv
Numeric
12
2
N
Caption: Sum Rsrv

8
cat_update
DateTime
8
0
N
Caption: Last Catalog Sort Update

9
cat_oper
Character
8
0
N
Caption: Catalog Update Operator

10
cons_id
Character
10
0
N
Caption: Consignor ID
Total record size: 80

Table: au!araptran

# Field Name Type Len Dec Null

1
ara_pk
Integer
4
0
N

2
ara_apfk
Integer
4
0
N
Caption: AP FK

3
cust_no
Character
6
0
N
Caption: Cust No

4
ara_cusfk
Integer
4
0
N
Caption: Customer FK

5
invoice
Character
6
0
N
Caption: Invoice

6
ara_invfk
Integer
4
0
N
Caption: Invoice FK

7
sale_no
Character
5
0
N
Caption: Sale No

8
ara_salfk
Integer
4
0
N
Caption: Sale Foreign Key

9
jr_type
Character
2
0
N
Caption: Journal Type

10
date
Date
8
0
N
Caption: Date

11
subamount
Numeric
11
2
N

12
buyfee
Numeric
10
2
N
Caption: Buyer's Fee

13
tax
Numeric
9
2
N
Caption: Tax

14
freight
Numeric
9
2
N
Caption: Freight

15
cc_fee
Numeric
9
2
N
Caption: CC Fee

16
consfee
Numeric
11
2
N
Caption: Cons Fee

17
miscfee
Numeric
11
2
N
Caption: Misc Fee

18
amount
Numeric
11
2
N
Caption: Amount

19
late_pay
Numeric
11
2
N
Caption: Late Pay

20
how_paid
Character
40
0
N
Caption: How Paid

21
trseqno
Character
4
0
N
Caption: TR Sequence Number

22
tran_code
Character
4
0
N
Caption: Transaction Code

23
operator
Character
10
0
N
Caption: Operator

24
last_edit
Date
8
0
N
Caption: Last Edit

25
last_time
Character
6
0
N
Caption: Last Time
Total record size: 212

Table: au!bids

# Field Name Type Len Dec Null

1
bid_pk
Integer
4
0
N
Caption: Primary Key

2
bid_salbfk
Integer
4
0
N
Caption: SaleBids Foreign Key

3
cust_no
Character
6
0
N
Caption: Cust No

4
bid_cusfk
Integer
4
0
N
Caption: Customer Foreign Key

5
lot_no
Character
5
0
N
Caption: Lot No

6
bid_lotfk
Integer
4
0
N
Caption: Lots Foreign Key

7
sale_no
Character
5
0
N
Caption: Sale No

8
bid_salfk
Integer
4
0
N
Caption: Sale Foreign Key

9
amount
Numeric
11
2
N
Caption: Amount

10
or_ind
Character
3
0
N
Caption: OR Indicator

11
ignore
Logical
1
0
N
Caption: Ignore

12
comments
Character
40
0
N
Caption: Comments

13
bid
Numeric
11
2
N
Caption: Bid Amount

14
drop
Logical
1
0
N
Caption: Drop

15
date_rcvd
Date
8
0
N
Caption: Date Received

16
time_rcvd
Character
6
0
N
Caption: Time Received

17
rank
Numeric
3
0
N
Caption: Rank

18
last_edit
Date
8
0
N
Caption: Last Edit

19
last_time
Character
6
0
N
Caption: Last Time

20
misc_info
Character
2
0
N
Caption: Misc. Info

21
oth_phone
Character
60
0
N
Caption: Phone Bidder No.

22
operator
Character
10
0
N
Caption: Operator

23
priorbook
Logical
1
0
N
Caption: Priorbook
Total record size: 208

Table: au!btype

# Field Name Type Len Dec Null

1
btp_pk
Integer
4
0
N
Caption: Bottle Type Primary Key

2
btp_code
Character
4
0
N
Caption: Bottle Type Code

3
btp_descr
Character
40
0
N
Caption: Bottle Type Description

4
last_edit
Date
8
0
N
Caption: Last Edit

5
last_time
Character
6
0
N
Caption: Last Time

6
operator
Character
10
0
N
Caption: Operator
Total record size: 73

Table: au!casetype

# Field Name Type Len Dec Null

1
cas_pk
Integer
4
0
N
Caption: Case Type Primary Key

2
cas_code
Character
4
0
N
Caption: Case Type Code

3
cas_descr
Character
40
0
N
Caption: Case Type Description

4
last_edit
Date
8
0
N
Caption: Last Edit

5
last_time
Character
6
0
N
Caption: Last Time

6
operator
Character
10
0
N
Caption: Operator
Total record size: 73

Table: au!category

# Field Name Type Len Dec Null

1
cat_pk
Integer
4
0
N
Caption: Primary Key

2
category
Character
8
0
N
Caption: Category

3
supgroup
Character
40
0
N
Caption: Super Group

4
majgroup
Character
100
0
N
Caption: Major Group

5
descrip
Character
100
0
N
Caption: Description

6
subgroup
Character
100
0
N
Caption: Sub Group

7
last_edit
Date
8
0
N
Caption: Last Edit

8
new_code
Character
7
0
N
Caption: New Code

9
old_code
Character
7
0
N
Caption: Old Code

10
ebay_cat
Character
7
0
N
Caption: eBAY Category

11
ebay_desc
Character
40
0
N
Caption: eBAY Category Description

12
ebay_cat2
Character
7
0
N
Caption: eBAY 2nd Category

13
operator
Character
10
0
N
Caption: Operator

14
last_time
Character
6
0
N
Caption: Last Time

15
perc_alcoh
Numeric
6
2
N
Caption: Percent Alcohol

16
sort_code
Character
10
0
N
Caption: Sort Code

17
webmajgrp
Character
40
0
N
Caption: Category Description to use in Web and Catalog

18
recdelete
Character
1
0
N
Caption: Delete

19
mergeto
Character
7
0
N
Caption: Merge To

20
winecolor
Character
10
0
N
Caption: Wine Color

21
cat_origin
Character
4
0
N
Caption: Country of Origin

22
tasting
Memo
4
0
N
Caption: Tasting note

23
vintage
Character
4
0
N
Caption: Vintage

24
dutyperlit
Numeric
8
4
N
Caption: Duty Per Litre

25
link_to
Character
7
0
N
Caption: Link To

26
longname
Character
100
0
N
Caption: Longname

27
price
Numeric
9
2
N
Caption: Price
Total record size: 655

Table: au!cbserver

# Field Name Type Len Dec Null

1
cbs_pk
Integer
4
0
N
Caption: CBS Server

2
cbs_lotfk
Integer
4
0
N
Caption: Cbs Lotpk

3
sale_no
Character
5
0
N
Caption: Sale No

4
lot_no
Character
5
0
N
Caption: Lot No

5
done
Character
1
0
N
Caption: Done
Total record size: 20

Table: au!conslog

# Field Name Type Len Dec Null

1
con_pk
Integer
4
0
N

2
cust_no
Character
6
0
N
Caption: Customer No.

3
con_cusfk
Integer
4
0
N

4
sale_no
Character
5
0
N
Caption: Sale No.

5
con_salfk
Integer
4
0
N
Caption: Sale Foreign Key

6
cons_num
Character
8
0
N
Caption: Consignment No.

7
date
Date
8
0
N
Caption: Date

8
how_ship
Character
15
0
N
Caption: How Ship

9
size
Character
30
0
N
Caption: Size

10
ins_value
Numeric
9
2
N
Caption: Insurance Value

11
given_to
Character
20
0
N
Caption: Given to

12
last_edit
Date
8
0
N
Caption: Last Edit

13
cons_perc
Numeric
5
1
N
Caption: Consignor Percent

14
date_sale
Character
15
0
N
Caption: Date of Sale

15
owner
Numeric
12
2
N
Caption: Owner

16
estimate
Numeric
12
2
N
Caption: Estimate

17
describe1
Character
40
0
N
Caption: Description of Property

18
charge1
Numeric
11
2
N
Caption: Charges (1)

19
describe2
Character
30
0
N
Caption: Name on Property

20
charge2
Numeric
11
2
N

21
describe3
Character
30
0
N

22
charge3
Numeric
11
2
N

23
describe4
Character
30
0
N

24
charge4
Numeric
11
2
N

25
describe5
Character
30
0
N

26
charge5
Numeric
11
2
N

27
comp_date
Date
8
0
N
Caption: Comp Date

28
cost
Numeric
11
2
N
Caption: Cost

29
est_low
Numeric
11
2
N
Caption: Sum of Price 1

30
est_real
Numeric
11
2
N
Caption: Sum of Price 2

31
est_cons
Numeric
11
2
N
Caption: Sum of Estimate to the Consignor

32
opening
Numeric
11
2
N
Caption: Sum of Opening

33
high_bid
Numeric
11
2
N
Caption: Sum of High Bid

34
realized
Numeric
11
2
N
Caption: Sum of Realized

35
num_lots
Numeric
6
0
N
Caption: Sum of Number of Lots

36
reserve
Numeric
11
2
N
Caption: Sum of Reserve

37
hand_fee
Numeric
11
2
N

38
ttl_sold
Numeric
11
2
N

39
ttl_fees
Numeric
11
2
N

40
real_ytd
Numeric
11
2
N

41
max_bid
Numeric
11
2
N

42
ttl_weight
Numeric
11
2
N

43
operator
Character
10
0
N
Caption: Operator

44
last_time
Character
6
0
N
Caption: Last Time

45
prop_num
Character
8
0
N
Caption: Property Number

46
cons_code
Character
10
0
N
Caption: Consignor Code

47
cat_name
Character
120
0
N
Caption: Catalog Name

48
lot_instr
Memo
4
0
N
Caption: Lotting Instructions

49
sett_instr
Memo
4
0
N
Caption: Settlement Instructions

50
rcvd_by
Character
20
0
N
Caption: Received By

51
prop_notes
Memo
4
0
N
Caption: Internal Property Notes

52
cstatus
Character
2
0
N
Caption: Status

53
cquality
Character
1
0
N
Caption: Quality

54
location
Character
10
0
N
Caption: Location

55
cusfilter
Character
1
0
N
Caption: Custom Filter

56
cost_perc
Numeric
5
1
N
Caption: Last Percentage used to Calculate Cost

57
cost_left
Numeric
12
2
N
Caption: Cost Left

58
cost_fixed
Numeric
12
2
N
Caption: Cost Fixed

59
profitable
Character
1
0
N
Caption: Profitable
Total record size: 779

Table: au!conslogd

# Field Name Type Len Dec Null

1
cld_pk
Integer
4
0
N

2
cust_no
Character
6
0
N
Caption: Customer No.

3
cld_cusfk
Integer
4
0
N

4
cld_confk
Integer
4
0
N
Caption: Consignor Log Foreign Key

5
line_no
Character
5
0
N
Caption: Line No.

6
descrip
Character
60
0
N
Caption: Description

7
prop_num
Character
8
0
N
Caption: Property Number

8
estimate
Numeric
12
2
N
Caption: Estimate

9
reserve
Numeric
11
2
N
Caption: Sum of Reserve

10
sale_type
Character
10
0
N
Caption: Sale Type

11
sale_no
Character
5
0
N
Caption: Actual Sale Number Assigned

12
operator
Character
10
0
N
Caption: Operator

13
last_time
Character
6
0
N
Caption: Last Time

14
last_edit
Date
8
0
N
Caption: Last Edit

15
date_in
Date
8
0
N
Caption: Date In

16
describer
Character
12
0
N
Caption: Describer
Total record size: 174

Table: au!consstat

# Field Name Type Len Dec Null

1
cst_pk
Integer
4
0
N

2
sale_no
Character
5
0
N

3
cst_salfk
Integer
4
0
N
Caption: Sale Foreign Key

4
consignor
Character
6
0
N

5
cst_confk
Integer
4
0
N
Caption: Consignor Foreign Key

6
lots_ttl
Numeric
5
0
N

7
lots_sold
Numeric
5
0
N

8
lots_unsld
Numeric
5
0
N

9
realized
Numeric
11
2
N

10
commission
Numeric
11
2
N

11
clearing
Numeric
11
2
N

12
insurance
Numeric
11
2
N

13
bi_fee
Numeric
11
2
N

14
misc_adj
Numeric
11
2
N

15
shipping
Numeric
11
2
N

16
paidtodate
Numeric
11
2
N

17
amount_pd
Numeric
11
2
N

18
sb_ttl
Numeric
11
2
N

19
sb_sold
Numeric
11
2
N

20
sb_unsold
Numeric
11
2
N
Total record size: 171

Table: au!contacts

# Field Name Type Len Dec Null

1
cts_pk
Integer
4
0
N

2
cts_cusfk
Integer
4
0
N

3
cust_no
Character
6
0
N
Caption: Cust No.

4
date
Date
8
0
N
Caption: Date

5
doneby
Character
10
0
N
Caption: Doneby - Operator who entered this record

6
type
Character
12
0
N
Caption: Type - Via

7
method
Character
12
0
N
Caption: Method of Communication

8
project
Character
8
0
N
Caption: Project

9
descrip
Memo
4
0
N
Caption: Description - Comments

10
next_step
Character
40
0
N
Caption: Next Step - Text Description

11
next_date
Date
8
0
N
Caption: Next Step Date

12
next_time
Character
5
0
N
Caption: Next Step Time

13
complete
Logical
1
0
N
Caption: Complete

14
reason
Character
40
0
N
Caption: Reason for Contact

15
last_edit
Date
8
0
N
Caption: Last Edit

16
last_time
Character
6
0
N
Caption: Last Time

17
operator
Character
10
0
N
Caption: Operator
Total record size: 187

Table: au!country

# Field Name Type Len Dec Null

1
cou_pk
Integer
4
0
N
Caption: Country Primary Key

2
cou_ab
Character
3
0
N
Caption: Country Abbrev.

3
cou_name
Character
25
0
N
Caption: Country Name

4
tax_rate
Numeric
6
3
N
Caption: Tax Rate

5
taxable
Character
1
0
N
Caption: Taxable

6
post_code
Character
10
0
N

7
region
Character
2
0
N
Caption: Region

8
eu
Character
1
0
N
Caption: Eu

9
www_code
Character
10
0
N
Caption: Default WWW Country Suffix

10
language
Character
20
0
N
Caption: Default Language Spoken

11
recdelete
Character
1
0
N
Caption: Delete

12
mergeto
Character
3
0
N
Caption: Mergeto

13
operator
Character
10
0
N
Caption: Operator

14
last_edit
Date
8
0
N
Caption: Last Edit

15
last_time
Character
6
0
N
Caption: Last Time
Total record size: 111

Table: au!credcard

# Field Name Type Len Dec Null

1
cre_pk
Integer
4
0
N

2
cust_no
Character
6
0
N
Caption: Cust No.

3
cre_cusfk
Integer
4
0
N

4
cred_type
Character
5
0
N
Caption: Credit Card Type

5
cred_no
Character
24
0
N
Caption: Card Number

6
cred_name
Character
20
0
N
Caption: Name

7
cred_init
Character
5
0
N
Caption: Init Date

8
cred_exp
Character
5
0
N
Caption: Expiration Date

9
cred_limit
Numeric
7
0
N
Caption: Credit Limit

10
current
Character
1
0
N
Caption: Current?

11
operator
Character
10
0
N
Caption: Operator

12
last_edit
Date
8
0
N
Caption: Last Edit

13
last_time
Character
6
0
N
Caption: Last Time
Total record size: 106

Table: au!credin

# Field Name Type Len Dec Null

1
cin_pk
Integer
4
0
N

2
merchant
Character
12
0
N

3
trans_id
Character
10
0
N

4
card_num
Character
22
0
N

5
exp_date
Character
4
0
N

6
amount1
Character
12
0
N

7
amount2
Character
12
0
N

8
appr_code
Character
6
0
N

9
comments
Character
30
0
N

10
response
Character
16
0
N

11
resp_code
Character
2
0
N

12
trans_num
Character
4
0
N

13
trans_date
Character
6
0
N

14
trans_time
Character
4
0
N

15
trans_code
Character
2
0
N

16
ser_number
Character
8
0
N

17
auth_sourc
Character
1
0
N

18
add_ver
Character
1
0
N

19
trancode
Character
1
0
N

20
acct_sourc
Character
1
0
N

21
id_source
Character
1
0
N

22
void_flag
Character
1
0
N

23
auth_ph
Character
30
0
N

24
auth_sh
Character
30
0
N

25
dep_ph
Character
30
0
N

26
dep_sh
Character
30
0
N

27
card_type
Character
4
0
N

28
key
Character
30
0
N

29
cust_name
Character
30
0
N

30
address
Character
30
0
N

31
city
Character
30
0
N

32
state
Character
2
0
N

33
zipcode
Character
10
0
N

34
phone
Character
20
0
N

35
posted
Logical
1
0
N
Total record size: 438

Table: au!credpost

# Field Name Type Len Dec Null

1
cpo_pk
Integer
4
0
N

2
merchant
Character
10
0
N

3
trans_id
Character
10
0
N

4
card_num
Character
22
0
N

5
exp_date
Character
4
0
N

6
amount1
Character
12
0
N

7
amount2
Character
12
0
N

8
appr_code
Character
6
0
N

9
comments
Character
30
0
N

10
response
Character
16
0
N

11
resp_code
Character
2
0
N

12
trans_num
Character
4
0
N

13
trans_date
Character
6
0
N

14
trans_time
Character
4
0
N

15
trans_code
Character
2
0
N

16
ser_number
Character
8
0
N

17
auth_sourc
Character
1
0
N

18
add_ver
Character
1
0
N

19
trancode
Character
1
0
N

20
acct_sourc
Character
1
0
N

21
id_source
Character
1
0
N

22
void_flag
Character
1
0
N

23
auth_ph
Character
30
0
N

24
auth_sh
Character
30
0
N

25
dep_ph
Character
30
0
N

26
dep_sh
Character
30
0
N

27
card_type
Character
4
0
N

28
key
Character
30
0
N

29
cust_name
Character
30
0
N

30
address
Character
30
0
N

31
city
Character
30
0
N

32
state
Character
2
0
N

33
zipcode
Character
10
0
N

34
phone
Character
20
0
N

35
posted
Logical
1
0
N
Total record size: 436

Table: au!currency

# Field Name Type Len Dec Null

1
cur_pk
Integer
4
0
N
Caption: Primary Key

2
cat_name
Character
40
0
N
Caption: Cat Name

3
code
Character
10
0
N
Caption: Code

4
abbr
Character
10
0
N
Caption: Abbreviation

5
conv_rate
Numeric
10
4
N
Caption: Conversion Rate

6
currency
Character
25
0
N
Caption: Currency

7
lead
Character
1
0
N
Caption: Lead or Trailing

8
operator
Character
10
0
N
Caption: Operator

9
last_edit
Date
8
0
N
Caption: Last Edit

10
last_time
Character
6
0
N
Caption: Last Time

11
beforecat
Character
10
0
N
Caption: # or Other Symbol before Catalog Number
Total record size: 135

Table: au!custarch

# Field Name Type Len Dec Null

1
cus_pk
Integer
4
0
N
Caption: Primary Key

2
cust_no
Character
6
0
N
Caption: Cust No

3
salutation
Character
5
0
N
Caption: Salutation

4
cust_fname
Character
20
0
N
Caption: First Name

5
cust_lname
Character
30
0
N
Caption: Last Name

6
suffix
Character
25
0
N
Caption: Suffix

7
attention
Character
40
0
N
Caption: Attention

8
addr1
Character
42
0
N
Caption: Address Line 1

9
addr2
Character
42
0
N
Caption: Address Line 2

10
addr3
Character
42
0
N
Caption: Address Line 3

11
city
Character
25
0
N
Caption: City

12
state
Character
3
0
N
Caption: State

13
county
Character
3
0
N
Caption: County

14
zip
Character
10
0
N
Caption: Zip

15
wphone
Character
22
0
N
Caption: Work Phone

16
hphone
Character
22
0
N
Caption: Home Phone

17
fphone
Character
22
0
N
Caption: Fax Phone

18
ophone
Character
22
0
N
Caption: Other Phone

19
country
Character
20
0
N
Caption: Country

20
cphone
Character
22
0
N
Caption: Cell Phone

21
cred_no
Character
20
0
N
Caption: Credit Card Number

22
cred_name
Character
20
0
N
Caption: Name on Credit Card

23
cred_init
Character
5
0
N
Caption: Credit Card Init Date

24
cred_exp
Character
5
0
N
Caption: Credit Card Exp Date

25
cred_type
Character
5
0
N
Caption: VISA, MasterCard, etc...

26
cred_limit
Numeric
7
0
N
Caption: Credit Limit

27
ib_number
Character
10
0
N

28
hand_fee
Numeric
11
2
N
Caption: Shipping Fee

29
ttl_weight
Numeric
11
2
N
Caption: Total Weight

30
total_real
Numeric
11
2
N
Caption: Total Realized

31
ttl_sold
Numeric
11
2
N
Caption: Total Sold

32
ttl_fees
Numeric
11
2
N
Caption: Total Fees

33
comments
Memo
4
0
N
Caption: Comments

34
comments2
Memo
4
0
N
Caption: Additional Comments

35
notes
Memo
4
0
N
Caption: Notes

36
cons_note
Memo
4
0
N
Caption: Consignor Note

37
terms
Character
1
0
N
Caption: Payment Terms

38
ship_via
Character
30
0
N
Caption: Ship Via

39
sub_date
Date
8
0
N
Caption: Subscription Date

40
sub_info
Character
6
0
N
Caption: Subscription Information

41
date_real
Date
8
0
N
Caption: Last Date Realized

42
resale_no
Character
12
0
N
Caption: Tax Exempt Resale Number

43
resale_st
Character
3
0
N
Caption: Resale ID State

44
resale_exp
Date
8
0
N
Caption: Resale Number Expiration Date

45
taxable
Character
1
0
N
Caption: Taxable

46
credit1
Character
60
0
N
Caption: Reference 1

47
credit2
Character
60
0
N
Caption: Reference 2

48
credit3
Character
60
0
N
Caption: Reference 3

49
credit4
Character
60
0
N
Caption: Reference 4

50
net_list
Date
8
0
N
Caption: Net Price List Date

51
real_ytd
Numeric
11
2
N
Caption: Bought to Date

52
sold_ytd
Numeric
11
2
N
Caption: Sold to Date

53
interest
Character
54
0
N

54
last_edit
Date
8
0
N
Caption: Last Edited

55
last_time
Character
6
0
N
Caption: Last Time Edited

56
operator
Character
10
0
N
Caption: Operator who last edited

57
creator
Character
10
0
N
Caption: Record Created by

58
spec_info
Character
10
0
N
Caption: Special Info

59
credit
Numeric
9
2
N
Caption: Credit Balance

60
tax_rate
Numeric
6
3
N
Caption: Tax Rate

61
net_resv
Character
1
0
N
Caption: Net Reserve

62
cons_perc
Numeric
4
1
N
Caption: Consignor Percentage

63
add_date
Date
8
0
N
Caption: Added to File

64
ship1
Character
40
0
N
Caption: Shipping Lable Line 1

65
ship2
Character
40
0
N
Caption: Shipping Lable Line 2

66
ship3
Character
40
0
N
Caption: Shipping Lable Line 3

67
ship4
Character
40
0
N
Caption: Shipping Lable Line 4

68
ship5
Character
40
0
N
Caption: Shipping Lable Line 5

69
date_under
Date
8
0
N
Caption: Last Date was an Underbidder

70
mail_flag
Character
4
0
N
Caption: Mail Flag

71
email_flag
Character
4
0
N
Caption: eMail Flag

72
cons_fixed
Numeric
5
2
N
Caption: ?

73
min_commp
Numeric
6
2
N
Caption: Minimum Commission Public Sale

74
min_commm
Numeric
6
2
N
Caption: Minimum Commission Mail Sale

75
no_fees
Logical
1
0
N
Caption: Do Not Charge Any Consignor Fees

76
ccons_type
Character
1
0
N
Caption: Consignor Type

77
zero_ins
Character
1
0
N
Caption: Do not charge for Insurance

78
busaddr
Character
1
0
N
Caption: Address is Business

79
tax_exempt
Logical
1
0
N
Caption: Tax Exempt

80
password
Character
8
0
N
Caption: Topspeed Password

81
email
Character
65
0
N
Caption: eMail Address

82
email2
Character
65
0
N
Caption: 2nd eMail Address

83
remove
Character
1
0
N
Caption: Remove from eMail Lists

84
ph_atten
Character
40
0
N
Caption: Phone Attention

85
house
Character
1
0
N
Caption: Customer is House Bidder

86
balcur
Numeric
10
2
N
Caption: Current Balance

87
bal30
Numeric
10
2
N
Caption: 30 Day Balance

88
bal60
Numeric
10
2
N
Caption: 60 Day Balance

89
bal90
Numeric
10
2
N
Caption: 90 Day Balance

90
bal91
Numeric
10
2
N
Caption: Over 90 day balance

91
flag_hist
Character
50
0
N
Caption: Mail Flag History

92
ttl_netdue
Numeric
12
2
N

93
handle
Character
20
0
N
Caption: SAN Handle

94
approved
Character
1
0
N
Caption: SAN Approved

95
cus_recst
Character
1
0
N
Caption: Record State

96
bbr_number
Character
10
0
N
Caption: 2nd Interface Number

97
cus_coufk
Integer
4
0
N
Caption: Country Foreign Key

98
cou_ab
Character
3
0
N
Caption: Country Code

99
email_type
Character
1
0
N
Caption: Email Type

100
mark_type
Character
1
0
N
Caption: Promotional Materials Type

101
fullsal
Character
65
0
N
Caption: Full Salutation (Complete Replacement)

102
finder
Character
6
0
N
Caption: Finder Customer Number

103
finder_fee
Numeric
5
1
N
Caption: Finder Fee

104
ship_state
Character
3
0
N
Caption: Ship State

105
company
Character
65
0
N
Caption: Company

106
position
Character
65
0
N
Caption: Position

107
vat_number
Character
15
0
N
Caption: Vat Number

108
cons_code
Character
4
0
N
Caption: Consignor Fee Struction Type

109
agent
Character
35
0
N
Caption: Bidding Agent

110
fedtaxid
Character
12
0
N
Caption: Federal Tax ID

111
cons_inss
Numeric
5
2
N
Caption: Insurance Percentage Sold Lots

112
cons_insu
Numeric
5
2
N
Caption: Insurance Percentage Unsold Lots

113
ins_waived
Logical
1
0
N
Caption: Insurance Waived

114
sh_city
Character
25
0
N
Caption: Shipping City

115
sh_state
Character
3
0
N
Caption: Shipping State

116
sh_zip
Character
10
0
N
Caption: Shipping Zip

117
sh_country
Character
20
0
N
Caption: Shipping Country

118
sh_cou_ab
Character
3
0
N
Caption: Shipping Country Abbreviation

119
sh_coufk
Integer
4
0
N
Caption: Shipping Country Foreign Key

120
sub_cost
Numeric
6
2
N
Caption: Subscription Cost

121
sh_county
Character
3
0
N
Caption: Shipping County
Total record size: 1975

Table: au!custdict

# Field Name Type Len Dec Null

1
cd_pk
Integer
4
0
N
Caption: Cust.Dict. PK

2
word
Character
30
0
N
Caption: Word

3
lastupdt
DateTime
8
0
N
Caption: Last Updated

4
operator
Character
10
0
N
Caption: User ID
Total record size: 53

Table: au!custlog

# Field Name Type Len Dec Null

1
cul_pk
Integer
4
0
N

2
cul_cusfk
Integer
4
0
N

3
cust_no
Character
6
0
N

4
date
Date
8
0
N

5
name
Character
30
0
N

6
credit
Numeric
10
2
N

7
balance
Numeric
10
2
N

8
operator
Character
10
0
N

9
custact
Character
8
0
N
Total record size: 91

Table: au!customer

# Field Name Type Len Dec Null

1
cus_pk
Integer
4
0
N
Caption: Primary Key

2
cust_no
Character
6
0
N
Caption: Cust No

3
salutation
Character
20
0
N
Caption: Salutation

4
cust_fname
Character
20
0
N
Caption: First Name

5
cust_lname
Character
30
0
N
Caption: Last Name

6
suffix
Character
40
0
N
Caption: Suffix

7
attention
Character
40
0
N
Caption: Attention

8
addr1
Character
42
0
N
Caption: Address Line 1

9
addr2
Character
42
0
N
Caption: Address Line 2

10
addr3
Character
42
0
N
Caption: Address Line 3

11
city
Character
25
0
N
Caption: City

12
state
Character
3
0
N
Caption: State

13
county
Character
3
0
N
Caption: County

14
zip
Character
10
0
N
Caption: Zip

15
wphone
Character
22
0
N
Caption: Work Phone

16
hphone
Character
22
0
N
Caption: Home Phone

17
fphone
Character
22
0
N
Caption: Fax Phone

18
ophone
Character
22
0
N
Caption: Other Phone

19
country
Character
25
0
N
Caption: Country

20
cphone
Character
22
0
N
Caption: Cell Phone

21
cred_no
Character
24
0
N
Caption: Credit Card Number

22
cred_name
Character
20
0
N
Caption: Name on Credit Card

23
cred_init
Character
5
0
N
Caption: Credit Card Init Date

24
cred_exp
Character
5
0
N
Caption: Credit Card Exp Date

25
cred_type
Character
5
0
N
Caption: VISA, MasterCard, etc...

26
cred_limit
Numeric
8
0
N
Caption: Credit Limit

27
ib_number
Character
10
0
N

28
hand_fee
Numeric
11
2
N
Caption: Shipping Fee

29
ttl_weight
Numeric
11
2
N
Caption: Total Weight

30
total_real
Numeric
11
2
N
Caption: Total Realized

31
ttl_sold
Numeric
11
2
N
Caption: Total Sold

32
ttl_fees
Numeric
11
2
N
Caption: Total Fees

33
comments
Memo
4
0
N
Caption: Comments

34
comments2
Memo
4
0
N
Caption: Additional Comments

35
notes
Memo
4
0
N
Caption: Notes

36
cons_note
Memo
4
0
N
Caption: Consignor Note

37
terms
Character
1
0
N
Caption: Payment Terms

38
ship_via
Character
30
0
N
Caption: Ship Via

39
sub_date
Date
8
0
N
Caption: Subscription Date

40
sub_info
Character
8
0
N
Caption: Subscription Information

41
date_real
Date
8
0
N
Caption: Last Date Realized

42
resale_no
Character
16
0
N
Caption: Tax Exempt Resale Number

43
resale_st
Character
3
0
N
Caption: Resale ID State

44
resale_exp
Date
8
0
N
Caption: Resale Number Expiration Date

45
taxable
Character
1
0
N
Caption: Taxable

46
credit1
Character
60
0
N
Caption: Reference 1

47
credit2
Character
60
0
N
Caption: Reference 2

48
credit3
Character
60
0
N
Caption: Reference 3

49
credit4
Character
60
0
N
Caption: Reference 4

50
net_list
Date
8
0
N
Caption: Net Price List Date

51
real_ytd
Numeric
11
2
N
Caption: Bought to Date

52
sold_ytd
Numeric
11
2
N
Caption: Sold to Date

53
interest
Character
54
0
N

54
real_12
Numeric
11
2
N
Caption: Bought Last 12 Months

55
sold_12
Numeric
11
2
N
Caption: Sold Last 12 Months

56
last_edit
Date
8
0
N
Caption: Last Edited

57
last_time
Character
6
0
N
Caption: Last Time Edited

58
operator
Character
10
0
N
Caption: Operator who last edited

59
creator
Character
10
0
N
Caption: Record Created by

60
spec_info
Character
10
0
N
Caption: Special Info

61
credit
Numeric
9
2
N
Caption: Credit Balance

62
tax_rate
Numeric
6
3
N
Caption: Tax Rate

63
tax_gst
Numeric
6
3
N
Caption: Tax Gst

64
net_resv
Character
1
0
N
Caption: Net Reserve

65
cons_perc
Numeric
4
1
N
Caption: Consignor Percentage

66
add_date
Date
8
0
N
Caption: Added to File

67
ship1
Character
40
0
N
Caption: Shipping Lable Line 1

68
ship2
Character
40
0
N
Caption: Shipping Lable Line 2

69
ship3
Character
40
0
N
Caption: Shipping Lable Line 3

70
ship4
Character
40
0
N
Caption: Shipping Lable Line 4

71
ship5
Character
40
0
N
Caption: Shipping Lable Line 5

72
date_under
Date
8
0
N
Caption: Last Date was an Underbidder

73
mail_flag
Character
4
0
N
Caption: Mail Flag

74
email_flag
Character
4
0
N
Caption: eMail Flag

75
cons_fixed
Numeric
5
2
N
Caption: ?

76
min_commp
Numeric
6
2
N
Caption: Minimum Commission Public Sale

77
min_commm
Numeric
6
2
N
Caption: Minimum Commission Mail Sale

78
no_fees
Logical
1
0
N
Caption: Do Not Charge Any Consignor Fees

79
ccons_type
Character
1
0
N
Caption: Consignor Type

80
zero_ins
Character
1
0
N
Caption: Do not charge for Insurance

81
busaddr
Character
1
0
N
Caption: Address is Business

82
tax_exempt
Logical
1
0
N
Caption: Tax Exempt

83
password
Character
8
0
N
Caption: Topspeed Password

84
email
Character
65
0
N
Caption: eMail Address

85
email2
Character
65
0
N
Caption: 2nd eMail Address

86
remove
Character
1
0
N
Caption: Remove from eMail Lists

87
ph_atten
Character
40
0
N
Caption: Phone Attention

88
house
Character
1
0
N
Caption: Customer is House Bidder

89
balcur
Numeric
10
2
N
Caption: Current Balance

90
bal30
Numeric
10
2
N
Caption: 30 Day Balance

91
bal60
Numeric
10
2
N
Caption: 60 Day Balance

92
bal90
Numeric
10
2
N
Caption: 90 Day Balance

93
bal91
Numeric
10
2
N
Caption: Over 90 day balance

94
flag_hist
Character
50
0
N
Caption: Mail Flag History

95
ttl_netdue
Numeric
12
2
N

96
handle
Character
40
0
N
Caption: SAN Handle

97
approved
Character
1
0
N
Caption: SAN Approved

98
cus_recst
Character
1
0
N
Caption: Record State

99
bbr_number
Character
10
0
N
Caption: 2nd Interface Number

100
cus_coufk
Integer
4
0
N
Caption: Country Foreign Key

101
cou_ab
Character
3
0
N
Caption: Country Code

102
email_type
Character
1
0
N
Caption: Email Type

103
mark_type
Character
1
0
N
Caption: Promotional Materials Type

104
fullsal
Character
65
0
N
Caption: Full Salutation (Complete Replacement)

105
finder
Character
6
0
N
Caption: Finder Customer Number

106
finder_fee
Numeric
5
1
N
Caption: Finder Fee

107
ship_state
Character
3
0
N
Caption: Ship State

108
company
Character
65
0
N
Caption: Company

109
position
Character
65
0
N
Caption: Position

110
vat_number
Character
20
0
N
Caption: Vat Number

111
cons_code
Character
4
0
N
Caption: Consignor Fee Struction Type

112
agent
Character
35
0
N
Caption: Bidding Agent

113
fedtaxid
Character
12
0
N
Caption: Federal Tax ID

114
cons_inss
Numeric
5
2
N
Caption: Insurance Percentage Sold Lots

115
cons_insu
Numeric
5
2
N
Caption: Insurance Percentage Unsold Lots

116
ins_waived
Logical
1
0
N
Caption: Insurance Waived

117
sh_city
Character
25
0
N
Caption: Shipping City

118
sh_state
Character
3
0
N
Caption: Shipping State

119
sh_county
Character
3
0
N
Caption: Shipping County

120
sh_zip
Character
10
0
N
Caption: Shipping Zip

121
sh_country
Character
25
0
N
Caption: Shipping Country

122
sh_cou_ab
Character
3
0
N
Caption: Shipping Country Abbreviation

123
sh_coufk
Integer
4
0
N
Caption: Shipping Country Foreign Key

124
sub_cost
Numeric
6
2
N
Caption: Subscription Cost

125
unsold_perc
Numeric
7
2
N
Caption: Unsold Commision Percentage

126
min_commpu
Numeric
7
2
N
Caption: Minimum Commission Public Unsold

127
min_commmu
Numeric
7
2
N
Caption: Minimum Commision Mail Unsold

128
ccon_lev1
Numeric
5
0
N
Caption: Break Commission at this Amount

129
ccon_perc0
Numeric
5
1
N
Caption: Consignor Percent Up to this level

130
ccon_perc1
Numeric
5
1
N
Caption: Consignor Percent After this level

131
custom1
Character
20
0
N
Caption: Custom Field 1

132
sales_mgr
Character
20
0
N
Caption: Sales Mgr

133
sales_rep
Character
20
0
N
Caption: Sales Rep

134
emessage
Memo
4
0
N
Caption: email Message

135
dns_all
Logical
1
0
N
Caption: Do Not Send Anything

136
dns_a
Logical
1
0
N
Caption: Do Not Send Announcements

137
dns_cc
Logical
1
0
N
Caption: Do Not Send Consignor Correspondence

138
dns_cats
Logical
1
0
N
Caption: Do Not Send Catalogs / Custom Catalogs

139
dns_bid
Logical
1
0
N
Caption: Do Not Send Bid Confirmations

140
dns_ob
Logical
1
0
N
Caption: Do Not Send Out Bid Notices

141
dns_inv
Logical
1
0
N
Caption: Do Not Send Invoices

142
dns_invp
Logical
1
0
N
Caption: DNS Paper Invoice

143
dns_pr
Logical
1
0
N
Caption: Do Not Send Prices Realized (General)

144
dns_cpr
Logical
1
0
N
Caption: Do Not Send Custom Prices Realized

145
dns_s
Logical
1
0
N
Caption: Do Not Send Statements / Dunning Letters

146
id_checked
Logical
1
0
N
Caption: Id Checked

147
sh_wphone
Character
22
0
N
Caption: Shipping Address Phone

148
sh_fphone
Character
22
0
N
Caption: Shipping Fax Phone

149
cusfilter
Character
1
0
N
Caption: Customer Filter

150
birthdate
Date
8
0
N
Caption: Birth Date

151
cust_idno
Character
12
0
N
Caption: Customer ID Number (Drivers Licence/Passport)

152
ship_zone
Character
4
0
N
Caption: Ship Zone

153
website
Character
60
0
N
Caption: Website

154
source
Character
20
0
N
Caption: Source

155
rating
Character
2
0
N
Caption: Rating of Client/Prospect

156
cust_type
Character
30
0
N
Caption: Customer Type

157
cust_stat
Character
20
0
N
Caption: Cust Stat

158
events
Character
10
0
N
Caption: Events

159
subsource
Character
10
0
N
Caption: Subsource

160
gifting
Character
20
0
N
Caption: Gifting

161
max_invoice
Numeric
11
2
N
Caption: Largest Invoice

162
sales_hist
Memo
4
0
N
Caption: Sales History

163
last_bid
Date
8
0
N
Caption: Last Bid

164
last_buy
Date
8
0
N
Caption: Last Buy

165
last_cons
Date
8
0
N
Caption: Last Cons

166
div1
Logical
1
0
N
Caption: Division 1

167
div2
Logical
1
0
N
Caption: Division 2

168
div3
Logical
1
0
N
Caption: Division 3

169
div4
Logical
1
0
N
Caption: Division 4

170
pnotes
Memo
4
0
N
Caption: Partner Notes

171
pconfident
Memo
4
0
N
Caption: Partner Confidential Notes

172
btotal
Numeric
12
2
N
Caption: Partner Buying Total

173
stotal
Numeric
12
2
N
Caption: Partner Selling Total
Total record size: 2507

Table: au!ebayfees

# Field Name Type Len Dec Null

1
eba_pk
Integer
4
0
N

2
sale_no
Character
5
0
N

3
lot_no
Character
5
0
N

4
ebay_id
Character
10
0
N

5
date
Date
8
0
N

6
amount
Numeric
9
2
N

7
type
Character
20
0
N

8
consignor
Character
6
0
N
Total record size: 68

Table: au!ebayinv

# Field Name Type Len Dec Null

1
ein_pk
Integer
4
0
N

2
item
Character
10
0
N

3
price
Numeric
8
2
N

4
descrip
Character
50
0
N

5
email
Character
60
0
N

6
date
Date
8
0
N

7
ebay_id
Character
80
0
N

8
sold
Character
1
0
N
Total record size: 222

Table: au!expcntrl

# Field Name Type Len Dec Null

1
exp_pk
Integer
4
0
N

2
sale1
Character
4
0
N

3
sale2
Character
4
0
N

4
sale3
Character
4
0
N

5
sale4
Character
4
0
N

6
sale5
Character
4
0
N

7
sale6
Character
4
0
N

8
open1
Character
1
0
N

9
open2
Character
1
0
N

10
open3
Character
1
0
N

11
open4
Character
1
0
N

12
open5
Character
1
0
N

13
open6
Character
1
0
N

14
iweb_date
Date
8
0
N
Caption: Iweb Date

15
iweb_time
Character
6
0
N
Caption: Iweb Time

16
uweb_date
Date
8
0
N
Caption: Uweb Date

17
uweb_time
Character
6
0
N
Caption: Uweb Time

18
dformat
Character
2
0
N
Caption: Division
Total record size: 65

Table: au!filcond

# Field Name Type Len Dec Null

1
fc_pk
Integer
4
0
N

2
fc_filfk
Integer
4
0
N

3
fc_seq
Numeric
2
0
N

4
fc_join
Character
8
0
N

5
fc_alias
Character
20
0
N

6
fc_fname
Character
40
0
N

7
fc_fdesc
Character
40
0
N

8
fc_ftype
Character
1
0
N

9
fc_not
Logical
1
0
N

10
fc_case
Logical
1
0
N

11
fc_oper
Character
1
0
N

12
fc_values
Memo
4
0
N

13
fc_close
Character
10
0
N
Total record size: 137

Table: au!filters

# Field Name Type Len Dec Null

1
fil_pk
Integer
4
0
N

2
fil_type
Character
1
0
N

3
fil_name
Character
50
0
N
Caption: Filter Name

4
fil_alias
Character
20
0
N
Caption: Primary Alias

5
fil_heading
Memo
4
0
N
Caption: Fil Heading

6
fil_usehdg
Logical
1
0
N
Caption: Fil Usehdg

7
fil_notes
Memo
4
0
N

8
fil_advanced
Memo
4
0
N
Caption: Advanced Filter Condition
Total record size: 89

Table: au!generatepk

# Field Name Type Len Dec Null

1
gpk_pk
Character
128
0
N
Caption: Primary Key
Comments: TableName for which to generate PKs

2
gpk_currentnumber
Integer
4
0
N
Caption: Current PK
Comments: Current PK Number in use

3
gpk_currentalpha
Character
5
0
N
Caption: Current AlphaNumeric PK
Comments: Current AlphaNumeric PK in use
Total record size: 138

Table: au!grower

# Field Name Type Len Dec Null

1
gro_pk
Integer
4
0
N
Caption: Grower Primary Key

2
gro_code
Character
4
0
N
Caption: Grower Code

3
gro_descr
Character
60
0
N
Caption: Grower Description

4
last_edit
Date
8
0
N
Caption: Last Edit

5
last_time
Character
6
0
N
Caption: Last Time

6
operator
Character
10
0
N
Caption: Operator

7
notes
Memo
4
0
N
Caption: Grower Notes

8
gcat_note
Memo
4
0
N
Caption: Grower Catalog Note

9
recdelete
Character
1
0
N
Caption: Delete

10
mergeto
Character
4
0
N
Caption: Mergeto

11
link_to
Character
7
0
N
Caption: Link To Other Field
Total record size: 113

Table: au!handheld

# Field Name Type Len Dec Null

1
oid
Integer
4
0
N
Caption: Handheld Unique ID

2
cust_no
Character
6
0
N

3
consignor
Character
6
0
N

4
category
Character
8
0
N

5
sale_no
Character
5
0
N

6
invoice
Character
6
0
N

7
lot_no
Character
5
0
N

8
win_code
Character
5
0
N

9
photo
Character
1
0
N

10
est_low
Numeric
11
2
N

11
est_real
Numeric
11
2
N

12
price3
Numeric
11
4
N

13
est_code
Character
1
0
N

14
est_cons
Numeric
11
2
N

15
seq_num
Character
6
0
N

16
prop_num
Character
8
0
N

17
cons_num
Character
12
0
N

18
number_lot
Numeric
6
0
N

19
qty2
Numeric
5
0
N

20
qty3
Numeric
6
0
N

21
loc1
Character
6
0
N

22
loc2
Character
5
0
N

23
loc3
Character
5
0
N

24
add_date
Date
8
0
N

25
operator
Character
10
0
N

26
last_edit
Date
8
0
N

27
last_time
Character
6
0
N

28
ref_num
Character
30
0
N

29
case_no
Character
10
0
N

30
location
Character
10
0
N
Total record size: 233

Table: au!history

# Field Name Type Len Dec Null

1
his_pk
Integer
4
0
N

2
cust_no
Character
6
0
N

3
his_buyfk
Integer
4
0
N
Caption: Buyer FK

4
consignor
Character
6
0
N

5
his_confk
Integer
4
0
N
Caption: Consignor FK

6
category
Character
8
0
N

7
his_catfk
Integer
4
0
N
Caption: Category Foreign Key

8
sale_no
Character
5
0
N

9
his_salfk
Integer
4
0
N
Caption: Sale Foreign Key

10
lot_no
Character
5
0
N

11
his_lotfk
Integer
4
0
N
Caption: Lot Foreign Key

12
condition
Character
8
0
N

13
cons_num
Character
6
0
N

14
descrip
Character
250
0
N

15
notes
Character
20
0
N

16
srtorder
Character
20
0
N

17
est_low
Numeric
11
2
N

18
est_real
Numeric
11
2
N

19
realized
Numeric
11
2
N

20
high_bid
Numeric
11
2
N

21
topics
Character
56
0
N

22
reserve
Numeric
11
2
N

23
date_sold
Date
8
0
N

24
seq_num
Character
6
0
N

25
ref_num
Character
15
0
N

26
his_imagef
Character
25
0
N
Caption: Image File Name
Total record size: 524

Table: au!index

# Field Name Type Len Dec Null

1
ind_pk
Integer
4
0
N
Caption: Ind Pk

2
lin_pk
Integer
4
0
N

3
lot_no
Character
5
0
N

4
lin_lotfk
Integer
4
0
N

5
sale_no
Character
5
0
N

6
lin_salfk
Integer
4
0
N
Caption: Sale Foreign Key

7
category
Character
7
0
N

8
lin_catfk
Integer
4
0
N
Caption: Category Foreign Key

9
index_type
Character
1
0
N

10
keyword
Character
40
0
N

11
seq_num
Character
7
0
N

12
last_edit
Date
8
0
N
Total record size: 94

Table: au!interest

# Field Name Type Len Dec Null

1
int_pk
Integer
4
0
N

2
cust_no
Character
6
0
N
Caption: Cust No

3
int_cusfk
Integer
4
0
N
Caption: Customer FK

4
collects
Character
30
0
N
Caption: Collects

5
last_edit
Date
8
0
N
Caption: Last Edit

6
level
Character
1
0
N
Caption: Level

7
num_lots
Numeric
5
0
N
Caption: Number of Lots

8
buy_total
Numeric
9
0
N
Caption: Total Purchased

9
ib_number
Character
6
0
N

10
operator
Character
10
0
N
Caption: Operator

11
last_time
Character
6
0
N
Caption: Last Time

12
int_type
Character
1
0
N
Caption: Interest Type M-Mail, C-Collects, W-Want
Total record size: 91

Table: au!invoice

# Field Name Type Len Dec Null

1
inv_pk
Integer
4
0
N
Caption: Invoice Primary Key

2
invoice
Character
6
0
N
Caption: Invoice No.

3
cust_no
Character
6
0
N
Caption: Customer No.

4
inv_cusfk
Integer
4
0
N
Caption: Customer Foreign Key

5
sale_no
Character
5
0
N
Caption: Sale No.

6
inv_salfk
Integer
4
0
N
Caption: Sale Foreign Key

7
date
Date
8
0
N
Caption: Invoice Date

8
subamount
Numeric
11
2
N
Caption: Sub Total of Hammer

9
cogsamount
Numeric
11
2
N
Caption: Cost of Goods Sold

10
cocmamount
Numeric
12
2
N
Caption: Cost of Consigned Material

11
returns
Numeric
11
2
N
Caption: Returns Subtotal

12
ret_qty
Numeric
4
0
N
Caption: Returns Quantity

13
texempt
Numeric
11
2
N
Caption: Tax Exempt Total

14
bidder_fee
Numeric
11
2
N
Caption: Bidders Premium Percentage

15
buyfee
Numeric
11
2
N
Caption: Amount of the Buyer's Premium

16
tax
Numeric
11
2
N
Caption: Tax Amount (or Sum of Hammer Vats)

17
tax_unpaid
Numeric
11
2
N
Caption: Tax Unpaid

18
taxgst
Numeric
11
2
N
Caption: Taxgst

19
prem_tax
Numeric
11
2
N
Caption: VAT Tax on Buyer's Premium (sum of Lots.Prem_Tax)

20
vat_taxs
Numeric
11
2
N
Caption: Vat Tax on Shipping

21
duty
Numeric
11
2
N
Caption: Duty

22
zero_tax
Logical
1
0
N
Caption: Zero Tax

23
freight
Numeric
11
2
N
Caption: Freight (Shipping and Handling)

24
cc_fee
Numeric
10
2
N
Caption: Credit Card Fee

25
expert
Numeric
11
2
N
Caption: Expert Fees

26
late_pay
Numeric
10
2
N
Caption: Late Payment Charge

27
discount
Numeric
6
2
N
Caption: Invoice Discount

28
ins_perc
Numeric
6
3
N
Caption: Insurance Percentage

29
insurance
Numeric
11
2
N
Caption: Insurance Amount

30
buyer_misc
Numeric
11
2
N
Caption: Sum of Miscellaneous Buyer Charges

31
credit
Numeric
11
2
N
Caption: Credit Amount

32
amount
Numeric
11
2
N
Caption: Total Amount of Invoice

33
paid
Character
1
0
N
Caption: Paid Status

34
amount_pd
Numeric
11
2
N
Caption: Total Amount Paid

35
date_paid
Date
8
0
N
Caption: Date Paid

36
how_paid
Character
20
0
N
Caption: How Paid

37
authorize
Character
20
0
N
Caption: Authorized by

38
comments
Memo
4
0
N
Caption: Comments to Print on Invoice

39
sales_rep
Character
20
0
N
Caption: Sales Rep

40
last_edit
Date
8
0
N
Caption: Last Edited

41
notes
Memo
4
0
N
Caption: Notes (Internal Use)

42
pickedup
Character
1
0
N
Caption: Picked Up

43
paddle
Character
4
0
N
Caption: Paddle No.

44
export
Character
1
0
N
Caption: Import Export

45
combo
Logical
1
0
N
Caption: Combination Invoice (has miscellaneous)

46
soldtime
Character
14
0
N
Caption: Sold Time

47
terms
Character
2
0
N
Caption: Payment Terms

48
cred_no
Character
24
0
N
Caption: Credit Card No.

49
cred_exp
Character
5
0
N
Caption: Credit Card Expiration Date

50
cred_type
Character
5
0
N
Caption: Credit Card Type

51
lineitems
Numeric
4
0
N
Caption: Line Items

52
weight
Numeric
7
1
N
Caption: Total Weight

53
ttlcases
Numeric
10
2
N
Caption: Ttlcases

54
ship_via
Character
30
0
N
Caption: Ship Via (Shipping Method)

55
operator
Character
10
0
N
Caption: Operator

56
last_time
Character
6
0
N
Caption: Last Time

57
shipspec
Character
20
0
N
Caption: Special Shipping

58
released
Character
1
0
N
Caption: Released

59
rel_date
Date
8
0
N
Caption: Release Date

60
rel_by
Character
20
0
N
Caption: Released By

61
rel_prntd
Character
1
0
N
Caption: Release Order Printed

62
shipped
Character
1
0
N
Caption: Shipped

63
ship_date
Date
8
0
N
Caption: Ship Date

64
tax_rate
Numeric
6
3
N
Caption: Tax Rate

65
tax_gst
Numeric
6
3
N
Caption: Tax Gst

66
taxable
Character
1
0
N
Caption: Taxable

67
ship1
Character
50
0
N
Caption: Ship to Address 1

68
ship2
Character
50
0
N
Caption: Ship to Address 2

69
ship3
Character
50
0
N
Caption: Ship to Address 3

70
ship4
Character
50
0
N
Caption: Ship to Address 4

71
ship5
Character
50
0
N
Caption: Ship to Address 5

72
tax_state
Character
3
0
N
Caption: Tax State

73
tax_cntry
Character
20
0
N
Caption: Tax Country

74
sh_city
Character
25
0
N
Caption: Sh City

75
sh_county
Character
3
0
N
Caption: Shipping County

76
sh_state
Character
3
0
N
Caption: Ship State

77
sh_zip
Character
10
0
N
Caption: Sh Zip

78
sh_cou_ab
Character
3
0
N
Caption: Shipping Country Abreviation

79
sh_country
Character
25
0
N
Caption: Ship Country

80
outside
Logical
1
0
N
Caption: Outside the Scheme

81
takeasib
Logical
1
0
N
Caption: Take IBDPA as IB

82
zerorated
Logical
1
0
N
Caption: Zero Rated

83
specflag
Logical
1
0
N
Caption: Special Flag for Invoices

84
addship
Logical
1
0
N
Caption: Additional Shipping Flag

85
revised
Date
8
0
N
Caption: Revised

86
revision
Numeric
3
0
N
Caption: Revision

87
eutransfer
Logical
1
0
N
Caption: EU Transfer

88
ishipper
Character
6
0
N
Caption: Invoice Shipper (Address from Customer)

89
vexport
Logical
1
0
N
Caption: Verified Exported

90
sh_coufk
Integer
4
0
N
Caption: Shipping Country Foreign Key

91
invlocked
Character
1
0
N
Caption: Invoice is Locked - Can not be Recalculated

92
resale_no
Character
12
0
N
Caption: Resale No.

93
shipverify
Character
1
0
N
Caption: Ship Verification Done?

94
ver_date
Date
8
0
N
Caption: Ship Verification Date

95
ver_by
Character
10
0
N
Caption: Ship Verified by

96
recalcship
Logical
1
0
N
Caption: Recalculate Shipping and Insurance

97
recalcins
Logical
1
0
N
Caption: Recalcins

98
pickship
Logical
1
0
N
Caption: Pickship

99
operator_pd
Character
10
0
N
Caption: Operator that marked the invoice paid

100
vat_bond
Numeric
11
2
N
Caption: Bond Clearing Charges

101
vat_manual
Logical
1
0
N
Caption: Override VAT Outcomes Manually

102
cc_perc
Numeric
6
3
N
Caption: Credit Card Percent

103
source
Character
10
0
N
Caption: Source

104
pr_list
Character
20
0
N
Caption: From Price List

105
icurrency
Character
8
0
N
Caption: Pay in Currency

106
inv_type
Character
25
0
N
Caption: Type of Invoice

107
manualship
Logical
1
0
N
Caption: Calculate Shipping/Delivery Charges Manually

108
sh_wphone
Character
22
0
N
Caption: Shipping Work Phone

109
sh_fphone
Character
22
0
N
Caption: Shipping Fax Phone

110
inv_cat1
Character
20
0
N
Caption: Inv Cat1

111
inv_cat2
Character
20
0
N
Caption: Inv Cat2

112
rcvd_date
Date
8
0
N
Caption: Date Items on Invoice were Received and are ready for Shipment

113
buy_split
Numeric
10
0
N
Caption: Buy Split

114
buy_perc2
Numeric
10
2
N
Caption: Buy Perc2

115
futamount
Numeric
12
2
N
Caption: Future Sales

116
niwamount
Numeric
12
2
N
Caption: Not in Warehouse

117
salamount
Numeric
12
2
N
Caption: SALAmount

118
cogsfuture
Numeric
12
2
N
Caption: Future Cost of Goods Sole

119
cogsniw
Numeric
12
2
N
Caption: NIW Cost of Goods Sold

120
ests_date
Date
8
0
N
Caption: Estimated Ship Date

121
ttlnecks
Numeric
8
0
N
Caption: Total Necks

122
col_date
Date
8
0
N
Caption: Collection Payment Date

123
invd_date
Date
8
0
N
Caption: Invoiced Date

124
pull_date
Date
8
0
N
Caption: Pull Date

125
pulled_by
Character
15
0
N
Caption: Pulled By

126
short_term
Character
15
0
N
Caption: Short Term Storage Location

127
inv_status
Character
30
0
N
Caption: Inv Status

128
pack_date
Date
8
0
N
Caption: Pack Date

129
packer
Character
15
0
N
Caption: Packer

130
pack_loc
Character
15
0
N
Caption: Pack Location

131
amount_bill
Numeric
12
2
N
Caption: Amount Bill

132
weather
Logical
1
0
N
Caption: Weather Watch
Total record size: 1397

Table: au!invpmts

# Field Name Type Len Dec Null

1
inp_pk
Integer
4
0
N

2
invoice
Character
6
0
N
Caption: Invoice Number

3
inp_invfk
Integer
4
0
N

4
cust_no
Character
6
0
N
Caption: Customer Number

5
inp_cusfk
Integer
4
0
N
Caption: Customer Foreign Key

6
date_paid
Date
8
0
N
Caption: Date Paid

7
amount_pd
Numeric
11
2
N
Caption: Amount Paid

8
how_paid
Character
30
0
N
Caption: How Paid

9
operator
Character
10
0
N
Caption: Operator

10
last_edit
Date
8
0
N
Caption: Last Edit

11
last_time
Character
6
0
N
Caption: Last Time

12
pay_type
Character
4
0
N
Caption: Pay Type

13
ref_num
Character
10
0
N
Caption: Sub Code

14
check_no
Character
20
0
N
Caption: Check No

15
checkcashed
Logical
1
0
N
Caption: Check Cashed

16
partialamt
Logical
1
0
N
Caption: Partialamt

17
paypalfee
Numeric
7
2
N
Caption: Paypalfee

18
exported
Logical
1
0
N
Caption: Exported
Total record size: 142

Table: au!lablset

# Field Name Type Len Dec Null

1
lab_pk
Integer
4
0
N

2
label_code
Character
4
0
N

3
descrip
Character
20
0
N

4
s_lab_las
Character
1
0
N

5
label_top
Character
1
0
N

6
s_lab_len
Numeric
2
0
N

7
s_lab_col
Numeric
2
0
N

8
s_lab_mar
Numeric
2
0
N

9
s_lab_row
Numeric
2
0
N

10
prnt_bar_c
Character
1
0
N

11
s_lab_wid
Numeric
2
0
N

12
s_lab_ex
Numeric
2
0
N

13
format
Character
2
0
N

14
lot_rept
Character
15
0
N

15
s_orient
Character
1
0
N
Total record size: 62

Table: au!larchive

# Field Name Type Len Dec Null

1
lot_pk
Integer
4
0
N
Caption: Primary Key

2
cust_no
Character
6
0
N
Caption: Buyer

3
lot_buyfk
Integer
4
0
N
Caption: Buyer FK

4
consignor
Character
6
0
N
Caption: Consignor

5
lot_confk
Integer
4
0
N
Caption: Consignor FK

6
category
Character
8
0
N
Caption: Category Code

7
lot_catfk
Integer
4
0
N
Caption: Category Foreign Key

8
sale_no
Character
5
0
N
Caption: Sale No.

9
lot_salfk
Integer
4
0
N
Caption: Sale Foreign Key

10
invoice
Character
6
0
N
Caption: Invoice No.

11
lot_invfk
Integer
4
0
N
Caption: Invoice Foreign Key

12
lot_no
Character
5
0
N
Caption: Lot No.

13
lot_apfk
Integer
4
0
N
Caption: AP record Foreign Key

14
lot_apsfk
Integer
4
0
N
Caption: AP Sort Foreign Key

15
win_code
Character
5
0
N
Caption: Wine Code

16
lot_winfk
Integer
4
0
N
Caption: Wine Foreign Key

17
lot_grofk
Integer
4
0
N
Caption: Grower Foreign Key

18
descrip
Character
250
0
N
Caption: not used (Now in Lot_Descr)

19
photo
Character
1
0
N
Caption: Photo

20
est_low
Numeric
11
2
N
Caption: Price 1

21
est_real
Numeric
11
2
N
Caption: Price 2

22
price3
Numeric
11
3
N
Caption: Price 3

23
est_code
Character
1
0
N
Caption: Est Code

24
est_cons
Numeric
11
2
N
Caption: Consignor Estimate

25
srtorder
Character
25
0
N
Caption: Catalog No.

26
seq_num
Character
7
0
N
Caption: Sequence No.

27
prop_num
Character
8
0
N
Caption: Property No.

28
cons_num
Character
12
0
N
Caption: Consignor Reference No.

29
cons_perc
Numeric
4
1
N
Caption: Consignor Percent

30
misc_fee
Numeric
8
2
N
Caption: Misc Fee

31
lott_fee
Numeric
7
2
N
Caption: Lotting Fee

32
cons_fee
Numeric
11
2
N
Caption: Consignor Fee

33
ins_fee
Numeric
10
2
N
Caption: Insurance Fee

34
underbid
Numeric
11
2
N
Caption: Underbid

35
opening
Numeric
11
2
N
Caption: Opening

36
man_open
Character
1
0
N
Caption: Manual Open

37
realized
Numeric
11
2
N
Caption: Realized

38
reserve
Numeric
12
3
N
Caption: Reserve

39
number_lot
Numeric
6
0
N
Caption: Number of Lots

40
qty2
Numeric
5
0
N
Caption: Qty2

41
qty3
Numeric
6
0
N
Caption: Qty3

42
loc1
Character
6
0
N
Caption: Location 1

43
loc2
Character
5
0
N
Caption: Location 2

44
loc3
Character
5
0
N
Caption: Location 3

45
duplicate
Logical
1
0
N
Caption: Duplicate Lot

46
est_weight
Numeric
7
2
N
Caption: Estimated Weight

47
high_bid
Numeric
11
2
N
Caption: High Bid

48
discount
Numeric
5
1
N
Caption: Discount %

49
bid
Numeric
11
2
N
Caption: Bid

50
symbol
Character
8
0
N
Caption: Symbol

51
condition
Character
8
0
N
Caption: Condition

52
pr_type
Character
1
0
N
Caption: PR Type

53
finder_fee
Numeric
5
1
N
Caption: Finder's Fee %

54
finder
Character
6
0
N
Caption: Finder No.

55
insurance
Numeric
7
3
N
Caption: Insurance %

56
expert_fee
Numeric
7
2
N
Caption: Expertization Fee

57
photo_fee
Numeric
7
2
N
Caption: Photo Fee

58
notes
Character
64
0
N
Caption: Notes

59
currency
Character
3
0
N
Caption: Currency

60
catalog
Character
15
0
N
Caption: Catalog

61
box_lot
Character
1
0
N
Caption: Box Lot

62
spill
Memo
4
0
N
Caption: Rest of Description (now in Lot_Descr)

63
bidder
Character
6
0
N
Caption: High Bidder No.

64
creator
Character
10
0
N
Caption: Created By

65
add_date
Date
8
0
N
Caption: Added Date

66
operator
Character
10
0
N
Caption: Last Changed by

67
last_edit
Date
8
0
N
Caption: Last Date Edited

68
last_time
Character
6
0
N
Caption: Last Time Edited

69
ref_num
Character
30
0
N
Caption: Reference No.

70
topics
Character
56
0
N
Caption: Topics

71
gum
Character
5
0
N
Caption: Gum

72
plate
Character
10
0
N
Caption: Plate

73
num_bids
Numeric
4
0
N
Caption: Number of Bids

74
net_resv
Character
1
0
N
Caption: Net Reserve?

75
lot_notes
Memo
4
0
N
Caption: Lotting Notes

76
date_sold
Date
8
0
N
Caption: Date Sold

77
date_buy
Date
8
0
N
Caption: Date Bought

78
extension
Character
5
0
N
Caption: On Extension

79
country
Character
120
0
N
Caption: Country

80
paddle
Character
4
0
N
Caption: Won by Paddle No.

81
tax_exempt
Logical
1
0
N
Caption: Tax Exempt

82
header
Memo
4
0
N
Caption: Header

83
footer
Memo
4
0
N
Caption: Footer

84
ceiling
Logical
1
0
N
Caption: Ceiling Bid on this lot

85
sale_hist
Character
60
0
N
Caption: Sale History

86
errata
Memo
4
0
N
Caption: Errata

87
added
Numeric
5
0
N
Caption: Added (labels)

88
lot_flag
Character
4
0
N
Caption: Lot Flag

89
soldtime
Character
14
0
N
Caption: Sold Time

90
image
Character
1
0
N
Caption: Image

91
pull
Character
1
0
N
Caption: Pull

92
deskkey
Character
1
0
N
Caption: Deskkey (multiple images)

93
buyer_misc
Numeric
11
2
N
Caption: Buyer Misc Fee

94
cons_misc
Numeric
11
2
N
Caption: Consignor Misc Fee

95
lot_descr
Memo
4
0
N
Caption: Description

96
vat_offer
Character
4
0
N
Caption: VAT Offered as Status

97
vat_taken
Character
4
0
N
Caption: VAT Taken Status

98
vat_tax
Numeric
11
2
N
Caption: Vat Tax

99
vat_prem
Numeric
12
2
N
Caption: Vat on Buyers Premium

100
duty
Numeric
12
2
N
Caption: Duty/Excise Tax

101
freecirc
Character
1
0
N
Caption: Free Circulation (default="Y")

102
cases
Numeric
4
0
N
Caption: Cases

103
ship_fee
Numeric
8
2
N
Caption: Shipping Fee per Case

104
lotclear
Character
1
0
N
Caption: Lot has been Cleared for Payment to the Consignor

105
nest_low
Numeric
10
2
N
Caption: New Low Estimate

106
nest_real
Numeric
10
2
N
Caption: New High Estimate

107
nreserve
Numeric
10
2
N
Caption: New Reserve

108
agent
Character
3
0
N
Caption: Agent

109
delivery
Logical
1
0
N
Caption: Delivery

110
lshipper
Character
6
0
N
Caption: Shipper for this Lot

111
reoffered
Numeric
3
0
N
Caption: Number of time lot has been reoffered

112
vat_bond
Numeric
11
2
N
Caption: Bond Clearing Charges

113
cvat_lot
Numeric
10
2
N
Caption: Consignors VAT on Lot Hammer

114
cvat_com
Numeric
10
2
N
Caption: Consignors VAT on LOT commision

115
cvat_ins
Numeric
10
2
N
Caption: Consignors VAT on Insurance

116
cvat_fees
Numeric
10
2
N
Caption: Consignors VAT on Lot Fees

117
parcel
Logical
1
0
N
Caption: Parcel

118
par_lotfk
Integer
4
0
N
Caption: Parcel Lot Foreign Key

119
retail
Numeric
12
2
N
Caption: Retail Price

120
newarrival
Character
1
0
N
Caption: New Arrival

121
special
Character
1
0
N
Caption: Special

122
number_bo
Numeric
6
0
N
Caption: Number Backordered

123
allow_bo
Character
1
0
N
Caption: Allow Backorders

124
addlotpk
Integer
4
0
N
Caption: PK in Invoices File (same as Lot_PK)

125
origlotpk
Integer
4
0
N
Caption: Original Lot_PK from Inventory

126
clr_date
Date
8
0
N
Caption: Date Lot was first Cleared for Payment
Total record size: 1342

Table: au!lindex

# Field Name Type Len Dec Null

1
lin_pk
Integer
4
0
N

2
lot_no
Character
5
0
N
Caption: Lot No.

3
lin_lotfk
Integer
4
0
N
Caption: Lot FK

4
sale_no
Character
5
0
N
Caption: Sale No.

5
lin_salfk
Integer
4
0
N
Caption: Sale Foreign Key

6
category
Character
8
0
N
Caption: Category Code

7
lin_catfk
Integer
4
0
N
Caption: Category Foreign Key

8
index_type
Character
1
0
N
Caption: Index Type

9
keyword
Character
40
0
N
Caption: Keyword

10
seq_num
Character
7
0
N
Caption: Sequence Number

11
last_edit
Date
8
0
N
Caption: Last Edit

12
operator
Character
10
0
N
Caption: Operator

13
last_time
Character
6
0
N
Caption: Last Time
Total record size: 107

Table: au!loggedinusers

# Field Name Type Len Dec Null

1
clu_fk
Character
5
0
N

2
clu_mk
Character
20
0
N

3
clu_dt
DateTime
8
0
N
Default: DATETIME()

4
clu_mk1
Character
12
0
N

5
clu_fk1
Character
5
0
N
Total record size: 51

Table: au!loginhistory

# Field Name Type Len Dec Null

1
ulh_pk
Integer
4
0
N
Default: x3genpk("LOGINHISTORY","AU")

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

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

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

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

6
ulh_machine
Character
20
0
N
Default: SYS(0)

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

8
ulh_wstfk
Integer
4
0
N
Total record size: 62

Table: au!lots

# Field Name Type Len Dec Null

1
lot_pk
Integer
4
0
N
Caption: Primary Key

2
cust_no
Character
6
0
N
Caption: Buyer

3
lot_buyfk
Integer
4
0
N
Caption: Buyer FK

4
consignor
Character
6
0
N
Caption: Consignor

5
lot_confk
Integer
4
0
N
Caption: Consignor FK

6
category
Character
8
0
N
Caption: Category Code

7
lot_catfk
Integer
4
0
N
Caption: Category Foreign Key

8
sale_no
Character
5
0
N
Caption: Sale No.

9
lot_salfk
Integer
4
0
N
Caption: Sale Foreign Key

10
invoice
Character
6
0
N
Caption: Invoice No.

11
lot_invfk
Integer
4
0
N
Caption: Invoice Foreign Key

12
lot_no
Character
5
0
N
Caption: Lot No.

13
lot_apfk
Integer
4
0
N
Caption: AP record Foreign Key

14
lot_apsfk
Integer
4
0
N
Caption: AP Sort Foreign Key

15
win_code
Character
5
0
N
Caption: Wine Code

16
lot_winfk
Integer
4
0
N
Caption: Wine Foreign Key

17
lot_grofk
Integer
4
0
N
Caption: Grower Foreign Key

18
descrip
Character
250
0
N
Caption: not used (Now in Lot_Descr)

19
photo
Character
1
0
N
Caption: Photo

20
est_low
Numeric
11
2
N
Caption: Price 1

21
est_real
Numeric
11
2
N
Caption: Price 2

22
price3
Numeric
11
4
N
Caption: Price 3

23
est_code
Character
1
0
N
Caption: Est Code

24
est_cons
Numeric
11
2
N
Caption: Consignor Estimate

25
srtorder
Character
40
0
N
Caption: Catalog No.

26
seq_num
Character
7
0
N
Caption: Sequence No.

27
prop_num
Character
8
0
N
Caption: Property No.

28
cons_num
Character
12
0
N
Caption: Consignor Reference No.

29
cons_perc
Numeric
5
1
N
Caption: Consignor Percent

30
misc_fee
Numeric
8
2
N
Caption: Misc Fee

31
lott_fee
Numeric
7
2
N
Caption: Lotting Fee

32
cons_fee
Numeric
11
2
N
Caption: Consignor Fee

33
ins_fee
Numeric
10
2
N
Caption: Insurance Fee

34
underbid
Numeric
11
2
N
Caption: Underbid

35
opening
Numeric
11
2
N
Caption: Opening

36
man_open
Character
1
0
N
Caption: Manual Open

37
realized
Numeric
12
3
N
Caption: Realized

38
reserve
Numeric
12
3
N
Caption: Reserve

39
number_lot
Numeric
9
2
N
Caption: Number of Lots

40
qty2
Numeric
6
0
N
Caption: Qty2

41
qty3
Numeric
6
0
N
Caption: Qty3

42
loc1
Character
12
0
N
Caption: Location 1

43
loc2
Character
12
0
N
Caption: Location 2

44
loc3
Character
12
0
N
Caption: Location 3

45
loc4
Character
12
0
N
Caption: Loc4

46
duplicate
Logical
1
0
N
Caption: Duplicate Lot

47
grade1
Character
12
0
N
Caption: Grade1

48
grade2
Character
12
0
N
Caption: Grade2

49
est_weight
Numeric
7
2
N
Caption: Estimated Weight

50
high_bid
Numeric
11
2
N
Caption: High Bid

51
discount
Numeric
9
5
N
Caption: Discount %

52
bid
Numeric
11
2
N
Caption: Bid

53
symbol
Character
8
0
N
Caption: Symbol

54
condition
Character
8
0
N
Caption: Condition

55
pr_type
Character
1
0
N
Caption: PR Type

56
finder_fee
Numeric
5
1
N
Caption: Finder's Fee %

57
finder
Character
6
0
N
Caption: Finder No.

58
insurance
Numeric
7
3
N
Caption: Insurance %

59
expert_fee
Numeric
7
2
N
Caption: Expertization Fee

60
photo_fee
Numeric
7
2
N
Caption: Photo Fee

61
notes
Character
64
0
N
Caption: Notes

62
currency
Character
3
0
N
Caption: Currency

63
catalog
Character
15
0
N
Caption: Catalog

64
box_lot
Character
1
0
N
Caption: Box Lot

65
spill
Memo
4
0
N
Caption: Rest of Description (now in Lot_Descr)

66
bidder
Character
6
0
N
Caption: High Bidder No.

67
creator
Character
10
0
N
Caption: Created By

68
add_date
Date
8
0
N
Caption: Added Date

69
operator
Character
10
0
N
Caption: Last Changed by

70
last_edit
Date
8
0
N
Caption: Last Date Edited

71
last_time
Character
6
0
N
Caption: Last Time Edited

72
ref_num
Character
50
0
N
Caption: Reference No.

73
topics
Character
56
0
N
Caption: Topics

74
gum
Character
12
0
N
Caption: Gum

75
plate
Character
12
0
N
Caption: Plate

76
num_bids
Numeric
4
0
N
Caption: Number of Bids

77
net_resv
Character
1
0
N
Caption: Net Reserve?

78
lot_notes
Memo
4
0
N
Caption: Lotting Notes

79
date_sold
Date
8
0
N
Caption: Date Sold

80
date_buy
Date
8
0
N
Caption: Date Bought

81
extension
Character
20
0
N
Caption: On Extension

82
country
Character
120
0
N
Caption: Country

83
paddle
Character
4
0
N
Caption: Won by Paddle No.

84
tax_exempt
Logical
1
0
N
Caption: Tax Exempt

85
header
Memo
4
0
N
Caption: Header

86
footer
Memo
4
0
N
Caption: Footer

87
ceiling
Logical
1
0
N
Caption: Ceiling Bid on this lot

88
sale_hist
Character
240
0
N
Caption: Sale History

89
errata
Memo
4
0
N
Caption: Errata

90
added
Numeric
5
0
N
Caption: Added (labels)

91
lot_flag
Character
4
0
N
Caption: Lot Flag

92
soldtime
Character
14
0
N
Caption: Sold Time

93
image
Character
1
0
N
Caption: Image

94
pull
Character
1
0
N
Caption: Pull

95
deskkey
Character
1
0
N
Caption: Deskkey (multiple images)

96
buyer_misc
Numeric
11
2
N
Caption: Buyer Misc Fee

97
cons_misc
Numeric
11
2
N
Caption: Consignor Misc Fee

98
lot_descr
Memo
4
0
N
Caption: Description

99
vat_offer
Character
4
0
N
Caption: VAT Offered as Status

100
vat_taken
Character
4
0
N
Caption: VAT Taken Status

101
vat_tax
Numeric
11
2
N
Caption: Vat Tax

102
vat_prem
Numeric
12
2
N
Caption: Vat on Buyers Premium

103
duty
Numeric
12
2
N
Caption: Duty/Excise Tax

104
freecirc
Character
1
0
N
Caption: Free Circulation (default="Y")

105
cases
Numeric
4
0
N
Caption: Cases

106
ship_fee
Numeric
8
2
N
Caption: Shipping Fee per Case

107
lotclear
Character
1
0
N
Caption: Lot has been Cleared for Payment to the Consignor

108
nest_low
Numeric
10
2
N
Caption: New Low Estimate

109
nest_real
Numeric
10
2
N
Caption: New High Estimate

110
nreserve
Numeric
10
2
N
Caption: New Reserve

111
agent
Character
3
0
N
Caption: Agent

112
delivery
Logical
1
0
N
Caption: Delivery

113
lshipper
Character
6
0
N
Caption: Shipper for this Lot

114
reoffered
Numeric
3
0
N
Caption: Number of time lot has been reoffered

115
vat_bond
Numeric
11
2
N
Caption: Bond Clearing Charges

116
cvat_lot
Numeric
10
2
N
Caption: Consignors VAT on Lot Hammer

117
cvat_com
Numeric
10
2
N
Caption: Consignors VAT on LOT commision

118
cvat_ins
Numeric
10
2
N
Caption: Consignors VAT on Insurance

119
cvat_fees
Numeric
10
2
N
Caption: Consignors VAT on Lot Fees

120
parcel
Logical
1
0
N
Caption: Parcel

121
par_lotfk
Integer
4
0
N
Caption: Parcel Lot Foreign Key

122
retail
Numeric
12
2
N
Caption: Retail Price

123
clr_date
Date
8
0
N
Caption: Date Lot was first Cleared for Payment

124
newarrival
Character
3
0
N
Caption: New Arrival

125
special
Character
3
0
N
Caption: Special

126
number_bo
Numeric
6
0
N
Caption: Number Backordered

127
allow_bo
Character
1
0
N
Caption: Allow Backorders

128
addlotpk
Integer
4
0
N
Caption: PK in Invoices File (same as Lot_PK)

129
origlotpk
Integer
4
0
N
Caption: Original Lot_PK from Inventory
Total record size: 1651

Table: au!mailhist

# Field Name Type Len Dec Null

1
cust_no
Character
6
0
N
Caption: Cust No

2
mail_flag
Character
4
0
N
Caption: Mail Flag

3
add_date
Date
8
0
N
Caption: Add Date
Total record size: 19

Table: au!mailing

# Field Name Type Len Dec Null

1
mai_pk
Integer
4
0
N

2
cust_no
Character
6
0
N

3
salutation
Character
5
0
N

4
cust_lname
Character
30
0
N
Total record size: 46

Table: au!memoae

# Field Name Type Len Dec Null

1
mae_code
Character
5
0
N
Caption: Code

2
mae_text
Memo
4
0
N
Caption: Expanded text

3
mae_usrfk
Integer
4
0
N
Total record size: 14

Table: au!miscinv

# Field Name Type Len Dec Null

1
mis_pk
Integer
4
0
N

2
invoice
Character
6
0
N
Caption: Invoice No.

3
mis_invfk
Integer
4
0
N

4
sale_no
Character
5
0
N
Caption: Sale No.

5
lot_no
Character
6
0
N
Caption: Lot No.

6
qty
Numeric
5
0
N
Caption: Quantity

7
descrip
Character
150
0
N
Caption: Description

8
cust_no
Character
6
0
N
Caption: Customer No.

9
seq_num
Character
6
0
N
Caption: Sequence No.

10
consignor
Character
6
0
N
Caption: Consignor No.

11
realized
Numeric
11
2
N
Caption: Realized

12
est_weight
Numeric
6
1
N
Caption: Estimate Weight

13
percent
Numeric
4
0
N
Caption: Percent Discount

14
last_edit
Date
8
0
N
Caption: Last Edited

15
srtorder
Character
10
0
N
Caption: Catalog Number

16
cachet
Character
3
0
N
Caption: Cachet

17
operator
Character
10
0
N
Caption: Operator

18
last_time
Character
6
0
N
Caption: Last Time
Total record size: 257

Table: au!moreap

# Field Name Type Len Dec Null

1
api_pk
Integer
4
0
N
Caption: Primary Key

2
api_apfk
Integer
4
0
N
Caption: AP Foreign Key

3
cust_no
Character
6
0
N
Caption: Cust No.

4
api_confk
Integer
4
0
N
Caption: Consignor Foreign Key

5
sale_no
Character
5
0
N
Caption: Sale No.

6
api_salfk
Integer
4
0
N
Caption: Sale Foreign Key

7
amount_pd
Numeric
11
2
N
Caption: Amount Paid

8
date
Date
8
0
N
Caption: Date

9
note
Character
40
0
N
Caption: Note

10
type
Character
4
0
N
Caption: Type

11
sort
Character
2
0
N
Caption: Sort

12
ref_num
Character
10
0
N
Caption: Reference No.

13
operator
Character
10
0
N
Caption: Operator

14
last_edit
Date
8
0
N
Caption: Last Edit

15
last_time
Character
6
0
N
Caption: Last Time

16
check_no
Character
10
0
N
Caption: Check Number

17
checkcashed
Logical
1
0
N
Caption: Check Cashed

18
partialamt
Logical
1
0
N
Caption: Partial Amount

19
exported
Logical
1
0
N
Caption: Exported
Total record size: 140

Table: au!mxlot

# Field Name Type Len Dec Null

1
mxl_pk
Integer
4
0
N
Caption: Mixed Lot Primary Key

2
mxl_lotfk
Integer
4
0
N
Caption: Lot Foreign Key

3
page_no
Character
3
0
N
Caption: Page No

4
line_no
Character
3
0
N
Caption: Line No

5
mxl_winfk
Integer
4
0
N
Caption: Wine Foreign Key

6
mxl_grofk
Integer
4
0
N
Caption: Grower Foreign Key

7
vintage
Character
4
0
N
Caption: Vintage

8
bottles
Numeric
3
0
N
Caption: Bottles

9
mxl_sizfk
Integer
4
0
N
Caption: Bottle Size Foreign Key

10
mxl_size
Character
4
0
N
Caption: Bottle Size

11
act_liter
Numeric
6
1
N
Caption: Actual Literage

12
mxest_low
Numeric
12
2
N
Caption: Low Estimate

13
mxest_real
Numeric
12
2
N
Caption: High Estimate

14
mxreserve
Numeric
12
2
N
Caption: Reserve

15
case_no
Character
10
0
N
Caption: Case No

16
inv_loc
Character
15
0
N
Caption: Warehouse Location

17
mxref_num
Character
10
0
N
Caption: Client Ref. No

18
rec_date
Date
8
0
N
Caption: Receipt Date

19
ship_date
Date
8
0
N
Caption: Ship Date

20
tracking
Character
10
0
N
Caption: Tracking No

21
last_edit
Date
8
0
N
Caption: Last Edit

22
last_time
Character
6
0
N
Caption: Last Time

23
operator
Character
10
0
N
Caption: Operator

24
cas_code
Character
4
0
N
Caption: Case Type Code

25
mxl_casfk
Numeric
10
0
N
Caption: Case Type Foreign Key

26
vat_off
Character
4
0
N
Caption: VAT Status

27
whse
Character
6
0
N
Caption: WareHouse

28
mxl_note
Character
120
0
N
Caption: Short Note

29
condition
Memo
4
0
N
Caption: Condition

30
case_cond
Character
80
0
N
Caption: Case Condition

31
usegrower
Logical
1
0
N
Caption: Use Grower Note?

32
donotusetn
Logical
1
0
N
Caption: Do Not Use Tasting Note.

33
donotupdt
Logical
1
0
N
Caption: Do Not Update Price Table

34
mxretail
Numeric
12
2
N
Caption: Retail Price

35
number_lot
Numeric
6
0
N
Caption: Number of Lots

36
mxprice3
Numeric
12
4
N
Caption: Cost

37
mxest_cons
Numeric
11
2
N
Caption: Estimate to the Consignor

38
islbottle
Logical
1
0
N
Caption: ISL Bottled
Total record size: 438

Table: au!newcust

# Field Name Type Len Dec Null

1
new_pk
Integer
4
0
N

2
new_xxxfk
Integer
4
0
N

3
field_db
Character
8
0
N

4
field_name
Character
10
0
N

5
field_type
Character
1
0
N

6
field_len
Numeric
3
0
N

7
field_dec
Numeric
3
0
N

8
field_txt1
Character
80
0
N

9
field_txt2
Character
80
0
N

10
descrip
Character
30
0
N

11
context
Memo
4
0
N

12
help_scr
Numeric
2
0
N

13
help_numb
Numeric
2
0
N
Total record size: 232

Table: au!nextlot

# Field Name Type Len Dec Null

1
nex_pk
Integer
4
0
N

2
nex_xxxfk
Integer
4
0
N

3
seq_num
Character
7
0
N

4
cur_row
Numeric
2
0
N

5
cur_col
Numeric
2
0
N

6
invoice
Character
6
0
N

7
cust_no
Character
6
0
N

8
last_edit
Date
8
0
N

9
line_num
Character
6
0
N

10
sale_no
Character
5
0
N

11
salecode
Character
1
0
N

12
cleared
Logical
1
0
N

13
saledate
Character
15
0
N

14
descrip
Character
40
0
N

15
saletype
Character
1
0
N

16
cons_num
Character
4
0
N

17
active
Character
1
0
N

18
last_lotd
Date
8
0
N

19
last_lott
Character
6
0
N

20
uweb_date
Date
8
0
N

21
uweb_time
Character
6
0
N

22
iweb_date
Date
8
0
N

23
iweb_time
Character
6
0
N

24
sal_pk
Integer
4
0
N
Caption: Sal Pk

25
check_no
Character
6
0
N
Caption: Next Check Number

26
stk_sale
Character
5
0
N
Caption: Sale where Stock is Kept

27
srv_sale
Character
5
0
N
Caption: Sale where Services are Kept

28
curr_misc
Character
5
0
N
Caption: Sale where Sales of Stock and Services are Kept

29
po_sale
Character
5
0
N
Caption: Purchase Order Sale

30
rel_numb
Character
6
0
N
Caption: Last Release Number

31
prop_numb
Character
6
0
N
Caption: Prop Numb

32
curr_misc2
Character
5
0
N
Caption: Curr Misc2

33
retail_no
Character
6
0
N
Caption: Retail No
Total record size: 209

Table: au!outbid

# Field Name Type Len Dec Null

1
out_pk
Integer
4
0
N
Caption: Primary Key

2
out_xxxfk
Integer
4
0
N

3
sale_no
Character
5
0
N
Caption: Sale No.

4
cust_no
Character
6
0
N
Caption: Cust No.

5
lot_no
Character
5
0
N
Caption: Lot No.
Total record size: 25

Table: au!paddle

# Field Name Type Len Dec Null

1
pad_pk
Integer
4
0
N
Caption: Paddle primary key

2
cust_no
Character
6
0
N
Caption: Cust No.

3
pad_cusfk
Integer
4
0
N
Caption: Customer foreign key

4
sale_no
Character
5
0
N
Caption: Sale No.

5
pad_salfk
Integer
4
0
N
Caption: Sale Foreign Key

6
pad_salbfk
Integer
4
0
N
Caption: Salebid foreign key

7
paddle
Character
4
0
N
Caption: Paddle No.

8
operator
Character
10
0
N
Caption: Operator

9
last_edit
Date
8
0
N
Caption: Last Edit

10
last_time
Character
6
0
N
Caption: Last Time
Total record size: 56

Table: au!pbcalls

# Field Name Type Len Dec Null

1
pbc_pk
Integer
4
0
N

2
pbc_xxxfk
Integer
4
0
N

3
sale_no
Character
5
0
N

4
calls
Numeric
10
0
N

5
startbids
Numeric
10
0
N

6
bids
Numeric
10
0
N
Total record size: 44

Table: au!pbfailed

# Field Name Type Len Dec Null

1
pbf_pk
Integer
4
0
N

2
pbf_xxxfk
Integer
4
0
N

3
cust_no
Character
6
0
N

4
zip
Character
10
0
N

5
date
Date
8
0
N

6
time
Character
8
0
N

7
added
Character
1
0
N
Total record size: 42

Table: au!pfexport

# Field Name Type Len Dec Null

1
pfe_pk
Integer
4
0
N
Caption: Pfe Pk

2
date_appl
Date
8
0
N
Caption: Date Appl

3
subtype
Character
2
0
N
Caption: Subtype

4
typedby
Character
12
0
N
Caption: Typedby

5
priority
Logical
1
0
N
Caption: Priority

6
pfe_coufk
Integer
4
0
N
Caption: Pfe Coufk

7
country
Character
25
0
N
Caption: Country

8
catalog_no
Character
20
0
N
Caption: Catalog No

9
issued
Character
4
0
N
Caption: Issued

10
denom
Character
15
0
N
Caption: Denom

11
appcolor
Character
35
0
N
Caption: Appcolor

12
appdescrip
Memo
4
0
N
Caption: Appdescrip

13
subvalue
Numeric
11
2
N
Caption: Subvalue

14
reconsider
Character
1
0
N
Caption: Reconsider

15
pickup
Logical
1
0
N
Caption: Pickup

16
firm_id
Character
2
0
N
Caption: Firm Id

17
sale_no
Character
5
0
N
Caption: Sale No

18
lot_no
Character
5
0
N
Caption: Lot No

19
seq_num
Character
7
0
N
Caption: Seq Num

20
app_lotfk
Integer
4
0
N
Caption: App Lotfk

21
cust_no
Character
6
0
N
Caption: Cust No

22
invoice
Character
6
0
N
Caption: Customer Invoice No.

23
pfe_cusfk
Integer
4
0
N
Caption: Pfe Cusfk

24
lot_descr
Memo
4
0
N
Caption: Lot Descr

25
symbol
Character
2
0
N
Caption: Symbol

26
prev_no
Character
7
0
N
Caption: Prev No

27
othername
Character
40
0
N
Caption: Othername

28
imagefile
Character
50
0
N
Caption: Imagefile

29
appl_no
Character
7
0
N
Caption: Appl No

30
feevalue
Numeric
11
2
N
Caption: Feevalue

31
finalfee
Numeric
7
2
N
Caption: Finalfee

32
final
Memo
4
0
N
Caption: Final

33
issuedate
Date
8
0
N
Caption: Issuedate

34
invoiceno
Character
7
0
N
Caption: Invoiceno

35
last_edit
Date
8
0
N
Caption: Last Edit

36
last_time
Character
6
0
N
Caption: Last Time

37
operator
Character
10
0
N
Caption: Operator

38
catalog
Character
20
0
N
Caption: Catalog

39
buyer
Character
40
0
N
Caption: Buyer

40
seller
Character
40
0
N
Caption: Seller

41
use_other
Logical
1
0
N
Caption: Use Other

42
graded
Logical
1
0
N
Caption: Graded

43
mingrade
Numeric
3
0
N
Caption: Minimum Grade

44
grade
Numeric
3
0
N
Caption: Grade

45
gradechar
Character
15
0
N
Caption: Grade Text

46
gradenote
Character
10
0
N
Caption: Gradenote

47
remarks
Character
50
0
N
Caption: Remarks

48
returndate
Date
8
0
N
Caption: Date Return

49
buyerdate
Date
8
0
N
Caption: Buyerdate

50
consdate
Date
8
0
N
Caption: Consdate
Total record size: 565

Table: au!phonebid

# Field Name Type Len Dec Null

1
pho_pk
Integer
4
0
N

2
pho_xxxfk
Integer
4
0
N

3
sale_no
Character
5
0
N

4
lot_no
Character
4
0
N

5
dummy
Character
1
0
N

6
cust_no
Character
6
0
N

7
amount
Numeric
11
2
N

8
pr_type
Character
1
0
N
Total record size: 37

Table: au!phrases

# Field Name Type Len Dec Null

1
phr_pk
Integer
4
0
N

2
code
Character
20
0
N
Caption: Code

3
allowtxt
Logical
1
0
N
Caption: Allow Textbox Insert

4
txtphrase
Character
40
0
N
Caption: Phrase for textbox

5
allowedt
Logical
1
0
N
Caption: Allow Memo field Insertion

6
edtphrase
Memo
4
0
N
Caption: Phrase for Memo field

7
hotkey
Character
20
0
N
Caption: Hot key assignment

8
autotype
Character
20
0
N
Caption: Spell Check Autotype
Total record size: 111

Table: au!postview

# Field Name Type Len Dec Null

1
pos_pk
Integer
4
0
N

2
sale_no
Character
5
0
N
Caption: Sale No.

3
lot_no
Character
5
0
N
Caption: Lot No.

4
pos_lotfk
Integer
4
0
N
Caption: Lot Foreign Key

5
cust_no
Character
6
0
N
Caption: Cust No.

6
pos_cusfk
Integer
4
0
N
Caption: Customer Foeign Key

7
invoice
Character
6
0
N
Caption: Invoice

8
pos_invfk
Integer
4
0
N
Caption: Invoice Foreign Key

9
date_out
Date
8
0
N
Caption: Date Out

10
date_in
Date
8
0
N
Caption: Date In
Total record size: 55

Table: au!profiles

# Field Name Type Len Dec Null

1
pro_pk
Integer
4
0
N

2
pro_xxxfk
Integer
4
0
N

3
sale_no
Character
5
0
N

4
pre_sale
Memo
4
0
N

5
post_sale
Memo
4
0
N

6
descrip
Character
65
0
N

7
date
Date
8
0
N

8
title1
Character
50
0
N

9
bill1
Character
50
0
N

10
bill2
Character
50
0
N

11
bill3
Character
50
0
N

12
bill4
Character
50
0
N

13
phone
Character
20
0
N

14
fax
Character
20
0
N

15
s_email
Character
50
0
N

16
s_webpage
Character
120
0
N

17
version
Character
8
0
N

18
slot1
Character
5
0
N

19
slot2
Character
5
0
N

20
slot3
Character
5
0
N

21
slot4
Character
5
0
N

22
slot5
Character
5
0
N

23
slot6
Character
5
0
N

24
elot1
Character
5
0
N

25
elot2
Character
5
0
N

26
elot3
Character
5
0
N

27
elot4
Character
5
0
N

28
elot5
Character
5
0
N

29
elot6
Character
5
0
N

30
cl_date1
Date
8
0
N

31
cl_date2
Date
8
0
N

32
cl_date3
Date
8
0
N

33
cl_date4
Date
8
0
N

34
cl_date5
Date
8
0
N

35
cl_date6
Date
8
0
N

36
cl_time1
Character
8
0
N

37
cl_time2
Character
8
0
N

38
cl_time3
Character
8
0
N

39
cl_time4
Character
8
0
N

40
cl_time5
Character
8
0
N

41
cl_time6
Character
8
0
N

42
spread1
Numeric
3
0
N

43
spread2
Numeric
3
0
N

44
spread3
Numeric
3
0
N

45
spread4
Numeric
3
0
N

46
spread5
Numeric
3
0
N

47
spread6
Numeric
3
0
N
Total record size: 737

Table: au!profit

# Field Name Type Len Dec Null

1
pro_pk
Integer
4
0
N

2
pro_xxxfk
Integer
4
0
N

3
range
Numeric
7
0
N

4
numlots
Numeric
6
0
N

5
totalest
Numeric
8
0
N

6
aveest
Numeric
11
2
N

7
lotssold
Numeric
6
0
N

8
totalpr
Numeric
8
0
N

9
avepr
Numeric
11
2
N

10
totalfees
Numeric
8
0
N

11
avefees
Numeric
11
2
N
Total record size: 85

Table: au!prtype

# Field Name Type Len Dec Null

1
prtype
Character
1
0
N
Caption: Prtype

2
prdesc
Character
20
0
N
Caption: Description
Total record size: 22

Table: au!qrystore

# Field Name Type Len Dec Null

1
qry_pk
Integer
4
0
N
Caption: Text Storage Primary Key

2
qrydescrip
Character
75
0
N
Caption: Description of Text

3
sqlquery
Memo
4
0
N
Caption: Contents
Total record size: 84

Table: au!readme

# Field Name Type Len Dec Null

1
rea_pk
Integer
4
0
N
Caption: Rea Pk

2
descrip
Character
120
0
N
Caption: Descrip

3
readme
Memo
4
0
N
Caption: Readme
Total record size: 129

Table: au!release

# Field Name Type Len Dec Null

1
rel_pk
Integer
4
0
N
Caption: Rel Pk

2
code
Character
3
0
N
Caption: Code

3
descrip
Character
60
0
N
Caption: Description

4
prtext
Memo
4
0
N
Caption: Text

5
prout
Memo
4
0
N

6
margin
Numeric
3
0
N

7
width
Numeric
3
0
N

8
type
Character
10
0
N
Caption: Type of Document

9
template
Character
30
0
N
Caption: Template for Document

10
user
Character
8
0
N
Caption: User ID
Total record size: 130

Table: au!reportcatalog

# Field Name Type Len Dec Null

1
rep_pk
Integer
4
0
N
Caption: Primary Key
Default: x3genpk("REPORTCATALOG","AU")

2
rep_name
Character
80
0
N
Caption: Name

3
rep_description
Memo
4
0
N
Caption: Description

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

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

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

7
rep_dialog
Character
100
0
N
Caption: Dialog
Comments: Required if EMPTY(Rep_Class) and EMPTY(Rep_FRX), if set takes precedence over Rep_Class and specifies an .SCX or [ClassName,VCXFile] dialog that ultimately runs a frmReport object
Total record size: 315

Table: au!returns

# Field Name Type Len Dec Null

1
ret_pk
Integer
4
0
N

2
sale_no
Character
5
0
N
Caption: Sale No.

3
lot_no
Character
5
0
N
Caption: Lot No.

4
ret_lotfk
Integer
4
0
N
Caption: Lot Foreign Key

5
cust_no
Character
6
0
N
Caption: Cust No.

6
seq_num
Character
7
0
N
Caption: Inventory No.

7
realized
Numeric
11
2
N
Caption: Realized

8
invoice
Character
6
0
N
Caption: Invoice No.

9
date_sold
Date
8
0
N
Caption: Date Sold

10
bidder_fee
Numeric
6
3
N
Caption: Bidder Fee

11
freight
Numeric
9
2
N
Caption: Freight

12
cons_misc
Numeric
10
2
N
Caption: Cert Fee

13
last_edit
Date
8
0
N
Caption: Last Edit

14
last_time
Character
5
0
N
Caption: Last Time

15
operator
Character
10
0
N
Caption: Operator

16
posted
Logical
1
0
N
Caption: Posted

17
reason
Character
80
0
N
Caption: Reason

18
cert
Character
1
0
N
Caption: Certificate

19
date_ret
Date
8
0
N
Caption: Date Ret

20
consignor
Character
6
0
N
Caption: Consignor

21
number_lot
Numeric
6
0
N
Caption: Number Lot
Total record size: 207

Table: au!salebids

# Field Name Type Len Dec Null

1
salb_pk
Integer
4
0
N

2
cust_no
Character
6
0
N
Caption: Cust No.

3
salb_cusfk
Integer
4
0
N
Caption: Customer foreign key

4
sale_no
Character
5
0
N
Caption: Sale No.

5
salb_salfk
Integer
4
0
N
Caption: Sale Foreign Key

6
max_bid
Numeric
8
0
N
Caption: Limit Bids to

7
incr_by
Numeric
3
0
N
Caption: Increase Bids By

8
cred_no
Character
20
0
N
Caption: Credit Card No.

9
cred_name
Character
20
0
N
Caption: Name on Credit Card

10
cred_init
Character
5
0
N
Caption: CC Init Date

11
cred_exp
Character
5
0
N
Caption: Expiration Date

12
cred_type
Character
5
0
N
Caption: Card Type

13
cred_limit
Numeric
7
0
N
Caption: Credit Limit

14
hand_fee
Numeric
11
2
N
Caption: Freight

15
ttl_weight
Numeric
11
2
N
Caption: Total Weight

16
total_real
Numeric
11
2
N
Caption: Realized

17
terms
Character
1
0
N
Caption: Terms

18
ship_via
Character
30
0
N
Caption: Ship Via

19
break_tie
Logical
1
0
N
Caption: Break Tie?

20
incr_bid
Logical
1
0
N
Caption: Increment Bid?

21
numb_incr
Numeric
1
0
N
Caption: Number of Increments

22
date_rcvd
Date
8
0
N
Caption: Date Rcvd

23
time_rcvd
Character
6
0
N
Caption: Time Bids Received

24
last_edit
Date
8
0
N
Caption: Last Edit

25
last_time
Character
5
0
N
Caption: Last Time

26
operator
Character
10
0
N
Caption: Operator

27
lots_won
Integer
4
0
N
Caption: Lots Won

28
outside
Logical
1
0
N
Caption: Take Outside the VAT Scheme

29
takeasib
Logical
1
0
N
Caption: Take IBDPA as IB (In Bond)

30
zerorated
Logical
1
0
N
Caption: Zero Rated

31
shipspec
Character
20
0
N
Caption: Special Shipping Instructions

32
language
Character
20
0
N
Caption: Language Spoken

33
specflag
Logical
1
0
N
Caption: Special Flag for Invoices

34
id_checked
Logical
1
0
N
Caption: Id Checked

35
phone_note
Memo
4
0
N
Caption: Phone Bid Notes

36
approved
Character
3
0
N
Caption: Approved to Bid

37
bidsheet
Numeric
6
0
N
Caption: Bidsheet Id
Total record size: 263

Table: au!sales

# Field Name Type Len Dec Null

1
sal_pk
Integer
4
0
N

2
sale_no
Character
5
0
N
Caption: Sale No.
Validation Rule: proclist(sale_no)

3
salecode
Character
1
0
N
Caption: 1 Char Code for Sale (eBAY)

4
cleared
Logical
1
0
N
Caption: Sale has been Cleared

5
omitinpb
Logical
1
0
N
Caption: Omit in Property Distribution Unsold Summary

6
omitinpbu
Logical
1
0
N
Caption: Omit in Property Distribution Unsolds

7
saledate
Character
25
0
N
Caption: Text Description of Sale Date

8
saletype
Character
1
0
N
Caption: Public or Mail

9
descrip
Character
65
0
N
Caption: Sale Description

10
active
Character
1
0
N
Caption: Active

11
pre_sale
Memo
4
0
N
Caption: Pre Sale Paragraph Description of Sale

12
post_sale
Memo
4
0
N
Caption: Post Sale Prices Realized Description

13
date
Date
8
0
N
Caption: Start Date of Sale

14
date2
Date
8
0
N
Caption: Ending Date of Sale

15
date_settle
Date
8
0
N
Caption: Settlement Date

16
title1
Character
50
0
N
Caption: (internal use only)

17
bill1
Character
50
0
N
Caption: (internal use only)

18
bill2
Character
50
0
N
Caption: (internal use only)

19
bill3
Character
50
0
N
Caption: (internal use only)

20
bill4
Character
50
0
N
Caption: (internal use only)

21
phone
Character
20
0
N
Caption: (internal use only)

22
fax
Character
20
0
N
Caption: (internal use only)

23
s_email
Character
50
0
N
Caption: eMail

24
s_webpage
Character
120
0
N
Caption: Web Page

25
version
Character
8
0
N
Caption: Version

26
slot1
Character
5
0
N
Caption: Session Lot From

27
slot2
Character
5
0
N
Caption: Session Lot From

28
slot3
Character
5
0
N
Caption: Session Lot From

29
slot4
Character
5
0
N
Caption: Session Lot From

30
slot5
Character
5
0
N
Caption: Session Lot From

31
slot6
Character
5
0
N
Caption: Session Lot From

32
elot1
Character
5
0
N
Caption: Session Lot to

33
elot2
Character
5
0
N
Caption: Session Lot to

34
elot3
Character
5
0
N
Caption: Session Lot to

35
elot4
Character
5
0
N
Caption: Session Lot to

36
elot5
Character
5
0
N
Caption: Session Lot to

37
elot6
Character
5
0
N
Caption: Session Lot to

38
cl_date1
Date
8
0
N
Caption: Session Close Date

39
cl_date2
Date
8
0
N
Caption: Session Close Date

40
cl_date3
Date
8
0
N
Caption: Session Close Date

41
cl_date4
Date
8
0
N
Caption: Session Close Date

42
cl_date5
Date
8
0
N
Caption: Session Close Date

43
cl_date6
Date
8
0
N
Caption: Session Close Date

44
cl_time1
Character
8
0
N
Caption: Session Close Time

45
cl_time2
Character
8
0
N
Caption: Session Close Time

46
cl_time3
Character
8
0
N
Caption: Session Close Time

47
cl_time4
Character
8
0
N
Caption: Session Close Time

48
cl_time5
Character
8
0
N
Caption: Session Close Time

49
cl_time6
Character
8
0
N
Caption: Session Close Time

50
spread1
Numeric
3
0
N
Caption: Spread Time

51
spread2
Numeric
3
0
N
Caption: Spread Time

52
spread3
Numeric
3
0
N
Caption: Spread Time

53
spread4
Numeric
3
0
N
Caption: Spread Time

54
spread5
Numeric
3
0
N
Caption: Spread Time

55
spread6
Numeric
3
0
N
Caption: Spread Time

56
operator
Character
10
0
N
Caption: Operator

57
last_edit
Date
8
0
N
Caption: Last Edit

58
last_time
Character
6
0
N
Caption: Last Time

59
room
Character
20
0
N
Caption: Room

60
location
Character
50
0
N
Caption: Location

61
viewing
Character
50
0
N
Caption: Viewing

62
buyperc
Numeric
7
4
N
Caption: Buyer's Premium

63
taxstate
Character
3
0
N
Caption: Tax State

64
staxrate
Numeric
7
4
N
Caption: Sales Tax Rate

65
staxzip
Character
5
0
N
Caption: Sales Tax Zipcode

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

67
staxcity
Character
25
0
N
Caption: Staxcity

68
converted
Character
1
0
N
Caption: Converted

69
simage_dir
Character
40
0
N
Caption: Image Directory (If not System)

70
simage_typ
Character
3
0
N
Caption: Image Type

71
simage_nam
Character
1
0
N
Caption: Sequence No. or Lot No.

72
ins_percb
Numeric
6
2
N
Caption: Buyer Insurance Percentage

73
cat_cost
Numeric
10
2
N
Caption: Catalog Cost

74
mail_cost
Numeric
10
2
N
Caption: Mailing Cost

75
prntqty
Numeric
6
0
N
Caption: Print Quantity

76
mailqty
Numeric
6
0
N
Caption: Mailing Quantity

77
dformat
Character
2
0
N
Caption: Division

78
exporttype
Character
1
0
N
Caption: Export to Database Type

79
inventory
Logical
1
0
N
Caption: Inventory

80
notinvent
Logical
1
0
N
Caption: Notinvent
Total record size: 1060

Table: au!securityaccess

# Field Name Type Len Dec Null

1
acc_pk
Integer
4
0
N
Caption: Primary Key
Default: x3genpk("SECURITYACCESS","AU")

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

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

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

Table: au!shiphist

# Field Name Type Len Dec Null

1
shi_pk
Integer
4
0
N

2
shi_cusfk
Integer
4
0
N

3
shi_invfk
Integer
4
0
N
Caption: Shi Invfk

4
invoice
Character
6
0
N
Caption: Invoice No.

5
cust_no
Character
6
0
N
Caption: Cust No.

6
date
Date
8
0
N
Caption: Date

7
method
Character
40
0
N
Caption: Method

8
sale_no
Character
5
0
N
Caption: Sale No.

9
last_edit
Date
8
0
N
Caption: Last Edit

10
last_time
Character
6
0
N
Caption: Last Time

11
operator
Character
10
0
N
Caption: Operator

12
track_num
Character
25
0
N
Caption: Tracking No.

13
shi_salfk
Integer
4
0
N
Caption: Sale Foreign Key

14
case_no
Character
10
0
N
Caption: Case No

15
ship_value
Numeric
10
2
N
Caption: Value

16
ship_fee
Numeric
10
2
N
Caption: Ship Fee

17
postage
Numeric
8
2
N
Caption: Postage

18
prntlabels
Numeric
1
0
N
Caption: Prntlabels

19
ship_type
Character
1
0
N
Caption: Ship Type
Total record size: 171

Table: au!shipping

# Field Name Type Len Dec Null

1
shi_pk
Integer
4
0
N

2
carrier
Character
10
0
N
Caption: Carrier

3
weight
Numeric
4
0
N
Caption: Weight

4
zone1
Numeric
8
2
N
Caption: Zone1

5
zone2
Numeric
8
2
N
Caption: UPS Zone 2

6
zone3
Numeric
8
2
N
Caption: UPS Zone 3

7
zone4
Numeric
8
2
N
Caption: UPS Zone 4

8
zone5
Numeric
8
2
N
Caption: UPS Zone 5

9
zone6
Numeric
8
2
N
Caption: UPS Zone 6

10
zone7
Numeric
8
2
N
Caption: UPS Zone 7

11
zone8
Numeric
8
2
N
Caption: UPS Zone 8

12
operator
Character
10
0
N
Caption: Operator

13
last_edit
Date
8
0
N
Caption: Last Edit

14
last_time
Character
6
0
N
Caption: Last Time

15
min_fee
Numeric
8
2
N
Caption: Minimum Fee

16
max_fee
Numeric
8
2
N
Caption: Maximum Fee

17
spec_fee
Numeric
8
2
N
Caption: Special Fee

18
shipper
Character
6
0
N
Caption: Shipper

19
ins_perc
Numeric
7
4
N
Caption: Insurance Percentage
Total record size: 144

Table: au!size

# Field Name Type Len Dec Null

1
siz_pk
Integer
4
0
N
Caption: Bottle Size Primary Key

2
siz_code
Character
4
0
N
Caption: Bottle Size Code

3
siz_descr
Character
40
0
N
Caption: Bottle Size Description

4
literage
Numeric
9
1
N
Caption: Literage

5
siz_text
Character
20
0
N
Caption: Size Text

6
conv_factor
Numeric
8
2
N
Caption: Conversion Factor from Bottles

7
upercase
Numeric
3
0
N
Caption: Bottles per case

8
last_edit
Date
8
0
N
Caption: Last Edit

9
last_time
Character
6
0
N
Caption: Last Time

10
operator
Character
10
0
N
Caption: Operator

11
recdelete
Character
1
0
N
Caption: Delete

12
mergeto
Character
4
0
N
Caption: Mergeto

13
link_to
Character
7
0
N
Caption: Link To
Total record size: 125

Table: au!specinfo

# Field Name Type Len Dec Null

1
spe_pk
Integer
4
0
N
Caption: Primary Key

2
spec_info
Character
10
0
N
Caption: Code

3
descrip
Character
40
0
N
Caption: Description

4
s1
Character
1
0
N

5
s2
Character
1
0
N

6
operator
Character
10
0
N

7
last_edit
Date
8
0
N

8
last_time
Character
6
0
N
Total record size: 81

Table: au!stamps

# Field Name Type Len Dec Null

1
sta_pk
Integer
4
0
N

2
category
Character
8
0
N
Caption: Category

3
sta_catfk
Integer
4
0
N
Caption: Category Foreign Key

4
srtorder
Character
40
0
N
Caption: Catalog Number

5
descrip
Character
250
0
N
Caption: Description

6
year
Character
4
0
N
Caption: Year

7
scottnum
Character
30
0
N
Caption: Scott No.

8
gibbons
Character
30
0
N
Caption: Gibbons

9
topics
Character
80
0
N
Caption: Topics

10
last_edit
Date
8
0
N
Caption: Last Edit

11
value0
Numeric
8
2
N
Caption: Value

12
value1
Numeric
8
2
N
Caption: Value

13
value2
Numeric
8
2
N
Caption: Value

14
value3
Numeric
8
2
N
Caption: Value

15
value4
Numeric
8
2
N
Caption: Value

16
value5
Numeric
8
2
N
Caption: Value

17
value6
Numeric
8
2
N
Caption: Value

18
value7
Numeric
8
2
N
Caption: Value

19
value8
Numeric
8
2
N
Caption: Value

20
value9
Numeric
8
2
N
Caption: Value

21
value10
Numeric
8
2
N
Caption: Value10

22
value11
Numeric
8
2
N
Caption: Value11

23
loc0
Character
5
0
N
Caption: Location

24
loc1
Character
5
0
N
Caption: Location

25
loc2
Character
5
0
N
Caption: Location

26
loc3
Character
5
0
N
Caption: Location

27
loc4
Character
5
0
N
Caption: Location

28
loc5
Character
5
0
N
Caption: Location

29
loc6
Character
5
0
N
Caption: Location

30
loc7
Character
5
0
N
Caption: Location

31
loc8
Character
5
0
N
Caption: Location

32
loc9
Character
5
0
N
Caption: Location

33
loc10
Character
5
0
N
Caption: Loc10

34
loc11
Character
5
0
N
Caption: Loc11

35
qty0
Numeric
5
0
N
Caption: Quantity

36
qty1
Numeric
5
0
N
Caption: Quantity

37
qty2
Numeric
5
0
N
Caption: Quantity

38
qty3
Numeric
5
0
N
Caption: Quantity

39
qty4
Numeric
5
0
N
Caption: Quantity

40
qty5
Numeric
5
0
N
Caption: Quantity

41
qty6
Numeric
5
0
N
Caption: Quantity

42
qty7
Numeric
5
0
N
Caption: Quantity

43
qty8
Numeric
5
0
N
Caption: Quantity

44
qty9
Numeric
5
0
N
Caption: Quantity

45
qty10
Numeric
5
0
N
Caption: Qty10

46
qty11
Numeric
11
0
N
Caption: Qty11

47
notes0
Character
10
0
N
Caption: Notes

48
notes1
Character
10
0
N
Caption: Notes

49
notes2
Character
10
0
N
Caption: Notes

50
notes3
Character
10
0
N
Caption: Notes

51
notes4
Character
10
0
N
Caption: Notes

52
notes5
Character
10
0
N
Caption: Notes

53
notes6
Character
10
0
N
Caption: Notes

54
notes7
Character
10
0
N
Caption: Notes

55
notes8
Character
10
0
N
Caption: Notes

56
notes9
Character
10
0
N
Caption: Notes

57
notes10
Character
10
0
N
Caption: Notes10

58
notes11
Character
10
0
N
Caption: Notes11

59
notes
Memo
4
0
N
Caption: Notes

60
fdccities
Numeric
3
0
N
Caption: FDC Cities

61
operator
Character
10
0
N
Caption: Operator

62
last_time
Character
6
0
N
Caption: Last Time

63
perc0
Numeric
4
0
N
Caption: Perc0

64
perc1
Numeric
4
0
N
Caption: Perc1

65
perc2
Numeric
4
0
N
Caption: Perc2

66
perc3
Numeric
4
0
N
Caption: Perc3

67
perc4
Numeric
4
0
N
Caption: Perc4

68
perc5
Numeric
5
0
N
Caption: Perc5

69
perc6
Numeric
4
0
N
Caption: Perc6

70
perc7
Numeric
4
0
N
Caption: Perc7

71
perc8
Numeric
4
0
N
Caption: Perc8

72
perc9
Numeric
4
0
N
Caption: Perc9

73
perc10
Numeric
4
0
N
Caption: Perc10

74
perc11
Numeric
4
0
N
Caption: Perc11

75
mint_add
Character
250
0
N
Caption: Mint Add

76
used_add
Character
250
0
N
Caption: Used Add

77
full_text
Memo
4
0
N
Caption: Full Text

78
shortdesc
Character
100
0
N
Caption: Shortdesc

79
variant
Character
1
0
N
Caption: Variant

80
refcopy
Character
10
0
N
Caption: Refcopy

81
stocked
Character
1
0
N
Caption: Stocked

82
setcont
Character
150
0
N
Caption: Set
Total record size: 1639

Table: au!state

# Field Name Type Len Dec Null

1
sta_pk
Integer
4
0
N

2
st_ab
Character
3
0
N
Caption: State Abbrev.

3
st_name
Character
25
0
N
Caption: State Name

4
st_type
Character
1
0
N
Caption: State or County

5
tax_rate
Numeric
6
3
N
Caption: Tax Rate

6
taxable
Character
1
0
N
Caption: Taxable

7
post_code
Character
10
0
N

8
eff_date
Date
8
0
N
Caption: Eff Date

9
operator
Character
10
0
N
Caption: Operator

10
last_edit
Date
8
0
N
Caption: Last Edit

11
last_time
Character
6
0
N
Caption: Last Time
Total record size: 83

Table: au!tasting

# Field Name Type Len Dec Null

1
tas_pk
Integer
4
0
N
Caption: Tasting Primary Key

2
tas_winfk
Integer
4
0
N
Caption: Wine Foreign Key

3
tas_grofk
Integer
4
0
N
Caption: Grower Foreign Key

4
vintage
Character
4
0
N
Caption: Vintage

5
note
Memo
4
0
N
Caption: Tasting Note

6
last_edit
Date
8
0
N
Caption: Last Edit

7
last_time
Character
6
0
N
Caption: Last Time

8
operator
Character
20
0
N
Caption: Operator

9
date_note
Date
8
0
N
Caption: Date of Note

10
note_by
Character
5
0
N
Caption: Note By

11
rating
Numeric
6
2
N
Caption: Rating

12
drink_from
Character
6
0
N
Caption: Drink From

13
drink_to
Character
6
0
N
Caption: Drink To

14
perf_with
Character
40
0
N
Caption: Perfect With

15
reference
Memo
4
0
N
Caption: Reference Note

16
ratingtxt
Character
10
0
N
Caption: Rating Text

17
shortnote
Character
150
0
N
Caption: Short Note

18
production
Memo
4
0
N
Caption: Production Note

19
longnote
Memo
4
0
N
Caption: Longnote
Total record size: 298

Table: au!taxtbl

# Field Name Type Len Dec Null

1
tax_pk
Numeric
8
0
N
Caption: Primary Key

2
zip1
Character
8
0
N
Caption: Starting Zip Range

3
city
Character
28
0
N
Caption: City

4
county
Character
25
0
N
Caption: County

5
state
Character
19
0
N
Caption: State Name

6
zip2
Character
5
0
N
Caption: Ending Zip Range

7
tax_rate
Numeric
7
4
N
Caption: Tax Rate (Total)

8
tax_gst
Numeric
7
4
N
Caption: Tax Gst

9
last_edit
Date
8
0
N
Caption: Last Edit

10
last_time
Character
6
0
N
Caption: Last Time

11
operator
Character
10
0
N
Caption: Operator

12
tax_state
Numeric
7
4
N
Caption: State Component

13
tax_county
Numeric
7
4
N
Caption: County Component

14
tax_city
Numeric
7
4
N
Caption: City Component
Total record size: 153

Table: au!tranxtn

# Field Name Type Len Dec Null

1
trx_pk
Integer
4
0
N
Caption: Primary Key

2
cust_no
Character
6
0
N
Caption: Cust No.

3
trx_cusfk
Integer
4
0
N
Caption: Consignor or Customer Foreign Key

4
invoice
Character
6
0
N
Caption: Invoice

5
trx_invfk
Integer
4
0
N
Caption: Invoice Foreign Key

6
trx_apfk
Integer
4
0
N
Caption: AP Foreign Key

7
sale_no
Character
5
0
N
Caption: Sale No.

8
trx_salfk
Integer
4
0
N
Caption: Sale Foreign Key

9
trx_amount
Numeric
11
2
N
Caption: Amount Paid

10
trx_date
Date
8
0
N
Caption: Date

11
trx_ref
Character
20
0
N
Caption: Reference No.

12
trx_type
Character
12
0
N
Caption: Trx Type

13
operator
Character
10
0
N
Caption: Operator

14
last_edit
Date
8
0
N
Caption: Last Edit

15
last_time
Character
6
0
N
Caption: Last Time

16
sort_code
Character
3
0
N
Caption: Sort Code

17
exported
Logical
1
0
N
Caption: Exported
Total record size: 117

Table: au!txtstore

# Field Name Type Len Dec Null

1
txt_pk
Integer
4
0
N
Caption: Text Storage Primary Key

2
txt_code
Character
30
0
N
Caption: Text File Message Code

3
txtdescrip
Character
75
0
N
Caption: Description of Text

4
textfile
Memo
4
0
N
Caption: Contents

5
dformat
Character
2
0
N
Caption: Division Code
Total record size: 116

Table: au!upszone

# Field Name Type Len Dec Null

1
ups_pk
Integer
4
0
N
Caption: Shipping Zones Primary Key

2
zip1
Character
5
0
N

3
zip2
Character
5
0
N

4
zone
Character
2
0
N

5
last_time
Character
6
0
N
Caption: Last Time

6
last_edit
Date
8
0
N
Caption: Last Edit

7
operator
Character
10
0
N
Caption: Operator

8
allowship
Character
1
0
N
Caption: Shipping is Allowed to this Zip Code Range

9
ucarrier
Character
10
0
N
Caption: Suggested Shipping Method
Total record size: 52

Table: au!useraccexceptions

# Field Name Type Len Dec Null

1
uae_pk
Integer
4
0
N
Caption: Primary Key
Default: x3genpk("USERACCEXCEPTIONS","AU")

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

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

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

Table: au!usergroups

# Field Name Type Len Dec Null

1
ugr_pk
Integer
4
0
N
Caption: Primary Key
Default: x3genpk("USERGROUPS","AU")

2
ugr_group
Character
20
0
N
Caption: Group

3
ugr_description
Character
60
0
N
Caption: Description

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

5
ugr_type
Character
1
0
N
Caption: Master Group Type
Total record size: 87

Table: au!userprefs

# Field Name Type Len Dec Null

1
prf_usrfk
Integer
4
0
N
Comments: Foreign key to the USERS table

2
prf_item
Character
115
0
N
Comments: Preference item

3
prf_itemdatatype
Character
1
0
N
Comments: Data type for Prf_ItemValue (C,N,L,D,T)

4
prf_itemvalue
Character
254
0
Y
Comments: Prf_Item value

5
prf_itemdescription
Character
254
0
N
Comments: Description of Prf_Item

6
prf_designedvalue
Character
254
0
Y
Total record size: 883

Table: au!users

# Field Name Type Len Dec Null

1
usr_pk
Integer
4
0
N
Caption: Primary Key
Comments: System-generated Primary Key
Default: x3genpk("USERS","AU")

2
usr_lanid
Character
10
0
N
Caption: UserName
Comments: User's UserName/ID (login UserID)

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

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

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

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

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

8
usr_firstname
Character
15
0
N
Caption: First Name

9
usr_middleinitial
Character
1
0
N
Caption: Middle Initial

10
usr_lastname
Character
20
0
N
Caption: Last Name

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

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

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

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

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

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

17
usr_sale
Character
5
0
N
Caption: Last sale number

18
usr_emailserver
Character
50
0
N
Caption: User Outgoing Email Server

19
usr_emailname
Character
50
0
N
Caption: eMail Authentication Name

20
usr_emailpassword
Character
20
0
N
Caption: User eMail Authentication Password

21
usr_email
Character
60
0
N
Caption: User Email Address

22
usr_seqnum
Character
7
0
N
Caption: Usr Seqnum

23
usr_dformat
Character
2
0
N
Caption: Division

24
usr_lastseq
Character
7
0
N
Caption: Usr Lastseq

25
usr_prntlbl
Character
1
0
N
Caption: User Print Label
Total record size: 325

Table: au!usrgrpxref

# Field Name Type Len Dec Null

1
ugx_pk
Integer
4
0
N
Caption: Primary Key
Default: x3genpk("USRGRPXREF","AU")

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

3
ugx_memberfk
Integer
4
0
N
Caption: Member
Comments: User/Group

4
ugx_membertype
Character
1
0
N
Caption: Member Type "U"ser or "G"roup
Default: "U"
Validation Rule: INLIST(ugx_membertype,"U","G")
Validation Text: xxfwruleerrortext("FR_UGX_MemberType","Member Type must be 'U' or 'G'.")
Total record size: 14

Table: au!vatcode

# Field Name Type Len Dec Null

1
vat_pk
Integer
4
0
N
Caption: Vat Code Primary Key

2
vat_code
Character
4
0
N
Caption: Vat Code

3
vat_descr
Character
40
0
N
Caption: Vat Code Description

4
vat_cat
Character
3
0
N
Caption: Code Used in Catalog

5
vat_sort
Character
2
0
N
Caption: Vat Sort in Catalog

6
last_edit
Date
8
0
N
Caption: Last Edit

7
last_time
Character
6
0
N
Caption: Last Time

8
operator
Character
10
0
N
Caption: Operator
Total record size: 78

Table: au!vmpri

# Field Name Type Len Dec Null

1
xri_parent_tablename
Character
128
0
N

2
xri_child_tablename
Character
128
0
N

3
xri_child_index_tag
Character
10
0
N

4
xri_insert_type
Character
1
0
N
Comments: Valid values are: 'I'nsert-Allow insert, 'R'estrict-No insert unless parent exists

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

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

Table: au!wantlist

# Field Name Type Len Dec Null

1
wl_pk
Integer
4
0
N

2
category
Character
8
0
N
Caption: Category Code

3
wl_catfk
Integer
4
0
N
Caption: Category Foreign Key

4
cust_no
Character
6
0
N
Caption: Cust No

5
wl_cusfk
Integer
4
0
N
Caption: Customer Foreign Key

6
symbol
Character
8
0
N
Caption: Symbol

7
level
Character
4
0
N
Caption: Level

8
condition
Character
8
0
N
Caption: Condition

9
srtorder
Character
40
0
N
Caption: Srtorder

10
est_real
Numeric
11
2
N
Caption: Est Real

11
ref_num
Character
30
0
N
Caption: Ref Num

12
est_low
Numeric
11
2
N
Caption: Est Low

13
catalog
Character
15
0
N
Caption: Catalog

14
catalog_no
Character
30
0
N
Caption: Catalog No

15
cat_value
Numeric
11
2
N
Caption: Cat Value

16
notes
Character
64
0
N
Caption: Notes

17
gum
Character
12
0
N
Caption: Gum

18
last_edit
Date
8
0
N
Caption: Last Edit

19
operator
Character
10
0
N
Caption: Operator

20
last_time
Character
6
0
N
Caption: Last Time

21
sgyr
Character
4
0
N
Caption: Sgyr

22
sgval
Character
4
0
N
Caption: Sgval

23
scyr
Character
4
0
N
Caption: Scyr

24
scval
Character
4
0
N
Caption: Scval

25
exyr
Character
4
0
N
Caption: Exyr

26
exval
Character
4
0
N
Caption: Exval
Total record size: 319

Table: au!wbids

# Field Name Type Len Dec Null

1
firm_id
Character
2
0
N
Caption: Firm Identifier

2
sale_no
Character
4
0
N
Caption: Sale No.

3
lot_no
Character
5
0
N
Caption: Lot No.

4
cust_no
Character
6
0
N
Caption: Customer No.

5
handle
Character
20
0
N
Caption: Web Unique Id

6
amount
Numeric
11
2
N
Caption: Amount of Bid

7
or_ind
Character
2
0
N
Caption: OR Indicator

8
ignore
Logical
1
0
N
Caption: not used

9
comments
Character
40
0
N
Caption: not used

10
bid
Numeric
11
2
N
Caption: Bid Amount (same as or greater than Amount)

11
drop
Logical
1
0
N

12
date_rcvd
Date
8
0
N
Caption: Date Received

13
rank
Numeric
3
0
N
Caption: not used

14
last_edit
Date
8
0
N
Caption: Last Changed

15
last_time
Character
6
0
N
Caption: Last Time

16
misc_info
Character
2
0
N
Caption: "IB" if Internet Bid, "IF" if Live Floor Bid

17
oth_phone
Character
60
0
N
Caption: not used

18
update
Character
1
0
N
Caption: not used

19
limit_amt
Numeric
11
2
N
Caption: Limit Amt

20
bidsheet
Numeric
6
0
N
Caption: Bidsheet Id
Total record size: 209

Table: au!wbidsin

# Field Name Type Len Dec Null

1
firm_id
Character
2
0
N

2
sale_no
Character
4
0
N

3
lot_no
Character
5
0
N

4
cust_no
Character
6
0
N

5
handle
Character
20
0
N

6
amount
Numeric
11
2
N

7
or_ind
Character
2
0
N

8
ignore
Logical
1
0
N

9
comments
Character
40
0
N

10
bid
Numeric
11
2
N

11
drop
Logical
1
0
N

12
date_rcvd
Date
8
0
N

13
rank
Numeric
3
0
N

14
last_edit
Date
8
0
N

15
last_time
Character
6
0
N

16
misc_info
Character
2
0
N

17
oth_phone
Character
60
0
N

18
update
Character
1
0
N

19
limit_amt
Numeric
11
2
N
Caption: Limit Amt

20
bidsheet
Numeric
6
0
N
Caption: Bidsheet Id
Total record size: 209

Table: au!wbidsout

# Field Name Type Len Dec Null

1
firm_id
Character
2
0
N

2
sale_no
Character
4
0
N

3
lot_no
Character
5
0
N

4
cust_no
Character
6
0
N

5
handle
Character
20
0
N

6
amount
Numeric
11
2
N

7
or_ind
Character
2
0
N

8
ignore
Logical
1
0
N

9
comments
Character
40
0
N

10
bid
Numeric
11
2
N

11
drop
Logical
1
0
N

12
date_rcvd
Date
8
0
N

13
rank
Numeric
3
0
N

14
last_edit
Date
8
0
N

15
last_time
Character
6
0
N

16
misc_info
Character
2
0
N

17
oth_phone
Character
60
0
N

18
update
Character
1
0
N

19
limit_amt
Numeric
11
2
N
Caption: Limit Amt

20
bidsheet
Numeric
6
0
N
Caption: Bidsheet Id
Total record size: 209

Table: au!wclass

# Field Name Type Len Dec Null

1
cla_pk
Integer
4
0
N
Caption: Classification Primary Key

2
cla_code
Character
4
0
N
Caption: Classification Code

3
cla_descr
Character
40
0
N
Caption: Classification Description

4
last_edit
Date
8
0
N
Caption: Last Date

5
last_time
Character
6
0
N
Caption: Last Time

6
operator
Character
10
0
N
Caption: Operator

7
recdelete
Character
1
0
N
Caption: Delete

8
mergeto
Character
4
0
N
Caption: Mergeto

9
sort_code
Character
5
0
N
Caption: Sort Code
Total record size: 83

Table: au!wconvert

# Field Name Type Len Dec Null

1
cust_no
Character
6
0
N
Caption: Customer Number (AMS/WMS sets this value)

2
cust_lname
Character
30
0
N
Caption: Last Name

3
cust_fname
Character
20
0
N
Caption: First Name and Middle Initial

4
attention
Character
40
0
N
Caption: Attention Line

5
addr1
Character
42
0
N
Caption: Address Line 1 (Account)

6
addr2
Character
42
0
N
Caption: Address Line 2 (Account)

7
addr3
Character
42
0
N
Caption: Address Line 3 (Account)

8
city
Character
25
0
N
Caption: City

9
state
Character
3
0
N
Caption: State

10
county
Character
3
0
N
Caption: County Code (not country)

11
zip
Character
10
0
N
Caption: Zip Code

12
wphone
Character
22
0
N
Caption: Work Phone

13
hphone
Character
22
0
N
Caption: Home Phone

14
fphone
Character
22
0
N
Caption: Fax Phone

15
ophone
Character
22
0
N
Caption: Other Phone

16
country
Character
25
0
N
Caption: Country

17
cred_no
Character
24
0
N
Caption: Credit Card Number

18
cred_name
Character
20
0
N
Caption: Name on Card

19
cred_init
Character
5
0
N
Caption: Init Date

20
cred_exp
Character
5
0
N
Caption: Expiration Date

21
cred_type
Character
5
0
N
Caption: Type of Card (VISA, MC, AMEX, etc...)

22
credit1
Character
60
0
N
Caption: Credit References

23
credit2
Character
60
0
N
Caption: Credit References

24
credit3
Character
60
0
N
Caption: Credit References

25
credit4
Character
60
0
N
Caption: Credit References

26
last_edit
Date
8
0
N
Caption: Date Stamped when Last Edited

27
last_time
Character
6
0
N
Caption: Time Stamped when Last Edited

28
operator
Character
10
0
N
Caption: Who Last Edited

29
creator
Character
10
0
N
Caption: Who Created the record

30
add_date
Date
8
0
N
Caption: Date Created

31
break_tie
Logical
1
0
N
Caption: Break Tie

32
incr_bid
Logical
1
0
N
Caption: Increase Bid

33
email
Character
65
0
N
Caption: Primary Email Address

34
wre_cusfk
Integer
4
0
N
Caption: Primary Key of Customer in AMS/WMS System

35
cou_ab
Character
3
0
N
Caption: Country Code

36
company
Character
65
0
N
Caption: Company (if the account is a company)

37
fullsal
Character
20
0
N
Caption: Fullsal

38
position
Character
20
0
N
Caption: Position

39
sales_mgr
Character
20
0
N
Caption: Sales Mgr

40
source
Character
10
0
N
Caption: Source

41
sales_rep
Character
10
0
N
Caption: Sales Rep

42
bbr_number
Character
6
0
N
Caption: Bbr Number

43
cred_limit
Numeric
6
0
N
Caption: Cred Limit

44
resale_no
Character
20
0
N
Caption: Resale No

45
sub_info
Character
10
0
N
Caption: Sub Info

46
notes
Memo
4
0
N
Caption: Notes

47
fedtaxid
Character
11
0
N
Caption: Fedtaxid

48
custom1
Character
20
0
N
Caption: Custom1

49
interest
Character
30
0
N
Caption: Interest

50
div2
Logical
1
0
N
Caption: Div2

51
div3
Logical
1
0
N
Caption: Div3

52
ib_number
Character
10
0
N
Caption: Ib Number

53
cou_coufk
Integer
4
0
N
Caption: Cou Coufk

54
spec_info
Character
10
0
N
Caption: Spec Info

55
matchon
Character
10
0
N
Caption: Matchon

56
ship_via
Character
30
0
N
Caption: Ship Via

57
pnotes
Memo
4
0
N
Caption: Partner Internal Notes

58
pconfident
Memo
4
0
N
Caption: Partner Confidential Notes

59
btotal
Numeric
12
2
N
Caption: Partner Buying Total

60
stotal
Numeric
12
2
N
Caption: Partner Selling Total

61
ourcustno
Character
6
0
N
Caption: Our Customer Number for reverse Matching
Total record size: 1148

Table: au!weights

# Field Name Type Len Dec Null

1
wgt_pk
Integer
4
0
N
Caption: Primary Key

2
code
Character
15
0
N
Caption: Code

3
weight
Numeric
6
2
N
Caption: Weight

4
operator
Character
10
0
N

5
last_edit
Date
8
0
N

6
last_time
Character
6
0
N
Total record size: 50

Table: au!whse

# Field Name Type Len Dec Null

1
whs_pk
Integer
4
0
N

2
whs_code
Character
6
0
N
Caption: Warehouse Code

3
whs_cntry
Character
20
0
N
Caption: Country

4
whs_coufk
Integer
4
0
N
Caption: Country Foreign Key

5
whs_name
Character
40
0
N
Caption: Warehouse Name

6
whs_catnm
Character
40
0
N
Caption: Warehouse Name used in Catalog

7
whs_addr1
Character
42
0
N
Caption: Address 1

8
whs_addr2
Character
42
0
N
Caption: Address 2

9
whs_addr3
Character
42
0
N
Caption: Address 3

10
whs_city
Character
25
0
N
Caption: City

11
whs_state
Character
3
0
N
Caption: State

12
whs_zip
Character
10
0
N
Caption: Zip Code

13
whs_phone
Character
17
0
N
Caption: Work Phone

14
whs_email
Character
50
0
N
Caption: eMail

15
whs_fax
Character
17
0
N
Caption: Fax Phone

16
operator
Character
10
0
N
Caption: Operator

17
last_edit
Date
8
0
N
Caption: Last Edit

18
last_time
Character
6
0
N
Caption: Last Time

19
wshipper
Character
6
0
N
Caption: Default Shipper

20
cou_ab
Character
3
0
N
Caption: Country Code
Total record size: 396

Table: au!wine

# Field Name Type Len Dec Null

1
win_pk
Integer
4
0
N
Caption: Wine Primary Key

2
win_code
Character
5
0
N
Caption: Wine Code

3
win_descr
Character
80
0
N
Caption: Wine Description

4
perc_alcoh
Numeric
6
2
N
Caption: Percent Alcohol

5
win_catfk
Integer
4
0
N
Caption: Foreign Key from Category

6
win_appfk
Integer
4
0
N
Caption: Appellation Foreign Key

7
win_clafk
Integer
4
0
N
Caption: Wine Classification Foreign Key

8
last_edit
Date
8
0
N
Caption: Last Edit

9
last_time
Character
6
0
N
Caption: Last Time

10
operator
Character
10
0
N
Caption: Operator

11
win_note
Memo
4
0
N
Caption: Win Note

12
wcat_note
Memo
4
0
N
Caption: Wine Catalog Note

13
recdelete
Character
1
0
N
Caption: Delete

14
mergeto
Character
5
0
N
Caption: Mergeto

15
link_to
Character
9
0
N
Caption: Link To
Total record size: 155

Table: au!winehx

# Field Name Type Len Dec Null

1
whx_pk
Integer
4
0
N
Caption: Wine Pricing Primary Key

2
whx_winfk
Integer
4
0
N
Caption: Wine Foreign Key

3
whx_grofk
Integer
4
0
N
Caption: Grower Foreign Key

4
vintage
Character
4
0
N
Caption: Vintage

5
siz_code
Character
4
0
N
Caption: Siz Code

6
whx_sizfk
Integer
4
0
N
Caption: Price History Size Foreign Key

7
date
Date
8
0
N
Caption: Date

8
sale_no
Character
8
0
N
Caption: Sale No

9
whx_salfk
Integer
4
0
N
Caption: Sale Foreign Key

10
lot_no
Character
5
0
N
Caption: Lot No

11
pr_type
Character
4
0
N
Caption: Pr Type

12
realized
Numeric
11
2
N
Caption: Realized

13
um
Character
10
0
N
Caption: Um

14
upercase
Numeric
8
2
N
Caption: Bottles Per Case

15
cases
Numeric
4
0
N
Caption: Cases

16
bottles
Numeric
4
0
N
Caption: Bottles

17
tax_status
Character
5
0
N
Caption: Tax Status

18
est_low
Numeric
12
2
N
Caption: Low Estimate

19
est_real
Numeric
12
2
N
Caption: High Estimate

20
last_time
Character
6
0
N
Caption: Last Time

21
last_edit
Date
8
0
N
Caption: Last Edit

22
operator
Character
10
0
N
Caption: Operator

23
source
Character
6
0
N
Caption: Source

24
category
Character
8
0
N
Caption: Category

25
srtorder
Character
4
0
N
Caption: Srtorder

26
lot_catfk
Integer
4
0
N
Caption: Lot Catfk

27
consignor
Character
6
0
N
Caption: Consignor

28
lot_confk
Integer
4
0
N
Caption: Lot Confk

29
cust_no
Character
6
0
N
Caption: Cust No

30
lot_buyfk
Integer
4
0
N
Caption: Lot Buyfk

31
est_cons
Numeric
11
2
N
Caption: Est Cons

32
lot_descr
Memo
4
0
N
Caption: Lot Descr

33
reserve
Numeric
11
2
N
Caption: Reserve

34
retail
Numeric
11
2
N
Caption: Retail

35
number_lot
Numeric
6
0
N
Caption: Number Lot
Total record size: 229

Table: au!wineprx

# Field Name Type Len Dec Null

1
wpx_pk
Integer
4
0
N
Caption: Wine Pricing Primary Key

2
wpx_winfk
Integer
4
0
N
Caption: Wine Foreign Key

3
wpx_grofk
Integer
4
0
N
Caption: Grower Foreign Key

4
vintage
Character
4
0
N
Caption: Vintage

5
est_low
Numeric
12
2
N
Caption: Low Estimate

6
est_real
Numeric
12
2
N
Caption: High Estimate

7
reserve
Numeric
12
2
N
Caption: Reserve

8
last_edit
Date
8
0
N
Caption: Last Edit

9
last_time
Character
6
0
N
Caption: Last Time

10
operator
Character
10
0
N
Caption: Operator

11
retail
Numeric
12
2
N
Caption: Retail

12
est_cons
Numeric
11
2
N
Caption: Estimate to the Consignor

13
price3
Numeric
11
2
N
Caption: Cost

14
vendor
Character
6
0
N
Caption: Vendor

15
wpx_cusfk
Integer
4
0
N
Caption: Vendor Foreign Key

16
allow_bo
Character
10
0
N
Caption: Allow Back Order and Timing

17
number_bo
Numeric
6
0
N
Caption: Qty that can be Backordered
Total record size: 137

Table: au!wlots

# Field Name Type Len Dec Null

1
wlo_pk
Integer
4
0
N

2
wlo_xxxfk
Integer
4
0
N

3
firm_id
Character
2
0
N

4
sale_no
Character
4
0
N

5
lot_no
Character
5
0
N

6
category
Character
8
0
N

7
majgroup
Character
50
0
N

8
catdescr
Character
50
0
N

9
subgroup
Character
50
0
N

10
order
Character
25
0
N

11
symbol
Character
5
0
N

12
condition
Character
8
0
N

13
gum
Character
5
0
N

14
shrttext
Character
60
0
N

15
htmltext
Memo
4
0
N

16
htmlfile
Character
20
0
N

17
inlineimg
Character
100
0
N

18
linkedimg
Character
100
0
N

19
descrip
Character
250
0
N

20
est_low
Numeric
11
2
N

21
est_real
Numeric
11
2
N

22
price3
Numeric
11
2
N

23
est_code
Character
1
0
N

24
seq_num
Character
6
0
N

25
opening
Numeric
11
2
N

26
man_open
Character
1
0
N

27
realized
Numeric
11
2
N

28
reserve
Numeric
11
2
N

29
number_lot
Numeric
5
0
N

30
high_bid
Numeric
11
2
N

31
bid
Numeric
11
2
N

32
notes
Character
64
0
N

33
currency
Character
3
0
N

34
catalog
Character
15
0
N

35
box_lot
Character
1
0
N

36
spill
Memo
4
0
N

37
bidder
Character
6
0
N

38
last_edit
Date
8
0
N

39
last_time
Character
6
0
N

40
num_bids
Numeric
4
0
N

41
net_resv
Character
1
0
N

42
ceiling
Logical
1
0
N

43
soldtime
Character
14
0
N

44
image
Character
1
0
N

45
deskkey
Character
1
0
N

46
update
Character
1
0
N

47
close_date
Date
8
0
N

48
start_date
Date
8
0
N

49
close_ch14
Character
17
0
N

50
start_ch14
Character
17
0
N

51
cust_no
Character
6
0
N

52
paddle
Character
4
0
N

53
lot_value
Character
40
0
N

54
primarykey
Character
11
0
N
Total record size: 1097

Table: au!wreal

# Field Name Type Len Dec Null

1
firm_id
Character
2
0
N

2
sale_no
Character
4
0
N

3
lot_no
Character
5
0
N

4
realized
Numeric
11
2
N

5
bidder
Character
6
0
N

6
cust_no
Character
6
0
N

7
paddle
Character
4
0
N

8
opening
Numeric
11
2
N

9
reserve
Numeric
11
2
N
Total record size: 61

Table: au!wrealout

# Field Name Type Len Dec Null

1
firm_id
Character
2
0
N

2
sale_no
Character
4
0
N

3
lot_no
Character
5
0
N

4
realized
Numeric
11
2
N

5
bidder
Character
6
0
N

6
cust_no
Character
6
0
N

7
paddle
Character
4
0
N

8
opening
Numeric
11
2
N

9
reserve
Numeric
11
2
N
Total record size: 61

Table: au!wregi

# Field Name Type Len Dec Null

1
cust_no
Character
6
0
N
Caption: Customer Number (AMS/WMS sets this value)

2
firm_id
Character
2
0
N

3
handle
Character
20
0
N
Caption: unique id for Web Customer, use Web Key Field

4
approved
Character
1
0
N
Caption: Approved for Bidding

5
bid_anony
Character
1
0
N
Caption: not used

6
paddle
Character
4
0
N
Caption: Paddle Number

7
cust_lname
Character
30
0
N
Caption: Last Name

8
cust_fname
Character
20
0
N
Caption: First Name and Middle Initial

9
attention
Character
40
0
N
Caption: Attention Line

10
addr1
Character
42
0
N
Caption: Address Line 1 (Account)

11
addr2
Character
42
0
N
Caption: Address Line 2 (Account)

12
addr3
Character
42
0
N
Caption: Address Line 3 (Account)

13
city
Character
25
0
N
Caption: City

14
state
Character
3
0
N
Caption: State

15
county
Character
3
0
N
Caption: County Code (not country)

16
zip
Character
10
0
N
Caption: Zip Code

17
max_bid
Numeric
8
0
N
Caption: Limit Total Winnings to this amount

18
incr_by
Numeric
3
0
N
Caption: Increase my bids by this percentage

19
wphone
Character
22
0
N
Caption: Work Phone

20
hphone
Character
22
0
N
Caption: Home Phone

21
fphone
Character
22
0
N
Caption: Fax Phone

22
ophone
Character
22
0
N
Caption: Other Phone

23
country
Character
25
0
N
Caption: Country

24
cred_no
Character
24
0
N
Caption: Credit Card Number

25
cred_name
Character
20
0
N
Caption: Name on Card

26
cred_init
Character
5
0
N
Caption: Init Date

27
cred_exp
Character
5
0
N
Caption: Expiration Date

28
cred_type
Character
5
0
N
Caption: Type of Card (VISA, MC, AMEX, etc...)

29
credit1
Character
60
0
N
Caption: Credit References

30
credit2
Character
60
0
N
Caption: Credit References

31
credit3
Character
60
0
N
Caption: Credit References

32
credit4
Character
60
0
N
Caption: Credit References

33
last_edit
Date
8
0
N
Caption: Date Stamped when Last Edited

34
last_time
Character
6
0
N
Caption: Time Stamped when Last Edited

35
operator
Character
10
0
N
Caption: Who Last Edited

36
creator
Character
10
0
N
Caption: Who Created the record

37
add_date
Date
8
0
N
Caption: Date Created

38
break_tie
Logical
1
0
N
Caption: Break Tie

39
incr_bid
Logical
1
0
N
Caption: Increase Bid

40
email
Character
65
0
N
Caption: Primary Email Address

41
email2
Character
65
0
N
Caption: Second Email Address

42
remove
Character
1
0
N
Caption: Y = Remove from email distribution Lists

43
update
Character
1
0
N
Caption: not used

44
wre_cusfk
Integer
4
0
N
Caption: Primary Key of Customer in AMS/WMS System

45
sale_no
Character
4
0
N
Caption: Sale No

46
cou_ab
Character
3
0
N
Caption: Country Code

47
ship1
Character
40
0
N
Caption: Shipping Address (Starts with Name)

48
ship2
Character
40
0
N
Caption: Shipping Address

49
ship3
Character
40
0
N
Caption: Shipping Address

50
ship4
Character
40
0
N
Caption: Shipping Address

51
ship5
Character
40
0
N
Caption: Shipping Address

52
sh_city
Character
25
0
N
Caption: Shipping City

53
sh_state
Character
3
0
N
Caption: Shipping State

54
sh_zip
Character
10
0
N
Caption: Shipping Zip

55
sh_country
Character
25
0
N
Caption: Shipping Country

56
sh_cou_ab
Character
3
0
N
Caption: Shipping Country Abreviation

57
company
Character
65
0
N
Caption: Company (if the account is a company)
Total record size: 1233

Table: au!wregiin

# Field Name Type Len Dec Null

1
cust_no
Character
6
0
N

2
firm_id
Character
2
0
N

3
handle
Character
20
0
N

4
approved
Character
1
0
N

5
bid_anony
Character
1
0
N

6
paddle
Character
4
0
N

7
cust_lname
Character
30
0
N

8
cust_fname
Character
20
0
N

9
attention
Character
40
0
N

10
addr1
Character
42
0
N

11
addr2
Character
42
0
N

12
addr3
Character
42
0
N

13
city
Character
25
0
N

14
state
Character
3
0
N

15
county
Character
3
0
N

16
zip
Character
10
0
N

17
max_bid
Numeric
8
0
N

18
incr_by
Numeric
3
0
N

19
wphone
Character
17
0
N

20
hphone
Character
17
0
N

21
fphone
Character
17
0
N

22
ophone
Character
17
0
N

23
country
Character
25
0
N

24
cred_no
Character
24
0
N

25
cred_name
Character
20
0
N

26
cred_init
Character
5
0
N

27
cred_exp
Character
5
0
N

28
cred_type
Character
5
0
N

29
credit1
Character
60
0
N

30
credit2
Character
60
0
N

31
credit3
Character
60
0
N

32
credit4
Character
60
0
N

33
last_edit
Date
8
0
N

34
last_time
Character
6
0
N

35
operator
Character
10
0
N

36
creator
Character
10
0
N

37
add_date
Date
8
0
N

38
break_tie
Logical
1
0
N

39
incr_bid
Logical
1
0
N

40
email
Character
65
0
N

41
email2
Character
65
0
N

42
remove
Character
1
0
N

43
update
Character
1
0
N

44
sale_no
Character
4
0
N
Caption: Sale No

45
cou_ab
Character
3
0
N
Caption: Cou Ab

46
ship1
Character
40
0
N
Caption: Ship1

47
ship2
Character
40
0
N
Caption: Ship2

48
ship3
Character
40
0
N
Caption: Ship3

49
ship4
Character
40
0
N
Caption: Ship4

50
ship5
Character
40
0
N
Caption: Ship5

51
sh_city
Character
25
0
N
Caption: Sh City

52
sh_state
Character
3
0
N
Caption: Sh State

53
sh_country
Character
25
0
N
Caption: Sh Country

54
sh_cou_ab
Character
3
0
N
Caption: Sh Cou Ab

55
company
Character
65
0
N
Caption: Company
Total record size: 1199

Table: au!wregiout

# Field Name Type Len Dec Null

1
cust_no
Character
6
0
N

2
firm_id
Character
2
0
N

3
handle
Character
20
0
N

4
approved
Character
1
0
N

5
bid_anony
Character
1
0
N

6
paddle
Character
4
0
N

7
cust_lname
Character
30
0
N

8
cust_fname
Character
20
0
N

9
attention
Character
40
0
N

10
addr1
Character
42
0
N

11
addr2
Character
42
0
N

12
addr3
Character
42
0
N

13
city
Character
25
0
N

14
state
Character
3
0
N

15
county
Character
3
0
N

16
zip
Character
10
0
N

17
max_bid
Numeric
8
0
N

18
incr_by
Numeric
3
0
N

19
wphone
Character
17
0
N

20
hphone
Character
17
0
N

21
fphone
Character
17
0
N

22
ophone
Character
17
0
N

23
country
Character
25
0
N

24
cred_no
Character
24
0
N

25
cred_name
Character
20
0
N

26
cred_init
Character
5
0
N

27
cred_exp
Character
5
0
N

28
cred_type
Character
5
0
N

29
credit1
Character
60
0
N

30
credit2
Character
60
0
N

31
credit3
Character
60
0
N

32
credit4
Character
60
0
N

33
last_edit
Date
8
0
N

34
last_time
Character
6
0
N

35
operator
Character
10
0
N

36
creator
Character
10
0
N

37
add_date
Date
8
0
N

38
break_tie
Logical
1
0
N

39
incr_bid
Logical
1
0
N

40
email
Character
65
0
N

41
email2
Character
65
0
N

42
remove
Character
1
0
N

43
update
Character
1
0
N

44
sale_no
Character
4
0
N
Caption: Sale No

45
cou_ab
Character
3
0
N
Caption: Cou Ab

46
ship1
Character
40
0
N
Caption: Ship1

47
ship2
Character
40
0
N
Caption: Ship2

48
ship3
Character
40
0
N
Caption: Ship3

49
ship4
Character
40
0
N
Caption: Ship4

50
ship5
Character
40
0
N
Caption: Ship5

51
sh_city
Character
25
0
N
Caption: Sh City

52
sh_state
Character
3
0
N
Caption: Sh State

53
sh_zip
Character
10
0
N
Caption: Sh Zip

54
sh_country
Character
25
0
N
Caption: Sh Country

55
sh_cou_ab
Character
3
0
N
Caption: Sh Cou Ab

56
company
Character
65
0
N
Caption: Company
Total record size: 1209

Table: au!wureg

# Field Name Type Len Dec Null

1
wur_pk
Integer
4
0
N

2
wur_xxxfk
Integer
4
0
N

3
handle
Character
20
0
N

4
password
Character
20
0
N

5
bid_anony
Character
1
0
N

6
cust_lname
Character
30
0
N

7
cust_fname
Character
20
0
N

8
attention
Character
40
0
N

9
addr1
Character
42
0
N

10
addr2
Character
42
0
N

11
addr3
Character
42
0
N

12
city
Character
25
0
N

13
state
Character
3
0
N

14
county
Character
3
0
N

15
zip
Character
10
0
N

16
wphone
Character
17
0
N

17
hphone
Character
17
0
N

18
fphone
Character
17
0
N

19
ophone
Character
17
0
N

20
country
Character
20
0
N

21
credit1
Character
60
0
N

22
credit2
Character
60
0
N

23
credit3
Character
60
0
N

24
credit4
Character
60
0
N

25
last_edit
Date
8
0
N

26
last_time
Character
6
0
N

27
last_sign
Date
8
0
N

28
operator
Character
10
0
N

29
creator
Character
10
0
N

30
add_date
Date
8
0
N

31
email
Character
65
0
N

32
email2
Character
65
0
N

33
remove
Character
1
0
N

34
update
Character
1
0
N
Total record size: 817

Free Table: catalog

# Field Name Type Len Dec Null

1
clg_pk
Integer
4
0
N
Caption: Clg Pk

2
auctionco
Character
20
0
N
Caption: Auctionco

3
sale_no
Character
5
0
N
Caption: Sale No

4
category
Character
7
0
N
Caption: Category

5
lot_no
Character
5
0
N
Caption: Lot No

6
descrip
Character
250
0
N
Caption: Descrip

7
price3
Numeric
11
2
N
Caption: Price3

8
est_low
Numeric
11
2
N
Caption: Est Low

9
est_real
Numeric
11
2
N
Caption: Est Real

10
est_code
Character
10
0
N
Caption: Est Code

11
order
Character
20
0
N
Caption: Order

12
realized
Numeric
11
2
N
Caption: Realized

13
symbol
Character
5
0
N
Caption: Symbol

14
condition
Character
8
0
N
Caption: Condition

15
notes
Character
15
0
N
Caption: Notes

16
currency
Character
3
0
N
Caption: Currency

17
majgroup
Character
50
0
N
Caption: Majgroup

18
catdescr
Character
50
0
N
Caption: Catdescr

19
subgroup
Character
50
0
N
Caption: Subgroup

20
saledate
Character
15
0
N
Caption: Saledate

21
catalog
Character
10
0
N
Caption: Catalog

22
format
Character
2
0
N
Caption: Format

23
spill
Memo
4
0
N
Caption: Spill

24
country
Character
120
0
N
Caption: Country

25
photo
Character
1
0
N
Caption: Photo

26
seq_num
Character
6
0
N
Caption: Seq Num

27
plate
Character
10
0
N
Caption: Plate

28
header
Memo
4
0
N
Caption: Header

29
footer
Memo
4
0
N
Caption: Footer

30
ref_num
Character
15
0
N
Caption: Ref Num

31
gum
Character
5
0
N
Caption: Gum

32
loc2
Character
5
0
N
Caption: Loc2
Total record size: 748

Free Table: largelot

# Field Name Type Len Dec Null

1
lar_pk
Integer
4
0
N
Caption: Lar Pk

2
lar_xxxfk
Integer
4
0
N
Caption: Lar Xxxfk

3
lot_no
Character
5
0
N
Caption: Lot No

4
symbol
Character
5
0
N
Caption: Symbol

5
condition
Character
8
0
N
Caption: Condition

6
descrip
Character
250
0
N
Caption: Descrip

7
est_low
Numeric
11
2
N
Caption: Est Low

8
est_real
Numeric
11
2
N
Caption: Est Real

9
realized
Numeric
11
2
N
Caption: Realized

10
reserve
Numeric
11
2
N
Caption: Reserve

11
sale_no
Character
5
0
N
Caption: Sale No

12
seq_num
Character
6
0
N
Caption: Seq Num

13
ref_num
Character
15
0
N
Caption: Ref Num

14
plate
Character
10
0
N
Caption: Plate

15
category
Character
7
0
N
Caption: Category

16
consignor
Character
6
0
N
Caption: Consignor
Total record size: 370

Free Table: lotlabel

# Field Name Type Len Dec Null

1
lot_pk
Integer
4
0
N
Caption: Lot Pk

2
lot_xxxfk
Integer
4
0
N
Caption: Lot Xxxfk

3
sale_no
Character
5
0
N
Caption: Sale No

4
lot_no
Character
5
0
N
Caption: Lot No

5
descrip
Character
250
0
N
Caption: Descrip

6
photo
Character
1
0
N
Caption: Photo

7
est_low
Numeric
11
2
N
Caption: Est Low

8
est_real
Numeric
11
2
N
Caption: Est Real

9
price3
Numeric
11
2
N
Caption: Price3

10
est_code
Character
1
0
N
Caption: Est Code

11
order
Character
20
0
N
Caption: Order

12
seq_num
Character
6
0
N
Caption: Seq Num

13
category
Character
7
0
N
Caption: Category

14
prop_num
Character
4
0
N
Caption: Prop Num

15
consignor
Character
6
0
N
Caption: Consignor

16
cons_num
Character
12
0
N
Caption: Cons Num

17
realized
Numeric
11
2
N
Caption: Realized

18
reserve
Numeric
11
2
N
Caption: Reserve

19
number_lot
Numeric
5
0
N
Caption: Number Lot

20
symbol
Character
5
0
N
Caption: Symbol

21
condition
Character
8
0
N
Caption: Condition

22
notes
Character
64
0
N
Caption: Notes

23
currency
Character
3
0
N
Caption: Currency

24
catalog
Character
15
0
N
Caption: Catalog

25
box_lot
Character
1
0
N
Caption: Box Lot

26
spill
Memo
4
0
N
Caption: Spill

27
ref_num
Character
15
0
N
Caption: Ref Num

28
topics
Character
56
0
N
Caption: Topics

29
gum
Character
5
0
N
Caption: Gum

30
plate
Character
10
0
N
Caption: Plate

31
lot_notes
Memo
4
0
N
Caption: Lot Notes

32
date_buy
Date
8
0
N
Caption: Date Buy

33
country
Character
120
0
N
Caption: Country

34
header
Memo
4
0
N
Caption: Header

35
footer
Memo
4
0
N
Caption: Footer

36
year
Character
6
0
N
Caption: Year

37
postmark
Character
25
0
N
Caption: Postmark

38
price
Character
10
0
N
Caption: Price
Total record size: 753

Free Table: lotstat

# Field Name Type Len Dec Null

1
sort
Character
35
0
N
Caption: Sort

2
descrip
Character
30
0
N
Caption: Descrip

3
sale_no
Character
5
0
N
Caption: Sale No

4
est_low
Numeric
11
2
N
Caption: Est Low

5
est_real
Numeric
11
2
N
Caption: Est Real

6
order
Character
20
0
N
Caption: Order

7
category
Character
7
0
N
Caption: Category

8
consignor
Character
6
0
N
Caption: Consignor

9
realized
Numeric
11
2
N
Caption: Realized

10
reserve
Numeric
11
2
N
Caption: Reserve

11
box_lot
Character
1
0
N
Caption: Box Lot

12
ref_num
Character
15
0
N
Caption: Ref Num

13
plate
Character
6
0
N
Caption: Plate

14
num_lots
Numeric
5
0
N
Caption: Num Lots

15
sold_lots
Numeric
5
0
N
Caption: Sold Lots

16
sum_est
Numeric
11
2
N
Caption: Sum Est

17
sum_real
Numeric
11
2
N
Caption: Sum Real

18
sum_sold
Numeric
11
2
N
Caption: Sum Sold

19
num_bids
Numeric
4
0
N
Caption: Num Bids
Total record size: 217