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?).
Hunting around, the closest I can come is the text field status in OpportinitiesAndEstimates, with the prefix of 'Opportinity : ' removed…
Has this been denormalised, and added to this "extendo" table?
Could I map back to an understandable list by taking the distinct set of entitystatus joined against opportunities in the O&E table with some parsing?