Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Where is the Internet Information

Where is the Internet Information

Where is the Internet Information

I'm looking for the tables that contain the data displayed in the Internet Information windows.  Specifically in regards to customer account information.  Email address, username and password.  It seems as though I've gone table by table and can't find it.  

RE: Where is the Internet Information

... Odd as it sounds, you should check the System tables. I know, for example, that I use the INETINFO field on SY01200 to get the Internet Info for Item. There are other fields there which for me are blank, but perhaps you'll find the info you need within. If not, try some other likely sounding SY tables.

Are you working in Crystal Reports? Because some of the tables aren't listed for whatever reason (bad design likely!) in Tools>Resource Description>Tables. For instance, I don't see SY01200 listed. So you may have to go into Crystal and browse for the data, as inconvenient as that can be.

Let me know what you find.


RE: Where is the Internet Information

The internet information is not limited to one ledger it is a single table for all the ledgers that it covers, therefore if you are looking for the table information you should look in the company series not the sales ledger.

However the SY01200 is the correct table for internet information make sure you only look at records marked 'CUS' for customers

RE: Where is the Internet Information

Thanks hoogie; yes I found it there, in Company. I must have seen the table in GP at some point and printed it, because I do link to it, but couldn't find it when answering SeanFu (wherever he may be).

But I have a question - on my SY01200 I have only 13 fields in all. Besides the first four (GPS_Reserved, Master type, Master ID, and Address Code), their names all begin with 'IN', which I presume is Inventory.

Why don't I have fields labelled 'CUS'? We don't use those fields that SeanFu was asking about, but shouldn't I still see the 'CUS' fields anyway, and they'll just be devoid of info? Is this a Setup thing in GP and/or the way the product was installed for this company?

Thanks in advance - you're the GP guru! : )


RE: Where is the Internet Information

The CUS I am refering to is the data that will be in the Master_Type field when the record is a customer.  If you don't have customer internet information stored you wont see any records with a 'CUS' master_type.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close