project QadFinancials > class BMfgServiceRepairOrder > dataset BMfgServiceRepairOrder

class dataset

object identification

primary key
sro_domain
sro_nbr

table tsro_mstr


field namedata typemnd.description
sro_nbrcharacter(80)noS/RO
sro_custcharacter(80)noCustomer
sro_shipcharacter(80)noShip-To
sro_takencharacter(80)noTaken By
sro_assigncharacter(80)noAssigned To
sro_ent_datedatenoEntered
sro_cls_datedatenoClosed
sro_typecharacter(80)noType
sro_statuscharacter(80)noStatus
sro_cr_termscharacter(80)noCredit Terms
sro_shipviacharacter(30)noShip Via
sro_pocharacter(30)noPO
sro_rgacharacter(80)noRGA
sro_authorcharacter(80)noAuthorized By
sro_print_rglogicalnoPrint RGA
sro_print_pllogicalnoPrint Pack List
sro_dspstncharacter(80)noDisposition
sro_partcharacter(30)noItem
sro_desccharacter(80)noDescription
sro_serialcharacter(50)noLot/Serial
sro_revcharacter(30)noRev
sro_wrrntylogicalnoWarranty
sro_failure1character(80)noFailure Code
sro_failure2character(80)noFailure Code 2
sro_failure3character(80)noFailure Code 3
sro_failure4character(80)noFailure Code 4
sro_failure5character(80)noFailure Code 5
sro_repair1character(80)noRepair Code
sro_repair2character(80)noRepair Code 2
sro_repair3character(80)noRepair Code 3
sro_repair4character(80)noRepair Code 4
sro_repair5character(80)noRepair Code 5
sro_frtdecimal(10)noFreight
sro_serv_chgdecimal(10)noService
sro_disc_pctdecimal(10)noDisc %
sro_spec_chgdecimal(10)noSpecial
sro_prepaiddecimal(10)noPrepaid Amount
sro_to_invlogicalnoReady to Invoice
sro_invoicedlogicalnoInvoiced
sro__qadc05character(80)no
sro__qadc06character(80)no
sro_inv_datedatenoInvoice Date
sro_shp_datedatenoShip Date
sro_closedlogicalnoClosed
sro_due_datedatenoDue Date
sro_user1character(80)noUfld1
sro_user2character(80)noUfld2
sro_qtydecimal(10)noQty
sro_cmtindxintegernoComment
sro__chr01character(80)no
sro__chr02character(80)no
sro__chr03character(80)no
sro__chr04character(80)no
sro__chr05character(80)no
sro__dte01dateno
sro__dte02dateno
sro__dec01decimal(10)no
sro__dec02decimal(10)no
sro__log01logicalno
sro_domaincharacter(8)yesDomain
oid_sro_mstrdecimal(10)no
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