|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_prj_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
prj__dec01
|
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
prj__dte01
|
|
|
99/99/99
|
|
|
|
prj__log01
|
|
|
yes/no
|
|
|
|
prj__qadc01
|
|
|
x(24)
|
|
|
|
prj__qadc02
|
|
|
x(24)
|
|
|
|
prj__qadd01
|
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
prj__qadd02
|
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
prj__qadi01
|
|
|
>>>>>>>9
|
|
|
|
prj__qadi02
|
|
|
>>>>>>>9
|
|
|
|
prj__qadl01
|
|
|
yes/no
|
|
|
|
prj__qadl02
|
|
|
yes/no
|
|
|
|
prj__qadt01
|
|
|
99/99/99
|
|
|
|
prj__qadt02
|
|
|
99/99/99
|
|
|
|
prj_action_stat
|
Action Status
|
|
x(2)
|
|
|
|
prj_ar_acct
|
AR Account
|
|
x(8)
|
|
|
|
prj_ar_cc
|
AR Cost Center
|
|
x(4)
|
|
|
|
prj_ar_sub
|
AR Sub-Account
|
|
x(8)
|
|
|
|
prj_bg_above
|
Budget Overrun Limit
|
|
->>9.9<%
|
10
|
|
|
prj_bg_below
|
Budget Warning Limit
|
|
->>9.9<%
|
10
|
|
|
prj_bill_to
|
Bill-To
|
|
x(8)
|
|
|
|
prj_channel
|
Channel
|
|
x(8)
|
|
|
|
prj_close_date
|
Close Date
|
|
99/99/99
|
|
|
|
prj_cmtindx
|
Comment Index
|
|
>>>>>>>9
|
|
|
|
prj_comm_pct[4]
|
Commission
|
|
>>9.9<%
|
10
|
|
|
prj_cr_card
|
Credit Card
|
|
x(2)
|
|
|
|
prj_cr_init
|
Cr Initials
|
|
x(3)
|
|
|
|
prj_cr_terms
|
Credit Terms
|
|
x(8)
|
|
|
|
prj_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
prj_cust
|
Sold-To
|
|
x(8)
|
|
|
|
prj_daybookset
|
Daybook Set
|
Dybk Set
|
x(8)
|
|
|
|
prj_desc
|
Desc
|
|
x(24)
|
|
|
|
prj_domain
|
Domain
|
|
x(8)
|
|
|
|
prj_end_date
|
End Date
|
|
99/99/99
|
|
|
|
prj_eng_nbr
|
Engineer
|
|
x(8)
|
|
|
|
prj_eu_nbr
|
End User
|
|
x(8)
|
|
|
|
prj_ex_rate
|
Exch Rate
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
prj_ex_rate2
|
Exch Rate 2
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
prj_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
prj_exru_seq
|
Sequence
|
|
>>>>>>>>9
|
|
|
|
prj_fix_rate
|
Fixed Rate
|
|
yes/no
|
|
|
|
prj_global_inv
|
Global Invoicing
|
|
yes/no
|
|
|
|
prj_inv_det
|
Details on Invoice
|
|
yes/no
|
|
|
|
prj_inv_det_pr
|
Price Details on Invoice
|
|
yes/no
|
|
|
|
prj_inv_lvl
|
Invoice Level
|
|
yes/no
|
|
|
|
prj_lang
|
Language
|
|
x(2)
|
|
|
|
prj_loc
|
Location
|
|
x(8)
|
|
|
|
prj_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
prj_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
prj_mref
|
Master Project
|
|
x(8)
|
|
|
|
prj_nbr
|
Project
|
|
x(8)
|
|
|
|
prj_ord_date
|
Order Date
|
|
99/99/99
|
|
|
|
prj_pjt_code
|
Project Type
|
|
x(8)
|
|
|
|
prj_po
|
Purchase Order
|
|
x(22)
|
|
|
|
prj_pr_list
|
Price List
|
|
x(8)
|
|
|
|
prj_pr_rollup
|
Auto Price Rollup
|
|
yes/no
|
|
|
|
prj_prep_tax
|
Prepaid Tax
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
prj_prepaid
|
Prepaid
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
prj_pricing_dt
|
Pricing Date
|
Price Dt
|
99/99/99
|
|
|
|
prj_rmks
|
Remarks
|
|
x(40)
|
|
|
|
prj_ship_date
|
Ship Date
|
|
99/99/99
|
|
|
|
prj_ship_to
|
Ship-To
|
|
x(8)
|
|
|
|
prj_shipvia
|
Ship Via
|
|
x(20)
|
|
|
|
prj_site
|
Site
|
|
x(8)
|
|
|
|
prj_slspsn[4]
|
Slsperson
|
|
x(8)
|
|
|
|
prj_st_date
|
Start Date
|
|
99/99/99
|
|
|
|
prj_status
|
Status
|
|
x(8)
|
|
|
|
prj_tax_date
|
Tax Date
|
|
99/99/99
|
|
|
|
prj_tax_env
|
Tax Environment
|
|
x(16)
|
|
|
|
prj_tax_in
|
Tax In
|
|
yes/no
|
|
|
|
prj_tax_usage
|
Tax Usage
|
|
x(8)
|
|
|
|
prj_taxable
|
Taxable
|
|
yes/no
|
|
|
|
prj_taxc
|
Tax Environment Tax Class
|
|
x(3)
|
|
|
|
prj_trl1_amt
|
Trailer Amt 1
|
|
-zzzz,zzz,zz9.99
|
10
|
|
|
prj_trl1_cd
|
Trailer 1
|
|
x(2)
|
|
|
|
prj_trl2_amt
|
Trailer Amt 2
|
|
-zzzz,zzz,zz9.99
|
10
|
|
|
prj_trl2_cd
|
Trailer 2
|
|
x(2)
|
|
|
|
prj_trl3_amt
|
Trailer Amt 3
|
|
-zzzz,zzz,zz9.99
|
10
|
|
|
prj_trl3_cd
|
Trailer 3
|
|
x(2)
|
|
|
|
prj_type_taxc
|
Tax Rate Tax Class
|
|
x(3)
|
|
|
|
prj_use_budgets
|
Use Budgets
|
|
yes/no
|
|
|
|
prj_user1
|
Ufld1
|
|
x(8)
|
|
|
|
prj_user2
|
Ufld2
|
|
x(8)
|
|
|
|
prj_userid
|
Entered By
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_prj_mstr
|
yes
|
oid_prj_mstr
|
yes
|
no
|
|
∗
|
prj_nbr
|
yes
|
prj_domain
|
yes
|
no
|
|
|
|
|
prj_nbr
|
yes
|
no
|
|
|
prj_pjt_code
|
no
|
prj_domain
|
yes
|
no
|
|
|
|
|
prj_pjt_code
|
yes
|
no
|
|
|
prj_po
|
no
|
prj_domain
|
yes
|
no
|
|
|
|
|
prj_po
|
yes
|
no
|
|
|
|
|
prj_cust
|
yes
|
no
|
|
|
prj_ship
|
no
|
prj_domain
|
yes
|
no
|
|
|
|
|
prj_ship_to
|
yes
|
no
|