Description
Query to find the pending vouchers records associated with a logistics accounting detail record.
Parameters
| icInternalReference | character | logistics accounting detail internal reference. |
| icDomain | character | Domain 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 name | data type | db field | description |
|---|
| tclacd_domain | character | lacd_det.lacd_domain | Domain |
| tclacd_internal_ref | character | lacd_det.lacd_internal_ref | Internal Reference |
| tclacd_log_supplier | character | lacd_det.lacd_log_supplier | Supplier |
| tdoid_pvo_mstr | decimal | pvo_mstr.oid_pvo_mstr | |
| tcpvo_curr | character | pvo_mstr.pvo_curr | Currency |
| tcpvo_domain | character | pvo_mstr.pvo_domain | Domain |
| ttpvo_eff_date | date | pvo_mstr.pvo_eff_date | GL Effective Date |
| 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 |
| tipvo_line | integer | pvo_mstr.pvo_line | Line |
| tcpvo_order | character | pvo_mstr.pvo_order | Order |
| tcpvo_order_type | character | pvo_mstr.pvo_order_type | Order Type |
| tcpvo_part | character | pvo_mstr.pvo_part | Item Number |
| tcpvo_project | character | pvo_mstr.pvo_project | Project |
| tcpvo_shipfrom | character | pvo_mstr.pvo_shipfrom | Ship-From |
| tcpvo_shipto | character | pvo_mstr.pvo_shipto | Ship-To |
| tcpvo_supplier | character | pvo_mstr.pvo_supplier | Supplier |
| tcpvo_tax_env | character | pvo_mstr.pvo_tax_env | Tax Environment |
| tlpvo_tax_in | logical | pvo_mstr.pvo_tax_in | Tax In |
| tcpvo_tax_usage | character | pvo_mstr.pvo_tax_usage | Tax Usage |
| tlpvo_taxable | logical | pvo_mstr.pvo_taxable | Taxable |
| tcpvo_taxc | character | pvo_mstr.pvo_taxc | Tax Class |
| ttpvo_trans_date | date | pvo_mstr.pvo_trans_date | Transaction Date |
| tdpvo_trans_qty | decimal | pvo_mstr.pvo_trans_qty | Transaction Qty |
| tdpvo_vouchered_amt | decimal | pvo_mstr.pvo_vouchered_amt | Vouchered Amt |
| tdpvo_vouchered_qty | decimal | pvo_mstr.pvo_vouchered_qty | Vouchered Qty |
| tdpvod_accrued_amt | decimal | pvod_det.pvod_accrued_amt | Accrued Amount |
| tipvod_id_line | integer | pvod_det.pvod_id_line | Line |
| tdpvod_vouchered_amt | decimal | pvod_det.pvod_vouchered_amt | Vouchered Amount |
| tcvd_daybookset | character | vd_mstr.vd_daybookset | Daybook Set |
Internal usage
QadFinancials