Accumulator Operations
For more information about the Edit Accumulator Entry dialog box, see Sterling B2B Integrator Map Editor Properties.
The following table lists the available accumulator operations and their functions:
- Operation
- Function
- Increment primary
- Adds 1 (one) to the contents of the primary accumulator (Primary = Primary + 1).
- Decrement primary
- Subtracts 1 (one) from the contents of the primary accumulator (Primary = Primary - 1).
- Sum in primary
- Adds the numeric value (takes the positive or negative sign of the numbers into account) of the field to the contents of the primary accumulator (Primary = (+/-)Primary + (+/-)Field).
- Hash sum in primary
- Adds the absolute value (does not take the positive or negative sign of the numbers into account) of the field to the contents of the primary accumulator (Primary + Field).
- Load primary
- Loads the contents of the field into the primary accumulator (Primary = Field).
- Use primary
- Loads the contents of the primary accumulator into the field (Field = Primary).
Note: The field must be a numeric field to display the accumulator value.
- Zero primary
- Sets the value of the primary accumulator to zero (Primary = 0).
- Multiply with primary
- Multiplies the field with the contents of the primary accumulator, and stores the result in the primary accumulator (Primary = Primary * Field).
- Divide by primary
- Divides the field with the contents of the primary accumulator, and stores the result in the primary accumulator (Primary = Field / Primary).
- Divide primary by field
- Divides the contents of the primary accumulator with the field, and stores the result in the primary accumulator (Primary = Primary / Field).
- Modulo with primary
- Divides the contents of the field with the contents of the primary accumulator, and stores the remainder of that operation in the primary accumulator (Primary = Primary % Field).
- Modulo with field
- Divides the contents of the primary accumulator with the contents of the field, and stores the remainder of that operation in the primary accumulator (Primary = Field % Primary).
- Negate primary
- Makes the contents of the primary accumulator negative (Primary = Primary * -1). The only way to subtract the primary accumulator from the field is to negate the primary accumulator and then use the sum in primary operation to add the negative primary accumulator to the field.
- Move primary to alternate
- Copies the contents of the primary accumulator to the Alternate Accum field. This overwrites the current contents of the Alternate Accum field (Alternate = Primary).
- Add primary to alternate
- Adds the contents of the primary accumulator to the contents of the Alternate Accum field, and stores the result in the primary accumulator (Primary = Primary + Alternate).
- Multiply primary by alternate
- Multiplies the contents of the primary accumulator with the contents of the Alternate Accum field, and stores the result in the primary accumulator (Primary = Primary * Alternate).
- Divide primary by alternate
- Divides the contents of the primary accumulator with the contents of the Alternate Accum field, and stores the result in the primary accumulator (Primary = Primary / Alternate).
- Modulo primary with alternate
- Divides the contents of the primary accumulator with the contents of the Alternate Accum field, and stores the remainder of that operation in the primary accumulator (Primary = Primary % Alternate).