NetSuite Data Dictionary
- 26 Feb 2024
- 1 Minute to read
- Print
- DarkLight
- PDF
NetSuite Data Dictionary
- Updated on 26 Feb 2024
- 1 Minute to read
- Print
- DarkLight
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
Panoply utilizes NetSuite's REST API to collect data into your Panoply data warehouse.
Metadata
Panoply inserts the following metadata fields into each table collected:
__account_id
: The connected NetSuite account id.__resource
: The name of the selected resource.
NetSuite Endpoints
The Netsuite TBA data source also supports custom records on top of the available records described below.
Custom Lists are available for selection and can be identified by both the list name and the list identifier
Panoply supports up to 117 different endpoints:
- account
- accountingBook
- accountingContext
- accountingPeriod
- activity
- amortizationSchedule
- amortizationTemplate
- billingAccount
- billingClass
- billingRateCard
- billingRevenueEvent
- billingSchedule
- bin
- bom
- bomRevision
- budgetCategory
- budgetExchangeRate
- budgets
- budgetsMachine
- calendarEvent
- campaignResponse
- campaignTemplate
- cardholderAuthentication
- charge
- chargeRule
- classification
- competitor
- consolidatedExchangeRate
- contact
- contactCategory
- contactRole
- costCategory
- couponCode
- currency
- customer
- customerCategory
- customInstallmentPercent
- customerMessage
- customerSubsidiaryRelationship
- customField
- department
- emailTemplate
- employee
- entity
- entityAddress
- expenseCategory
- fairValuePrice
- fixedAmountProjectRevenueRule
- fulfillmentRequest
- genericResource
- giftCertificate
- globalInventoryRelationship
- inboundShipment
- inventoryNumber
- inventoryStatus
- item
- itemDemandPlan
- itemLocationConfiguration
- itemSupplyPlan
- job
- jobStatus
- jobType
- location
- manufacturingCostTemplate
- manufacturingOperationTask
- manufacturingRouting
- merchandiseHierarchyLevel
- merchandiseHierarchyNode
- merchandiseHierarchyVersion
- message
- mfgPlannedTime
- nexus
- note
- otherName
- otherNameCategory
- partner
- paymentMethod
- payrollItem
- pctCompleteProjectRevenueRule
- phoneCall
- plannedOrder
- planningItemCategory
- planningItemGroup
- planningRuleGroup
- previousTransactionLink
- priceLevel
- pricingGroup
- projectExpenseType
- projectTask
- projectTemplate
- promotionCode
- revenuePlan
- salesInvoiced
- salesOrdered
- salesTaxItem
- searchCampaign
- shipItem
- solution
- statisticalJournalEntry
- storePickupFulfillment
- subsidiary
- supplyChainSnapshot
- supplyChainSnapshotSimulation
- supplyChangeOrder
- supplyPlanDefinition
- supportCase
- systemNote
- task
- taxType
- term
- timeBill
- timeSheet
- topic
- transaction
- transactionBilling
- transactionAccountingLine
- transactionHistory
- transactionLine
- transactionSalesTeam
- transactionShipment
- transactionStatus
- unitsType
- usage
- vendor
- vendorCategory
- vendorSubsidiaryRelationship
- webSite
Was this article helpful?