project QadFinancials > class BMFGLegalDocument > business logic query LegalDocumentPendVoucherForERS

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.
icReceivercharacterParameter: Receiver number.
icReceiverFromcharacterFiltering Parameter: Reciever number from.
icReceiverTocharacterFiltering parameter: receiver number 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_posted <> true

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

          each pvo_mstr (inner-join) where
pvo_mstr.pvo_domain = lgdd_det.lgdd_domain AND
pvo_mstr.pvo_order = lgdd_det.lgdd_order AND
pvo_mstr.pvo_line = lgdd_det.lgdd_order_line AND
pvo_mstr.pvo_internal_ref = icReceiver AND
pvo_mstr.pvo_internal_ref >= icReceiverFrom AND
pvo_mstr.pvo_internal_ref <= icReceiverTo AND
pvo_mstr.pvo_shipto = icSite AND
pvo_mstr.pvo_shipto >= icSiteFrom AND
pvo_mstr.pvo_shipto <= icSiteTo AND
pvo_mstr.pvo_supplier = icSupplier AND
pvo_mstr.pvo_supplier >= icSupplierFrom AND
pvo_mstr.pvo_supplier <= icSupplierTo AND
pvo_mstr.pvo_trans_date = itReceiptDate AND
pvo_mstr.pvo_trans_date >= itReceiptDateFrom AND
pvo_mstr.pvo_trans_date <= itReceiptDateTo AND
pvo_mstr.pvo_lc_charge = ''

              first po_mstr (inner-join) where
po_mstr.po_domain = pvo_mstr.pvo_domain AND
po_mstr.po_nbr = pvo_mstr.pvo_order AND

              each pvod_det (inner-join) where
pvod_det.pvod_domain = pvo_mstr.pvo_domain AND
pvod_det.pvod_id = pvo_mstr.pvo_id AND


query resultset tqLegalDocumentPendVoucherForERS


field namedata typedb fielddescription
tclgd_doc_typecharacterlgd_mstr.lgd_doc_typeDoc Type
tclgd_domaincharacterlgd_mstr.lgd_domainDomain
ttlgd_effdatedatelgd_mstr.lgd_effdateEffective Date
tclgd_inv_nbrcharacterlgd_mstr.lgd_inv_nbrInvoice Number
tclgd_nbrcharacterlgd_mstr.lgd_nbrLegal Doc Nbr
tllgd_postedlogicallgd_mstr.lgd_postedPosted
tclgd_shipcharacterlgd_mstr.lgd_shipShip-To
tclgd_shipper_idcharacterlgd_mstr.lgd_shipper_idShipper ID
tclgd_shipto_sitecharacterlgd_mstr.lgd_shipto_siteShip-to Site
tilgdd_lineintegerlgdd_det.lgdd_lineLine
tclgdd_ordercharacterlgdd_det.lgdd_orderOrder
tilgdd_order_lineintegerlgdd_det.lgdd_order_lineLine
tcpo_project1characterpo_mstr.po_projectProject
tipvo_cinvoice_idintegerpvo_mstr.pvo_cinvoice_idInvoice ID
tcpvo_currcharacterpvo_mstr.pvo_currCurrency
tipvo_ers_optintegerpvo_mstr.pvo_ers_optERS Option
tipvo_ers_price_lst_optintegerpvo_mstr.pvo_ers_price_lst_optERS Price List Option
tipvo_ers_statusintegerpvo_mstr.pvo_ers_statusERS Status
tcpvo_external_refcharacterpvo_mstr.pvo_external_refExternal Reference
tipvo_idintegerpvo_mstr.pvo_idPending Voucher ID
tcpvo_internal_refcharacterpvo_mstr.pvo_internal_refInternal Reference
tcpvo_internal_ref_typecharacterpvo_mstr.pvo_internal_ref_typeInternal Reference Type
tcpvo_lc_chargecharacterpvo_mstr.pvo_lc_chargeLogistics Charge Code
tcpvo_partcharacterpvo_mstr.pvo_partItem Number
tcpvo_shiptocharacterpvo_mstr.pvo_shiptoShip-To
tcpvo_suppliercharacterpvo_mstr.pvo_supplierSupplier
ttpvo_trans_datedatepvo_mstr.pvo_trans_dateTransaction Date
tipvod_id_lineintegerpvod_det.pvod_id_lineLine
tdpvod_trans_qtydecimalpvod_det.pvod_trans_qtyTransaction Qty


Internal usage


QadFinancials
method BERSProcessor.GetERSLegalDocumentsNoLC