project QadFinancials > class BMfgPO > business logic query PurchaseOrderDetailForTax


Parameters


icDomaincharacterdomain
icPoNbrcharacterPo number


query condition


  each po_mstr where
po_mstr.po_domain = icDomain AND
po_mstr.po_nbr = icPoNbr

      each pod_det (inner-join) where
pod_det.pod_domain = po_mstr.po_domain AND
pod_det.pod_nbr = po_mstr.po_nbr AND

          first tx2d_det (conditional-join) where
tx2d_det.tx2d_domain = pod_det.pod_domain AND
tx2d_det.tx2d_ref = pod_det.pod_nbr AND
tx2d_det.tx2d_line = pod_det.pod_line AND

              first tx2_mstr (conditional-join) where
tx2_mstr.tx2_domain = tx2d_det.tx2d_domain AND
tx2_mstr.tx2_tax_code = tx2d_det.tx2d_tax_code AND


query resultset tqPurchaseOrderDetailForTax


field namedata typedb fielddescription
tcpo_domaincharacterpo_mstr.po_domainDomain
tcpo_nbrcharacterpo_mstr.po_nbrPurchase Order
tcpod_domaincharacterpod_det.pod_domainDomain
tipod_lineintegerpod_det.pod_lineLine
tcpod_nbrcharacterpod_det.pod_nbrPurchase Order
tltx2_rcpt_tax_pointlogicaltx2_mstr.tx2_rcpt_tax_pointAccrue Tax at Receipt
tltx2_usage_tax_pointlogicaltx2_mstr.tx2_usage_tax_pointAccrue Tax At Usage
tctx2d_domaincharactertx2d_det.tx2d_domainDomain
titx2d_lineintegertx2d_det.tx2d_lineLine
tctx2d_refcharactertx2d_det.tx2d_refReference
tctx2d_tr_typecharactertx2d_det.tx2d_tr_typeTransaction Type
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(po_mstr),rowid(pod_det),rowid(tx2d_det),rowid(tx2_mstr)


Internal usage


QadFinancials
method BCInvoice.CreateCIPostingTax