| field name | data type | description |
|---|
| Creditor_ID | integer | |
| NormalPaymentCondition_ID | integer | |
| BusinessRelation_ID | integer | |
| CreditorIsActive | logical | |
| SharedSet_ID | integer | |
| InvControlGLProfile_ID | integer | |
| CnControlGLProfile_ID | integer | |
| DivisionProfile_ID | integer | |
| PurchaseCode_ID | integer | |
| Reason_ID | integer | |
| BLWIGroup_ID | integer | |
| DeliveryCond_ID | integer | |
| Currency_ID | integer | |
| PaymentGroup_ID | integer | |
| PurchaseGLProfile_ID | integer | |
| CreditorType_ID | integer | |
| PurchaseType_ID | integer | |
| PrePayControlGLProfile_ID | integer | |
| WHTCertFormat_ID | integer | |
| FinChgGLProfile_ID | integer | |
| CreditorCode | character | |
| VatDeliveryType | character | |
| VatPercentageLevel | character | |
| CreditorIsSendRemittance | logical | |
| CreditorIsIndividualPaymnt | logical | |
| CreditorIsTaxable | logical | |
| CreditorIsTaxInCity | logical | |
| CreditorIsTaxIncluded | logical | |
| CreditorTaxIDFederal | character | |
| CreditorTaxIDState | character | |
| CreditorTaxIDMisc1 | character | |
| CreditorTaxIDMisc2 | character | |
| CreditorTaxIDMisc3 | character | |
| CreditorTaxDeclaration | integer | |
| CreditorIsTaxReport | logical | |
| CreditorDBNumber | character | |
| CreditorCocNumber | character | |
| CreditorTIDNotice | character | |
| CreditorDebtorNumber | character | |
| CreditorIsTaxConfirmed | logical | |
| CreditorIsWHT | logical | |
| CreditorIsBearBankCharge | logical | |
| CreditorCommentNote | character | |
| CreditorTaxIDFiscalCode | character | |
| CreditorForeignFiscalCode | character | |
| CreditorBirthDate | date | |
| CreditorBirthCity | character | |
| TxzTaxZone | character | |
| TxclTaxCls | character | |
| TxuTaxUsage | character | |
| tcNormalPaymentConditionCode | character | |
| tcInvControlGLProfileCode | character | |
| tcCnControlGLProfileCode | character | |
| tcDivisionProfileCode | character | |
| tcReasonCode | character | |
| tcBLWIGroupCode | character | |
| tlBusinessRelationIsInterco | logical | |
| tcPaymentGroupCode | character | |
| tcBusinessRelationCode | character | |
| tcCurrencyCode | character | |
| tcCreditorTypeCode | character | |
| tcNormalPaymentConditionType | character | The value of PaymentConditionPaymentType field related to the NormalPaymentCondition |
| tcPurchaseGLProfileCode | character | |
| tcBusinessRelationName1 | character | |
| tcPurchaseTypeCode | character | |
| tcPrepayControlGLProfileCode | character | |
| tcWHTCertFormatCode | character | |
| 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) | |
| CustomShort10 | character | |
| CustomShort11 | character | |
| CustomShort12 | character | |
| CustomShort13 | character | |
| CustomShort14 | character | |
| CustomShort15 | character | |
| CustomShort16 | character | |
| CustomShort17 | character | |
| CustomShort18 | character | |
| CustomShort19 | character | |
| CustomCombo10 | character | |
| CustomCombo11 | character | |
| CustomCombo12 | character | |
| CustomCombo13 | character | |
| CustomCombo14 | character | |
| CustomDecimal5 | decimal(4) | |
| CustomDecimal6 | decimal(4) | |
| CustomDecimal7 | decimal(4) | |
| CustomDecimal8 | decimal(4) | |
| CustomDecimal9 | decimal(4) | |
| CustomDate5 | date | |
| CustomDate6 | date | |
| CustomDate7 | date | |
| CustomDate8 | date | |
| CustomDate9 | date | |
| 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