I'm migrating our SuiteAnalytics connect reporting from the netsuite.com schema to the netsuite2.com schema.
I'm having problems finding the equivalent of the EVENTS1 table in the netsuite2.com schema.
The NS_TO_NS2.xls doc quite clearly says it's CalendarEvent
However this table doesn't have the same records at all, and the primary key as described in oa_keys is not unique.
select * from oa_fkeys where fktable_name is null and pktable_name='CalendarEvent' order by pktable_name, key_seq;
PKTABLE_QUALIFIER | PKTABLE_OWNER | PKTABLE_NAME | PKCOLUMN_NAME | FKTABLE_QUALIFIER | FKTABLE_OWNER | FKTABLE_NAME | FKCOLUMN_NAME | KEY_SEQ | UPDATE_RULE | DELETE_RULE | FK_NAME | PK_NAME |
|---|
… | Data Warehouse Integrator | CalendarEvent | id | | | | | 1 | | | | CalendarEvent_PK |
Is there a way of getting the EVENTS1 data?