project QadFinancials > class BMFGLegalDocument > business logic query LegalDocumentPendVoucherDetail

Description

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


Parameters


icDomaincharacterParameters: domain code.
icSuppliercharacter
icLegalNbrcharacterParameters: Legal document number.
itEffDatedateParameters: effective issue date.


query condition


  each lgd_mstr where
lgd_mstr.lgd_domain = icDomain AND
lgd_mstr.lgd_effdate = itEffDate AND
lgd_mstr.lgd_nbr = icLegalNbr

      first im_mstr (outer-join) where
im_mstr.im_domain = lgd_mstr.lgd_domain AND
im_mstr.im_inv_mov = lgd_mstr.lgd_inv_mov AND

      each lgdd_det (inner-join) where
lgdd_det.oid_lgd_mstr = lgd_mstr.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
pvo_mstr.pvo_supplier = icSupplier

              first prh_hist (inner-join) where
prh_hist.prh_domain = pvo_mstr.pvo_domain AND
prh_hist.prh_nbr = pvo_mstr.pvo_order AND
prh_hist.prh_receiver = pvo_mstr.pvo_internal_ref AND
prh_hist.prh_line = pvo_mstr.pvo_line AND

                  first pod_det (inner-join) where
pod_det.pod_domain = prh_hist.prh_domain AND
pod_det.pod_line = prh_hist.prh_line AND
pod_det.pod_nbr = prh_hist.prh_nbr AND

                      first po_mstr (inner-join) where
po_mstr.po_domain = pod_det.pod_domain AND
po_mstr.po_nbr = pod_det.pod_nbr 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 tqLegalDocumentPendVoucherDetail


field namedata typedb fielddescription
tcim_desccharacterim_mstr.im_descDescription
tcim_domaincharacterim_mstr.im_domainDomain
tiim_flowintegerim_mstr.im_flowTransaction Flow
tcim_inv_movcharacterim_mstr.im_inv_movInventory Movement Code
tcim_tr_typecharacterim_mstr.im_tr_typeTransaction Type
tdlgd_amtdecimallgd_mstr.lgd_amtLegal Doc Amount
tdlgd_ar_amtdecimallgd_mstr.lgd_ar_amtAR Amount
tclgd_cr_termscharacterlgd_mstr.lgd_cr_termsCredit Terms
tclgd_domaincharacterlgd_mstr.lgd_domainDomain
tdlgd_dsc_amtdecimallgd_mstr.lgd_dsc_amtDiscount Amount
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
tllgd_fix_ratelogicallgd_mstr.lgd_fix_rateFixed Rate
tdlgd_goods_amtdecimallgd_mstr.lgd_goods_amtGoods Amount
tclgd_nbrcharacterlgd_mstr.lgd_nbrLegal Doc Nbr
ttlgd_receive_datedatelgd_mstr.lgd_receive_dateReceiving Date
tclgd_shipcharacterlgd_mstr.lgd_shipShip-To
ttlgd_ship_datedatelgd_mstr.lgd_ship_dateShip Date
ttlgd_tax_datedatelgd_mstr.lgd_tax_dateTax Date
tclgd_trans_currcharacterlgd_mstr.lgd_trans_currTransaction Currency
tdlgd_trl_amtdecimallgd_mstr.lgd_trl_amtTrailer Total Amount
tdlgd_trl1_amtdecimallgd_mstr.lgd_trl1_amtTrailer Amt 1
tdlgd_trl2_amtdecimallgd_mstr.lgd_trl2_amtTrailer Amt 2
tdlgd_trl3_amtdecimallgd_mstr.lgd_trl3_amtTrailer Amt 3
tllgd_typelogicallgd_mstr.lgd_typeLegal Document Type
tdlgdd_ext_pricedecimallgdd_det.lgdd_ext_priceExt Price
tilgdd_lineintegerlgdd_det.lgdd_lineLine
tclgdd_nbrcharacterlgdd_det.lgdd_nbrLegal Doc Nbr
tclgdd_ordercharacterlgdd_det.lgdd_orderOrder
tilgdd_order_lineintegerlgdd_det.lgdd_order_lineLine
tdlgdd_pricedecimallgdd_det.lgdd_pricePrice
tdlgdd_qty_itemdecimallgdd_det.lgdd_qty_itemItem Quantity
tclgdd_umcharacterlgdd_det.lgdd_umUM
tdoid_lgd_mstrdecimallgd_mstr.oid_lgd_mstr
tdoid_pvo_mstr1decimalpvo_mstr.oid_pvo_mstr
tcpo_ap_acctcharacterpo_mstr.po_ap_acctAP Acct
tcpo_ap_cccharacterpo_mstr.po_ap_ccCost Ctr
tcpo_ap_subcharacterpo_mstr.po_ap_subAP Sub-Acct
tcpo_cr_termscharacterpo_mstr.po_cr_termsCredit Terms
tcpo_currcharacterpo_mstr.po_currCurrency
tcpo_daybooksetcharacterpo_mstr.po_daybooksetDaybook Set
tdpo_disc_pctdecimalpo_mstr.po_disc_pctDisc %
ttpo_ord_datedatepo_mstr.po_ord_dateOrder Date
tcpo_pr_listcharacterpo_mstr.po_pr_listDisc Tbl
tcpo_pr_list2characterpo_mstr.po_pr_list2Price Tbl
tlpo_schedlogicalpo_mstr.po_schedScheduled
tcpo_shipcharacterpo_mstr.po_shipShip-To
tcpo_sitecharacterpo_mstr.po_siteSite
ttpo_tax_datedatepo_mstr.po_tax_dateTax Date
tlpo_taxablelogicalpo_mstr.po_taxableTaxable
tcpo_vendcharacterpo_mstr.po_vendSupplier
tlpod_fix_prlogicalpod_det.pod_fix_prFixed Price
tcpod_partcharacterpod_det.pod_partItem Number
tcpod_pr_listcharacterpod_det.pod_pr_listPrice List
tdpod_pur_costdecimalpod_det.pod_pur_costPurchase Cost
tdpod_qty_orddecimalpod_det.pod_qty_ordQty Ordered
tcpod_sitecharacterpod_det.pod_siteSite
tcpod_umcharacterpod_det.pod_umUM
tdpod_um_convdecimalpod_det.pod_um_convUM Conversion
tcpod_vpartcharacterpod_det.pod_vpartSupplier Item
tcprh_domaincharacterprh_hist.prh_domainDomain
tcprh_ps_nbrcharacterprh_hist.prh_ps_nbrPacking Slip
ttprh_rcp_datedateprh_hist.prh_rcp_dateReceipt Date
tcprh_rcp_typecharacterprh_hist.prh_rcp_typeReceipt Type
tdprh_rcvddecimalprh_hist.prh_rcvdReceipt Qty
tcprh_receivercharacterprh_hist.prh_receiverReceiver
ttprh_ship_datedateprh_hist.prh_ship_dateShip Date
tlpvo_consignment1logicalpvo_mstr.pvo_consignmentConsignment
tcpvo_domain1characterpvo_mstr.pvo_domainDomain
ttpvo_eff_date1datepvo_mstr.pvo_eff_dateGL Effective Date
tcpvo_external_ref1characterpvo_mstr.pvo_external_refExternal Reference
tipvo_id1integerpvo_mstr.pvo_idPending Voucher ID
tcpvo_internal_ref1characterpvo_mstr.pvo_internal_refInternal Reference
tdpvod_ex_ratedecimalpvod_det.pvod_ex_rateExch Rate
tdpvod_ex_rate2decimalpvod_det.pvod_ex_rate2Exch Rate 2
tipvod_idintegerpvod_det.pvod_idPending Voucher ID
tipvod_id_lineintegerpvod_det.pvod_id_lineLine
tcpvod_last_vouchercharacterpvod_det.pvod_last_voucherSupplier Invoice
tdpvod_pur_costdecimalpvod_det.pvod_pur_costPO Cost
ttpvod_trans_datedatepvod_det.pvod_trans_dateTransaction Date
tdpvod_trans_qtydecimalpvod_det.pvod_trans_qtyTransaction Qty
tdpvod_vouchered_qtydecimalpvod_det.pvod_vouchered_qtyVouchered Qty


Internal usage


QadFinancials
method BERSProcessor.ERSProcessLegalDocuments