business logic query CInvoiceMovementByType

Parameters

iiCompanyId	integer	Company id
iiCInvoiceId	integer
icCInvoiceMovementType	character

query condition

each CInvoiceMovement where

CInvoiceMovement.Company_Id = iiCompanyId AND
CInvoiceMovement.CInvoice_ID = iiCInvoiceId AND
CInvoiceMovement.CInvoiceMovementType = icCInvoiceMovementType

first PostingLine (inner-join) where

PostingLine.Company_Id = iiCompanyId AND
PostingLine.PostingLine_ID = CInvoiceMovement.PostingLine_ID AND

query resultset tqCInvoiceMovementByType

field name	data type	db field	description
tiCInvoice_ID	integer	CInvoiceMovement.CInvoice_ID	Link to CInvoice
tcCInvoiceMovementType	character	CInvoiceMovement.CInvoiceMovementType	CInvoiceMovementType. "Initial" indicates that the movement represents the initial creation of the invoice, "movement" stands for all subsequent modifications of the invoice balance (payments, adjustments etc).
tiPostingLine_ID	integer	PostingLine.PostingLine_ID	Record ID
tdPostingLineCreditTC	decimal	PostingLine.PostingLineCreditTC	TC Credit
tdPostingLineDebitTC	decimal	PostingLine.PostingLineDebitTC	TC Debit

Internal usage

QadFinancials

method BCInvoice.ReverseCInvoiceValidateStatus
method BCInvoice.ValidateComponentPost