This field is present in many Voucher related tables, requisition tables, VAT, Project costing, receiving and journal related tables.
unpost-sequence
One must be careful when making queries with these tables that unpost seq must be join criteria. For example, During a join of journal header and journal line tables we must also include the unpost sequence criteria apart from having the business_unit , journal_id, journal_line and journal dates.
How is it created?
The system creates reversing entries and archives the original entries. The UNPOST_SEQ for the archived entry is one higher than for the reversal entry. Nothing is deleted.
unpost-sequence-properties
Therefore, Unpost Seq just equal to the number of times that the Event Generator has been run. For Standard entries, the value will always be 0.
unpost-sequence-example
For Supplemental entries, the value will be 0 the first time the Event Generator is run; 1 – the second time, 2 – the third time, 3 – the fourth time, and so on.
