{"uid":"cap_n03aR9kcUMzAZCD8gzfiD","slug":"payment-reconciliation-numeric-row-ordering-trailing-mean-series-bf84f2c8","name":"Payment Reconciliation — Numeric Row Ordering + Trailing Mean Series","description":"Payment reconciliation — Numeric row ordering + Trailing mean series: Numeric row ordering + Trailing mean series for supplied payment reconciliation records (expected_amount, received_amount). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-finance-08-115?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","instrument_group","date","expected_amount","received_amount"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"expected_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"received_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"instrument_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","expected_amount":10,"received_amount":1,"instrument_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","expected_amount":20,"received_amount":2,"instrument_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","expected_amount":15,"received_amount":3,"instrument_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","expected_amount":30,"received_amount":4,"instrument_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["expected_amount","received_amount"],"type":"string","default":"expected_amount"},"window":{"type":"integer","default":2,"maximum":200,"minimum":2}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_8EVVByDaX0VFQNfI2I2j5","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Computes numeric row ordering and trailing mean series for up to 200 payment reconciliation records (expected_amount, received_amount), returning two local analytical reports per call.","exampleAgentPrompt":"Run numeric row ordering and a trailing mean series with a window of 3 on my payment reconciliation data — I have 4 rows: row-1 on 2026-10-01 with expected 10 and received 1 for group-a, row-2 on 2026-10-02 with expected 20 and received 2 for group-b, row-3 on 2026-10-03 with expected 15 and received 3 for group-a, row-4 on 2026-10-04 with expected 30 and received 4 for group-b — use expected_amount as the field.","exampleUseCases":[{"title":"Monthly reconciliation trend smoothing","prompt":"I have 12 months of payment reconciliation rows for two instrument groups. Can you rank them by numeric order and compute a trailing mean series with a window of 4 on the received_amount field so I can see the smoothed trend over time?"},{"title":"Discrepancy pattern detection in batch","prompt":"Here are 50 reconciliation records with expected and received amounts across several instrument groups. Please run numeric row ordering and a trailing mean with window size 5 on expected_amount so I can identify where patterns shift."},{"title":"Finance audit prep for two metrics","prompt":"I need two analytical reports on my payment data before our audit — numeric row ranking and a trailing mean series (window of 2) for the received_amount across these 8 rows by date. Can you run that?"}],"resultDescription":"Two analytical reports per call: (1) a numeric row ordering of the supplied payment reconciliation rows, and (2) a trailing mean series computed over the specified field (expected_amount or received_amount) using the given window size. Results are derived entirely from the supplied data with no external lookups or predictions.","failureModes":["More than 200 rows submitted — exceeds maxItems limit","Missing required fields (row_id, instrument_group, date, expected_amount, received_amount) in any row","Invalid date format (must match YYYY-MM-DD pattern)","Window size less than 2 or greater than 200","field value not in enum ['expected_amount', 'received_amount']","Numeric values outside allowed range (-1,000,000,000,000 to 1,000,000,000,000)"],"whenToPreferThis":"Choose this endpoint when you need lightweight, local analytical computation — specifically numeric row ordering and trailing mean series — on payment reconciliation data without requiring external data sources, live market lookups, or professional financial assessment. Best suited for batch analytics on up to 200 rows when you want two reports (ordering + smoothing) in a single cost-effective call at $0.01 USDC.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-30T12:38:44.318Z","isFirstParty":false,"canonicalSlug":"payment-reconciliation-numeric-row-ordering-trailing-mean-series-bf84f2c8"}