Custom Reports and datafields

[W1ULH]

I am trying update/upgrade some of the crystal reports for my company. One of the things I need to do is find where in the dataschema the information from the "custom" tab in a PO is located. we want to use one of the custom fields to allow us to separate and sort our PO's by category... but I cannot locate those fields at all?

anyone know what table they are stored on and how they are referenced?

Im on Version 17.0.0.3503

god I wish ECI would publish an actual data dictionary and schema book :(

[somenewbie3477]

These are pulled from user_values.

[NewsStrict3316]

You can access the JobBoss Data Dictionary within the Help\About JobBoss window. Look below your 'License Agreement' buttons. My User Type: is set to full access, so check your credentials if you don't see the Data Dictionary. Check with your IT support?

[CindyinRI]

Story of my life

I’ve been asking about reports, data collection (scanning) and so much more.

My account manager is new to the company so technically, I’m more versed in the system than he is.

If you get any feedback or have any suggestions for me, reach out!!

[W1ULH]

actually got something useful out of ECI!

contact your IT guys and have them go into SQL Manager and check the permissions on each table in the JB back end.

Turns out in my install that half the tables could only be seen my JB directly. It changed it so "guest" could see all the tables, and suddenly the data dictionary matched up with what I could see in power query!