Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Add new columns in table CUSTOMRECORD_NCFAR_ASSET

Jinesh Jain User

Connector name: sox_data_eng_netsuite_hourly

 

Table name: CUSTOMRECORD_NCFAR_ASSET 

Column to add:

  1. custrecord_assetname

  2. custrecord_assetcurrency

  3. custrecord_assetaccountingbook

API documentation link:

 

Additional details:

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Rohan Sanjeev Indurkar Fivetranner

    Hi Jinesh,

    We are reviewing the above details and will share an update shortly. 

  • Rohan Sanjeev Indurkar Fivetranner

    Hi Jinesh,

    I checked and none of custrecord_assetname, custrecord_assetcurrency, or custrecord_assetaccountingbook appear in the metadata we receive. Also, the connector has no field allowlist and column discovery runs dynamically against NetSuite's oa_columns metadata view  and CUSTOMRECORD_NCFAR_ASSET is a supported incremental table. We sync whatever oa_columns returns, so "missing from Fivetran" isn't a possible state here.

    It seems to be a source-side gap and not a connector gap. You need to open a ticket with NetSuite to confirm these fields are exposed on the NetSuiteAnalytics Connect record for CUSTOMRECORD_NCFAR_ASSET and that the integration role has the Custom Record permissions covering them. Once they're in oa_columns, they sync automatically and there is no change needed on our side.