IF27794 Shipped
Fulfillment dateAug 13, 2019
Ship methodSAIA
StatusShipped
Lines20 related · 0 files
| Tracking number | Description | Weight | Unit |
|---|---|---|---|
| 770859675701 | 1402798-001: FHC20174 (1) | 224 |
Open a line with + to see all of its information.
| # | Item | Description | Quantity | Remaining | Location | ||
|---|---|---|---|---|---|---|---|
| 0 | 2653WIDPLWQC | 2653WI: Left Drain: White: Dual: Friction Heater: Chrome PneumaticControl: ChromeTrim: Overflow | 1.00 | 1.00 | 1 | ||
| 3 | FHC20174 | 4-Piece Roman Tub Faucet with Extendable Showerhead | 1.00 | 1.00 | 1 | ||
General
General · 10 fields · 9 with a value · 1 empty
- Created fromcreatedfrom
- Sales Order #SOS220101
- Customformcustomform
- Spa World - Item Fulfillment
- Fulfillment #tranid
- IF27794
- Linkedlinked
- No
- Order typeordertype
- SalesOrd
- Statusstatus
- Shipped
- Subsidiarysubsidiary
- Spa World Corporation
- Transactionnumbertransactionnumber
- ITEMSHIP27794
- Voidedvoided
- No
No value 1
- Memomemo
- —
Customer
Customer · 16 fields · 12 with a value · 4 empty
- Balancebalance
- 0.00
- Companyidcompanyid
- 1841
- Credholdentitycredholdentity
- 1841
- Credholdoverridecredholdoverride
- Yes
- Credlimcredlim
- 5,000.00
- Customerentity
- 2431 Royal Plumbing
- Daysoverduedaysoverdue
- 0
- Entitycurrencyentitycurrency
- 1
- Entitynameentityname
- 2431 Royal Plumbing
- Manualcreditholdmanualcredithold
- No
- Overallbalanceoverallbalance
- 0.00
- Phonephone
- (515) 994-3224
No value 4
- Email hc trancustbody_email_hc_tran
- —
- Entitytaxidentitytaxid
- —
- Partnerpartner
- —
- Phone hc enitycustbody_phone_hc_enity
- —
Shipping
Shipping · 36 fields · 26 with a value · 10 empty
- Carrierformcarrierform
- ns
- Defaultshipstagedefaultshipstage
- B
- Export shipmentcustbody_export_shipment
- No
- Houzz shipmentcustbody_houzz_shipment
- No
- Ignoreshippervoiderrorignoreshippervoiderror
- No
- Isfreeshippingpromoisfreeshippingpromo
- No
- Onsaveshipmentweightonsaveshipmentweight
- 224
- Originalshipstatusoriginalshipstatus
- C
- Pj sssdeliverycustbody_pj_sssdelivery
- No
- Recordshipmethodrecordshipmethod
- 15564
- Ship houzzcustbody_ship_houzz
- No
- Ship methodshipmethod
- SAIA
- Ship statusshipstatus
- Shipped
- Ship toshipaddress
- Ernie Royal Plumbing 107 S East St Prairie City IA 50228 (515) 994-3224
- Shipcountryshipcountry
- US
- Shipisresidentialshipisresidential
- No
- Shipment exportedcustbody_shipment_exported
- No
- Shipoverrideshipoverride
- No
- Shippingaddress keyshippingaddress_key
- 879020
- Shippingaddress textshippingaddress_text
- Ernie Royal Plumbing 107 S East St Prairie City IA 50228 (515) 994-3224
- Shippingaddress typeshippingaddress_type
- shipaddr
- Shippingaddress2 setshippingaddress2_set
- var subrecord = nlapiViewSubrecord('shippingaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('shippingaddress_text', addresstext);
- Shippingcostoverriddenshippingcostoverridden
- No
- Shippinggroupidshippinggroupid
- 1
- Shipstateshipstate
- IA
- Shipzipshipzip
- 50228
No value 10
- Atlas carriercustbody_atlas_carrier
- —
- Carrier codecustbody_carrier_code
- —
- Markpackshipmarkpackship
- —
- Previous shipaddresslistprevious_shipaddresslist
- —
- Prevshipmethodprevshipmethod
- —
- Ship method usedcustbody_ship_method_used
- —
- Shipaddresslistshipaddresslist
- —
- Shipperservicecodeshipperservicecode
- —
- Shippingaddress defaultvalueshippingaddress_defaultvalue
- —
- Shipspeedcustbody_shipspeed
- —
Billing
Billing · 3 fields · 1 with a value · 2 empty
- Billingtypebillingtype
- CustInvc
No value 2
- Defaultaddrbookdefaultaddrbook
- —
- Defaultaddresseedefaultaddressee
- —
Amounts & tax
Amounts & tax · 14 fields · 11 with a value · 3 empty
- Currencycodecurrencycode
- USD
- Exchange rateexchangerate
- 1
- Isbasecurrencyisbasecurrency
- Yes
- Kcurrencykcurrency
- 1
- Linkedclosedperioddiscountslinkedclosedperioddiscounts
- No
- Overallunbilledordersoverallunbilledorders
- 0.00
- Primarycurrencyprimarycurrency
- 1.00
- Primarycurrencyfxrateprimarycurrencyfxrate
- 1.00
- Totalquantitytotalquantity
- 2.0
- Unbilledordersunbilledorders
- 0.00
- Usdtosubsidiaryexchangerateusdtosubsidiaryexchangerate
- 1
No value 3
- Atlas boltotalcustbody_atlas_boltotal
- —
- If total qtycustbody_if_total_qty
- —
- Taxperiodtaxperiod
- —
Dates
Dates · 10 fields · 7 with a value · 3 empty
- Createdcreateddate
- 8/13/2019 9:52 am
- Datetodaydatetoday
- 6/15/2024
- Fulfillment datetrandate_dt
- Aug 13, 2019
- Last modifiedlastmodifieddate
- 8/13/2019 10:28 am
- Pp epp_e_dt
- Aug 31, 2019
- Pp spp_s_dt
- Aug 1, 2019
- Prevdateprevdate_dt
- Aug 13, 2019
No value 3
- Amazon order datecustbody_amazon_order_date
- —
- Estimated ship datecustbody_estimated_ship_date
- —
- Ns charged datecustbody_ns_charged_date_dt
- —
Integrations & channels
Integrations & channels · 64 fields · 26 with a value · 38 empty
- Amazon fbacustbody_amazon_fba
- No
- Amazon prime sfcustbody_amazon_prime_sf
- No
- Ebay updated shipcustbody_ebay_updated_ship
- No
- Export to shopifycustbody_export_to_shopify
- No
- Ns os sales shipments exportdcustbody_ns_os_sales_shipments_exportd
- No
- Originalsyncshipstatusoriginalsyncshipstatus
- C
- Pacejet autoimportcustbody_pacejet_autoimport
- Yes
- Pacejet autoshipcustbody_pacejet_autoship
- No
- Pacejet delivery instructionscustbody_pacejet_delivery_instructions
- This tub gets the v-pack jets !!!
- Pacejet freight costcustbody_pacejet_freight_cost
- 183.04
- Pacejet freight costcurrencycustbody_pacejet_freight_costcurrency
- 183.04
- Pacejet freight pricecustbody_pacejet_freight_price
- 183.04
- Pacejet freight pricecurrencycustbody_pacejet_freight_pricecurrency
- 183.04
- Pacejet freight termscustbody_pacejet_freight_terms
- Prepaid
- Pacejet if carrier trackingcustbody_pacejet_if_carrier_tracking
- https://www.saia.com/track
- Pacejet if fulfilledcustbody_pacejet_if_fulfilled
- Yes
- Pacejet master tracking numcustbody_pacejet_master_tracking_num
- 770859675701
- Pacejet shipped methodcustbody_pacejet_shipped_method
- SAIA - Standard
- Pacejet sps updatedcustbody_pacejet_sps_updated
- No
- Pacejet tracking linkcustbody_pacejet_tracking_link
- http://appn.pacejet.cc/SpaWorld/Content/Transactions/SearchShipments.aspx?lstSearchFor=DeliveryOrder&txtSearchValue=1402798
- Pacejet updateentitycustbody_pacejet_updateentity
- <?xml version="1.0" encoding="utf-16"?><ShipUpdateEntity xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><Notifications><HighestSeverity>Success</HighestSeverity><NotificationList /></Notifications><TransactionID>1402798</TransactionID><ExternalTransactionID>1402798</ExternalTransactionID><Location>SpaWorld</Location><Method>ShipImport</Method><SubMethod>itemfulfillment</SubMethod><Action>Push</Action><WorkstationName>Station 3 Building A</WorkstationName><MasterTrackingNumber>770859675701</MasterTrackingNumber><ProBill /><ITNNumber /><LabelType>PDF</LabelType><CarrierClassOfService>STD</CarrierClassOfService><Carrier>SAIA</Carrier><ShipVia /><FreightTerms>Prepaid</FreightTerms><PrinterName>\\desktop-mifdacs\nicozebra</PrinterName><LabelCustomPositioning>OFF</LabelCustomPositioning><ShippedBy>nchavez</ShippedBy><Origin><Address1>5701 NW 35th Ave</Address1><Address2 /><Address3 /><Address4 /><City>Miami</City><StateOrProvinceCode>FL</StateOrProvinceCode><PostalCode>33142</PostalCode><CountryCode>US</CountryCode><Residential>false</Residential><LocationType>Facility</LocationType><LocationSite>MAIN</LocationSite><LocationCode>1</LocationCode><CompanyName>Spa World</CompanyName><ContactName>Spa World</ContactName><Email>arc@swcorp.com</Email><EmailNotificationFlags>1</EmailNotificationFlags><Phone>305-330-1146</Phone></Origin><Destination><Address1>107 S East St</Address1><Address2 /><Address3 /><Address4 /><City>Prairie City</City><StateOrProvinceCode>IA</StateOrProvinceCode><PostalCode>50228</PostalCode><CountryCode>US</CountryCode><Residential>false</Residential><LocationType>Customer</LocationType><LocationSite /><LocationCode>1402798</LocationCode><CompanyName>Royal Plumbing</CompanyName><ContactName>Ernie</ContactName><Email>lindsay@royalplumbingia.com</Email><EmailNotificationFlags>1</EmailNotificationFlags><Phone>(515) 994-3224</Phone></Destination><BillingDetails><FreightTermsCode>Prepaid</FreightTermsCode><FreightAccountID>1402798</FreightAccountID><FreightAccount /><FreightAccountZip>50228</FreightAccountZip><FreightAccountCountryCode>US</FreightAccountCountryCode></BillingDetails><ShipmentDetail><ShipmentServicesCodes><Code><Code>LIFT_GATE</Code></Code><Code><Code>LIFT_GATE</Code></Code></ShipmentServicesCodes><ShipmentOptions><DeliveryInstructionsText>0</DeliveryInstructionsText><SignatureType /><DangerousGoodsType /></ShipmentOptions></ShipmentDetail><RoutingDetail><ShipTimestamp>2019-08-13T14:28:35.6244033Z</ShipTimestamp><ArrivalEstimate>2019-08-16T00:00:00</ArrivalEstimate><TransitTime>3</TransitTime><ArrivalEstimateString>Friday, August 16, 2019</ArrivalEstimateString></RoutingDetail><RateDetail><TotalWeight><Units>LB</Units><Value>224.000</Value></TotalWeight><FreightTotalCost><Currency>USD</Currency><Amount>183.0400</Amount></FreightTotalCost><FreightTotalPrice><Currency>USD</Currency><Amount>183.0400</Amount></FreightTotalPrice><FreightListPrice><Currency>USD</Currency><Amount>183.0400</Amount></FreightListPrice><FreightTotalSurchages><Currency>USD</Currency><Amount>43.2700</Amount></FreightTotalSurchages><QuoteID /></RateDetail><CompletedPackageDetails><CompletedPackageDetails><PackingListNumber>1402798-001</PackingListNumber><ExternalID /><TrackingUrl>https://www.saia.com/track</TrackingUrl><TrackingNumber>770859675701</TrackingNumber><SequenceNumber>1</SequenceNumber><RateDetail /><PackagingType /><Weight><Units>LB</Units><Value>224.000</Value></Weight><Dimensions><Length>56.000</Length><Width>33.000</Width><Height>50.000</Height><Units>IN</Units></Dimensions><UserFieldList /><ItemList><Item><ProductNumber>FHC20174</ProductNumber><ProductDescription>4-Piece Roman Tub Faucet with Extendable Showerhead</ProductDescription><Quantity>1</Quantity><ExternalID>9283</ExternalID><UserFieldList><UserField1>3</UserField1><UserField3>1</UserField3></UserFieldList><QuantityUOM>EA</QuantityUOM><UnitWeight><Units>LB</Units><Value>10.300</Value></UnitWeight><CommodityName /><CommodityCode /><HazardousCode /><ECCNCode /><HarmonizeCode /><CountryOfOrigin /><UPCCode /></Item></ItemList><BaseCharge><Currency /><Amount>183.0400</Amount></BaseCharge><PackageNumber /><PackageOptions><Classification><RateBaseTariffCode>158260-4</RateBaseTariffCode><ProductCode>158260-4</ProductCode><ProductSubCode /></Classification><RateClass>175</RateClass><CODTotal>0</CODTotal></PackageOptions><SSCC /></CompletedPackageDetails></CompletedPackageDetails><UserFieldList><UserField1>This tub gets the v-pack jets !!!</UserField1><UserField2>SOS220101</UserField2><UserField3>MB409Delaware</UserField3><UserField15>1369334</UserField15></UserFieldList><MessageList><Message><Name>FedEx_Reference_CUSTOMER_REFERENCE</Name><Value>This tub gets the v-pack jets !!!</Value></Message><Message><Name>FedEx_Reference_P_O_NUMBER</Name><Value>MB409Delaware</Value></Message><Message><Name>FedEx_Reference_INVOICE_NUMBER</Name><Value>SOS220101</Value></Message><Message><Name>UPS_Reference_1</Name><Value>MB409Delaware</Value></Message><Message><Name>UPS_Reference_2</Name><Value>SOS220101</Value></Message><Message><Name>Delivery_Instructions</Name><Value>This tub gets the v-pack jets !!!</Value></Message><Message><Name /><Value>1</Value></Message></MessageList></ShipUpdateEntity>
- Ship export walmartcustbody_ship_export_walmart
- No
- Storeorderstoreorder
- No
- Woocom if updated to woocustbody_woocom_if_updated_to_woo
- No
- Woocom order created by scripcustbody_woocom_order_created_by_scrip
- No
- Woocom order linkcustbody_woocom_order_link
- <a href=&action=edit></a>
No value 38
- Amazon order idcustbody_amazon_order_id
- —
- Amazon premium shippingcustbody_amazon_premium_shipping
- —
- B2c channelcustbody_b2c_channel
- —
- Ebay cancel reason nscustbody_ebay_cancel_reason_ns
- —
- Ebay orderidcustbody_ebay_orderid
- —
- Edi statuscustbody_edi_status
- —
- Externalidexternalid
- —
- Fulfilment channel ordercustbody_fulfilment_channel_order
- —
- Ns os sales channel namecustbody_ns_os_sales_channel_name
- —
- Ns os sales channel numbercustbody_ns_os_sales_channel_number
- —
- Ns os sales error codecustbody_ns_os_sales_error_code
- —
- Ns os sales order idcustbody_ns_os_sales_order_id
- —
- Ns os sales order statuscustbody_ns_os_sales_order_status
- —
- Ns os sales setup rec idcustbody_ns_os_sales_setup_rec_id
- —
- Ns os sales ship exp bat idcustbody_ns_os_sales_ship_exp_bat_id
- —
- Ns os sales shipping carriercustbody_ns_os_sales_shipping_carrier
- —
- Ns os sales shipping methodcustbody_ns_os_sales_shipping_method
- —
- Ns os sales warehouse namecustbody_ns_os_sales_warehouse_name
- —
- Pacejet batchidcustbody_pacejet_batchid
- —
- Pacejet cust parent linkcustbody_pacejet_cust_parent_link
- —
- Pacejet freight servicecustbody_pacejet_freight_service
- —
- Pacejet freightacctoverridecustbody_pacejet_freightacctoverride
- —
- Pacejet int rqurlcustbody_pacejet_int_rqurl
- —
- Pacejet int shipmenturlcustbody_pacejet_int_shipmenturl
- —
- Pacejet lastcontainercustbody_pacejet_lastcontainer
- —
- Pacejet ship from overridecustbody_pacejet_ship_from_override
- —
- Pacejet timestampcustbody_pacejet_timestamp
- —
- Pacejet workstationcustbody_pacejet_workstation
- —
- Shopify order idcustbody_shopify_order_id
- —
- Shopify storecustbody_shopify_store
- —
- Walmart order idcustbody_walmart_order_id
- —
- Wayfair shipment idcustbody_wayfair_shipment_id
- —
- Websitewebsite
- —
- Wms asngenerationcustbody_wms_asngeneration
- —
- Wms ordertypecustbody_wms_ordertype
- —
- Wmsse fulfill shipcostcustbody_wmsse_fulfill_shipcost
- —
- Wmsse transactiontypecustbody_wmsse_transactiontype
- —
- Woocommerce order idcustbody_woocommerce_order_id
- —
Custom fields
Custom fields · 33 fields · 6 with a value · 27 empty
- Hj tc fulfill pocustbodyhj_tc_fulfill_po
- MB409Delaware
- If qty calccustbody_if_qty_calc
- 2
- Pj sscodcustbody_pj_sscod
- No
- Pj ssliftgatecustbody_pj_ssliftgate
- No
- Pj sssigreqcustbody_pj_sssigreq
- No
- Po acceptedcustbody_po_accepted
- No
No value 27
- Amz order setupcustbody_amz_order_setup
- —
- Atlas bolnetcustbodyatlas_bolnet
- —
- Atlas bolpackcustbody_atlas_bolpack
- —
- Atlas boltarecustbody_atlas_boltare
- —
- B2c ponumcustbody_b2c_ponum
- —
- Hj tc asntypecustbodyhj_tc_asntype
- —
- Hj tc autopacktemplatecustbodyhj_tc_autopacktemplate
- —
- Hj tc dccodecustbodyhj_tc_dccode
- —
- Hj tc edideptnocustbodyhj_tc_edideptno
- —
- Hj tc markforcodecustbodyhj_tc_markforcode
- —
- Hj tc storecodecustbodyhj_tc_storecode
- —
- Hj tc udf1custbodyhj_tc_udf1
- —
- Hj tc udf2custbodyhj_tc_udf2
- —
- Hj tc udf3custbodyhj_tc_udf3
- —
- Hj tc udf4custbodyhj_tc_udf4
- —
- Hj tc udf5custbodyhj_tc_udf5
- —
- Houzz order idcustbody_houzz_order_id
- —
- Houzz storecustbody_houzz_store
- —
- Ns markerplace setupcustbody_ns_markerplace_setup
- —
- Package height iftrancustbody_package_height_iftran
- —
- Package lengthcustbody_package_length
- —
- Package width iftranscustbody_package_width_iftrans
- —
- Po acceptidcustbody_po_acceptid
- —
- Setup recordcustbody_setup_record
- —
- Wf po numbercustbody_wf_po_number
- —
- Wm purchase idcustbody_wm_purchase_id
- —
- Wrm claimnumbercustbody_wrm_claimnumber
- —
Others
Others · 27 fields · 23 with a value · 4 empty
- Basedimensionunitbasedimensionunit
- in
- Baseweightunitbaseweightunit
- lbs
- Defaultitemweightdefaultitemweight
- 1
- Fulfillmenthaslabelfulfillmenthaslabel
- No
- Fulfillmenthastnumfulfillmenthastnum
- Yes
- Isbrowserrequestisbrowserrequest
- No
- Isdynscriptingenabledisdynscriptingenabled
- Yes
- Isfulfillmenteditisfulfillmentedit
- Yes
- Islabelenabledislabelenabled
- No
- Ismultisubsidiaryismultisubsidiary
- No
- Linkedrevrecjelinkedrevrecje
- No
- Ordbulkordbulk
- No
- Orderidorderid
- 1369334
- Pkgweightmanuallyupdatedpkgweightmanuallyupdated
- No
- Postingperiodpostingperiod
- Aug 2019
- Ppsetbyuserppsetbyuser
- No
- Semailsemail
- lindsay@royalplumbingia.com
- Sendorderfulfillmentemailsendorderfulfillmentemail
- Yes
- Sonumsonum
- SOS220101
- Srccountrysrccountry
- US
- Trandimensionunittrandimensionunit
- in
- Tranweightunittranweightunit
- lbs
- Weightconversionfactorweightconversionfactor
- 1.0
No value 4
- Allownonglchangesallownonglchanges
- —
- Labellengthlabellength
- —
- Periodclosedperiodclosed
- —
- Ppsetbyuservalueppsetbyuservalue
- —
System & IDs
System & IDs · 47 fields · 25 with a value · 22 empty
- Baserecordtypebaserecordtype
- itemfulfillment
- Createdfrom refidcreatedfrom_refid
- 1369334
- Customform refidcustomform_refid
- 184
- Dbstrantypedbstrantype
- ItemShip
- Entity refidentity_refid
- 1841
- Entryformquerystringentryformquerystring
- e=T&id=1402798
- Haslineshaslines
- Yes
- Idid
- 1402798
- InternalIdInternalId
- 1402798
- Ntypentype
- Item Fulfillment
- Ntype refidntype_refid
- 32
- Pacejet freight terms refidcustbody_pacejet_freight_terms_refid
- 1
- Postingperiod refidpostingperiod_refid
- 46
- Rectype 1221 9883 maxnkeyrectype_1221_9883_maxnkey
- 0
- Rectype 159 1115 maxnkeyrectype_159_1115_maxnkey
- 0
- Rectype 395 3062 maxnkeyrectype_395_3062_maxnkey
- 0
- Rectype 400 3093 maxnkeyrectype_400_3093_maxnkey
- 7
- Shipmethod refidshipmethod_refid
- 15564
- Shipstatus refidshipstatus_refid
- C
- StatusRefstatusRef
- shipped
- Subsidiary refidsubsidiary_refid
- 1
- Tax affecting address fields before recalctax_affecting_address_fields_before_recalc
- citystatezipcountry
- Templatestoredtemplatestored
- Yes
- Typetype
- itemship
- Versionversion
- 3
No value 22
- Amz order setup refidcustbody_amz_order_setup_refid
- —
- Atlas carrier refidcustbody_atlas_carrier_refid
- —
- Bulkbulk
- —
- Customwhencecustomwhence
- —
- Hj tc asntype refidcustbodyhj_tc_asntype_refid
- —
- Hj tc autopacktemplate refidcustbodyhj_tc_autopacktemplate_refid
- —
- Houzz store refidcustbody_houzz_store_refid
- —
- Ns markerplace setup refidcustbody_ns_markerplace_setup_refid
- —
- Ns os sales setup rec id refidcustbody_ns_os_sales_setup_rec_id_refid
- —
- Nsbrowserenvnsbrowserenv
- —
- Pacejet cust parent link refidcustbody_pacejet_cust_parent_link_refid
- —
- Pacejet freightacctoverride refidcustbody_pacejet_freightacctoverride_refid
- —
- Pacejet ship from override refidcustbody_pacejet_ship_from_override_refid
- —
- Partner refidpartner_refid
- —
- Selectedtabselectedtab
- —
- Setup record refidcustbody_setup_record_refid
- —
- Shipaddresslist refidshipaddresslist_refid
- —
- Shopify store refidcustbody_shopify_store_refid
- —
- Trantypepermchecktrantypepermcheck
- —
- Wms asngeneration refidcustbody_wms_asngeneration_refid
- —
- Wms ordertype refidcustbody_wms_ordertype_refid
- —
- Wrm claimnumber refidcustbody_wrm_claimnumber_refid
- —
No field matches your search.
Fields without a value are shown as “—”.
No files are attached to this record.