Sort Key
The following table defines the structure of the sort key that appears on each statement print record. Please note that different components are filled in for each printer key.
|
Field Name |
Format |
Record Type |
Source/Value/Description |
|
Statement ID |
A12 |
All |
Prime key of the statement |
|
Sequence Number |
N2 |
All |
Set to "1" |
|
Copy Number |
N2 |
All |
Defaulted to "1" on the first copy, set to "1" when a statement is requested on-line |
|
Statement record group |
A2 |
0010 |
Blank |
|
0100 |
10 |
||
|
0120 |
20 |
||
|
0500, 0900, 1100, 1300, 3600, 3700, 5000 |
30 |
||
|
9999 |
60 |
||
|
Construct detail sort sequence 1 |
N3 |
0010, 0100, 0120, 9999 |
blank |
|
0500, 0900, 1100, 1300, 3600, 3700, 5000 |
Statement construct's PRT_SEQ |
||
|
Construct detail sort sequence 2 |
A10 |
0010, 0100, 0120, 9999 |
blank |
|
0500, 0900, 1100, 1300, 3600, 3700, 5000 |
Statement construct's STM_CNST_DTL_ID |
||
|
Premise Indicator |
A1 |
0010, 0100, 0120, 0500, 9999 |
Blank |
|
5000 |
'Z' |
||
|
0900, 1100, 1300, 3600, 3700 |
For a non-premise, this will be 'N' otherwise 'Y' |
||
|
Premise State |
A6 |
0010, 0100, 0120, 0500, 5000, 9999 |
Blank |
|
0900, 1100, 1300, 3600, 3700 |
Premise's state (if this is for a non-premise, this will be blank) |
||
|
Premise City |
A90 |
0010, 0100, 0120, 0500, 5000, 9999 |
Blank |
|
0900, 1100, 1300, 3600, 3700, |
Premise's city (if this is for a non-premise, this will be blank) |
||
|
Premise Address 1 |
A58 |
0010, 0100, 0120, 0500, 5000, 9999 |
Blank |
|
0900, 1100, 1300, 3600, 3700 |
Premise's address line 1(if this is for a non-premise, this will be blank) |
||
|
Premise Id |
A10 |
0010, 0100, 0120, 0500, 5000, 9999 |
Blank |
|
0900, 1100, 1300, 3600, 3700 |
Premise's ID (if this is for a non-premise, this will be blank) |
||
|
SA Print Priority |
A2 |
0010, 0100, 0120, 0500, 5000, 9999 |
Blank |
|
0900, 1100, 1300, 3600, 3700 |
The SA's SA type's print priority |
||
|
SA Id |
A10 |
0010, 0100, 0120, 0500, 5000, 9999 |
Blank |
|
0900, 1100, 1300, 3600, 3700 |
The SA's SA ID |
||
|
SA record group |
A2 |
0010, 0100, 0120, 0500, 5000, 9999 |
Blank |
|
0900 |
10 |
||
|
1100, 1300, 3600 |
20 |
||
|
3700 |
30 |
||
|
Bill Date |
A10 |
0010, 0100, 0120, 0500, 0900, 3700, 5000, 9999 |
Blank |
|
1100, 1300, 3600 |
Bill's bill date in the format YYYYMMDD. |
||
|
Bill Id |
A12 |
0010, 0100, 0120, 0500, 0900, 3700, 5000, 9999 |
Blank |
|
1100, 1300, 3600 |
Bill's bill id |
||
|
Bill record group |
A2 |
0010, 0100, 0120, 0500, 0900, 3700, 5000, 9999 |
Blank |
|
1100 |
10 |
||
|
1300 |
20 |
||
|
3600 |
30 |
||
|
Arrears Date |
A10 |
0010, 0100, 0120, 0500, 0900, 1100, 3600, 3700, 5000, 9999 |
Blank |
| 1300 |
Financial transaction arrears date
|
||
|
FT Type |
A2 |
0010, 0100, 0120, 0500, 0900, 1100, 3600, 3700, 5000, 9999 |
Blank |
|
1300 |
Financial transaction type
|