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