project QadFinancials > class BDCollection > business logic query DCollectionByDDocument


Parameters


iiCompanyIdintegerCompany id
iiDCollectionIdinteger


query condition


  each DCollection where
DCollection.Company_Id = iiCompanyId AND
DCollection.DCollection_ID = iiDCollectionId

      each DDocument (inner-join) where
DDocument.Company_Id = iiCompanyId AND
DDocument.DCollection_ID = DCollection.DCollection_ID AND

          first BankNumber1 (inner-join) where
BankNumber1.BankNumber_ID = DDocument.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 CompanySharedSet (inner-join) where
CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.CompanySharedSet_ID = BankNumber2.CompanySharedSet_ID AND


query resultset tqDCollectionByDDocument


field namedata typedb fielddescription
tiBankAccFormat_IDintegerBankNumber2.BankAccFormat_IDBank Account Format
tiBankBusinessRelation_IDintegerBankNumber2.BankBusinessRelation_IDBusiness Relation
tcBankNumbercharacterBankNumber2.BankNumberBank Number
tiBankNumber_IDintegerBankNumber2.BankNumber_IDRecord ID
tcBankNumberBranchcharacterBankNumber2.BankNumberBranchBranch
tcBankNumberExtensioncharacterBankNumber2.BankNumberExtensionBank Extension
tcBankNumberFormattedcharacterBankNumber2.BankNumberFormattedFormatted Bank Account No
tlBankNumberIsActivelogicalBankNumber2.BankNumberIsActiveActive
tlBankNumberIsDefaultlogicalBankNumber2.BankNumberIsDefaultDefault
tcBankNumberParentTypecharacterBankNumber2.BankNumberParentTypeType
tcBankNumberSwiftCodecharacterBankNumber2.BankNumberSwiftCodeSWIFT Code
tcBankNumberValidationcharacterBankNumber2.BankNumberValidationValidation
tiBankPayFormat_IDintegerBankNumber2.BankPayFormat_IDLink to BankPayFormat
tiCompanySharedSet_IDintegerBankNumber2.CompanySharedSet_IDLink to CompanySharedSet
tiCurrency_IDintegerBankNumber2.Currency_IDCurrency Code
tcCustomCombo0characterBankNumber2.CustomCombo0Custom Combo Field
tcCustomCombo1characterBankNumber2.CustomCombo1Custom Combo Field
tcCustomCombo2characterBankNumber2.CustomCombo2Custom Combo Field
tcCustomCombo3characterBankNumber2.CustomCombo3Custom Combo Field
tcCustomCombo4characterBankNumber2.CustomCombo4Custom Combo Field
tcCustomCombo5characterBankNumber2.CustomCombo5Custom Combo Field
tcCustomCombo6characterBankNumber2.CustomCombo6Custom Combo Field
tcCustomCombo7characterBankNumber2.CustomCombo7Custom Combo Field
tcCustomCombo8characterBankNumber2.CustomCombo8Custom Combo Field
tcCustomCombo9characterBankNumber2.CustomCombo9Custom Combo Field
ttCustomDate0dateBankNumber2.CustomDate0Custom Date Field
ttCustomDate1dateBankNumber2.CustomDate1Custom Date Field
ttCustomDate2dateBankNumber2.CustomDate2Custom Date Field
ttCustomDate3dateBankNumber2.CustomDate3Custom Date Field
ttCustomDate4dateBankNumber2.CustomDate4Custom Date Field
tdCustomDecimal0decimalBankNumber2.CustomDecimal0Custom Decimal Field
tdCustomDecimal1decimalBankNumber2.CustomDecimal1Custom Decimal Field
tdCustomDecimal2decimalBankNumber2.CustomDecimal2Custom Decimal Field
tdCustomDecimal3decimalBankNumber2.CustomDecimal3Custom Decimal Field
tdCustomDecimal4decimalBankNumber2.CustomDecimal4Custom Decimal Field
tiCustomInteger0integerBankNumber2.CustomInteger0Custom Integer Field
tiCustomInteger1integerBankNumber2.CustomInteger1Custom Integer Field
tiCustomInteger2integerBankNumber2.CustomInteger2Custom Integer Field
tiCustomInteger3integerBankNumber2.CustomInteger3Custom Integer Field
tiCustomInteger4integerBankNumber2.CustomInteger4Custom Integer Field
tcCustomLong0characterBankNumber2.CustomLong0Custom Long Field
tcCustomLong1characterBankNumber2.CustomLong1Custom Long Field
tcCustomNotecharacterBankNumber2.CustomNoteCustom Note Field
tcCustomShort0characterBankNumber2.CustomShort0Custom Short Field
tcCustomShort1characterBankNumber2.CustomShort1Custom Short Field
tcCustomShort2characterBankNumber2.CustomShort2Custom Short Field
tcCustomShort3characterBankNumber2.CustomShort3Custom Short Field
tcCustomShort4characterBankNumber2.CustomShort4Custom Short Field
tcCustomShort5characterBankNumber2.CustomShort5Custom Short Field
tcCustomShort6characterBankNumber2.CustomShort6Custom Short Field
tcCustomShort7characterBankNumber2.CustomShort7Custom Short Field
tcCustomShort8characterBankNumber2.CustomShort8Custom Short Field
tcCustomShort9characterBankNumber2.CustomShort9Custom Short Field
tiDCollection_IDintegerDCollection.DCollection_IDRecord ID
ttLastModifiedDatedateBankNumber2.LastModifiedDateLast Modified Date
tiLastModifiedTimeintegerBankNumber2.LastModifiedTimeLast Modified Time
tcLastModifiedUsercharacterBankNumber2.LastModifiedUserLast Modified User
tiParentObject_IDintegerBankNumber2.ParentObject_IDParent Object
tcQADC01characterBankNumber2.QADC01unused QAD reserved field
tcQADC02characterBankNumber2.QADC02unused QAD reserved field
tdQADD01decimalBankNumber2.QADD01unused QAD reserved field
ttQADT01dateBankNumber2.QADT01unused QAD reserved field


Internal usage


QadFinancials
method BDCollection.FillProDataSetGL