Bill Information
The topics in this section describe the information that appears on each on each bill print record.
• Global Extract Information Record (0010)
• Bill Record (0100)
• Account Balance Record (0150)
• Current Charge Record (0300)
• Payment Record (0600)
• Premise Record (0900)
• Service Agreement Record (1100)
• Bill Segment Record (1300)
• Bill Calc Header Record (1500)
• Bill Calc line Record (1700)
• End Bill Calc Header Record (1900)
• Bill Segment Read Record (2100)
• Bill Segment SQ Record (2400)
• Bill Segment Item Record (2700)
• Bill Segment Message Record (2840)
• End Bill Segment Record (2900)
• Histogram Record (3100)
• Adjustment Record (3400)
• Adjustment Calc Lines Record (3420)
• End Service Agreement Record (3600)
• End Premise Record (3700)
• Message Record (3900)
• End Bill Record (9999)
• Address Sub-Record
Global Extract Information Record (0010)
This is a "header" record that contains information about the extract run as a whole.
Note: 
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.
BILL_​CNT
N10
Count of bills on this extract. Multiple copies of a bill are counted multiple as well.
EXTRACT_​DTTM
A26
System time of extraction. Also updated in bill routing table.
BILL_​ID_​START
A12
This is only used when a bill is produced as a result of an online request (from Bill - Main). It contains the Bill Id to extract.
BILL_​ID_​END
A12
This is only used when a bill is produced as a result of an online request (from Bill - Main). It contains the Bill Id to extract.
THREAD_​NBR
N10
This field is only used if bills are extracted in batch. It contains the thread number in which the bill was extracted.
THREAD_​CNT
N10
This field is only used if bills are extracted in batch. It contains the total number of threads that were extracted.
Top of Page
Bill Record (0100)
Field Name
Format
Source/Value/Description
BILL_​ID
A12
CI_​BILL
ACCT_​ID
A10
CI_​BILL
BILL_​DT
D (A10)
CI_​BILL
DUE_​DT
D (A10)
CI_​BILL
COPY_​NBR
N2
NBR_​BILL_​COPIES
N2
CI_​BILL_​RTG
BILL_​PRT_​INTERCEPT
A8
CI_​BILL_​RTG
BILL_​FORMAT_​FLG
A2
CI_​BILL_​RTG
REPRINT_​SW
A1
CI_​BILL_​RTG
CASH_​ONLY_​SW
A1
CUR_​BAL
S13.2
CI_​BILL_​SA
CUR_​CHG_​AMT
S13.2
CI_​FT
CUR_​CORR_​AMT
S13.2
CI_​FT
CUR_​ADJ_​AMT
S13.2
CI_​FT
CUR_​PAY_​AMT
S13.2
CI_​FT
CUR_​PREV_​BAL
S13.2
CI_​FT
TOT_​BAL
S13.2
CI_​BILL_​SA
TOT_​CHG_​AMT
S13.2
CI_​FT
TOT_​CORR_​AMT
S13.2
CI_​FT
TOT_​ADJ_​AMT
S13.2
CI_​FT
TOT_​PAY_​AMT
S13.2
CI_​FT
TOT_​PREV_​BAL
S13.2
Computed during extract.
CURRENCY_​CD
A3
CI_​BILL_​SA
DELINQUENT_​AMT
S13.2
Computed during extract.
CUST_​PO_​ID
A20
CI_​BILL_​RTG
ACCT_​ENTITY_​NAME
A254
CI_​PER_​NAME. Account Entity Name. Might include prefix/suffix from Account/Person if available.
ENTITY_​NAME
A254
CI_​BILL_​RTG. Mailing Entity Name.
ADDRESS_​SBR
A1241
CI_​BILL_​RTG. Refer to its components in a later section.
FINAL_​BILL_​SW
A1
Computed during extract. Contains a value of Y if this bill is considered to be a "final" bill.
SCHED_​EXTRACT_​DT
D (A10)
CI_​APAY_​CLR_​STG. This is the date that the automatic payment will be downloaded.
ENTITY_​NAME1
A254
CI_​BILL_​RTG. Mailing Entity Name1.
ENTITY_​NAME2
A254
CI_​BILL_​RTG. Mailing Entity Name2.
ENTITY_​NAME3
A254
CI_​BILL_​RTG. Mailing Entity Name3.
ACCT-CUR-SYMBOL
A4
Currency symbol for the account's currency code.
Top of Page
Account Balance Record (0150)
Field Name
Format
Source/Value/Description
SPECIAL-ROLE-CD
A2
SA Type Special Role flag
SPECIAL-ROLE –DESCR
A30
Special Role description
CUR-AMT
S13.2
Derived from CI_​FT (Include ALL non-canceled/non-closed SAs for the account/debt class, even those that do not have current charges)
TOT- AMT
S13.2
Derived from CI_​FT (Include ALL non-canceled/non-closed SAs for the account/debt class, even those that do not have current charges)
Top of Page
Current Charge Record (0300)
Field Name
Format
Source/Value/Description
DEBT-CLASS-CD
A4
Debt Class of SA Type
DEBT-CLASS-DESCR
A30
Debt Class Description
CUR-CHARGE-AMT
S13.2
Derived from CI_​FT (Only the current charge bill segments.)
TOT-CHARGE-AMT
S13.2
Derived from CI_​FT (Only the current charge bill segments.)
Top of Page
Payment Record (0600)
Field Name
Format
Source/Value/Description
FT TYPE
A2
Pay or Pay Cancel ('PS' or 'PX')
PAY-DT
D (A10)
Derived from CI_​FT
CAN_​RSN_​CD
A4
Derived from CI_​PAY, Only for cancellation
CAN-RSN-DESCR
A30
Derived from CI_​PAY_​CAN_​RSN
CUR-PAY-AMT
S13.2
Derived from CI_​FT.
TOT-PAY-AMT
S13.2
Derived from CI_​FT.
Top of Page
Premise Record (0900)
Field Name
Format
Source/Value/Description
NON_​PREM_​SW
A1
Y/N switch to indicate (Y) special (non-premise) premise record. This is for non-premise service agreements such as charity or payment arrangement.
PREM_​ID
A10
From CI_​SA or CI_​BSEG
ADDRESS_​SBR
A1241
Service Address (Address of Char Premise) from CI_​PREM. Refer to its components in a later section.
Top of Page
Service Agreement Record (1100)
Field Name
Format
Source/Value/Description
SA_​ID
A10
CI_​SA
OLD_​ACCT_​ID
A36
CI_​SA
CUST_​READ_​FLG
A2
CI_​SA
SIC_​CD
A4
CI_​SA
SIC_​DESCR
A30
CI_​SIC
BUSINESS_​UNIT
A10
CI_​SA
SA_​TYPE_​CD
A8
CI_​SA
SA_​TYPE_​DESCR
A30
CI_​SA_​TYPE
SA_​TYPE_​DFLT_​DESCR
A80
CI_​SA_​TYPE
SVC_​TYPE_​CD
A30
CI_​SA_​TYPE
SVC_​TYPE_​DESCR
A30
CI_​SVC_​TYPE
REV_​CL_​CD
A8
CI_​SA_​TYPE
CHAR_​PREM_​ID
A10
CI_​SA
SA_​REL_​ID
A10
CI_​SA_​REL
SA_​REL_​TYPE_​CD
A8
CI_​SA_​REL
SA_​REL_​TYPE_​DESCR
A30
CI_​SA_​REL_​TYPE
SPR_​CD
A12
CI_​SA_​REL
SPR_​DESCR
A50
CI_​SPR
SPR_​ENTITY_​NAME
A254
CI_​PER_​NAME (this is the service provider's person's name)
Top of Page
Bill Segment Record (1300)
Field Name
Format
Source/Value/Description
START_​DT
D (A10)
CI_​BSEG
END_​DT
D (A10)
CI_​BSEG
CLOSING_​BSEG_​SW
A1
CI_​BSEG
EST_​SW
A1
CI_​BSEG
BILL_​CYC_​CD
A4
CI_​BSEG
SQ_​OVERRIDE_​SW
A1
CI_​BSEG
ITEM_​OVERRIDE_​SW
A1
CI_​BSEG
BSEG_​STAT_​FLG
A2
CI_​BSEG
CAN_​RSN_​CD
A4
CI_​BSEG
CAN_​RSN_​DESCR
A30
CI_​BILL_​CAN_​RSN
CUR_​AMT
S13.2
CI_​FT
TOT_​AMT
S13.2
CI_​FT
Top of Page
Bill Calc Header Record (1500)
Field Name
Format
Source/Value/Description
START_​DT
D (A10)
CI_​BSEG_​CALC
END_​DT
D (A10)
CI_​BSEG_​CALC
SETID
A10
CI_​BSEG_​CALC
RS_​CD
A8
CI_​BSEG_​CALC
CALC_​AMT
S13.2
CI_​BSEG_​CALC
DESCR_​ON_​BILL
A254
CI_​BSEG_​CALC
Top of Page
Bill Calc line Record (1700)
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
Top of Page
End Bill Calc Header Record (1900)
Field Name
Format
Source/Value/Description
Dummy field
Top of Page
Bill Segment Read Record (2100)
Field Name
Format
Source/Value/Description
SP_​ID
A10
CI_​BSEG_​READ
BADGE_​NBR
A16
CI_​MTR
UOM_​CD
A30
CI_​BSEG_​READ
TOU_​CD
A30
CI_​BSEG_​READ
RDG_​DEC_​POS
N1
CI_​REG. Decimal positions of the reads.
START_​REG_​READING
S9.6
CI_​BSEG_​READ
START_​READ_​DTTM
T (A26)
CI_​BSEG_​READ
START_​ESTIMATE_​SW
A1
CI_​REG_​READ
END_​REG_​READING
S9.6
CI_​BSEG_​READ
END_​READ_​DTTM
T (A26)
CI_​BSEG_​READ
END_​ESTIMATE_​SW
A1
CI_​REG_​READ
MSR_​QTY
S12.6
CI_​BSEG_​READ
USAGE_​FLG
A2
CI_​BSEG_​READ
USE_​PCT
N3
CI_​BSEG_​READ
HOW_​TO_​USE_​FLG
A2
CI_​BSEG_​READ
CONSUM_​SUB_​FLG
A2
CI_​REG
MSR_​PEAK_​QTY_​SW
A1
CI_​BSEG_​READ
REGISTER_​CONST
S6.6
CI_​BSEG_​READ
QTY_​DEC_​POS
N1
CI_​UOM. Decimal positions of the final quantity.
FINAL_​UOM
A4
CI_​BSEG_​READ
FINAL_​TOU
A8
CI_​BSEG_​READ
FINAL_​REG_​QTY
S12.6
CI_​BSEG_​READ
SQI_​CD
A30
CI_​BSEG_​READ
FINAL_​SQI_​CD
A8
CI_​BSEG_​READ
Top of Page
Bill Segment SQ Record (2400)
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
Top of Page
Bill Segment Item Record (2700)
Field Name
Format
Source/Value/Description
START_​DT
D (A10)
CI_​BSEG_​ITEM
END_​DT
D (A10)
CI_​BSEG_​ITEM
ITEM_​CNT
S9.2
CI_​BSEG_​ITEM
ITEM_​DESCR
A60
CI_​ITEM_​TYPE
Top of Page
Bill Segment Message Record (2840)
Field Name
Format
Source/Value/Description
BILL_​MSG_​CD
A4
CI_​BSEG_​MSG
MSG_​ON_​BILL
A254
CI_​BILL_​MSG_​L
Top of Page
End Bill Segment Record (2900)
Field Name
Format
Source/Value/Description
Dummy field
Top of Page
Histogram Record (3100)
Field Name
Format
Source/Value/Description
UOM_​CD
A30
CI_​SA_​TYPE
TOU_​CD
A30
SQI_​CD
A30
SQ_​DEC_​POS
N1
CI_​UOM. Decimal positions of SQ.
SQ_​CNT
N2
Count of SQ (maximum of 13.)
MAX_​BILL_​SQ
S12.6
Maximum Bill SQ from list. This is derived from CI_​BSEG_​READ.
SQ_​DT (1:13)
D (A10)
Date (for label of the SQ). This is derived from CI_​BSEG.
BILL_​SQ (1:13)
S12.6 (1:13)
13 occurrences of QTY, one for each period ending on the SQ_​DT. This is derived from CI_​BSEG_​READ.
Top of Page
Adjustment Record (3400)
Field Name
Format
Source/Value/Description
ADJ_​DT
D (A10)
CI_​FT
FT_​TYPE_​FLG
A2
CI_​FT
CUR_​AMT
S13.2
CI_​FT
TOT_​AMT
S13.2
CI_​FT
ADJ_​TYPE_​CD
A8
CI_​ADJ
ADJ_​TYPE_​DESCR
A30
CI_​ADJ_​TYPE
DESCR_​ON_​BILL
A254
CI_​ADJ_​TYPE
CAN_​RSN_​CD
A4
CI_​ADJ
CAN_​RSN_​DESCR
A30
CI_​ADJ_​CAN_​RSN
Top of Page
Adjustment Calc Lines Record (3420)
Field Name
Format
Source/Value/Description
APP_​IN_​SUMM_​SW
A1
Appears in Summary Y/N switch derived from CI_​ADJ_​CALC_​LN
RS_​CD
A8
Rate Schedule derived from CI_​ADJ_​CALC_​LN
CALC_​AMT
S13.2
Calculated Amount derived from CI_​ADJ_​CALC_​LN
EXEMPT_​AMT
S13.2
Exempt Amount derived from CI_​ADJ_​CALC_​LN
UOM_​CD
A30
Unit of Measure derived from CI_​ADJ_​CALC_​LN
TOU_​CD
A30
Time of Use derived from CI_​ADJ_​CALC_​LN
SQI_​CD
A30
SQI derived from CI_​ADJ_​CALC_​LN
BILL_​SQ
S12.6
Billable Service Quantity derived from CI_​ADJ_​CALC_​LN
DESCR_​ON_​BILL
A254
Description on Bill derived from CI_​ADJ_​CALC_​LN
APP_​IN_​SUMM_​SW
A1
Appears in Summary Y/N switch derived from CI_​ADJ_​CALC_​LN
Top of Page
End Service Agreement Record (3600)
Field Name
Format
Source/Value/Description
Dummy field
Top of Page
End Premise Record (3700)
Field Name
Format
Source/Value/Description
Dummy field
Top of Page
Message Record (3900)
Field Name
Format
Source/Value/Description
BILL_​MSG_​CD
A4
CI_​BILL_​MSGS
MSG_​PRIORITY_​FLG
A2
CI_​BILL_​MSG
INSERT_​CD
A8
CI_​BILL_​MSG
MSG_​ON_​BILL
A254
CI_​BILL_​MSG
Top of Page
End Bill Record (9999)
Field Name
Format
Source/Value/Description
Dummy field
Top of Page
Address Sub-Record
The address sub-record that appears in both the bill record (0100) and the premise record (0900) is composed of the following:
Field Name
Format
Description
COUNTRY
A3
ADDRESS1
A254
Refer to The Source Of Bill Routing Information 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
A254
ADDRESS3
A254
ADDRESS4
A254
CITY
A90
NUM1
A6
NUM2
A4
HOUSE_​TYPE
A2
COUNTY
A90
STATE
A6
POSTAL
A12
GEO_​CODE
A11
IN_​CITY_​LIMIT
A1