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

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

field name	data type	db field	description
tcBusinessRelationCode	character	BusinessRelation.BusinessRelationCode	Business 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.
tcBusinessRelationICCode	character	BusinessRelation.BusinessRelationICCode	Intercompany 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.
tcBusinessRelationName1	character	BusinessRelation.BusinessRelationName1	Name: 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.
tcCreditorCode	character	Creditor.CreditorCode	Supplier Code
tcpo_nbr	character	po_mstr.po_nbr	Purchase Order
ttpo_ord_date	date	po_mstr.po_ord_date	Order Date
tcpo_vend	character	po_mstr.po_vend	Supplier
tcpo_curr	character	po_mstr.po_curr	Currency
tcpo_cr_terms	character	po_mstr.po_cr_terms	Credit Terms
tcpo_site	character	po_mstr.po_site	Site
tcpo_ship	character	po_mstr.po_ship	Ship-To
tcpo_domain	character	po_mstr.po_domain	Domain

QadFinancials