GET /tms/deliveries/(?P\d+)

TMS > tms.delivery

What it does

#^/tms/deliveries/(?P<id>\d+)$# accepts GET and is declared in app/systems/TMS/delivery/api_routes.php:2140 as a regex pattern.

The route handler delegates to tmsDeliveryApiReadRows(). That function is the owner of this behaviour; the route entry is only dispatch.

Who calls it

No literal caller path was found in frontend/, public/ or new-system/. The endpoint may be called through a constructed path, a helper wrapper, or only by an external client. Treat the route table and owner function as the authority.

Input

Where	Key
path	id

Request bodies must not use TYPE, ACTION or USERNAME as contract fields.

Output

The response is produced by a shared helper, so the key set is not visible at the route. Read the owner function to confirm the shape before writing a client.

SQL executed

SELECT D.*, $driverNameExpr AS DRIVER_NAME, HC.DISPLAY_NAME AS CARRIER_COMPANY, SC.DISPLAY_NAME AS SHIPPER_COMPANY_NAME, CC.DISPLAY_NAME AS CONSIGNEE_COMPANY_NAME FROM T_DELIVERY AS D LEFT JOIN T_USER AS UDR ON UDR.ID=D.USER_ID AND UDR.CLIENT_ID=D.CLIENT_ID AND UDR.DELETED_AT IS NULL LEFT JOIN T_COMPANY AS HC ON HC.ID=D.CARRIER_COMPANY_ID AND HC.CLIENT_ID=D.CLIENT_ID AND HC.DELETED_AT IS NULL LEFT JOIN T_COMPANY AS SC ON SC.ID=D.SHIPPER_COMPANY_ID AND SC.CLIENT_ID=D.CLIENT_ID AND SC.DELETED_AT IS NULL LEFT JOIN T_COMPANY AS CC ON CC.ID=D.CONSIGNEE_COMPANY_ID AND CC.CLIENT_ID=D.CLIENT_ID AND CC.DELETED_AT IS NULL WHERE D.CLIENT_ID=? AND D.ID IN (

Data

Tables reached from the owner function:

• T_COMPANY
• T_DELIVERY
• T_USER

Access

• module-gated on tms.delivery, so tenant module access applies