project QadFinancials > class BDDocument > dataset BDDocument

class dataset

object identification

primary key
DDocument_ID
object identity
DDocument_ID

table tDDocument

Description

Customer-Document

field namedata typemnd.description
DDocument_IDintegeryesRecord ID
Company_IDintegeryesLink to Company
DCollection_IDintegernoLink to DCollection
Debtor_IDintegeryesCustomer
Currency_IDintegeryesCurrency Code
GL_IDintegeryesBank Account
CreationUsr_IDintegernoLogin
BankNumber_IDintegeryesLink to BankNumber
DPaySel_IDintegernoLink to DPaySel
DDocumentTypecharacter(20)yesPayment Instrument. The system displays the payment instrument associated with the payment format linked to the customer bank.
value list:{&PAYFORMATPAYINSTRUMENTS-AR}
DDocumentSubTypecharacter(20)yesSubtype. 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.
value list:{&DOCUMENTSUBTYPES}
DDocumentYearintegeryesYear/Number. This field displays the accounting year and payment sequence number, which is automatically generated by the accounting year.
DDocumentNumberintegeryesDocument Number. This field hold a unified number for report use.
DDocumentReferencecharacter(40)noReference. Reference text for the payment.
DDocumentOriginalCreditTCdecimal(4)noTC Original Credit. This field holds the debit value of the payment in transaction currency.
DDocumentOriginalCreditLCdecimal(4)noBC Original Credit.This field holds the amount of the Payment in baisc currency.
DDocumentOriginalCreditCCdecimal(4)noSC Original Credit. This field hold the amount of the payment in management currency.
DDocumentOriginalDebitTCdecimal(4)noAmount.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)noTC Original Debit. This field holds the debit value of the payment in base currency.
DDocumentOriginalDebitCCdecimal(4)noTC Original Debit. This field holds the debit value of the payment in management currency.
DDocumentIsOpenlogicalyesOpen. This field indicates if the payment is completely paid already.
DDocumentDueDatedatenoDue Date. The date on which the payment is receivable.
DDocumentStatuscharacter(20)noStatus. The payment status. The default value for a new record is Initial.
value list:{&DOCUMENTSTATUSDEBTORS}
DDocumentValueDaysintegeryesValue 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.
DDocumentCreationDatedateyesCreation Date.This field indicate the payment creation date.
This field is read-only.
DDocumentTimesPrintedintegeryesTimes Printed.This field indicates the number of times the payment has been printed.
This field is read-only.
DDocumentLastPrintDatedatenoLast Printed Date. This field indicates the most recent printing date.
DDocumentOriginalDebitBCdecimal(4)noBC Original Debit
DDocumentOriginalCreditBCdecimal(4)noBC Original Credit
DDocumentCreationTimeintegernoCreation Time. The time payment is created.
DDocumentIncassoSelectCodecharacter(20)noCustomer Payment Selection Code. This field displays the customer payment selection code.
This field is read-only.
DDocumentExchangeRatedecimal(10)noExchange Rate. This field holds the exchange rate applying to the transaction currency.
DDocumentRateScaledecimal(10)noScale Factor. This field indicates the scaling factor applying to the transaction currency.
DDocumentCCRatedecimal(10)noSC Rate. The statutory scaling factor applying to the transaction currency.
DDocumentCCScaledecimal(10)noSC Rate Scale. The statutory exchange rate used by the invoice.
DDocumentClosingDatedatenoClosing Date. The closing date of the payment.
DDocumentBankImpRefcharacter(255)noBank Importing Reference
DDocumentTransTpStatcharacter(20)noTransaction Type Status
tcBusinessRelationCodecharacter(20)noBusiness Relation.This field identifies the business relation associated with the customer.
tcBusinessRelationNamecharacter(36)noBusiness Relation Name.The business relation name associated with the customer.
tlInvoicesLinkedlogicalnoInvoices Linked. This field indicates if the payment is linked to an invoice.
ttPostingDatedatenoPosting Date. This field indicates the date the payment is posted.
tcPostingRowIdcharacter(40)noPosting Row ID
tcDebtorBankNumbercharacter(20)noCustomer Bank.The customer bank accosiated with the bank GL account.
tcPayFormatTypeCodecharacter(20)noPayment Format. This field identifies the payment format used by the payment.
tcPaymentLevelPayCodecharacter(20)noPayment level Code. This field identifies the Payment level formats used by the payment.
tcDebtorCodecharacter(8)yesCustomer. 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.
tcCurrencyCodecharacter(3)yesCurrency. 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.
tcGLCodecharacter(8)yesBank Account. The GL account of type bank receiving the payment. If you specify a customer first, the banking details default from the customer.
tcCreationUsrLogincharacter(20)noLogin. This field displays the login ID of the user who create the payment.
tcOwnBankNumbercharacter(20)noOwn 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.
tcPostingTextcharacternoValue of this field is used as posting and posting line description.
tcBusinessRelationSearchcharacter(28)no
tcExternalUniqueIdentifiercharacter(20)no
CustomShort0character(20)noCustom Short Field
CustomShort1character(20)noCustom Short Field
CustomShort2character(20)noCustom Short Field
CustomShort3character(20)noCustom Short Field
CustomShort4character(20)noCustom Short Field
CustomShort5character(20)noCustom Short Field
CustomShort6character(20)noCustom Short Field
CustomShort7character(20)noCustom Short Field
CustomShort8character(20)noCustom Short Field
CustomShort9character(20)noCustom Short Field
CustomCombo0character(20)noCustom Combo Field
CustomCombo1character(20)noCustom Combo Field
CustomCombo2character(20)noCustom Combo Field
CustomCombo3character(20)noCustom Combo Field
CustomCombo4character(20)noCustom Combo Field
CustomCombo5character(20)noCustom Combo Field
CustomCombo6character(20)noCustom Combo Field
CustomCombo7character(20)noCustom Combo Field
CustomCombo8character(20)noCustom Combo Field
CustomCombo9character(20)noCustom Combo Field
CustomLong0character(255)noCustom Long Field
CustomLong1character(255)noCustom Long Field
CustomNotecharacter(2000)noCustom Note Field
CustomDate0datenoCustom Date Field
CustomDate1datenoCustom Date Field
CustomDate2datenoCustom Date Field
CustomDate3datenoCustom Date Field
CustomDate4datenoCustom Date Field
CustomInteger0integernoCustom Integer Field
CustomInteger1integernoCustom Integer Field
CustomInteger2integernoCustom Integer Field
CustomInteger3integernoCustom Integer Field
CustomInteger4integernoCustom Integer Field
CustomDecimal0decimal(4)noCustom Decimal Field
CustomDecimal1decimal(4)noCustom Decimal Field
CustomDecimal2decimal(4)noCustom Decimal Field
CustomDecimal3decimal(4)noCustom Decimal Field
CustomDecimal4decimal(4)noCustom Decimal Field
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacternoempty string
tc_Statuscharacternoupdate status

table tDDocInvoiceXrefStage

Description

This table holds the information about the payment of the customer invoice in every stage.

field namedata typemnd.description
DDocInvoiceXrefStage_IDintegeryesRecord ID
DDocumentInvoiceXref_IDintegeryesLink to DDocumentInvoiceXref
DInvoiceStage_IDintegernoLink to DInvoiceStage
DDocument_IDintegernoLink to DDocument
DDocInvoiceXrefStageAlloTCdecimal(4)noStage TC Allocated. This field holds the payeent amount to be paid in the stage in transaction currency.
DDocInvoiceXrefStageDiscTCdecimal(4)noStage Discount. This field indicates the payment discount amount in this stage in transaction currency.
DDocInvoiceXrefStagePaidAmtTCdecimal(4)noTC Paid Amount
tdDefaultPaymentAmountTCdecimal(4)noTC Payment Amount. This field indicates the payment amount in this stage in transaction currency.
tdDefaultDiscountAmountTCdecimal(4)noTC Discount Amount
tdDefaultDiscountPercdecimal(2)noDefault Discount Percentage
tiDInvoice_IDintegeryes
ttDefaultDueDatedatenoStage Due Date
ttDefaultDiscDatedatenoStage discount date
tdDefaultAllocAmountTCdecimal(4)noDefault allocation amount
tlUIFullAllocationlogicalnoFull allocation of the staged payment
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tDDocumentInvoiceXref.tc_Rowid
tc_Statuscharacternoupdate status

table tDDocumentInvoiceXref

Description

This table holds the information about the customer invocie associated with the payment.
DDocumentInvoiceXRef

field namedata typemnd.description
DDocumentInvoiceXref_IDintegeryesRecord ID
DDocument_IDintegeryesLink to DDocument
DInvoice_IDintegernoLink to DInvoice
DDocumentInvoiceXrefAlloTCdecimal(4)yesTC Allocated Amount. This field indicates the invocie amount already Allocated in transaction currency.
DDocumentInvoiceXrefDiscTCdecimal(4)yesTC Discount Amount. This field indicates the discount amount of the invoice already allocated by transaction currency.
DDocumentInvoiceXrefIntTCdecimal(4)noTC Interest Amount
DDocumentInvoiceXrefPaidAmtTCdecimal(4)noTC Paid Amount
tcAllocAmountCrDtcharacter(2)noAllocateAmountCrDt. This field indicates that the payment is a credit or debit.
tcBusinessRelationCodecharacter(20)noBusiness Relation.The business relation code linked to the customer.
This field is calculated by the system using the customer code.
tcDInvoiceBalanceCrDtcharacter(2)noInvoice Balance DR/CR. This field indicates that the customer invocie is a credit or debit before the payment.
tcDInvoiceReferencecharacter(40)noReference. An alphanumeric reference to help identify the invoice in the system.
This reference is typically the ID number of the invoice received from the customer.
tcShipperCodecharacter(20)noShipper. A shipper number to select invoices related to a specific shipment. This field applies to automatically created salesrelated invoices.
tcDInvoiceTypecharacter(20)noInvoice Type. This field identifies the invoice type.
tcCompanyCodecharacter(20)noEntity Code. This field identifies the entity of the invocie.
tcCurrencyCodecharacter(20)noCurrency Code.This filed identifies the currency used by the customer invoice.
tcNewBalanceCrDtcharacter(2)noNew Invoice Balance DR/CR. This field indicates that the customer invocie is a credit or debit after the payment.
tdDInvoiceBalancedecimal(4)noInvoice Balance. This field holds the balance of the customer invoice before the payment.
tdDiscountPercentagedecimal(2)noDiscount Percentage. When the invoice is paid before the discount due date, this is the discount percentage that can be given.
tdNewBalancedecimal(4)noInvoice Balance. This field holds the balance of the customer invoice after the payment.
tlUIFullAllocationlogicalnoFull. This field indicates if the payment is already completely paid or not.
ttDInvoiceDatedatenoInvoice Date. This field indicates the invoice creation date.
ttDInvoiceDiscountDueDatedatenoDiscount Due Date.This field indicates the last date a discount applies, calculated by the system based on the credit terms and the invoice date.
ttDInvoiceDueDatedatenoDue Date.This field indicates the date when payment become due.
This field can be modified without affecting the credit terms.
This field is calculated by the system based on the credit terms and the invoice date.
tdDefaultDiscountAmountdecimal(4)noDefault discount Amount. This field holds the discount amount of the customer invoice calculated using the default discount rate.
tdDefaultPaymentAmountdecimal(4)noDefault payment Amount. The Default payment Amount of the invoice.
tcDebtorCodecharacter(20)noCustomer Code. The code that identifies the customer to be paid with this invoice.
This field is calculated by the system.
tcDivisionCodecharacter(20)noSub-Account Code. This field displays the code of sub-account if the customer control account is defined with sub-account analysis.
This sub-account applies to all invoice posting lines.
This field can be blank.
tdVatBaseTCdecimal(4)noif tdDInvoiceVatBaseDebitTC <> 0 =>tdDInvoiceVatBaseDebitTC
if tdDInvoiceVatBaseDebitTC = 0
=>tdDInvoiceVatBaseCreditTC
tdVatTCdecimal(4)noif tdDInvoiceVatDebitTC <> 0 => tdDInvoiceVatDebitTC if tdDInvoiceVatDebitTC = 0 => tdDInvoiceVatCreditTC
tcVatBaseCrDtcharacter(20)noVatBaseCrDt. This field indicates if the Tax base amount is a credit or debit.
tcVatCrDtcharacter(20)noTax CR/CR. This field indicates if the Tax amount of the customer invoice is a credit or debit.
tiDInvoicePostingIdintegernoInvoice Posting ID. This field hold the posting ID(s) which handle(s) the payment of the invoices.
tcVatCountryCodecharacter(20)noInvoice Tax Country Code. This field indicates the tax Country of the invoice.
tlDiscountTaxAtPaymentlogicalnoDiscount Tax at payment. This field holds the discount tax amount when the invoice is paid.
tcCostCentreCodecharacter(20)noCost Center Code. The cost center to which this invoice is to be posted.
tcProjectCodecharacter(20)noProject. The project to which this invoice is to be posted.
tcCorporateGroupCodecharacter(20)noGroup Name. This field indicates the group the corporation belongs to.
tcBusinessRelationName1characternoBusiness Relation Name.The business relation name associated with the customer.
tcDInvoiceDITextcharacter(32)noLegacy Invoice Number
tdDDocumentInvoiceXrefPaidTCdecimal(4)noObsolete field (replaced by CDocumentInvoiceXrefPayTC)
tdNonDiscAmtTCdecimal(4)noInvoice Non Discountable Amount. This field display the invoice amount without discount in transaction currency.
tdLCExchangeRatedecimal(10)noExchange Rate. The exchange rate used by the invoice.
tdLCExchangeRateScaledecimal(10)noScale Factor. This field indicates the scale factor applying to the exchange rate in use for foreign currency payments.
tdCCExchangeRatedecimal(10)noSC Rate. The statutory exchange rate used by the invoice.
tdCCExchangeRateScaledecimal(10)noScale Factor. This field indicates the scale factor applying to the SC rate in use for foreign currency payments.
tcDeductionCatCodecharacternoDeduction Catagory Code
tiDeductionCatLine_IDintegerno
tcDInvoiceDeductionStatuscharacterno
tdDeductionTCdecimal(2)no
tcDInvoiceDeductionParentRowIDcharacterno
tcDInoviceDeductionCusReferencecharacter(40)no
tcDInvoiceTSMNumbercharacternocontains the customer TSM Number
tiBillNumberintegerno
tcBillStatuscharacterno
tiBillYearintegerno
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tDDocument.tc_Rowid
tc_Statuscharacternoupdate status

table tDDocumentPostingLine

Description

This table holds the information about the posting line generated by the payment.

field namedata typemnd.description
DDocumentPostingLine_IDintegeryesRecord ID
DDocument_IDintegeryesLink to DDocument
PostingLine_IDintegeryesLink to PostingLine
DDocumentStatuscharacter(20)noCustomer Payment Status. This field indicats the customer payment status.
At a minimum, you must have two statuses: Paid and Void
value list:{&DOCUMENTSTATUSDEBTORS}
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tDDocument.tc_Rowid
tc_Statuscharacternoupdate status

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter