project QadFinancials > class BMFGLegalDocument > business logic query LegalDocumentPendVoucherLCForERS

Description

Query to return information for a set of legal documents. Includes pending voucher header information and purchase order header information.


Parameters


icDomaincharacterParameter for the domaincode
icSuppliercharacterParameter for the supplier.
icSupplierFromcharacterFilteing parameter: supplier from.
icSupplierTocharacterFiltering parameter: supplier to.
icSitecharacterParameter: Site Code.
icSiteFromcharacterFiltering parameter: Site From
icSiteTocharacterFiltering parameter: Site To.
itReceiptDatedateParameter: receipt date.
itReceiptDateFromdateFiltering parameter: receipt date from.
itReceiptDateTodateFiltering parameter: receipt date to.
icLegalDoccharacterParameter: legal document.
icLegalDocFromcharacterFiltering parameter: legal document from.
icLegalDocTocharacterFiltering parameter: Legal document to.
itEffDatedateParameter: Effective Issue Date
itEffDateFromdateFiltering parameter: effective issue date.
itEffDateTodateFiltering parameter: effective issue date.


query condition


  each lgd_mstr where
lgd_mstr.lgd_domain = icDomain AND
lgd_mstr.lgd_nbr = icLegalDoc AND
lgd_mstr.lgd_nbr >= icLegalDocFrom AND
lgd_mstr.lgd_nbr <= icLegalDocTo AND
lgd_mstr.lgd_effdate = itEffDate AND
lgd_mstr.lgd_effdate >= itEffDateFrom AND
lgd_mstr.lgd_effdate <= itEffDateTo AND
lgd_mstr.lgd_shipfrom = icSupplier AND
lgd_mstr.lgd_shipfrom >= icSupplierFrom AND
lgd_mstr.lgd_shipfrom <= icSupplierTo AND
lgd_mstr.lgd_shipto_site = icSite AND
lgd_mstr.lgd_shipto_site >= icSiteFrom AND
lgd_mstr.lgd_shipto_site <= icSiteTo AND
lgd_mstr.lgd_receive_date = itReceiptDate AND
lgd_mstr.lgd_receive_date >= itReceiptDateFrom AND
lgd_mstr.lgd_receive_date <= itReceiptDateTo

      each lgdd_det (inner-join) where
lgdd_det.oid_lgd_mstr = lgd_mstr.oid_lgd_mstr AND


query resultset tqLegalDocumentPendVoucherLCForE


field namedata typedb fielddescription
tclgd_cr_termscharacterlgd_mstr.lgd_cr_termsCredit Terms
tclgd_doc_typecharacterlgd_mstr.lgd_doc_typeDoc Type
tclgd_domaincharacterlgd_mstr.lgd_domainDomain
ttlgd_due_datedatelgd_mstr.lgd_due_dateDue Date
ttlgd_effdatedatelgd_mstr.lgd_effdateEffective Date
tdlgd_ex_ratedecimallgd_mstr.lgd_ex_rateExch Rate
tdlgd_ex_rate2decimallgd_mstr.lgd_ex_rate2Exch Rate 2
tclgd_inv_nbrcharacterlgd_mstr.lgd_inv_nbrInvoice Number
tclgd_nbrcharacterlgd_mstr.lgd_nbrLegal Doc Nbr
tllgd_postedlogicallgd_mstr.lgd_postedPosted
ttlgd_receive_datedatelgd_mstr.lgd_receive_dateReceiving Date
tclgd_shipcharacterlgd_mstr.lgd_shipShip-To
tclgd_shipfromcharacterlgd_mstr.lgd_shipfromShip From
tclgd_shipper_idcharacterlgd_mstr.lgd_shipper_idShipper ID
ttlgd_tax_datedatelgd_mstr.lgd_tax_dateTax Date
tllgd_taxablelogicallgd_mstr.lgd_taxableTaxable
tclgd_trans_currcharacterlgd_mstr.lgd_trans_currTransaction Currency
tclgdd_doc_typecharacterlgdd_det.lgdd_doc_typeDoc Type
tilgdd_lineintegerlgdd_det.lgdd_lineLine
tclgdd_ordercharacterlgdd_det.lgdd_orderOrder
tilgdd_order_lineintegerlgdd_det.lgdd_order_lineLine
tdlgdd_pricedecimallgdd_det.lgdd_pricePrice
tdoid_lgdd_detdecimallgdd_det.oid_lgdd_det


Internal usage


QadFinancials
method BERSProcessor.ERSProcessLegalDocuments
method BERSProcessor.GetERSLegalDocumentsLC