JDBC Driver for NetSuite

Build 22.0.8462

transaction

The transaction table.

Columns

Name Type References Description
id [KEY] Integer Internal ID
abbrevtype String Abbrev. Type
accountbasednumber String Account Based Number
actionitem String Action Item
actualproductionenddate Date Actual Production End Date
actualproductionstartdate Date Actual Production Start Date
actualshipdate Date Actual Shipping Date
approvalstatus String Approval Status
asofdate Date As of Date
autocalculatelag Boolean Auto-calculate Lag
billingaddress String Billing Address
billingstatus Boolean Billing Status
billofmaterials String Bill of Materials
billofmaterialsrevision String Bill of Materials Revision
buyingreason String Buying Reason
buyingtimeframe String Buying Time Frame
closedate Date Date Closed
committed Double Buildable
createdby String Created By
createddate Date Date Created
currency String Currency
daysopen Double Days Open
daysoverduesearch Integer Days Overdue
duedate Date Due Date
employee String Sales Rep
enddate Date End Date
entity String Entity
entitystatus String Status (Customer)
estgrossprofit Decimal Est. Gross Profit
estgrossprofitpercent Double Est. Gross Profit Percent
estimatedbudget Decimal Estimated Budget
exchangerate Decimal Exchange Rate
expectedclosedate Date Expected Close Date
externalid String External ID
firmed Boolean Firmed
forecasttype String Forecast Type
foreignamountpaid Decimal Amount Paid (Transaction Currency)
foreignamountunpaid Decimal Amount Unpaid (Transaction Currency)
foreignpaymentamountunused Decimal Payment Amount Unused (Transaction Currency)
foreignpaymentamountused Decimal Payment Amount Used (Transaction Currency)
foreigntotal Decimal Total Amount (Transaction Currency)
fulfillmenttype String Fulfillment Type
incoterm String Incoterm
isactualprodenddateenteredmanually Boolean Enter Manually
isactualprodstartdateenteredmanually Boolean Enter Manually
isbookspecific Boolean Is Book Specific
isbudgetapproved Boolean Budget Approved
isfinchrg Boolean Finance Charge
isreversal Boolean Is Reversal
journaltype String Journal Type
lastmodifiedby String Last Modified By
lastmodifieddate Date Date Last Modified
leadsource String Lead Source
linkedtrackingnumberlist String Linked Tracking Numbers
manufacturingrouting String Manufacturing Routing
memdoc String Memorized Transaction Definition
memo String Memo
message String Message
nextapprover String Next Approver
nextbilldate Date Next Bill Date
nexus String Nexus
number Long Document Number
opportunity String Opportunity
ordpicked Boolean Picked
ordreceived Boolean Order Received
otherrefnum String PO/Check Number
partner String Partner
paymenthold Boolean Payment Hold
paymentmethod String Payment Method
paymentoption String Payment Option
posting Boolean Posting
postingperiod String Posting Period
printedpickingticket Boolean Printed Picking Ticket
probability Double Probability (%)
projectedtotal Decimal Projected Total
rangehigh Decimal Range High
rangelow Decimal Range Low
recordtype String Record Type
reversal String Reversal Doc
reversaldate Date Reversal Date
salesreadiness String Sales Readiness
schedulingmethod String Scheduling Method
shipcomplete Boolean Ship Complete
shipdate Date Ship Date
shippingaddress String Shipping Address
source String Source
sourcetransaction String Source Transaction
startdate Date Start Date
status String Status
terms String Terms
title String Title
tosubsidiary String To Subsidiary
totalcostestimate Decimal Est. Cost
trackingnumberlist String Tracking Numbers
trandate Date Date
trandisplayname String Transaction
tranid String Document Number/ID
transactionnumber String Transaction Number
transferlocation String Destination Location
type String Type
typebaseddocumentnumber String Type Based Document Number
useitemcostastransfercost Boolean Use Item Cost As Transfer Cost
userevenuearrangement Boolean Generates Revenue Arrangement
visibletocustomer Boolean Available In Customer Center
void Boolean Void
voided Boolean Voided
website String Website
weightedtotal Decimal Weighted Total
winlossreason String Win/Loss Reason

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462