ACCUM_INSTANCES
Description:
This table contains general information about accumulation instances.

Primary Key
Column Name Ordinal Position
ACCUMULATION_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ACCUMULATION_ID NUMERIC No
The unique identifier (.1 item) for the accumulation record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 ACCUM_GROUP_ID NUMERIC No
The accumulation group associated with the accumulation instance.
4 ACCUM_PREV_ACC_ID NUMERIC No
The ID of the previous accumulation applied to the associated accumulation group.
5 ACCUM_PREV_ACC_LN INTEGER No
The line in related group 90 from the accumulation corresponding to the previous accumulation instance.
6 ACCUM_APPLIED_AMT NUMERIC No
The amount applied to the associated accumulation group.
7 ACCUM_RUNNING_TOTAL NUMERIC No
The running total for the associated ACG after this accumulation instance was added.
8 ACCUMULATION_INSTANT_DTTM DATETIME (UTC) No
The instant this accumulation happened.
9 TARGET_AMOUNT NUMERIC No
The amount that we attempt to accumulate towards the associated accumulation group (ACG).
10 REVERSED_LINE INTEGER No
The line in this ACC's related group 90 which is reversed by this line.
11 SEQUENCE_NUMBER INTEGER No
The position in the sequence of accumulation instances this line represents for the associated accumulation group.