Quote Information
Global Extract Information (0010) Record Definition
This is a "header" record that contains information about the extract run as a whole.
Please be aware that if you do not sort your extract file by CIS Sort Key after it is produced, this record will physically be the last record on the extract file.
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. |
QTE_CNT |
N10 |
Count of quotes on this extract. |
EXTRACT_DTTM |
A26 |
System time of extraction. |
QUOTE_ID_START |
A12 |
This is only used when a quote is produced as a result of an online request (from Quote - Main). It contains the Quote Id to extract. |
QUOTE_ID_END |
A12 |
This is only used when a quote is produced as a result of an online request (from Quote - Main). It contains the Quote Id to extract. |
THREAD_NBR |
N10 |
This field is only used if quotes are extracted in batch. It contains the thread number in which the quote was extracted. |
THREAD_CNT |
N10 |
This field is only used if quotes are extracted in batch. It contains the total number of threads that were extracted. |
Quote (0100) Record Definition
Field Name |
Format |
Source/Value/Description |
QUOTE_ID |
A12 |
CI_QUOTE |
ACCT_ID |
A10 |
CI_QUOTE |
EXPIRE_DTTM |
A26 |
CI_QUOTE |
QUOTE_STAT_FLG |
A2 |
CI_QUOTE |
CURRENCY_CD |
A3 |
CI_ACCT |
CUR_SYMBOL |
A4 |
CI_CURRENCY_CD |
ENTITY_NAME1 |
A64 |
CI_QUOTE_RTG. Mailing Entity Name1. |
ENTITY_NAME2 |
A64 |
CI_QUOTE_RTG. Mailing Entity Name2. |
ENTITY_NAME3 |
A64 |
CI_QUOTE_RTG. Mailing Entity Name3. |
ADDRESS_SBR |
A361 |
CI_QUOTE_RTG. Refer to its components in a later section. |
EMAILID |
A254 |
CI_QUOTE_RTG |
PHONE-FAX |
A64 |
CI_QUOTE_RTG |
Quote Detail (0200) Record Definition
Field Name |
Format |
Source/Value/Description |
QUOTE_DTL_ID |
A12 |
CI_QUOTE_DTL |
SA_ID |
A10 |
CI_QUOTE_DTL |
TOTAL_AMT |
N13.2 |
CI_BSEG_CALC. Sum of all calculation amounts (quote detail's bill segments). |
PREMISE_ID |
A10 |
CI_SA (Characteristic Premise) |
ADDRESS_SBR |
A361 |
CI_PREM. Refer to its components in a later section. |
SA_TYPE_DESCR |
A60 |
CI_SA_TYPE_L |
SVC_TYPE_CD |
A30 |
CI_SVC_TYPE_L |
SA_VERSION |
N5 |
CI_QUOTE_DTL |
QTE_DTL_SA_VERSION |
N5 |
CI_QUOTE_DTL |
RS_DESCR |
A60 |
CI_RS_L. Description of Rate effective on SA start date. |
SA Terms and Conditions (0300) Record Definition
Field Name |
Format |
Source/Value/Description |
START_DT |
A10 |
CI_SA_TC |
END_DT |
A10 |
CI_SA_TC |
TC_TYPE_CD |
A12 |
CI_TC |
DESCR |
A60 |
CI_TC_L |
TC_TYPE_TXT |
A2000 |
CI_TC_L |
Bill Segment (0400) Record Definition
Field Name |
Format |
Source/Value/Description |
START_DT |
A10 |
CI_BSEG |
END_DT |
A10 |
CI_BSEG |
BSEG_STAT_FLG |
A2 |
CI_BSEG |
BSEG_AMT |
S13.2 |
CI_BSEG_CALC_LN |
Bill Calculation Header (0500) Record Definition
Field Name |
Format |
Source/Value/Description |
START_DT |
A10 |
CI_BSEG_CALC |
END_DT |
A10 |
CI_BSEG_CALC |
RS_CD |
A8 |
CI_BSEG_CALC |
CALC_AMT |
S13.2 |
CI_BSEG_CALC |
DESCR_ON_BILL |
A254 |
CI_BSEG_CALC |
Bill Calculation Line (0600) Record Definition
Field Name |
Format |
Source/Value/Description |
APP_IN_SUMM_SW |
A1 |
CI_BSEG_CALC_LN |
CALC_AMT |
S13.2 |
CI_BSEG_CALC_LN |
EXEMPT_AMT |
S13.2 |
CI_BSEG_CALC_LN |
UOM_CD |
A30 |
CI_BSEG_CALC_LN |
TOU_CD |
A30 |
CI_BSEG_CALC_LN |
SQI_CD |
A30 |
CI_BSEG_CALC_LN |
BILL_SQ |
S12.6 |
CI_BSEG_CALC_LN |
DESCR_ON_BILL |
A254 |
CI_BSEG_CALC_LN |
End of Bill Calculation Header (0700) Record Definition
Field Name |
Format |
Source/Value/Description |
Dummy field |
Bill Segment Read (0800) Record Definition
Bill Segment SQ (0900) Record Definition
Field Name |
Format |
Source/Value/Description |
UOM_CD |
A30 |
CI_BSEG_SQ |
TOU_CD |
A30 |
CI_BSEG_SQ |
SQI_CD |
A30 |
CI_BSEG_SQ |
SQ_DEC_POS |
N1 |
CI_BSEG_SQ |
BILL_SQ |
S12.6 |
CI_BSEG_SQ |
End of Bill Segment (1000) Record Definition
Field Name |
Format |
Source/Value/Description |
Dummy field |
End of Quote Detail (1100) Record Definition
Field Name |
Format |
Source/Value/Description |
Dummy field |
End of Quote (9999) Record Definition
Field Name |
Format |
Source/Value/Description |
Dummy field |
Address Sub-Record Definition
The address that appears in both the quote record (0100) and the quote detail record (0200) is composed of the following:
Field Name |
Format |
Description |
COUNTRY |
A3 |
|
ADDRESS1 |
A64 |
Refer to Completing A Quote Creates Quote Routings for a description of conditions when this field will contain a fax number or an Email address rather than the first line of a postal address (this only occurs for a bill record (0100)). |
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 |