Work Order Completion

Internal ID: workordercompletion

Fields

Internal ID	Type	nlapiSubmitField	Label	Required	Help
class	select	false	Class	false	Optionally select a class if you track them.
completedquantity	float	false	Completed Quantity	false	The quantity to be completed shows in this field.
createddate	datetime	false		false
customform	select	false	Custom Form	true
department	select	false	Department	false	Optionally select a department if you track them.
endoperation	select	false	Ending Operation	true	Select a Starting Operation and Ending Operation to define a range. The default component quantity shows for components to be completed within the operation range.
externalid	text	false	ExternalId	false
inventorydetail	summary	false	Inventory Detail	false	After you have entered a quantity to build, click the Inventory Detail button to specify a bin, serial or lot number for the items being processed.
isbackflush	checkbox	false	Backflush	false	Check the Backflush box to enter the completions with backflush. Using backflush means that component consumption is recorded at the same time. Component consumption is based on the proportion designated on the original work order and the build quantity.
item	select	false	Assembly	true	In the Assembly field, select the assembly item you want to complete. A completion can be entered only for assembly items on record. To create new assembly item records, click Assembly at Lists > Accounting > Items > New .
lastmodifieddate	datetime	false		false
location	select	false	Location	true	The location is displayed in this field.
manufacturingrouting	select	false	Manufacturing Routing	false	This field displays the associated routing.
memo	text	true	Memo	false	Optionally enter a memo for this transaction. You can search for text entered here to find the transaction later.
orderquantity	float	false	Work Order Quantity	false	The quantity of assemblies from the work order displays in this field.
postingperiod	select	false	Posting Period	false	Select a posting period for this transaction.
quantity	float	false	Quantity to Build	true	Enter the number of assemblies to record as being completed.
revision	select	false	Revision	false	Select the revision to be used for this completion. For details, click Help and read Revision Control BOM Management .
revisionmemo	text	false	Revision Memo	false
scrapquantity	float	false	Scrap Quantity	false	Enter the quantity to record as being scrapped.
startoperation	select	false	Starting Operation	true	Select a Starting Operation and Ending Operation to define a range. The default component quantity shows for components to be completed within the operation range.
subsidiary	select	false	Subsidiary	false
taxperiod	text	false		false
total	currency	false	Projected Value	false	Unlike on an assembly build, the Projected Value field on a work order completion displays the cost of the assembly, not individual components (unless you use backflush.)
trandate	date	false	Date	true	Select or verify the date for this transaction. The current date autofills this field.
tranid	text	false	Reference #	false	In the Reference # field, you can enter a reference number to track this transaction.
unitcost	float	false	Unit Cost	false
units	select	false	Units	false	The unit of measure for this item is displayed in this field.

Sublists

accountingbookdetail - Accounting Books

Internal ID	Type	Label	Required
accountingbook	select	Secondary Book	false
exchangerate	currency2	Exchange Rate	true

component - Components

Internal ID	Type	Label	Required
componentinventorydetail	summary	Inventory Detail	false
item	text		false
linenumber	integer		false
operationsequencenumber	text	Operation	false
quantity	float	Quantity	true
quantityper	float	Quantity Per	false
unitcost	float		false

operation - Operations

Internal ID	Type	Label	Required
completedquantity	float	Completed Quantity	false
inputquantity	float	Input Quantity	false
laborresources	integer	Labor Resources	false
laborruntime	float	Labor Run Time (Min)	false
laborsetuptime	float	Labor Setup Time (Min)	false
machineresources	integer	Machine Resources	false
machineruntime	float	Machine Run Time (Min)	false
machinesetuptime	float	Machine Setup Time (Min)	false
operationname	text	Operation Name	false
operationsequence	integer	Operation Sequence	false
predecessorcompletedquantity	float	Predecessor Completed Quantity	false
quantityremaining	float	Quantity Remaining	false
recordsetup	checkbox	Record Setup Time	false
runrate	float		false
setuptime	float		false
workcenter	text	Manufacturing Work Center	false

Tabs

Name	Label
components	Components
custom	Custom
history	History
operations	Operations
workflow	Workflow

Search Joins

Join ID	Join Description	Actual 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
partner	Partner	Partner
payrollitem	Payroll Item	Payroll Item
requestor	Requestor	Employee
revision	Revision	Item Revision
salesrep	Sales Rep	Employee
subsidiary	Subsidiary	Subsidiary
task	Task	Task
user	User	Employee
vendor	Vendor	Vendor

Search Filters

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
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	datetime	Date Closed
cogs	checkbox	COGS Line
commissioneffectivedate	date	Commission Effective Date
commit	select	Commit
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
refnumber	integer	Reference Number
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 ID	Type	Label
abbrev	text	Abbrev. Type
account	select	Account
account_grouped	select	Account (Grouped)
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
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
refnumber	integer	Reference Number
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