Work Order

Internal ID: workorder

Fields

Internal IDTypenlapiSubmitFieldLabelRequiredHelp
assemblyitem select false Assembly true Select the assembly you need to build. Click the Open icon to open a list of assembly items. When the item is selected, the components of that assembly show on the items subtab. Once an assembly build is associated with this work order, this field cannot be changed.
autocalculatelag checkbox false Auto-calculate Lag false Check the Auto-calculate Lag box if you want NetSuite to calculate lag times for operation tasks. For more information, click help and read Operations Overlap.
class select false Class false Select a class to associate the assemblies on this work order with a particular class. Your selection here carries over to the assembly build. Click New to set up a new class. Go to <_TABNAME=LIST_CLASS_> > <_TASKCATEGORY=LIST_CLASS_> > Classes for details about existing classes.
createddate datetime false false
createdfrom select false Created From false The Created From field displays the number of the sales order associated with this work order, if any. Note: The Created From field is not available if you are creating a stand-alone work order on the Enter Work Orders page. The Created From field appears only on existing work orders created from sales orders using one of these methods: * By clicking on the Work Ord. link on the line item in the sales order * By automatic work order creation from a sales order when the Create WO field is marked upon saving the sales order
currency text false false
customform select false Custom Form true Select the form to use with this work order. If you customized a sales order form, select it here, or click New to customize a new sales order form.
department select false Department false Select a department to associate the assemblies on this work order with a particular department. Your selection here carries over to the assembly build. Click New to enter a new department. Go to <_TABNAME=LIST_DEPARTMENT_> > <_TASKCATEGORY=LIST_DEPARTMENT_> > Departments for details about existing departments.
enddate date false Production End Date false In the Production End Date field, enter the date you expect to complete assembly production. This field defaults to show the transaction date plus lead time. Note: When you use Demand Planning, the assembly supply is based on the production end date. Using the Manufacturing Routing feature: When you use the Routing and Demand Planning features to generate supply work orders, the function of the Production Start Date field and Production End Date field depend on the selected scheduling method NetSuite uses to calculate production requirements. * Forward Scheduling When you use forward scheduling, you set a production start date and NetSuite calculates the time, materials, and resources required to complete all necessary operations to finish the task. The production end date is determined based on these calculations. When using the Forward Scheduling method, on work orders, the Production Start Date field is required and defaults to the current date. The Production End Date field is grayed out because it will be calculated. * Backward Scheduling When you use backward scheduling, you set the production end date, which is the date you need to have the completed items. Then, based on data from the associated routing, as well as the related work center calendar, NetSuite calculates the time, materials, and resources required to complete all necessary operations. The production start date is determined based on these calculations. When using the Backward Scheduling method, on work orders, the Production End Date field is required. The Production Start Date field is grayed out because it will be calculated. Note: This calculated start date may be a date in the past, prior to the current date. For more details, click Help and read Production Scheduling Methods Overview.
entity select false Customer false Select a customer if you want to associate this work order with a particular customer.
entitynexus select false Nexus false
exchangerate text false false
expandassembly checkbox false Build Sub-Assemblies false If you check the Build Sub-Assemblies box, member items that are assemblies themselves are also built to complete the work order. Then, sub-assembly components are displayed hierarchically on the Items subtab. Clear the box if you do not want to build member assemblies. Once an assembly build is associated with this work order, this field cannot be changed.
externalid text false ExternalId false
firmed checkbox false Firmed false Planned work orders can be either Open or Firmed. * Open &#x2013; Open planned work orders will be deleted before supply planning runs. Clear this box to keep the order Open. * Firmed &#x2013; Firmed planned work orders will NOT be deleted before supply planning runs. Check this box to firm this order.
job select false Project false Select a job if the assemblies on this work order are for a particular job. Click the Open icon to open a list of jobs.
lastmodifieddate datetime false false
location select false Location false Select a location if you track them. The location you select here carries over to the assembly build. If you use the Multi-Location Inventory feature, the location selected is the one that component inventory items are committed from. Note: All items on one work order must be committed from the same location. Items can commit only from the location specified, even if there are no available items at the specified location, and there are items available at another location. Select New to enter a new location record. Go to <_TABNAME=LIST_LOCATION_> > <_TASKCATEGORY=LIST_LOCATION_> > Locations for details about existing location records.
memo text true Memo false Optionally enter a memo for this work order. Later, you can search for the memo text to find this work order.
nexus select false Nexus false
orderstatus text false Status false Select the current status of this order.
quantity posfloat false Quantity true Enter the quantity you want to create of the assembly item. This can be a fractional number, if necessary.
revision select false Revision false For work orders, NetSuite automatically populates the effective revision based on the effective date. If you change the revision selected on the work order, then NetSuite changes the components on the top level assembly based on the revision selected. If you change the revision selected on the work order and the Build Subassembly box is checked, then top-level components will change based on the revision selected and the lower level components are determined based on the effective date.
revisionmemo textarea false Revision Memo false
salesgroup select false Choose Team false
salesrep select true Sales Rep false
schedulingmethod select false Scheduling Method true When you use the Routing and Demand Planning features to generate supply work orders, you can choose the method NetSuite uses to calculate production requirements. These calculations assess the time, materials, and resources required to complete an order and set a start or end date for the production run accordingly. The two methods available are as follows: * Forward Scheduling When you use forward scheduling, you set a production start date and NetSuite calculates the time, materials, and resources required to complete all necessary operations to finish the task. The production end date is determined based on these calculations. When using the Forward Scheduling method, on work orders, the Production Start Date field is required and defaults to the current date. The Production End Date field is grayed out because it will be calculated. * Backward Scheduling When you use backward scheduling, you set the production end date, which is the date you need to have the completed items. Then, based on data from the associated routing, as well as the related work center calendar, NetSuite calculates the time, materials, and resources required to complete all necessary operations. The production start date is determined based on these calculations. When using the Backward Scheduling method, on work orders, the Production End Date field is required. The Production Start Date field is grayed out because it will be calculated. Note: This calculated start date may be a date in the past, prior to the current date. For more details, click Help and read Production Scheduling Methods Overview.
source text false Source false
startdate date false Production Start Date false In the Production Start Date field, enter the date you expect to begin assembly production. This field defaults to show the transaction date. Note: When you use Demand Planning, the component demand is based on the production start date. Using the Manufacturing Routing feature: When you use the Routing and Demand Planning features to generate supply work orders, the function of the Production Start Date field and Production End Date field depend on the selected scheduling method NetSuite uses to calculate production requirements. * Forward Scheduling When you use forward scheduling, you set a production start date and NetSuite calculates the time, materials, and resources required to complete all necessary operations to finish the task. The production end date is determined based on these calculations. When using the Forward Scheduling method, on work orders, the Production Start Date field is required and defaults to the current date. The Production End Date field is grayed out because it will be calculated. * Backward Scheduling When you use backward scheduling, you set the production end date, which is the date you need to have the completed items. Then, based on data from the associated routing, as well as the related work center calendar, NetSuite calculates the time, materials, and resources required to complete all necessary operations. The production start date is determined based on these calculations. When using the Backward Scheduling method, on work orders, the Production End Date field is required. The Production Start Date field is grayed out because it will be calculated. Note: This calculated start date may be a date in the past, prior to the current date. For more details, click Help and read Production Scheduling Methods Overview.
status text false Status false
statusRef text false false
subsidiary select false Subsidiary true If you use OneWorld, select a subsidiary.
syncpartnerteams checkbox false Update Customer false
syncsalesteams checkbox false Update Customer false
trandate date false Date true NetSuite inserts today's date for the date of this work order. You can enter or select another date.
tranid text false Order # false NetSuite increases the largest work order number by one. If you wish, you can enter another number. The next order number will revert to the standard pattern.
units select false Units false If the assembly you select uses Units of Measure, the units are displayed in this field. * New work orders you enter on this form can use only stock units. * Work orders you view that were previously generated by NetSuite display the units for reference only and cannot be changed.

Sublists

accountingbookdetail - Accounting Books

Internal IDTypeLabelRequired
accountingbook select Secondary Book false
exchangerate currency2 Exchange Rate true

item - Items

Internal IDTypeLabelRequired
billvariancestatus text false
catchupperiod select false
commitinventory select Commit false
createpo select Create PO false
createwo checkbox Create WO false
daysbeforeexpiration text false
deferrevrec checkbox false
description textarea Description false
id text false
inventorydetail summary Inventory Detail false
isclosed text false
isvsoebundle text false
item select Item true
itemid text false
itemsubtype text false
itemtype text false
line text false
linenumber integer false
matrixtype text false
operationsequencenumber integer Operation Sequence Number false
options namevaluelist Options false
orderpriority float Order Priority false
plannedissuedate datetime Planned Component Issue Date false
porate currency2 false
povendor text false
printitems text false
quantity float Quantity false
quantityavailable float false
quantitybackordered float Back Ordered false
quantitycommitted float Committed false
quantityfulfilled float Used in Build false
rate rate false
rateschedule text false
units select Units false

partners - Partners

Internal IDTypeLabelRequired
contribution percent Contribution % true
id text false
isprimary checkbox Primary false
partner select Partner true
partnerrole select Partner Role false
transaction text false

salesteam - Sales Team

Internal IDTypeLabelRequired
contribution percent Contribution % true
employee select Employee true
id text false
isprimary checkbox Primary false
issalesrep text false
salesrole select Sales Role true
transaction text false

Tabs

NameLabel
custom Custom
history History
items Items
multipartner Partners
teamselling Sales Team
workflow Workflow

Search Joins

Join IDJoin DescriptionActual Join Name
account Account Account
accountingperiod Accounting Period Accounting Period
billingaddress Billing Address Address
contactprimary Contact (Primary) Contact
customer Customer Customer
customermain Customer (Main Line) Customer
department Department Department
employee Employee Employee
expensecategory Expense Category Expense Category
inventorydetail Inventory Detail Inventory Detail
itemnumber Item Number Inventory Numbers
job Job Job
jobmain Job (Main Line) Job
leadsource Lead Source Campaign
location Location Location
messages Messages Message
mfgplannedtime Manufacturing Planned Time Manufacturing Planned Time
payrollitem Payroll Item Payroll Item
requestor Requestor Employee
revision Revision Item Revision
salesrep Sales Rep Employee
subsidiary Subsidiary Subsidiary
task Task Task
vendor Vendor Vendor

Search Filters

Internal IDTypeLabel
account select Account
accounttype select Account Type
actualshipdate date Actual Ship/Receipt Date
altsalesamount currency Amount (Alt.Sales)
altsalesnetamount currency Amount (Alt.Sales Net)
amount currency Amount
amountpaid currency Amount Paid
amountremaining currency Amount Remaining
amountunbilled currency Amount Unbilled
anylineitem multiselect Item On Any Line
appliedtoforeignamount currency Applied To Link Amount (Foreign Currency)
appliedtoisfxvariance checkbox Applied To Is FxVariance
appliedtolinkamount currency Applied To Link Amount
appliedtolinktype select Applied To Link Type
appliedtotransaction select Applied To Transaction
applyingforeignamount currency Applying Link Amount (Foreign Currency)
applyingisfxvariance checkbox Applying Is FxVariance
applyinglinkamount currency Applying Link Amount
applyinglinktype select Applying Link Type
applyingtransaction select Applying Transaction
approvalstatus select Approval Status
authcode text Auth. Code
autocalculatelag checkbox Auto-calculate Lag
avsstreetmatch select AVS Street Match
avszipmatch select AVS Zip Match
billable checkbox Billable
billaddress textarea Billing Address
billaddressee text Billing Addressee
billattention text Billing Attention
billcity text Billing City
billcountry select Billing Country
billcounty text Billing County/State
billeddate date Date Billed
billingschedule select Billing Schedule
billingstatus checkbox Billing Status
billingtransaction select Billing Transaction
billphone phone Billing Phone
billstate select Billing State/Province
billvariancestatus select Bill Variance Status
billzip text Billing Zip
binnumber text Transaction Bin Number
binnumberquantity float Transaction Bin Quantity
bomquantity float BOM Quantity
bookspecifictransaction checkbox Book Specific Transaction
buildentireassembly checkbox Build Sub-Assemblies
buildvariance float Build Variance
built float Built
catchupperiod select Catch Up Period
cccustomercode text CC Customer Code
ccexpiredate date CC Expire Date
ccname text Credit Cardholder Name
ccnumber ccnumber Credit Card Number
class select Class
cleared checkbox Cleared
closed checkbox Closed
closedate date Date Closed
cogs checkbox COGS Line
commissioneffectivedate date Commission Effective Date
commit select Commit
componentyield float Component Yield
confirmationnumber text Confirmation Number
contribution integer Contribution %
costcomponentamount currency Cost Component Amount
costcomponentcategory select Cost Component Category
costcomponentitem select Cost Component Item
costcomponentquantity float Cost Component Quantity
costcomponentstandardcost float Cost Component Standard Cost
costestimate currency Est. Extended Cost (Line)
costestimaterate currency Est. Unit Cost
costestimatetype select Cost Estimate Type
createdby select Created By
createdfrom select Created From
creditamount currency Amount (Credit)
cscmatch select CSC Match
currency select Currency
customersubof select Customer Sub of
customform select Custom Form
customgl checkbox Custom GL
custtype select Customer Category
datecreated datetime Date Created
daysopen integer Days Open
daysoverdue integer Days Overdue
debitamount currency Amount (Debit)
deferredrevenue currency Amount (Deferred)
deferrevrec checkbox Delay Rev. Rec.
department select Department
depositdate date Date Deposited/Refunded
deposittransaction select Deposit/Refund Transaction
draccount select Deferred Revenue Reclassification Account
duedate date Due Date/Receive By
email text Email
employee select Employee
enddate date End Date
entity select Name
entitystatus select Estimate/Opportunity Status
estgrossprofit currency Est. Gross Profit (Line)
estgrossprofitpct percent Est. Gross Profit Percent (Line)
exchangerate currency Exchange Rate
excludecommission checkbox Exclude Commissions
excludefromraterequest checkbox Exclude Item from Rate Request
expectedclosedate date Expected Close Date
expectedreceiptdate date Expected Receipt Date
expensedate date Expense Date
expreports select Expense Category
externalid select External ID
externalidstring text External ID (Text)
finchrg checkbox Finance Charge
firmed checkbox Firmed
forecasttype select Forecast Type
formuladate date Formula (Date)
formulanumeric float Formula (Numeric)
formulatext text Formula (Text)
fulfillingtransaction select Fulfilling/Receiving Transaction
fxaccount select Foreign Currency Adjustment Revenue Account
fxamount currency Amount (Foreign Currency)
fxcostestimate currency Est. Extended Cost (Line) (Foreign Currency)
fxcostestimaterate currency Est. Unit Cost (Foreign Currency)
fxestgrossprofit currency Est. Gross Profit (Line) (Foreign Currency)
fxtrancostestimate currency Est. Extended Cost (Transaction) (Foreign Currency)
fxvsoeallocation currency VSOE Allocation (Foreign Currency)
fxvsoeamount currency VSOE Amount (Foreign Currency)
fxvsoeprice currency VSOE Price (Foreign Currency)
gcoavailabeltocharge checkbox Available to Charge
gcoavailabletorefund currency Funds Available to Refund
gcoavsstreetmatch text AVS Street Match (Google)
gcoavszipmatch text AVS Zip Match (Google)
gcobuyeraccountage integer Buyer Account Age
gcobuyerip text Buyer IP Address
gcochargeamount currency Requested Charge Amount
gcochargebackamount currency Chargeback Amount
gcoconfirmedchargedtotal currency Charge Amount Confirmed
gcoconfirmedrefundedtotal currency Confirmed Refund Amount
gcocreditcardnumber text Credit Card (Google)
gcocscmatch text CSC Match (Google)
gcofinancialstate text Google Order Financial State
gcofulfillmentstate text Google Order Fulfillment State
gcoorderid text Google Order ID
gcoordertotal currency Google Order Total
gcopromotionamount currency Google Checkout Promotion Amount
gcopromotionname text Google Checkout Promotion
gcorefundamount currency Requested Refund Amount
gcoshippingtotal currency Google Shipping Total
gcostatechangeddetail text Reason for Cancellation
giftcertificate text Gift Certificate
grossamount currency Amount (Gross)
includeinforecast checkbox Include in Forecast
intercostatus select Intercompany Status
intercotransaction select Paired Intercompany Transaction
internalid select Internal ID
internalidnumber integer Internal ID (Number)
invsoebundle checkbox In VSOE Bundle
isallocation checkbox Is Allocation
isbackflush checkbox Backflush
isgcochargeback checkbox Chargeback
isgcochargeconfirmed checkbox Charge Confirmed
isgcopaymentguaranteed checkbox Payment Guaranteed by Google
isgcorefundconfirmed checkbox Refund Confirmed
isintercompanyadjustment checkbox Is Intercompany Adjustment
ispaypalmeth checkbox Is PayPal Payment Method
isreversal checkbox Is Reversal
isrevrectransaction checkbox Is Amortization/Revenue Recognition
isscrap checkbox Is Scrap
isshipaddress checkbox Residential Address
istransferpricecosting checkbox Use Item Cost as Transfer Cost
isvsoealloc checkbox VSOE Allocation Line
iswip checkbox WIP
item select Item
itemrevision select Item Revision
itemsubof select Item Sub of
lastmodifieddate datetime Date Last Modified
leadsource select Lead Source
location select Location
mainline checkbox Main Line
mainname select Main Line Name
matchbilltoreceipt checkbox Match Bill To Receipt
memo text Memo
memomain text Memo (Main)
memorized checkbox Memorized
merchantaccount text Credit Card Processor
message text Message
multisubsidiary checkbox Intercompany
netamount currency Amount (Net)
nextapprover select Next Approver
nextbilldate date Next Bill Date
nonreimbursable checkbox Non-reimbursable
number integer Number
opportunity select Opportunity
otherrefnum text PO/Check Number
packagecount integer Package Count
paidtransaction select Paid Transaction
partner select Partner
partnercontribution integer Partner Contribution %
partnerrole select Partner Role
partnerteammember select Partner Team Member
payingtransaction select Paying Transaction
paymenteventdate datetime Payment Event Date
paymenteventholdreason select Payment Event Hold Reason
paymenteventpurchasecardused checkbox Payment Event Purchase Card Used
paymenteventpurchasedatasent checkbox Payment Event Purchase Data Sent
paymenteventresult select Payment Event Result
paymenteventtype select Payment Event Type
paymentmethod select Payment Method
paypalpending checkbox Pending PayPal Authorization
paypalstatus text PayPal Payment Status
paypaltranid text PayPal Transaction ID
pnrefnum text P/N Ref
poastext text PO/Check ID
posting checkbox Posting
postingperiod period Period
pricelevel select Price Level
printedpickingticket checkbox Printed Picking Ticket
probability integer Probability
projectedamount currency Projected Total
promocode select Promotion
purchaseorder select Purchase Order
quantity float Quantity
quantitybilled float Quantity Billed
quantitycommitted float Quantity Committed
quantitypacked float Quantity Packed
quantitypicked float Quantity Picked
quantityrevcommitted float Quantity Rev. Committed
quantityshiprecv float Quantity Shipped/Received
recognizedrevenue currency Amount (Recognized)
recordtype text Record Type
revcommitstatus select Rev. Commit. Status
revcommittingstatus checkbox Revenue Committing Status
revcommittingtransaction select Revenue Committing Transaction
revenuestatus select Revenue Status
reversaldate date Reversal Date
reversalnumber text Reversal Number
revrecenddate date Rev. Rec. End Date
revreconrevcommitment checkbox Rev. Rec. On Rev. Committment
revrecstartdate date Rev. Rec. Start Date
revrecterminmonths integer Rev. Rec. Term in Months
saleseffectivedate date Sales Effective Date
salesorder select Sales Order
salesrep select Sales Rep
salesteammember select Sales Team Member
salesteamrole select Sales Team Role
schedulingmethod select Scheduling Method
serialnumber text Transaction Serial/Lot Number
serialnumbercost currency Transaction Serial/Lot Amount
serialnumbercostadjustment currency Transaction Serial/Lot Cost Adjustment
serialnumberquantity float Transaction Serial/Lot Number Quantity
shipaddress textarea Shipping Address
shipaddressee text Shipping Addressee
shipattention text Shipping Attention
shipcarrier select Shipping Carrier
shipcity text Shipping City
shipcomplete checkbox Ship Complete
shipcountry select Shipping Country
shipcounty text Shipping County/State
shipdate date Ship Date
shipgroup integer Ship Group
shipmethod select Ship Via
shipphone phone Shipping Phone
shipping checkbox Shipping Line
shiprecvstatus checkbox Fulfillment/Receipt Status
shiprecvstatusline checkbox Fulfillment/Receipt Status (Line Level)
shipstate select Shipping State/Province
shipto select Ship To
shipzip text Shipping Zip
source select Source
startdate date Start Date
status select Status
subsidiary select Subsidiary
taxitem select Tax Item
taxline checkbox Tax Line
taxperiod period Tax Period
taxrate currency Rate
terms select Terms
title text Title
tobeemailed checkbox To Be Emailed
tobeprinted checkbox To Be Printed
tosubsidiary select To Subsidiary
totalamount currency Amount (Transaction Total)
trackingnumbers text Tracking Number
trancostestimate currency Est. Extended Cost (Transaction)
trandate date Date
tranestgrossprofit currency Est. Gross Profit (Transaction)
tranestgrossprofitpct percent Est. Gross Profit Percent (Transaction)
tranfxestgrossprofit currency Est. Gross Profit (Transaction) (Foreign Currency)
tranid text Number/ID
tranisvsoebundle checkbox Transaction Is VSOE Bundle
transactiondiscount checkbox Transaction discount
transactionlinetype select Transaction Line Type
transactionnumber text Transaction Number
transferlocation select To Location
transferorderquantitycommitted float Transfer Order Quantity Committed
transferorderquantitypacked float Transfer Order Quantity Packed
transferorderquantitypicked float Transfer Order Quantity Picked
transferorderquantityreceived float Transfer Order Quantity Received
transferorderquantityshipped float Transfer Order Quantity Fulfilled
type select Type
unit select Units
unitcostoverride currency Unit Cost Override
vendtype select Vendor Category
visibletocustomer checkbox Available In Customer Center
voided checkbox Voided
vsoeallocation currency VSOE Allocation
vsoeamount currency VSOE Amount
vsoedeferral select Deferral
vsoedelivered checkbox Delivered
vsoepermitdiscount select Permit Discount
vsoeprice currency VSOE Price
website select Web Site

Search Columns

Internal IDTypeLabel
abbrev text Abbrev. Type
account select Account
accounttype text Account Type
actualshipdate date Actual Ship/Receipt Date
altsalesamount currency Amount (Alt.Sales)
altsalesnetamount currency Amount (Alt.Sales Net)
amount currency Amount
amountpaid currency Amount Paid
amountremaining currency Amount Remaining
amountunbilled currency Amount Unbilled
appliedtoforeignamount currency Applied To Link Amount (Foreign Currency)
appliedtoisfxvariance checkbox Applied To Link Is FxVariance
appliedtolinkamount currency Applied To Link Amount
appliedtolinktype select Applied To Link Type
appliedtotransaction select Applied To Transaction
applyingforeignamount currency Applying Link Amount (Foreign Currency)
applyingisfxvariance checkbox Applying Link Is FxVariance
applyinglinkamount currency Applying Link Amount
applyinglinktype select Applying Link Type
applyingtransaction select Applying Transaction
approvalstatus select Approval Status
authcode text Auth. Code
autocalculatelag checkbox Auto-calculate Lag
avsstreetmatch text AVS Street Match
avszipmatch text AVS Zip Match
billable checkbox Billable
billaddress text Billing Address
billaddress1 text Billing Address 1
billaddress2 text Billing Address 2
billaddress3 text Billing Address 3
billaddressee text Billing Addressee
billattention text Billing Attention
billcity text Billing City
billcountry select Billing Country
billcountrycode text Billing Country Code
billeddate date Date Billed
billingamount currency2 Billing Amount
billingschedule select Billing Schedule
billingtransaction select Billing Transaction
billphone text Billing Phone
billstate text Billing State/Province
billvariancestatus text Bill Variance Status
billzip text Billing Zip
binnumber text Transaction Bin Number
binnumberquantity float Transaction Bin Quantity
bomquantity float BOM Quantity
buildentireassembly checkbox Build Sub-Assemblies
buildvariance float Build Variance
built float Built
catchupperiod text Catch Up Period
cccustomercode text CC Customer Code
ccexpdate mmyydate CC Expire Date
ccholdername text Credit Cardholder Name
ccnumber ccnumber Credit Card Number
ccstreet text Card Street
cczipcode text Card Zip Code
class select Class
classnohierarchy select Class (no hierarchy)
cleared checkbox Cleared
closed checkbox Closed
closedate date Date Closed
cogsamount currency2 COGS Amount
commissioneffectivedate date Commission Effective Date
commit select Commit
confirmationnumber text Confirmation Number
contribution percent Contribution %
contributionprimary percent Primary Sales Rep Contribution %
costcomponentamount currency Cost Component Amount
costcomponentcategory text Cost Component Category
costcomponentitem text Cost Component Item
costcomponentquantity float Cost Component Quantity
costcomponentstandardcost float Cost Component Standard Cost
costestimate currency Est. Extended Cost (Line)
costestimaterate currency Est. Unit Cost
costestimatetype text Cost Estimate Type
createdby select Created By
createdfrom select Created From
creditamount currency Amount (Credit)
cscmatch text CSC Match
currency select Currency
customform select Custom Form
customgl checkbox Custom GL
custtype select Customer Category
datecreated datetime Date Created
daysopen integer Days Open
daysoverdue integer Days Overdue
debitamount currency Amount (Debit)
deferredrevenue currency Amount (Deferred)
deferrevrec checkbox Delay Rev. Rec.
department select Department
departmentnohierarchy select Department (no hierarchy)
depositdate date Date Deposited/Refunded
deposittransaction select Deposit/Refund Transaction
discountamount currency Amount Discount
draccount text Deferred Revenue Reclassification Account
duedate date Due Date/Receive By
effectiverate currency2 Effective Rate
email email Email
enddate date End Date
entity select Name
entitystatus select Estimate/Opportunity Status
estgrossprofit currency Est. Gross Profit (Line)
estgrossprofitpct percent Est. Gross Profit Percent (Line)
estgrossprofitpercent percent Est. Gross Profit Percent (Transaction)
exchangerate currency2 Exchange Rate
excludecommission checkbox Exclude Commissions
excludefromraterequest checkbox Exclude Item from Rate Request
expectedclosedate date Expected Close
expectedreceiptdate date Expected Receipt Date
expensecategory select Expense Category
expensedate date Expense Date
externalid select External ID
firmed checkbox Firmed
forecasttype select Forecast Type
formulacurrency currency Formula (Currency)
formuladate date Formula (Date)
formuladatetime datetime Formula (Date/Time)
formulanumeric float Formula (Numeric)
formulapercent percent Formula (Percent)
formulatext text Formula (Text)
fulfillingtransaction select Fulfilling/Receiving Transaction
fxaccount text Foreign Currency Adjustment Revenue Account
fxamount currency Amount (Foreign Currency)
fxcostestimate currency Est. Extended Cost (Line) (Foreign Currency)
fxcostestimaterate currency Est. Unit Cost (Foreign Currency)
fxestgrossprofit currency Est. Gross Profit (Line) (Foreign Currency)
fxtrancostestimate currency Est. Extended Cost (Transaction) (Foreign Currency)
fxvsoeallocation currency VSOE Allocation (Foreign Currency)
fxvsoeamount currency VSOE Amount (Foreign Currency)
fxvsoeprice currency2 VSOE Price (Foreign Currency)
gcoavailabeltocharge currency Funds Available to Process
gcoavailabletorefund currency Funds Available to Refund
gcoavsstreetmatch text AVS Street Match (Google)
gcoavszipmatch text AVS Zip Match (Google)
gcobuyeraccountage integer Buyer Account Age
gcobuyerip text Buyer IP Address
gcochargeamount currency Pending Charges
gcochargebackamount currency Chargeback Amount
gcoconfirmedchargedtotal currency Charge Amount Confirmed
gcoconfirmedrefundedtotal currency Confirmed Refund Amount
gcocreditcardnumber text Credit Card (Google)
gcocscmatch text CSC Match (Google)
gcofinancialstate text Google Order Financial State
gcofulfillmentstate text Google Order Fulfillment State
gcoorderid text Google Order ID
gcoordertotal currency Google Order Total
gcopromotionamount currency Google Checkout Promotion Amount
gcopromotionname text Google Checkout Promotion
gcorefundamount currency Pending Refund Amount
gcoshippingtotal currency Google Shipping Total
gcostatechangeddetail text Reason for Cancellation
giftcert text Gift Certificate
grossamount currency Amount (Gross)
includeinforecast checkbox Include in Forecast
intercostatus select Intercompany Status
intercotransaction text Paired Intercompany Transaction
internalid select Internal ID
invsoebundle checkbox In VSOE Bundle
isallocation checkbox Is Allocation
isbackflush checkbox Backflush
isgcochargeback checkbox Chargeback
isgcochargeconfirmed checkbox Charge Confirmed
isgcopaymentguaranteed checkbox Payment Guaranteed by Google
isgcorefundconfirmed checkbox Refund Confirmed
isintercompanyadjustment checkbox Is Intercompany Adjustment
isreversal checkbox Is Reversal
isrevrectransaction checkbox Is Amortization/Revenue Recognition
isscrap checkbox Is Scrap
isshipaddress checkbox Residential Address
istransferpricecosting checkbox Use Item Cost as Transfer Cost
iswip checkbox WIP
item select Item
itemrevision select Item Revision
lastmodifieddate datetime Last Modified
lastviewed datetime Last Viewed
leadsource select Lead Source
line integer Line ID
linesequencenumber integer Line Sequence Number
location select Location
locationnohierarchy select Location (no hierarchy)
mainline text *
mainname select Main Line Name
matchbilltoreceipt checkbox Match Bill To Receipt
memo text Memo
memomain text Memo (Main)
memorized checkbox Memorized
merchantaccount select Credit Card Processor
message text Message
multisubsidiary checkbox Intercompany
netamount currency Amount (Net)
netamountnotax currency Amount (Net of Tax)
nextapprover select Next Approver
nextbilldate date Next Bill Date
nonreimbursable checkbox Non-reimbursable
opportunity select Opportunity
options namevaluelist Options
originator select Originator
otherrefnum text PO/Check Number
packagecount integer Package Count
paidamount currency2 Paid Amount
paidtransaction select Paid Transaction
partner select Partner
partnercontribution percent Partner Contribution %
partnerrole select Partner Role
partnerteammember select Partner Team Member
payingamount currency2 Paying Amount
payingtransaction select Paying Transaction
paymenteventdate datetime Payment Event Date
paymenteventholdreason text Payment Event Hold Reason
paymenteventpurchasecardused checkbox Payment Event Purchase Card Used
paymenteventpurchasedatasent checkbox Payment Event Purchase Data Sent
paymenteventresult text Payment Event Result
paymenteventtype text Payment Event Type
paymentmethod select Payment Method
paypalpending checkbox Pending PayPal Authorization
paypalstatus text PayPal Payment Status
paypaltranid text PayPal Transaction ID
payrollbatch text Payroll Batch
pnrefnum text P/N Ref
porate currency2 PO Rate
posting checkbox Posting
postingperiod select Period
pricelevel select Price Level
print text Print
probability percent Probability
projectedamount currency Projected Total
promocode select Promotion
purchaseorder select Purchase Order
quantity float Quantity
quantitybilled float Quantity Billed
quantitycommitted float Quantity Committed
quantitypacked float Quantity Packed
quantitypicked float Quantity Picked
quantityrevcommitted float Quantity Rev. Committed
quantityshiprecv float Quantity Fulfilled/Received
quantityuom float Quantity in Transaction Units
rate currency2 Item Rate
realizedgainpostingtransaction select Realized Gain Posting Transaction
recognizedrevenue currency Amount (Recognized)
recordtype text Record Type
revcommitstatus text Rev. Commit. Status
revcommittingtransaction select Revenue Committing Transaction
revenuestatus text Revenue Status
reversaldate date Reversal Date
reversalnumber text Reversal Number
revrecenddate date Rev. Rec. End Date
revreconrevcommitment checkbox Rev. Rec. On Rev. Committment
revrecstartdate date Rev. Rec. Start Date
rgaccount select Realized Gain Account
rgamount currency Realized Gain Amount
saleseffectivedate date Sales Effective Date
salesorder select Sales Order
salesrep select Sales Rep
salesteammember select Sales Team Member
salesteamrole select Sales Team Role
schedulingmethod text Scheduling Method
serialnumber text Transaction Serial/Lot Number
serialnumbercost currency Transaction Serial/Lot Number Amount
serialnumbercostadjustment currency Transaction Serial/Lot Number Cost Adjustment
serialnumberquantity float Transaction Serial/Lot Number Quantity
serialnumbers text Serial/Lot Numbers
shipaddress text Shipping Address
shipaddress1 text Shipping Address 1
shipaddress2 text Shipping Address 2
shipaddress3 text Shipping Address 3
shipaddressee text Shipping Addressee
shipattention text Shipping Attention
shipcarrier select Shipping Carrier
shipcity text Shipping City
shipcomplete checkbox Ship Complete
shipcountry select Shipping Country
shipcountrycode text Shipping Country Code
shipdate date Ship Date
shipgroup integer Ship Group
shipmethod select Ship Via
shipphone text Shipping Phone
shippingamount currency Amount (Shipping)
shiprecvstatusline checkbox Fulfilled/Received (Line Level)
shipstate text Shipping State/Province
shipto select Ship To
shipzip text Shipping Zip
signedamount currency Amount (Signed)
source select Source
startdate date Start Date
statusref select Status
subsidiary select Subsidiary
subsidiarynohierarchy select Subsidiary (no hierarchy)
taxamount currency Amount (Tax)
taxcode select Tax Item
taxline checkbox Tax Line
taxperiod select Tax Period
taxtotal currency Amount (Tax Total)
terminmonths integer Rev. Rec. Term in Months
terms select Terms
title text Title
tobeemailed checkbox To Be Emailed
tobeprinted checkbox To Be Printed
tosubsidiary select To Subsidiary
tosubsidiarynohierarchy select To Subsidiary (no hierarchy)
total currency Amount (Transaction Total)
totalcostestimate currency Est. Extended Cost (Transaction)
trackingnumbers text Tracking Numbers
trandate date Date
tranestgrossprofit currency Est. Gross Profit (Transaction)
tranfxestgrossprofit currency Est. Gross Profit (Transaction) (Foreign Currency)
tranid text Number
tranisvsoebundle checkbox Transaction Is VSOE Bundle
transactiondiscount checkbox Transaction Discount
transactionlinetype select Transaction Line Type
transactionnumber text Transaction Number
transferlocation select To Location
transferorderitemline text Transfer Order Item Line Id
transferorderquantitycommitted float Transfer Order Quantity Committed
transferorderquantitypacked float Transfer Order Quantity Packed
transferorderquantitypicked float Transfer Order Quantity Picked
transferorderquantityreceived float Transfer Order Quantity Received
transferorderquantityshipped float Transfer Order Quantity Shipped
type select Type
unit text Units
unitcostoverride currency Unit Cost Override
vendtype select Vendor Category
visibletocustomer checkbox Available In Customer Center
vsoeallocation currency VSOE Allocation
vsoeamount currency VSOE Amount
vsoedeferral text Deferral
vsoedelivered checkbox Delivered
vsoepermitdiscount text Permit Discount
vsoeprice currency2 VSOE Price
website text Web Site