Welcome, Guest
Username: Password: Remember me

TOPIC: Table - Accounts

Table - Accounts #1694

  • dghodgson
  • dghodgson's Avatar
  • OFFLINE
  • Senior Boarder
  • Posts: 40
  • Karma: 0
Can anyone tell me the table name where the account names are stored in Synergy?
The administrator has disabled public write access.

Table - Accounts #1695

  • ultrav375
  • ultrav375's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 35
  • Thank you received: 1
  • Karma: 0
cicmpy under cmp_name

Celeste
The administrator has disabled public write access.

Table - Accounts #1696

  • dghodgson
  • dghodgson's Avatar
  • OFFLINE
  • Senior Boarder
  • Posts: 40
  • Karma: 0
Thank you, could you also tell me the field name for contact(s)? I assume same table ??
The administrator has disabled public write access.

Table - Accounts #1697

  • ultrav375
  • ultrav375's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 35
  • Thank you received: 1
  • Karma: 0
Actually contacts are under cicntp - haven't reported much on that table - not sure how the main contact is differentiated...
The administrator has disabled public write access.

Table - Accounts #1698

  • jamescard
  • jamescard's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 24
  • Karma: 0
This should help...

--GET ALL ACCOUNTS AND ALL OF THEIR CONTACTS
SELECT c.cmp_name AS [Company Name], t.FullName AS [Contact Name]
FROM cicmpy c INNER JOIN cicntp t ON c.cmp_wwn = t.cmp_wwn
ORDER BY c.cmp_name

--GET ALL ACCOUNTS AND THE MAIN CONTACT ASSOCIATED WITH EACH ACCOUNT
SELECT c.cmp_name AS [Company Name], t.FullName AS [Contact Name]
FROM cicmpy c INNER JOIN cicntp t ON c.cmp_wwn = t.cmp_wwn AND c.cnt_id = t.cnt_id
ORDER BY c.cmp_name
_______________________________________
James Card - Consulting Manager
Mayer, Shanzer & Mayer, P.C.
An Authorized Exact Business Partner
610-506-1460
jcard@msmpc.com
http://www.msmpc.com
The administrator has disabled public write access.

Table - Accounts #1699

  • ultrav375
  • ultrav375's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 35
  • Thank you received: 1
  • Karma: 0
Thanks!!
The administrator has disabled public write access.

Table - Accounts #1700

  • dghodgson
  • dghodgson's Avatar
  • OFFLINE
  • Senior Boarder
  • Posts: 40
  • Karma: 0
This is great, I also need to link the cicmpy table to abscences table, any thoughts on that?
The administrator has disabled public write access.

Table - Accounts #1702

  • jamescard
  • jamescard's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 24
  • Karma: 0
sure. this depends on how you are collecting the customer link on the request. if you are using the standard "account" field then...

SELECT c.cmp_name AS [Company Name], a.HID AS [Request Number]
FROM cicmpy c INNER JOIN Absences a ON c.cmp_wwn = a.CustomerID AND a.Type = ???

where ??? is the request type value for the desired requests.

If you are using one of the Free Guid Fields to collect customer info then you would substitute the a.CustomerID for the appropriate guid field name.
_______________________________________
James Card - Consulting Manager
Mayer, Shanzer & Mayer, P.C.
An Authorized Exact Business Partner
610-506-1460
jcard@msmpc.com
http://www.msmpc.com
The administrator has disabled public write access.

Table - Accounts #1704

  • dghodgson
  • dghodgson's Avatar
  • OFFLINE
  • Senior Boarder
  • Posts: 40
  • Karma: 0
thanks
The administrator has disabled public write access.
Time to create page: 0.039 seconds
Powered by Kunena Forum  Protected by R Antispam