|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sfh_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sfh__chr01
|
User Character Field #1
|
|
x(8)
|
0
|
|
|
sfh__chr02
|
User Character Field #2
|
|
x(8)
|
0
|
|
|
sfh__chr03
|
User Character Field #3
|
|
x(8)
|
0
|
|
|
sfh__chr04
|
User Character Field #4
|
|
x(8)
|
0
|
|
|
sfh__dec01
|
User Decimal #1
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sfh__dec02
|
User Decimal #2
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sfh__dec03
|
User Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sfh__dte01
|
User Date #1
|
|
99/99/99
|
|
|
|
sfh__dte02
|
User Date #2
|
|
99/99/99
|
|
|
|
sfh__dte03
|
User Date #3
|
|
99/99/99
|
|
|
|
sfh__log01
|
User Logical #1
|
|
yes/no
|
|
|
|
sfh__log02
|
User Logical #2
|
|
yes/no
|
|
|
|
sfh__log03
|
User Logical #3
|
|
yes/no
|
|
|
|
sfh__qadc01
|
QAD Character Field
|
|
x(8)
|
0
|
|
|
sfh__qadc02
|
Qad Field #2
|
|
x(8)
|
|
|
|
sfh__qadc03
|
Qad Field #3
|
|
x(8)
|
|
|
|
sfh__qadc04
|
QAD Character Field
|
|
x(8)
|
0
|
|
|
sfh__qadd01
|
Qad Date #1
|
|
99/99/99
|
|
|
|
sfh__qadd02
|
Qad Date #2
|
|
99/99/99
|
|
|
|
sfh__qadd03
|
Qad Date #3
|
|
99/99/99
|
|
|
|
sfh__qadde01
|
Qad Decimal #1
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sfh__qadde02
|
Qad Decimal #2
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sfh__qadde03
|
Qad Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sfh__qadl01
|
QAD Logical Field
|
|
yes/no
|
|
|
|
sfh__qadl02
|
QAD Logical Field
|
|
yes/no
|
|
|
|
sfh__qadl03
|
QAD Logical Field
|
|
yes/no
|
|
|
|
sfh__qadl04
|
QAD Logical Field
|
|
yes/no
|
|
|
|
sfh_ca_opn_date
|
|
|
99/99/99
|
|
|
|
sfh_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
sfh_covered_amt
|
Covered Amount
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sfh_desc
|
Description
|
|
x(24)
|
|
|
|
sfh_detail
|
|
|
yes/no
|
|
|
|
sfh_domain
|
Domain
|
|
x(8)
|
|
|
|
sfh_exchange
|
Exchange
|
|
yes/no
|
|
|
|
sfh_exg_price
|
Exchange Price
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
sfh_fcg_code
|
Charge Code
|
Charge
|
x(8)
|
|
|
|
sfh_fis_column
|
Column
|
Col
|
>>9
|
|
|
|
sfh_fis_sort
|
Type
|
|
x(18)
|
|
|
|
sfh_fixed_cost
|
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sfh_fixed_price
|
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
sfh_fsc_code
|
Service Category
|
Svc Cat
|
x(8)
|
|
|
|
sfh_inv_nbr
|
Invoice
|
|
x(22)
|
|
|
|
sfh_invoice_cost
|
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sfh_line
|
Line
|
|
>>>9
|
|
|
|
sfh_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
sfh_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
sfh_nbr
|
|
|
x(8)
|
|
|
|
sfh_op
|
Operation
|
Op
|
>>>>>9
|
|
|
|
sfh_part
|
Item
|
|
x(18)
|
|
|
|
sfh_price
|
List Price
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
sfh_price_on_inv
|
Price on Invoice
|
|
yes/no
|
|
|
|
sfh_pst
|
PST Taxable
|
|
yes/no
|
|
|
|
sfh_pt_type
|
|
|
>>9
|
|
|
|
sfh_qty_billed
|
Qty Billed
|
|
->>>,>>9.9<
|
10
|
|
|
sfh_qty_inv
|
Qty to Invoice
|
Qty to Inv
|
->>>,>>9.9<
|
10
|
|
|
sfh_qty_on_inv
|
Qty on Invoice
|
|
yes/no
|
|
|
|
sfh_qty_req
|
Qty Required
|
|
->>>,>>9.9<<
|
10
|
|
|
sfh_qty_ret
|
Qty Returned
|
|
->,>>>,>>9.9<<<
|
10
|
|
|
sfh_report
|
Report
|
|
X(8)
|
|
|
|
sfh_ret_serial
|
Returned Serial
|
|
X(18)
|
|
|
|
sfh_serial
|
Serial
|
|
x(18)
|
|
|
|
sfh_so_line
|
SO Line
|
|
>>>9
|
|
|
|
sfh_tax_env
|
Tax Environment
|
|
X(16)
|
0
|
|
|
sfh_tax_in
|
Tax In
|
|
yes/no
|
|
|
|
sfh_tax_usage
|
Tax Usage
|
|
x(8)
|
0
|
|
|
sfh_taxable
|
Taxable
|
|
yes/no
|
|
|
|
sfh_taxc
|
Tax Class
|
|
x(8)
|
0
|
|
|
sfh_total_std
|
Total Cost
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
sfh_trnbr
|
Transaction
|
|
>>>>>>>>>9
|
|
|
|
sfh_um
|
UM
|
|
x(2)
|
|
|
|
sfh_user1
|
Ufld1
|
|
X(8)
|
|
|
|
sfh_user2
|
Ufld2
|
|
X(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sfh_hist
|
yes
|
oid_sfh_hist
|
yes
|
no
|
|
|
sfh_inv_nbr
|
no
|
sfh_domain
|
yes
|
no
|
|
|
|
|
sfh_inv_nbr
|
yes
|
no
|
|
|
|
|
sfh_so_line
|
yes
|
no
|
|
|
|
|
sfh_pt_type
|
yes
|
no
|
|
|
|
|
sfh_fis_sort
|
yes
|
no
|
|
|
|
|
sfh_line
|
yes
|
no
|
|
|
sfh_line
|
no
|
sfh_domain
|
yes
|
no
|
|
|
|
|
sfh_nbr
|
yes
|
no
|
|
|
|
|
sfh_so_line
|
yes
|
no
|
|
|
|
|
sfh_pt_type
|
yes
|
no
|
|
|
|
|
sfh_fis_sort
|
yes
|
no
|
|
|
|
|
sfh_line
|
yes
|
no
|
|
∗
|
sfh_trnbr
|
yes
|
sfh_domain
|
yes
|
no
|
|
|
|
|
sfh_trnbr
|
yes
|
no
|