business logic query DInvoicePostingByDIPostingID

Description

DInvoicePostingByDIPostingID: query that returns the debtor-code based on the posting_id in the debtorposting-table

iiPostingID	integer	PostingID: posting_id of table DInvoicePosting
iiDInvoiceID	integer	DInvoiceID: DInvoice_id of table DInvoicePosting
iiCompanyId	integer	Company id

each DInvoicePosting where

DInvoicePosting.DInvoice_ID = iiDInvoiceID AND
DInvoicePosting.Posting_ID = iiPostingID

first DInvoice (inner-join) where

DInvoice.Company_Id = iiCompanyId AND
DInvoice.DInvoice_ID = DInvoicePosting.DInvoice_ID AND

first Debtor (inner-join) where

Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor.Debtor_ID = DInvoice.Debtor_ID AND

field name	data type	db field	description
tiDInvoicePosting_ID	integer	DInvoicePosting.DInvoicePosting_ID	Record ID
tiDInvoice_ID	integer	DInvoicePosting.DInvoice_ID	Link to DInvoice
tiPosting_ID	integer	DInvoicePosting.Posting_ID	Link to Posting
tiCompany_ID	integer	DInvoice.Company_ID	Link to Company
tiDebtor_ID	integer	DInvoice.Debtor_ID	Link to Debtor
tcDebtorCode	character	Debtor.DebtorCode	A code (maximum eight characters) that identifies a customer. If the code you specify matches an existing supplier code, a warning message displays. You can choose to ignore the warning, and create the record. However, when a supplier and customer share the same code, they must reference the same business relation.
	api annotation:		If you leave the Customer Code field blank, the system automatically generates a number for the record based on the sequence defined in Customer Autonumber Create.

QadFinancials