Tidy Balances
This background process creates adjustments that cause each SA's current and payoff balances to equal its balance in the legacy system (note: the batch control ID of CNV-BAL is used for this process).
Note: 
Submitting this process. You submit this process in the staging database. Refer to Tidy Balances for a description of this process and its parameters.
You supply the desired balances to this background process in a flat file in the following format:
Field
Size
Description
SA ID
X10
The unique identifier of the service agreement
Payoff Balance Sign
X1
Positive or Negative value indicates debit or credit balance respectively
Payoff Balance
N15.2
The SA's payoff balance (how much the customer really owes).
Current Balance New Charge Sign
X1
Positive or Negative value indicates debit or credit balance respectively
Current Balance - New Charge
N15.2
The amount of the SA's current balance that is considered a new charge, i.e., it hasn't started aging yet.
Current Balance Amount 1 Sign
X1
Positive or Negative value indicates debit or credit balance respectively
Current Balance - Amount 1
N15.2
The amount of the SA's current balance that is X days old (X is defined in the next field)
Age of Current Balance - Amount 1
N3
The number of days old the prior field is (if you keep your debt in "buckets" as opposed to knowing the exact number of days it has aged, you will have to choose an exact age). Set this value to zero if the value of amount 1 should be considered a "new charge" (i.e., it should only start aging when it is swept onto the next bill produced for the SA's account)
Current Balance Amount 2 Sign
X1
Positive or Negative value indicates debit or credit balance respectively
Current Balance - Amount 2
N15.2
The amount of the SA's current balance that is X days old (X is defined in the next field)
Age of Current Balance - Amount 2
N3
The number of days old the prior field is (if you keep your debt in "buckets" as opposed to knowing the exact number of days it has aged, you will have to choose an exact age)
Current Balance Amount 3 Sign
X1
Positive or Negative value indicates debit or credit balance respectively
Current Balance - Amount 3
N15.2
The amount of the SA's current balance that is X days old (X is defined in the next field)
Age of Current Balance - Amount 3
N3
The number of days old the prior field is (if you keep your debt in "buckets" as opposed to knowing the exact number of days it has aged, you will have to choose an exact age)
Current Balance Amount 4 Sign
X1
Positive or Negative value indicates debit or credit balance respectively
Current Balance - Amount 4
N15.2
The amount of the SA's current balance that is X days old (X is defined in the next field)
Age of Current Balance - Amount 4
N3
The number of days old the prior field is (if you keep your debt in "buckets" as opposed to knowing the exact number of days it has aged, you will have to choose an exact age)
Current Balance Amount 5 Sign
X1
Positive or Negative value indicates debit or credit balance respectively
Current Balance - Amount 5
N15.2
The amount of the SA's current balance that is X days old (X is defined in the next field)
Age of Current Balance - Amount 5
N3
The number of days old the prior field is (if you keep your debt in "buckets" as opposed to knowing the exact number of days it has aged, you will have to choose an exact age)
Note: 
Submitting this process. You submit this process in the staging database. Refer to Tidy Balances for a description of this process and its parameters.