About This Guide > tr_hist
  
tr_hist
Inventory Transaction History
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_lgd_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_tr_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
tr__chr01
 
 
x(8)
 
 
tr__chr02
 
 
x(8)
 
 
tr__chr03
 
 
x(8)
 
 
tr__chr04
 
 
x(8)
 
 
tr__chr05
 
 
x(8)
 
 
tr__chr06
 
 
x(8)
 
 
tr__chr07
 
 
x(8)
 
 
tr__chr08
 
 
x(8)
 
 
tr__chr09
 
 
x(8)
 
 
tr__chr10
 
 
x(8)
 
 
tr__chr11
 
 
x(8)
 
 
tr__chr12
 
 
x(8)
 
 
tr__chr13
 
 
x(8)
 
 
tr__chr14
 
 
x(8)
 
 
tr__chr15
 
 
x(8)
 
 
tr__dec01
 
 
>>>,>>>,>>9.99
10
 
tr__dec02
 
 
>>>,>>>,>>9.99
10
 
tr__dec03
 
 
>>>,>>>,>>9.99
10
 
tr__dec04
 
 
>>>,>>>,>>9.99
10
 
tr__dec05
 
 
>>>,>>>,>>9.99
10
 
tr__dte01
 
 
99/99/99
 
 
tr__dte02
 
 
99/99/99
 
 
tr__dte03
 
 
99/99/99
 
 
tr__dte04
 
 
99/99/99
 
 
tr__dte05
 
 
99/99/99
 
 
tr__log01
 
 
yes/no
 
 
tr__log02
 
 
yes/no
 
 
tr_addr
Address
 
x(8)
 
 
tr_assay
Assay %
 
>>9.99%
10
 
tr_auto_install
Auto Installed
 
yes/no
 
 
tr_batch
Batch
 
x(18)
 
 
tr_bdn_std
Burden
 
->>>,>>>,>>9.99<<<
10
 
tr_begin_qoh
Begin Balance
 
->,>>>,>>9.9<<<<<<<<
10
 
tr_ca_int_type
Work Code
 
x(8)
 
 
tr_ca_opn_date
 
 
99/99/99
 
 
tr_covered_amt
Covered Amount
 
>>>>,>>>,>>9.99<<<
10
 
tr_cprice
Price
 
>>>>,>>>,>>9.99<<<
10
 
tr_curr
Currency
Cur
x(3)
 
 
tr_date
Date
 
99/99/99
 
 
tr_daycode
Day Code
 
x(8)
 
 
tr_doc_id
Document ID
 
x(24)
 
 
tr_domain
Domain
 
x(8)
 
 
tr_effdate
Effective
Eff Date
99/99/99
 
 
tr_enduser
End User
 
X(8)
 
 
tr_eng_area
Service Area
Area
x(18)
 
 
tr_eng_code
Engineer Code
Eng Code
x(8)
 
 
tr_ex_rate
Exch Rate
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
tr_ex_rate2
Exch Rate 2
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
tr_ex_ratetype
Rate Type
 
x(8)
 
 
tr_expire
Expire Date
 
99/99/99
 
 
tr_exru_seq
Sequence
 
>>>>>>>>9
 
 
tr_fcg_code
Charge Code
 
x(8)
 
 
tr_fldchg_cmtindx
Comment
 
>>>>>>>9
 
 
tr_for
Service Part
 
x(18)
 
 
tr_fsc_code
Service Category
 
x(8)
 
 
tr_fsm_type
FSM Type
 
x(8)
 
 
tr_gl_amt
Amount
 
->>>>>,>>9.99
10
 
tr_gl_date
GL Date
 
99/99/99
 
 
tr_grade
Grade
 
x(2)
 
 
tr_intercompanyref
Inter Company Reference
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
tr_last_date
Last Activity
 
99/99/99
 
 
tr_lbr_std
Labor
 
->>>,>>>,>>9.99<<<
10
 
tr_line
Line
Ln
>>9
 
 
tr_loc
Loc
Location
x(8)
 
 
tr_loc_begin
Begin Loc Bal
 
->,>>>,>>9.9<<<<<<<<
10
 
tr_lot
ID
 
x(8)
 
 
tr_msg
Message Number
Msg
>>>>9
 
 
tr_mtl_std
Material
 
->>>,>>>,>>9.99<<<
10
 
tr_nbr
Order
 
x(18)
 
 
tr_ord_rev
Revision
Rev
>>9
 
 
tr_ovh_std
Overhead
 
>>>>,>>>,>>9.99<<<
10
 
tr_part
Item Number
 
x(18)
 
 
tr_pc_sequence
PC Sequence
 
>>>>>>>>>>>>>>>>>>9
 
 
tr_per_date
Performance Date
Perform
99/99/99
 
 
tr_price
Price
 
->>>,>>>,>>9.99<<<
10
 
tr_prod_line
Product Line
Line
x(4)
 
 
tr_program
Program
 
x(12)
 
 
tr_promise_date
Promise Date
Promise
99/99/99
 
 
tr_qty_chg
Qty Change
 
->,>>>,>>9.9<<<<<<<<
10
 
tr_qty_cn_adj
Consignment Qty Adjusted
 
->,>>>,>>9.9<<<<<<<<
10
 
tr_qty_loc
Loc Qty Change
 
->,>>>,>>9.9<<<<<<<<
10
 
tr_qty_req
Qty Required
 
->,>>>,>>9.9<<<<<<<<
10
 
tr_qty_short
Qty Short
 
->,>>>,>>9.9<<<<<<<<
10
 
tr_ref
Ref
Reference
x(8)
 
 
tr_ref_site
Reference Site
Ref Site
x(8)
 
 
tr_rev
Rev
 
x(4)
 
 
tr_rmks
Remarks
 
x(10)
 
 
tr_rsn_code
Reason
 
x(8)
 
 
tr_sa_nbr
Contract
 
x(8)
0
 
tr_serial
Lot/Serial
 
x(18)
 
 
tr_ship_date
Ship Date
 
99/99/99
 
 
tr_ship_id
Shipper Number
 
x(20)
 
 
tr_ship_inv_mov
Inventory Movement Code
Inv Mov
x(8)
 
 
tr_ship_type
Ship Type
T
x(1)
 
 
tr_site
Site
 
x(8)
 
 
tr_slspsn[4]
Salesperson
Salespsn
x(8)
 
 
tr_so_job
Sales/Job
 
x(8)
 
 
tr_status
Inventory Status
Status
x(8)
 
 
tr_sub_std
Subcontract
 
->>>,>>>,>>9.99<<<
10
 
tr_sv_code
Contract Type
 
x(8)
 
 
tr_svc_type
 
 
x(1)
 
 
tr_sys_prod
System Product Line
S Prod
x(4)
 
 
tr_time
Time
 
>>,>>>,>>9
 
 
tr_trnbr
Trans
 
>>>>>>>>>>
 
 
tr_type
Trans Type
Type
x(8)
 
 
tr_um
UM
 
x(2)
 
 
tr_upd_isb
 
 
yes/no
 
 
tr_user1
Ufld1
 
x(8)
 
 
tr_user2
Ufld2
 
x(8)
 
 
tr_userid
User ID
 
x(8)
 
 
tr_vend_date
Supplier Production Date
Prod Date
99/99/99
 
 
tr_vend_lot
Supplier Lot
 
x(18)
 
 
tr_wo_due_date
Due Date
Due
99/99/99
 
 
tr_wo_line
Production Line
Line
x(8)
 
 
tr_wo_qty_comp
Qty Completed
 
->,>>>,>>9.9<<<<<<<<
10
 
tr_wo_qty_ord
Qty Ordered
 
->,>>>,>>9.9<<<<<<<<
10
 
tr_wo_yield_pct
Yield
 
>>9.99%
10
 
tr_wod_op
Operation
Op
>>>>>>
 
 
tr_xcr_acct
Not Used. Cr Acct
 
x(8)
 
 
tr_xcr_cc
Not Used. Cr Cost Ctr
CC
x(4)
 
 
tr_xcr_proj
Not used. Cr Project
Project
x(8)
 
 
tr_xdr_acct
Not used. Dr Acct
 
x(8)
 
 
tr_xdr_cc
Not used. Dr Cost Ctr
CC
x(4)
 
 
tr_xdr_proj
Not used. Dr Project
Project
x(8)
 
 
tr_xgl_ref
Not used. GL Reference
 
x(14)
 
 
tr_xslspsn1
Salesperson 1
Salespsn
x(8)
 
 
tr_xslspsn2
Salesperson 2
Salespsn
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_tr_hist
yes
oid_tr_hist
yes
no
 
tr_addr_eff
no
tr_domain
yes
no
 
 
 
tr_addr
yes
no
 
 
 
tr_effdate
yes
no
 
tr_batch
no
tr_domain
yes
no
 
 
 
tr_batch
yes
no
 
tr_date_trn
yes
tr_domain
yes
no
 
 
 
tr_date
yes
no
 
 
 
tr_trnbr
yes
no
 
tr_eff_trnbr
no
tr_domain
yes
no
 
 
 
tr_effdate
yes
no
 
 
 
tr_trnbr
yes
no
 
tr_nbr_eff
no
tr_domain
yes
no
 
 
 
tr_nbr
yes
no
 
 
 
tr_effdate
yes
no
 
tr_nbr_rmks_type
no
tr_domain
yes
no
 
 
 
tr_nbr
yes
no
 
 
 
tr_rmks
yes
no
 
 
 
tr_type
yes
no
 
tr_oid_lgd_mstr
no
oid_lgd_mstr
yes
no
 
tr_part_eff
no
tr_domain
yes
no
 
 
 
tr_part
yes
no
 
 
 
tr_effdate
yes
no
 
tr_part_trn
no
tr_domain
yes
no
 
 
 
tr_part
yes
no
 
 
 
tr_trnbr
yes
no
 
tr_serial
no
tr_domain
yes
no
 
 
 
tr_serial
yes
no
 
tr_shipper
no
tr_domain
yes
no
 
 
 
tr_ship_inv_mov
yes
no
 
 
 
tr_ship_id
yes
no
tr_trnbr
yes
tr_domain
yes
no
 
 
 
tr_trnbr
yes
no
 
tr_type
no
tr_domain
yes
no
 
 
 
tr_type
yes
no
 
 
 
tr_effdate
yes
no
 
tr_vend_lot
no
tr_domain
yes
no
 
 
 
tr_vend_lot
yes
no