dataset dcrCreditorWHTCertificate

table tqCreditorWHTCerditicateComp

field name	data type	description
tcCountryCode	character
tcCompanyDescription	character
tcCompanyCode	character
tcBusinessRelationName1	character	Name: The full name of the business relation. This field sets the default name for linked addresses such as customers and suppliers.
	api annotation:	PartialUpdate = yes - defaults to the BusinessRelationCode.
tcAddressZip	character	Zip. The postal code or US zip code associated with this address. This field is used to decide the tax zone for the address. This field can be blank.
tcAddressTelephone	character	Telephone. The telephone number for calling this business relation address. This field can be blank.
tcAddressTaxIDState	character	State Tax. This field is for reference and documentation purposes, the value of the field is either a state or provincial tax identification number or a VAT registration number.
tcAddressTaxIDMisc3	character	Miscellaneous Tax 3.This field is for reference and documentation purposes, its value can be any other tax identification numbers that are useful. This field can be blank.
tcAddressTaxIDMisc2	character	Miscellaneous Tax 2.This field is for reference and documentation purposes, its value can be any other tax identification numbers that are useful. This field can be blank.
tcAddressTaxIDMisc1	character	Miscellaneous Tax 1.This field is for reference and documentation purposes, its value can be any other tax identification numbers that are useful. This field can be blank.
tcAddressTaxIDFederal	character	Federal Tax. The value of this filed is the tax ID assigned to this address by the federal or national government. If Tax Report is true, the Federal tax ID must be unique; otherwise, related business relations can share an ID.
tcAddressStreet3	character	Address.Line three of address details. This field can be blank.
tcAddressStreet2	character	Address.Line two of address details. This field can be blank.
tcAddressStreet1	character	Address: Line one of address details. This field can be blank.
tcAddressState	character	Obsolete field
tcAddressFax	character	Fax. This field indicates the fax or telex number to use when sending documents to this address. This field can be balnk.
tcAddressCity	character	City. The city for this address. This field can be used to decide the tax zone of the address.
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date

table tqCreditorWHTCertificate

field name	data type	description
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
ti_Sequence	integer	Use this data item to add as a field in public temp-tables.
tdWHTAmt	decimal(4)
tdWHTFees	decimal(4)
tdWHTTax	decimal(4)
tdWHTTaxableFees	decimal(4)
tdWHTTotalPaid	decimal(4)
tdWHTExpenseAmt	decimal(4)
tdWHTInvoiceTotal	decimal(4)
tiWHTMonth	integer
tcCurrencyCodeFilter1	character
ttWHTPaymentDate	date
ttCreditorBirthDate	date
ttCInvoicePostingDate	date	Posting Date. This filed indicates the date on which the invoice is to be posted.
	api annotation:	This field defaults from the invoice creation date.
ttCInvoiceDate	date	Invoice Date. This field indicates the invoice creation date. The system uses this field with the credit terms to calculate due date and discount date.
	api annotation:	This field defaults from the system date.
tiWHT_ID	integer
tiJournal_ID	integer
tiCInvoiceVoucher	integer	Voucher. This field displays the numeric identifier assigned to the posting. When the daybook of the journal entry is changed (after transfer), the voucher is cleared. Voucher must be unique in one GL period. When the user input is zero, the system automatically assign a value not used yet for this field.
tiCInvoicePostingYearPeriod	integer	Year/Period. This field indicates the accounting year and period for the invoice. If you modify these fields, the posting and tax dates are changed correspondingly.
	api annotation:	This field defaults to the accounting year and period associated with the posting date.
tiCInvoicePostingYear	integer	Year.This field indicates the accounting year for the invoice. If you modify these fields, the posting and tax dates are changed correspondingly.
	api annotation:	This field defaults to the accounting year associated with the posting date.
tiCInvoicePostingPeriod	integer	GL Period.This field indicates the period when the invoice to be posted. If this field is modified, the posting and tax dates are changed correspondingly.
	api annotation:	This field defaults to the period associated with the posting date.
tiCInvoiceCurrency_ID	integer
tiCInvoice_ID	integer
tdWHTVATAmtDebitTC	decimal(4)
tdWHTVATAmtDebitLC	decimal(4)
tdWHTVATAmtDebitCC	decimal(4)
tdWHTVATAmtCreditTC	decimal(4)
tdWHTVATAmtCreditLC	decimal(4)
tdWHTVATAmtCreditCC	decimal(4)
tdWHTTotAmtDebitTC	decimal(4)
tdWHTTotAmtDebitLC	decimal(4)
tdWHTTotAmtDebitCC	decimal(4)
tdWHTTotAmtCreditTC	decimal(4)
tdWHTTotAmtCreditLC	decimal(4)
tdWHTTotAmtCreditCC	decimal(4)
tdWHTTaxableFeesDebitTC	decimal(4)
tdWHTTaxableFeesDebitLC	decimal(4)
tdWHTTaxableFeesDebitCC	decimal(4)
tdWHTTaxableFeesCreditTC	decimal(4)
tdWHTTaxableFeesCreditLC	decimal(4)
tdWHTTaxableFeesCreditCC	decimal(4)
tdWHTRetainedAmtDebitTC	decimal(4)
tdWHTRetainedAmtDebitLC	decimal(4)
tdWHTRetainedAmtDebitCC	decimal(4)
tdWHTRetainedAmtCreditTC	decimal(4)
tdWHTRetainedAmtCreditLC	decimal(4)
tdWHTRetainedAmtCreditCC	decimal(4)
tdWHTPercentage	decimal(2)
tdWHTPaidAmtDebitTC	decimal(4)
tdWHTPaidAmtDebitLC	decimal(4)
tdWHTPaidAmtDebitCC	decimal(4)
tdWHTPaidAmtCreditTC	decimal(4)
tdWHTPaidAmtCreditLC	decimal(4)
tdWHTPaidAmtCreditCC	decimal(4)
tdWHTChargeAmtDebitTC	decimal(4)
tdWHTChargeAmtCreditTC	decimal(4)
tdWHTAmtDebitTC	decimal(4)
tdWHTAmtDebitLC	decimal(4)
tdWHTAmtDebitCC	decimal(4)
tdWHTAmtCreditTC	decimal(4)
tdWHTAmtCreditLC	decimal(4)
tdWHTAmtCreditCC	decimal(4)
tdCInvoiceOriginalDebitTC	decimal(4)	TC AP Amount. This field displays the debit total invoice amount in the transaction currency. If you modify this field, the system automatically recalculates the exchange rate to ensure that the TC Invoice Amount remains the same.
tdCInvoiceOriginalDebitLC	decimal(4)	BC Invoice Amount(DR). This field displays the debit total invoice amount in the base currency. This field is calculated by the system using the TC Invoice Amount(DR) and the Exchange rate.
tdCInvoiceOriginalDebitCC	decimal(4)	SC Invoice Amount (DR). This field displays the debit total invoice amount in the statutory currency. This field is calculated by the system using the TC Invoice Amount(CR) and the SC Rate.
tdCInvoiceOriginalCreditTC	decimal(4)	TC Invoice Amount CR. This field displays the credit total invoice amount in the transaction currency. If you modify this field, the system automatically recalculates the exchange rate to ensure that the BC Invoice Amount remains the same.
tdCInvoiceOriginalCreditLC	decimal(4)	BC Invoice Amount(CR). This field displays the credit total invoice amount in the base currency. This field is calculated by the system using the TC Invoice Amount(CR) and the Exchange rate.
tdCInvoiceOriginalCreditCC	decimal(4)	SC Invoice Amount (CR). This field displays the credit total invoice amount in the statutory currency. This field is calculated by the system using the TC Invoice Amount(CR) and the SC Rate.
tcWHTPaymentReference	character
tcWHTChargeType	character
tcVatDescription	character
tcVatCode	character
tctx2_tax_code	character
tctx2_group	character
tcJournalCode	character	A daybook code (maximum eight characters).
tcCreditorTaxIDFiscalCode	character
tcCreditorForeignFiscalCode	character
tcCreditorCode	character
tcCreditorBirthCity	character
tcCountryCode	character
tcCInvoiceReference	character	Reference. An alphanumeric reference to help identify the invoice in the system. This reference is typically the ID number of the invoice received from the supplier.
tcBusinessRelationName1	character	Name: The full name of the business relation. This field sets the default name for linked addresses such as customers and suppliers.
	api annotation:	PartialUpdate = yes - defaults to the BusinessRelationCode.
tcAddressZip	character	Zip. The postal code or US zip code associated with this address. This field is used to decide the tax zone for the address. This field can be blank.
tcAddressStreet3	character	Address.Line three of address details. This field can be blank.
tcAddressStreet2	character	Address.Line two of address details. This field can be blank.
tcAddressStreet1	character	Address: Line one of address details. This field can be blank.
tcAddressState	character	Obsolete field
tcAddressCounty	character	Obsolete field
tcAddressCity	character	City. The city for this address. This field can be used to decide the tax zone of the address.
tcPaySelCode	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCDocument_ID	integer

table tqCreditorWHTCertificateByPay

field name	data type	description
ttWHTPaymentDate	date
ttCDocumentCreationDate	date	Creation Date.This field indicate the payment creation date. This field is read-only.
tiWHTNumber	integer
tiCDocumentYear	integer	Year/Number. This field displays the accounting year and payment sequence number, which is automatically generated by the accounting year.
tiCDocumentPrePrintedNumber	integer	Preprinted Number.This field is used to define a number or range of numbers when you are reprinting the payment.
tiCDocumentNumber	integer	Document Number. This field hold a unified number for report use.
tdWHTPercentage	decimal(2)
tdCDocumentInvoiceXrefDiscTC	decimal(4)	TC Discount Amount. This field indicates the discount amount of the invoice already allocated by transaction currency.
tdCDocumentInvoiceXrefAlloTC	decimal(4)	TC Allocated Amount. This field indicates the invocie amount already Allocated in transaction currency.
tcWHTCertFormatCode	character
tcVatCode	character
tcPayFormatTypeCode	character
tcCreditorCode	character
tcCDocumentReference	character	Reference. Reference text for the payment.
tcBankNumber	character
tdWHTTaxableFees	decimal(4)
tdWHTAmt	decimal(4)
tdAmountPaid	decimal
tdDeductions	decimal
tdCheckAmount	decimal
tdDiscount	decimal
tcWHTPaymentReference	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCDocument_ID	integer

table tqFilter

field name	data type	description
ti_Sequence	integer	Use this data item to add as a field in public temp-tables.
tcBusinessFieldLabel	character
tcBusinessFieldName	character	BusinessFieldName
tcOperator	character	Operator
tcParameterValue	character	ParameterValue

table tqHeader

field name	data type	description
tcCompanyCode	character
tcCurrLC	character
tcDateFormat	character
tiDecCC	integer
tcDecimalFormat	character
tiDecLC	integer
tcDecTC	character
tiDocLayoutMode	integer
tcExtraInfo	character
tiFilterMode	integer
tiPageBreakMode	integer
tcReportTitle	character
tiSummaryMode	integer
tcUser	character
tcDomainCode	character
tcCompanyDescription	character
tcUserLogin	character	Current User login ID
tlShadeAltLines	logical

table tqText

field name	data type	description
tcCode	character
tcText	character

Internal usage

QadFinancials

method BCreditorReport.CreditorWHTCertificate