Here's my value 12/007365121440. I'm trying to remove the characters before the /. I tried using a regexReplace and a regexMatch, but I'm having a hard time understanding what the full Handlebar should be. Any suggestions?
And yes, you are interpreting correctly!
Hey Jack,
Removing all the PII, can you paste the Mock Data here? As per the error message, it means that the field you referenced doesn't exist in the data.
Regards,
Lakhan Bhagnani
Jack,
If you just want the data after the / then I would suggest using the SPLIT function
{{split myData "/" 1}}
That did exactly what I needed it to. Thanks!
{
"HeaderInformation": [
{
"CODE CLIENT": "MAR08"
},
{
"TRXSet": "ASN"
},
{
"ROUTE": "MAR08"
},
{
"COMPANY": "W1"
}
],
"ReferenceInformation": [
{
"ReportingCode": "0",
"DepositorOrderNumber": "269358",
"Date": "20240325",
"ShipmentID": "",
"Agent Shipment ID": "2097014",
"PurchaseOrderNumber": "10009626",
"AlternateReference1": "",
"LoadNumber": "0120",
"SpecialHandlingCode": "",
"ReasonCode": "",
"TransactionTypeCode": "",
"ActionCode": "",
"Tracking_Number": "002097014",
"Reference1": "0244185840000",
"Reference2": "ASN",
"Reference3": "MARING2871",
"Reference4": "0002064",
"LoadExternalNumber": "",
"CarrierProNumber": "",
"Names": [
{
"OrganizationIDCode": "WH",
"Name": "Distribution"
},
{
"OrganizationIDCode": "DE",
"Name": "FOODS"
},
{
"OrganizationIDCode": "ST",
"Name": "MARKETS INC",
"IDType": "91",
"EntityCode": "0244185840000"
}
],
"Addresses": [
{
"Address1": "WAREHOUSE 2913",
"Address2": "US HIGHWAY WEST",
"Address3": "",
"Address4": ""
}
],
"GeographicLocation": [
{
"City": "MOUNTAIN",
"State": "",
"Zip": "",
"Country": "US"
}
],
"DateTimes": [
{
"DateQualifier": "02",
"Date": "20240325"
},
{
"DateQualifier": "10",
"Date": "20240325"
},
{
"DateQualifier": "52",
"Date": "20240311"
}
],
"WarehouseCarrierInformation": [
{
"TransportationMethod": "H",
"SCAC": "CPU",
"Routing": "CUSTOMER PICK-UP",
"MethodofPayment": "CC",
"EquipmentDescriptionCode": "",
"EquipmentInitial": "",
"EquipmentNumber": "",
"ShipmentOrderStatusCode": "",
"SpecialHandlingCode": "",
"CarrierChangeReasonCode": "",
"PowerUnitNumber": "",
"CarryUnitNumber": "",
"VesselNumber": "",
"VoyageNumber": ""
}
],
"ConsolidationInformation": [
{
"PackagingCode": "PLT49",
"LadingQuantity": "1373",
"Weight": "14278.7",
"WeightQualifier": "G",
"WgtUOM": "LB"
}
],
"WarehouseAdditionalCarrierInfo": []
}
],
"LineInformation": [
{
"AssignedNumber": "000001",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "11",
"ShippedQuantity": "11",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365112862",
"Level2": "SEP122025",
"Level3": "355122",
"Level4": "",
"GrsWgt": "85.25",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "85.25",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695488",
"ExpiryDate": "20250912",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "FRUIT SPREAD PREMIUM STRAWBERRY",
"AlternateItemDesc": "STRAWBERRY FRUIT SPREAD",
"ExtendedDesc": "8/007365112862"
},
{
"AssignedNumber": "000002",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "31",
"ShippedQuantity": "31",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365112862",
"Level2": "SEP122025",
"Level3": "355128",
"Level4": "",
"GrsWgt": "240.25",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "240.25",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695488",
"ExpiryDate": "20250912",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "FRUIT SPREAD PREMIUM STRAWBERRY",
"AlternateItemDesc": "STRAWBERRY FRUIT SPREAD",
"ExtendedDesc": "8/007365112862"
},
{
"AssignedNumber": "000003",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "44",
"ShippedQuantity": "44",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365151221",
"Level2": "MAR222026",
"Level3": "345107",
"Level4": "",
"GrsWgt": "677.60",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "677.60",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695495",
"ExpiryDate": "20260322",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "135-1 12/7 LOW SALT ST MZ",
"AlternateItemDesc": "12/7 OZ JAR MARIO SMT REDUCED SALT - PAR",
"ExtendedDesc": "12/007365151221"
},
{
"AssignedNumber": "000004",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "41",
"ShippedQuantity": "41",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365121440-DEHK",
"Level2": "030326",
"Level3": "345453",
"Level4": "",
"GrsWgt": "492.00",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "492.00",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695501",
"ExpiryDate": "20260303",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "921 12/6 EXLARGE PITTED RIPE OLIVES",
"AlternateItemDesc": "12/6 OZ TIN TRAY MARIO EX LG BLACK PITTED",
"ExtendedDesc": "12/007365121440"
},
{
"AssignedNumber": "000005",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "4",
"ShippedQuantity": "4",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365121440-DEHK",
"Level2": "030326",
"Level3": "345464",
"Level4": "",
"GrsWgt": "48.00",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "48.00",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695501",
"ExpiryDate": "20260303",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "921 12/6 EXLARGE PITTED RIPE OLIVES",
"AlternateItemDesc": "12/6 OZ TIN TRAY MARIO EX LG BLACK PITTED",
"ExtendedDesc": "12/007365121440"
},
{
"AssignedNumber": "000006",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "90",
"ShippedQuantity": "90",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365121428-WA",
"Level2": "DEC232025",
"Level3": "342186",
"Level4": "",
"GrsWgt": "1170.00",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "1170.00",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695518",
"ExpiryDate": "20251223",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "916 12/6 LARGE PITTED RIPE OLIVES",
"AlternateItemDesc": "12/6 OZ CAN MARIO LARGE BLACK PITTED",
"ExtendedDesc": "12/007365121428"
},
{
"AssignedNumber": "000007",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "10",
"ShippedQuantity": "10",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365111746",
"Level2": "DEC212025",
"Level3": "353782",
"Level4": "",
"GrsWgt": "120.00",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "120.00",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695525",
"ExpiryDate": "20251221",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "12/6 OZ JAR MARIO SALAD",
"AlternateItemDesc": "12/6 OZ JAR MARIO SALAD",
"ExtendedDesc": "12/007365111746"
},
{
"AssignedNumber": "000008",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "1",
"ShippedQuantity": "1",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365111746",
"Level2": "DEC212025",
"Level3": "353782",
"Level4": "",
"GrsWgt": "12.00",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "12.00",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695525",
"ExpiryDate": "20251221",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "12/6 OZ JAR MARIO SALAD",
"AlternateItemDesc": "12/6 OZ JAR MARIO SALAD",
"ExtendedDesc": "12/007365111746"
},
{
"AssignedNumber": "000009",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "97",
"ShippedQuantity": "97",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365111746",
"Level2": "DEC212025",
"Level3": "353784",
"Level4": "",
"GrsWgt": "1164.00",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "1164.00",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695525",
"ExpiryDate": "20251221",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "12/6 OZ JAR MARIO SALAD",
"AlternateItemDesc": "12/6 OZ JAR MARIO SALAD",
"ExtendedDesc": "12/007365111746"
},
{
"AssignedNumber": "000010",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "9",
"ShippedQuantity": "9",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365121422",
"Level2": "JAN242026",
"Level3": "341306",
"Level4": "",
"GrsWgt": "117.00",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "117.00",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695532",
"ExpiryDate": "20260124",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "911 12/6 MEDIUM PITTED RIPE OLIVES",
"AlternateItemDesc": "12/6 OZ CAN MARIO MEDIUM BLACK PITTED",
"ExtendedDesc": "12/007365121422"
},
{
"AssignedNumber": "000011",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "126",
"ShippedQuantity": "126",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365121422",
"Level2": "JAN242026",
"Level3": "341313",
"Level4": "",
"GrsWgt": "1638.00",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "1638.00",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695532",
"ExpiryDate": "20260124",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "911 12/6 MEDIUM PITTED RIPE OLIVES",
"AlternateItemDesc": "12/6 OZ CAN MARIO MEDIUM BLACK PITTED",
"ExtendedDesc": "12/007365121422"
},
{
"AssignedNumber": "000012",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "41",
"ShippedQuantity": "41",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365111710-A",
"Level2": "DEC222025",
"Level3": "339560",
"Level4": "",
"GrsWgt": "759.32",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "759.32",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695549",
"ExpiryDate": "20251222",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "GREEN OLIVES STF W/PIMIENTO",
"AlternateItemDesc": "STUFFED WITH PIMIENTO",
"ExtendedDesc": "6/007365111710"
},
{
"AssignedNumber": "000013",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "19",
"ShippedQuantity": "19",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365111710-A",
"Level2": "DEC222025",
"Level3": "339564",
"Level4": "",
"GrsWgt": "351.88",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "351.88",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695549",
"ExpiryDate": "20251222",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "GREEN OLIVES STF W/PIMIENTO",
"AlternateItemDesc": "STUFFED WITH PIMIENTO",
"ExtendedDesc": "6/007365111710"
},
{
"AssignedNumber": "000014",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "68",
"ShippedQuantity": "68",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "073651161314",
"ItemCode": "7365179702",
"Level2": "SEP262025",
"Level3": "356143",
"Level4": "",
"GrsWgt": "482.80",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "482.80",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695556",
"ExpiryDate": "20250926",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "GREEN CASTLEVELTRANO OLIVES 160/180",
"AlternateItemDesc": "PITTED GREEN CASTELEVELTRANO OLIVES",
"ExtendedDesc": "6/007365179702"
},
{
"AssignedNumber": "000015",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "50",
"ShippedQuantity": "50",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365111833",
"Level2": "MAR142026",
"Level3": "345510",
"Level4": "",
"GrsWgt": "225.00",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "225.00",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695563",
"ExpiryDate": "20260314",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "SLCD GREEN OLIVES 12/2.25OZ",
"AlternateItemDesc": "12/2.25 OZ CAN MARIO SLICED GREEN",
"ExtendedDesc": "12/007365111833"
},
{
"AssignedNumber": "000016",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "12",
"ShippedQuantity": "12",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365116132",
"Level2": "JUN222025",
"Level3": "351544",
"Level4": "",
"GrsWgt": "94.80",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "94.80",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695570",
"ExpiryDate": "20250622",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "GREEN OLIVES",
"AlternateItemDesc": "STUFFED WITH FETA CHEESE",
"ExtendedDesc": "6/007365116132"
},
{
"AssignedNumber": "000017",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "26",
"ShippedQuantity": "26",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365116132",
"Level2": "JUN222025",
"Level3": "351552",
"Level4": "",
"GrsWgt": "205.40",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "205.40",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695570",
"ExpiryDate": "20250622",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "GREEN OLIVES",
"AlternateItemDesc": "STUFFED WITH FETA CHEESE",
"ExtendedDesc": "6/007365116132"
},
{
"AssignedNumber": "000018",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "68",
"ShippedQuantity": "68",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365111706",
"Level2": "OCT282025",
"Level3": "360577",
"Level4": "",
"GrsWgt": "817.36",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "817.36",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695587",
"ExpiryDate": "20251028",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "133 12/5.75OZ STUFFED GREEN OLIVES W/PIM",
"AlternateItemDesc": "STUFFED GREEN OLIVE STUFFED W PIMIENTO",
"ExtendedDesc": "12/007365111706"
},
{
"AssignedNumber": "000019",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "34",
"ShippedQuantity": "34",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365111706",
"Level2": "OCT282025",
"Level3": "360578",
"Level4": "",
"GrsWgt": "408.68",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "408.68",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695587",
"ExpiryDate": "20251028",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "133 12/5.75OZ STUFFED GREEN OLIVES W/PIM",
"AlternateItemDesc": "STUFFED GREEN OLIVE STUFFED W PIMIENTO",
"ExtendedDesc": "12/007365111706"
},
{
"AssignedNumber": "000020",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "51",
"ShippedQuantity": "51",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365121470-WA",
"Level2": "122125",
"Level3": "341208",
"Level4": "",
"GrsWgt": "663.00",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "663.00",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695594",
"ExpiryDate": "20251221",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "931 12/5.75 JUMBO PITTED RIPE OLIVES",
"AlternateItemDesc": "12/5.75 OZ CAN MARIO JUMBO BLACK PITTED",
"ExtendedDesc": "12/007365121470"
},
{
"AssignedNumber": "000021",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "149",
"ShippedQuantity": "149",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365121405",
"Level2": "DEC192025",
"Level3": "339423",
"Level4": "",
"GrsWgt": "1385.70",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "1385.70",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695600",
"ExpiryDate": "20251219",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "980 24/2.25 SLICED RIPE OLIVES TRAY PACK",
"AlternateItemDesc": "24/2.25 OZ CAN MARIO SLICED BLACK OLIVE TRAY PK",
"ExtendedDesc": "24/007365121405"
},
{
"AssignedNumber": "000022",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "71",
"ShippedQuantity": "71",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365121405",
"Level2": "DEC192025",
"Level3": "339424",
"Level4": "",
"GrsWgt": "660.30",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "660.30",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695600",
"ExpiryDate": "20251219",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "980 24/2.25 SLICED RIPE OLIVES TRAY PACK",
"AlternateItemDesc": "24/2.25 OZ CAN MARIO SLICED BLACK OLIVE TRAY PK",
"ExtendedDesc": "24/007365121405"
},
{
"AssignedNumber": "000023",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "198",
"ShippedQuantity": "198",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "073651214089",
"ItemCode": "7365121408",
"Level2": "FEB102026",
"Level3": "342777",
"Level4": "",
"GrsWgt": "1514.70",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "1514.70",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695617",
"ExpiryDate": "20260210",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "SLICED RIPE 12/3.8 TIN",
"AlternateItemDesc": "SLICED RIPE 12/3.8 TIN",
"ExtendedDesc": "12/007365121408"
},
{
"AssignedNumber": "000024",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "42",
"ShippedQuantity": "42",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365112864",
"Level2": "SEP132025",
"Level3": "356605",
"Level4": "",
"GrsWgt": "325.50",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "325.50",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695624",
"ExpiryDate": "20250913",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "FRUIT SPREAD PREMIUM RASPBERRY",
"AlternateItemDesc": "RASPBERRY FRUIT SPREAD",
"ExtendedDesc": "8/007365112864"
},
{
"AssignedNumber": "000025",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "38",
"ShippedQuantity": "38",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "073651161338",
"ItemCode": "7365116133",
"Level2": "NOV132026",
"Level3": "359731",
"Level4": "",
"GrsWgt": "293.36",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "293.36",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695631",
"ExpiryDate": "20261113",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "GREEN OLIVES",
"AlternateItemDesc": "STUFFED WITH REAL PIMIENTO. OLIVES",
"ExtendedDesc": "6/007365116133"
},
{
"AssignedNumber": "000026",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "42",
"ShippedQuantity": "42",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365112867",
"Level2": "DEC162024",
"Level3": "355159",
"Level4": "",
"GrsWgt": "326.76",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "326.76",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695655",
"ExpiryDate": "20241216",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "FRUIT SPREAD PREM 8/GLTRY PK APRICOT",
"AlternateItemDesc": "APRICOT FRUIT SPREAD",
"ExtendedDesc": "8/007365112867"
}
],
"NumberofUnitsShipped": "1373",
"TotalWeight": "14278.7",
"UOM": "LB"
}