WebCOBRA.com Community Message Boards

val
Posts: 5
Since: 01/07/2010

Good morning.
Is there a way to find disbursed premiums or premiums through WebService?
We tried to use example queries provided in WebAPI_Loader app (WebCOBRAQuerySystem class), but got back only ARRA Subsidy payments and no information on premiums.

Thank you.

Rjackson
Posts: 5
Since: 01/19/2010

Below is an access query that gets you all the payments that have been disbursed. You can filter certain types of payments by looking at the paymentMethod table and adding AccountingPaymentMethod.PaymentMeth odID to the “Where” clause. If you would like to get all payments and not just those disbursed simply remove the Inner join to accountingDIsburements. If have any other questions please don’t hesitate to ask.


SELECT AccountingPayment.[DateEntered], AccountingPayment.[AmountPayed], QB.LastName, QB.FirstName, QB.SSN, QB.QBTypeID, AccountingDisbursement.Amount, AccountingPaymentMethod.Name
FROM (AccountingPayment INNER JOIN AccountingPaymentMethod ON AccountingPayment.PaymentMethodID = AccountingPaymentMethod.PaymentMeth odID) INNER JOIN (AccountingDisbursement INNER JOIN (QBGroups INNER JOIN QB ON QBGroups.QBGroupID = QB.QBGroupID) ON AccountingDisbursement.QBGroupID = QBGroups.QBGroupID) ON AccountingPayment.PaymentHistoryID = AccountingDisbursement.AccountingPaymentID
WHERE (((QB.QBTypeID)=9));

val
Posts: 5
Since: 01/07/2010

Thank you very much. Now I have hard time finding Company address, I know there is table Addresses in DB but could not figure out right way from Companies table to Addresses

sszelei
Posts: 53
Since: 09/02/2009

You can obtain this information by joining on the tables as per the example:

Select * from
QBGroup,
Addresses a
inner join SystemInformationLinkTable on SystemInformationLinkTable.TableLin kIdent = a.AddressID
and SystemInformationLinkTable.ModuleTy peID = 3 and SystemInformationLinkTable.InformationTypeID = 1
where
AND SystemInformationLinkTable.ModuleIdent = QBGroup.QBAutoID

Regs,

Steven

val
Posts: 5
Since: 01/07/2010

Thank you! I could never figure it out myself.