JDBC Driver for NetSuite

Build 23.0.8839

purchaseorder

The purchaseorder table.

Columns

Name Type References Description
approvalstatus String Approvalstatus
availablevendorcredit Decimal Availablevendorcredit
balance Decimal Balance
billaddress String Billaddress
billingaddress String Billingaddress
billisresidential String Billisresidential
class String Class
createddate Datetime Createddate
createdfrom String Createdfrom
currency String Currency
currencyname String Currencyname
currencysymbol String Currencysymbol
customform String Customform
department String Department
duedate Date Duedate
email String Email
employee String Employee
entity String Entity
entitynexus String Entitynexus
entitytaxregnum String Entitytaxregnum
exchangerate Decimal Exchangerate
externalid String Externalid
fob String Fob
incoterm String Incoterm
intercostatus String Intercostatus
intercotransaction String Intercotransaction
isbasecurrency Boolean Isbasecurrency
lastmodifieddate Datetime Lastmodifieddate
linkedtrackingnumbers String Linkedtrackingnumbers
location String Location
memo String Memo
message String Message
nextapprover String Nextapprover
nexus String Nexus
orderstatus String Orderstatus
otherrefnum String Otherrefnum
purchasecontract String Purchasecontract
returntrackingnumbers String Returntrackingnumbers
shipaddress String Shipaddress
shipdate Date Shipdate
shipisresidential String Shipisresidential
shipmethod String Shipmethod
shipoverride String Shipoverride
shippingaddress String Shippingaddress
shipto String Shipto
source String Source
status String Status
statusref String Statusref
subsidiary String Subsidiary
subsidiarytaxregnum String Subsidiarytaxregnum
supervisorapproval Boolean Supervisorapproval
taxdetailsoverride Boolean Taxdetailsoverride
taxpointdate Date Taxpointdate
taxpointdateoverride Boolean Taxpointdateoverride
taxregoverride Boolean Taxregoverride
terms String Terms
tobeemailed Boolean Tobeemailed
tobefaxed Boolean Tobefaxed
tobeprinted Boolean Tobeprinted
total Decimal Total
trackingnumbers String Trackingnumbers
trandate Date Trandate
tranid String Tranid
unbilledorders Decimal Unbilledorders

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