project QadFinancials > class BMfgProjectRealization > dataset BMfgProjectRealization

class dataset

object identification

primary key
prj_domain
prj_nbr
alternate key
oid_prj_mstr

table tprj_mstr


field namedata typemnd.description
prj_nbrcharacter(80)yesProject
prj_action_statcharacter(30)noAction Status
prj_ar_acctcharacter(80)noAR Account
prj_ar_subcharacter(80)noAR Sub-Account
prj_ar_cccharacter(30)noAR Cost Center
prj_bg_abovedecimal(10)noBudget Overrun Limit
prj_bg_belowdecimal(10)noBudget Warning Limit
prj_bill_tocharacter(80)noBill-To
prj_channelcharacter(80)noChannel
prj_cmtindxintegernoComment Index
prj_close_datedatenoClose Date
prj_cr_cardcharacter(30)noCredit Card
prj_cr_initcharacter(30)noCr Initials
prj_cr_termscharacter(80)noCredit Terms
prj_currcharacter(30)noCurrency
prj_custcharacter(80)noSold-To
prj_desccharacter(80)noDesc
prj_end_datedatenoEnd Date
prj_eng_nbrcharacter(80)noEngineer
prj_eu_nbrcharacter(80)noEnd User
prj_exru_seqintegernoSequence
prj_ex_ratedecimal(10)noExch Rate
prj_ex_rate2decimal(10)noExch Rate 2
prj_ex_ratetypecharacter(80)noRate Type
prj_fix_ratelogicalnoFixed Rate
prj_global_invlogicalnoGlobal Invoicing
prj_inv_detlogicalnoDetails on Invoice
prj_inv_det_prlogicalnoPrice Details on Invoice
prj_inv_lvllogicalnoInvoice Level
prj_langcharacter(30)noLanguage
prj_loccharacter(80)noLocation
prj_mrefcharacter(80)noMaster Project
prj_ord_datedatenoOrder Date
prj_pjt_codecharacter(80)noProject Type
prj_pocharacter(30)noPurchase Order
prj_pr_listcharacter(80)noPrice List
prj_pr_rolluplogicalnoAuto Price Rollup
prj_prepaiddecimal(10)noPrepaid
prj_prep_taxdecimal(10)noPrepaid Tax
prj_pricing_dtdatenoPricing Date
prj_rmkscharacter(80)noRemarks
prj_ship_datedatenoShip Date
prj_ship_tocharacter(80)noShip-To
prj_shipviacharacter(30)noShip Via
prj_sitecharacter(80)noSite
prj_st_datedatenoStart Date
prj_statuscharacter(80)noStatus
prj_tax_datedatenoTax Date
prj_tax_envcharacter(30)noTax Environment
prj_tax_inlogicalnoTax In
prj_tax_usagecharacter(80)noTax Usage
prj_taxablelogicalnoTaxable
prj_taxccharacter(30)noTax Environment Tax Class
prj_type_taxccharacter(30)noTax Rate Tax Class
prj_trl1_amtdecimal(10)noTrailer Amt 1
prj_trl1_cdcharacter(30)noTrailer 1
prj_trl2_amtdecimal(10)noTrailer Amt 2
prj_trl2_cdcharacter(30)noTrailer 2
prj_trl3_amtdecimal(10)noTrailer Amt 3
prj_trl3_cdcharacter(30)noTrailer 3
prj_useridcharacter(80)noEntered By
prj_use_budgetslogicalnoUse Budgets
prj_mod_datedatenoModified Date
prj_mod_useridcharacter(80)noUser ID
prj_user1character(80)noUfld1
prj_user2character(80)noUfld2
prj__dec01decimal(10)no
prj__log01logicalno
prj__dte01dateno
prj__qadc01character(80)no
prj__qadc02character(80)no
prj__qadd01decimal(10)no
prj__qadd02decimal(10)no
prj__qadi01integerno
prj__qadi02integerno
prj__qadl01logicalno
prj__qadl02logicalno
prj__qadt01dateno
prj__qadt02dateno
prj_domaincharacter(8)yesDomain
oid_prj_mstrdecimal(10)no
prj_daybooksetcharacter(8)noDaybook Set
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacternoempty string
tc_Statuscharacternoupdate status

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter