project QadFinancials > class BDebtor > business logic query DebtorForBankNumber


Parameters


iiCompanyIdintegerCompany id
iiDebtorIDinteger
icDebtorCodecharacter


query condition


  each Debtor where
Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor.Debtor_ID = iiDebtorID AND
Debtor.DebtorCode = icDebtorCode

      each BankNumber1 (inner-join) where
BankNumber1.ParentObject_ID = Debtor.Debtor_ID AND

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

              first PayFormatType (inner-join) where
PayFormatType.PayFormatTypeCode = BankPayFormat.PayFormatTypeCode AND

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

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

                  first CompanySharedSet (inner-join) where
CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.CompanySharedSet_ID = BankNumber2.CompanySharedSet_ID AND

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


query resultset tqDebtorForBankNumber


field namedata typedb fielddescription
tcBankNumbercharacterBankNumber1.BankNumberBank Number
tiBankNumber_IDintegerBankNumber1.BankNumber_IDRecord ID
tcBankNumberExtensioncharacterBankNumber1.BankNumberExtensionBank Extension
tlBankNumberIsActivelogicalBankNumber1.BankNumberIsActiveActive
tlBankNumberIsDefaultlogicalBankNumber1.BankNumberIsDefaultDefault
tcBankNumberParentTypecharacterBankNumber1.BankNumberParentTypeType
tcBankNumberValidationcharacterBankNumber1.BankNumberValidationValidation
tiBankPayFormat_IDintegerBankNumber1.BankPayFormat_IDLink to BankPayFormat
tlBankPayFormatIsActivelogicalBankPayFormat.BankPayFormatIsActiveActive
tiCompany_IDintegerCompany.Company_IDRecord ID
tcCompanyCodecharacterCompany.CompanyCodeEntity Code
tiCompanySharedSet_IDintegerBankNumber2.CompanySharedSet_IDLink to CompanySharedSet
tiDebtor_IDintegerDebtor.Debtor_IDRecord ID
tcDebtorCodecharacterDebtor.DebtorCodeA code (maximum eight characters) that identifies a customer. If the code you specify matches an existing supplier code, a warning message displays. You can choose to ignore the warning, and create the record. However, when a supplier and customer share the same code, they must reference the same business relation.
api annotation:If you leave the Customer Code field blank, the system automatically generates a number for the record based on the sequence defined in Customer Autonumber Create.
tcGLCodecharacterGL.GLCodeA code identifying the GL account.
tcOwnBankNumbercharacterBankNumber2.BankNumberBank Number
tiOwnBankNumber_IDintegerBankNumber2.BankNumber_IDRecord ID
tlOwnBankNumberIsActivelogicalBankNumber2.BankNumberIsActiveActive
tiOwnParentObject_IDintegerBankNumber2.ParentObject_IDParent Object
tiParentObject_IDintegerBankNumber1.ParentObject_IDParent Object
tcPayFormatTypeCodecharacterPayFormatType.PayFormatTypeCodeFormat Name
tlPayFormatTypeIsActivelogicalPayFormatType.PayFormatTypeIsActiveActive
tcPayFormatTypeModulecharacterPayFormatType.PayFormatTypeModuleModule
tcPayFormatTypePayInstrumentcharacterPayFormatType.PayFormatTypePayInstrumentPayment Instrument
tcPayFormatTypePayTypecharacterPayFormatType.PayFormatTypePayTypePayment Type


Internal usage


QadFinancials
method BBankNumber.GetParentBankData