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)

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