business logic query QCrossCyPostingByCompany

Description

Returns all QCrossCyPosting ID's

iiCompanyId	integer	Company id
iiDaemonId	integer

each QCrossCyPosting where

QCrossCyPosting.Company_Id = iiCompanyId AND

each fcDaemonQueue (outer-join) where

fcDaemonQueue.DaemonQueueRef = string(QCrossCyPosting.QCrossCyPosting_ID) AND
fcDaemonQueue.DaemonId = iiDaemonId

field name	data type	db field	description
tiCInvoice_ID	integer	QCrossCyPosting.CInvoice_ID	Link to CInvoice
tiCompany_ID	integer	QCrossCyPosting.Company_ID	Link to Company
tiDaemonId	integer	fcDaemonQueue.DaemonId	Daemon ID
tiDaemonQueueId	integer	fcDaemonQueue.DaemonQueueId	identifier
tiDInvoice_ID	integer	QCrossCyPosting.DInvoice_ID	Link to DInvoice
tiQCrossCyPosting_ID	integer	QCrossCyPosting.QCrossCyPosting_ID	Record ID
ttQCrossCyPostingCreateDate	date	QCrossCyPosting.QCrossCyPostingCreateDate	Creation Date
tiQCrossCyPostingCreateTime	integer	QCrossCyPosting.QCrossCyPostingCreateTime	Creation Time
tcQCrossCyPostingInfo	character	QCrossCyPosting.QCrossCyPostingInfo	Originator Info

QadFinancials