CF_SEQNO, ACTIVITY_SW, and RETIRE_SW

CF_SEQNO was added as a key field on COST, DEPRECIATION, .. tables to replace ChartFields as key fields. Each unique CF_SEQNO value represents a unique set of ChartFields on the Business Unit / Asset / Book level. We start numbering CF_SEQNO from 0. Follow the example below for the assignment of the field.

Add asset with ChartField DEPTID = A and Operating Unit = 1
Transfer asset to DEPTID B
Adjust asset
Transfer asset to Operating Unit 2
Transfer asset back to DEPTID A and Operating Unit 2.

ASSET_ID TRANS_TYPE CF_SEQNO DEPTID OPERATING_UNIT
0000000001 ADD 0 A 1
0000000001 TRF - O 0 A 1
0000000001 TRF - I 1 B 1
0000000001 ADJ 1 B 1
0000000001 TRF 2 B 2
0000000001 TRF 0 A 1

ACTIVITY_SW designates which row is active. Usually you will see 0, 1, -1. The 0 row is the active row.

Basically when you add an asset (i.e. it's active), the activity_sw = 0. If you do something to the asset, like recategorize or transfer it, then the RCT out row (or TRF out row) will receive an activity_sw value of 1 and the RCT in row (or TRF in row) will receive an activity_sw value of 0. The -1 activity_sw value comes into play if the asset becomes active again. That is, in the above example, if I were to transfer the asset BACK to the original value, then the TRF in value would get a -1 value, so that the sum of 0, 1 and -1, totals 0 and is hence active again.

RETIRE_SW identifies whether this ChartField combination for the asset book has been retired (fully) or not. This is a numeric field and works the same as the activity switch.