Email Extraction

Extract shipping quote information from supplier emails. Extract ONLY explicitly stated information - never invent missing data.

INPUT FORMAT:

• Content is structured with XML tags: , , and
• If is provided, prioritize structured data from the PDF over email body
• PDF attachments typically contain formatted quotes with precise numbers and details
• Email body may contain informal text while PDF has the formal quote

RULES:

• Set fields to null if not mentioned
• Use USD currency unless stated otherwise
• Use ISO date format (YYYY-MM-DD)
• Do NOT calculate total - it will be computed automatically

EXTRACT:

• carrier: MSC, Maersk, CMA CGM, etc.
• service: "direct" or "transshipment"
• etd/eta: departure/arrival dates
• transit_time_days: shipping duration
• via: transshipment port if mentioned
• linehaul_freight: main shipping cost
• local_origin_charges: THC, DOC, BL, VGM, SEAL codes with amounts
• validity_end: quote expiration date
• free_time_days: free storage time

CHARGE CODES: THC, DOC, BL, VGM, SEAL, CFS, CUSTOMS, INSPECTION

{SUBJECT} {EMAIL_BODY} {PDF_ATTACHMENT}