project QadFinancials > class BExpenseNote > business logic query ExpNoteCInvoiceByCInvoice


Parameters


iiCInvoice_IDinteger
icExpNoteCInvoiceStatusCodecharacter
iiCompanyIdintegerCompany id


query condition


  each ExpNoteCInvoice where
ExpNoteCInvoice.CInvoice_ID = iiCInvoice_ID AND
ExpNoteCInvoice.ExpNoteCInvoiceStatusCode = icExpNoteCInvoiceStatusCode

      first ExpNote (inner-join) where
ExpNote.Company_Id = iiCompanyId AND
ExpNote.ExpNote_ID = ExpNoteCInvoice.ExpNote_ID AND


query resultset tqExpNoteCInvoiceByCInvoice


field namedata typedb fielddescription
tiExpNote_IDintegerExpNoteCInvoice.ExpNote_IDLink to ExpNote
tdExpNoteCInvoiceDeductLCdecimalExpNoteCInvoice.ExpNoteCInvoiceDeductLCBC Deductible
tdExpNoteCInvoiceDeductTCdecimalExpNoteCInvoice.ExpNoteCInvoiceDeductTCTC Deductible
tcExpNoteCInvoiceStatusCodecharacterExpNoteCInvoice.ExpNoteCInvoiceStatusCodeStatus Code
tdExpNoteCInvoiceToReturnTCdecimalExpNoteCInvoice.ExpNoteCInvoiceToReturnTCTC To Return
tcExpNoteCInvoiceTypeCodecharacterExpNoteCInvoice.ExpNoteCInvoiceTypeCodeType Code
ttExpNoteConfirmationDatedateExpNote.ExpNoteConfirmationDateConfirmation Date
tiExpNoteNumberintegerExpNote.ExpNoteNumberNumber
ttExpNoteRegistrationDatedateExpNote.ExpNoteRegistrationDateRegistration Date
tiExpNoteYearintegerExpNote.ExpNoteYearYear
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(ExpNoteCInvoice),rowid(ExpNote)


Internal usage


QadFinancials
method BExpenseNote.APIGetAdvancesInfo
method BExpenseNote.RefreshAdvances