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

icDomain	character	Parameter for the domaincode
icSupplier	character	Parameter for the supplier.
icSupplierFrom	character	Filteing parameter: supplier from.
icSupplierTo	character	Filtering parameter: supplier to.
icSite	character	Parameter: Site Code.
icSiteFrom	character	Filtering parameter: Site From
icSiteTo	character	Filtering parameter: Site To.
icReceiver	character	Parameter: Receiver number.
icReceiverFrom	character	Filtering Parameter: Reciever number from.
icReceiverTo	character	Filtering parameter: receiver number to.
itReceiptDate	date	Parameter: receipt date.
itReceiptDateFrom	date	Filtering parameter: receipt date from.
itReceiptDateTo	date	Filtering parameter: receipt date to.
icLegalDoc	character	Parameter: legal document.
icLegalDocFrom	character	Filtering parameter: legal document from.
icLegalDocTo	character	Filtering parameter: Legal document to.
itEffDate	date	Parameter: Effective Issue Date
itEffDateFrom	date	Filtering parameter: effective issue date.
itEffDateTo	date	Filtering 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 name	data type	db field	description
tclgd_doc_type	character	lgd_mstr.lgd_doc_type	Doc Type
tclgd_domain	character	lgd_mstr.lgd_domain	Domain
ttlgd_effdate	date	lgd_mstr.lgd_effdate	Effective Date
tclgd_inv_nbr	character	lgd_mstr.lgd_inv_nbr	Invoice Number
tclgd_nbr	character	lgd_mstr.lgd_nbr	Legal Doc Nbr
tllgd_posted	logical	lgd_mstr.lgd_posted	Posted
tclgd_ship	character	lgd_mstr.lgd_ship	Ship-To
tclgd_shipper_id	character	lgd_mstr.lgd_shipper_id	Shipper ID
tclgd_shipto_site	character	lgd_mstr.lgd_shipto_site	Ship-to Site
tilgdd_line	integer	lgdd_det.lgdd_line	Line
tclgdd_order	character	lgdd_det.lgdd_order	Order
tilgdd_order_line	integer	lgdd_det.lgdd_order_line	Line
tcpo_project1	character	po_mstr.po_project	Project
tipvo_cinvoice_id	integer	pvo_mstr.pvo_cinvoice_id	Invoice ID
tcpvo_curr	character	pvo_mstr.pvo_curr	Currency
tipvo_ers_opt	integer	pvo_mstr.pvo_ers_opt	ERS Option
tipvo_ers_price_lst_opt	integer	pvo_mstr.pvo_ers_price_lst_opt	ERS Price List Option
tipvo_ers_status	integer	pvo_mstr.pvo_ers_status	ERS Status
tcpvo_external_ref	character	pvo_mstr.pvo_external_ref	External Reference
tipvo_id	integer	pvo_mstr.pvo_id	Pending Voucher ID
tcpvo_internal_ref	character	pvo_mstr.pvo_internal_ref	Internal Reference
tcpvo_internal_ref_type	character	pvo_mstr.pvo_internal_ref_type	Internal Reference Type
tcpvo_lc_charge	character	pvo_mstr.pvo_lc_charge	Logistics Charge Code
tcpvo_part	character	pvo_mstr.pvo_part	Item Number
tcpvo_shipto	character	pvo_mstr.pvo_shipto	Ship-To
tcpvo_supplier	character	pvo_mstr.pvo_supplier	Supplier
ttpvo_trans_date	date	pvo_mstr.pvo_trans_date	Transaction Date
tipvod_id_line	integer	pvod_det.pvod_id_line	Line
tdpvod_trans_qty	decimal	pvod_det.pvod_trans_qty	Transaction Qty

Internal usage

QadFinancials

method BERSProcessor.GetERSLegalDocumentsNoLC