project QadFinancials > class BMfgItem > business logic (internal API) query ItemForBillReport

query filter (table tFilter)

tcBusinessFieldName	tcDataType	tcOperator
icPart	c	=
icDomain	c	=
tpt_mstr.pt_desc1	c	=,>=,>,<>,<=,<,begins,can-do,matches
tpt_mstr.pt_desc2	c	=,>=,>,<>,<=,<,begins,can-do,matches

Parameters (internal)

icPart	character
icDomain	character

query condition

each pt_mstr where

pt_mstr.pt_part = icPart AND
pt_mstr.pt_domain = icDomain

query resultset tqItemForBillReport

field name	data type	db field	description
tcpt_desc1	character	pt_mstr.pt_desc1	Description
tcpt_desc2	character	pt_mstr.pt_desc2	Description
pt_mstrCustom	character	calculated	custom fields
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(pt_mstr)

Internal usage

QadFinancials

method BBillReport.GetDInvoiceDetailInfo