project QadFinancials > class BDInvoice > dataset tDIDefault

table tDIDefault

Description

temp table with the input values of the DefaultValues method

field namedata typedescription
tcAddressTaxIdStatecharacterState Tax ID
tlCountryIsEUCountrylogicalIs the country an EU Country ?
tcCurrencyCodecharacterCurrency Code
tiCurrencyIdinteger
tcDAJournalCodecharacter
tcDebtorCodecharacterCustomer Code
tiDebtorIdintegerDebtor ID
tcDebtorVatNumbercharacterDebtor Vat Number
tiDebtorVatNumberIdintegerDebtor VAT Number ID
tcDebVatBusinessRelationCodecharacterBusiness Relation Code for Debtor Vat Number
tcDebVatCountryCodecharacterCountry Code of Debtor VAT Number
ttDInvoiceDatedateInvoice Date. This field indicates the invoice creation date.This field is normallly prior to the posting date and within the same accounting period as the posting date. The date must be within the upper and lower date limits of an open GL period.
The system uses the invoice date with the credit terms to calculate due date and discount date.
api annotation:This field defaults to the DInvoicePostingDate.
tcDInvoiceDescriptioncharacterDescirption of debtor invoice
tcDInvoiceDITextcharacterCI Text
ttDInvoiceDueDatedateDue Date
tdDInvoiceExchangeRatedecimal(10)Exchange Rate of Debtor Invoice
tdDInvoiceExchangeRateScaledecimal(10)
tiDInvoiceIdintegerDInvoice ID
tdDInvoiceManhourPercentagedecimal
tdDInvoiceOriginalLCdecimal(4)Invoice Amount in LC
tdDInvoiceOriginalTCdecimal(4)Invoice Amount in TC
ttDInvoicePostingDatedateposting date
ttDInvoiceTaxPointDatedatetax point date
tcDInvoiceTypecharacterInvoice Type. This field displays the invoice type.
Invoice Correction and Credit Note Correction display as choices only when the appropriate daybook types have already been defined.
api annotation:PartialUpdate = yes - defaults to Invoice
tcDiscountPaymentConditionCodecharacterDiscount Payment Condition Code
tiDiscountPaymentConditionIdintegerDiscount Payment Condition ID
tcDivisionCodecharacterSub-Account Code
tiDivisionIdintegerDivision ID
tcFieldNamecharacterField name of a ui field
tcFromTaxZonecharacterfrom Tax Zone
tcJournalCodecharacterDaybook Code
tiJournalIdintegerJournal ID
tiLinkedDInvoiceVoucherintegerLinked DInvoice Voucher
tcLinkedJournalCodecharacterLinked Daybook Code
tiLinkedPeriodYearintegerLinked Period Year
tcNormalPaymentConditionCodecharacterNormal Payment Condition Code
tiNormalPaymentConditionIdintegerNormal Payment Condition ID
tcOwnVatBusinessRelationCodecharacterOwn Vat BusinessRelation Code
tcOwnVatCountryCodecharacterOwn Vat Country Code
tcOwnVatCurrencyCodecharacter
tiOwnVatCurrencyIdinteger
tcOwnVatNumbercharacterOwn Vat Number
tiOwnVatNumberIdintegerOwn Vat Number ID
tiPeriodPeriodintegerGL Period
tiPeriodYearintegerPeriod Year
tcReasonCodecharacterReason Code
tiReasonIdintegerReason ID
tcToTaxZonecharacterTo Tax Zone
tcTransactionEndCountryCodecharacterTransaction End Country Code
tiTransactionEndCountryIdintegerTransaction End Country ID
tcTransactionStartCountryCodecharacterTransactionStartCountryCode
tiTransactionStartCountryIdintegerTransaction start country ID
tcTxclTaxClscharacterTax Class
tcVatCodecharacterTax Code
tdVatCurrencyExchangeRatedecimal
tiVatCurrencyNumDecinteger
tdVatCurrencyRateScaledecimal
tcCostCentreCodecharacter
tcProjectCodecharacter


Internal usage


QadFinancials
method BDInvoice.DefaultValuesDueDates
method BDInvoice.DefaultValuesValidate