Paid In Full

General

Customformcustomform

Spa World - Vendor Bill

Linkedlinked

Yes

Locationlocation

Miami

Locationusesbinslocationusesbins

Yes

Memomemo

Sample Order (OVS To TEST our Model)

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

VENDBILL50055

Voidedvoided

No

Warnnexuschangewarnnexuschange

No

Bill #tranid

—

Classclass

—

Departmentdepartment

—

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

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

Billaddresslistbilladdresslist

No. 117 Chunjiang Road

Billingaddress keybillingaddress_key

2388445

Billingaddress textbillingaddress_text

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);

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

72.69

Payment termsterms

Prepayment

Stc amount after discountcustbody_stc_amount_after_discount

72.69

Stc tax after discountcustbody_stc_tax_after_discount

0.00

Stc total after discountcustbody_stc_total_after_discount

72.69

Totaltotal

72.69

Usertotalusertotal

72.69

Discdaysdiscdays

—

Discountamountdiscountamount

—

Intercostatusintercostatus

—

Landedcostamount8landedcostamount8

—

Landedcostmethodlandedcostmethod

—

Landedcostperlinelandedcostperline

—

Landedcostsource8landedcostsource8

—

Landedcostsourcetran8landedcostsourcetran8

—

St amountcustbody_st_amount

—

Stc discountpercentcustbody_stc_discountpercent

—

Taxamount2overridetaxamount2override

—

Taxamountoverridetaxamountoverride

—

Taxperiodtaxperiod

—

Payment

New payment schedulecustbody_new_payment_schedule

No

Payablesacctpayablesacct

113

Paymentholdpaymenthold

No

Paymentspayments

Yes

Freight payment amountcustbody_freight_payment_amount

—

Stc payment transaction idcustbody_stc_payment_transaction_id

—

Dates

Bill datetrandate_dt

Feb 3, 2022

Createdcreateddate

2/3/2022 9:11 am

Datedrivendatedriven

No

Due dateduedate_dt

Feb 3, 2022

Last modifiedlastmodifieddate

2/3/2022 9:11 am

Pp epp_e_dt

Feb 28, 2022

Pp spp_s_dt

Feb 1, 2022

Prevdateprevdate_dt

Feb 3, 2022

Ready to ship datecustbody_ready_to_ship_date_dt

May 5, 2021

Booking confirmation datecustbody_booking_confirmation_date_dt

—

Date of taxable supplycustbody_date_of_taxable_supply_dt

—

Discountdatediscountdate_dt

—

Document datecustbody_document_date_dt

—

Payment date balancecustbody_payment_date_balance_dt

—

Payment date depositcustbody_payment_date_deposit_dt

—

Ready to ship calcustbody_ready_to_ship_cal_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

2769

Nsts vp purchase ordercustbody_nsts_vp_purchase_order

POS13041

Nsts vp vendor emailcustbody_nsts_vp_vendor_email

purchasing@swcorp.com

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

—

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

Disputedcustbody_disputed

No

First app appcustbody_first_app_app

Yes

First approvercustbody_first_approver

Humberto T Tapia

Hj tc po statuscustbodyhj_tc_po_status

New

Nondeductible processedcustbody_nondeductible_processed

No

Order notescustbody_order_notes

Sample Testing In Process, ETA To Be Updated * China Team: The sample keeps our china office to test whether match bathtub,won't ship to USA

Pend apcustbody_pend_ap

No

Po emailedcustbody_po_emailed

No

Po status trancustbody_po_status_tran

Pending Sail Date

Report timestampcustbody_report_timestamp

3/2/2022 6:10:47

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

—

Cntnr number pocustbody_cntnr_number_po

—

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

—

Forwarder namecustbody_forwarder_name

—

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

—

Production timecustbody_production_time

—

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

Feb 2022

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

Billaddresslist refidbilladdresslist_refid

410

Currency refidcurrency_refid

1

Customform refidcustomform_refid

165

Dbstrantypedbstrantype

VendBill

Editionedition

US

Entity refidentity_refid

151

Entitynexus refidentitynexus_refid

1

Entryformquerystringentryformquerystring

e=T&id=12609778

First approver refidcustbody_first_approver_refid

279362

Haslineshaslines

Yes

Hj tc po status refidcustbodyhj_tc_po_status_refid

1

Idid

12609778

InternalIdInternalId

12609778

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

8

Postingperiod refidpostingperiod_refid

90

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

—

Bulkbulk

—

Cci statement refidcustbody_cci_statement_refid

—

Cci transaction refidcustbody_cci_transaction_refid

—

Class refidclass_refid

—

Customwhencecustomwhence

—

Delivery terms refidcustbody_delivery_terms_refid

—

Department refiddepartment_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

—