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" |
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 |
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. |
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 |
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 |
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 |
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. |
Field Name | Format | Source/Value/Description |
Dummy field |
Field Name | Format | Source/Value/Description |
Dummy field |
Field Name | Format | Source/Value/Description |
Dummy field |
Field Name | Format | Source/Value/Description |
Dummy field |
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 |