project QadFinancials > class BDCollection > business logic query DCollectionByID


Parameters


iiCompanyIdintegerCompany id
iiCollectionIdinteger


query condition


  each DCollection where
DCollection.Company_Id = iiCompanyId AND


query resultset tqDCollectionByID


field namedata typedb fielddescription
tiCompany_IDintegerDCollection.Company_IDLink to Company
tiDCollection_IDintegerDCollection.DCollection_IDRecord ID
tcDCollectionIncSelCodeListcharacterDCollection.DCollectionIncSelCodeListCustomer Payment Selection Code
tcDCollectionNamecharacterDCollection.DCollectionNameName
tiDCollectionNumberintegerDCollection.DCollectionNumberNumber
tcDCollectionReferencecharacterDCollection.DCollectionReference1099 Box Reference
ttDCollectionRequestedDatedateDCollection.DCollectionRequestedDateRequested Date
tiDCollectionYearintegerDCollection.DCollectionYearYear/Customer Payment Selection Code
tiGL_IDintegerDCollection.GL_IDGL Account
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(DCollection)


Internal usage


QadFinancials
method BDCollection.ExportCLIEOP03
method BDCollection.ExportDOM80
method BDCollection.ExportLCRBOR
method BDCollection.ExportXml