project QadFinancials > class BDInvoice > business logic query DInvoiceBankForDiscountGL

Description

DInvoiceBankForDiscountGL


Parameters


iiDInvoiceIDinteger
iiCompanyIdintegerCompany id


query condition


  each DInvoiceBank where
DInvoiceBank.DInvoice_ID = iiDInvoiceID

      first BankNumber1 (inner-join) where
BankNumber1.BankNumber_ID = DInvoiceBank.BankNumber_ID AND

          first BankPayFormat (inner-join) where
BankPayFormat.BankPayFormat_ID = BankNumber1.BankPayFormat_ID AND

              first BankNumber2 (inner-join) where
BankNumber2.BankNumber_ID = BankPayFormat.BankNumber_ID AND

                  first GL1 (inner-join) where
GL1.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL1.GL_ID = BankNumber2.ParentObject_ID AND

                      first GL2 (inner-join) where
GL2.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL2.GL_ID = GL1.BankARDiscountGL_ID AND

      first DInvoice (inner-join) where
DInvoice.Company_Id = iiCompanyId AND
DInvoice.DInvoice_ID = DInvoiceBank.DInvoice_ID AND

          first Division (outer-join) where
Division.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division.Division_ID = DInvoice.Division_ID AND


query resultset tqDInvoiceBankForDiscountGL


field namedata typedb fielddescription
tiBankARDiscountGL_IDintegerGL1.BankARDiscountGL_IDAR Discount Account
tcBankARDiscountGLCodecharacterGL2.GLCodeA code identifying the GL account.
tiDivision_IDintegerDInvoice.Division_IDSub-Account
tcDivisionCodecharacterDivision.DivisionCodeSub-Account
tlGLIsDivisionAccountlogicalGL2.GLIsDivisionAccountSet to true if the account has a sub-account.
Its value is calculated by the system and is determined by the value of tcDivisionProfileCode.
api annotation:This field can be left blank as it will be calculated by the system.
tiDebtorBankNumber_IDintegerBankNumber1.BankNumber_IDRecord ID
tiGLBankNumber_IDintegerBankPayFormat.BankNumber_IDBank Number
tiBankPayFormat_IDintegerBankPayFormat.BankPayFormat_IDRecord ID
tiParentObject_IDintegerBankNumber2.ParentObject_IDParent Object
tiBankGL_IDintegerGL1.GL_IDRecord ID
tiBankNumber_IDintegerDInvoiceBank.BankNumber_IDFormatted Bank Account No
tiDInvoice_IDintegerDInvoiceBank.DInvoice_IDLink to DInvoice
tiDInvoiceBank_IDintegerDInvoiceBank.DInvoiceBank_IDRecord ID


Internal usage


QadFinancials
method BOpenItemAdjustment.OIAdjCommitSubDInvoiceDiscount