project QadFinancials > class BMFGLegalDocument > business logic query LegalDocDetailForAPMatching

Description

Querty that obtains the legal document and pending voucher information from the unique index for the legal document detail record.


Parameters


idOidLegalDocumentDetaildecimalIndex for legal document detail record.


query condition


  each lgdd_det where
lgdd_det.oid_lgdd_det = idOidLegalDocumentDetail

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

      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

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

              first prh_hist (inner-join) where
prh_hist.prh_domain = pvod_det.pvod_domain AND
prh_hist.prh_receiver = pvod_det.pvod_internal_ref AND
prh_hist.prh_nbr = pvod_det.pvod_order AND
prh_hist.prh_line = pvod_det.pvod_order_line AND


query resultset tqLegalDocDetailForAPMatching


field namedata typedb fielddescription
ttlgd_effdatedatelgd_mstr.lgd_effdateEffective Date
tclgd_nbrcharacterlgd_mstr.lgd_nbrLegal Doc Nbr
tclgd_shipfromcharacterlgd_mstr.lgd_shipfromShip From
tilgdd_lineintegerlgdd_det.lgdd_lineLine
tclgdd_partcharacterlgdd_det.lgdd_partItem Number
tdoid_lgd_mstrdecimallgdd_det.oid_lgd_mstr
tdoid_lgdd_detdecimallgdd_det.oid_lgdd_det
tdprh_ps_qtydecimalprh_hist.prh_ps_qtyPacking Slip Qty
tcprh_typecharacterprh_hist.prh_typePurchase Type
tcprh_umcharacterprh_hist.prh_umUM
tcpvo_domaincharacterpvo_mstr.pvo_domainDomain
tipvo_idintegerpvo_mstr.pvo_idPending Voucher ID
tipvo_lineintegerpvo_mstr.pvo_lineLine
tcpvo_ordercharacterpvo_mstr.pvo_orderOrder
tcpvo_partcharacterpvo_mstr.pvo_partItem Number
tcpvod_ordercharacterpvod_det.pvod_orderOrder
tipvod_order_lineintegerpvod_det.pvod_order_lineOrder Line
tcpvod_partcharacterpvod_det.pvod_partItem Number


Internal usage


QadFinancials
method BAPMatching.GetPendingVouchersLogChargesQuery