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
Buyer Type
-
- Posts: 84
- Joined: Thu Sep 11, 2008 1:57 pm
Re: Buyer Type
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
Senior Report Developer
SoftPro