project QadFinancials > class BMFGLegalDocument > business logic query LegalDocumentByLegalDocNbr
Description
Query to return information for a set of legal documents. Includes pending voucher header information only.
Parameters
| icDomainCode | character | Domain Code |
| icLegalDocNbr | character | Legal Document Number |
| itEffIssueDate | date | Effective Issue Date |
| icSupplier | character | Supplier Code |
query condition
each lgd_mstr where
lgd_mstr.lgd_domain = icDomainCode AND
lgd_mstr.lgd_effdate = itEffIssueDate AND
lgd_mstr.lgd_nbr = icLegalDocNbr AND
lgd_mstr.lgd_shipfrom = icSupplier
each lgdd_det (inner-join) where
lgdd_det.oid_lgd_mstr = lgd_mstr.oid_lgd_mstr AND
query resultset tqLegalDocumentByLegalDocNbr
| field name | data type | db field | description |
|---|
| tclgd_addr | character | lgd_mstr.lgd_addr | Legal Doc Address |
| tdlgd_amt | decimal | lgd_mstr.lgd_amt | Legal Doc Amount |
| tdlgd_ar_amt | decimal | lgd_mstr.lgd_ar_amt | AR Amount |
| tclgd_bill | character | lgd_mstr.lgd_bill | Bill-To |
| tclgd_cust | character | lgd_mstr.lgd_cust | Customer |
| tclgd_doc_type | character | lgd_mstr.lgd_doc_type | Doc Type |
| tclgd_domain | character | lgd_mstr.lgd_domain | Domain |
| tdlgd_dsc_amt | decimal | lgd_mstr.lgd_dsc_amt | Discount Amount |
| 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 |
| tdlgd_goods_amt | decimal | lgd_mstr.lgd_goods_amt | Goods Amount |
| ttlgd_inv_date | date | lgd_mstr.lgd_inv_date | Invoice Date |
| tclgd_inv_mov | character | lgd_mstr.lgd_inv_mov | Inventory Movement Code |
| tclgd_inv_nbr | character | lgd_mstr.lgd_inv_nbr | Invoice Number |
| tclgd_nbr | character | lgd_mstr.lgd_nbr | Legal Doc Nbr |
| tclgd_order | character | lgd_mstr.lgd_order | Order Number |
| tclgd_ship | character | lgd_mstr.lgd_ship | Ship-To |
| tclgd_shipfrom | character | lgd_mstr.lgd_shipfrom | Ship From |
| tclgd_shipto_loc | character | lgd_mstr.lgd_shipto_loc | Ship-to Location |
| tclgd_shipto_site | character | lgd_mstr.lgd_shipto_site | Ship-to Site |
| tclgd_tax_env | character | lgd_mstr.lgd_tax_env | Tax Environment |
| tllgd_tax_in | logical | lgd_mstr.lgd_tax_in | Tax In |
| tclgd_tax_usage | character | lgd_mstr.lgd_tax_usage | Tax Usage |
| tllgd_taxable | logical | lgd_mstr.lgd_taxable | Taxable |
| tclgd_taxc | character | lgd_mstr.lgd_taxc | Tax Class |
| tdlgd_trl_amt | decimal | lgd_mstr.lgd_trl_amt | Trailer Total Amount |
| tdlgd_trl1_amt | decimal | lgd_mstr.lgd_trl1_amt | Trailer Amt 1 |
| tdlgd_trl2_amt | decimal | lgd_mstr.lgd_trl2_amt | Trailer Amt 2 |
| tdlgd_trl3_amt | decimal | lgd_mstr.lgd_trl3_amt | Trailer Amt 3 |
| tllgd_type | logical | lgd_mstr.lgd_type | Legal Document Type |
| 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 |
| tclgdd_tax_env | character | lgdd_det.lgdd_tax_env | Tax Environment |
| tllgdd_tax_in | logical | lgdd_det.lgdd_tax_in | Tax In |
| tclgdd_tax_usage | character | lgdd_det.lgdd_tax_usage | Tax Usage |
| tllgdd_taxable | logical | lgdd_det.lgdd_taxable | Taxable |
| tclgdd_taxc | character | lgdd_det.lgdd_taxc | Tax Class |
Internal usage
QadFinancials