project QadFinancials > class BMfgCosting > dataset BMfgCosting

class dataset

object identification

primary key
sct_domain
sct_sim
sct_part
sct_site
alternate key
oid_sct_det

table tsct_det


field namedata typemnd.description
sct_simcharacter(80)noCost Set
sct_partcharacter(30)noItem Number
sct_cst_totdecimal(10)noCost Total
sct_mtl_tldecimal(10)noMaterial
sct_lbr_tldecimal(10)noLabor
sct_bdn_tldecimal(10)noBurden
sct_ovh_tldecimal(10)noOverhead
sct_sub_tldecimal(10)noSubcontract
sct_mtl_lldecimal(10)noMaterial LL
sct_lbr_lldecimal(10)noLabor LL
sct_bdn_lldecimal(10)noBurden LL
sct_ovh_lldecimal(10)noOverhead LL
sct_sub_lldecimal(10)noSubcontract LL
sct_cst_datedatenoCost Update
sct_user1character(80)noUfld1
sct_user2character(80)noUfld2
sct_serialcharacter(50)noLot/Serial
sct_sitecharacter(80)noSite
sct_rolluplogicalnoFreeze
sct_rollup_idcharacter(30)noRollup ID
sct_nrvdecimal(10)noNet Realized Value
sct__qadc01character(80)no
sct_cost_changedlogicalnoCost Changed
sct_domaincharacter(8)yesDomain
oid_sct_detdecimal(10)no
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacternoempty string
tc_Statuscharacternoupdate status

table tspt_det


field namedata typemnd.description
spt_simcharacter(80)noCost Set
spt_partcharacter(30)noItem Number
spt_elementcharacter(80)noCost Element
spt_cst_tldecimal(10)noCost
spt_cst_lldecimal(10)noCost LL
spt_user1character(80)noUfld1
spt_user2character(80)noUfld2
spt_useridcharacter(80)noUser ID
spt_mod_datedatenoModified Date
spt_pct_tldecimal(10)noSeq 2
spt_pct_lldecimal(10)noSeq 1
spt_aologicalnoAdd On
spt_sitecharacter(80)noSite
spt__qadc01character(80)no
spt_domaincharacter(8)yesDomain
oid_spt_detdecimal(10)no
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tsct_det.tc_Rowid
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