project QadFinancials > class BMFGLegalDocument > business logic query LegalDocDetailForAPMatching
Description
Querty that obtains the legal document and pending voucher information from the unique index for the legal document detail record.
Parameters
idOidLegalDocumentDetail | decimal | Index for legal document detail record. |
query condition
each lgdd_det where
lgdd_det.oid_lgdd_det = idOidLegalDocumentDetail
first lgd_mstr (inner-join) where
lgd_mstr.oid_lgd_mstr = lgdd_det.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
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 prh_hist (inner-join) where
prh_hist.prh_domain = pvod_det.pvod_domain AND
prh_hist.prh_receiver = pvod_det.pvod_internal_ref AND
prh_hist.prh_nbr = pvod_det.pvod_order AND
prh_hist.prh_line = pvod_det.pvod_order_line AND
query resultset tqLegalDocDetailForAPMatching
field name | data type | db field | description |
ttlgd_effdate | date | lgd_mstr.lgd_effdate | Effective Date |
tclgd_nbr | character | lgd_mstr.lgd_nbr | Legal Doc Nbr |
tclgd_shipfrom | character | lgd_mstr.lgd_shipfrom | Ship From |
tilgdd_line | integer | lgdd_det.lgdd_line | Line |
tclgdd_part | character | lgdd_det.lgdd_part | Item Number |
tdoid_lgd_mstr | decimal | lgdd_det.oid_lgd_mstr | |
tdoid_lgdd_det | decimal | lgdd_det.oid_lgdd_det | |
tdprh_ps_qty | decimal | prh_hist.prh_ps_qty | Packing Slip Qty |
tcprh_type | character | prh_hist.prh_type | Purchase Type |
tcprh_um | character | prh_hist.prh_um | UM |
tcpvo_domain | character | pvo_mstr.pvo_domain | Domain |
tipvo_id | integer | pvo_mstr.pvo_id | Pending Voucher ID |
tipvo_line | integer | pvo_mstr.pvo_line | Line |
tcpvo_order | character | pvo_mstr.pvo_order | Order |
tcpvo_part | character | pvo_mstr.pvo_part | Item Number |
tcpvod_order | character | pvod_det.pvod_order | Order |
tipvod_order_line | integer | pvod_det.pvod_order_line | Order Line |
tcpvod_part | character | pvod_det.pvod_part | Item Number |
Internal usage
QadFinancials