Buyer Type

Discussions related to custom development with Select.
Post Reply
sanjay.mittal
Posts: 94
Joined: Mon Dec 28, 2009 3:43 pm

Buyer Type

Post by sanjay.mittal »

Can you tell me how do I find out if a buyer is an individual buyer or a corporation in the database? I am looking at pfm.contact table and couldn’t find it.

Thanks
SM
Lisa Ennis
Posts: 84
Joined: Thu Sep 11, 2008 1:57 pm

Re: Buyer Type

Post by Lisa Ennis »

Link pfm.Principal to the pfm.Contact table (pfm.Contact.RootId#=pfm.Principal.RootId# AND pfm.Contact.Id#=pfm.Principal.Id#). The pfm.Principal.BuyerSellerType field contains the code for the Type. You can link on that field to the zref.BuyerSellerType to determine if the Buyer/Seller is an Individual or an Organization.
Lisa Ennis
Senior Report Developer
SoftPro
sanjay.mittal
Posts: 94
Joined: Mon Dec 28, 2009 3:43 pm

Re: Buyer Type

Post by sanjay.mittal »

Thanks Lisa.
Post Reply