|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sah_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sah__chr01
|
User Field#1
|
|
x(8)
|
|
|
|
sah__chr02
|
User Field #1
|
|
x(8)
|
|
|
|
sah__chr03
|
User Field #3
|
|
x(8)
|
|
|
|
sah__chr04
|
User Field #4
|
|
x(8)
|
|
|
|
sah__chr05
|
User Field #5
|
|
x(8)
|
|
|
|
sah__chr06
|
User Field #6
|
|
x(8)
|
|
|
|
sah__chr07
|
User Field #7
|
|
x(8)
|
|
|
|
sah__chr08
|
User Field #8
|
|
x(8)
|
|
|
|
sah__chr09
|
User Field #9
|
|
x(8)
|
|
|
|
sah__chr10
|
User Field #10
|
|
x(8)
|
|
|
|
sah__dec01
|
User Decimal #1
|
|
>>>,>>>,>>9.99
|
10
|
|
|
sah__dec02
|
User Decimal #2
|
|
>>>,>>>,>>9.99
|
10
|
|
|
sah__dec03
|
User Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sah__dte01
|
User Date #1
|
|
99/99/99
|
|
|
|
sah__dte02
|
User Date #2
|
|
99/99/99
|
|
|
|
sah__dte03
|
User Date #3
|
|
99/99/99
|
|
|
|
sah__log01
|
User Logical #1
|
|
yes/no
|
|
|
|
sah__log02
|
User Logical #2
|
|
yes/no
|
|
|
|
sah__log03
|
User Logical #3
|
|
yes/no
|
|
|
|
sah__qadc01
|
Qad Field #1
|
|
x(8)
|
|
|
|
sah__qadc02
|
Qad Field #2
|
|
x(8)
|
|
|
|
sah__qadc03
|
Qad Field #3
|
|
x(8)
|
|
|
|
sah__qadc04
|
Qad Field #4
|
|
x(8)
|
|
|
|
sah__qadc05
|
|
|
x(8)
|
|
|
|
sah__qadc06
|
|
|
x(4)
|
|
|
|
sah__qadd01
|
Qad Decimal #1
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sah__qadd02
|
Qad Decimal #2
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sah__qadd03
|
Qad Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sah__qadl01
|
Qad Logical #1
|
|
yes/no
|
|
|
|
sah__qadl02
|
Qad Logical #2
|
|
yes/no
|
|
|
|
sah__qadl03
|
Qad Logical #3
|
|
yes/no
|
|
|
|
sah__qadl04
|
QAD Logical Field
|
|
yes/no
|
|
|
|
sah__qadt01
|
Qad Date #1
|
|
99/99/99
|
|
|
|
sah__qadt02
|
Qad Date #2
|
|
99/99/99
|
|
|
|
sah__qadt03
|
Qad Date #3
|
|
99/99/99
|
|
|
|
sah_area
|
Area
|
|
x(8)
|
|
|
|
sah_arrears
|
Bill Arrears
|
Arrear
|
yes/no
|
|
|
|
sah_autornew
|
Auto Renew
|
A Renew
|
yes/no
|
|
|
|
sah_base_pct
|
Contract Base
|
|
>>>9.99<<<
|
10
|
|
|
sah_bill_cnt
|
Bill Count
|
Bill Cnt
|
->,>>>,>>9
|
|
|
|
sah_bill_to
|
Bill To
|
|
x(8)
|
|
|
|
sah_bill_type
|
Billing Type
|
|
x(8)
|
|
|
|
sah_blanket
|
Blanket Contract
|
|
yes/no
|
|
|
|
sah_bol
|
BOL
|
|
x(18)
|
|
|
|
sah_calls_allow
|
Calls Allowed
|
|
>>>,>>9
|
|
|
|
sah_calls_total
|
Total Calls
|
|
>>>,>>9
|
|
|
|
sah_can_tax
|
PST Pct
|
|
->>9.99<<%
|
10
|
|
|
sah_cancel
|
Cancel Date
|
|
99/99/99
|
|
|
|
sah_channel
|
Channel
|
|
x(8)
|
|
|
|
sah_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
sah_comm_pct[4]
|
Commission
|
Comm%
|
>>9.99%
|
10
|
|
|
sah_complete
|
Complete
|
Cplt
|
yes/no
|
|
|
|
sah_conf_date
|
Confirmed Date
|
Confirmed
|
99/99/99
|
|
|
|
sah_cr_card
|
Credit Card
|
Card
|
x(2)
|
|
|
|
sah_cr_init
|
Cr Initials
|
Initials
|
x(2)
|
|
|
|
sah_cr_terms
|
Credit Terms
|
Terms
|
x(8)
|
|
|
|
sah_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
sah_cust
|
Customer
|
|
x(8)
|
|
|
|
sah_cycle
|
Billing Cycle
|
Cyc
|
x(2)
|
|
|
|
sah_date_printed
|
Date Printed
|
|
99/99/99
|
|
|
|
sah_disc_pct
|
Disc %
|
|
->9.99%
|
10
|
|
|
sah_domain
|
Domain
|
|
x(8)
|
|
|
|
sah_end_date
|
End Date
|
|
99/99/99
|
|
|
|
sah_enduser
|
End User
|
|
x(8)
|
|
|
|
sah_ent_ex
|
Exch Rate
|
|
>>,>>9.99999<<<<<
|
10
|
|
|
sah_ex_rate
|
Exch Rate
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sah_ex_rate2
|
Exch Rate 2
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sah_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
sah_exp_date
|
Expire Date
|
Exp Date
|
99/99/99
|
|
|
|
sah_exru_seq
|
Sequence
|
|
>>>>>>>>9
|
|
|
|
sah_ext_date
|
Extend Date
|
Ext Date
|
99/99/9999
|
|
|
|
sah_fix_pr
|
Fixed Price
|
|
yes/no
|
|
|
|
sah_fix_rate
|
Fixed Rate
|
Fixed
|
yes/no
|
|
|
|
sah_fob
|
FOB Point
|
|
x(20)
|
|
|
|
sah_free_frm
|
Free Coverage From
|
|
99/99/99
|
|
|
|
sah_free_to
|
Free Coverage To
|
|
99/99/99
|
|
|
|
sah_fst_id
|
FST ID
|
|
x(16)
|
|
|
|
sah_gen_0itm
|
Generate 0$ Items
|
|
yes/no
|
|
|
|
sah_hold
|
Hold Contract
|
Hld
|
yes/no
|
|
|
|
sah_inv_date
|
Invoice Date
|
Inv Date
|
99/99/99
|
|
|
|
sah_invoiced
|
Invoiced
|
|
yes/no
|
|
|
|
sah_lang
|
Language
|
|
x(2)
|
|
|
|
sah_last_bill
|
Last Billed
|
Last Bill
|
99/99/99
|
|
|
|
sah_limit_copy
|
Renew Limits From
|
|
X(1)
|
|
|
|
sah_lst_bill
|
Last Bill
|
|
99/99/99
|
|
|
|
sah_lst_cover
|
Last Bill
|
Lst Bill
|
99/99/99
|
|
|
|
sah_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
sah_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
sah_mref
|
Master Contract
|
Master
|
x(8)
|
|
|
|
sah_mrp
|
Link to MRP
|
|
yes/no
|
|
|
|
sah_nbr
|
Number
|
|
x(10)
|
|
|
|
sah_next_dur
|
Next Duration
|
|
>>9.99
|
10
|
|
|
sah_nxt_bill
|
Next Bill
|
|
99/99/99
|
|
|
|
sah_off_hours_pt
|
Off Hours Item
|
|
x(18)
|
|
|
|
sah_ord_date
|
Order Date
|
Ord Date
|
99/99/99
|
|
|
|
sah_orig_date
|
Original Start
|
|
99/99/99
|
|
|
|
sah_part
|
Service Type
|
Svc Type
|
x(8)
|
|
|
|
sah_periodic
|
Periodic Billing
|
|
yes/no
|
|
|
|
sah_po
|
Purchase Order
|
|
x(20)
|
|
|
|
sah_pr_list
|
Price List
|
List
|
x(8)
|
|
|
|
sah_pr_list2
|
List Price List
|
List
|
x(8)
|
|
|
|
sah_prefix
|
Pf
|
|
x(1)
|
|
|
|
sah_prepaid
|
Prepaid
|
|
-z,zzz,zzz,zz9.99
|
10
|
|
|
sah_print
|
Print Sales Order
|
Print SO
|
yes/no
|
|
|
|
sah_print_pl
|
Print Pack List
|
Print Pack
|
yes/no
|
|
|
|
sah_prodline
|
Product Line
|
Line
|
x(4)
|
|
|
|
sah_project
|
Project
|
|
X(8)
|
|
|
|
sah_prt_0itm
|
Print 0$ Items
|
|
yes/no
|
|
|
|
sah_pst
|
PST
|
|
yes/no
|
|
|
|
sah_pst_id
|
PST ID
|
|
x(16)
|
|
|
|
sah_qty_per
|
Duration
|
|
->>>9.9<<<
|
10
|
|
|
sah_qty_plst
|
Last Qty Billed
|
Last Qty
|
->>>9.9<<<
|
10
|
|
|
sah_quote
|
Quote
|
|
x(8)
|
|
|
|
sah_quote_mod
|
Quote Modified
|
|
yes/no
|
|
|
|
sah_rel_date
|
Release Date
|
Rel Date
|
99/99/99
|
|
|
|
sah_release
|
Release to Contract
|
Rel
|
yes/no
|
|
|
|
sah_renew_count
|
Renewal Count
|
|
>>9
|
|
|
|
sah_renew_period
|
Renewal Periods
|
|
>>9
|
|
|
|
sah_renewal_date
|
Renewal Date
|
|
99/99/99
|
|
|
|
sah_renewed_from
|
Renewed From
|
|
X(8)
|
0
|
|
|
sah_renewed_to
|
Renewed To
|
|
X(8)
|
0
|
|
|
sah_reval_index
|
Revaluation Index Month
|
|
>>9
|
|
|
|
sah_reval_period
|
Revaluation Period
|
|
>>9
|
|
|
|
sah_revalue_date
|
Revaluation Date
|
|
99/99/99
|
|
|
|
sah_rmks
|
Remarks
|
|
x(40)
|
|
|
|
sah_rsn_lost
|
Reason Lost
|
|
x(8)
|
|
|
|
sah_sah_type
|
Type
|
|
x(8)
|
|
|
|
sah_sched_start
|
PM Start Date
|
Start
|
yes/no
|
|
|
|
sah_schedule
|
Billing Schedule File
|
|
yes/no
|
|
|
|
sah_serial_det
|
Serial Detail
|
|
yes/no
|
|
|
|
sah_ship_date
|
Ship Date
|
|
99/99/99
|
|
|
|
sah_shipvia
|
Ship Via
|
|
x(20)
|
|
|
|
sah_site
|
Site
|
|
x(8)
|
|
|
|
sah_slspsn[4]
|
Salesperson
|
Salespsn
|
X(8)
|
0
|
|
|
sah_so_nbr
|
Sales Order
|
Order
|
x(8)
|
|
|
|
sah_source
|
Order Source
|
Source
|
x(8)
|
|
|
|
sah_st_cover
|
Coverage
|
|
99/99/99
|
|
|
|
sah_st_date
|
Start Date
|
|
99/99/99
|
|
|
|
sah_stat
|
Action Status
|
St
|
x(2)
|
|
|
|
sah_summarize
|
Summarize
|
|
yes/no
|
|
|
|
sah_tax_date
|
Tax Date
|
|
99/99/99
|
|
|
|
sah_tax_env
|
Tax Environment
|
Tax Env.
|
x(16)
|
0
|
|
|
sah_tax_pct[3]
|
Tax
|
|
->9.99%
|
10
|
|
|
sah_tax_usage
|
Nature of Operation
|
Nature
|
x(8)
|
|
|
|
sah_taxable
|
Taxable
|
Tax
|
yes/no
|
|
|
|
sah_taxc
|
Tax Code
|
T
|
x(3)
|
|
|
|
sah_total_billed
|
Total Billed
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sah_total_cost
|
Total Cost
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sah_trl1_amt
|
Trailer Amt 1
|
|
-zzzz,zzz,zz9.99
|
10
|
|
|
sah_trl1_cd
|
Trailer 1
|
Trl1
|
x(2)
|
|
|
|
sah_trl2_amt
|
Trailer Amt 2
|
|
-zzzz,zzz,zz9.99
|
10
|
|
|
sah_trl2_cd
|
Trailer 2
|
Trl2
|
x(2)
|
|
|
|
sah_trl3_amt
|
Trailer Amt 3
|
|
-zzzz,zzz,zz9.99
|
10
|
|
|
sah_trl3_cd
|
Trailer 3
|
Trl3
|
x(2)
|
|
|
|
sah_trnbr
|
Transaction
|
|
>>>>>>>>>>>9
|
|
|
|
sah_type
|
Type
|
|
x(8)
|
|
|
|
sah_um
|
UM
|
|
x(2)
|
|
|
|
sah_user1
|
Ufld1
|
|
x(8)
|
|
|
|
sah_user2
|
Ufld2
|
|
x(8)
|
|
|
|
sah_visits
|
Visits
|
|
>>9
|
10
|
|
|
sah_xcomm_pct[2]
|
Commission
|
Comm%
|
>>9.99%
|
10
|
|
|
sah_xslspsn[2]
|
Salesperson
|
Salespsn
|
x(8)
|
0
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sah_hist
|
yes
|
oid_sah_hist
|
yes
|
no
|
|
|
sah_enduser
|
no
|
sah_domain
|
yes
|
no
|
|
|
|
|
sah_enduser
|
yes
|
no
|
|
|
|
|
sah_prefix
|
yes
|
no
|
|
|
|
|
sah_nbr
|
yes
|
no
|
|
|
sah_nbr
|
no
|
sah_domain
|
yes
|
no
|
|
|
|
|
sah_nbr
|
yes
|
no
|
|
|
|
|
sah_prefix
|
yes
|
no
|
|
|
|
|
sah_end_date
|
yes
|
no
|
|
∗
|
sah_trnbr
|
yes
|
sah_domain
|
yes
|
no
|
|
|
|
|
sah_trnbr
|
yes
|
no
|