^ordered

+

-

if workflow have "Ordered" text

^{Production plan}

+

-

if workflow have "Production plan" text

^Production

+

-

if workflow have "Production" text

^{In transit}

+

-

if workflow have "In transit" text

^{Arrived branch}

+

-

if workflow have "Arrived branch" text

^{Harbour arrived}

+

-

if workflow have "Harbour arrived" text

^{Harbour departed}

+

-

if workflow have "Harbour departed" text

^{Jump off}

+

-

if workflow have "Jump off" text

^delivered

+

-

if workflow have "delivered" text or delivered field in file = "yes"

^Sold

+

-

if workflow have "Sold" text or sold field in file = "yes"

^orderNumber

-

-

Used as Primary Key. Never updated

^salesman

-

+

Salesman

endItemCode

-

+

End Item Code

kobraNotes

-

+

Notes

^{dealerInvoiceRef}

-

+

^{Dealer invoice ref}

^orderClass

-

+

Order class

^{purchaseInvoiceRef}

-

+

^{Purchase invoice ref}

^dealership

-

+

^dealership

^{dealerInvoiceDate}

-

+

^{Dealer invoice date}

^{dealerInvoicePaidDate}

-

+

^{Dealer invoice paid date}

^{transportRequestedDate}

-

+

^{Transport requested date}

^{harbourCheckoutDate}

-

+

^{Harbour checkout date}

^{deliveredDate}

-

+

^{Delivered date}

^customer

-

+

Customer

submodel

-

+

Submodel

^{current location}

-

+

Current Location

^VIN

-

+

VIN

^engineNumber

-

+

^{Engine number}

^colorCode

-

+

Exterior

^costs

-

+

^Costs

importerStatus

-

+

^{Importer status}

orderPack

-

+

Order pack

modelYear

-

+

Model year

interiorCode

-

+

int. code

regNumber

-

+

reg. nubmber

estimatedProductionDate

-

+

Estimated production date

purchaseInvoiceDate

-

+

Purchase invoice date

arrivedBranchDate

-

+

Branch check-in date

etaDate

-

+

ETA date

orderDate

-

+

Order date

preOrderDate

-

+

^{Pre order date}

productionDate

-

+

Production date

harborArrivedDate

-

+

Harbour arrived date

inTransitDate

-

+

In transit date

deliveryArrangedDate

-

+

Delivery date & time

workshopDate

-

+

Workshop date & time

^{dealerInvoiceSum}

-

+

Dealer invoice sum

^{dealerInvoiceTermDate}

-

+

Dealer invoice term

^{dealerInvoiceRef}

-

+

^{Dealer invoice ref}

^{customerInvoiceRef}

-

+

^{Customer invoice ref}

^{purchaseInvoiceSum}

-

+

^{Purchase invoice sum}

^{harborRequestedDate}

-

+

^{Harbour check-out date}

^{harborRequestAcceptedDate}

-

+

^{Harbour request acceptance date}

^{customerInvoiceDate}

-

+

^{Customer invoice date}

^{customerInvoicePaidDate}

-

+

^{Customer invoice paid date}

^{partsFittedDate}

-

+

^{Parts fitted Date}

^{partsArrivedDate}

-

+

^{Parts arrived Date}

^{partsCheckedDate}

-

+

^{Parts checked Date}

^{partsOrderedDate}

-

+

^{Parts ordered Date}

^workshopDate

-

+

^{Workshop date & time}

special price

-

+

Vehicle special price

fullMass

-

+

Full mass

co2

-

-

CO2