Statement Information
The topics in this section describe the information that appears on each on each statement print record. The following links are provided so that you can move easily to specific topic within this section:
• Global Extract Information Record (0010)
• Statement Record (0100)
• Total By Currency Record (0120)
• Statement Construct Detail Record (0500)
• Service Agreement Record (0900)
• Bill Record (1100)
• Financial Transaction (FT) Record (1300)
• End Bill Record (3600)
• End Service Agreement Record (3700)
• End Statement Construct Detail Record (5000)
• End Statement Record (9999)
• Address Sub-record
Global Extract Information Record (0010)
Field Name
Format
Source/Value/Description
BATCH_​CD
A8
Batch Control Code of the extract process.
BATCH_​NBR
N10
Batch Number of the extract process
BATCH_​RERUN_​NBR
N10
Batch Rerun number of the extract process.
STATEMENT_​CNT
N10
Count of statements on this extract. Multiple copies of a statement are counted multiple as well.
EXTRACT_​DTTM
A31
System time of extraction. Formatted according to user profile.
STMT_​ID_​START
A12
This is only used when a statement is produced as a result of an online request (from Statement - Main). It contains the Statement Id to extract.
STMT_​ID_​END
A12
This is only used when a statement is produced as a result of an online request (from Statement - Main). It contains the Statement Id to extract.
THREAD_​NBR
N10
This field is only used if statements are extracted in batch. It contains the thread number in which the statement was extracted.
THREAD_​CNT
N10
This field is only used if statements are extracted in batch. It contains the total number of threads that were extracted.
STATEMENT_​IND
A1
Defaulted to "Y"
Top of Page
Statement Record (0100)
Field Name
Format
Source/Value/Description
STMT_​ID
A12
CI_​STM
PER_​ID
A10
CI_​STM_​CNST
STMT_​DT
A31
STM_​DT from CI_​STM. Formatted according to user profile.
COPY_​NBR
N1
"1"
NBR_​STMT_​COPIES
N1
"1"
ENTITY_​NAME
A64
Main name of CI_​PER (from CI_​PER_​NAME).
ADDRESS_​SBR
A361
Address where the statement should be sent (the address is defined on the statement's statement construct).
ENTITY_​NAME1
A64
CI_​PER
ENTITY_​NAME2
A64
CI_​PER
ENTITY_​NAME3
A64
CI_​PER
DESCR50
A50
CI_​STM_​CNST
Top of Page
Total By Currency Record (0120)
One total record will be created for each currency code associated with the FT's associated with the SA snapshots linked to the statement.
Field Name
Format
Source/Value/Description
CURRENCY_​CD
A3
This is the currency code associated with the summary information.
CUR_​BAL
A30
This is the sum of CUR_​AMT snapshot on the SA snapshots (CI_​BILL_​SA) linked to the statement. SA snapshots (CI_​BILL_​SAs) are referenced on CI_​STM_​DTL.
BILL_​AMT
A30
This is the sum of CUR_​AMT from CI_​FTs classified as "corrections" and "current charges" on bill's associated with the statement. Please note, only those FT's associated with SAs linked to the statement will be amalgamated. This is formatted according to user's display profile.
CUR_​ADJ_​AMT
A30
This is the sum of CUR_​AMT from CI_​FTs classified as "adjustments" on bills associated with the statement. Please note, only those FT's associated with SAs linked to the statement will be amalgamated. This is formatted according to user's display profile.
CUR_​PAY_​AMT
A30
This is the sum of CUR_​AMT from CI_​FTs classified as "payments" on bills associated with the statement. Please note, only those FT's associated with SAs linked to the statement will be amalgamated. This is formatted according to user's display profile.
Top of Page
Statement Construct Detail Record (0500)
Field Name
Format
Source/Value/Description
STM_​CNST_​ID
A12
CI_​STM_​DTL
SA / Account Indicator
A1
A switch to indicate if the statement construct is for a service agreement or an account. 'S' for service agreement, 'A' for account.
Unique ID
A10
The unique identifier of the account or service agreement
SA / Account Info
A160
Contains the standard information about the account or service agreement
STMT_​PRT_​DESCR
A50
CI_​STM_​CNST
Top of Page
Service Agreement Record (0900)
Field Name
Format
Source/Value/Description
SA_​ID
A10
CI_​SA
Address Information
A120
This is the standard format of a premise address that is displayed throughout the system.
SA Information
A120
This is the standard SA information that is displayed throughout the system
SVC_​TYPE_​CD
A30
CI_​SA_​TYPE
Top of Page
Bill Record (1100)
Field Name
Format
Source/Value/Description
BILL_​ID
A12
Completion Date
A31
Date formatted according to user profile.
Due Date
A31
Date formatted according to user profile.
SA Ending Balance
A30
FT Exist Indicator
A1
Top of Page
Financial Transaction (FT) Record (1300)
Field Name
Format
Source/Value/Description
FT_​ID
A12
CI_​FT
ARS_​DT
A31
CI_​FT (The date when the transaction starts aging).
Date formatted according to user profile.
AMOUNT
A30
CUR_​AMT from CI_​FT formatted according to user display profile.
FT_​DESCR
A120
Formatted FT information.
Top of Page
End Bill Record (3600)
Field Name
Format
Source/Value/Description
Dummy field
Top of Page
End Service Agreement Record (3700)
Field Name
Format
Source/Value/Description
Dummy field
Top of Page
End Statement Construct Detail Record (5000)
Field Name
Format
Source/Value/Description
Dummy field
Top of Page
End Statement Record (9999)
Field Name
Format
Source/Value/Description
Dummy field
Top of Page
Address Sub-record
The address sub-record that in statement record (0100) is composed of the following:
Field Name
Format
Description
COUNTRY
A3
ADDRESS1
A64
ADDRESS2
A64
ADDRESS3
A64
ADDRESS4
A64
CITY
A30
NUM1
A6
NUM2
A4
HOUSE_​TYPE
A2
COUNTY
A30
STATE
A6
POSTAL
A12
GEO_​CODE
A11
IN_​CITY_​LIMIT
A1