business logic query DaybookSetByCodeType

Description

This query returns all information for a daybook set

Parameters

icFromDaybookSet	character
icDaybookSetType	character
ilDaybookSetActive	logical
icToDaybookSet	character
icDomainCode	character

query condition

each dybs_mstr where

(dybs_mstr.dybs_code >= icFromDaybookSet AND
dybs_mstr.dybs_code <= icToDaybookSet ) AND
dybs_mstr.dybs_type = icDaybookSetType AND
dybs_mstr.dybs_active = ilDaybookSetActive AND
dybs_mstr.dybs_domain = icDomainCode

query resultset tqDaybookSetByCodeType

field name	data type	db field	description
tldybs_active	logical	dybs_mstr.dybs_active	Active
tcdybs_adjustment_dybk	character	dybs_mstr.dybs_adjustment_dybk	Adjustment Daybook
tldybs_by_site	logical	dybs_mstr.dybs_by_site	By Site
tcdybs_code	character	dybs_mstr.dybs_code	Daybook Set
tcdybs_credit_dybk	character	dybs_mstr.dybs_credit_dybk	Credit Note Daybook
tcdybs_desc	character	dybs_mstr.dybs_desc	Description
tcdybs_domain	character	dybs_mstr.dybs_domain	Domain
tcdybs_interco_dybk	character	dybs_mstr.dybs_interco_dybk	Intercompany Daybook
tcdybs_invoices_dybk	character	dybs_mstr.dybs_invoices_dybk	Invoice Daybook
tcdybs_neg_crcn_dybk	character	dybs_mstr.dybs_neg_crcn_dybk	Correction Credit Note (Negative)
tcdybs_neg_criv_dybk	character	dybs_mstr.dybs_neg_criv_dybk	Correction Invoice (Negative)
tcdybs_pos_crcn_dybk	character	dybs_mstr.dybs_pos_crcn_dybk	Correction Credit Note (Positive)
tcdybs_pos_criv_dybk	character	dybs_mstr.dybs_pos_criv_dybk	Correction Invoice (Positive)
tcdybs_site	character	dybs_mstr.dybs_site	Site
tcdybs_site_from	character	dybs_mstr.dybs_site_from	Site From
tcdybs_site_to	character	dybs_mstr.dybs_site_to	Site To
tcdybs_type	character	dybs_mstr.dybs_type	Type

Internal usage

QadFinancials

method BMfgDaybookSetReport.DaybookSetReport