project QadFinancials > class BMfgAddressListDetail > dataset tCreditorsToUpdate2

table tCreditorsToUpdate2

Description

temp-table with creditors that are added/changed/deleted

field namedata typedescription
Creditor_IDinteger
NormalPaymentCondition_IDinteger
BusinessRelation_IDinteger
CreditorIsActivelogical
SharedSet_IDinteger
InvControlGLProfile_IDinteger
CnControlGLProfile_IDinteger
DivisionProfile_IDinteger
PurchaseCode_IDinteger
Reason_IDinteger
BLWIGroup_IDinteger
DeliveryCond_IDinteger
Currency_IDinteger
PaymentGroup_IDinteger
PurchaseGLProfile_IDinteger
CreditorType_IDinteger
PurchaseType_IDinteger
PrePayControlGLProfile_IDinteger
WHTCertFormat_IDinteger
FinChgGLProfile_IDinteger
CreditorCodecharacter
VatDeliveryTypecharacter
VatPercentageLevelcharacter
CreditorIsSendRemittancelogical
CreditorIsIndividualPaymntlogical
CreditorIsTaxablelogical
CreditorIsTaxInCitylogical
CreditorIsTaxIncludedlogical
CreditorTaxIDFederalcharacter
CreditorTaxIDStatecharacter
CreditorTaxIDMisc1character
CreditorTaxIDMisc2character
CreditorTaxIDMisc3character
CreditorTaxDeclarationinteger
CreditorIsTaxReportlogical
CreditorDBNumbercharacter
CreditorCocNumbercharacter
CreditorTIDNoticecharacter
CreditorDebtorNumbercharacter
CreditorIsTaxConfirmedlogical
CreditorIsWHTlogical
CreditorIsBearBankChargelogical
CreditorCommentNotecharacter
CreditorTaxIDFiscalCodecharacter
CreditorForeignFiscalCodecharacter
CreditorBirthDatedate
CreditorBirthCitycharacter
TxzTaxZonecharacter
TxclTaxClscharacter
TxuTaxUsagecharacter
tcNormalPaymentConditionCodecharacter
tcInvControlGLProfileCodecharacter
tcCnControlGLProfileCodecharacter
tcDivisionProfileCodecharacter
tcReasonCodecharacter
tcBLWIGroupCodecharacter
tlBusinessRelationIsIntercological
tcPaymentGroupCodecharacter
tcBusinessRelationCodecharacter
tcCurrencyCodecharacter
tcCreditorTypeCodecharacter
tcNormalPaymentConditionTypecharacterThe value of PaymentConditionPaymentType field related to the NormalPaymentCondition
tcPurchaseGLProfileCodecharacter
tcBusinessRelationName1character
tcPurchaseTypeCodecharacter
tcPrepayControlGLProfileCodecharacter
tcWHTCertFormatCodecharacter
CustomShort0character
CustomShort1character
CustomShort2character
CustomShort3character
CustomShort4character
CustomShort5character
CustomShort6character
CustomShort7character
CustomShort8character
CustomShort9character
CustomCombo0character
CustomCombo1character
CustomCombo2character
CustomCombo3character
CustomCombo4character
CustomCombo5character
CustomCombo6character
CustomCombo7character
CustomCombo8character
CustomCombo9character
CustomLong0character
CustomLong1character
CustomNotecharacter
CustomDate0date
CustomDate1date
CustomDate2date
CustomDate3date
CustomDate4date
CustomInteger0integer
CustomInteger1integer
CustomInteger2integer
CustomInteger3integer
CustomInteger4integer
CustomDecimal0decimal(4)
CustomDecimal1decimal(4)
CustomDecimal2decimal(4)
CustomDecimal3decimal(4)
CustomDecimal4decimal(4)
CustomShort10character
CustomShort11character
CustomShort12character
CustomShort13character
CustomShort14character
CustomShort15character
CustomShort16character
CustomShort17character
CustomShort18character
CustomShort19character
CustomCombo10character
CustomCombo11character
CustomCombo12character
CustomCombo13character
CustomCombo14character
CustomDecimal5decimal(4)
CustomDecimal6decimal(4)
CustomDecimal7decimal(4)
CustomDecimal8decimal(4)
CustomDecimal9decimal(4)
CustomDate5date
CustomDate6date
CustomDate7date
CustomDate8date
CustomDate9date
LastModifiedDatedate
LastModifiedTimeinteger
LastModifiedUsercharacter
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 BMfgAddressListDetail.ApiReplicateFromFinancialsCreditor
method BMfgAddressListDetail.MaintainDataCreditor