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 | |