field name | data type | mnd. | description |
---|---|---|---|
prj_nbr | character(80) | yes | Project |
prj_action_stat | character(30) | no | Action Status |
prj_ar_acct | character(80) | no | AR Account |
prj_ar_sub | character(80) | no | AR Sub-Account |
prj_ar_cc | character(30) | no | AR Cost Center |
prj_bg_above | decimal(10) | no | Budget Overrun Limit |
prj_bg_below | decimal(10) | no | Budget Warning Limit |
prj_bill_to | character(80) | no | Bill-To |
prj_channel | character(80) | no | Channel |
prj_cmtindx | integer | no | Comment Index |
prj_close_date | date | no | Close Date |
prj_cr_card | character(30) | no | Credit Card |
prj_cr_init | character(30) | no | Cr Initials |
prj_cr_terms | character(80) | no | Credit Terms |
prj_curr | character(30) | no | Currency |
prj_cust | character(80) | no | Sold-To |
prj_desc | character(80) | no | Desc |
prj_end_date | date | no | End Date |
prj_eng_nbr | character(80) | no | Engineer |
prj_eu_nbr | character(80) | no | End User |
prj_exru_seq | integer | no | Sequence |
prj_ex_rate | decimal(10) | no | Exch Rate |
prj_ex_rate2 | decimal(10) | no | Exch Rate 2 |
prj_ex_ratetype | character(80) | no | Rate Type |
prj_fix_rate | logical | no | Fixed Rate |
prj_global_inv | logical | no | Global Invoicing |
prj_inv_det | logical | no | Details on Invoice |
prj_inv_det_pr | logical | no | Price Details on Invoice |
prj_inv_lvl | logical | no | Invoice Level |
prj_lang | character(30) | no | Language |
prj_loc | character(80) | no | Location |
prj_mref | character(80) | no | Master Project |
prj_ord_date | date | no | Order Date |
prj_pjt_code | character(80) | no | Project Type |
prj_po | character(30) | no | Purchase Order |
prj_pr_list | character(80) | no | Price List |
prj_pr_rollup | logical | no | Auto Price Rollup |
prj_prepaid | decimal(10) | no | Prepaid |
prj_prep_tax | decimal(10) | no | Prepaid Tax |
prj_pricing_dt | date | no | Pricing Date |
prj_rmks | character(80) | no | Remarks |
prj_ship_date | date | no | Ship Date |
prj_ship_to | character(80) | no | Ship-To |
prj_shipvia | character(30) | no | Ship Via |
prj_site | character(80) | no | Site |
prj_st_date | date | no | Start Date |
prj_status | character(80) | no | Status |
prj_tax_date | date | no | Tax Date |
prj_tax_env | character(30) | no | Tax Environment |
prj_tax_in | logical | no | Tax In |
prj_tax_usage | character(80) | no | Tax Usage |
prj_taxable | logical | no | Taxable |
prj_taxc | character(30) | no | Tax Environment Tax Class |
prj_type_taxc | character(30) | no | Tax Rate Tax Class |
prj_trl1_amt | decimal(10) | no | Trailer Amt 1 |
prj_trl1_cd | character(30) | no | Trailer 1 |
prj_trl2_amt | decimal(10) | no | Trailer Amt 2 |
prj_trl2_cd | character(30) | no | Trailer 2 |
prj_trl3_amt | decimal(10) | no | Trailer Amt 3 |
prj_trl3_cd | character(30) | no | Trailer 3 |
prj_userid | character(80) | no | Entered By |
prj_use_budgets | logical | no | Use Budgets |
prj_mod_date | date | no | Modified Date |
prj_mod_userid | character(80) | no | User ID |
prj_user1 | character(80) | no | Ufld1 |
prj_user2 | character(80) | no | Ufld2 |
prj__dec01 | decimal(10) | no | |
prj__log01 | logical | no | |
prj__dte01 | date | no | |
prj__qadc01 | character(80) | no | |
prj__qadc02 | character(80) | no | |
prj__qadd01 | decimal(10) | no | |
prj__qadd02 | decimal(10) | no | |
prj__qadi01 | integer | no | |
prj__qadi02 | integer | no | |
prj__qadl01 | logical | no | |
prj__qadl02 | logical | no | |
prj__qadt01 | date | no | |
prj__qadt02 | date | no | |
prj_domain | character(8) | yes | Domain |
oid_prj_mstr | decimal(10) | no | |
prj_daybookset | character(8) | no | Daybook Set |
tc_Rowid | character | yes | primary index |
tc_ParentRowid | character | no | empty string |
tc_Status | character | no | update status |
field name | data type | description |
---|---|---|
tcCustomShort0 | character | |
tcCustomShort1 | character | |
tcCustomShort2 | character | |
tcCustomShort3 | character | |
tcCustomShort4 | character | |
tcCustomShort5 | character | |
tcCustomShort6 | character | |
tcCustomShort7 | character | |
tcCustomShort8 | character | |
tcCustomShort9 | character | |
tcCustomCombo0 | character | |
tcCustomCombo1 | character | |
tcCustomCombo2 | character | |
tcCustomCombo3 | character | |
tcCustomCombo4 | character | |
tcCustomCombo5 | character | |
tcCustomCombo6 | character | |
tcCustomCombo7 | character | |
tcCustomCombo8 | character | |
tcCustomCombo9 | character | |
tcCustomLong0 | character | |
tcCustomLong1 | character | |
tcCustomNote | character | |
ttCustomDate0 | date | |
ttCustomDate1 | date | |
ttCustomDate2 | date | |
ttCustomDate3 | date | |
ttCustomDate4 | date | |
tiCustomInteger0 | integer | |
tiCustomInteger1 | integer | |
tiCustomInteger2 | integer | |
tiCustomInteger3 | integer | |
tiCustomInteger4 | integer | |
tdCustomDecimal0 | decimal(4) | |
tdCustomDecimal1 | decimal(4) | |
tdCustomDecimal2 | decimal(4) | |
tdCustomDecimal3 | decimal(4) | |
tdCustomDecimal4 | decimal(4) | |
tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
tc_ParentRowid | character | |
tc_Status | character |
field name | data type | description |
---|---|---|
tcCustomShort0 | character | |
tcCustomShort1 | character | |
tcCustomShort2 | character | |
tcCustomShort3 | character | |
tcCustomShort4 | character | |
tcCustomShort5 | character | |
tcCustomShort6 | character | |
tcCustomShort7 | character | |
tcCustomShort8 | character | |
tcCustomShort9 | character | |
tcCustomCombo0 | character | |
tcCustomCombo1 | character | |
tcCustomCombo2 | character | |
tcCustomCombo3 | character | |
tcCustomCombo4 | character | |
tcCustomCombo5 | character | |
tcCustomCombo6 | character | |
tcCustomCombo7 | character | |
tcCustomCombo8 | character | |
tcCustomCombo9 | character | |
tcCustomLong0 | character | |
tcCustomLong1 | character | |
tcCustomNote | character | |
ttCustomDate0 | date | |
ttCustomDate1 | date | |
ttCustomDate2 | date | |
ttCustomDate3 | date | |
ttCustomDate4 | date | |
tiCustomInteger0 | integer | |
tiCustomInteger1 | integer | |
tiCustomInteger2 | integer | |
tiCustomInteger3 | integer | |
tiCustomInteger4 | integer | |
tdCustomDecimal0 | decimal(4) | |
tdCustomDecimal1 | decimal(4) | |
tdCustomDecimal2 | decimal(4) | |
tdCustomDecimal3 | decimal(4) | |
tdCustomDecimal4 | decimal(4) | |
tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
tc_ParentRowid | character | |
tc_Status | character |
field name | data type | description |
---|---|---|
tcCustomShort0 | character | |
tcCustomShort1 | character | |
tcCustomShort2 | character | |
tcCustomShort3 | character | |
tcCustomShort4 | character | |
tcCustomShort5 | character | |
tcCustomShort6 | character | |
tcCustomShort7 | character | |
tcCustomShort8 | character | |
tcCustomShort9 | character | |
tcCustomCombo0 | character | |
tcCustomCombo1 | character | |
tcCustomCombo2 | character | |
tcCustomCombo3 | character | |
tcCustomCombo4 | character | |
tcCustomCombo5 | character | |
tcCustomCombo6 | character | |
tcCustomCombo7 | character | |
tcCustomCombo8 | character | |
tcCustomCombo9 | character | |
tcCustomLong0 | character | |
tcCustomLong1 | character | |
tcCustomNote | character | |
ttCustomDate0 | date | |
ttCustomDate1 | date | |
ttCustomDate2 | date | |
ttCustomDate3 | date | |
ttCustomDate4 | date | |
tiCustomInteger0 | integer | |
tiCustomInteger1 | integer | |
tiCustomInteger2 | integer | |
tiCustomInteger3 | integer | |
tiCustomInteger4 | integer | |
tdCustomDecimal0 | decimal(4) | |
tdCustomDecimal1 | decimal(4) | |
tdCustomDecimal2 | decimal(4) | |
tdCustomDecimal3 | decimal(4) | |
tdCustomDecimal4 | decimal(4) | |
tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
tc_ParentRowid | character | |
tc_Status | character |