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 |
|---|
