Home |
SO Header |
SO Items
Sales Order Header Field Map
# zx55.com, Sales Order Header Field Map
# 28/09/2019 JP Initial Version
!id={string}iOrderId
!date={string}dtOrderDate
!billingname1={string}vBillingCompanyName
!billingname2={string}vBillingName
!ordervalue={string}fTotalPrice
!vat={string}fTotalTax
!currency={string}vCurrency
!lookup_billingcountry={string}vBillingCountryName
# !lookup_courier={string}
!lookup_currency={string}vCurrency
!lookup_customerref={string}accref
!lookup_paymentmethod={string}vPaymentMethod
!lookup_shippingcountry={string}vShippingCountryName
!lookup_systemuser={string}user
!lookup_taxcode={string}taxcd
!lookup_transactionid={string}vTransactionId
ordno={int}[ordno] ; order number (auto generated)
ord_ty_cd={int}1 ; default to order
ord_or_quote={string}Order
Closed={int}0
quote_expiry_dt={date}2000-01-01
quote_status_id={int}0
quote_status={string}
ord_dt={date}[dtOrderDate] ; (Date & Time)
req_dt={date}2000-01-01
desp_dt={date}2000-01-01
inv_status_id={int}0
inv_status={string}None Invoiced
allocated_status_cd={int}1
allocated_status={string}Nil
sid_desp={int}1
desp_status={string}
~accref={string}[vBillingName:F3]&[iCustomerId]
id_sl={int}!lookup_customerref
accref={string}[accref]
cnt_nm={string}[vBillingName]
nm={string}[VBillingCompanyName]|[vBillingName]
adr1={string}[vBillingAddress]
adr2={string}[vBillingAddress2]
adr3={string}[vBillingCity]
adr4={string}[vBillingCountyName]
adr5={string}[vBillingCountryName]+[vBillingZipCode]
del_nm={string}[vShippingCompanyName]|[vShippingName]
dadr1={string}[vShippingAddress]
dadr2={string}[vShippingAddress2]
dadr3={string}[vShippingCity]
dadr4={string}[vShippingCountyName]
dadr5={string}[vShippingCountryName]+[vShippingZipCode]
cust_tel_no={string}[vBillingPhone]
is_notc={string}
is_terms={string}
inv_no={int}0
usr={string}!lookup_systemuser ; Returns currently logged in user login name
cust_ordno={string}[vOrderNumber]
notes={string}[vInstruction]
notes2={string}[vDeliveryInstruction]
notes3={string}
notes4={string}
curr={int}!lookup_currency ; Lookup / converts GBP to currency ID, id_curr
curr_ty={int}0
foreign_rate={decimal}!lookup_currency
global_nomcd={string}4000
global_dtls={string}
global_taxcd={string}!lookup_taxcode
global_deptno={int}0
g_dept={string}
delcount={int}0
shipcount={int}0
inv={string}
courier_no={int}0
delco_nm={string}
del_note={string}
delnomcd={string}4095
deltaxcd={string}!lookup_taxcode
deldeptno={int}0
carr_dept_nm={string}
del_dt={date}2000-01-01
boxes={string}
cust_disc_rate={decimal}0.0
vlu_disc_rate={decimal}0.0
stlm_due_days={int}0
stlm_disc_rate={decimal}0.0
stlm_disc_amt={decimal}0.0
stlm_tot={decimal}0.0
itms_net={decimal}0.0
itms_disc={decimal}0.0
itms_tax={decimal}0.0
itms_gross={decimal}0.0
delnet={decimal}0.00
deltax={decimal}0.0
delgross={decimal}0.0
inv_net={decimal}0
inv_tax={decimal}0
inv_gross={decimal}0
pmt_ty={int}!lookup_paymentmethod ; e.g. convert PayPal to pmt_ty
bnk_reff={string}!lookup_currency
amt_prepaid={decimal}0.00
pmt_reff={string}[vTransactionId]
foreign_stlm_disc_amt={decimal}0.0
foreign_stlm_tot={decimal}0.0
foreign_amt_prepaid={decimal}0.00
foreign_itms_net={decimal}[fSubTotal]
foreign_itms_disc={decimal}0.00
~frgn_itms_tax={decimal}[fTotalTax]-[vDeliveryTax]
foreign_itms_tax={decimal}[frgn_itms_tax]
~frgn_itms_gross={decimal}[fSubTotal]+[frgn_itms_tax]
foreign_itms_gross={decimal}[frgn_itms_gross]
foreign_delnet={decimal}[vDeliveryPrice]
foreign_deltax={decimal}[vDeliveryTax]
~frgn_del_gross={decimal}[vDeliveryPrice]+[vDeliveyTax]
foreign_delgross={decimal}[frgn_del_gross]
foreign_inv_net={decimal}[fSubTotal]
foreign_inv_tax={decimal}[fTotalTax]
foreign_inv_gross={decimal}[fTotalPrice]
tax_rate1={decimal}!lookup_taxcode
tax_rate2={decimal}0.0
tax_rate3={decimal}0.0
tax_rate4={decimal}0.0
tax_rate5={decimal}0.0
net_amt1={decimal}0.0
net_amt2={decimal}0.0
net_amt3={decimal}0.0
net_amt4={decimal}0.0
net_amt5={decimal}0.0
tax_amt1={decimal}0.0
tax_amt2={decimal}0.0
tax_amt3={decimal}0.0
tax_amt4={decimal}0.0
tax_amt5={decimal}0.0
taxovrride={string}
zerotaxrate={string}
prn={string}N
#created=
#modified=
f_del={int}0
deltaxrate={decimal}!lookup_taxcode
salesperson={string}
prband={int}0
weight={decimal}[fTotalWeight]
adr_ccd={string}!lookup_billingcountry
del_ccd={string}!lookup_shippingcountry
w_ordno={int}[iOrderId]
w_email={string}[vBillingEmail]
w_orddt={datetime}[dtOrderDate]
Home |
SO Header |
SO Items Sales Order Items Field Map
# zx55.com, Sales Order Item Field Map
# 28/09/2019 JP Initial Version
!description={string}vTitle
!price={string}fPrice
!lookup_itemnumber={string}itm_no
!lookup_stock_code={string}vSKU
#id=
ordno={int}[ordno]
job_no={string}
service_flag={int}1
txt={string}
itm_no={int}!lookup_itemnumber ; auto generate imported items number
stkcd={string}[vSKU]
unit_of_sale={string}
prband={int}1
sellpr={decimal}[fPrice]
sellpr2={decimal}0.0
sellpr3={decimal}0.0
sellpr4={decimal}0.0
uwt={decimal}[fWeight]
param1={decimal}0.0
param2={decimal}0.0
param3={decimal}0.0
param4={string}
param5={string}
param6={string}
description={string}[vTitle]
comment1={string}
comment2={string}
ext_ord_reff={string}
qty_ord={decimal}[iQuantity]
unit_pr={decimal}0.0
disc_rate={decimal}0.0
disc_amt={decimal}0.0
qty_dlvrd={decimal}0.0
qty_last_desp={decimal}0.0
full_net_amt={decimal}0.0
tax_amt={decimal}0.0
nomcd={string}4000
deptno={int}0
dept_nm={string}
qty_allocated={decimal}0.0
qty_desp={decimal}0.0
foreign_unit_pr={decimal}[fPrice]
id_stk={int}!lookup_stock_code
foreign_disc_amt={decimal}0.0
dlv_dt={date}2000-01-01
taxcd={string}T1
disc_op={decimal}0.0
disc_qty={decimal}0.0
tax_rate={decimal}[fTaxRate]
net_amt={decimal}0.0
gross_amt={decimal}0.0
foreign_full_net_amt={decimal}[fTotalPrice]
foreign_net_amt={decimal}[fTotalPrice]
foreign_tax_amt={decimal}[fTotalTaxAmount]
~frgn_gross_amt={decimal}[fTotalPrice]+[fTotalTaxAmount]
foreign_gross_amt={decimal}[frgn_gross_amt]
ext_ord_line_ref={int}0
po_itms_id={int}0
due_dt={date}2000-01-01
#created=
#modified=
f_del={int}0
intrastat={string}
is_notc={int}0
stk_adjust={int}0
qty_inv={decimal}0.0
extra1={string}
extra2={string}
disc_ty={string}
disc_Band={string}
id_gdn={int}0
isstk={string}!lookup_stock_code
tc_qship={decimal}0.0
tc_qalloc={decimal}0.0
cp_alloc={decimal}0.0
cp_shipd={decimal}0.0
batch={string}
Home |
SO Header |
SO Items
