ODBC Driver for NetSuite

Build 24.0.9060

RevenueElement

The RevenueElement table.

Columns

Name Type References Description
SourceRecordType Boolean SourceRecordType
Itemisautoexpand String Itemisautoexpand
AccountingBook Integer AccountingBook
Allocatedcontractcostamount Float Allocatedcontractcostamount
AllocationType String AllocationType
AlternateQuantity Float AlternateQuantity
AlternateUnits Integer AlternateUnits
AlternateUnitsType Integer AlternateUnitsType
AmortizationEndDate Date AmortizationEndDate
AmortizationSchedule Integer AmortizationSchedule
AmortizationStartDate Date AmortizationStartDate
AmortizationTemplate Integer AmortizationTemplate
FairValue Float FairValue
CalculatedAmount Float CalculatedAmount
Carveinratio Percent Carveinratio
Carveoutratio Percent Carveoutratio
Class Integer Class
Contractcostallocationpct Percent Contractcostallocationpct
ContractExpenseAcct Integer ContractExpenseAcct
ContractExpenseOffsetAcct Integer ContractExpenseOffsetAcct
CostAmortizationAmount Float CostAmortizationAmount
CreateRevenuePlansOn Integer CreateRevenuePlansOn
Currency Integer Currency
Entity Integer Entity
DeferralAccount Integer DeferralAccount
DeferContractExpenseAcct Integer DeferContractExpenseAcct
JournalEntry Integer JournalEntry
Delivered Boolean Delivered
Department Integer Department
DiscountedSalesAmount Float DiscountedSalesAmount
EffectiveEndDate Date EffectiveEndDate
EffectiveStartDate Date EffectiveStartDate
ContingentRevenueHandling Boolean ContingentRevenueHandling
RevRecEndDate Date RevRecEndDate
ExchangeRate Float ExchangeRate
TreatmentOverride Boolean TreatmentOverride
Expensemigrateadjaccount Integer Expensemigrateadjaccount
ExternalId String ExternalId
FairValueOverride Boolean FairValueOverride
Forecastenddate Date Forecastenddate
ForecastStartDate Date ForecastStartDate
Revreclassfxaccount Integer Revreclassfxaccount
Fullname String Fullname
Id [KEY] Integer Id
IsBOMItemType Boolean IsBOMItemType
IsVsoePrice Boolean IsVsoePrice
Item Integer Item
Itemlaborcostamount Float Itemlaborcostamount
Itemresalecostamount Float Itemresalecostamount
Labordeferredexpenseacct Integer Labordeferredexpenseacct
Laborexpenseacct Integer Laborexpenseacct
LastMergedFromArrangement Integer LastMergedFromArrangement
LastModifiedDate Datetime LastModifiedDate
ReturnOfElement Integer ReturnOfElement
Location Integer Location
RecordNumber String RecordNumber
Originalchangeorderdiscamount Float Originalchangeorderdiscamount
Originalchangeorderquantity Float Originalchangeorderquantity
CarveOverride Boolean CarveOverride
ParentBOMElement Integer ParentBOMElement
PermitDiscount Boolean PermitDiscount
PostingDiscountApplied Boolean PostingDiscountApplied
Quantity Float Quantity
RecognitionAccount Integer RecognitionAccount
RecognitionTreatment Integer RecognitionTreatment
ReferenceId String ReferenceId
Requiresrevenueplanupdate Boolean Requiresrevenueplanupdate
Residualdiscsalesamount Currency Residualdiscsalesamount
RevenueAllocationGroup Integer RevenueAllocationGroup
RevenueAllocationRatio Percent RevenueAllocationRatio
AllocationAmount Float AllocationAmount
RevenueArrangement Integer RevenueArrangement
Revenuemigrateadjaccount Integer Revenuemigrateadjaccount
Revenueplanstatus String Revenueplanstatus
RevenueRecognitionRule Integer RevenueRecognitionRule
RevRecForecastRule Integer RevRecForecastRule
SalesAmount Float SalesAmount
Source String Source
ElementDate Date ElementDate
RevRecStartDate Date RevRecStartDate
SubscriptionLine String SubscriptionLine
Subsidiary Integer Subsidiary
Carveinamount Float Carveinamount
Carveoutamount Float Carveoutamount
TermInDays Integer TermInDays
TermInMonths Integer TermInMonths
NewStandardMigrateDate Date NewStandardMigrateDate
UnbilledReceivableGroup String UnbilledReceivableGroup
Units String Units

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060