|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pjs_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pjs__chr01
|
|
|
x(8)
|
|
|
|
pjs__dec01
|
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjs__dec02
|
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjs__dte01
|
|
|
99/99/99
|
|
|
|
pjs__dte02
|
|
|
99/99/99
|
|
|
|
pjs__log01
|
|
|
yes/no
|
|
|
|
pjs__log02
|
|
|
yes/no
|
|
|
|
pjs__qadc01
|
|
|
x(24)
|
|
|
|
pjs__qadc02
|
|
|
x(24)
|
|
|
|
pjs__qadc03
|
|
|
x(24)
|
|
|
|
pjs__qadd01
|
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjs__qadd02
|
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjs__qadi01
|
|
|
>>>>>>>9
|
|
|
|
pjs__qadi02
|
|
|
>>>>>>>9
|
|
|
|
pjs__qadl01
|
|
|
yes/no
|
|
|
|
pjs__qadl02
|
|
|
yes/no
|
|
|
|
pjs__qadt01
|
|
|
99/99/99
|
|
|
|
pjs__qadt02
|
|
|
99/99/99
|
|
|
|
pjs_amt_inv
|
Amount Invoiced
|
Amt Inv
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjs_budget_type
|
Budget Type
|
|
>9
|
|
|
|
pjs_ca_int_type
|
Work Code
|
|
x(8)
|
|
|
|
pjs_cmtindx
|
Comment Index
|
|
>>>>>>>9
|
|
|
|
pjs_completed
|
Completed
|
|
yes/no
|
|
|
|
pjs_cost
|
Unit Cost
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjs_cost_actual
|
Actual Cost
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjs_cost_iss
|
Issued Cost
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjs_cost_wip
|
WIP Cost
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjs_desc
|
Description
|
|
x(24)
|
|
|
|
pjs_detail_on_inv
|
Detail on Invoice
|
|
yes/no
|
|
|
|
pjs_disc_pct
|
Discount
|
|
->>9.9<%
|
10
|
|
|
pjs_domain
|
Domain
|
|
x(8)
|
|
|
|
pjs_frozen
|
Frozen
|
|
yes/no
|
|
|
|
pjs_fsc_code
|
Category
|
|
x(8)
|
|
|
|
pjs_inv_group
|
Invoice Group
|
|
x(8)
|
|
|
|
pjs_inv_lvl
|
Invoice Level
|
|
yes/no
|
|
|
|
pjs_line
|
Project Line
|
|
>>>>>>>9
|
|
|
|
pjs_line_disp
|
Project Line ID
|
|
x(12)
|
|
|
|
pjs_line_par
|
Parent Line
|
|
>>>>>>>9
|
|
|
|
pjs_line_seq
|
Project Line Seq
|
|
>>>9
|
|
|
|
pjs_line_sort
|
Project Line Sort
|
|
x(24)
|
|
|
|
pjs_link_ok
|
Link to PAO
|
|
yes/no
|
|
|
|
pjs_list_pr
|
List Price
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjs_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pjs_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
pjs_nbr
|
Project
|
|
x(8)
|
|
|
|
pjs_part
|
Item Number
|
|
x(18)
|
|
|
|
pjs_povar_amt
|
PO Variance Amount
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjs_price
|
Net Price
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
pjs_price_on_inv
|
Price on Invoice
|
|
yes/no
|
|
|
|
pjs_prod_line
|
Product Line
|
|
x(4)
|
|
|
|
pjs_qty_actual
|
Qty Actual
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjs_qty_budget
|
Qty Budgeted
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjs_qty_inv
|
Qty Invoiced
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjs_qty_iss
|
Qty Issued
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjs_qty_oh
|
Project QOH
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjs_qty_planned
|
Qty Planned
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjs_qty_sel_inv
|
Qty to Invoice
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjs_qty_wip
|
Qty WIP
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
pjs_status
|
Status
|
|
x(8)
|
|
|
|
pjs_sub_nbr
|
Subproject
|
|
>>>9
|
|
|
|
pjs_subassy
|
Subassembly
|
|
yes/no
|
|
|
|
pjs_um
|
UM
|
|
x(2)
|
|
|
|
pjs_um_conv
|
UM Conversion
|
|
>>>>9.9999<<<<
|
10
|
|
|
pjs_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pjs_user2
|
Ufld2
|
|
x(8)
|
|
|
|
pjs_variation
|
Variation
|
|
yes/no
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pjs_mstr
|
yes
|
oid_pjs_mstr
|
yes
|
no
|
|
∗
|
pjs_line
|
yes
|
pjs_domain
|
yes
|
no
|
|
|
|
|
pjs_nbr
|
yes
|
no
|
|
|
|
|
pjs_line
|
yes
|
no
|
|
|
pjs_status
|
no
|
pjs_domain
|
yes
|
no
|
|
|
|
|
pjs_nbr
|
yes
|
no
|
|
|
|
|
pjs_status
|
yes
|
no
|
|
|
|
|
pjs_link_ok
|
yes
|
no
|
|
|
pjs_structure
|
no
|
pjs_domain
|
yes
|
no
|
|
|
|
|
pjs_nbr
|
yes
|
no
|
|
|
|
|
pjs_sub_nbr
|
yes
|
no
|
|
|
|
|
pjs_line_par
|
yes
|
no
|
|
|
|
|
pjs_line_seq
|
yes
|
no
|
|
|
pjs_tree
|
no
|
pjs_domain
|
yes
|
no
|
|
|
|
|
pjs_nbr
|
yes
|
no
|
|
|
|
|
pjs_line_sort
|
yes
|
no
|