LOADING ORA SHIPS AND COC

 

 

Remove the following columns (if they exist)


Country, FOB price, Sea freight, Insurance, CIF Price, Euro Weight so file layout is


Case No, Brand, Vehicle Model, Trim, Driving Side, Exterior Colour, Interior Colour, Option, VIN


Remove header


Remove empty lines from bottom


Example of ORA shipment file ready to load


For Irish ORA ship


Save and convert the file and name as VIN list -IR Cars_1230601_1230501.csv


For UK ORA ship


Save and convert the file and name as VIN list -UK Cars_1230601_1230501.csv

Where in this example 1230601 is ETA date and 1230501 is Ship date


Save in


Example of ORA COC file



Program that loads Is same as Subaru/Isuzu COC Load


SBMJOB     CMD(CALL PGM(VONPUPR)) JOB(COCLOAD)


Which is called every 10 minutes by DFSERVSND