business logic query LegalDocByLegDocByShipToByDate

Description

Query to return legal document records using a set of filter conditions.

Parameters

icDomainCode	character	DomainCode parameter
ilType	logical	Type parameter.
icLegalDocumentFrom	character	legal document from parameter.
icLegalDocumentTo	character	Legal document to parameter.
itReceiveDateFrom	date	Receive date from parameter.
itReceiveDateTo	date	Receive date to parameter.
icShipToFrom	character	Ship to address from parameter.
icShipToTo	character	Ship To Address to parameter.

query condition

each lgd_mstr where

lgd_mstr.lgd_domain = icDomainCode AND
lgd_mstr.lgd_type = ilType AND
lgd_mstr.lgd_nbr >= icLegalDocumentFrom AND
lgd_mstr.lgd_nbr <= icLegalDocumentTo AND
lgd_mstr.lgd_receive_date >= itReceiveDateFrom AND
lgd_mstr.lgd_receive_date <= itReceiveDateTo AND
lgd_mstr.lgd_ship >= icShipToFrom AND
lgd_mstr.lgd_ship <= icShipToTo AND
lgd_mstr.lgd_ship >= icShipToFrom AND
lgd_mstr.lgd_ship <= icShipToTo

query resultset tqLegalDocByLegDocByShipToByDate

field name	data type	db field	description
tclgd_domain	character	lgd_mstr.lgd_domain	Domain
tclgd_inv_nbr	character	lgd_mstr.lgd_inv_nbr	Invoice Number
tclgd_nbr	character	lgd_mstr.lgd_nbr	Legal Doc Nbr
tclgd_order	character	lgd_mstr.lgd_order	Order Number
ttlgd_print_date	date	lgd_mstr.lgd_print_date	Print Date
ttlgd_receive_date	date	lgd_mstr.lgd_receive_date	Receiving Date
tclgd_ship	character	lgd_mstr.lgd_ship	Ship-To
tllgd_type	logical	lgd_mstr.lgd_type	Legal Document Type

Internal usage

QadFinancials

method BMFGLegalDocument.ApiLegalDocumentReport