About This Guide > sfh_hist
  
sfh_hist
Service/Support Billing History
 
 
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