Demurrage invoice appeals system map: the identifiers that join terminal, clearance, inbox and ERP records

Short answer

Five shared identifiers stitch one demurrage dispute together: the container number, the bill of lading number, the customs entry number, the carrier's invoice number and the service contract number, with the ERP's own vendor bill and credit memo IDs tying the ledger entries to each other. Each identifier sits in some of the five places that hold the case, never in all of them. The fragile join is usually the inspection hold, recorded only in a clearance agent's message whose entry number appears nowhere in the ledger.

Visual briefFull-size diagram
Five record holders in a row, terminal system, clearance agent, payables inbox, ERP and contract folder, with five key bars (container number, bill of lading, entry number, invoice number, contract number) growing across the systems that share them; the entry number bar is dashed orange as the weakest join.
Illustrative system map; the keys each company actually records decide which links hold.

This map is part of the parent guide. The guide sets out what to inventory before a port vendor change; this page traces which identifier lives where, so a partner can tell whether a company's dispute history can be followed from first event to final credit.

Five record holders, one shipment

  • Terminal system. Unloading, availability and gate-out timestamps, a hold flag where the operator shows one, sometimes a last free day. Primary identifier: the container number.
  • Clearance agent. Inspection selection, hold and lifting notices, entry records. Primary identifier: the entry number, with the container number only if the agent typed it.
  • Payables inbox. Carrier bills as PDFs, the challenge emails and the dispute desk's answers. Primary identifier: the carrier's invoice number.
  • ERP. Vendor bills, credit memos, payments and the job file. Primary identifiers: internal document IDs, plus whatever outside numbers staff keyed in.
  • Contract folder. Tariffs, service contracts and amendments fixing free days and daily rates. Primary identifier: the contract or amendment number.

Identifier map: system, record, linking key, owner

The evidence asset for this page. Each row names a record, the field that should carry a shared identifier, and who can confirm whether it does.

SystemRecordLinking keyOwner
Terminal systemUnloading, availability, gate-out timestampsContainer numberImport coordinator
Terminal systemHold flagContainer numberImport coordinator
Clearance agentHold and lifting noticesEntry number plus container numberCustoms compliance manager
Payables inboxCarrier bill PDFInvoice number plus container numberLogistics accountant
Payables inboxChallenge email and replyInvoice number in the subject lineLogistics accountant
ERPVendor billVendor bill ID, invoice number, container in line or memo fieldPayables lead
ERPCredit memoCredit memo ID referencing the vendor bill IDPayables lead
ERPJob fileBill of lading number plus container numberOperations manager
Contract folderTariff or service contractContract number printed on the bill of lading or invoiceProcurement or finance director

Federal billing rules make one join dependable: carrier and terminal bills must identify the boxes, including the bill of lading number and container number, and state free time, the dates charged and the rate. So the invoice almost always carries both keys and becomes the bridge between timestamps and ledger. The same rules let a billing party that sent the bill to the wrong party reissue it only within the 30-day window, and in 2025 the D.C. Circuit set aside the provision on who may be invoiced while leaving the rest in force, so the billed party can change from case to case. The map should record whether bills arrive at the forwarder, the importer or both. This is general information, not legal advice.

LinkHow it breaksQuestion for the finance director
Clearance agent to everything elseLifting notice sits in the agent's system or a personal inboxAre the agent's hold and release messages filed with the job?
Terminal system to ERPContainer number typed into a memo field, or not at allWas the container keyed on the vendor bill line?
Credit memo to billCredit netted against a later invoice instead of the originalDo credit memos reference the original vendor bill ID?
Contract to invoiceFree-time terms live in an amendment nobody indexedWhere are tariffs and service contract amendments filed?
Terminal historyTimestamps expire or end with the terminal system contractHow many years of events can still be viewed or downloaded?

Export capability and history depth vary by terminal operator, so the company should confirm them with each provider. Where invoices were paid through a separate AP tool, the page on Bill.com invoice history lists the questions for that layer.

One case joined end to end (Illustrative)

Built for this page from the worked exception example: a fictional 340-person forwarder, one import container, a customs hold on day 3, six days billed at $175 a day. All identifiers are placeholders.

OrderRecordSystemKeys carriedJoins to
1Free time of four days, then $175 per dayContract folderService contract SC-12Row 5
2Discharge day 0, gate-out day 10Terminal systemContainer C-1Rows 3 and 5
3Hold placed day 3, released day 8Clearance agent emailEntry E-55, container C-1Rows 2 and 6
4Shipment fileERPB/L 4410, container C-1Rows 2 and 7
5Invoice for 6 days, $1,050Payables inboxInvoice INV-2207, container C-1, SC-12Rows 6 and 7
6Appeal citing hold datesPayables inboxINV-2207, entry E-55Rows 3 and 8
7Vendor billERPVB-883, INV-2207, container C-1Rows 4 and 8
8Credit memo for $700; $350 paidERPCM-119 referencing VB-883Row 7

Row 3 is the one to watch. If the agent's email had not carried the container number, or had never been saved with the job, row 6 would cite dates nothing else in the file could confirm.

Scoring the map with the company

Walk the linking-key table with the finance director and mark each row yes, partly or no. Add the years each system covers, roughly how many disputes a year, and whether any terminal system or clearance agent changed during the period. That is the whole partner task. Cross-system data value explains why joined records say more than isolated ones, and SourceX's current data needs and value explains why no partner can price the result. The referral brief template turns the score into a forwardable note.

Who confirms, who decides, what waits

The logistics accountant, AP lead and customs compliance manager can confirm which keys exist. None of them can authorize licensing; the CEO can, often with the CFO preparing the case and counsel reviewing client, carrier and broker agreements. For a forwarder, many records describe clients' shipments, so reuse limits, de-identification, SourceX's current data needs and any offer stay unknown until SourceX reviews them. Partners never take invoices, exports, broker emails or logins; the AP side of the workflow is described in accounts payable exception handling.

The company needs 50+ full-time employees at peak (contractors excluded), a documented operating history, rights to license and an authorized contact. Companies in the U.S., Canada and the EU qualify, as do companies in the UK, Australia, New Zealand, India, Singapore, South Africa, Latin America, the UAE and Saudi Arabia when at least 70% of the data is in English. Partners sign the Channel Partner Agreement before submitting; the first valid introduction within the 90-day window is credited when the company submits a verified application.

Next step

Refer a company. No cap on rewards. Default reward on a company's first qualifying transaction: the greater of $50,000 plus 5% and 15% of Actual Supplier Payout, with no cap; further qualifying transactions first agreed within 12 months of the first Closing pay 15%. Eligibility and payment conditions apply, including the USD 100,000 Minimum Transaction, and a signed Schedule A or addendum can differ. A lead, meeting or signature alone does not trigger payment.

If most links on a client's map hold, especially the clearance agent and credit memo rows, register as a partner, check the company on who qualifies and read the program terms before sending the summary.

  1. Step 1Share your linkSend your personal link to a company you know.
  2. Step 2Company appliesThe company applies itself at /apply.
  3. Step 3Company signs and is paidThe company signs, delivers its data and is paid by SourceX under its agreement.
  4. Step 4You get your rewardthe greater of $50,000 plus 5% and 15% of the actual supplier payout, with no cap. A reward becomes payable after SourceX has paid the referred company under its signed agreement and the payout conditions in the program terms are met, including finance approval and your tax and payment details.

Common questions

Which key matters most?

The container number, because it appears on portal events, the invoice and usually the vendor bill. If AP never keyed it, the ERP side of every appeal has to be matched by hand.

What if the forwarder used several port portals?

List each one as its own node with its own years and owner. Event history depth and download options vary by operator, so the company should confirm them portal by portal.

Is a broker's entry number sensitive?

It identifies a customs transaction, so it stays with the company. The brief can say entry numbers are kept with the job without quoting any.

Sources

  1. ecfr.gov/current/title-46/chapter-IV/subchapter-B/par…
  2. fmc.gov/articles/u-s-court-of-appeals-issues-decisio…
  3. refer.sourcex.si/terms

Free resources

Know a company with valuable proprietary data?

Become a referral partner, get your link and introduce the company’s CEO (in an owner-run company, usually the owner). Referral partners can join from most countries. We can't work with partners in countries or regions under U.S. sanctions or on U.S. restricted-party lists. The companies you introduce should be based in the U.S., Canada and the EU, or in the UK, Australia, New Zealand, India, Singapore, South Africa, Latin America, the UAE and Saudi Arabia with at least 70% of their data in English.

Refer a company →

I own a business

Explore licensing your company's data directly to SourceX for AI training and evaluation. Start a short assessment; no uploads needed.

Start an assessment