Secret Squirrel Code

[billyskip]

When I go to this link

https://www.ramtrucks.com/hostz/cots/order-status/60825013/skipper

it shows me some goody code. Just wish I knew what it all means


{"statusCode":"200","orderstatus":[{"statusCode":"C","statusDesc":"Order Confirmed","arrivalDate":"","statusUpdateDate":"2024-06-25","display":"Y","currentStatus":"Y","order":"1"},{"statusCode":"D1","statusDesc":"Scheduled","arrivalDate":"","statusUpdateDate":"","display":"Y","currentStatus":"N","order":"2"},{"statusCode":"E","statusDesc":"In Production","arrivalDate":"","statusUpdateDate":"","display":"Y","currentStatus":"N","order":"3"},{"statusCode":"KZ","statusDesc":"Vehicle Built","arrivalDate":"","statusUpdateDate":"","display":"Y","currentStatus":"N","order":"4"},{"statusCode":"KZM","statusDesc":"Shipped","arrivalDate":"","statusUpdateDate":"","display":"Y","currentStatus":"N","order":"5"},{"statusCode":"KZX","statusDesc":"Delivered","arrivalDate":"","statusUpdateDate":"","display":"N","currentStatus":"N","order":"6"}],"vinDetails":{"brandName":"RAM","modelName":"1500 RHO CREW CAB 4X4 4WD","modelYear":"2025","vin":"1C6SRFUP2SN587985","von":"60825013","paintSalescode":"","bodyModelCode":"DT6S98","cllp":"2TY","image":"https://www.ramtrucks.com/mediaserv...XRB,XSQ,XZ6,YGE,ZDG,ZGZ,ZSG,ZVY&pov=fronthero"},"dealerDetails":{"name":"Davis Chrysler Dodge Jeep Ram of Yulee","address":"464037 State Road 200","city":"Yulee","state":"FL","zip":"32097","phoneNumber":"9044323588","lat":"+03062280","longitude":"-08153460","dealerWebsiteUrl":"https://www.daviscdjr.com"}}

 

[yuppie]

This is just a JSON object, easier to read when "pretty printed":

{
  "statusCode": "200",
  "orderstatus": [
    {
      "statusCode": "C",
      "statusDesc": "Order Confirmed",
      "arrivalDate": "",
      "statusUpdateDate": "2024-06-25",
      "display": "Y",
      "currentStatus": "Y",
      "order": "1"
    },
    {
      "statusCode": "D1",
      "statusDesc": "Scheduled",
      "arrivalDate": "",
      "statusUpdateDate": "",
      "display": "Y",
      "currentStatus": "N",
      "order": "2"
    },
    {
      "statusCode": "E",
      "statusDesc": "In Production",
      "arrivalDate": "",
      "statusUpdateDate": "",
      "display": "Y",
      "currentStatus": "N",
      "order": "3"
    },
    {
      "statusCode": "KZ",
      "statusDesc": "Vehicle Built",
      "arrivalDate": "",
      "statusUpdateDate": "",
      "display": "Y",
      "currentStatus": "N",
      "order": "4"
    },
    {
      "statusCode": "KZM",
      "statusDesc": "Shipped",
      "arrivalDate": "",
      "statusUpdateDate": "",
      "display": "Y",
      "currentStatus": "N",
      "order": "5"
    },
    {
      "statusCode": "KZX",
      "statusDesc": "Delivered",
      "arrivalDate": "",
      "statusUpdateDate": "",
      "display": "N",
      "currentStatus": "N",
      "order": "6"
    }
  ],
  "vinDetails": {
    "brandName": "RAM",
    "modelName": "1500 RHO CREW CAB 4X4 4WD",
    "modelYear": "2025",
    "vin": "1C6SRFUP2SN587985",
    "von": "60825013",
    "paintSalescode": "",
    "bodyModelCode": "DT6S98",
    "cllp": "2TY",
    "image": "https://www.ramtrucks.com/mediaserv...XRB,XSQ,XZ6,YGE,ZDG,ZGZ,ZSG,ZVY&pov=fronthero"
  },
  "dealerDetails": {
    "name": "Davis Chrysler Dodge Jeep Ram of Yulee",
    "address": "464037 State Road 200",
    "city": "Yulee",
    "state": "FL",
    "zip": "32097",
    "phoneNumber": "9044323588",
    "lat": "+03062280",
    "longitude": "-08153460",
    "dealerWebsiteUrl": "https://www.daviscdjr.com"
  }
}

From what I'm seeing here, "statusCode" of "200" is just an HTTP response meaning the request you sent to the URL "https://www.ramtrucks.com/hostz/cots/order-status/60825013/skipper" was OK

After that, it's just telling the frontend of the website what to display...

 

[jb37]

someone else who speaks RAM and JSON

 

[Bigram]

that is just the following in computer language

Status Codes

The entire list is not necessarily in order, depending on your build you may skip a step or move up or down the list as required.

Unscheduled:
BA – order entered in system by dealer
BB – fleet order only – review by bid department
BD – special equipment processing
BE – edit error – coding error which must be corrected before order can be scheduled
BG – order has passed edit but cannot be scheduled regardless of sold status
BX – good order available for scheduling

Scheduled:
C – Tentative schedule. Your order is "subfirm". The plant can see the order at this point but it's not fully committed to building as the supplier may or may not be able to get parts to the plant to build the vehicle.
D – Firm schedule: serial number assigned. Firm order. (This is when you get your VIN assigned)
D1 – Gate line: unit sequenced for production (Get an estimated build date)

Build:
E – Framing. Metal is welded together to form the body and frame. The body is inspected at the end of this step to ensure it's within tolerances.
F – Paint. The metal is coated, primed, sprayed, clear coated, polished, inspected, and hand finished if necessary.
G – Trim. The engine is installed in the chassis, the interior is installed, the chassis is mated to the body, the bed is put on. At the end of this, your new vehicle is built.

Built:
I – unit built, pending final inspection. Your vehicle goes through a battery of shakedown tests and measurements are taken to ensure the vehicle looks and performs as expected.
J – Vehicle passed final inspection but not released to carrier
** BUILD SHEET BECOMES AVAILABLE**
JB – shipped to body vendor. The vehicle is sent off site to have a spray liner put in, steps, graphics etc.
JE – shipped to emissions
JJ – consigned to body vendor
JS – shipped to storage
KZ – released by plant and invoiced. The truck is ready to be shipped. The dealer is actually charged for the truck at this point and can be a source of delay. Typically two statuses here: "Awaiting Shipment" or "Staged for Shipment"

**WINDOW STICKER BECOMES AVAILABLE**

Transit Codes:
KZL – released but not shipped
KZM – first rail departure
KZN – first rail arrival
KZO – delayed/received
KZOA – plant hold, quality audit
KZOB – zone, dealer, sales, vehicle prep, tax, diversion or derailment hold, dealer refusal, vehicle diverted
KZOC – carrier delay, strike-bound, emission or safety hold, rail car shortage, bad or insufficient load, inclement weather, need shipping order, manifest error
KZOD – mechanical failure, glass damage, vehicle in repair, lacking parts or storage hold
KZOE – misdropped or misshipped vehicle
KZOF – shipped air freight, stolen vehicle recovered, show vehicle, test info code, vessel sailed
KZOG – damaged vehicle, stolen vehicle, abandon to carrier, vehicle scrapped, donate vehicle, repair and auction
KZOH – all other “O” type carrier codes
KZP – Truck is sent offsite to a vendor location for shipping
KZR – First Move To Rail Station
KZS – Waiting on rail car
KZT – Second rail departure
KZU – Second rail arrival
KZY1 – major damage – must not be sold as new
KZY2 – major damage – vehicle sold at auction

KZX - Delivered to your dealer!


ZA – Order Canceled (either by you or your dealer)

 

[MattH89]

that is just the following in computer language

Status Codes

The entire list is not necessarily in order, depending on your build you may skip a step or move up or down the list as required.

Unscheduled:
BA – order entered in system by dealer
BB – fleet order only – review by bid department
BD – special equipment processing
BE – edit error – coding error which must be corrected before order can be scheduled
BG – order has passed edit but cannot be scheduled regardless of sold status
BX – good order available for scheduling

Scheduled:
C – Tentative schedule. Your order is "subfirm". The plant can see the order at this point but it's not fully committed to building as the supplier may or may not be able to get parts to the plant to build the vehicle.
D – Firm schedule: serial number assigned. Firm order. (This is when you get your VIN assigned)
D1 – Gate line: unit sequenced for production (Get an estimated build date)

Build:
E – Framing. Metal is welded together to form the body and frame. The body is inspected at the end of this step to ensure it's within tolerances.
F – Paint. The metal is coated, primed, sprayed, clear coated, polished, inspected, and hand finished if necessary.
G – Trim. The engine is installed in the chassis, the interior is installed, the chassis is mated to the body, the bed is put on. At the end of this, your new vehicle is built.

Built:
I – unit built, pending final inspection. Your vehicle goes through a battery of shakedown tests and measurements are taken to ensure the vehicle looks and performs as expected.
J – Vehicle passed final inspection but not released to carrier
** BUILD SHEET BECOMES AVAILABLE**
JB – shipped to body vendor. The vehicle is sent off site to have a spray liner put in, steps, graphics etc.
JE – shipped to emissions
JJ – consigned to body vendor
JS – shipped to storage
KZ – released by plant and invoiced. The truck is ready to be shipped. The dealer is actually charged for the truck at this point and can be a source of delay. Typically two statuses here: "Awaiting Shipment" or "Staged for Shipment"

**WINDOW STICKER BECOMES AVAILABLE**

Transit Codes:
KZL – released but not shipped
KZM – first rail departure
KZN – first rail arrival
KZO – delayed/received
KZOA – plant hold, quality audit
KZOB – zone, dealer, sales, vehicle prep, tax, diversion or derailment hold, dealer refusal, vehicle diverted
KZOC – carrier delay, strike-bound, emission or safety hold, rail car shortage, bad or insufficient load, inclement weather, need shipping order, manifest error
KZOD – mechanical failure, glass damage, vehicle in repair, lacking parts or storage hold
KZOE – misdropped or misshipped vehicle
KZOF – shipped air freight, stolen vehicle recovered, show vehicle, test info code, vessel sailed
KZOG – damaged vehicle, stolen vehicle, abandon to carrier, vehicle scrapped, donate vehicle, repair and auction
KZOH – all other “O” type carrier codes
KZP – Truck is sent offsite to a vendor location for shipping
KZR – First Move To Rail Station
KZS – Waiting on rail car
KZT – Second rail departure
KZU – Second rail arrival
KZY1 – major damage – must not be sold as new
KZY2 – major damage – vehicle sold at auction

KZX - Delivered to your dealer!


ZA – Order Canceled (either by you or your dealer)

...no it isn't? The JSON quoted is the data to populate his specific build tracker.

 

[Brian]

...no it isn't? The JSON quoted is the data to populate his specific build tracker.

This is correct. This is what I'm thinking:

The individual entries in the "array" of data will become populated as the build progresses through the various stages until completion. This data will help the build tracker decide what graphics/data to show users.

I can see that there is already a date for "the Order Confirmed" status: 2024-06-25. Here's what I see for that stage of the build process:

{
"statusCode": "C",
"statusDesc": "Order Confirmed",
"arrivalDate": "",
"statusUpdateDate": "2024-06-25",
"display": "Y",
"currentStatus": "Y",
"order": "1"
}

No statusUpdateDate values are provided yet for "Scheduled", "In Production", "Vehicle Built", etc..., which is why you can see an empty string "" for those values. Example (this entry is most likely updated when build has actually been scheduled):

{
"statusCode": "D1",
"statusDesc": "Scheduled",
"arrivalDate": "",
"statusUpdateDate": "",
"display": "Y",
"currentStatus": "N",
"order": "2"
}

These values will likely be updated as the build process progresses.

Hope this helps a bit.