project QadFinancials > class BBillReport > business logic query GetDInvoiceMovementByPostDate

Parameters


iiCompanyIdintegerCompany id
iiDInvoiceIdinteger
itPostDatedate

query condition


  each DInvoiceMovement where
DInvoiceMovement.Company_Id = iiCompanyId AND
DInvoiceMovement.DInvoice_ID = iiDInvoiceId AND
DInvoiceMovement.DInvoiceMovementPostDate > itPostDate

      first PostingLine (inner-join) where
PostingLine.Company_Id = iiCompanyId AND
PostingLine.PostingLine_ID = DInvoiceMovement.PostingLine_ID AND

query resultset tqGetDInvoiceMovementByPostDate


field namedata typedb fielddescription
tiDInvoiceMovement_IDintegerDInvoiceMovement.DInvoiceMovement_IDRecord ID
ttDInvoiceMovementPostDatedateDInvoiceMovement.DInvoiceMovementPostDatePosting Date. The Posting Date of the Invoice's movement.
tcDInvoiceMovementTypecharacterDInvoiceMovement.DInvoiceMovementTypeCInvoiceMovementType. "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).
ttPostingDatedatePostingLine.PostingDatePosting Date.
api annotation:If this field is blank, it gets a default value equal to the value of PostingDate in tPosting.
tiPostingLine_IDintegerPostingLine.PostingLine_IDRecord ID
tdPostingLineCreditTCdecimalPostingLine.PostingLineCreditTCTC Credit
tdPostingLineDebitTCdecimalPostingLine.PostingLineDebitTCTC Debit

Internal usage


QadFinancials
method BBillReport.CaculateBalanceOpenItems