| field name | data type | description |
|---|
| APMatching_ID | integer | |
| Company_ID | integer | |
| CInvoice_ID | integer | |
| Reason_ID | integer | |
| Period_ID | integer | |
| Currency_ID | integer | |
| Journal_ID | integer | |
| Posting_ID | integer | |
| CirecPostingLine_ID | integer | |
| APMatchingTotalAmountTC | decimal(4) | |
| APMatchingTotalAmountLC | decimal(4) | |
| APMatchingARRecTaxTC | decimal(4) | |
| APMatchingARNRecTaxTC | decimal(4) | |
| APMatchingAIRecTaxTC | decimal(4) | |
| APMatchingAINRecTaxTC | decimal(4) | |
| APMatchingCInvoiceDiscPct | decimal(2) | |
| APMatchingStatus | character | |
| APMatchingDate | date | |
| APMatchingTaxEnv | character | |
| tcReasonCode | character | |
| tiPeriodYear | integer | |
| tiPeriodPeriod | integer | |
| tiPostingVoucher | integer | |
| tcCurrencyCode | character | |
| tcJournalCode | character | |
| tiCInvoicePostingYear | integer | |
| tiCInvoiceVoucher | integer | |
| tcCInvoiceJournalCode | character | |
| tcCreditorCode | character | |
| tiBusinessRelationID | integer | |
| tcBusinessRelationCode | character | |
| tdCInvoiceExchangeRate | decimal(10) | Rate between TC and LC at the moment of the invoice (type: accounting) |
| tdCInvoiceRateScale | decimal(10) | Scale between TC and LC at the moment of the invoice (type: accounting) |
| tdCInvoiceCCRate | decimal(10) | Rate between TC and SC at the moment of the invoice (type: Statutory - optional: accounting) |
| tdCInvoiceCCScale | decimal(10) | Scale between TC and SC at the moment of the invoice (type: Statutory - optional: accounting) |
| tdCInvoiceLCCCRate | decimal(10) | Rate between LC and SC at the moment of the invoice (type: Statutory - optional: accounting) |
| tdCInvoiceLCCCScale | decimal(10) | Scale between LC and SC at the moment of the invoice (type: Statutory - optional: accounting) |
| ttCInvoiceDate | date | |
| ttCInvoicePostingDate | date | Posting-date of the invoice |
| tcCInvoiceReference | character | |
| tcCInvoiceType | character | |
| ttCInvoiceTaxPointDate | date | |
| tcCInvoicePaymentConditionCode | character | |
| tlCInvoiceIsInitialStatus | logical | |
| tiCInvoiceRegistrationNr | integer | |
| tcCreditorAddrTaxIDFederal | character | |
| tcCreditorAddrTaxIDState | character | |
| tcCreditorAddrTaxIDMisc1 | character | |
| tcCreditorAddrTaxIDMisc2 | character | |
| tcCreditorAddrTaxIDMisc3 | character | |
| tlCreditorAddrIsTaxInCity | logical | |
| tlCreditorAddrIsEUCountry | logical | |
| tcCreditorAddrCountryCode | character | |
| tcShipToAddrTaxIDFederal | character | |
| tcShipToAddrTaxIDState | character | |
| tcShipToAddrTaxIDMisc1 | character | |
| tcShipToAddrTaxIDMisc2 | character | |
| tcShipToAddrTaxIDMisc3 | character | |
| tiShipToAddrTaxDeclaration | integer | |
| tlShipToAddrIsTaxInCity | logical | |
| tlShipToAddrIsEUCountry | logical | |
| tcShipToAddrCountryCode | character | |
| tcBusinessRelationICCode | character | |
| tlIsUpdateCInvoiceAutomatically | logical | This flag indicates, whether supplier invoice (total amount and taxes) should be updated automatically during save of receiver matching or not. |
| tlJournalAccessAllowed | logical | Used to determine whether a user has access to modify an ap matching |
| tiNormalPaymentCondition_ID | integer | |
| tiShipToAddress_ID | integer | |
| tiCreditorAddr_ID | integer | |
| CustomShort0 | character | |
| CustomShort1 | character | |
| CustomShort2 | character | |
| CustomShort3 | character | |
| CustomShort4 | character | |
| CustomShort5 | character | |
| CustomShort6 | character | |
| CustomShort7 | character | |
| CustomShort8 | character | |
| CustomShort9 | character | |
| CustomCombo0 | character | |
| CustomCombo1 | character | |
| CustomCombo2 | character | |
| CustomCombo3 | character | |
| CustomCombo4 | character | |
| CustomCombo5 | character | |
| CustomCombo6 | character | |
| CustomCombo7 | character | |
| CustomCombo8 | character | |
| CustomCombo9 | character | |
| CustomLong0 | character | |
| CustomLong1 | character | |
| CustomNote | character | |
| CustomDate0 | date | |
| CustomDate1 | date | |
| CustomDate2 | date | |
| CustomDate3 | date | |
| CustomDate4 | date | |
| CustomInteger0 | integer | |
| CustomInteger1 | integer | |
| CustomInteger2 | integer | |
| CustomInteger3 | integer | |
| CustomInteger4 | integer | |
| CustomDecimal0 | decimal(4) | |
| CustomDecimal1 | decimal(4) | |
| CustomDecimal2 | decimal(4) | |
| CustomDecimal3 | decimal(4) | |
| CustomDecimal4 | decimal(4) | |
| LastModifiedDate | date | |
| LastModifiedTime | integer | |
| LastModifiedUser | character | |
| 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 | |
QadFinancials