Internal ID | Type | nlapiSubmitField | Label | Required | Help |
account |
select
|
false |
Account |
false |
|
approvalstatus |
select
|
false |
Approval Status |
false |
The approval status of this bill shows in this field.
Accept the default status or choose one of the following:
* Approved – No further review or processing is required before a payment is processed.
* Pending Approval – Someone with permission must approve the bill before a payment can be processed for it. |
availablevendorcredit |
currency
|
false |
Available Vendor Credit |
false |
|
balance |
text
|
false |
|
false |
|
billaddresslist |
select
|
false |
Vendor Select |
false |
In the Vendor Select field, choose a vendor.
Verify the billing address displayed in the Vendor field. |
billingaddress |
summary
|
false |
|
false |
|
class |
select
|
false |
Class |
false |
|
createddate |
datetime
|
false |
|
false |
|
creditlimit |
currency
|
false |
Credit Limit |
false |
The credit limit you entered for your purchases from this vendor will appear here.
To enter or change a credit limit, go to <_TABNAME=LIST_VENDOR_> > <_TASKCATEGORY=LIST_VENDOR_> > Vendors. On the vendor record's Financial tab, enter the credit limit.
NetSuite will warn you when you meet or exceed this vendor's limit while you are entering orders if you go to Home > Set Preferences and check the Credit Limit Warnings box. |
currency |
select
|
false |
Currency |
true |
The transaction currency for this bill is shown here.
If this bill was created from a purchase order, the currency on the originating purchase order is shown, and you cannot change the currency on the bill. |
currencyname |
text
|
false |
Currency |
false |
This vendor's currency is shown in this field.
All currency amounts on this transaction are shown in this currency. |
currencysymbol |
text
|
false |
Currency Symbol |
false |
|
customform |
select
|
false |
Custom Form |
true |
|
department |
select
|
false |
Department |
false |
|
discountamount |
currency
|
false |
Disc. Amt. |
false |
NetSuite enters the amount discounted on this bill.
This discount is based on the purchase order terms. For example, if terms are set as 2%-10, Net 30 and the bill is paid within 10 days, a 2% discount is applied.
If this discount item is taxable, the discount is applied before taxes. If it is not taxable, the discount is applied after taxes. |
discountdate |
date
|
false |
Disc. Date |
false |
If your vendor offers discounts for early payments on bills, a calculated date based on the terms of the bill automatically shows up in this field. This date is the last day you can pay this bill in order to receive a discount. |
documentstatus |
text
|
false |
|
false |
|
duedate |
date
|
false |
Due Date |
false |
NetSuite inserts today's date. You can type or pick another date. If you do not assign a due date, this bill will not appear on aging reports. |
entity |
select
|
false |
Vendor |
true |
Select the vendor for this purchase. Click New to set up a new vendor.
Go to <_TABNAME=LIST_VENDOR_> > <_TASKCATEGORY=LIST_VENDOR_> > Vendors for details about existing vendors.
Note: If you use NetSuite OneWorld, the Subsidiary field defaults to the primary subsidiary assigned to the selected vendor. If the selected vendor has been shared with multiple secondary subsidiaries, you can select the secondary subsidiary to associate with this bill. |
entitynexus |
select
|
false |
Nexus |
false |
|
exchangerate |
currency2
|
false |
Exchange Rate |
true |
The currency's exchange rate is shown in this field.
You can edit the exchange rate for this transaction only, or you can update the currency record with the exchange rate you enter here. |
externalid |
text
|
false |
ExternalId |
false |
|
isbasecurrency |
checkbox
|
false |
Base Currency |
false |
|
landedcostperline |
checkbox
|
false |
Landed Cost per Line |
false |
Check this box to enter a landed cost per line item. |
lastmodifieddate |
datetime
|
false |
|
false |
|
location |
select
|
false |
Location |
true |
|
memo |
text
|
true |
Memo |
false |
|
nextapprover |
select
|
false |
Next Approver |
false |
This field displays the next person set to approve this bill via approval routing. |
nexus |
select
|
false |
Nexus |
false |
|
paymenthold |
checkbox
|
false |
Payment Hold |
false |
Check the Payment Hold box to apply a payment hold on a disputed bill. When the Payment Hold box is checked, the following occurs:
* The Make Payment button is not be available on the vendor bill and a vendor payment cannot be processed for that bill.
* Vendor bills that have a Payment Hold enabled do not show up on the Bill Payments page.
* The Electronic Payment SuiteApp does not process payments that have a payment hold. |
postingperiod |
select
|
false |
Posting Period |
true |
Select the period to which you want to post this transaction.
You cannot post to a closed period. |
received |
text
|
false |
Received Bill |
false |
|
status |
text
|
false |
Status |
false |
|
statusRef |
text
|
false |
|
false |
|
subsidiary |
select
|
false |
Subsidiary |
false |
|
terms |
select
|
false |
Terms |
false |
Select discount terms that apply to this bill.
To add additional choices to this list, go to <_TABNAME=LIST_ACCOUNTINGOTHERLIST_> > <_TASKCATEGORY=LIST_ACCOUNTINGOTHERLIST_> > Accounting Lists > Terms. |
total |
currency
|
false |
Amount |
false |
|
trandate |
date
|
false |
Date |
true |
NetSuite inserts today's date for the posting date of this bill. You can type or pick another date.
What you enter here determines the date range in which this transaction appears on the Accounts Payable Register.
You can select or enter custom date ranges on registers. |
tranid |
text
|
false |
Reference No. |
false |
Enter up to 45 characters to identify this transaction, such as the vendor's invoice number. This reference appears on reports such as the Accounts Payable Register.
Note: The maximum number of characters you can enter in this field is 45. |
transactionnumber |
text
|
false |
Transaction Number |
false |
By default, transaction lists display only the Number field in searches and reporting. If you plan to include the new Transaction Number field, be aware that this value will be the different from the value in the Number field for the twelve transaction types available through Version 2014 Release 1.
For the transaction types available through previous releases, these two values will be the same.
Note: The Transaction Number field is visible by default on standard NetSuite forms and invisible by default on customized forms. You can, however, customize a form to display this field. |
unbilledorders |
text
|
false |
|
false |
|
usertotal |
currency
|
false |
Amount |
false |
You can enter the dollar amount of the bill, but NetSuite will update this amount as you add or edit line items. |
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 |
date |
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 |
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 |
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 |
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 |