List of Sales Order Variables

Modified on Fri, 21 Jun at 8:48 AM

Below is a list of all available variables on sales orders - variables pull data onto your forms from Navigator. It is important that the forms designer training is carried out before trying to add these. This can be completed here: https://classroom.dmsnavigator.com/catalog/info/id:158


 

SalesCategory

SupplierOrderNo

SignableCustomerName

SignableSignature

SignableSignatureDate

DOB

VAT_NUMBER

ORDER_NOTE

ORDER_NOTE

CUST_NAME

ADDRESS1

ADDRESS

POST_CODE

HOMETEL

WORKTEL

MOBILETEL

EMAIL

FAX

SP_CATEGORY

SP_PURCHASE_TYPE

SP_FINANCE_METHOD

SP_PROMOTIONS

RETAIL_PRICE

LIST_PRICE

LIST_PRICE_VAT

LIST_PRICE_TOTAL

QUOTE_PRICE

QUOTE_PRICE

FoptDesc

FoptRetail

FoptSale

FoptSaleLessVat

FTotDesc

FTotOther

FoptVat

FoptTotal

FoptTotalSale

FoptTotalRetail

TotVehFactOpts

FoptQuoteTot

USED_SPEC

DISCOUNT

DISCOUNT_DESC

Less Support

CARD_DISCOUNT_REF

CARD_DISCOUNT

USED_DISCOUNT

USED_DISCOUNT_DESC

Less Discount

DISCOUNTINCVAT

DoptDesc

DoptRetail

DoptList

DoptVat

DoptTotal

TotDOptDesc

TotDOptList

DOptTotalSale

DOptTotalSaleIncVat

TotalDiscounts

WARRANTY_DESCRIPTION

WARRANTY_PRICE

WARRANTY_VAT

WARRANTY_TOTAL

DELIVERY_CHARGE

DELIVERY_VAT

DELIVERY_TOTAL

DELIVERY_NETT

DELIVERY_VAT

DELIVERY_TOTAL

TotVehFactOptsIncVat

RFL

RFL_DESC

TOTAL_VAT

PRICE_ON_ROAD

FINANCE_COMPANY_NAME

FINANCE_ADDRESS_

FINANCE_PERIOD

FINANCE_BALANCE

FINANCE_DEPOSIT

FINANCE_PAYMENT

FINANCE_RESIDUAL

TOTAL_RECEIPT_SUBSIDY

DEPOSIT

PRICE_LESS_PX

PAID_TO_DATE

BALANCE_OUTSTANDING

TOTAL_DUE

STOCK_NO

QUOTE_NO

ORD_NO

ORDER_DATE

ORIGINAL_ORDER_DATE

DELIVERED

DELIVERY_DUE

DELIVERY_TIME

QUOTATION_NOTE

QUOTATION_NOTE

VAT_FREE

REGNO

VAT_QUAL

MOT_EXPIRY

KEYTAG

SPEREKEYNOTES       

TYPE

REG_DATE

SALESMAN

SALESPERSON_NO

MILES

DELIVERY

CHASSIS

BoatName

USER

COLOUR

MAKE

MODEL

DERIVITAVE

ENGINE_SIZE

ENGINE_TYPE

TRANSMISSION

BODY

MODEL_YEAR

FULL_MODEL

PX_MAKE

PX_MODEL

PX_DERIVATIVE

PX_BERTHS

PX_FULL_MODEL

PX_YEAR

PX_REG

PX_CHASSIS

PX_ENGINENO

PX_ENGINE_SIZE

PX_BOATNAME

PX_VALUE

PX_VAT

PX_VAT_QUAL

PX_COLOUR

HPI_CHECK_DATE

PX_STOCKNO

PX_REG_DATE

PX_MILEAGE

PX_MOT_EXPIRY

PX_VALUE_TOTAL

FLEET_QTY

SETTLEMENT_FOR

SETTLEMENT_WITH

SETTLEMENT_REF

SETTLEMENT_VALUE

SETTLEMENT_CONTRA

SETTLEMENT_FOR_EST

SETTLEMENT_WITH_EST

SETTLEMENT_REF_EST

SETTLEMENT_VALUE_EST

SETTLEMENT_UNKNOWN

SETTLEMENT_TOTAL

SETTLEMENT_CONTRA_TOTAL

SEC_NUM_

USER_

VEHICLE_USER_

HPI_RESULTS

PRINT_DATE

PxHpiCis

CustomerType

CoVatNo

AccountNo

CoRegistrationNo

SourceOfEnquiry

VehicleSaleType

LicenseProof

InsuranceProof

PasswordProof

AdminFee

TotExtendedWarranty

RecVehiclePrice

TotVattable

TotVat

TotGapInsurance

TotBrkCover

Tot

DueFromFinanceVehicle

BalanceToPay

TotAccessories

TotNonVatAccessories

RecExtendedWarrantyMonth

RecBreakDown

GrossPx

SettlementPx

CashBack

CarryForward

CashInput

LoanAmount

STOCK_MOT_EXPIRY

ReceiptAmount

ReceiptDate

ReceiptRef

PaidByCustomer

ManufacturerWarrantyMonths

OurWarrantyMonths

RecExtWarrantyMonths

TotWarrantyMonths

MaxClaim

WarrantyType

MaxAmountPerClaim

WarrLabourRate

BreakDownIncluded

RecWarrantyDesc

WearAndTearInc

GapInsuranceAct

AccessoryText

AccessoryVatStatus

AccessoryNet

AccessoryVat

AccessoryTot

WorkshopBranch

GeneralWorkshopNotes

DeliveryColBranch

 








Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article