Listed below are the tables which can be used for your own registration reporting:
Orders (ER100_ACCT_ORDER) - Contains all service, membership, fulfillment, registration and statistics orders in the system. Registrant orders have an Order Type (ER100_ORD_TYPE) of ER.
Order Items (ER101_ACCT_ORDER_DTL) - Contains all items of all phases for every order in the system. If there are multiple registrants per order they will be detailed in this table in the ER101_REG_ACCT field.
Event Registrant Types (ER131_EVT_REG_TYPES) - Contains all the registrant types attached to each event.
Event Registrants (ER110_EVT_REGIS) - Contains all the registrants tied to orders and order items.
Event Registrant Type Items (ER132_EVT_REG_TYPE_ITEMS) - Contains all the resource items available to be ordered by registrant types on an event.
Event Registrants (ER150_EVT_REGISTRANTS) - Contains all the registrants on an event. A registrant will be represented in this table only one time for each event regardless of the number of orders the registrant is tied to.
Event Registration Item Rates (ER109_REG_RATES) - Contains the rates, including tiered rates, for all event registration items.
Event Registration/Service Limit Capacities (ER103_RES_MINMAX) - Contains the minimum and maximum registration and service limit capacities allowed for events, function and items. Also has pricing information and display formats for registration items.
Exhibitor Registration Rules Details (ER141_EXH_REG_RULES_DTL) - Contains the Exhibitor Registration Rules Details information.
Exhibitor Registration Rules Header (ER140_EXH_REG_RULES_HDR) - Contains the header information of the exhibitor registration rules.
Comments
3 comments
I am trying to use the Registration Order Items grid for some sales analysis. I need to report by Salesperson. There is no Salesperson as such but I am hoping to use the Account Rep instead.
The Order Account Rep defaults to the Account's Rep (which is fine) and can be manually updated on the order itself.
The issue is that the Order Account Rep column is not available on the Registration Order Items grid. Only the Account Rep is available.
Eg,
I add an Order for Company ABC. The Account Rep on that company is Mary. I then update the Order Account Rep to be John. When I look at the Order Items grid, I can only display Mary against the items and not John.
Please update to allow the Order Rep as a display column on the Items grid.
0 upvotes
Hi Sean,
I passed this on to our Registration Product Managers. I understand where you are coming from - I run into the same problem when I'm doing reporting from this screen as well.
Thanks,
Maggie
1 upvotes
Thanks Maggie,
Seems like a simple omission to rectify. Appreciate you passing it on.
0 upvotes
Please sign in to leave a comment.