|
|
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
|