Pharma Component Lot Use Allocation Term Tool

Description

Select requestedBatch, deduplicate lots in first-seen order, sum their masses, and return the combined batchMass.

Manufacturing records link lots, batches, effective dates, and review windows. Literal agreement or timing within a supplied window does not establish approval or traceability on its own.

Select requestedBatch, deduplicate lots in first-seen order, sum their masses, and return the combined batchMass.

When to use this tool

Use Pharma Component Lot Use Allocation Term when you need a scoped manufacturing-record consistency check.

How to use the tool and how it works

Enter lotIds, consumed, batchIds, requestedBatch. Keep parallel arrays aligned. Use the units and conventions below.
Run the tool. Correct any format, range, or cross-field input error before interpreting the output.
Read lots, batchMass, lotMasses. Use the output convention below.

Require aligned lotIds, consumed, and batchIds with nonnegative consumption. Select requestedBatch, deduplicate lots in first-seen order, sum their masses, and return the combined batchMass.^[1]

Input field	Meaning and units	Accepted input
lotIds	Lot Ids	Required. Array of text; maximum UTF-16 length 8192; maximum items 256.
consumed	Consumed	Required. Array of finite number; maximum items 256.
batchIds	Batch Ids	Required. Array of text; maximum UTF-16 length 8192; maximum items 256.
requestedBatch	Requested Batch	Required. Text; maximum UTF-16 length 8192.

Output field	Interpretation	Returned shape
lots	Lots	Required. Array of text; maximum UTF-16 length 8192; maximum items 256.
batchMass	Batch Mass	Required. Finite number.
lotMasses	Lot Masses	Required. Array of finite number; maximum items 256.

json

{
  "input": {
    "lotIds": [
      "L1",
      "L2",
      "L1"
    ],
    "consumed": [
      10,
      20,
      5
    ],
    "batchIds": [
      "B",
      "B",
      "C"
    ],
    "requestedBatch": "B"
  },
  "output": {
    "lots": [
      "L1",
      "L2"
    ],
    "batchMass": 30,
    "lotMasses": [
      10,
      20
    ]
  }
}

Limitations and assumptions

Lot links and amounts are supplied; this does not authenticate traceability, release status, or material suitability.
Inputs must satisfy both the field types and the cross-field conditions above. Invalid input causes an error; a successful false flag or documented placeholder is a different result.
Numeric calculations use binary floating point unless exact decimal-integer arithmetic is explicitly stated. No hidden measurement tolerance or decimal rounding is added; nonfinite or out-of-contract results are rejected. Numeric signed-zero results are exported as zero.

Alternative or Complementary methods

Verify the original controlled records, approved procedures, and responsible quality review.

References

Calculation and input contract: industrial-pharmacy/pharma-component-lot-use-allocation-term — tool.io

Similar or alternative tools

Manufacturing Lot Source Gap
Count exact pairs, source IDs beginning with the prefix, and mismatched pairs independently.
Packaging Count Support Share
Sum all counts and those with countVerified, artworkMatched, and lotTraceable all true using exact integers; return decimal totals and their share.