project QadFinancials > class BDDocument > dataset tDDocToUpdate


copy of class table tDDocument

table tDDocToUpdate


field namedata typedescription
DDocument_IDinteger
Company_IDinteger
DCollection_IDinteger
Debtor_IDinteger
Currency_IDinteger
GL_IDinteger
CreationUsr_IDinteger
BankNumber_IDinteger
DPaySel_IDinteger
DDocumentTypecharacterPayment Instrument. The system displays the payment instrument associated with the payment format linked to the customer bank.
DDocumentSubTypecharacterSubtype. This read-only field indicates that the payment is manual or automatic. You create manual customer payments through the Customer Payment activities, and automatic payments through the Customer Payment Selections.
DDocumentYearintegerYear/Number. This field displays the accounting year and payment sequence number, which is automatically generated by the accounting year.
DDocumentNumberintegerDocument Number. This field hold a unified number for report use.
DDocumentReferencecharacterReference. Reference text for the payment.
DDocumentOriginalCreditTCdecimal(4)TC Original Credit. This field holds the debit value of the payment in transaction currency.
DDocumentOriginalCreditLCdecimal(4)BC Original Credit.This field holds the amount of the Payment in baisc currency.
DDocumentOriginalCreditCCdecimal(4)SC Original Credit. This field hold the amount of the payment in management currency.
DDocumentOriginalDebitTCdecimal(4)Amount.This field hold the value of the payment in the transaction currency. This field must be positive and can be entered manually or automatically by linking the payment to an open item.
DDocumentOriginalDebitLCdecimal(4)TC Original Debit. This field holds the debit value of the payment in base currency.
DDocumentOriginalDebitCCdecimal(4)TC Original Debit. This field holds the debit value of the payment in management currency.
DDocumentIsOpenlogicalOpen. This field indicates if the payment is completely paid already.
DDocumentDueDatedateDue Date. The date on which the payment is receivable.
DDocumentStatuscharacterStatus. The payment status. The default value for a new record is Initial.
DDocumentValueDaysintegerValue Days. A value for the number of days required by the bank to process the transaction. The default is based on the payment status entered.
DDocumentCreationDatedateCreation Date.This field indicate the payment creation date.
This field is read-only.
DDocumentTimesPrintedintegerTimes Printed.This field indicates the number of times the payment has been printed.
This field is read-only.
DDocumentLastPrintDatedateLast Printed Date. This field indicates the most recent printing date.
DDocumentOriginalDebitBCdecimal(4)
DDocumentOriginalCreditBCdecimal(4)
DDocumentCreationTimeintegerCreation Time. The time payment is created.
DDocumentIncassoSelectCodecharacterCustomer Payment Selection Code. This field displays the customer payment selection code.
This field is read-only.
DDocumentExchangeRatedecimal(10)Exchange Rate. This field holds the exchange rate applying to the transaction currency.
DDocumentRateScaledecimal(10)Scale Factor. This field indicates the scaling factor applying to the transaction currency.
DDocumentCCRatedecimal(10)SC Rate. The statutory scaling factor applying to the transaction currency.
DDocumentCCScaledecimal(10)SC Rate Scale. The statutory exchange rate used by the invoice.
DDocumentClosingDatedateClosing Date. The closing date of the payment.
DDocumentBankImpRefcharacter
DDocumentTransTpStatcharacter
tcBusinessRelationCodecharacterBusiness Relation.This field identifies the business relation associated with the customer.
tcBusinessRelationNamecharacterBusiness Relation Name.The business relation name associated with the customer.
tlInvoicesLinkedlogicalInvoices Linked. This field indicates if the payment is linked to an invoice.
ttPostingDatedatePosting Date. This field indicates the date the payment is posted.
tcPostingRowIdcharacter
tcDebtorBankNumbercharacterCustomer Bank.The customer bank accosiated with the bank GL account.
tcPayFormatTypeCodecharacterPayment Format. This field identifies the payment format used by the payment.
tcPaymentLevelPayCodecharacterPayment level Code. This field identifies the Payment level formats used by the payment.
tcDebtorCodecharacterCustomer. Specify the code that identifies the customer making a payment. The system loads the customers default bank information defined in the Banking tab of Customer Create. Most bank details default from the bank and cannot be modified.
tcCurrencyCodecharacterCurrency. This field identifies the currency of the payment.
The payment currency must be the same as that of the open item against which you allocate the payment. Currency information is contained in the payment format linked to your bank account, and you ensure that the currencies match by selecting the correct bank account.
tcGLCodecharacterBank Account. The GL account of type bank receiving the payment. If you specify a customer first, the banking details default from the customer.
tcCreationUsrLogincharacterLogin. This field displays the login ID of the user who create the payment.
tcOwnBankNumbercharacterOwn Bank Number. This field displays the account number that receives payments from this customer.
This number is defined on the customer record, and is normally the default bank account number for the entity you are currently working in.
tcPostingTextcharacterValue of this field is used as posting and posting line description.
tcBusinessRelationSearchcharacter
tcExternalUniqueIdentifiercharacter
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)
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 BDDocument.UpdateDDocument