project QadFinancials > class BCreditorBalance > dataset tCredBalQCInvoiceMovement

table tCredBalQCInvoiceMovement

Description

Temp-table to store the deleted QCInvoiceMovements.
Used in UpdateCBalanceAndCHist to pass the QCInvoiceMovement-records that were deleted in BQCInvoiceMovement.

field namedata typedescription
QCInvoiceMovement_IDinteger
CInvoiceMovementDebitLCdecimal(4)
CInvoiceMovementCreditLCdecimal(4)
CInvoiceMovementDebitTCdecimal(4)
CInvoiceMovementCreditTCdecimal(4)
CInvoiceMovementDebitCCdecimal(4)
CInvoiceMovementCreditCCdecimal(4)
CInvoiceMovementVatDebLCdecimal(4)
CInvoiceMovementVatCredLCdecimal(4)
CInvoiceMovementVatDebTCdecimal(4)
CInvoiceMovementVatCredTCdecimal(4)
CInvoiceMovementVatDebCCdecimal(4)
CInvoiceMovementVatCredCCdecimal(4)
CInvoiceMovementIsInvoicelogical
CInvoiceMovementIsCreditNlogical
CInvoiceMovementTypecharacter
CInvoiceMovementInfocharacter
MovementYearPeriodinteger
Company_IDinteger
Creditor_IDinteger
Currency_IDinteger
Period_IDinteger
GL_IDinteger
Division_IDinteger
Project_IDinteger
CostCentre_IDinteger
Journal_IDinteger
ttValidityDatedatevalidity date
tdExchangeRatedecimal(10)
tdExchangeRateScaledecimal(10)ExchangeRateScale
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter


Internal usage


QadFinancials
method BCreditorBalance.UpdateCBalanceAndCHist