Customer data - Cust Master CONTACTS DETAIL SHEET
Most all fields are traceable per Field Help // Technical Details except
3 fields w/o DB field names which are within the PRIMARY CONTACT section of this sheet
the 3 fields are check-boxes : Billing Purchasing Shipping
Appreciate insight as to being able to BAQ these Customer specific fields.
Have reviewed > Custoemr > CustCnt > PerCon > Person…
Customer.PrimBCon is the contact number for the primary billing contact.
Thanks,
Norman Hutchins
Systems Administrator
Howell Laboratories, Inc.
On the DMT template for Customer Contact, it shows the three check boxes as Boolean fields:
[/uploads/default/original/2X/7/70115ef7bd44bdc82d088d33ccd3c076f55185ba.jpg]
Mazin
My guest based on similar designed for the default authorized user for buyers or workforce is that Epicor will set a bit in a field to 0 or 1 and stored in some field related to the CustCnt table or PerCon table.
Based on some feedback… this is what I found out:
The three fields on the Customer - Contacts - Detail sheet (Primary contact area // Billing - Purchasing - Shipping)
are Customer.PrimBCon
Customer.PrimPCon
Customer.PrimSCon
Field Help indicates these are EPI-binding fields (not specifically ID-ing the field)
Thanks to those who provided insight! (no pun intended)
How does EPICOR manage this?
Epicor loads a sequential Contact ID number to each contact.
Let’s say there are four…
1- Moe
2- Larry
3- Curley
4-Shep
If you check Larry as the Primary purchasing contact, E-10 loads a numerical 2
into Customer.PrimPCon.
Since there can only be ONE Primary contact for Purchasing checked…
Going to Curley’s contact entry and checking Purchasing removes the check from Larry and updates
Customer.PrimPCon with “3”