business logic query CInvoicePOByCInvoicePO

Description

CInvoicePOByCInvoicePO: query that returns all fields of table CInvoicePO and that allows filtering on all fields

each CInvoicePO where

CInvoicePO.CInvoice_ID = iiCInvoiceID AND
CInvoicePO.CInvoicePOPoDomain = icPODomain AND
CInvoicePO.CInvoicePOPoNbr = icPONbr

field name	data type	db field	description
tiCInvoice_ID	integer	CInvoicePO.CInvoice_ID	Link to CInvoice
tiCInvoicePO_ID	integer	CInvoicePO.CInvoicePO_ID	Record ID
tcCInvoicePOPoDomain	character	CInvoicePO.CInvoicePOPoDomain	PO Domain. This field indicates which domain the purchase order belongs to.
tcCInvoicePOPoNbr	character	CInvoicePO.CInvoicePOPoNbr	PO Number. This fields identifies the PO receipts which the invoice matches.
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(CInvoicePO)

QadFinancials