Sequence Numbers

When you revise workfile transactions, the system sequentially numbers the workfile transactions and each new revision for audit purposes.

When you enter revisions, including changes for markup and splits, in the Billing Detail Workfile table (F4812), the system first copies the original transactions from the Billing Detail Workfile table to the Billing Workfile - History table (F4812H). Then the system assigns the next sequential numbers to the revised transaction in the Billing Detail Workfile table.

You can use these sequence numbers to track the progression of revisions to original workfile transactions. The system uses these numbers to link the workfile transactions together:

Number

Usage

Billing Control ID (BCI)

The BCI number is assigned at the time that the workfile transaction is first created in the Billing Detail Workfile table. The system uses Next Numbers, system 48, index 2 (Billing Control) to derive the number. The BCI number of a workfile transaction never changes, regardless of the revisions that are made to the workfile transaction. If you split a workfile transaction, the resulting workfile transactions will share the same BCI.

Sequence Number (SBSQ)

The sequence number of the original workfile transaction is always 1. The sequence number changes only when you split the workfile transaction. The system assigns the next available sequence number within that BCI series to the resulting workfile transactions. For example, the first time that you split a workfile transaction, the sequence numbers that are assigned to the resulting workfile transactions are 2 and 3. If you split one of those workfile transactions, the sequence numbers that are assigned to the resulting workfile transactions are 4 and 5.

Parent Sequence Number (PRSQ)

The parent sequence number of the original workfile transaction is always 0. The parent sequence number changes only when you split the workfile transaction. The system assigns a parent sequence number to workfile transactions that result from a split. The parent sequence number is always the sequence number of the workfile transaction that you split. For example, if you split a workfile transaction with a sequence number of 1 and a parent sequence number of 0, the system assigns the resulting workfile transactions a parent sequence number of 1.

Secondary Sequence Number (SCSQ)

The secondary sequence number of the original workfile transaction is always 1. The secondary sequence number tracks the number of revisions that you make to a workfile transaction. You can use this number to track the progression of revisions to original workfile transactions. For example, you might revise a workfile transaction three times. The secondary sequence number of the workfile transaction that you revise is 1. After the revision, the secondary sequence number for the workfile transaction is 2. When you change the transaction again, the secondary sequence number is 3. When you split a workfile transaction, the secondary sequence numbers will be 1 on the resulting workfile transactions.

Component Link Number (CLNK)

The component link number of the workfile transaction links the parent workfile transaction to the child component transactions. If this number is 0, no components or burdening exists for this workfile transaction. The component link number changes when you split a workfile transaction with components or burdening. The system assigns a new component link number to each resulting parent workfile transaction. This new component link number is then assigned to the respective component and burdening workfile transactions.