business logic query ReportCustomFields

Parameters

iiBusActivityID	integer
icVariantName	character

each RptRequest where

RptRequest.BusActivity_ID = iiBusActivityID AND
RptRequest.RptRequestName = icVariantName AND
RptRequest.RptRequestType = 'V'

each RptRequestCBF (inner-join) where

RptRequestCBF.RptRequest_ID = RptRequest.RptRequest_ID AND

field name	data type	db field	description
tcRptRequestCBF	character	RptRequestCBF.RptRequestCBF	The name of the custom business field that is used to fill in the value in the related field in the result set. This is always in the format "<class-table-name>.<custom-field>". For example: "tDInvoice.CustomShort0".
tcRptRequestResultField	character	RptRequestCBF.RptRequestResultField	This field contains the name of the field in the report result table, in the format "<result table name>.<fieldname>", where "<fieldname>" is always in the format "t<d>Custom<number>" (<d>=data type indication). For example: "tqDebtorAccountState.tcCustom1".

BLF