field name | data type | description |
QDInvoiceMovement_ID | integer | |
DInvoiceMovementDebitLC | decimal(4) | |
DInvoiceMovementCreditLC | decimal(4) | |
DInvoiceMovementDebitTC | decimal(4) | |
DInvoiceMovementCreditTC | decimal(4) | |
DInvoiceMovementDebitCC | decimal(4) | |
DInvoiceMovementCreditCC | decimal(4) | |
DInvoiceMovementVatDebLC | decimal(4) | |
DInvoiceMovementVatCredLC | decimal(4) | |
DInvoiceMovementVatDebTC | decimal(4) | |
DInvoiceMovementVatCredTC | decimal(4) | |
DInvoiceMovementVatDebCC | decimal(4) | |
DInvoiceMovementVatCredCC | decimal(4) | |
DInvoiceMovementIsInvoice | logical | |
DInvoiceMovementIsCreditN | logical | |
DInvoiceMovementType | character | |
DInvoiceMovementInfo | character | |
MovementYearPeriod | integer | |
Company_ID | integer | |
Currency_ID | integer | |
Debtor_ID | integer | |
Period_ID | integer | |
GL_ID | integer | |
Division_ID | integer | |
Project_ID | integer | |
CostCentre_ID | integer | |
Journal_ID | integer | |
ttValidityDate | date | validity date |
tdExchangeRate | decimal(10) | |
tdExchangeRateScale | decimal(10) | ExchangeRateScale |
QADC01 | character | unused QAD reserved field |
QADC02 | character | unused QAD reserved field |
QADT01 | date | unused QAD reserved field |
QADD01 | decimal(10) | unused QAD reserved field |
tc_Rowid | character | |
tc_ParentRowid | character | |
tc_Status | character | |