Netsuite schema

9 tables

About the connector Start free

9 tables

Joins between these tables aren't mapped yet.

Loading diagram…

accounttype

10

id

string

longname

string

left

boolean

balancesheet

boolean

includeinrevaldefault

boolean

seqnum

double

defaultcashflowratetype

string

defaultgeneralratetype

string

eliminationalgo

string

_weld_synced

date

accountingperiodfiscalcalendars

3

accountingperiod

string

fiscalcalendar

string

_weld_synced

date

deletedrecord

12

recordtypeid

string

recordid

string

deleteddate

date

type

string

scriptid

string

name

string

deletedby

string

context

string

iscustomrecord

boolean

iscustomlist

boolean

iscustomtransaction

boolean

_weld_synced

date

entity

33

id

string

type

string

entityid

string

entitynumber

double

entitytitle

string

altname

string

firstname

string

middlename

string

lastname

string

inventorynumberlocation

9

inventorynumber

string

location

string

createddate

date

lastmodifieddate

date

quantityavailable

double

quantityintransit

double

quantityonhand

double

quantityonorder

double

_weld_synced

date

item

34

id

string

itemid

string

itemtype

string

displayname

string

fullname

string

description

string

purchasedescription

string

salesdescription

string

parent

string

transaction

106

id

string

recordtype

string

type

string

abbrevtype

string

tranid

string

transactionnumber

string

trandisplayname

string

typebaseddocumentnumber

string

accountbasednumber

string

transactionaccountingline

16

transaction

string

transactionline

string

accountingbook

string

lastmodifieddate

date

account

string

amount

double

debit

double

credit

double

transactionline

68

id

string

transaction

string

lastmodifieddate

date

uniquekey

double

linesequencenumber

double

transactionlinetype

string

itemtype

string

documentnumber

string

memo

string