Paid In Full

General

Customformcustomform

Spa World - Vendor Bill

Departmentdepartment

Supply Chain : Purchasing

Linkedlinked

Yes

Locationlocation

Miami

Locationusesbinslocationusesbins

Yes

Memomemo

Pumps and Blowers (Full Container) Shipment

Nexus countrynexus_country

US

Originalnexusoriginalnexus

United States FL

Originalnexuscountryoriginalnexuscountry

US

Statusstatus

Paid In Full

Subsidiarysubsidiary

Spa World Corporation

Tax nexusnexus

United States FL

To be printedtobeprinted

No

Transactionnumbertransactionnumber

VENDBILL45872

Voidedvoided

No

Warnnexuschangewarnnexuschange

No

Bill #tranid

—

Classclass

—

Customer

Companyidcompanyid

151

Customerentity

Guangdong Lingxiao Pump Industry Co Ltd

Entity nexus countryentity_nexus_country

US

Entityfieldnameentityfieldname

entity

Entitynameentityname

Guangdong Lingxiao Pump Industry Co Ltd

Entitynexusentitynexus

United States FL

Shipping

Delivery termscustbody_delivery_terms

—

Inboundshipmentvalueinboundshipmentvalue

—

Incotermincoterm

—

Billing

Bill tobilladdress

Elvin Guangdong Lingxiao Pump Industr No. 117 Chunjiang Road Yangchun, Guangdong China

Billingaddress keybillingaddress_key

3239388

Billingaddress textbillingaddress_text

Elvin Guangdong Lingxiao Pump Industr No. 117 Chunjiang Road Yangchun, Guangdong China

Billingaddress typebillingaddress_type

shipaddr

Billingaddress2 setbillingaddress2_set

var subrecord = nlapiViewSubrecord('billingaddress'); var addresstext; if (subrecord) { addresstext = subrecord.getFieldValue('addrtext'); } else { } nlapiSetFieldValue('billingaddress_text', addresstext);

Billaddresslistbilladdresslist

—

Billingaddress defaultvaluebillingaddress_defaultvalue

—

Defaultaddrbookdefaultaddrbook

—

Defaultaddresseedefaultaddressee

—

Previous billaddresslistprevious_billaddresslist

—

Amounts & tax

Currencycurrency

US Dollar

Currencynamecurrencyname

US Dollar

Currencyprecisioncurrencyprecision

2

Currencysymbolcurrencysymbol

USD

Discpctdiscpct

0.00

Duedaysduedays

0

Exchange rateexchangerate

1.00

Isbasecurrencyisbasecurrency

Yes

Linkedclosedperioddiscountslinkedclosedperioddiscounts

No

Mindaysmindays

0

Origcurrencyorigcurrency

1

Origexchangerateorigexchangerate

1.00

Origtotalorigtotal

5960.58

Payment termsterms

Prepayment

Stc amount after discountcustbody_stc_amount_after_discount

5,960.58

Stc tax after discountcustbody_stc_tax_after_discount

0.00

Stc total after discountcustbody_stc_total_after_discount

5,960.58

Totaltotal

5,960.58

Usertotalusertotal

5,960.58

Discdaysdiscdays

—

Discountamountdiscountamount

—

Intercostatusintercostatus

—

Landedcostamount8landedcostamount8

—

Landedcostmethodlandedcostmethod

—

Landedcostperlinelandedcostperline

—

Landedcostsource8landedcostsource8

—

Landedcostsourcetran8landedcostsourcetran8

—

St amountcustbody_st_amount

—

Stc discountpercentcustbody_stc_discountpercent

—

Taxamount2overridetaxamount2override

—

Taxamountoverridetaxamountoverride

—

Taxperiodtaxperiod

—

Payment

Freight payment amountcustbody_freight_payment_amount

395268

New payment schedulecustbody_new_payment_schedule

No

Payablesacctpayablesacct

113

Paymentholdpaymenthold

No

Paymentspayments

Yes

Stc payment transaction idcustbody_stc_payment_transaction_id

—

Dates

Bill datetrandate_dt

Dec 3, 2021

Booking confirmation datecustbody_booking_confirmation_date_dt

Sep 23, 2021

Createdcreateddate

12/3/2021 1:41 pm

Datedrivendatedriven

No

Due dateduedate_dt

Dec 3, 2021

Last modifiedlastmodifieddate

12/3/2021 1:42 pm

Payment date depositcustbody_payment_date_deposit_dt

Nov 22, 2019

Pp epp_e_dt

Dec 31, 2021

Pp spp_s_dt

Dec 1, 2021

Prevdateprevdate_dt

Dec 3, 2021

Ready to ship calcustbody_ready_to_ship_cal_dt

Apr 30, 2020

Date of taxable supplycustbody_date_of_taxable_supply_dt

—

Discountdatediscountdate_dt

—

Document datecustbody_document_date_dt

—

Payment date balancecustbody_payment_date_balance_dt

—

Ready to ship datecustbody_ready_to_ship_date_dt

—

Sii accounting datecustbody_sii_accounting_date_dt

—

Sii invoice datecustbody_sii_invoice_date_dt

—

Sii operation datecustbody_sii_operation_date_dt

—

St end datecustbody_st_end_date

—

St start datecustbody_st_start_date

—

Transaction datecustbody_transaction_date_dt

—

Integrations & channels

Nsts vp auto apply prepaymentcustbody_nsts_vp_auto_apply_prepayment

Yes

Nsts vp include taxcustbody_nsts_vp_include_tax

No

Nsts vp prepay transcustbody_nsts_vp_prepay_trans

No

Nsts vp prepay vpcustbody_nsts_vp_prepay_vp

1009;1241;1507;1851;450;603;934

Nsts vp purchase ordercustbody_nsts_vp_purchase_order

POS12942

Nsts vp with prepaymentscustbody_nsts_vp_with_prepayments

Yes

Ebay cancel reason nscustbody_ebay_cancel_reason_ns

—

Externalidexternalid

—

Nsts vp po employee emailcustbody_nsts_vp_po_employee_email

—

Nsts vp prepay pocustbody_nsts_vp_prepay_po

—

Nsts vp prepay totalcustbody_nsts_vp_prepay_total

—

Nsts vp prepay total appliedcustbody_nsts_vp_prepay_total_applied

—

Nsts vp prepay total unappliecustbody_nsts_vp_prepay_total_unapplie

—

Nsts vp vendor emailcustbody_nsts_vp_vendor_email

—

Pacejet delivery instructionscustbody_pacejet_delivery_instructions

—

Pacejet freight costcustbody_pacejet_freight_cost

—

Pacejet freight costcurrencycustbody_pacejet_freight_costcurrency

—

Pacejet freight pricecustbody_pacejet_freight_price

—

Pacejet freight pricecurrencycustbody_pacejet_freight_pricecurrency

—

Pacejet int rqurlcustbody_pacejet_int_rqurl

—

Pacejet shipped methodcustbody_pacejet_shipped_method

—

Pacejet timestampcustbody_pacejet_timestamp

—

Shopify payout idcustbody_shopify_payout_id

—

Custom fields

4custbody4

No

5custbody5

No

Bill entered bycustbody_bill_entered_by

Humberto T Tapia

Cash registercustbody_cash_register

No

Cntnr number pocustbody_cntnr_number_po

TGHU6977328 / MSMU5470997 / TRHU8734530 / MSMU6209740 / APHU6799420 / CMAU5509607 / TGBU6727250 / CMAU4615841 / TGBU6808352 / TRHU8203908 / TCNU2395008 / UESU5206369 / TCNU5216600 / TGBU5085156 / CMAU6231212 / DFSU6261432 / SEKU5706354 / SEKU5707920 / ZCSU7632616 / ZCSU7669410 / TCNU4113504 etc.

Disputedcustbody_disputed

No

First app appcustbody_first_app_app

Yes

First approvercustbody_first_approver

Humberto T Tapia

Forwarder namecustbody_forwarder_name

JustShipping

Hj tc po statuscustbodyhj_tc_po_status

New

Nondeductible processedcustbody_nondeductible_processed

No

Order notescustbody_order_notes

-cntr: TGHU6977328 -cntr: MSMU5470997 / TRHU8734530 / MSMU6209740 eta:11/16/21+5 -cntr: APHU6799420 / TGBU6727250 / CMAU5509607 / CMAU4615841 eta 11/19/21+5 - TGBU6808352 / TRHU8203908 eta 11/22/21+5 - TCNU2395008 / UESU5206369 eta 11/18/21+5 10.25.21 - Carton expenses placed on POS13966 10.26.21 - TGHU6977328 ETA 11/3/21 Booking Date 9/23/21 10.27.21 - MSMU6209740 ETA 11/29/21 10.27.21 - CMAU4615841 ETA 11/29/21 10.27.21 - CMAU5509607 ETA 11/29/21 10.27.21 - TGBU6727250 ETA 11/29/21 10.27.21 - APHU6799420 ETA 11/29/21 10.27.21 - TGBU6808352 ETA 12/2/21 10.27.21 - TRHU8203908 ETA 12/2/21 11.3.21 - TCNU2395008 ETA 11/18/21 11.3.21 - UESU5206369 ETA 11/18/21 11.8.21 - TGHU6977328 ready for delivery to SWCORP. 11.8.21 - MSMU6209740 freight cost $21,000/3 = $7000 (+ $10783) 11.10.21 - TCNU2395008 --> $17000/4 = $4250 (+ $17783) 11.10.21 - UESU5206369 --> $17000/4 = $4250 (+ $22033) - TCLU8228778 & CMAU7052839 ETA 12.10.21+5 11.16.21 CMAU4615841 --> $16900/4 = $4225 (+ $26283) 11.16.21 CMAU5509607 --> $16900/3 = $5633 (+ $30508) 10.16.21 TGBU6727250 --> $16900/4 = $4225 (+36141) 11.16.21 TGBU6808352 -- $16620/6 = $2770 (+ $40366) 11.16.21 APHU6799420 --> $16900/4 = $4225 (+ $43136) 11.16.21 TCLU8228778 --> $13500/5 = $2700 (+ $47361) 11.16.21 CMAU7052839 --> $12500/4 = $3125 (+ $50061) 11.19.21 SEKU5707920 --> $15000/4 = $3750 (+ $53186) 11.19.21 SEKU5706354 --> $15000/4 = $3750 (+ $56936) 11.19.21 ZCSU7632616 --> $17000/4 = $4250 (+ $60686) 11.19.21 - TCNU4113504 --> $15000/3 = $5000 (+ $64936) 11.19.21 - CMAU4459420 --> $15000/3 = $5000 (+ $69936) 11.19.21 MSMU5470997 --> $21000/3 = $7000 (+ $74936) 11.19.21 TRHU8734530 --> $21000/3 = $7000 (+ $81936) 11.18.21 - ZCSU7669410 U.S. Customs has placed an intensive hold on this cargo upon arrival into Jacksonville Terminal. Once containers have discharged, they will be transferred to the CES for an exam which is located on Blount Island. Goods will not be made available until all charges are satisfied with the CES and ZIM lines. 11.22.21 ZCSU7669410 As per customs they should be moving the container to exam site tomorrow late evening or wed, we hope to see it release soon. Last free day is 11/24. 11.24.21 APHU7050123 ETA 12/31/21 +5 11.24.21 BSIU8067646 ETA 12/31/21 +5 11.24.21 ZCSU7669410 As per customs warehouse , container arrived there pending to be release, they advise me should be sometime by Monday. 11.29.21 ZCSU7756094 ETA 12/30 +5 11.29.21 ZCSU7756094 --> $17065/5 = $3413 (+ $88936) 12.1.21 ZCSU7669410 --> $16900/3 = $5633 (+ $92349) 12.1.21 TRHU8203908 --> $16800/5 = $3360 (+ $97982) 12.2.21 added cost of all containers with these items per new process = $345768 12.3.21 MSMU6781761-MSMU6781571-MSMU6776718 ETA 1/9/22 +5 12.3.21 MSMU6781761-MSMU6781571-MSMU6776718 --> $16500 KYT (EA)

Pend apcustbody_pend_ap

No

Po emailedcustbody_po_emailed

No

Po status trancustbody_po_status_tran

In Transit

Production timecustbody_production_time

160

Report timestampcustbody_report_timestamp

3/12/2021 10:41:13

Sii article 72 73custbody_sii_article_72_73

No

Sii not reported in timecustbody_sii_not_reported_in_time

No

15529 vendor entity bankcustbody_15529_vendor_entity_bank

—

4599 mx operation typecustbody_4599_mx_operation_type

—

4599 sg import permit numcustbody_4599_sg_import_permit_num

—

Cci statementcustbody_cci_statement

—

Cci transactioncustbody_cci_transaction

—

Counterparty vatcustbody_counterparty_vat

—

Country of origincustbody_country_of_origin

—

Doc num summ invoicecustbody_doc_num_summ_invoice

—

Establishment codecustbody_establishment_code

—

Fob on pocustbody_fob_on_po

—

Hj po change revision numbercustbodyhj_po_change_revision_number

—

Hj tc dccodecustbodyhj_tc_dccode

—

Hj tc edideptnocustbodyhj_tc_edideptno

—

Hj tc markforcodecustbodyhj_tc_markforcode

—

Hj tc poack decisioncustbodyhj_tc_poack_decision

—

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

—

Itr nexuscustbody_itr_nexus

—

Mode of transportcustbody_mode_of_transport

—

My import declaration numcustbody_my_import_declaration_num

—

Nexus notccustbody_nexus_notc

—

Nondeductible ref genjrnlcustbody_nondeductible_ref_genjrnl

—

Notccustbody_notc

—

Refno originvoicecustbody_refno_originvoice

—

Regime codecustbody_regime_code

—

Regime code of supplycustbody_regime_code_of_supply

—

Scpq iframecustbody_scpq_iframe

—

Sii codecustbody_sii_code

—

Sii correction typecustbody_sii_correction_type

—

Sii external referencecustbody_sii_external_reference

—

Sii intra txn typecustbody_sii_intra_txn_type

—

Sii orig billcustbody_sii_orig_bill

—

Sii received inv typecustbody_sii_received_inv_type

—

Sii registration codecustbody_sii_registration_code

—

Sii registration msgcustbody_sii_registration_msg

—

Sii registration statuscustbody_sii_registration_status

—

Sii spcl scheme code purchasecustbody_sii_spcl_scheme_code_purchase

—

St amz settle idcustbody_st_amz_settle_id

—

Stc daysuntilexpirycustbody_stc_daysuntilexpiry

—

Transaction regioncustbody_transaction_region

—

Others

Accountaccount

20010 Total Accounts Payable : Accounts Payable

Approval statusapprovalstatus

Approved

Custpage taf subsidiarycachecustpage_taf_subsidiarycache

{"1":"US","5":"US","6":"US","3":"US","9":"US","2":"US","4":"US","7":"US","8":"US"}

Expacctexpacct

433

Expacctnameexpacctname

69050 Other Admin Expenses : Purchase Discount

Initialentityinitialentity

151

Linkedrevrecjelinkedrevrecje

No

Locationsrequiredlocationsrequired

No

Nextaccountdocnumnextaccountdocnum

1

Oldapprovalstatusoldapprovalstatus

2

Postingperiodpostingperiod

Dec 2021

Ppsetbyuserppsetbyuser

No

Receivedreceived

Yes

Allownonglchangesallownonglchanges

—

Initialtranidinitialtranid

—

Intercotransactionintercotransaction

—

Nextapprovernextapprover

—

Periodclosedperiodclosed

—

Ppsetbyuservalueppsetbyuservalue

—

Representssubsidiaryrepresentssubsidiary

—

Workflowbuttonclickedworkflowbuttonclicked

—

Workflowbuttonsworkflowbuttons

—

System & IDs

Account refidaccount_refid

113

Approvalstatus refidapprovalstatus_refid

2

Baserecordtypebaserecordtype

vendorbill

Bill entered by refidcustbody_bill_entered_by_refid

279362

Currency refidcurrency_refid

1

Customform refidcustomform_refid

165

Dbstrantypedbstrantype

VendBill

Department refiddepartment_refid

32

Editionedition

US

Entity refidentity_refid

151

Entitynexus refidentitynexus_refid

1

Entryformquerystringentryformquerystring

e=T&id=11578056

First approver refidcustbody_first_approver_refid

279362

Haslineshaslines

Yes

Hj tc po status refidcustbodyhj_tc_po_status_refid

1

Idid

11578056

InternalIdInternalId

11578056

Inventorydetailuitypeinventorydetailuitype

MOH_STRICT_VALIDATION

Location refidlocation_refid

1

Nextapprover refidnextapprover_refid

-1

Nexus refidnexus_refid

1

Ntypentype

Bill

Ntype refidntype_refid

17

Originalnexus refidoriginalnexus_refid

1

Po status tran refidcustbody_po_status_tran_refid

5

Postingperiod refidpostingperiod_refid

85

Rectype 159 1115 maxnkeyrectype_159_1115_maxnkey

0

Rectype 400 3093 maxnkeyrectype_400_3093_maxnkey

7

StatusRefstatusRef

paidInFull

Subsidiary refidsubsidiary_refid

1

Templatestoredtemplatestored

Yes

Terms refidterms_refid

11

Typetype

vendbill

Versionversion

4

15529 vendor entity bank refidcustbody_15529_vendor_entity_bank_refid

—

4599 mx operation type refidcustbody_4599_mx_operation_type_refid

—

Billaddresslist refidbilladdresslist_refid

—

Bulkbulk

—

Cci statement refidcustbody_cci_statement_refid

—

Cci transaction refidcustbody_cci_transaction_refid

—

Class refidclass_refid

—

Customwhencecustomwhence

—

Delivery terms refidcustbody_delivery_terms_refid

—

Fob on po refidcustbody_fob_on_po_refid

—

Hj tc poack decision refidcustbodyhj_tc_poack_decision_refid

—

Incoterm refidincoterm_refid

—

Intercostatus refidintercostatus_refid

—

Intercotransaction refidintercotransaction_refid

—

Landedcostmethod refidlandedcostmethod_refid

—

Landedcostsource8 refidlandedcostsource8_refid

—

Landedcostsourcetran8 refidlandedcostsourcetran8_refid

—

Mode of transport refidcustbody_mode_of_transport_refid

—

Nexus notc refidcustbody_nexus_notc_refid

—

Nondeductible ref genjrnl refidcustbody_nondeductible_ref_genjrnl_refid

—

Notc refidcustbody_notc_refid

—

Nsbrowserenvnsbrowserenv

—

Nsts vp prepay po refidcustbody_nsts_vp_prepay_po_refid

—

Regime code of supply refidcustbody_regime_code_of_supply_refid

—

Regime code refidcustbody_regime_code_refid

—

Selectedtabselectedtab

—

Sii correction type refidcustbody_sii_correction_type_refid

—

Sii intra txn type refidcustbody_sii_intra_txn_type_refid

—

Sii orig bill refidcustbody_sii_orig_bill_refid

—

Sii received inv type refidcustbody_sii_received_inv_type_refid

—

Sii registration code refidcustbody_sii_registration_code_refid

—

Sii registration status refidcustbody_sii_registration_status_refid

—

Sii spcl scheme code purchase refidcustbody_sii_spcl_scheme_code_purchase_refid

—

Transaction region refidcustbody_transaction_region_refid

—

Trantypepermchecktrantypepermcheck

—