DOC ID: TRM-ARCH-2026.10 • CLASSIFICATION: BORDER COOLER, ERP & BUYER ARCHITECTURE SPEC
PHYSICAL RAIL: MX/PE ORIGIN (+52/+51) → US BORDER COOLER STAGING → 53' MIXED OTR • ● VERIFIED LIVE
2-PAGE ARCHITECTURE & COLD-CHAIN DATA SHEET • REV 2026.10

Tarima.Cool: Cross-Border Cold-Chain, US Border Cooler Staging & ERP / EDI 856 Spec

Two-page engineering and biological reference sheet for IT Directors, Famous Software (Oracle/SQL), Silo ERP, and Produce Pro Administrators, US Border Cold-Storage Operators (McAllen/Pharr, Nogales, Laredo, Otay Mesa, Pompano, Vineland), and PACA / DRC Produce Buyers.

✓ Full 2-Page Technical Data Sheet Unlocked: Oracle SQL / Famous ERP table mappings, X12 EDI 856 ASN segments, and the 5-crop 53-foot reefer matrix are now unlocked for viewing and PDF printing.
30 sec
Origin Shed WhatsApp Capture (+52/+51) • $0 Free
6-12 hrs
Pre-Arrival Famous / Silo ERP Sync Before Bridge
< 48 hrs
US Border Cooler Cross-Dock Floor Turn Target
+4 to +5 Days
Retail Shelf Life Gained by Bypassing Inland Re-Warehousing
THE 2-STAGE CROSS-BORDER REALITY: ORIGINATES IN MEXICO / PERU → PHYSICALLY STAGED IN US BORDER COOLERS → DIRECT 53' MIXED LOAD TO BUYER

Over 80% of North American tropical volume originates at packing sheds in Mexico (+52) (with ~20% arriving by ocean/air from Peru / Central America), but virtually 100% of Mexican overland loads are physically unloaded and staged inside a US border cold-storage warehouse (McAllen/Pharr TX, Nogales AZ, Laredo TX, Otay Mesa CA) for CBP/USDA inspection, drayage transfer, and quality grading. Tarima.Cool turns that mandatory US border cooler floor into a high-velocity consolidation hub, eliminating the expensive second inland middleman warehouse hop.

STAGE 1 • ORIGIN SHED (+52 / +51)

Mexico & Peru Packing Houses

Michoacan, Sinaloa, Veracruz, Jalisco & Piura. Shed snaps paper manifiesto + 6s voice note on WhatsApp to mint the FSMA 204 TLC & 4-digit PTI Voice Pick code at departure.

STAGE 2 • US BORDER STAGING (MANDATORY)

US Border Cooler Floor (Pharr / Nogales)

Drayage truck crosses the bridge and unloads into the US border cooler. Lots are already pre-staged in Famous / Silo ERP 6-12h early to publish the 5:30 AM Day-1 Sheet.

STAGE 3 • OUTBOUND 53' MULTI-ZONE OTR

Direct to Supermarket DC / Wholesaler

The US border cooler builds a 3-zone 53' mixed reefer (40.5°F / 48.5°F / 53.0°F) and fires a compliant X12 EDI 856 ASN straight to the US/Canadian receiver.

1. Origin Packing Shed Ingestion (+52 Mexico / +51 Peru)

Origin Shed Cost: $0 Free Forever on WhatsApp (zero app downloads or proprietary hardware).

  • 30-Second Multimodal Capture: WhatsApp photo of paper manifiesto de embarque + cellular temperature logger barcode + 6-second Spanish voice note.
  • Extracted QA Fields: Origin municipality/block, harvest and initial pack dates, forced-air precooling pulp temp (°F), Dry Matter % (avocados), Brix (mangos/pineapples), juice % (limes).
  • Regulatory Output: FDA FSMA Rule 204 Traceability Lot Code (TLC) + GS1-128 GTIN-14 case/pallet label with 4-digit PTI Voice Pick Code.

2. US Border Cooler Staging & ERP Pre-Arrival Sync

Pre-Arrival Lead Time: Injected 6 to 12 hours before the transfer truck unloads in McAllen/Pharr, Nogales, Laredo, or Otay Mesa.

  • Famous Software (Oracle RDBMS / PL-SQL / XML): Direct staging table & XML import bridge for grower lot receiving, custom Oracle SQL grower liquidation views, and Crystal Reports.
  • Silo ERP & Produce Pro: Bidirectional REST JSON / Webhook connector for pallet-level cooler age tracking (<48-hour target floor turns) and multi-commodity buyer order allocation.
  • X12 EDI 856 ASN (4010 / 5010): Automated Advance Ship Notice generation (`HL` Shipment → Order → Tare SSCC-18 → Item GTIN-14 + Lot TLC) routed to iTradeNetwork, SPS Commerce, and Cleo.
🔒 PAGE 2 OF 2 • ERP SCHEMA, EDI 856 MAPPING & 53' REEFER SPEC

Unlock Page 2 & Full 2-Page Printable PDF Data Sheet

Enter your work details below to immediately unblur the 5-Crop 53-Foot Multi-Zone Reefer Matrix, the Famous Oracle SQL / Silo / X12 EDI 856 Field Mapping Table, and one-click PDF printing.

Instant inline unlock (no email wait) • Remembers your browser • Formatted for 2-page US Letter PDF

3. 5-Crop Biological Cold-Chain Matrix & 53-Foot Multi-Zone Reefer Layout (22 Pallets)

Tropical Commodity Origin Shed → US Staging Hub Target Pulp Temp Chilling Floor Internal QA Standard Ethylene Profile & 53' Reefer Zone
Hass Avocados Michoacan / Jalisco → Pharr / Laredo 40.0°F - 42.0°F (4.4°C-5.5°C) 38.0°F 24.0%+ Dry Matter High producer • Zone A (Nose P1-P8 at 40.5°F with KMnO4 scrubber)
Golden MD2 Pineapples Veracruz / Costa Rica → Pharr / Pompano 45.0°F - 47.0°F (7.2°C-8.3°C) 44.0°F 15.0°+ Brix Low producer • Zone B (Center Bay P9-P12 at 48.5°F)
Seedless Persian Limes Veracruz / Yucatan → Pharr / McAllen 48.0°F - 52.0°F (8.9°C-11.1°C) 46.0°F 52.0%+ Juice • Emerald Rind Ethylene-sensitive • Zone B (Center Bay P13-P16 isolated from Zone A)
Honey (Ataulfo) & Kent Mangos Sinaloa / Chiapas / Peru → Nogales / Pharr 50.0°F - 54.0°F (10.0°C-12.2°C) 50.0°F 14.0° - 15.5°+ Brix Chilling-sensitive <50°F • Zone C (Tail Doors P17-P22 at 53.0°F)
Jumbo Blueberries Peru / Jalisco / Sinaloa → Vineland / Nogales 32.0°F - 34.0°F (0.0°C-1.1°C) 30.0°F 16mm+ Firm Silver Bloom Low producer • Dedicated Cold Nose (32.5°F)

4. Famous ERP (Oracle SQL), Silo ERP & X12 EDI 856 ASN Field Mapping (FSMA 204 KDE)

Tarima Lot Passport Field FDA FSMA Rule 204 KDE X12 EDI 856 ASN / GS1-128 Segment Famous ERP (Oracle RDBMS) / Silo / Produce Pro Target
traceability_lot_code Traceability Lot Code (TLC) LIN*...*LT*TRM-8910 / AI (10) Famous Tag / Lot Master (FAMOUS_LOT_ID) • Silo lotNumber
gtin14_case + pack_date Product Description & Pack Date LIN*...*UP*10850049123015 / AI (01) + (13) Famous GTIN / PTI Label Table + Deterministic 4-Digit VOICE_PICK_CODE
sscc18_pallet_tare Shipping Unit Identifier HL*3*2*T → MAN*GM*0010850049... Famous Pallet Tag Inventory (PALLET_TAG_NO) • 48h Floor Turn Clock
origin_municipality + pulp_temp_f Harvest / First Receiver Location & QA MEA*PD*TC*41.2*FA + REF*OR*URUAPAN Grower Liquidation View (Oracle SQL) + PACA / DRC Good-Arrival Defense

5. Logistics Lakehouse & Reefer Carrier Telemetry

  • 15,143 Active Refrigerated Produce Carriers (FMCSA): Indexed with USDOT, power unit count, corridor classification (1,776 MX-domiciled, 4,376 Canada DRC, Pharr, Laredo, Nogales) and direct dispatch contacts.
  • 29 US CBP Commercial Truck Ports: Live standard and FAST lane delay telemetry (bwt.cbp.gov).
  • 14-Day Grove Precipitation Radar: Predicts orchard harvest pauses across 8 MX/PE municipalities 5 to 10 days before US border cooler supply tightens.

6. Public AI / GEO Discovery Endpoints (/api/ai/*)

PRO DESK & ERP BRIDGE

Unlock Live ERP Sync, X12 EDI 856 ASN & 5:30 AM Day-1 Lot Sheets

Single-lot PTI Voice Pick checksums, FSMA 204 KDE previews, and macro 14-day grove weather are 100% free forever. Production webhooks into Famous Software (Oracle/SQL), Silo ERP, Produce Pro, automated X12 EDI 856 ASN streams, and the 15,143 Cross-Border Reefer Carrier Directory are provisioned for verified cooler and buying desks.