| Label |
ID |
Type |
UI Workbook |
SuiteScript / SuiteTalk REST Web Services |
Connect |
| Abbrev. Type |
abbrevtype |
text |
Yes |
Yes |
Yes |
| Account Based Number |
accountbasednumber |
text |
Yes |
Yes |
Yes |
| Action Item |
actionitem |
text |
Yes |
Yes |
Yes |
| Actual Production End Date |
actualproductionenddate |
date |
Yes |
Yes |
Yes |
| Actual Production Start Date |
actualproductionstartdate |
date |
Yes |
Yes |
Yes |
| Actual Shipping Date |
actualshipdate |
date |
Yes |
Yes |
Yes |
| Alt. Sales Range High |
altsalesrangehigh |
currency |
Yes |
Yes |
Yes |
| Alt. Sales Range Low |
altsalesrangelow |
currency |
Yes |
Yes |
Yes |
| Alt. Sales Total |
projaltsalesamt |
currency |
Yes |
Yes |
Yes |
| Amount Paid (Transaction Currency) |
foreignamountpaid |
currency |
Yes |
Yes |
Yes |
| Amount Unpaid (Transaction Currency) |
foreignamountunpaid |
currency |
Yes |
Yes |
Yes |
| Annually |
recurannually |
currency2 |
Yes |
Yes |
Yes |
| AOM Automated |
isaomautomated |
checkbox |
Yes |
Yes |
Yes |
| Approval Status |
approvalstatus |
select |
Yes |
Yes |
Yes |
| As of Date |
asofdate |
date |
Yes |
Yes |
Yes |
| Assignee |
assignee |
select |
Yes |
Yes |
Yes |
| Auto-calculate Lag |
autocalculatelag |
checkbox |
Yes |
Yes |
Yes |
| Available In Customer Center |
visibletocustomer |
checkbox |
Yes |
Yes |
Yes |
| Bid Close Date |
bidclosedate |
date |
Yes |
Yes |
Yes |
| Bid Open Date |
bidopendate |
date |
Yes |
Yes |
Yes |
| Billing Account |
billingaccount |
select |
Yes |
Yes |
Yes |
| Billing Address |
billingaddress |
summary |
Yes |
Yes |
Yes |
| Billing Status |
billingstatus |
checkbox |
Yes |
Yes |
Yes |
| Bill of Materials |
billofmaterials |
select |
Yes |
Yes |
Yes |
| Bill of Materials Revision |
billofmaterialsrevision |
select |
Yes |
Yes |
Yes |
| Budget Approved |
isbudgetapproved |
checkbox |
Yes |
Yes |
Yes |
| Buildable |
committed |
float |
Yes |
Yes |
Yes |
| Bulk Processing Submission |
bulkprocsubmission |
select |
Yes |
Yes |
Yes |
| Business Events Processing History |
businesseventsprocessinghistory |
multiselect |
Yes |
Yes |
Yes |
| Buying Reason |
buyingreason |
select |
Yes |
Yes |
Yes |
| Buying Time Frame |
buyingtimeframe |
select |
Yes |
Yes |
Yes |
| Competitors |
competitors |
sublist |
Yes |
Yes |
Yes |
| Completed Date |
completeddate |
date |
Yes |
Yes |
Yes |
| Created By |
createdby |
select |
Yes |
Yes |
Yes |
| Currency |
currency |
select |
Yes |
Yes |
Yes |
| Date |
trandate |
date |
Yes |
Yes |
Yes |
| Date Closed |
closedate |
date |
Yes |
Yes |
Yes |
| Date Created |
createddate |
datetime |
Yes |
Yes |
Yes |
| Date Last Modified |
lastmodifieddate |
datetime |
Yes |
Yes |
Yes |
| Days Open |
daysopen |
integer |
Yes |
Yes |
Yes |
| Days Overdue |
daysoverduesearch |
integer |
Yes |
Yes |
Yes |
| Deferred Revenue |
deferredrevenue |
currency |
Yes |
Yes |
Yes |
| Deferred Revenue Reclassification Account |
draccount |
select |
Yes |
Yes |
Yes |
| Destination Location |
transferlocation |
select |
Yes |
Yes |
Yes |
| Document Number |
number |
integer |
Yes |
Yes |
Yes |
| Document Number/ID |
tranid |
text |
Yes |
Yes |
Yes |
| Due Date |
duedate |
date |
Yes |
Yes |
Yes |
| Effectivity Based On |
effectivitybasedon |
select |
Yes |
Yes |
Yes |
| Email |
email |
emails |
Yes |
Yes |
Yes |
| End Date |
enddate |
date |
Yes |
Yes |
Yes |
| Enter Manually |
isactualprodenddateenteredmanually |
checkbox |
Yes |
Yes |
Yes |
| Enter Manually |
isactualprodstartdateenteredmanually |
checkbox |
Yes |
Yes |
Yes |
| Entity |
entity |
select |
Yes |
Yes |
Yes |
| Entity Tax Reg. Number |
entitytaxregnum |
select |
Yes |
Yes |
Yes |
| Est. Cost |
totalcostestimate |
currency |
Yes |
Yes |
Yes |
| Est. Gross Profit |
estgrossprofit |
currency |
Yes |
Yes |
Yes |
| Est. Gross Profit Percent |
estgrossprofitpercent |
percent |
Yes |
Yes |
Yes |
| Estimated Budget |
estimatedbudget |
currency |
Yes |
Yes |
Yes |
| Estimates |
estimates |
sublist |
Yes |
Yes |
Yes |
| Exchange Rate |
exchangerate |
currency2 |
Yes |
Yes |
Yes |
| Expected Close Date |
expectedclosedate |
date |
Yes |
Yes |
Yes |
| Expiration Date |
pickupexpirationdate |
date |
Yes |
Yes |
Yes |
| External ID |
externalid |
text |
Yes |
Yes |
Yes |
| Fax |
fax |
phone |
Yes |
Yes |
Yes |
| Finance Charge |
isfinchrg |
checkbox |
Yes |
Yes |
Yes |
| Firmed |
firmed |
checkbox |
Yes |
Yes |
Yes |
| Forecast Type |
forecasttype |
select |
Yes |
Yes |
Yes |
| Foreign Currency Adjustment Revenue Account |
fxaccount |
select |
Yes |
Yes |
Yes |
| Fulfillment Type |
fulfillmenttype |
select |
Yes |
Yes |
Yes |
| Generates Revenue Arrangement |
userevenuearrangement |
checkbox |
Yes |
Yes |
Yes |
| Handling Tax Amount |
basehandlingtaxamount |
currency |
Yes |
Yes |
Yes |
| Handling Tax Amount (Foreign Currency) |
handlingtaxamount |
currency |
Yes |
Yes |
Yes |
| Incoterm |
incoterm |
select |
Yes |
Yes |
Yes |
| Intercompany Status |
intercostatus |
select |
Yes |
Yes |
Yes |
| Internal ID |
id |
integer |
Yes |
Yes |
Yes |
| Inventory Transfer |
linkedinventorytransfer |
select |
Yes |
Yes |
Yes |
| Is Book Specific |
isbookspecific |
checkbox |
Yes |
Yes |
Yes |
| Is Intercompany Adjustment |
intercoadj |
checkbox |
Yes |
Yes |
Yes |
| Is Reversal |
isreversal |
checkbox |
Yes |
Yes |
Yes |
| Item Receipt |
linkedir |
select |
Yes |
Yes |
Yes |
| Item Revision |
revision |
select |
Yes |
Yes |
Yes |
| Journal Type |
journaltype |
select |
Yes |
Yes |
Yes |
| Last Modified By |
lastmodifiedby |
select |
Yes |
Yes |
Yes |
| Lead Source |
leadsource |
select |
Yes |
Yes |
Yes |
| Legacy Tax |
legacytax |
checkbox |
Yes |
Yes |
Yes |
| Line Items |
lineitems |
sublist |
Yes |
Yes |
Yes |
| Linked Tracking Numbers |
linkedtrackingnumberlist |
multiselect |
Yes |
Yes |
Yes |
| Location |
location |
select |
Yes |
Yes |
Yes |
| Manufacturing Routing |
manufacturingrouting |
select |
Yes |
Yes |
Yes |
| Maximum Amount |
maximumamount |
poscurrency |
Yes |
Yes |
Yes |
| Memo |
memo |
text |
Yes |
Yes |
Yes |
| Memorized Transaction Definition |
memdoc |
select |
Yes |
Yes |
Yes |
| Message |
message |
textarea |
Yes |
Yes |
Yes |
| Minimum Amount |
minimumamount |
poscurrency |
Yes |
Yes |
Yes |
| Monthly |
recurmonthly |
currency2 |
Yes |
Yes |
Yes |
| Next Approver |
nextapprover |
select |
Yes |
Yes |
Yes |
| Next Bill Date |
nextbilldate |
date |
Yes |
Yes |
Yes |
| Nexus |
nexus |
select |
Yes |
Yes |
Yes |
| Number of Pricing Tiers |
pricingtiers |
integer |
Yes |
Yes |
Yes |
| One Time |
onetime |
currency2 |
Yes |
Yes |
Yes |
| Opportunity |
opportunity |
select |
Yes |
Yes |
Yes |
| Order Received |
ordreceived |
checkbox |
Yes |
Yes |
Yes |
| Order Type |
ordertype |
select |
Yes |
Yes |
Yes |
| Outsourced |
outsourced |
checkbox |
Yes |
Yes |
Yes |
| Outsourcing Charge |
outsourcingcharge |
select |
Yes |
Yes |
Yes |
| Paired Intercompany Transaction |
intercotransaction |
select |
Yes |
Yes |
Yes |
| Partner |
partner |
select |
Yes |
Yes |
Yes |
| Partners |
partners |
sublist |
Yes |
Yes |
Yes |
| Payment Amount Unused (Transaction Currency) |
foreignpaymentamountunused |
currency |
Yes |
Yes |
Yes |
| Payment Amount Used (Transaction Currency) |
foreignpaymentamountused |
currency |
Yes |
Yes |
Yes |
| Payment Hold |
paymenthold |
checkbox |
Yes |
Yes |
Yes |
| Payment Method |
paymentmethod |
select |
Yes |
Yes |
Yes |
| Payment Option |
paymentoption |
select |
Yes |
Yes |
Yes |
| Payroll Batch |
payrollbatch |
select |
Yes |
Yes |
Yes |
| Picked |
ordpicked |
checkbox |
Yes |
Yes |
Yes |
| Picked Up Date |
pickedupdate |
date |
Yes |
Yes |
Yes |
| Picking Type |
picktype |
select |
Yes |
Yes |
Yes |
| Pick Tasks |
picktasks |
sublist |
Yes |
Yes |
Yes |
| Pickup Email Notification Sent |
ispickupemailnotificationsent |
checkbox |
Yes |
Yes |
Yes |
| Pickup Hold |
pickuphold |
select |
Yes |
Yes |
Yes |
| PO/Check Number |
otherrefnum |
text |
Yes |
Yes |
Yes |
| Posting |
posting |
checkbox |
Yes |
Yes |
Yes |
| Posting Period |
postingperiod |
select |
Yes |
Yes |
Yes |
| Printed Picking Ticket |
printedpickingticket |
checkbox |
Yes |
Yes |
Yes |
| Priority |
priority |
select |
Yes |
Yes |
Yes |
| Probability (%) |
probability |
percent |
Yes |
Yes |
Yes |
| Projected Total |
projectedtotal |
currency |
Yes |
Yes |
Yes |
| Promotion Combinations |
promotioncombinations |
multiselect |
Yes |
Yes |
Yes |
| Promotions |
promotions |
sublist |
Yes |
Yes |
Yes |
| Purchase Order |
linkedpo |
select |
Yes |
Yes |
Yes |
| Purchase Order Instructions |
purchaseorderinstructions |
textarea |
Yes |
Yes |
Yes |
| Quarterly |
recurquarterly |
currency2 |
Yes |
Yes |
Yes |
| Range High |
rangehigh |
currency |
Yes |
Yes |
Yes |
| Range Low |
rangelow |
currency |
Yes |
Yes |
Yes |
| Recognized Revenue |
recognizedrevenue |
currency |
Yes |
Yes |
Yes |
| Record Type |
recordtype |
text |
Yes |
Yes |
Yes |
| Recurring Bill |
recurringbill |
checkbox |
Yes |
Yes |
Yes |
| Related Transactions - Next |
nextlinks |
sublist |
Yes |
Yes |
Yes |
| Related Transactions - Previous |
previouslinks |
sublist |
Yes |
Yes |
Yes |
| Released Date |
releaseddate |
date |
Yes |
Yes |
Yes |
| Rev. Rec. End Date |
revrecenddate |
date |
Yes |
Yes |
Yes |
| Rev. Rec. Schedule |
revrecschedule |
select |
Yes |
Yes |
Yes |
| Rev. Rec. Start Date |
revrecstartdate |
date |
Yes |
Yes |
Yes |
| Revenue Committing Status |
revcommittingstatus |
checkbox |
Yes |
Yes |
Yes |
| Reversal Date |
reversaldate |
date |
Yes |
Yes |
Yes |
| Reversal Doc |
reversal |
select |
Yes |
Yes |
Yes |
| Rev Rec on Rev Commit. |
revreconrevcommitment |
checkbox |
Yes |
Yes |
Yes |
| Sales Readiness |
salesreadiness |
select |
Yes |
Yes |
Yes |
| Sales Rep |
employee |
select |
Yes |
Yes |
Yes |
| Sales Team |
salesteam |
sublist |
Yes |
Yes |
Yes |
| Scheduling Method |
schedulingmethod |
select |
Yes |
Yes |
Yes |
| Ship Complete |
shipcomplete |
checkbox |
Yes |
Yes |
Yes |
| Ship Date |
shipdate |
date |
Yes |
Yes |
Yes |
| Shipment |
transactionshipments |
sublist |
Yes |
Yes |
Yes |
| Shipping Address |
shippingaddress |
summary |
Yes |
Yes |
Yes |
| Shipping Tax Amount |
baseshippingtaxamount |
currency |
Yes |
Yes |
Yes |
| Shipping Tax Amount (Foreign Currency) |
shippingtaxamount |
currency |
Yes |
Yes |
Yes |
| Source |
source |
select |
Yes |
Yes |
Yes |
| Source Transaction |
sourcetransaction |
select |
Yes |
Yes |
Yes |
| Start Date |
startdate |
date |
Yes |
Yes |
Yes |
| Status |
status |
select |
Yes |
Yes |
Yes |
| Status (Customer) |
entitystatus |
select |
Yes |
Yes |
Yes |
| Subsidiary Tax Reg. Number |
subsidiarytaxregnum |
select |
Yes |
Yes |
Yes |
| Tax Details Override |
taxdetailsoverride |
checkbox |
Yes |
Yes |
Yes |
| Tax Point Date |
taxpointdate |
date |
Yes |
Yes |
Yes |
| Tax Point Date Override |
taxpointdateoverride |
checkbox |
Yes |
Yes |
Yes |
| Tax Registration Override |
taxregoverride |
checkbox |
Yes |
Yes |
Yes |
| Tax Total |
basetaxtotal |
currency |
Yes |
Yes |
Yes |
| Tax Total (Foreign Currency) |
taxtotal |
currency |
Yes |
Yes |
Yes |
| Terms |
terms |
select |
Yes |
Yes |
Yes |
| Title |
title |
text |
Yes |
Yes |
Yes |
| To Subsidiary |
tosubsidiary |
select |
Yes |
Yes |
Yes |
| Total After Taxes |
basetotalaftertaxes |
currency |
Yes |
Yes |
Yes |
| Total After Taxes (Foreign Currency) |
totalaftertaxes |
currency |
Yes |
Yes |
Yes |
| Total Amount (Transaction Currency) |
foreigntotal |
currency |
Yes |
Yes |
Yes |
| Tracking Numbers |
trackingnumberlist |
multiselect |
Yes |
Yes |
Yes |
| Transaction |
trandisplayname |
text |
Yes |
Yes |
Yes |
| Transaction Address |
transactionaddress |
sublist |
Yes |
Yes |
Yes |
| Transaction Is VSOE Bundle |
tranisvsoebundle |
checkbox |
Yes |
Yes |
Yes |
| Transaction Line |
transactionlines |
sublist |
Yes |
Yes |
Yes |
| Transaction Number |
transactionnumber |
text |
Yes |
Yes |
Yes |
| Type |
type |
select |
Yes |
Yes |
Yes |
| Type Based Document Number |
typebaseddocumentnumber |
text |
Yes |
Yes |
Yes |
| Unit Price |
outsourcingchargeunitprice |
currency2 |
Yes |
Yes |
Yes |
| Use Item Cost As Transfer Cost |
useitemcostastransfercost |
checkbox |
Yes |
Yes |
Yes |
| Vendor |
vendor |
select |
Yes |
Yes |
Yes |
| Void |
void |
checkbox |
Yes |
Yes |
Yes |
| Voided |
voided |
checkbox |
Yes |
Yes |
Yes |
| Wave Type |
wavetype |
select |
Yes |
Yes |
Yes |
| Website |
website |
select |
Yes |
Yes |
Yes |
| Weekly |
recurweekly |
currency2 |
Yes |
Yes |
Yes |
| Weighted Total |
weightedtotal |
currency |
Yes |
Yes |
Yes |
| Win/Loss Reason |
winlossreason |
select |
Yes |
Yes |
Yes |
| WIP |
iswip |
checkbox |
Yes |
Yes |
Yes |
| Join |
Target Record |
UI Workbook |
SuiteScript / SuiteTalk REST Web Services |
Connect |
| Transaction Line to Commit Criteria (invtCommit.key) |
transaction line (transactionline, transactionline.commitinventory) |
Yes |
Yes |
Yes |
| Transaction Line to Expense Amortization Rule (expenseAmortizationRule.id) |
transaction line (transactionline, transactionline.expenseamortizationrule) |
No |
Yes |
Yes |
| Transaction Line to Price Level (priceLevel.id) |
transaction line (transactionline, transactionline.price) |
No |
Yes |
Yes |
| Transaction Line to Project Task (projectTask.id) |
transaction line (transactionline, transactionline.projecttask) |
No |
Yes |
Yes |
| Partners to Partner (Partner.id) |
partners (transactionpartner, transactionpartner.partner) |
No |
Yes |
Yes |
| Transaction to Employee (employee.id) |
transaction (transaction, transaction.assignee) |
No |
Yes |
Yes |
| Transaction to Address Book (transactionBillingAddressbook.internalid) |
transaction (transaction, transaction.billaddresslist) |
No |
Yes |
Yes |
| Transaction to Address (transactionBillingAddress.nkey) |
transaction (transaction, transaction.billingaddress) |
No |
Yes |
Yes |
| Competitor to Transaction (transaction.id) |
competitor (transactioncompetitor, transactioncompetitor.opportunity) |
No |
Yes |
Yes |
| Transaction to Transaction (transaction.id) |
transaction (transaction, transaction.intercotransaction) |
No |
Yes |
Yes |
| Transaction to Manufacturing Routing (manufacturingRouting.id) |
transaction (transaction, transaction.manufacturingrouting) |
No |
Yes |
Yes |
| Transaction to Employee (employee.id) |
transaction (transaction, transaction.nextapprover) |
No |
Yes |
Yes |
| Transaction to Transaction (transaction.id) |
transaction (transaction, transaction.opportunity) |
No |
Yes |
Yes |
| Partners to Transaction (transaction.id) |
partners (transactionpartner, transactionpartner.transaction) |
No |
Yes |
Yes |
| Transaction to Payroll Batch (payrollBatch.id) |
transaction (transaction, transaction.payrollbatch) |
No |
Yes |
Yes |
| Transaction to Accounting Period (accountingPeriod.id) |
transaction (transaction, transaction.postingperiod) |
No |
Yes |
Yes |
| Transaction to Address (transactionShippingAddress.nkey) |
transaction (transaction, transaction.shippingaddress) |
No |
Yes |
Yes |
| Transaction to Transaction (transaction.id) |
transaction (transaction, transaction.sourcetransaction) |
No |
Yes |
Yes |
| Transaction to Tax Registrations (subsidiaryTaxRegistration.id) |
transaction (transaction, transaction.subsidiarytaxregnum) |
No |
Yes |
Yes |
| Shipment to Transaction (transaction.id) |
shipment (transactionshipment, transactionshipment.doc) |
No |
Yes |
Yes |