Internal ID | Type | nlapiSubmitField | Label | Required | Help |
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 – Open planned work orders will be deleted before supply planning runs.
Clear this box to keep the order Open.
* Firmed – 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. |
Internal ID | Type | Label |
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 |
Internal ID | Type | Label |
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 |