project QadFinancials > class BMFGLogisiticsAccounting > business logic query LogAcctPendingVoucherForERS

Description

Query to find the pending vouchers records associated with a logistics accounting detail record.


Parameters


icInternalReferencecharacterlogistics accounting detail internal reference.
icDomaincharacterDomain code


query condition


  each lacd_det where
lacd_det.lacd_internal_ref = icInternalReference AND
lacd_det.lacd_domain = icDomain

      each pvo_mstr (inner-join) where
pvo_mstr.pvo_internal_ref_type = lacd_det.lacd_internal_ref_type AND
pvo_mstr.pvo_internal_ref = lacd_det.lacd_internal_ref AND
pvo_mstr.pvo_domain = lacd_det.lacd_domain AND
pvo_mstr.pvo_lc_charge = lacd_det.lacd_lc_charge AND
(('' <> lacd_det.lacd_log_supplier AND
pvo_mstr.pvo_shipfrom = lacd_det.lacd_log_supplier ) OR
(pvo_mstr.pvo_shipfrom = lacd_det.lacd_shipfrom ))

          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 vd_mstr (inner-join) where
vd_mstr.vd_addr = pvo_mstr.pvo_supplier AND
vd_mstr.vd_domain = pvo_mstr.pvo_domain AND


query resultset tqLogAcctPendingVoucherForERS


field namedata typedb fielddescription
tclacd_domaincharacterlacd_det.lacd_domainDomain
tclacd_internal_refcharacterlacd_det.lacd_internal_refInternal Reference
tclacd_log_suppliercharacterlacd_det.lacd_log_supplierSupplier
tdoid_pvo_mstrdecimalpvo_mstr.oid_pvo_mstr
tcpvo_currcharacterpvo_mstr.pvo_currCurrency
tcpvo_domaincharacterpvo_mstr.pvo_domainDomain
ttpvo_eff_datedatepvo_mstr.pvo_eff_dateGL Effective Date
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
tipvo_lineintegerpvo_mstr.pvo_lineLine
tcpvo_ordercharacterpvo_mstr.pvo_orderOrder
tcpvo_order_typecharacterpvo_mstr.pvo_order_typeOrder Type
tcpvo_partcharacterpvo_mstr.pvo_partItem Number
tcpvo_projectcharacterpvo_mstr.pvo_projectProject
tcpvo_shipfromcharacterpvo_mstr.pvo_shipfromShip-From
tcpvo_shiptocharacterpvo_mstr.pvo_shiptoShip-To
tcpvo_suppliercharacterpvo_mstr.pvo_supplierSupplier
tcpvo_tax_envcharacterpvo_mstr.pvo_tax_envTax Environment
tlpvo_tax_inlogicalpvo_mstr.pvo_tax_inTax In
tcpvo_tax_usagecharacterpvo_mstr.pvo_tax_usageTax Usage
tlpvo_taxablelogicalpvo_mstr.pvo_taxableTaxable
tcpvo_taxccharacterpvo_mstr.pvo_taxcTax Class
ttpvo_trans_datedatepvo_mstr.pvo_trans_dateTransaction Date
tdpvo_trans_qtydecimalpvo_mstr.pvo_trans_qtyTransaction Qty
tdpvo_vouchered_amtdecimalpvo_mstr.pvo_vouchered_amtVouchered Amt
tdpvo_vouchered_qtydecimalpvo_mstr.pvo_vouchered_qtyVouchered Qty
tdpvod_accrued_amtdecimalpvod_det.pvod_accrued_amtAccrued Amount
tipvod_id_lineintegerpvod_det.pvod_id_lineLine
tdpvod_vouchered_amtdecimalpvod_det.pvod_vouchered_amtVouchered Amount
tcvd_daybooksetcharactervd_mstr.vd_daybooksetDaybook Set


Internal usage


QadFinancials
method BERSProcessor.ERSProcessLegalDocuments