project QadFinancials > class BCInvoice > business logic query CInvoiceForSharedSet

Description

Cinvoice to shared set


Parameters


iiCompanyIdintegerCompany id
iiCInvoiceIDintegerCInvoice ID
icSharedSetTypecharacterShared Set Type


query condition


  each CInvoice where
CInvoice.Company_Id = iiCompanyId AND

      first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = CInvoice.Company_ID AND

          each CompanySharedSet (inner-join) where
CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.Company_ID = Company.Company_ID AND

              first SharedSet (inner-join) where
SharedSet.SharedSet_ID = CompanySharedSet.SharedSet_ID AND


query resultset tqCInvoiceForSharedSet


field namedata typedb fielddescription
tiCInvoice_IDintegerCInvoice.CInvoice_IDRecord ID
tiCompany_IDintegerCompany.Company_IDRecord ID
tcCompanyCodecharacterCompany.CompanyCodeEntity Code
tiSharedSet_IDintegerSharedSet.SharedSet_IDRecord ID
tcSharedSetCodecharacterSharedSet.SharedSetCodeShared Set Code
tcSharedSetTypeCodecharacterSharedSet.SharedSetTypeCodeShared Set Type


Internal usage


QadFinancials
method BPaymentSelection.ValidateComponentPost