project QadFinancials > class BMfgPO > business logic query PurchaseOrderForCreditorBR

Description

Query that returns all information for the Supplier's Business Relation of Purchase Orders where the parameters match - when values are provided


Parameters


icPurchaseOrdercharacterPurchase Order
icCreditorCodecharacterCreditor Code
iiCompanyIdintegerCompany id
icPvoDomaincharacter


query condition


  each po_mstr where
po_mstr.po_domain = icPvoDomain AND
po_mstr.po_nbr = icPurchaseOrder AND
po_mstr.po_vend = icCreditorCode

      first Creditor (inner-join) where
Creditor.SharedSet_Id = vi_CREDITOR_sharedset(iiCompanyId) AND
Creditor.CreditorCode = po_mstr.po_vend AND

          first BusinessRelation (inner-join) where
BusinessRelation.BusinessRelation_ID = Creditor.BusinessRelation_ID AND


query resultset tqPurchaseOrderForCreditorBR


field namedata typedb fielddescription
tcBusinessRelationCodecharacterBusinessRelation.BusinessRelationCodeBusiness Relation. A code to identify the business relation.
If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create.
tcBusinessRelationICCodecharacterBusinessRelation.BusinessRelationICCodeIntercompany Code. When Intercompany is true, this field is mandatory.
The code entered here must match the intercompany code entered for GL accounts in order to generate intercompany reports.
The intercompany code must be unique for this business relation.
tcBusinessRelationName1characterBusinessRelation.BusinessRelationName1Name: The full name of the business relation.
This field sets the default name for linked addresses such as customers and suppliers.
api annotation:PartialUpdate = yes - defaults to the BusinessRelationCode.
tcCreditorCodecharacterCreditor.CreditorCodeSupplier Code
tcpo_nbrcharacterpo_mstr.po_nbrPurchase Order
ttpo_ord_datedatepo_mstr.po_ord_dateOrder Date
tcpo_vendcharacterpo_mstr.po_vendSupplier
tcpo_currcharacterpo_mstr.po_currCurrency
tcpo_cr_termscharacterpo_mstr.po_cr_termsCredit Terms
tcpo_sitecharacterpo_mstr.po_siteSite
tcpo_shipcharacterpo_mstr.po_shipShip-To
tcpo_domaincharacterpo_mstr.po_domainDomain


Internal usage


QadFinancials
method BAPMatching.AdditionalUpdatesAllLinesPLAddPostingLine