Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
In SuiteAnalytics schema NetSuite2, where is the equivalent to company_status?
Sorry if this is in the wrong place.
I'm trying to map our old reporting against suiteanalytics connect odbc/jdbc from the netsuite.com schema to the netsuite2.com schema.
I'm trying to track down the equivalent of COMPANY_STATUS from the netsuite.com schema
The mapping doc shows:
TRANSACTIONS | COMPANY_STATUS_ID | Transaction | opportunity^transaction.entitystatus | Status (Customer) |
|---|
and entitystatus in transaction according to the metadata is a fk to customerstatus.CONSTRAINT transaction_entitystatus_customerStatus_id FOREIGN KEY (entitystatus) REFERENCES "Data Warehouse Integrator".customerStatus(id) ON DELETE CASCADE ON UPDATE CASCADE
But customerstatus is empty (should role 57/DWI see everything like this?).
0