|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sad_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sad__chr01
|
|
|
x(8)
|
|
|
|
sad__chr02
|
|
|
x(8)
|
|
|
|
sad__chr03
|
|
|
x(8)
|
|
|
|
sad__chr04
|
|
|
x(8)
|
|
|
|
sad__chr05
|
|
|
x(8)
|
|
|
|
sad__chr06
|
|
|
x(8)
|
|
|
|
sad__chr07
|
|
|
x(8)
|
|
|
|
sad__chr08
|
|
|
x(8)
|
|
|
|
sad__chr09
|
|
|
x(8)
|
|
|
|
sad__chr10
|
|
|
x(8)
|
|
|
|
sad__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
sad__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
sad__dte01
|
|
|
99/99/99
|
|
|
|
sad__dte02
|
|
|
99/99/99
|
|
|
|
sad__log01
|
|
|
yes/no
|
|
|
|
sad__qadc01
|
Qad Field #1
|
|
x(8)
|
|
|
|
sad__qadc02
|
Qad Field #2
|
|
x(8)
|
|
|
|
sad__qadc03
|
Qad Field #3
|
|
x(8)
|
|
|
|
sad__qadc04
|
Qad Field #4
|
|
x(8)
|
|
|
|
sad__qadc05
|
|
|
x(8)
|
|
|
|
sad__qadc06
|
|
|
x(4)
|
|
|
|
sad__qadd01
|
Qad Decimal #1
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sad__qadd02
|
Qad Decimal #2
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sad__qadd03
|
Qad Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sad__qadl01
|
QAD Logical Field
|
|
yes/no
|
|
|
|
sad__qadl02
|
Qad Logical #2
|
|
yes/no
|
|
|
|
sad__qadl03
|
Qad Logical #3
|
|
yes/no
|
|
|
|
sad__qadt01
|
Qad Date #1
|
|
99/99/99
|
|
|
|
sad__qadt02
|
Qad Date #2
|
|
99/99/99
|
|
|
|
sad__qadt03
|
Qad Date #3
|
|
99/99/99
|
|
|
|
sad_accrued
|
Accrued
|
Accr
|
yes/no
|
|
|
|
sad_acct
|
Sales Acct
|
Sales
|
x(8)
|
|
|
|
sad_amt_type
|
Amount Type
|
AT
|
x(1)
|
|
|
|
sad_area
|
Area
|
|
x(8)
|
|
|
|
sad_autorenew
|
Auto Renew
|
Renew
|
yes/no
|
|
|
|
sad_bill_to
|
Bill To
|
|
x(8)
|
|
|
|
sad_blanket_eu
|
Blanket End User
|
|
yes/no
|
|
|
|
sad_ca_nbr
|
Call
|
|
x(8)
|
|
|
|
sad_cancel
|
Cancel Date
|
|
99/99/99
|
|
|
|
sad_cc
|
Cost Ctr
|
CC
|
x(4)
|
|
|
|
sad_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
sad_comm_pct[4]
|
Commission
|
Comm%
|
>>9.99%
|
10
|
|
|
sad_comment[5]
|
Comments
|
|
x(40)
|
|
|
|
sad_crt_int
|
Credit Terms Int
|
CRT Int
|
->>>9.99
|
10
|
|
|
sad_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
sad_cust
|
Customer
|
|
x(8)
|
|
|
|
sad_custpart
|
Customer Item
|
|
x(18)
|
|
|
|
sad_cycle
|
Billing Cycle
|
Cyc
|
x(2)
|
|
|
|
sad_desc
|
Description
|
|
x(24)
|
|
|
|
sad_disc_pct
|
Disc %
|
|
->>9.99%
|
10
|
|
|
sad_discount
|
Discountable
|
|
yes/no
|
|
|
|
sad_domain
|
Domain
|
|
x(8)
|
|
|
|
sad_dsc_acct
|
Disc Acct
|
|
x(8)
|
|
|
|
sad_dsc_cc
|
CC
|
|
x(4)
|
|
|
|
sad_dsc_project
|
Disc Project
|
|
x(8)
|
|
|
|
sad_dsc_sub
|
Disc Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
sad_end_date
|
End Date
|
End
|
99/99/99
|
|
|
|
sad_es_nbr
|
Escalation
|
|
x(8)
|
|
|
|
sad_eu_nbr
|
End User
|
|
x(8)
|
|
|
|
sad_ex_rate
|
Exch Rate
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sad_ex_rate2
|
Exch Rate 2
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sad_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
sad_expire
|
Expires
|
|
99/99/99
|
|
|
|
sad_exru_seq
|
Sequence
|
|
>>>>>>>>9
|
|
|
|
sad_fix_pr
|
Fixed Price
|
|
yes/no
|
|
|
|
sad_fix_rate
|
Fixed Rate
|
Fixed
|
yes/no
|
|
|
|
sad_for
|
Supported Item
|
Item
|
x(18)
|
|
|
|
sad_fsrev_acct
|
Revenue Acct
|
Revenue Acct
|
x(8)
|
|
|
|
sad_fsrev_cc
|
Revenue CC
|
CC
|
x(4)
|
|
|
|
sad_fsrev_sub
|
Revenue Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
sad_fst_list
|
FST on List
|
|
yes/no
|
|
|
|
sad_lastbill
|
Date Last Billed
|
|
99/99/99
|
|
|
|
sad_line
|
Contract Line
|
Con Line
|
>>>>>>>9
|
|
|
|
sad_line_type
|
Line Type
|
LT
|
x(1)
|
|
|
|
sad_list_pr
|
List Price
|
Lst Price
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
sad_lst_bill
|
Last Bill
|
|
99/99/99
|
|
|
|
sad_lstcover
|
Last Billed
|
Lst Bill
|
99/99/99
|
|
|
|
sad_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
sad_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
sad_mrp
|
Link Line to MRP
|
|
yes/no
|
|
|
|
sad_nbr
|
Contract
|
|
x(8)
|
|
|
|
sad_nxt_bill
|
Next Bill
|
|
99/99/99
|
|
|
|
sad_parent_line
|
Parent Line
|
|
>>>>>>>9
|
|
|
|
sad_pct_type
|
Percent Type
|
PT
|
x(1)
|
|
|
|
sad_per_date
|
Perform Date
|
Perform
|
99/99/99
|
|
|
|
sad_po
|
Purchase Order
|
|
x(20)
|
|
|
|
sad_pr_list
|
Price List
|
Prc Lst
|
x(8)
|
|
|
|
sad_prefix
|
Pf
|
|
x(2)
|
|
|
|
sad_price
|
Net Price
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sad_pricing_dt
|
Pricing Date
|
Price Dt
|
99/99/99
|
|
|
|
sad_priority
|
Priority
|
Pri
|
>9
|
|
|
|
sad_prlist_fnd
|
Price List Found
|
|
yes/no
|
|
|
|
sad_prodline
|
Product Line
|
Line
|
x(4)
|
|
|
|
sad_project
|
Project
|
|
x(8)
|
|
|
|
sad_pst
|
PST Taxable
|
|
yes/no
|
|
|
|
sad_pvm_bill
|
Bill PM
|
|
yes/no
|
|
|
|
sad_pvm_bom
|
Bill of Material
|
|
x(18)
|
|
|
|
sad_pvm_only
|
PM Item
|
|
yes/no
|
|
|
|
sad_pvm_route
|
Routing
|
|
x(18)
|
|
|
|
sad_qty_bld
|
Billed Count
|
|
->>>,>>9.9<<<<<
|
10
|
|
|
sad_qty_chg
|
Qty To Bill
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
sad_qty_item
|
Item Quantity
|
Item Qty
|
->>,>>9.9
|
10
|
|
|
sad_qty_litm
|
Last Item Qty
|
Last Item
|
->>>9.9<<<
|
10
|
|
|
sad_qty_lst
|
Qty Last Billed
|
Last Qty
|
->,>>>,>>9.9<<
|
10
|
|
|
sad_qty_per
|
Duration
|
|
->>>9.9<<<
|
10
|
|
|
sad_ref
|
Ref
|
|
>>>>>>>9
|
|
|
|
sad_released
|
Released To Contract
|
Rel
|
yes/no
|
|
|
|
sad_renewed_to
|
Renewed To
|
|
x(8)
|
|
|
|
sad_serial
|
Lot/Serial
|
|
x(18)
|
|
|
|
sad_site
|
Site
|
|
x(8)
|
|
|
|
sad_slspsn[4]
|
Salesperson
|
Salespsn
|
X(8)
|
|
|
|
sad_so_nbr
|
Sales Order
|
Order
|
x(8)
|
|
|
|
sad_so_ship
|
From Sales Order
|
|
x(8)
|
|
|
|
sad_so_shipln
|
From SO Line
|
|
>>9
|
|
|
|
sad_sod_line
|
Sales Order Line
|
|
>>9
|
|
|
|
sad_st_cover
|
Coverage
|
|
99/99/99
|
|
|
|
sad_st_date
|
Start Date
|
Start
|
99/99/99
|
|
|
|
sad_status
|
Status
|
|
x(8)
|
|
|
|
sad_std_cost
|
Cost
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
sad_sub
|
Sales Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
sad_sv_code
|
Service Type
|
Svc Type
|
x(8)
|
|
|
|
sad_tax_env
|
Tax Environment
|
Tax Env
|
x(16)
|
|
|
|
sad_tax_in
|
Tax In
|
|
yes/no
|
|
|
|
sad_tax_usage
|
Tax Usage
|
TaxUsage
|
x(8)
|
|
|
|
sad_taxable
|
Taxable
|
Tax
|
yes/no
|
|
|
|
sad_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
sad_total_bld
|
Total Billed
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sad_type
|
Ship Type
|
T
|
x(1)
|
|
|
|
sad_ui_line
|
Line
|
|
>>>>9
|
|
|
|
sad_um
|
UM
|
|
x(2)
|
|
|
|
sad_um_conv
|
UM Conversion
|
UM Conv
|
>>>>9.9999<<<<
|
10
|
|
|
sad_user1
|
Ufld1
|
|
x(8)
|
|
|
|
sad_user2
|
Ufld2
|
|
x(8)
|
|
|
|
sad_visits
|
Visits
|
|
>>9
|
10
|
|
|
sad_xcomm_pct[2]
|
Commission
|
Comm%
|
>>9.99%
|
10
|
|
|
sad_xslspsn[3]
|
Salesperson
|
Salespsn
|
x(8)
|
0
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sad_det
|
yes
|
oid_sad_det
|
yes
|
no
|
|
|
sad_enduser
|
yes
|
sad_domain
|
yes
|
no
|
|
|
|
|
sad_nbr
|
yes
|
no
|
|
|
|
|
sad_prefix
|
yes
|
no
|
|
|
|
|
sad_eu_nbr
|
yes
|
no
|
|
|
|
|
sad_line
|
yes
|
no
|
|
|
sad_eu_line
|
yes
|
sad_domain
|
yes
|
no
|
|
|
|
|
sad_nbr
|
yes
|
no
|
|
|
|
|
sad_prefix
|
yes
|
no
|
|
|
|
|
sad_line_type
|
yes
|
no
|
|
|
|
|
sad_eu_nbr
|
yes
|
no
|
|
|
|
|
sad_ui_line
|
yes
|
no
|
|
|
sad_line_eu
|
no
|
sad_domain
|
yes
|
no
|
|
|
|
|
sad_nbr
|
yes
|
no
|
|
|
|
|
sad_prefix
|
yes
|
no
|
|
|
|
|
sad_line_type
|
yes
|
no
|
|
|
|
|
sad_ui_line
|
yes
|
no
|
|
|
|
|
sad_eu_nbr
|
yes
|
no
|
|
∗
|
sad_nbrln
|
yes
|
sad_domain
|
yes
|
no
|
|
|
|
|
sad_nbr
|
yes
|
no
|
|
|
|
|
sad_prefix
|
yes
|
no
|
|
|
|
|
sad_line
|
yes
|
no
|
|
|
sad_part
|
no
|
sad_domain
|
yes
|
no
|
|
|
|
|
sad_for
|
yes
|
no
|
|
|
|
|
sad_serial
|
yes
|
no
|
|
|
|
|
sad_ref
|
yes
|
no
|
|
|
|
|
sad_nbr
|
yes
|
no
|
|
|
|
|
sad_prefix
|
yes
|
no
|
|
|
sad_prefix_type
|
no
|
sad_domain
|
yes
|
no
|
|
|
|
|
sad_prefix
|
yes
|
no
|
|
|
|
|
sad_eu_nbr
|
yes
|
no
|
|
|
|
|
sad_line_type
|
yes
|
no
|
|
|
sad_serial
|
no
|
sad_domain
|
yes
|
no
|
|
|
|
|
sad_prefix
|
yes
|
no
|
|
|
|
|
sad_serial
|
yes
|
no
|