Connector Improvement: NetSuite Connector is not showing all the fields for BOM_REVISIONS & BILL_OF_MATERIALS table.
Not planned
Hi Fivetran Team,
Currently, Our NetSuite connector (netsuite_com_prod) which connects to NetSuite Prod via NetSuite.com and we found In a table (BOM_REVISIONS) there are missing fields.
The following screenshot from NetSuite, The BOM REVISIONS should have Effective Start and Effective End date, however these fields are missing currently in BOM_REVISIONS table.
Fields in BOM_REVISIONS Table:
BOM_REVISION_ID
BILL_OF_MATERIALS_ID
BOM_REVISION_EXTID
DATE_CREATED
DATE_EFFECTIVE
DATE_OBSOLETE
FORM_TEMPLATE_COMPONENT_ID
FORM_TEMPLATE_ID
IS_INACTIVE
MEMO
NAME
_FIVETRAN_DELETED
DATE_DELETED
_FIVETRAN_SYNC
Also, there is another table BILL_OF_MATERIALS which is also missing a field (o9 Routing)
Current Fields in the BILL_OF_MATERIALS table:
BILL_OF_MATERIALS_ID
AVAILABLE_FOR_ALL_ASSEMBLIES
AVAILABLE_FOR_ALL_LOCATIONS
BILL_OF_MATERIALS_EXTID
DATE_CREATED
EXCLUDE_CHILD_SUBSIDIARIES
FORM_TEMPLATE_COMPONENT_ID
FORM_TEMPLATE_ID
IS_INACTIVE
MEMO
NAME
ORIGINAL_ASSEMBLY_ID
USE_COMPONENT_YIELD
_FIVETRAN_DELETED
DATE_DELETED
_FIVETRAN_SYNC
Please help us to get these fields added.
-
Official comment
Hi Rupesh,
Can you confirm if these fields are a formula field or calculated field? We don't support those fields currently.
Thanks,
Frank
-
Thanks Frank !
I checked the BOM_REVISIONS fields (Effective Start and Effective End date) are not custom fields:
However the table BILL_OF_MATERIALS field (o9 Routing) is a custom field:
Regards,
Rupesh
-
Hi Rupesh,
To best assist in this matter I would open a request with Fivetran support as this is not expected behavior.
Thanks,
Frank
Please sign in to leave a comment.
Comments
3 comments