project QadFinancials > class BCInvoice > business logic query CInvoiceByIDsForAttr


Parameters


iiCompanyIdintegerCompany id
iiCInvoiceIDinteger
iiCreditorIDinteger
iiBankNumberIDinteger
iiCurrencyIDinteger


query condition


  each CInvoice where
CInvoice.Company_Id = iiCompanyId AND
CInvoice.Creditor_ID = iiCreditorID AND
CInvoice.CInvoice_ID = iiCInvoiceID AND
CInvoice.CInvoiceCurrency_ID = iiCurrencyID

      each CInvoiceBank (inner-join) where
CInvoiceBank.CInvoice_ID = CInvoice.CInvoice_ID AND
CInvoiceBank.BankNumber_ID = iiBankNumberID

          each CInvoiceBankPayCode (inner-join) where
CInvoiceBankPayCode.CInvoiceBank_ID = CInvoiceBank.CInvoiceBank_ID AND

              first PayFormatGroup (inner-join) where
PayFormatGroup.PayFormatGroup_ID = CInvoiceBankPayCode.PayFormatGroup_ID AND


query resultset tqCInvoiceByIDsForAttr


field namedata typedb fielddescription
tiBankNumber_IDintegerCInvoiceBank.BankNumber_IDBank Number
tiCInvoice_IDintegerCInvoice.CInvoice_IDRecord ID
tiCInvoice_ID2integerCInvoiceBank.CInvoice_IDLink to CInvoice
tiCInvoiceBank_IDintegerCInvoiceBank.CInvoiceBank_IDRecord ID
tiCInvoiceBank_ID2integerCInvoiceBankPayCode.CInvoiceBank_IDLink to CInvoiceBank
tiCInvoiceBankPayCode_IDintegerCInvoiceBankPayCode.CInvoiceBankPayCode_IDRecord ID
tcCInvoiceBankPayCodeValuecharacterCInvoiceBankPayCode.CInvoiceBankPayCodeValueAttribute Value. A new attribute of the payment Format.
This field is added by the user for bank payment.
api annotation:This field defaults from the value user set in the payment maintance.
tiCInvoiceCurrency_IDintegerCInvoice.CInvoiceCurrency_IDCurrency Code
tiCreditor_IDintegerCInvoice.Creditor_IDLink to Creditor
tiPayFormatCode_IDintegerCInvoiceBankPayCode.PayFormatCode_IDLink to PayFormatCode
tiPayFormatGroup_IDintegerCInvoiceBankPayCode.PayFormatGroup_IDLink to PayFormatGroup
tcPayFormatGroupCodecharacterPayFormatGroup.PayFormatGroupCodeAttribute Name
tcPayFormatGroupLevelcharacterPayFormatGroup.PayFormatGroupLevelLevel
tcPayFormatTypeCodecharacterPayFormatGroup.PayFormatTypeCodePayment Format Type
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(CInvoice),rowid(CInvoiceBank),rowid(CInvoiceBankPayCode),rowid(PayFormatGroup)


Internal usage


QadFinancials
method BPaymentSelection.FillProDataSet