|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pjsh_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pjsh__qadc01
|
|
|
x(24)
|
|
|
|
pjsh__qadd01
|
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjsh__qadi01
|
|
|
>>>>>>>9
|
|
|
|
pjsh__qadl01
|
|
|
yes/no
|
|
|
|
pjsh__qadt01
|
|
|
99/99/99
|
|
|
|
pjsh_amt_inv
|
Invoiced Amount
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjsh_amt_inv_chg
|
Invoiced Amt Change
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
pjsh_cost_act_chg
|
Actual Cost Change
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjsh_cost_actual
|
Actual Cost
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjsh_cost_iss
|
Issued Cost
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjsh_cost_iss_chg
|
Issued Cost Change
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjsh_cost_planned
|
Planned Cost
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjsh_cost_pln_chg
|
Planned Cost Change
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjsh_cost_wip
|
WIP Cost
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjsh_cost_wip_chg
|
WIP Cost Change
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjsh_domain
|
Domain
|
|
x(8)
|
|
|
|
pjsh_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pjsh_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
pjsh_nbr
|
Project
|
|
x(8)
|
|
|
|
pjsh_old_status
|
Prev Line Status
|
|
x(8)
|
|
|
|
pjsh_pjs_line
|
Project Line
|
|
>>>>>>>9
|
|
|
|
pjsh_povar_amt
|
PO Variance Amt
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjsh_povar_chg
|
PO Variance Change
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjsh_qty_act_chg
|
Qty Actual Change
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjsh_qty_actual
|
Qty Actual
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjsh_qty_bg_chg
|
Qty Budgeted Change
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjsh_qty_budget
|
Qty Budgeted
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjsh_qty_inv
|
Qty Invoiced
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjsh_qty_inv_chg
|
Qty Invoiced Change
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjsh_qty_iss
|
Qty Issued
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjsh_qty_iss_chg
|
Qty Issued Change
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjsh_qty_oh
|
Project QOH
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjsh_qty_oh_chg
|
Project QOH Change
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjsh_qty_planned
|
Qty Planned
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjsh_qty_pln_chg
|
Qty Planned Change
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjsh_qty_sel_chg
|
Qty to Invoice Change
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjsh_qty_sel_inv
|
Qty to Invoice
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjsh_qty_wip
|
Qty WIP
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjsh_qty_wip_chg
|
Qty WIP Change
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjsh_rel_nbr
|
Related Project
|
|
x(8)
|
|
|
|
pjsh_status
|
Project Line Status
|
|
x(8)
|
|
|
|
pjsh_tr_cost
|
Transaction Cost
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjsh_tr_date
|
Transaction Date
|
|
99/99/99
|
|
|
|
pjsh_tr_ind
|
Transaction Indicator
|
|
x(8)
|
|
|
|
pjsh_tr_qty
|
Transaction Qty
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjsh_tr_time
|
Transaction Time
|
|
>>>>>>>>9
|
|
|
|
pjsh_tr_type
|
Transaction Type
|
|
x(8)
|
|
|
|
pjsh_trnbr
|
Transaction
|
|
>>>>>>>9
|
|
|
|
pjsh_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pjsh_user2
|
Ufld2
|
|
x(8)
|
|
|
|
pjsh_userid
|
User ID
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pjsh_hist
|
yes
|
oid_pjsh_hist
|
yes
|
no
|
|
|
pjsh_prj_nbr
|
no
|
pjsh_domain
|
yes
|
no
|
|
|
|
|
pjsh_nbr
|
yes
|
no
|
|
|
|
|
pjsh_pjs_line
|
yes
|
no
|
|
|
|
|
pjsh_tr_date
|
yes
|
no
|
|
|
|
|
pjsh_tr_time
|
yes
|
no
|
|
∗
|
pjsh_trnbr
|
yes
|
pjsh_domain
|
yes
|
no
|
|
|
|
|
pjsh_trnbr
|
yes
|
no
|