project QadFinancials > class BCInvoice > business logic query CInvoiceMovementByType


Parameters


iiCompanyIdintegerCompany id
iiCInvoiceIdinteger
icCInvoiceMovementTypecharacter


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 namedata typedb fielddescription
tiCInvoice_IDintegerCInvoiceMovement.CInvoice_IDLink to CInvoice
tcCInvoiceMovementTypecharacterCInvoiceMovement.CInvoiceMovementTypeCInvoiceMovementType. "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_IDintegerPostingLine.PostingLine_IDRecord ID
tdPostingLineCreditTCdecimalPostingLine.PostingLineCreditTCTC Credit
tdPostingLineDebitTCdecimalPostingLine.PostingLineDebitTCTC Debit


Internal usage


QadFinancials
method BCInvoice.ReverseCInvoiceValidateStatus
method BCInvoice.ValidateComponentPost