Delivery Fields for NetSuite Transactional Messages

Delivery tags reference data from NetSuite and makes it available to use in your message. Using delivery tags in your message does not import the order from NetSuite.

The full set of transaction/order and customer variables are available for all messages. Fulfillment variables are limited to the Order Fulfilled message.

Table 1. Order header-level fields
Delivery Field NetSuite Field Description
%%#order_tranid%% tranid The internal ID number for the transaction
%%#order_trandate%% trandate Order creation date
%%#order_total%% total Total
%%#order_subtotal%% subtotal Subtotal
%%#order_taxtotal%% taxtotal Tax Amount
%%#order_discounttotal%% discounttotal Amount discounted on this order
%%#order_status%% status Order status
%%#order_currencysymbol%% currencysymbol Description
%%#order_shippingcost%% shippingcost Shipping cost
%%#order_shipdate%% shipdate Shipping date
%%#order_shipmethod%% shipmethod Shipping service; for example, FedEx
%%#order_memo%% memo Order Memo
%%#order_billaddr_addr1%% addr1 Billing address line 1
%%#order_billaddr_addr2%% addr2 Billing address line 2
%%#order_billaddr_addr3%% addr3 Billing address line 3
%%#order_billaddr_addressee%% addressee Billing Addressee; for example, John Smith
%%#order_billaddr_addrphone%% addrphone Billing Address phone number
%%#order_billaddr_addrtext%% addrtext Billing Address summary text
%%#order_billaddr_attention%% attention Billing Attention text; for example, Attention: Accounts Payable
%%#order_billaddr_city%% city Billing City
%%#order_billaddr_country%% country Billing Country
%%#order_billaddr_state%% state Billing State
%%#order_billaddr_zip%% zip Billing Zip Code
%%#order_shipaddr_addr1%% addr1 Shipping Address line 1
%%#order_shipaddr_addr2%% addr2 Shipping Address line 2
%%#order_shipaddr_addr3%% addr3 Shipping Address line 3
%%#order_shipaddr_addressee%% addressee Shipping Addressee; for example, John Smith
%%#order_shipaddr_addrphone%% addrphone Shipping Address phone number
%%#order_shipaddr_addrtext%% addrtext Shipping Address summary text
%%#order_shipaddr_attention%% attention Shipping Attention text; for example, Attention: Accounts Payable
%%#order_shipaddr_city%% city Shipping City
%%#order_shipaddr_country%% country Shipping Country
%%#order_shipaddr_state%% state Shipping State
%%#order_shipaddr_zip%% zip Shipping Zip Code
Table 2. Order line-level fields
Delivery Field NetSuite Field Description
%%#order_li_itemid_#%% itemid Item ID
%%#order_li_intid_#%% internalid Internal ID of item record
%%#order_li_displayname_#%% displayname Item display name
%%#order_li_quantity_#%% quantity Line-item quantity
%%#order_li_rate_#%% rate Unit price
%%#order_li_amount_#%% amount Line total
%%#order_li_description_#%% description Item description
Table 3. Fulfillment header-level delivery fields
Delivery Field NetSuite Field Description
%%#ffill_tranid%% tranid Internal ID of item fulfillment record
%%#ffill_shipmethod%% shipmethod Shipping method; for example, FedEx
%%#ffill_shipaddr_addr1%% addr1 Fulfillment Address line 1
%%#ffill_shipaddr_addr2%% addr2 Fulfillment Address line 2
%%#ffill_shipaddr_addr3%% addr3 Fulfillment Address line 3
%%#ffill_shipaddr_addressee%% addressee Fulfillment Addressee; for example, John Smith
%%#ffill_shipaddr_addrphone%% addrphone Fulfillment Address phone number
%%#ffill_shipaddr_addrtext%% addrtext Fulfillment Address summary text
%%#ffill_shipaddr_attention%% attention Fulfillment Attention text; for example, Attention: Accounts Payable
%%#ffill_shipaddr_city%% city Fulfillment City
%%#ffill_shipaddr_country%% country Fulfillment Country
%%#ffill_shipaddr_state%% state Fulfillment State
%%#ffill_shipaddr_zip%% zip Fulfillment Zip Code
Table 4. Fulfillment line-level delivery fields
Delivery Field NetSuite Field Description
%%#ffill_line_qty_#%% quantity Quantity of line-item #
%%#ffill_line_itm_desc_#%% itemdescription Item description for line #
%%#ffill_line_itm_name_#%% itemname Item name for line #
%%#ffill_line_itm_intid_#%% internalid Internal ID of item record
%%#ffill_line_itm_units_#%% units Units for line #; for example, EA
%%#ffill_track_#%% trackingnumbers Package tracking numbers
Table 5. Customer delivery fields
Delivery Field NetSuite Field Description
%%#customer_cust_id%% entityid Entity ID; for example, John Smith
%%#customer_firstname%% firstname Customer first name
%%#customer_lastname%% lastname Customer last name
%%#customer_company_name%% companyname Company name