business logic query LegalDocumentPendVoucherLCForERS

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.
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_shipfrom = icSupplier AND
lgd_mstr.lgd_shipfrom >= icSupplierFrom AND
lgd_mstr.lgd_shipfrom <= icSupplierTo AND
lgd_mstr.lgd_shipto_site = icSite AND
lgd_mstr.lgd_shipto_site >= icSiteFrom AND
lgd_mstr.lgd_shipto_site <= icSiteTo AND
lgd_mstr.lgd_receive_date = itReceiptDate AND
lgd_mstr.lgd_receive_date >= itReceiptDateFrom AND
lgd_mstr.lgd_receive_date <= itReceiptDateTo

each lgdd_det (inner-join) where

lgdd_det.oid_lgd_mstr = lgd_mstr.oid_lgd_mstr AND

query resultset tqLegalDocumentPendVoucherLCForE

field name	data type	db field	description
tclgd_cr_terms	character	lgd_mstr.lgd_cr_terms	Credit Terms
tclgd_doc_type	character	lgd_mstr.lgd_doc_type	Doc Type
tclgd_domain	character	lgd_mstr.lgd_domain	Domain
ttlgd_due_date	date	lgd_mstr.lgd_due_date	Due Date
ttlgd_effdate	date	lgd_mstr.lgd_effdate	Effective Date
tdlgd_ex_rate	decimal	lgd_mstr.lgd_ex_rate	Exch Rate
tdlgd_ex_rate2	decimal	lgd_mstr.lgd_ex_rate2	Exch Rate 2
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
ttlgd_receive_date	date	lgd_mstr.lgd_receive_date	Receiving Date
tclgd_ship	character	lgd_mstr.lgd_ship	Ship-To
tclgd_shipfrom	character	lgd_mstr.lgd_shipfrom	Ship From
tclgd_shipper_id	character	lgd_mstr.lgd_shipper_id	Shipper ID
ttlgd_tax_date	date	lgd_mstr.lgd_tax_date	Tax Date
tllgd_taxable	logical	lgd_mstr.lgd_taxable	Taxable
tclgd_trans_curr	character	lgd_mstr.lgd_trans_curr	Transaction Currency
tclgdd_doc_type	character	lgdd_det.lgdd_doc_type	Doc Type
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
tdlgdd_price	decimal	lgdd_det.lgdd_price	Price
tdoid_lgdd_det	decimal	lgdd_det.oid_lgdd_det

Internal usage

QadFinancials

method BERSProcessor.ERSProcessLegalDocuments
method BERSProcessor.GetERSLegalDocumentsLC