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