project QadFinancials > class BCInvoice > API query CInvoiceByAllInfo

Description

This query lists all CInvoice records based on creditor invoice id.


query filter (table tFilter)


tcBusinessFieldNametcDataTypetcOperator
iiCompanyIdi
iiCInvoice_IDi=
tCInvoice.CInvoiceAllocationStatusc=,>=,>,<>,<=,<,begins,can-do,matches
tCInvoice.CInvoiceBalanceCCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceBalanceCreditCCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceBalanceCreditLCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceBalanceCreditTCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceBalanceDebitCCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceBalanceDebitLCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceBalanceDebitTCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceBalanceLCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceBalanceTCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceCirecClosingDatet=,>=,>,<>,<=,<
tCInvoice.CInvoiceCITextc=,>=,>,<>,<=,<,begins,can-do,matches
tCInvoice.CInvoiceClosingDatet=,>=,>,<>,<=,<
tCInvoice.CInvoiceContactc=,>=,>,<>,<=,<,begins,can-do,matches
tCInvoice.CInvoiceDatet=,>=,>,<>,<=,<
tCInvoice.CInvoiceDescriptionc=,>=,>,<>,<=,<,begins,can-do,matches
tCInvoice.CInvoiceDiscountDueDatet=,>=,>,<>,<=,<
tCInvoice.CInvoiceDueDatet=,>=,>,<>,<=,<
tCInvoice.CInvoiceExchangeRated=,>=,>,<>,<=,<
tCInvoice.CInvoiceHoldAmountTCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceIsInvoiceApprovedl=,<>
tCInvoice.CInvoiceIsLockPaymentl=,<>
tCInvoice.CInvoiceIsLogisticMatchingl=,<>
tCInvoice.CInvoiceIsOpenl=,<>
tCInvoice.CInvoiceIsSelectedl=,<>
tCInvoice.CInvoiceIsTaxablel=,<>
tCInvoice.CInvoiceIsVatDelayl=,<>
tCInvoice.CInvoiceIsWHTl=,<>
tCInvoice.CInvoiceMFTextc=,>=,>,<>,<=,<,begins,can-do,matches
tCInvoice.CInvoiceOriginalCreditCCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceOriginalCreditLCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceOriginalCreditTCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceOriginalDebitCCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceOriginalDebitLCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceOriginalDebitTCd=,>=,>,<>,<=,<
tCInvoice.CInvoicePostingDatet=,>=,>,<>,<=,<
tCInvoice.CInvoicePostingPeriodi=,>=,>,<>,<=,<
tCInvoice.CInvoicePostingYeari=,>=,>,<>,<=,<
tCInvoice.CInvoicePostingYearPeriodi=,>=,>,<>,<=,<
tCInvoice.CInvoiceRateScaled=,>=,>,<>,<=,<
tCInvoice.CInvoiceReferencec=,>=,>,<>,<=,<,begins,can-do,matches
tCInvoice.CInvoiceTaxPointDatet=,>=,>,<>,<=,<
tCInvoice.CInvoiceTSMNumberc=,>=,>,<>,<=,<,begins,can-do,matches
tCInvoice.CInvoiceTypec=,>=,>,<>,<=,<,begins,can-do,matches
tCInvoice.CInvoiceVatBaseCreditCCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceVatBaseCreditLCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceVatBaseCreditTCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceVatBaseDebitCCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceVatBaseDebitLCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceVatBaseDebitTCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceVatCreditCCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceVatCreditLCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceVatCreditTCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceVatDebitCCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceVatDebitLCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceVatDebitTCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceVatExchangeRated=,>=,>,<>,<=,<
tCInvoice.CInvoiceVatRateScaled=,>=,>,<>,<=,<
tCInvoice.CInvoiceVoucheri=,>=,>,<>,<=,<
tCInvoice.CInvoiceWHTBaseAmtCreditCCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceWHTBaseAmtCreditLCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceWHTBaseAmtCreditTCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceWHTBaseAmtDebitCCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceWHTBaseAmtDebitLCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceWHTBaseAmtDebitTCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceWHTTotAmtCreditCCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceWHTTotAmtCreditLCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceWHTTotAmtCreditTCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceWHTTotAmtDebitCCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceWHTTotAmtDebitLCd=,>=,>,<>,<=,<
tCInvoice.CInvoiceWHTTotAmtDebitTCd=,>=,>,<>,<=,<
tCInvoice.LastModifiedDatet=,>=,>,<>,<=,<
tCInvoice.LastModifiedTimei=,>=,>,<>,<=,<
tCInvoice.LastModifiedUserc=,>=,>,<>,<=,<,begins,can-do,matches


Parameters (internal)


iiCompanyIdintegerCompany id
iiCInvoice_IDintegerInvoice ID


query condition


  each CInvoice where
CInvoice.Company_Id = iiCompanyId AND
CInvoice.CInvoice_ID = iiCInvoice_ID


query resultset tqCInvoiceByAllInfo


field namedata typedb fielddescription
tiBLWIGroup_IDintegerCInvoice.BLWIGroup_IDBLWI Group Code
tiCInvoice_IDintegerCInvoice.CInvoice_IDRecord ID
tcCInvoiceAllocationStatuscharacterCInvoice.CInvoiceAllocationStatusAllocation Status.This field indicates whether postings occur and if they affect transient or official layers.
User can not delete an invoice which has a non-initial invoice status code.
tdCInvoiceBalanceCCdecimalCInvoice.CInvoiceBalanceCCSC Balance. This field displays the sum of the debit and credit amounts of all posting lines in statutory currency.
This field is calculated by the system using the TC Balance and the SC rate.
tdCInvoiceBalanceCreditCCdecimalCInvoice.CInvoiceBalanceCreditCCBC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency.
This field is calculated by the system using the TC Base Amount CR and the SC rate.
tdCInvoiceBalanceCreditLCdecimalCInvoice.CInvoiceBalanceCreditLCBC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency.
This field is calculated by the system using the TC Base Amount CR and the Exchange rate.
tdCInvoiceBalanceCreditTCdecimalCInvoice.CInvoiceBalanceCreditTCTC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency.
tdCInvoiceBalanceDebitCCdecimalCInvoice.CInvoiceBalanceDebitCCSC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in statutory currency.
This field is calculated by the system using the TC Base Amount DR and the SC rate.
tdCInvoiceBalanceDebitLCdecimalCInvoice.CInvoiceBalanceDebitLCBC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in transaction currency.
This field is calculated by the system using the TC Base Amount DR and the Exchange rate.
tdCInvoiceBalanceDebitTCdecimalCInvoice.CInvoiceBalanceDebitTCTC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in transaction currency.
tdCInvoiceBalanceLCdecimalCInvoice.CInvoiceBalanceLCBC Balance. This field displays the sum of the debit and credit amounts of all posting lines in base currency.
This field is calculated by the system using the TC Balance and the Exchange rate.
tdCInvoiceBalanceTCdecimalCInvoice.CInvoiceBalanceTCBalance. This field displays the sum of the debit and credit amounts of all posting lines in transaction currency.
ttCInvoiceCirecClosingDatedateCInvoice.CInvoiceCirecClosingDateSIREC Closing Date.This field displays the date on which the Unallocated Invoices account has been backed out for this invoice.
tcCInvoiceCITextcharacterCInvoice.CInvoiceCITextCIDescription. A brief description for the SI posting.
api annotation:This field defaults from the CInvoiceDescription.
ttCInvoiceClosingDatedateCInvoice.CInvoiceClosingDateClosing Date. This field displays the date on which the open balance became zero.
tcCInvoiceContactcharacterCInvoice.CInvoiceContactContact. This field indicates the name of the purchasing contact in the supplier company.
api annotation:This field defaults from the Contact field of the invoice's supplier.
tiCInvoiceCurrency_IDintegerCInvoice.CInvoiceCurrency_IDCurrency Code
ttCInvoiceDatedateCInvoice.CInvoiceDateInvoice 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.
tcCInvoiceDescriptioncharacterCInvoice.CInvoiceDescriptionDescription. A brief description of the invoice. The system generates a default description based on the Reference and Supplier Code.
ttCInvoiceDiscountDueDatedateCInvoice.CInvoiceDiscountDueDateDiscount Due Date.This field indicates the last date a discount applies, calculated by the system based on the credit terms and the invoice date.
User can modify this field without affecting the credit terms.
ttCInvoiceDueDatedateCInvoice.CInvoiceDueDateDue 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.
tdCInvoiceExchangeRatedecimalCInvoice.CInvoiceExchangeRateExchange Rate. The exchange rate used by the invoice.
The BC Invoice Amount is calculated based on the exchange rate.
If user modify the TC Invoice Amount, the BC invoice amount is automatically adjusted.
tdCInvoiceHoldAmountTCdecimalCInvoice.CInvoiceHoldAmountTCTC Hold Amount. This field displays the amount of the invoice total that is not to be paid.
If this field is not blank, the hold amount is taken into account during payment processing.
Hold amounts must be:
For invoices or correction invoices: Less than the invoice total and greater than zero.
For credit notes or correction credit notes: Greater than the document total and less than zero.
The hold amount for a negative payment must always be set to zero.
tlCInvoiceIsInvoiceApprovedlogicalCInvoice.CInvoiceIsInvoiceApprovedInvoice Approved. This field indicates if the invoice is already approved for payment.
api annotation:PartialUpdate = yes - defaults to false
tlCInvoiceIsLockPaymentlogicalCInvoice.CInvoiceIsLockPaymentLock Payment. This field indicates if the invoice is locked for payment. The invoice cannot be included in any automatic payment selections if this field is true.
api annotation:PartialUpdate = yes - defaults to false
tlCInvoiceIsLogisticMatchinglogicalCInvoice.CInvoiceIsLogisticMatchingReceiver Matching.This field indicates If the Receiver Matching function is enabled.
This field is calculated by the system using the invoice status code.
tlCInvoiceIsOpenlogicalCInvoice.CInvoiceIsOpenOpen.This field indicates if the invoice has been completely paid.
This field is updated automatically when complete payment is confirmed.
This field is read-only.
api annotation:PartialUpdate = yes - defaults to true
tlCInvoiceIsSelectedlogicalCInvoice.CInvoiceIsSelectedSelected. This field indicates whether the invoice is included in a payment selection.
This field is read-only.
tlCInvoiceIsTaxablelogicalCInvoice.CInvoiceIsTaxableTaxable. This field indicates if the invoice is taxable.
This field defaults to true if the supplier is taxable.
tlCInvoiceIsVatDelaylogicalCInvoice.CInvoiceIsVatDelayTax Delay. This field indicates if the Taxes on purchase orders and supplier invoices or credit notes are delayed.
tlCInvoiceIsWHTlogicalCInvoice.CInvoiceIsWHTWithholding Tax
tcCInvoiceMFTextcharacterCInvoice.CInvoiceMFTextMFDescription. A brief description for the Matching posting.
api annotation:This field defaults from the CInvoiceDescription.
tdCInvoiceOriginalCreditCCdecimalCInvoice.CInvoiceOriginalCreditCCSC 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.
tdCInvoiceOriginalCreditLCdecimalCInvoice.CInvoiceOriginalCreditLCBC 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.
tdCInvoiceOriginalCreditTCdecimalCInvoice.CInvoiceOriginalCreditTCTC 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.
tdCInvoiceOriginalDebitCCdecimalCInvoice.CInvoiceOriginalDebitCCSC 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.
tdCInvoiceOriginalDebitLCdecimalCInvoice.CInvoiceOriginalDebitLCBC 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.
tdCInvoiceOriginalDebitTCdecimalCInvoice.CInvoiceOriginalDebitTCTC 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.
ttCInvoicePostingDatedateCInvoice.CInvoicePostingDatePosting Date. This filed indicates the date on which the invoice is to be posted.
api annotation:This field defaults from the invoice creation date.
tiCInvoicePostingPeriodintegerCInvoice.CInvoicePostingPeriodGL 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.
tiCInvoicePostingYearintegerCInvoice.CInvoicePostingYearYear.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.
tiCInvoicePostingYearPeriodintegerCInvoice.CInvoicePostingYearPeriodYear/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.
tdCInvoiceRateScaledecimalCInvoice.CInvoiceRateScaleScale Factor. This field indicates the scale factor applying to the exchange rate in use for foreign currency payments.
tcCInvoiceReferencecharacterCInvoice.CInvoiceReferenceReference. 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.
ttCInvoiceTaxPointDatedateCInvoice.CInvoiceTaxPointDateTax Point Date.This field indicates the date to be used in tax calculations.
api annotation:This field defaults from the posting date.
tcCInvoiceTSMNumbercharacterCInvoice.CInvoiceTSMNumberPayment Reference. This field displays a unique reference number to be included in the supplier payment file.
This reference can consist of a Transfer with Structured Message (TSM) number.
This field can be blank.
tcCInvoiceTypecharacterCInvoice.CInvoiceTypeInvoice Type. This field identifies the invoice type.
The value can be Invoice Correction and Credit Note Correction type only when the appropriate daybook types have already been defined.
tdCInvoiceVatBaseCreditCCdecimalCInvoice.CInvoiceVatBaseCreditCCSC Base Amount CR. This field displays the credit base amount in the statutory currency.
This field is calculated by the system using the TC Base Amount CR and the SC rate.
tdCInvoiceVatBaseCreditLCdecimalCInvoice.CInvoiceVatBaseCreditLCBC Base Amount CR. This field displays the credit base amount in the base currency.
This field is calculated by the system using the TC Base Amount CR and the Exchange rate.
tdCInvoiceVatBaseCreditTCdecimalCInvoice.CInvoiceVatBaseCreditTCTC Base Amount CR. This field displays the credit base amount in the transaction currency.
This field is calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
tdCInvoiceVatBaseDebitCCdecimalCInvoice.CInvoiceVatBaseDebitCCSC Base Amount DR. This field displays the debit base amount in the statutory currency.
This field is calculated by the system using the TC Base Amount DR and the SC rate.
tdCInvoiceVatBaseDebitLCdecimalCInvoice.CInvoiceVatBaseDebitLCBC Base Amount DR. This field displays the debit base amount in the base currency.
This field is calculated by the system using the TC Base Amount DR and the Exchange rate.
tdCInvoiceVatBaseDebitTCdecimalCInvoice.CInvoiceVatBaseDebitTCTC Base Amount DR. This field displays the debit base amount in the transaction currency.
This field is calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
tdCInvoiceVatCreditCCdecimalCInvoice.CInvoiceVatCreditCCSC Tax Amount CR. This field displays the credit tax amount in the statutory currency.
This field is calculated by the system using the TC Tax Amount CR and the SC rate.
tdCInvoiceVatCreditLCdecimalCInvoice.CInvoiceVatCreditLCBC Tax Amount CR. This field displays the debit tax amount in the base currency.
This field is calculated by the system using the TC Tax Amount CR and the Exchange rate.
tdCInvoiceVatCreditTCdecimalCInvoice.CInvoiceVatCreditTCTC Tax Amount CR. This field displays the credit tax amount (TC) calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
tdCInvoiceVatDebitCCdecimalCInvoice.CInvoiceVatDebitCCBC Tax Amount DR. This field displays the debit tax amount in the statutory currency.
This field is calculated by the system using the TC Tax Amount DR and the SC rate.
tdCInvoiceVatDebitLCdecimalCInvoice.CInvoiceVatDebitLCBC Tax Amount DR. This field displays the debit tax amount in the base currency.
This field is calculated by the system using the TC Tax Amount DR and the Exchange rate.
tdCInvoiceVatDebitTCdecimalCInvoice.CInvoiceVatDebitTCTC Tax Amount DR. This field displays the debit tax amount (TC) calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
tdCInvoiceVatExchangeRatedecimalCInvoice.CInvoiceVatExchangeRateTax Exchange Rate. The exchange rate used to calculate the tax of the invoice.
The BC Tax amount is calculated using the Tax exchange rate.
tdCInvoiceVatRateScaledecimalCInvoice.CInvoiceVatRateScaleTax Rate Scale. This field indicates the scale factor applying to the tax exchange rate in use for foreign currency payments.
tiCInvoiceVoucherintegerCInvoice.CInvoiceVoucherVoucher. 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.
tdCInvoiceWHTBaseAmtCreditCCdecimalCInvoice.CInvoiceWHTBaseAmtCreditCCSC WHT Base Amount (CR)
tdCInvoiceWHTBaseAmtCreditLCdecimalCInvoice.CInvoiceWHTBaseAmtCreditLCBC WHT Base Amount (CR)
tdCInvoiceWHTBaseAmtCreditTCdecimalCInvoice.CInvoiceWHTBaseAmtCreditTCTC WHT Base Amount (CR)
tdCInvoiceWHTBaseAmtDebitCCdecimalCInvoice.CInvoiceWHTBaseAmtDebitCCSC WHT Base Amount (DR)
tdCInvoiceWHTBaseAmtDebitLCdecimalCInvoice.CInvoiceWHTBaseAmtDebitLCBC WHT Base Amount (DR)
tdCInvoiceWHTBaseAmtDebitTCdecimalCInvoice.CInvoiceWHTBaseAmtDebitTCTC WHT Base Amount (DR)
tdCInvoiceWHTTotAmtCreditCCdecimalCInvoice.CInvoiceWHTTotAmtCreditCCSC WHT Total Amount (CR)
tdCInvoiceWHTTotAmtCreditLCdecimalCInvoice.CInvoiceWHTTotAmtCreditLCBC WHT Total Amount (CR)
tdCInvoiceWHTTotAmtCreditTCdecimalCInvoice.CInvoiceWHTTotAmtCreditTCTC WHT Total Amount (CR)
tdCInvoiceWHTTotAmtDebitCCdecimalCInvoice.CInvoiceWHTTotAmtDebitCCSC WHT Total Amount (DR)
tdCInvoiceWHTTotAmtDebitLCdecimalCInvoice.CInvoiceWHTTotAmtDebitLCBC WHT Total Amount (DR)
tdCInvoiceWHTTotAmtDebitTCdecimalCInvoice.CInvoiceWHTTotAmtDebitTCTC WHT Total Amount (DR)
tiCompany_IDintegerCInvoice.Company_IDLink to Company
tiCostCentre_IDintegerCInvoice.CostCentre_IDCost Center
tiCreditor_IDintegerCInvoice.Creditor_IDLink to Creditor
tcCustomCombo0characterCInvoice.CustomCombo0Custom Combo Field
tcCustomCombo1characterCInvoice.CustomCombo1Custom Combo Field
tcCustomCombo2characterCInvoice.CustomCombo2Custom Combo Field
tcCustomCombo3characterCInvoice.CustomCombo3Custom Combo Field
tcCustomCombo4characterCInvoice.CustomCombo4Custom Combo Field
tcCustomCombo5characterCInvoice.CustomCombo5Custom Combo Field
tcCustomCombo6characterCInvoice.CustomCombo6Custom Combo Field
tcCustomCombo7characterCInvoice.CustomCombo7Custom Combo Field
tcCustomCombo8characterCInvoice.CustomCombo8Custom Combo Field
tcCustomCombo9characterCInvoice.CustomCombo9Custom Combo Field
ttCustomDate0dateCInvoice.CustomDate0Custom Date Field
ttCustomDate1dateCInvoice.CustomDate1Custom Date Field
ttCustomDate2dateCInvoice.CustomDate2Custom Date Field
ttCustomDate3dateCInvoice.CustomDate3Custom Date Field
ttCustomDate4dateCInvoice.CustomDate4Custom Date Field
tdCustomDecimal0decimalCInvoice.CustomDecimal0Custom Decimal Field
tdCustomDecimal1decimalCInvoice.CustomDecimal1Custom Decimal Field
tdCustomDecimal2decimalCInvoice.CustomDecimal2Custom Decimal Field
tdCustomDecimal3decimalCInvoice.CustomDecimal3Custom Decimal Field
tdCustomDecimal4decimalCInvoice.CustomDecimal4Custom Decimal Field
tiCustomInteger0integerCInvoice.CustomInteger0Custom Integer Field
tiCustomInteger1integerCInvoice.CustomInteger1Custom Integer Field
tiCustomInteger2integerCInvoice.CustomInteger2Custom Integer Field
tiCustomInteger3integerCInvoice.CustomInteger3Custom Integer Field
tiCustomInteger4integerCInvoice.CustomInteger4Custom Integer Field
tcCustomLong0characterCInvoice.CustomLong0Custom Long Field
tcCustomLong1characterCInvoice.CustomLong1Custom Long Field
tcCustomNotecharacterCInvoice.CustomNoteCustom Note Field
tcCustomShort0characterCInvoice.CustomShort0Custom Short Field
tcCustomShort1characterCInvoice.CustomShort1Custom Short Field
tcCustomShort2characterCInvoice.CustomShort2Custom Short Field
tcCustomShort3characterCInvoice.CustomShort3Custom Short Field
tcCustomShort4characterCInvoice.CustomShort4Custom Short Field
tcCustomShort5characterCInvoice.CustomShort5Custom Short Field
tcCustomShort6characterCInvoice.CustomShort6Custom Short Field
tcCustomShort7characterCInvoice.CustomShort7Custom Short Field
tcCustomShort8characterCInvoice.CustomShort8Custom Short Field
tcCustomShort9characterCInvoice.CustomShort9Custom Short Field
tiDivision_IDintegerCInvoice.Division_IDSub-Account
tiJournal_IDintegerCInvoice.Journal_IDDaybook Code
ttLastModifiedDatedateCInvoice.LastModifiedDateLast Modified Date
tiLastModifiedTimeintegerCInvoice.LastModifiedTimeLast Modified Time
tcLastModifiedUsercharacterCInvoice.LastModifiedUserLast Modified User
tiLinkedCInvoice_IDintegerCInvoice.LinkedCInvoice_IDReference
tiNormalPaymentCondition_IDintegerCInvoice.NormalPaymentCondition_IDCredit Terms Code
tiPeriod_IDintegerCInvoice.Period_IDLink to Period
tiProject_IDintegerCInvoice.Project_IDProject
tiReason_IDintegerCInvoice.Reason_IDInvoice Status Code
tiRole_IDintegerCInvoice.Role_IDRole Name
tiShipToAddress_IDintegerCInvoice.ShipToAddress_IDCity
tiTransactionEndCountry_IDintegerCInvoice.TransactionEndCountry_IDCountry Code
tiTransactionStartCountry_IDintegerCInvoice.TransactionStartCountry_IDCountry Code
tiVatCurrency_IDintegerCInvoice.VatCurrency_IDCurrency Code
CInvoiceCustomcharactercalculatedcustom fields
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(CInvoice)


Internal usage


QadFinancials
method BCDocument.ValidateComponentPostWHT
method BPaymentSelection.FillProDataSetPayment


Sample code: how to call this query through RPCRequestService (QXtend Inbound)

define temp-table ttContext no-undo
    field propertyQualifier as character
    field propertyName as character
    field propertyValue as character
    index entityContext is primary unique
        propertyQualifier
        propertyName
    index propertyQualifier
        propertyQualifier.

define dataset dsContext for ttContext.

define variable vhContextDS as handle no-undo.
define variable vhExceptionDS as handle no-undo.
define variable vhServer as handle no-undo.
define variable vhInputDS as handle no-undo.
define variable vhInputOutputDS as handle no-undo.
define variable vhOutputDS as handle no-undo.
define variable vhParameter as handle no-undo.

/* Create context */
create ttContext.
assign ttContext.propertyName = "programName"
       ttContext.propertyValue = "BCInvoice".
create ttContext.
assign ttContext.propertyName = "methodName"
       ttContext.propertyValue = "CInvoiceByAllInfo".
create ttContext.
assign ttContext.propertyName = "applicationId"
       ttContext.propertyValue = "fin".
create ttContext.
assign ttContext.propertyName = "entity"
       ttContext.propertyValue = "1000".
create ttContext.
assign ttContext.propertyName = "userName"
       ttContext.propertyValue = "mfg".
create ttContext.
assign ttContext.propertyName = "password"
       ttContext.propertyValue = "".

/* Create input dataset */
create dataset vhInputDS.
vhInputDS:read-xmlschema("file", "xml/bcinvoice.cinvoicebyallinfo.i.xsd", ?).
vhParameter = vhInputDS:get-buffer-handle("tParameterI").
vhParameter:buffer-create().

assign vhParameter::icRange = "A"
       vhParameter::icRowid = ""
       vhParameter::iiRownum = 0
       vhParameter::iiNumber = 5 /* Number of records to read */
       vhParameter::icSortColumns = ""
       vhParameter::ilCountOnly = false
       vhParameter::ilForwardRead = true
       vhParameter::iiMaximumBrowseRecordsToCount = 0.

vhParameter = vhInputDS:get-buffer-handle("tFilter").
vhParameter:buffer-create().

assign vhParameter::<field-name-1> = <field-value-1>
       vhParameter::<field-name-2> = <field-value-2>
       ...

/* Connect the AppServer */
create server vhServer.
vhServer:connect("-URL <appserver-url>").

if not vhServer:connected()
then do:
    message "Could not connect AppServer" view-as alert-box error title "Error".
    return.
end.

/* Run */
assign vhContextDS = dataset dsContext:handle.

run program/rpcrequestservice.p on vhServer
    (input-output dataset-handle vhContextDS by-reference,
           output dataset-handle vhExceptionDS,
     input        dataset-handle vhInputDS by-reference,
     input-output dataset-handle vhInputOutputDS by-reference,
           output dataset-handle vhOutputDS).

/* Handle output however you want, in this example, we dump it to xml */
if valid-handle(vhExceptionDS)
then vhExceptionDS:write-xml("file", "Exceptions.xml", true).

if valid-handle(vhOutputDS)
then vhOutputDS:write-xml("file", "Output.xml", true).

/* Cleanup */
vhServer:disconnect().
assign vhServer = ?.

if valid-handle(vhInputDS)
then delete object vhInputDS.

if valid-handle(vhOutputDS)
then delete object vhOutputDS.

if valid-handle(vhExceptionDS)
then delete object vhExceptionDS.