project QadFinancials > class BMFGLegalDocument > business logic query LegalDocByLegDocByShipToByDate

Description

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


Parameters


icDomainCodecharacterDomainCode parameter
ilTypelogicalType parameter.
icLegalDocumentFromcharacterlegal document from parameter.
icLegalDocumentTocharacterLegal document to parameter.
itReceiveDateFromdateReceive date from parameter.
itReceiveDateTodateReceive date to parameter.
icShipToFromcharacterShip to address from parameter.
icShipToTocharacterShip 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 namedata typedb fielddescription
tclgd_domaincharacterlgd_mstr.lgd_domainDomain
tclgd_inv_nbrcharacterlgd_mstr.lgd_inv_nbrInvoice Number
tclgd_nbrcharacterlgd_mstr.lgd_nbrLegal Doc Nbr
tclgd_ordercharacterlgd_mstr.lgd_orderOrder Number
ttlgd_print_datedatelgd_mstr.lgd_print_datePrint Date
ttlgd_receive_datedatelgd_mstr.lgd_receive_dateReceiving Date
tclgd_shipcharacterlgd_mstr.lgd_shipShip-To
tllgd_typelogicallgd_mstr.lgd_typeLegal Document Type


Internal usage


QadFinancials
method BMFGLegalDocument.ApiLegalDocumentReport