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