topic I can not read the attached XML file in SAS Programming https://communities.sas.com/t5/SAS-Programming/I-can-not-read-the-attached-XML-file/m-p/45290#M9343 I have tried several methods and I am not having any luck reading the attached XML file. It contains some repeating(array) type record structures which may be the problem. Any ideas?? Thanks for the help.... Listed below are some sample records<BR /> <BR /> <BR /> - <ROWSET><BR /> - <FBE_ROW><BR /> <CUSTOMER_NUMBER>9999999</CUSTOMER_NUMBER> <BR /> <CUSTOMER_TYPE>RES</CUSTOMER_TYPE> <BR /> <ACCOUNT_ID>145454546</ACCOUNT_ID> <BR /> <ACCOUNT_NAME>Test Name1</ACCOUNT_NAME> <BR /> <ACCOUNT_NUMBER>6559999999999999</ACCOUNT_NUMBER> <BR /> <ACCOUNT_TYPE>RES</ACCOUNT_TYPE> <BR /> <PROFIT_CENTER>MASS</PROFIT_CENTER> <BR /> <CREDIT_SCORE>-1</CREDIT_SCORE> <BR /> <TDSP>Centerpoint Energy Houston Electric LLC</TDSP> <BR /> <LDC_ACCT_ID>1586882</LDC_ACCT_ID> <BR /> <LDC_START_DT>19800101</LDC_START_DT> <BR /> <LDC_END_DT>19800101</LDC_END_DT> <BR /> <LDC_BUILDING_TY_CD>House</LDC_BUILDING_TY_CD> <BR /> <LDC_BUILDING_SUB_TY_CD>Mobile Home One or Two Bedroom</LDC_BUILDING_SUB_TY_CD> <BR /> <COUNTY_NM>HARRIS</COUNTY_NM> <BR /> <DOS>0</DOS> <BR /> <LDC_CLASS_TYPE>RES</LDC_CLASS_TYPE> <BR /> <TOTAL_ESI_ON_ACCOUNT>1</TOTAL_ESI_ON_ACCOUNT> <BR /> <COLLECTION_RULE_NM>RESIDENTIAL DEFAULT</COLLECTION_RULE_NM> <BR /> <MAX_INVOICE_ID>72690009323867</MAX_INVOICE_ID> <BR /> <FINAL_INVOICE_DT>20070926</FINAL_INVOICE_DT> <BR /> <FINAL_INVOICE_CREATION_DT>20070926</FINAL_INVOICE_CREATION_DT> <BR /> <FINAL_BILL_DUE_DT>20071015</FINAL_BILL_DUE_DT> <BR /> <RATING_GROUP></RATING_GROUP> <BR /> <RATING_GROUP_START_DT></RATING_GROUP_START_DT> <BR /> <RATING_GROUP_END_DT></RATING_GROUP_END_DT> <BR /> <OFFER_PROMO_CODE>STD-CP05</OFFER_PROMO_CODE> <BR /> <AGREEMENT_MAX_ID>3539988</AGREEMENT_MAX_ID> <BR /> <AGREEMENT_START_DATE>20070817</AGREEMENT_START_DATE> <BR /> <AGREEMENT_END_DATE>20080817</AGREEMENT_END_DATE> <BR /> <AGREEMENT_RATE_CODE>COMPMMRESREL137GREEN</AGREEMENT_RATE_CODE> <BR /> <AGREEMENT_RENEWAL_OFFER></AGREEMENT_RENEWAL_OFFER> <BR /> <AGREEMENT_CONTRACT_DURATION>12</AGREEMENT_CONTRACT_DURATION> <BR /> <AGREEMENT_STATUS>CANCL</AGREEMENT_STATUS> <BR /> <AGREEMENT_TYPE>TERM</AGREEMENT_TYPE> <BR /> <RENEWAL_DEFAULT_INDICATOR>N</RENEWAL_DEFAULT_INDICATOR> <BR /> <CONTRACT_INDICATOR>N</CONTRACT_INDICATOR> <BR /> <PRICE_PLAN_NAME>SIMPLY BETTER EARTH SAVER PLAN</PRICE_PLAN_NAME> <BR /> <SALES_VENDOR_NAME>FCP</SALES_VENDOR_NAME> <BR /> <CHANNEL_NAME>Call Center</CHANNEL_NAME> <BR /> <FINAL_BILL_FEES>0</FINAL_BILL_FEES> <BR /> <ETRM_BILL_SUB_TYPE>0</ETRM_BILL_SUB_TYPE> <BR /> <NSF_BILL_SUB_TYPE>0</NSF_BILL_SUB_TYPE> <BR /> <LPC_BILL_SUB_TYPE>14</LPC_BILL_SUB_TYPE> <BR /> <CCF_BILL_SUB_TYPE>0</CCF_BILL_SUB_TYPE> <BR /> <BILL_SUB_TYPE_650F>0</BILL_SUB_TYPE_650F> <BR /> <DNPF_BILL_SUB_TYPE>0</DNPF_BILL_SUB_TYPE> <BR /> <BDE_WRITE_OFF_DT>20080307</BDE_WRITE_OFF_DT> <BR /> <BDE_WRITE_OFF_AMT>-14</BDE_WRITE_OFF_AMT> <BR /> <PDE_WRITE_OFF_DT></PDE_WRITE_OFF_DT> <BR /> <PDE_WRITE_OFF_AMT>0</PDE_WRITE_OFF_AMT> <BR /> <MOVE_OUT_TYPE></MOVE_OUT_TYPE> <BR /> <DREF_AMT_ON_FINAL_BILL>0</DREF_AMT_ON_FINAL_BILL> <BR /> <DREF_AMT_AFTER_FINAL_BILL>0</DREF_AMT_AFTER_FINAL_BILL> <BR /> <TOTAL_AMOUNT_DUE>394.36</TOTAL_AMOUNT_DUE> <BR /> <TOTAL_NEW_CHARGES>100.36</TOTAL_NEW_CHARGES> <BR /> <CAM_ASSIGNED_AMOUNT>394.36</CAM_ASSIGNED_AMOUNT> <BR /> <ASSIGNED_AGENCY_NAME>NCO</ASSIGNED_AGENCY_NAME> <BR /> <CAM_ASSIGNED_DT>20071226</CAM_ASSIGNED_DT> <BR /> <ACH_RCC_STATUS></ACH_RCC_STATUS> <BR /> <LITE_UP_STATUS>N</LITE_UP_STATUS> <BR /> <BUDGET_BILL_STATUS>N</BUDGET_BILL_STATUS> <BR /> <UNBILLED_RECEIVABLES></UNBILLED_RECEIVABLES> <BR /> <CURRENT_RECEIVABLES></CURRENT_RECEIVABLES> <BR /> <OUTSTANDING_AM_1_30></OUTSTANDING_AM_1_30> <BR /> <OUTSTANDING_AM_31_60></OUTSTANDING_AM_31_60> <BR /> <OUTSTANDING_AM_61_90></OUTSTANDING_AM_61_90> <BR /> <OUTSTANDING_AM_91_180></OUTSTANDING_AM_91_180> <BR /> <OUTSTANDING_AM_GT_180></OUTSTANDING_AM_GT_180> <BR /> <UNAPPLIED_CREDITS></UNAPPLIED_CREDITS> <BR /> <TOTAL_BAL>0</TOTAL_BAL> <BR /> <FB2_CORRESPONDENCE_DT>20071211</FB2_CORRESPONDENCE_DT> <BR /> <FB2_NOTICE_AMOUNT>394.36</FB2_NOTICE_AMOUNT> <BR /> <PA_GRANTED_CNT></PA_GRANTED_CNT> <BR /> <PA_COMPLETED_CNT></PA_COMPLETED_CNT> <BR /> <PA_SATISFIED_CNT></PA_SATISFIED_CNT> <BR /> <PA_DROPPED_CNT></PA_DROPPED_CNT> <BR /> <PA_CANCELLED_CNT></PA_CANCELLED_CNT> <BR /> <TOTAL_DNPL_EVENTS>1</TOTAL_DNPL_EVENTS> <BR /> <MONTHS_DNP_COUNT></MONTHS_DNP_COUNT> <BR /> <TOTAL_NSF_COUNT>0</TOTAL_NSF_COUNT> <BR /> <LPC_COUNT>0</LPC_COUNT> <BR /> <RATED_USAGE>N</RATED_USAGE> <BR /> - <ENERGY_PRICE><BR /> - <DETAIL><BR /> <CHARGE_TY_CD>KWH</CHARGE_TY_CD> <BR /> <BLOCK_START_NO>0</BLOCK_START_NO> <BR /> <BLOCK_END_NO>0</BLOCK_END_NO> <BR /> <BLOCK_UNIT_CD>KH</BLOCK_UNIT_CD> <BR /> <SIGNIFICANCE_CD>TOT</SIGNIFICANCE_CD> <BR /> <PRICE_PER_UNIT_NO>.132</PRICE_PER_UNIT_NO> <BR /> <SEASON_NM>All</SEASON_NM> <BR /> <USAGE_QUAL_CD>M</USAGE_QUAL_CD> <BR /> </DETAIL><BR /> </ENERGY_PRICE><BR /> <CUSTOMER_VALUE></CUSTOMER_VALUE> <BR /> </FBE_ROW><BR /> - <FBE_ROW><BR /> <CUSTOMER_NUMBER>8888888888</CUSTOMER_NUMBER> <BR /> <CUSTOMER_TYPE>RES</CUSTOMER_TYPE> <BR /> <ACCOUNT_ID>78787878</ACCOUNT_ID> <BR /> <ACCOUNT_NAME>Test Name2</ACCOUNT_NAME> <BR /> <ACCOUNT_NUMBER>655777777777</ACCOUNT_NUMBER> <BR /> <ACCOUNT_TYPE>RES</ACCOUNT_TYPE> <BR /> <PROFIT_CENTER>MASS</PROFIT_CENTER> <BR /> <CREDIT_SCORE></CREDIT_SCORE> <BR /> <TDSP>Centerpoint Energy Houston Electric LLC</TDSP> <BR /> <LDC_ACCT_ID>449748</LDC_ACCT_ID> <BR /> <LDC_START_DT>20060728</LDC_START_DT> <BR /> <LDC_END_DT>20080904</LDC_END_DT> <BR /> <LDC_BUILDING_TY_CD>House</LDC_BUILDING_TY_CD> <BR /> <LDC_BUILDING_SUB_TY_CD></LDC_BUILDING_SUB_TY_CD> <BR /> <COUNTY_NM>HARRIS</COUNTY_NM> <BR /> <DOS>769</DOS> <BR /> <LDC_CLASS_TYPE>RES</LDC_CLASS_TYPE> <BR /> <TOTAL_ESI_ON_ACCOUNT>1</TOTAL_ESI_ON_ACCOUNT> <BR /> <COLLECTION_RULE_NM>RESIDENTIAL DEFAULT</COLLECTION_RULE_NM> <BR /> <MAX_INVOICE_ID>82530017771066</MAX_INVOICE_ID> <BR /> <FINAL_INVOICE_DT>20080909</FINAL_INVOICE_DT> <BR /> <FINAL_INVOICE_CREATION_DT>20080909</FINAL_INVOICE_CREATION_DT> <BR /> <FINAL_BILL_DUE_DT>20080926</FINAL_BILL_DUE_DT> <BR /> <RATING_GROUP>COMPMMRESREL137GREEN</RATING_GROUP> <BR /> <RATING_GROUP_START_DT>20070907</RATING_GROUP_START_DT> <BR /> <RATING_GROUP_END_DT>0</RATING_GROUP_END_DT> <BR /> <OFFER_PROMO_CODE>RENEW-100% RENEWABLE-CP1</OFFER_PROMO_CODE> <BR /> <AGREEMENT_MAX_ID>5119789</AGREEMENT_MAX_ID> <BR /> <AGREEMENT_START_DATE>20070907</AGREEMENT_START_DATE> <BR /> <AGREEMENT_END_DATE>20080910</AGREEMENT_END_DATE> <BR /> <AGREEMENT_RATE_CODE>COMPMMRESREL137GREEN</AGREEMENT_RATE_CODE> <BR /> <AGREEMENT_RENEWAL_OFFER>RENEW-DEFAULT-CP1</AGREEMENT_RENEWAL_OFFER> <BR /> <AGREEMENT_CONTRACT_DURATION>12</AGREEMENT_CONTRACT_DURATION> <BR /> <AGREEMENT_STATUS>COMPL</AGREEMENT_STATUS> <BR /> <AGREEMENT_TYPE>TERM</AGREEMENT_TYPE> <BR /> <RENEWAL_DEFAULT_INDICATOR>Y</RENEWAL_DEFAULT_INDICATOR> <BR /> <CONTRACT_INDICATOR>N</CONTRACT_INDICATOR> <BR /> <PRICE_PLAN_NAME>SIMPLY BETTER EARTH SAVER PLAN</PRICE_PLAN_NAME> <BR /> <SALES_VENDOR_NAME>FCP</SALES_VENDOR_NAME> <BR /> <CHANNEL_NAME>Call Center</CHANNEL_NAME> <BR /> <FINAL_BILL_FEES></FINAL_BILL_FEES> <BR /> <ETRM_BILL_SUB_TYPE>0</ETRM_BILL_SUB_TYPE> <BR /> <NSF_BILL_SUB_TYPE>0</NSF_BILL_SUB_TYPE> <BR /> <LPC_BILL_SUB_TYPE>0</LPC_BILL_SUB_TYPE> <BR /> <CCF_BILL_SUB_TYPE>0</CCF_BILL_SUB_TYPE> <BR /> <BILL_SUB_TYPE_650F>0</BILL_SUB_TYPE_650F> <BR /> <DNPF_BILL_SUB_TYPE>0</DNPF_BILL_SUB_TYPE> <BR /> <BDE_WRITE_OFF_DT></BDE_WRITE_OFF_DT> <BR /> <BDE_WRITE_OFF_AMT>0</BDE_WRITE_OFF_AMT> <BR /> <PDE_WRITE_OFF_DT></PDE_WRITE_OFF_DT> <BR /> <PDE_WRITE_OFF_AMT>0</PDE_WRITE_OFF_AMT> <BR /> <MOVE_OUT_TYPE>Switch-Away</MOVE_OUT_TYPE> <BR /> <DREF_AMT_ON_FINAL_BILL></DREF_AMT_ON_FINAL_BILL> <BR /> <DREF_AMT_AFTER_FINAL_BILL>0</DREF_AMT_AFTER_FINAL_BILL> <BR /> <TOTAL_AMOUNT_DUE>53.33</TOTAL_AMOUNT_DUE> <BR /> <TOTAL_NEW_CHARGES>53.33</TOTAL_NEW_CHARGES> <BR /> <CAM_ASSIGNED_AMOUNT></CAM_ASSIGNED_AMOUNT> <BR /> <ASSIGNED_AGENCY_NAME></ASSIGNED_AGENCY_NAME> <BR /> <CAM_ASSIGNED_DT></CAM_ASSIGNED_DT> <BR /> <ACH_RCC_STATUS>ACH</ACH_RCC_STATUS> <BR /> <LITE_UP_STATUS>N</LITE_UP_STATUS> <BR /> <BUDGET_BILL_STATUS>N</BUDGET_BILL_STATUS> <BR /> <UNBILLED_RECEIVABLES></UNBILLED_RECEIVABLES> <BR /> <CURRENT_RECEIVABLES></CURRENT_RECEIVABLES> <BR /> <OUTSTANDING_AM_1_30></OUTSTANDING_AM_1_30> <BR /> <OUTSTANDING_AM_31_60></OUTSTANDING_AM_31_60> <BR /> <OUTSTANDING_AM_61_90></OUTSTANDING_AM_61_90> <BR /> <OUTSTANDING_AM_91_180></OUTSTANDING_AM_91_180> <BR /> <OUTSTANDING_AM_GT_180></OUTSTANDING_AM_GT_180> <BR /> <UNAPPLIED_CREDITS></UNAPPLIED_CREDITS> <BR /> <TOTAL_BAL>0</TOTAL_BAL> <BR /> <FB2_CORRESPONDENCE_DT></FB2_CORRESPONDENCE_DT> <BR /> <FB2_NOTICE_AMOUNT></FB2_NOTICE_AMOUNT> <BR /> <PA_GRANTED_CNT></PA_GRANTED_CNT> <BR /> <PA_COMPLETED_CNT></PA_COMPLETED_CNT> <BR /> <PA_SATISFIED_CNT></PA_SATISFIED_CNT> <BR /> <PA_DROPPED_CNT></PA_DROPPED_CNT> <BR /> <PA_CANCELLED_CNT></PA_CANCELLED_CNT> <BR /> <TOTAL_DNPL_EVENTS></TOTAL_DNPL_EVENTS> <BR /> <MONTHS_DNP_COUNT></MONTHS_DNP_COUNT> <BR /> <TOTAL_NSF_COUNT>0</TOTAL_NSF_COUNT> <BR /> <LPC_COUNT>0</LPC_COUNT> <BR /> <RATED_USAGE>Y</RATED_USAGE> <BR /> - <ENERGY_PRICE><BR /> - <DETAIL><BR /> <CHARGE_TY_CD>KWH</CHARGE_TY_CD> <BR /> <BLOCK_START_NO>0</BLOCK_START_NO> <BR /> <BLOCK_END_NO>0</BLOCK_END_NO> <BR /> <BLOCK_UNIT_CD>KH</BLOCK_UNIT_CD> <BR /> <SIGNIFICANCE_CD>TOT</SIGNIFICANCE_CD> <BR /> <PRICE_PER_UNIT_NO>.132</PRICE_PER_UNIT_NO> <BR /> <SEASON_NM>All</SEASON_NM> <BR /> <USAGE_QUAL_CD>M</USAGE_QUAL_CD> <BR /> </DETAIL><BR /> </ENERGY_PRICE><BR /> <CUSTOMER_VALUE></CUSTOMER_VALUE> <BR /> </FBE_ROW><BR /> - <FBE_ROW><BR /> <CUSTOMER_NUMBER>1111111</CUSTOMER_NUMBER> <BR /> <CUSTOMER_TYPE>RES</CUSTOMER_TYPE> <BR /> <ACCOUNT_ID>232323234</ACCOUNT_ID> <BR /> <ACCOUNT_NAME>Tes Name3</ACCOUNT_NAME> <BR /> <ACCOUNT_NUMBER>655123456789000000</ACCOUNT_NUMBER> <BR /> <ACCOUNT_TYPE>RES</ACCOUNT_TYPE> <BR /> <PROFIT_CENTER>MASS</PROFIT_CENTER> <BR /> <CREDIT_SCORE>521</CREDIT_SCORE> <BR /> <TDSP>Centerpoint Energy Houston Electric LLC</TDSP> <BR /> <LDC_ACCT_ID>1782796</LDC_ACCT_ID> <BR /> <LDC_START_DT>20080506</LDC_START_DT> <BR /> <LDC_END_DT>20080507</LDC_END_DT> <BR /> <LDC_BUILDING_TY_CD>House</LDC_BUILDING_TY_CD> <BR /> <LDC_BUILDING_SUB_TY_CD>1 Story House Three Bedroom</LDC_BUILDING_SUB_TY_CD> <BR /> <COUNTY_NM>HARRIS</COUNTY_NM> <BR /> <DOS>1</DOS> <BR /> <LDC_CLASS_TYPE>RES</LDC_CLASS_TYPE> <BR /> <TOTAL_ESI_ON_ACCOUNT>1</TOTAL_ESI_ON_ACCOUNT> <BR /> <COLLECTION_RULE_NM>RESIDENTIAL DEFAULT</COLLECTION_RULE_NM> <BR /> <MAX_INVOICE_ID>83200019422386</MAX_INVOICE_ID> <BR /> <FINAL_INVOICE_DT>20081114</FINAL_INVOICE_DT> <BR /> <FINAL_INVOICE_CREATION_DT>20081115</FINAL_INVOICE_CREATION_DT> <BR /> <FINAL_BILL_DUE_DT>20081202</FINAL_BILL_DUE_DT> <BR /> <RATING_GROUP>COMPMMRESREL137GREEN</RATING_GROUP> <BR /> <RATING_GROUP_START_DT>20070904</RATING_GROUP_START_DT> <BR /> <RATING_GROUP_END_DT>0</RATING_GROUP_END_DT> <BR /> <OFFER_PROMO_CODE>WHITE-CP02</OFFER_PROMO_CODE> <BR /> <AGREEMENT_MAX_ID>4066866</AGREEMENT_MAX_ID> <BR /> <AGREEMENT_START_DATE>20070904</AGREEMENT_START_DATE> <BR /> <AGREEMENT_END_DATE>20080817</AGREEMENT_END_DATE> <BR /> <AGREEMENT_RATE_CODE>COMPMMRESREL137GREEN</AGREEMENT_RATE_CODE> <BR /> <AGREEMENT_RENEWAL_OFFER></AGREEMENT_RENEWAL_OFFER> <BR /> <AGREEMENT_CONTRACT_DURATION>12</AGREEMENT_CONTRACT_DURATION> <BR /> <AGREEMENT_STATUS>CANCL</AGREEMENT_STATUS> <BR /> <AGREEMENT_TYPE>TERM</AGREEMENT_TYPE> <BR /> <RENEWAL_DEFAULT_INDICATOR>N</RENEWAL_DEFAULT_INDICATOR> <BR /> <CONTRACT_INDICATOR>N</CONTRACT_INDICATOR> <BR /> <PRICE_PLAN_NAME>SIMPLY BETTER EARTH SAVER PLAN</PRICE_PLAN_NAME> <BR /> <SALES_VENDOR_NAME>WhiteFence</SALES_VENDOR_NAME> <BR /> <CHANNEL_NAME>Third Party Website</CHANNEL_NAME> <BR /> <FINAL_BILL_FEES>0</FINAL_BILL_FEES> <BR /> <ETRM_BILL_SUB_TYPE>0</ETRM_BILL_SUB_TYPE> <BR /> <NSF_BILL_SUB_TYPE>0</NSF_BILL_SUB_TYPE> <BR /> <LPC_BILL_SUB_TYPE>0</LPC_BILL_SUB_TYPE> <BR /> <CCF_BILL_SUB_TYPE>0</CCF_BILL_SUB_TYPE> <BR /> <BILL_SUB_TYPE_650F>0</BILL_SUB_TYPE_650F> <BR /> <DNPF_BILL_SUB_TYPE>0</DNPF_BILL_SUB_TYPE> <BR /> <BDE_WRITE_OFF_DT>20090221</BDE_WRITE_OFF_DT> <BR /> <BDE_WRITE_OFF_AMT>-9.62</BDE_WRITE_OFF_AMT> <BR /> <PDE_WRITE_OFF_DT></PDE_WRITE_OFF_DT> <BR /> <PDE_WRITE_OFF_AMT>0</PDE_WRITE_OFF_AMT> <BR /> <MOVE_OUT_TYPE>Force Move-Out</MOVE_OUT_TYPE> <BR /> <DREF_AMT_ON_FINAL_BILL>0</DREF_AMT_ON_FINAL_BILL> <BR /> <DREF_AMT_AFTER_FINAL_BILL>0</DREF_AMT_AFTER_FINAL_BILL> <BR /> <TOTAL_AMOUNT_DUE>9.62</TOTAL_AMOUNT_DUE> <BR /> <TOTAL_NEW_CHARGES>9.62</TOTAL_NEW_CHARGES> <BR /> <CAM_ASSIGNED_AMOUNT></CAM_ASSIGNED_AMOUNT> <BR /> <ASSIGNED_AGENCY_NAME></ASSIGNED_AGENCY_NAME> <BR /> <CAM_ASSIGNED_DT></CAM_ASSIGNED_DT> <BR /> <ACH_RCC_STATUS></ACH_RCC_STATUS> <BR /> <LITE_UP_STATUS>N</LITE_UP_STATUS> <BR /> <BUDGET_BILL_STATUS>N</BUDGET_BILL_STATUS> <BR /> <UNBILLED_RECEIVABLES></UNBILLED_RECEIVABLES> <BR /> <CURRENT_RECEIVABLES></CURRENT_RECEIVABLES> <BR /> <OUTSTANDING_AM_1_30></OUTSTANDING_AM_1_30> <BR /> <OUTSTANDING_AM_31_60></OUTSTANDING_AM_31_60> <BR /> <OUTSTANDING_AM_61_90></OUTSTANDING_AM_61_90> <BR /> <OUTSTANDING_AM_91_180></OUTSTANDING_AM_91_180> <BR /> <OUTSTANDING_AM_GT_180></OUTSTANDING_AM_GT_180> <BR /> <UNAPPLIED_CREDITS></UNAPPLIED_CREDITS> <BR /> <TOTAL_BAL>0</TOTAL_BAL> <BR /> <FB2_CORRESPONDENCE_DT>20081205</FB2_CORRESPONDENCE_DT> <BR /> <FB2_NOTICE_AMOUNT>9.62</FB2_NOTICE_AMOUNT> <BR /> <PA_GRANTED_CNT></PA_GRANTED_CNT> <BR /> <PA_COMPLETED_CNT></PA_COMPLETED_CNT> <BR /> <PA_SATISFIED_CNT></PA_SATISFIED_CNT> <BR /> <PA_DROPPED_CNT></PA_DROPPED_CNT> <BR /> <PA_CANCELLED_CNT></PA_CANCELLED_CNT> <BR /> <TOTAL_DNPL_EVENTS></TOTAL_DNPL_EVENTS> <BR /> <MONTHS_DNP_COUNT></MONTHS_DNP_COUNT> <BR /> <TOTAL_NSF_COUNT>0</TOTAL_NSF_COUNT> <BR /> <LPC_COUNT>0</LPC_COUNT> <BR /> <RATED_USAGE>Y</RATED_USAGE> <BR /> - <ENERGY_PRICE><BR /> - <DETAIL><BR /> <CHARGE_TY_CD>KWH</CHARGE_TY_CD> <BR /> <BLOCK_START_NO>0</BLOCK_START_NO> <BR /> <BLOCK_END_NO>0</BLOCK_END_NO> <BR /> <BLOCK_UNIT_CD>KH</BLOCK_UNIT_CD> <BR /> <SIGNIFICANCE_CD>TOT</SIGNIFICANCE_CD> <BR /> <PRICE_PER_UNIT_NO>.132</PRICE_PER_UNIT_NO> <BR /> <SEASON_NM>All</SEASON_NM> <BR /> <USAGE_QUAL_CD>M</USAGE_QUAL_CD> <BR /> </DETAIL><BR /> </ENERGY_PRICE><BR /> <CUSTOMER_VALUE></CUSTOMER_VALUE> <BR /> </FBE_ROW><BR /> - <FBE_ROW><BR /> <CUSTOMER_NUMBER>0000000000121213</CUSTOMER_NUMBER> <BR /> <CUSTOMER_TYPE>RES</CUSTOMER_TYPE> <BR /> <ACCOUNT_ID>13456789</ACCOUNT_ID> <BR /> <ACCOUNT_NAME>Test Name4</ACCOUNT_NAME> <BR /> <ACCOUNT_NUMBER>6550987654321</ACCOUNT_NUMBER> <BR /> <ACCOUNT_TYPE>RES</ACCOUNT_TYPE> <BR /> <PROFIT_CENTER>MASS</PROFIT_CENTER> <BR /> <CREDIT_SCORE>640</CREDIT_SCORE> <BR /> <TDSP>Centerpoint Energy Houston Electric LLC</TDSP> <BR /> <LDC_ACCT_ID>1782826</LDC_ACCT_ID> <BR /> <LDC_START_DT>20070829</LDC_START_DT> <BR /> <LDC_END_DT>20071211</LDC_END_DT> <BR /> <LDC_BUILDING_TY_CD>Apartment</LDC_BUILDING_TY_CD> <BR /> <LDC_BUILDING_SUB_TY_CD>Apartment/Condo Two Bedroom</LDC_BUILDING_SUB_TY_CD> <BR /> <COUNTY_NM>HARRIS</COUNTY_NM> <BR /> <DOS>104</DOS> <BR /> <LDC_CLASS_TYPE>RES</LDC_CLASS_TYPE> <BR /> <TOTAL_ESI_ON_ACCOUNT>1</TOTAL_ESI_ON_ACCOUNT> <BR /> <COLLECTION_RULE_NM>RESIDENTIAL DEFAULT</COLLECTION_RULE_NM> <BR /> <MAX_INVOICE_ID>73480010888877</MAX_INVOICE_ID> <BR /> <FINAL_INVOICE_DT>20071214</FINAL_INVOICE_DT> <BR /> <FINAL_INVOICE_CREATION_DT>20071214</FINAL_INVOICE_CREATION_DT> <BR /> <FINAL_BILL_DUE_DT>20071231</FINAL_BILL_DUE_DT> <BR /> <RATING_GROUP>COMPMMRESREL137GREEN</RATING_GROUP> <BR /> <RATING_GROUP_START_DT>20070829</RATING_GROUP_START_DT> <BR /> <RATING_GROUP_END_DT>0</RATING_GROUP_END_DT> <BR /> <OFFER_PROMO_CODE>WHITE-CP02</OFFER_PROMO_CODE> <BR /> <AGREEMENT_MAX_ID>4067477</AGREEMENT_MAX_ID> <BR /> <AGREEMENT_START_DATE>20070829</AGREEMENT_START_DATE> <BR /> <AGREEMENT_END_DATE>20080817</AGREEMENT_END_DATE> <BR /> <AGREEMENT_RATE_CODE>COMPMMRESREL137GREEN</AGREEMENT_RATE_CODE> <BR /> <AGREEMENT_RENEWAL_OFFER></AGREEMENT_RENEWAL_OFFER> <BR /> <AGREEMENT_CONTRACT_DURATION>12</AGREEMENT_CONTRACT_DURATION> <BR /> <AGREEMENT_STATUS>CANCL</AGREEMENT_STATUS> <BR /> <AGREEMENT_TYPE>TERM</AGREEMENT_TYPE> <BR /> <RENEWAL_DEFAULT_INDICATOR>N</RENEWAL_DEFAULT_INDICATOR> <BR /> <CONTRACT_INDICATOR>N</CONTRACT_INDICATOR> <BR /> <PRICE_PLAN_NAME>SIMPLY BETTER EARTH SAVER PLAN</PRICE_PLAN_NAME> <BR /> <SALES_VENDOR_NAME>WhiteFence</SALES_VENDOR_NAME> <BR /> <CHANNEL_NAME>Third Party Website</CHANNEL_NAME> <BR /> <FINAL_BILL_FEES></FINAL_BILL_FEES> <BR /> <ETRM_BILL_SUB_TYPE>0</ETRM_BILL_SUB_TYPE> <BR /> <NSF_BILL_SUB_TYPE>0</NSF_BILL_SUB_TYPE> <BR /> <LPC_BILL_SUB_TYPE>14.12</LPC_BILL_SUB_TYPE> <BR /> <CCF_BILL_SUB_TYPE>0</CCF_BILL_SUB_TYPE> <BR /> <BILL_SUB_TYPE_650F>15</BILL_SUB_TYPE_650F> <BR /> <DNPF_BILL_SUB_TYPE>0</DNPF_BILL_SUB_TYPE> <BR /> <BDE_WRITE_OFF_DT>20080322</BDE_WRITE_OFF_DT> <BR /> <BDE_WRITE_OFF_AMT>-240.69</BDE_WRITE_OFF_AMT> <BR /> <PDE_WRITE_OFF_DT></PDE_WRITE_OFF_DT> <BR /> <PDE_WRITE_OFF_AMT>0</PDE_WRITE_OFF_AMT> <BR /> <MOVE_OUT_TYPE>Force Move-Out</MOVE_OUT_TYPE> <BR /> <DREF_AMT_ON_FINAL_BILL></DREF_AMT_ON_FINAL_BILL> <BR /> <DREF_AMT_AFTER_FINAL_BILL>0</DREF_AMT_AFTER_FINAL_BILL> <BR /> <TOTAL_AMOUNT_DUE>240.69</TOTAL_AMOUNT_DUE> <BR /> <TOTAL_NEW_CHARGES>52.77</TOTAL_NEW_CHARGES> <BR /> <CAM_ASSIGNED_AMOUNT>240.69</CAM_ASSIGNED_AMOUNT> <BR /> <ASSIGNED_AGENCY_NAME>CREDIT SYSTEMS INTERNATIONAL</ASSIGNED_AGENCY_NAME> <BR /> <CAM_ASSIGNED_DT>20080117</CAM_ASSIGNED_DT> <BR /> <ACH_RCC_STATUS></ACH_RCC_STATUS> <BR /> <LITE_UP_STATUS>N</LITE_UP_STATUS> <BR /> <BUDGET_BILL_STATUS>N</BUDGET_BILL_STATUS> <BR /> <UNBILLED_RECEIVABLES></UNBILLED_RECEIVABLES> <BR /> <CURRENT_RECEIVABLES></CURRENT_RECEIVABLES> <BR /> <OUTSTANDING_AM_1_30></OUTSTANDING_AM_1_30> <BR /> <OUTSTANDING_AM_31_60></OUTSTANDING_AM_31_60> <BR /> <OUTSTANDING_AM_61_90></OUTSTANDING_AM_61_90> <BR /> <OUTSTANDING_AM_91_180></OUTSTANDING_AM_91_180> <BR /> <OUTSTANDING_AM_GT_180></OUTSTANDING_AM_GT_180> <BR /> <UNAPPLIED_CREDITS></UNAPPLIED_CREDITS> <BR /> <TOTAL_BAL>0</TOTAL_BAL> <BR /> <FB2_CORRESPONDENCE_DT>20080102</FB2_CORRESPONDENCE_DT> <BR /> <FB2_NOTICE_AMOUNT>240.69</FB2_NOTICE_AMOUNT> <BR /> <PA_GRANTED_CNT></PA_GRANTED_CNT> <BR /> <PA_COMPLETED_CNT></PA_COMPLETED_CNT> <BR /> <PA_SATISFIED_CNT></PA_SATISFIED_CNT> <BR /> <PA_DROPPED_CNT></PA_DROPPED_CNT> <BR /> <PA_CANCELLED_CNT></PA_CANCELLED_CNT> <BR /> <TOTAL_DNPL_EVENTS>2</TOTAL_DNPL_EVENTS> <BR /> <MONTHS_DNP_COUNT>1</MONTHS_DNP_COUNT> <BR /> <TOTAL_NSF_COUNT>0</TOTAL_NSF_COUNT> <BR /> <LPC_COUNT>2</LPC_COUNT> <BR /> <RATED_USAGE>Y</RATED_USAGE> <BR /> - <ENERGY_PRICE><BR /> - <DETAIL><BR /> <CHARGE_TY_CD>KWH</CHARGE_TY_CD> <BR /> <BLOCK_START_NO>0</BLOCK_START_NO> <BR /> <BLOCK_END_NO>0</BLOCK_END_NO> <BR /> <BLOCK_UNIT_CD>KH</BLOCK_UNIT_CD> <BR /> <SIGNIFICANCE_CD>TOT</SIGNIFICANCE_CD> <BR /> <PRICE_PER_UNIT_NO>.132</PRICE_PER_UNIT_NO> <BR /> <SEASON_NM>All</SEASON_NM> <BR /> <USAGE_QUAL_CD>M</USAGE_QUAL_CD> <BR /> </DETAIL><BR /> </ENERGY_PRICE><BR /> <CUSTOMER_VALUE></CUSTOMER_VALUE> <BR /> </FBE_ROW><BR /> - <FBE_ROW><BR /> <CUSTOMER_NUMBER>1012134567</CUSTOMER_NUMBER> <BR /> <CUSTOMER_TYPE>RES</CUSTOMER_TYPE> <BR /> <ACCOUNT_ID>000000001</ACCOUNT_ID> <BR /> <ACCOUNT_NAME>Test Name5</ACCOUNT_NAME> <BR /> <ACCOUNT_NUMBER>65598789054</ACCOUNT_NUMBER> <BR /> <ACCOUNT_TYPE>RES</ACCOUNT_TYPE> <BR /> <PROFIT_CENTER>MASS</PROFIT_CENTER> <BR /> <CREDIT_SCORE>579</CREDIT_SCORE> <BR /> <TDSP>Centerpoint Energy Houston Electric LLC</TDSP> <BR /> <LDC_ACCT_ID>1234567</LDC_ACCT_ID> <BR /> <LDC_START_DT>20070830</LDC_START_DT> <BR /> <LDC_END_DT>20080424</LDC_END_DT> <BR /> <LDC_BUILDING_TY_CD>Apartment</LDC_BUILDING_TY_CD> <BR /> <LDC_BUILDING_SUB_TY_CD>Apartment/Condo Two Bedroom</LDC_BUILDING_SUB_TY_CD> <BR /> <COUNTY_NM>HARRIS</COUNTY_NM> <BR /> <DOS>238</DOS> <BR /> <LDC_CLASS_TYPE>RES</LDC_CLASS_TYPE> <BR /> <TOTAL_ESI_ON_ACCOUNT>1</TOTAL_ESI_ON_ACCOUNT> <BR /> <COLLECTION_RULE_NM>RESIDENTIAL DEFAULT</COLLECTION_RULE_NM> <BR /> <MAX_INVOICE_ID>81440014929542</MAX_INVOICE_ID> <BR /> <FINAL_INVOICE_DT>20080523</FINAL_INVOICE_DT> <BR /> <FINAL_INVOICE_CREATION_DT>20080523</FINAL_INVOICE_CREATION_DT> <BR /> <FINAL_BILL_DUE_DT>20080611</FINAL_BILL_DUE_DT> <BR /> <RATING_GROUP>COMPMMRESREL137GREEN</RATING_GROUP> <BR /> <RATING_GROUP_START_DT>20070830</RATING_GROUP_START_DT> <BR /> <RATING_GROUP_END_DT>0</RATING_GROUP_END_DT> <BR /> <OFFER_PROMO_CODE>STD-CP05</OFFER_PROMO_CODE> <BR /> <AGREEMENT_MAX_ID>4285525</AGREEMENT_MAX_ID> <BR /> <AGREEMENT_START_DATE>20070830</AGREEMENT_START_DATE> <BR /> <AGREEMENT_END_DATE>20080817</AGREEMENT_END_DATE> <BR /> <AGREEMENT_RATE_CODE>COMPMMRESREL137GREEN</AGREEMENT_RATE_CODE> <BR /> <AGREEMENT_RENEWAL_OFFER></AGREEMENT_RENEWAL_OFFER> <BR /> <AGREEMENT_CONTRACT_DURATION>12</AGREEMENT_CONTRACT_DURATION> <BR /> <AGREEMENT_STATUS>CANCL</AGREEMENT_STATUS> <BR /> <AGREEMENT_TYPE>TERM</AGREEMENT_TYPE> <BR /> <RENEWAL_DEFAULT_INDICATOR>N</RENEWAL_DEFAULT_INDICATOR> <BR /> <CONTRACT_INDICATOR>N</CONTRACT_INDICATOR> <BR /> <PRICE_PLAN_NAME>SIMPLY BETTER EARTH SAVER PLAN</PRICE_PLAN_NAME> <BR /> <SALES_VENDOR_NAME>FCP</SALES_VENDOR_NAME> <BR /> <CHANNEL_NAME>Call Center</CHANNEL_NAME> <BR /> <FINAL_BILL_FEES>0</FINAL_BILL_FEES> <BR /> <ETRM_BILL_SUB_TYPE>0</ETRM_BILL_SUB_TYPE> <BR /> <NSF_BILL_SUB_TYPE>25</NSF_BILL_SUB_TYPE> <BR /> <LPC_BILL_SUB_TYPE>63.62</LPC_BILL_SUB_TYPE> <BR /> <CCF_BILL_SUB_TYPE>0</CCF_BILL_SUB_TYPE> <BR /> <BILL_SUB_TYPE_650F>0</BILL_SUB_TYPE_650F> <BR /> <DNPF_BILL_SUB_TYPE>0</DNPF_BILL_SUB_TYPE> <BR /> <BDE_WRITE_OFF_DT>20080831</BDE_WRITE_OFF_DT> <BR /> <BDE_WRITE_OFF_AMT>-809.67</BDE_WRITE_OFF_AMT> <BR /> <PDE_WRITE_OFF_DT></PDE_WRITE_OFF_DT> <BR /> <PDE_WRITE_OFF_AMT>0</PDE_WRITE_OFF_AMT> <BR /> <MOVE_OUT_TYPE>Collections Generated</MOVE_OUT_TYPE> <BR /> <DREF_AMT_ON_FINAL_BILL>0</DREF_AMT_ON_FINAL_BILL> <BR /> <DREF_AMT_AFTER_FINAL_BILL>0</DREF_AMT_AFTER_FINAL_BILL> <BR /> <TOTAL_AMOUNT_DUE>809.67</TOTAL_AMOUNT_DUE> <BR /> <TOTAL_NEW_CHARGES>8.78</TOTAL_NEW_CHARGES> <BR /> <CAM_ASSIGNED_AMOUNT>809.85</CAM_ASSIGNED_AMOUNT> <BR /> <ASSIGNED_AGENCY_NAME>CREDIT SYSTEMS INTERNATIONAL</ASSIGNED_AGENCY_NAME> <BR /> <CAM_ASSIGNED_DT>20080627</CAM_ASSIGNED_DT> <BR /> <ACH_RCC_STATUS></ACH_RCC_STATUS> <BR /> <LITE_UP_STATUS>N</LITE_UP_STATUS> <BR /> <BUDGET_BILL_STATUS>N</BUDGET_BILL_STATUS> <BR /> <UNBILLED_RECEIVABLES></UNBILLED_RECEIVABLES> <BR /> <CURRENT_RECEIVABLES></CURRENT_RECEIVABLES> <BR /> <OUTSTANDING_AM_1_30></OUTSTANDING_AM_1_30> <BR /> <OUTSTANDING_AM_31_60></OUTSTANDING_AM_31_60> <BR /> <OUTSTANDING_AM_61_90></OUTSTANDING_AM_61_90> <BR /> <OUTSTANDING_AM_91_180></OUTSTANDING_AM_91_180> <BR /> <OUTSTANDING_AM_GT_180></OUTSTANDING_AM_GT_180> <BR /> <UNAPPLIED_CREDITS></UNAPPLIED_CREDITS> <BR /> <TOTAL_BAL>0</TOTAL_BAL> <BR /> <FB2_CORRESPONDENCE_DT>20080612</FB2_CORRESPONDENCE_DT> <BR /> <FB2_NOTICE_AMOUNT>809.67</FB2_NOTICE_AMOUNT> <BR /> <PA_GRANTED_CNT></PA_GRANTED_CNT> <BR /> <PA_COMPLETED_CNT></PA_COMPLETED_CNT> <BR /> <PA_SATISFIED_CNT></PA_SATISFIED_CNT> <BR /> <PA_DROPPED_CNT></PA_DROPPED_CNT> <BR /> <PA_CANCELLED_CNT></PA_CANCELLED_CNT> <BR /> <TOTAL_DNPL_EVENTS>4</TOTAL_DNPL_EVENTS> <BR /> <MONTHS_DNP_COUNT>1</MONTHS_DNP_COUNT> <BR /> <TOTAL_NSF_COUNT>1</TOTAL_NSF_COUNT> <BR /> <LPC_COUNT>4</LPC_COUNT> <BR /> <RATED_USAGE>Y</RATED_USAGE> <BR /> - <ENERGY_PRICE><BR /> - <DETAIL><BR /> <CHARGE_TY_CD>KWH</CHARGE_TY_CD> <BR /> <BLOCK_START_NO>0</BLOCK_START_NO> <BR /> <BLOCK_END_NO>0</BLOCK_END_NO> <BR /> <BLOCK_UNIT_CD>KH</BLOCK_UNIT_CD> <BR /> <SIGNIFICANCE_CD>TOT</SIGNIFICANCE_CD> <BR /> <PRICE_PER_UNIT_NO>.132</PRICE_PER_UNIT_NO> <BR /> <SEASON_NM>All</SEASON_NM> <BR /> <USAGE_QUAL_CD>M</USAGE_QUAL_CD> <BR /> </DETAIL><BR /> </ENERGY_PRICE><BR /> <CUSTOMER_VALUE></CUSTOMER_VALUE> <BR /> </FBE_ROW><BR /> - <FBE_ROW><BR /> <CUSTOMER_NUMBER>4444444498</CUSTOMER_NUMBER> <BR /> <CUSTOMER_TYPE>RES</CUSTOMER_TYPE> <BR /> <ACCOUNT_ID>55555567</ACCOUNT_ID> <BR /> <ACCOUNT_NAME>Test Name6</ACCOUNT_NAME> <BR /> <ACCOUNT_NUMBER>655555555555789</ACCOUNT_NUMBER> <BR /> <ACCOUNT_TYPE>RES</ACCOUNT_TYPE> <BR /> <PROFIT_CENTER>MASS</PROFIT_CENTER> <BR /> <CREDIT_SCORE></CREDIT_SCORE> <BR /> <TDSP>Centerpoint Energy Houston Electric LLC</TDSP> <BR /> <LDC_ACCT_ID>2967926</LDC_ACCT_ID> <BR /> <LDC_START_DT>20071130</LDC_START_DT> <BR /> <LDC_END_DT>20080822</LDC_END_DT> <BR /> <LDC_BUILDING_TY_CD>Apartment</LDC_BUILDING_TY_CD> <BR /> <LDC_BUILDING_SUB_TY_CD>Apartment/Condo Two Bedroom</LDC_BUILDING_SUB_TY_CD> <BR /> <COUNTY_NM>HARRIS</COUNTY_NM> <BR /> <DOS>266</DOS> <BR /> <LDC_CLASS_TYPE>RES</LDC_CLASS_TYPE> <BR /> <TOTAL_ESI_ON_ACCOUNT>2</TOTAL_ESI_ON_ACCOUNT> <BR /> <COLLECTION_RULE_NM>RESIDENTIAL DEFAULT</COLLECTION_RULE_NM> <BR /> <MAX_INVOICE_ID>82390017437668</MAX_INVOICE_ID> <BR /> <FINAL_INVOICE_DT>20080826</FINAL_INVOICE_DT> <BR /> <FINAL_INVOICE_CREATION_DT>20080826</FINAL_INVOICE_CREATION_DT> <BR /> <FINAL_BILL_DUE_DT>20080912</FINAL_BILL_DUE_DT> <BR /> <RATING_GROUP>1R53</RATING_GROUP> <BR /> <RATING_GROUP_START_DT>20071130</RATING_GROUP_START_DT> <BR /> <RATING_GROUP_END_DT>0</RATING_GROUP_END_DT> <BR /> <OFFER_PROMO_CODE>STD</OFFER_PROMO_CODE> <BR /> <AGREEMENT_MAX_ID>9007542</AGREEMENT_MAX_ID> <BR /> <AGREEMENT_START_DATE>20071130</AGREEMENT_START_DATE> <BR /> <AGREEMENT_END_DATE>20080827</AGREEMENT_END_DATE> <BR /> <AGREEMENT_RATE_CODE>1R53</AGREEMENT_RATE_CODE> <BR /> <AGREEMENT_RENEWAL_OFFER>RENEW-DEFAULT-CP1</AGREEMENT_RENEWAL_OFFER> <BR /> <AGREEMENT_CONTRACT_DURATION>12</AGREEMENT_CONTRACT_DURATION> <BR /> <AGREEMENT_STATUS>COMPL</AGREEMENT_STATUS> <BR /> <AGREEMENT_TYPE>TERM</AGREEMENT_TYPE> <BR /> <RENEWAL_DEFAULT_INDICATOR>N</RENEWAL_DEFAULT_INDICATOR> <BR /> <CONTRACT_INDICATOR>N</CONTRACT_INDICATOR> <BR /> <PRICE_PLAN_NAME></PRICE_PLAN_NAME> <BR /> <SALES_VENDOR_NAME>ADS</SALES_VENDOR_NAME> <BR /> <CHANNEL_NAME>Standard-APR</CHANNEL_NAME> <BR /> <FINAL_BILL_FEES>0</FINAL_BILL_FEES> <BR /> <ETRM_BILL_SUB_TYPE>0</ETRM_BILL_SUB_TYPE> <BR /> <NSF_BILL_SUB_TYPE>0</NSF_BILL_SUB_TYPE> <BR /> <LPC_BILL_SUB_TYPE>75.08</LPC_BILL_SUB_TYPE> <BR /> <CCF_BILL_SUB_TYPE>0</CCF_BILL_SUB_TYPE> <BR /> <BILL_SUB_TYPE_650F>30</BILL_SUB_TYPE_650F> <BR /> <DNPF_BILL_SUB_TYPE>0</DNPF_BILL_SUB_TYPE> <BR /> <BDE_WRITE_OFF_DT>20081220</BDE_WRITE_OFF_DT> <BR /> <BDE_WRITE_OFF_AMT>-1200.12</BDE_WRITE_OFF_AMT> <BR /> <PDE_WRITE_OFF_DT></PDE_WRITE_OFF_DT> <BR /> <PDE_WRITE_OFF_AMT>0</PDE_WRITE_OFF_AMT> <BR /> <MOVE_OUT_TYPE>Force Move-Out</MOVE_OUT_TYPE> <BR /> <DREF_AMT_ON_FINAL_BILL>-286.91</DREF_AMT_ON_FINAL_BILL> <BR /> <DREF_AMT_AFTER_FINAL_BILL>0</DREF_AMT_AFTER_FINAL_BILL> <BR /> <TOTAL_AMOUNT_DUE>1200.12</TOTAL_AMOUNT_DUE> <BR /> <TOTAL_NEW_CHARGES>321.67</TOTAL_NEW_CHARGES> <BR /> <CAM_ASSIGNED_AMOUNT>1200.12</CAM_ASSIGNED_AMOUNT> <BR /> <ASSIGNED_AGENCY_NAME></ASSIGNED_AGENCY_NAME> <BR /> <CAM_ASSIGNED_DT>20081121</CAM_ASSIGNED_DT> <BR /> <ACH_RCC_STATUS></ACH_RCC_STATUS> <BR /> <LITE_UP_STATUS>N</LITE_UP_STATUS> <BR /> <BUDGET_BILL_STATUS>N</BUDGET_BILL_STATUS> <BR /> <UNBILLED_RECEIVABLES></UNBILLED_RECEIVABLES> <BR /> <CURRENT_RECEIVABLES></CURRENT_RECEIVABLES> <BR /> <OUTSTANDING_AM_1_30></OUTSTANDING_AM_1_30> <BR /> <OUTSTANDING_AM_31_60></OUTSTANDING_AM_31_60> <BR /> <OUTSTANDING_AM_61_90></OUTSTANDING_AM_61_90> <BR /> <OUTSTANDING_AM_91_180></OUTSTANDING_AM_91_180> <BR /> <OUTSTANDING_AM_GT_180></OUTSTANDING_AM_GT_180> <BR /> <UNAPPLIED_CREDITS></UNAPPLIED_CREDITS> <BR /> <TOTAL_BAL>0</TOTAL_BAL> <BR /> <FB2_CORRESPONDENCE_DT>20081106</FB2_CORRESPONDENCE_DT> <BR /> <FB2_NOTICE_AMOUNT>1200.12</FB2_NOTICE_AMOUNT> <BR /> <PA_GRANTED_CNT>2</PA_GRANTED_CNT> <BR /> <PA_COMPLETED_CNT>1</PA_COMPLETED_CNT> <BR /> <PA_SATISFIED_CNT>0</PA_SATISFIED_CNT> <BR /> <PA_DROPPED_CNT>1</PA_DROPPED_CNT> <BR /> <PA_CANCELLED_CNT>0</PA_CANCELLED_CNT> <BR /> <TOTAL_DNPL_EVENTS>6</TOTAL_DNPL_EVENTS> <BR /> <MONTHS_DNP_COUNT>2</MONTHS_DNP_COUNT> <BR /> <TOTAL_NSF_COUNT>0</TOTAL_NSF_COUNT> <BR /> <LPC_COUNT>2</LPC_COUNT> <BR /> <RATED_USAGE>Y</RATED_USAGE> <BR /> - <ENERGY_PRICE><BR /> - <DETAIL><BR /> <CHARGE_TY_CD>KWH</CHARGE_TY_CD> <BR /> <BLOCK_START_NO>0</BLOCK_START_NO> <BR /> <BLOCK_END_NO>2000</BLOCK_END_NO> <BR /> <BLOCK_UNIT_CD>KH</BLOCK_UNIT_CD> <BR /> <SIGNIFICANCE_CD>TOT</SIGNIFICANCE_CD> <BR /> <PRICE_PER_UNIT_NO>.136</PRICE_PER_UNIT_NO> <BR /> <SEASON_NM>All</SEASON_NM> <BR /> <USAGE_QUAL_CD>M</USAGE_QUAL_CD> <BR /> </DETAIL><BR /> - <DETAIL><BR /> <CHARGE_TY_CD>KWH</CHARGE_TY_CD> <BR /> <BLOCK_START_NO>2001</BLOCK_START_NO> <BR /> <BLOCK_END_NO>4000</BLOCK_END_NO> <BR /> <BLOCK_UNIT_CD>KH</BLOCK_UNIT_CD> <BR /> <SIGNIFICANCE_CD>TOT</SIGNIFICANCE_CD> <BR /> <PRICE_PER_UNIT_NO>.128</PRICE_PER_UNIT_NO> <BR /> <SEASON_NM>All</SEASON_NM> <BR /> <USAGE_QUAL_CD>M</USAGE_QUAL_CD> <BR /> </DETAIL><BR /> </ENERGY_PRICE><BR /> <CUSTOMER_VALUE></CUSTOMER_VALUE> <BR /> </FBE_ROW><BR /> </ROWSET> Tue, 16 Jun 2009 14:49:55 GMT deleted_user 2009-06-16T14:49:55Z I can not read the attached XML file https://communities.sas.com/t5/SAS-Programming/I-can-not-read-the-attached-XML-file/m-p/45290#M9343 I have tried several methods and I am not having any luck reading the attached XML file. It contains some repeating(array) type record structures which may be the problem. Any ideas?? Thanks for the help.... Listed below are some sample records<BR /> <BR /> <BR /> - <ROWSET><BR /> - <FBE_ROW><BR /> <CUSTOMER_NUMBER>9999999</CUSTOMER_NUMBER> <BR /> <CUSTOMER_TYPE>RES</CUSTOMER_TYPE> <BR /> <ACCOUNT_ID>145454546</ACCOUNT_ID> <BR /> <ACCOUNT_NAME>Test Name1</ACCOUNT_NAME> <BR /> <ACCOUNT_NUMBER>6559999999999999</ACCOUNT_NUMBER> <BR /> <ACCOUNT_TYPE>RES</ACCOUNT_TYPE> <BR /> <PROFIT_CENTER>MASS</PROFIT_CENTER> <BR /> <CREDIT_SCORE>-1</CREDIT_SCORE> <BR /> <TDSP>Centerpoint Energy Houston Electric LLC</TDSP> <BR /> <LDC_ACCT_ID>1586882</LDC_ACCT_ID> <BR /> <LDC_START_DT>19800101</LDC_START_DT> <BR /> <LDC_END_DT>19800101</LDC_END_DT> <BR /> <LDC_BUILDING_TY_CD>House</LDC_BUILDING_TY_CD> <BR /> <LDC_BUILDING_SUB_TY_CD>Mobile Home One or Two Bedroom</LDC_BUILDING_SUB_TY_CD> <BR /> <COUNTY_NM>HARRIS</COUNTY_NM> <BR /> <DOS>0</DOS> <BR /> <LDC_CLASS_TYPE>RES</LDC_CLASS_TYPE> <BR /> <TOTAL_ESI_ON_ACCOUNT>1</TOTAL_ESI_ON_ACCOUNT> <BR /> <COLLECTION_RULE_NM>RESIDENTIAL DEFAULT</COLLECTION_RULE_NM> <BR /> <MAX_INVOICE_ID>72690009323867</MAX_INVOICE_ID> <BR /> <FINAL_INVOICE_DT>20070926</FINAL_INVOICE_DT> <BR /> <FINAL_INVOICE_CREATION_DT>20070926</FINAL_INVOICE_CREATION_DT> <BR /> <FINAL_BILL_DUE_DT>20071015</FINAL_BILL_DUE_DT> <BR /> <RATING_GROUP></RATING_GROUP> <BR /> <RATING_GROUP_START_DT></RATING_GROUP_START_DT> <BR /> <RATING_GROUP_END_DT></RATING_GROUP_END_DT> <BR /> <OFFER_PROMO_CODE>STD-CP05</OFFER_PROMO_CODE> <BR /> <AGREEMENT_MAX_ID>3539988</AGREEMENT_MAX_ID> <BR /> <AGREEMENT_START_DATE>20070817</AGREEMENT_START_DATE> <BR /> <AGREEMENT_END_DATE>20080817</AGREEMENT_END_DATE> <BR /> <AGREEMENT_RATE_CODE>COMPMMRESREL137GREEN</AGREEMENT_RATE_CODE> <BR /> <AGREEMENT_RENEWAL_OFFER></AGREEMENT_RENEWAL_OFFER> <BR /> <AGREEMENT_CONTRACT_DURATION>12</AGREEMENT_CONTRACT_DURATION> <BR /> <AGREEMENT_STATUS>CANCL</AGREEMENT_STATUS> <BR /> <AGREEMENT_TYPE>TERM</AGREEMENT_TYPE> <BR /> <RENEWAL_DEFAULT_INDICATOR>N</RENEWAL_DEFAULT_INDICATOR> <BR /> <CONTRACT_INDICATOR>N</CONTRACT_INDICATOR> <BR /> <PRICE_PLAN_NAME>SIMPLY BETTER EARTH SAVER PLAN</PRICE_PLAN_NAME> <BR /> <SALES_VENDOR_NAME>FCP</SALES_VENDOR_NAME> <BR /> <CHANNEL_NAME>Call Center</CHANNEL_NAME> <BR /> <FINAL_BILL_FEES>0</FINAL_BILL_FEES> <BR /> <ETRM_BILL_SUB_TYPE>0</ETRM_BILL_SUB_TYPE> <BR /> <NSF_BILL_SUB_TYPE>0</NSF_BILL_SUB_TYPE> <BR /> <LPC_BILL_SUB_TYPE>14</LPC_BILL_SUB_TYPE> <BR /> <CCF_BILL_SUB_TYPE>0</CCF_BILL_SUB_TYPE> <BR /> <BILL_SUB_TYPE_650F>0</BILL_SUB_TYPE_650F> <BR /> <DNPF_BILL_SUB_TYPE>0</DNPF_BILL_SUB_TYPE> <BR /> <BDE_WRITE_OFF_DT>20080307</BDE_WRITE_OFF_DT> <BR /> <BDE_WRITE_OFF_AMT>-14</BDE_WRITE_OFF_AMT> <BR /> <PDE_WRITE_OFF_DT></PDE_WRITE_OFF_DT> <BR /> <PDE_WRITE_OFF_AMT>0</PDE_WRITE_OFF_AMT> <BR /> <MOVE_OUT_TYPE></MOVE_OUT_TYPE> <BR /> <DREF_AMT_ON_FINAL_BILL>0</DREF_AMT_ON_FINAL_BILL> <BR /> <DREF_AMT_AFTER_FINAL_BILL>0</DREF_AMT_AFTER_FINAL_BILL> <BR /> <TOTAL_AMOUNT_DUE>394.36</TOTAL_AMOUNT_DUE> <BR /> <TOTAL_NEW_CHARGES>100.36</TOTAL_NEW_CHARGES> <BR /> <CAM_ASSIGNED_AMOUNT>394.36</CAM_ASSIGNED_AMOUNT> <BR /> <ASSIGNED_AGENCY_NAME>NCO</ASSIGNED_AGENCY_NAME> <BR /> <CAM_ASSIGNED_DT>20071226</CAM_ASSIGNED_DT> <BR /> <ACH_RCC_STATUS></ACH_RCC_STATUS> <BR /> <LITE_UP_STATUS>N</LITE_UP_STATUS> <BR /> <BUDGET_BILL_STATUS>N</BUDGET_BILL_STATUS> <BR /> <UNBILLED_RECEIVABLES></UNBILLED_RECEIVABLES> <BR /> <CURRENT_RECEIVABLES></CURRENT_RECEIVABLES> <BR /> <OUTSTANDING_AM_1_30></OUTSTANDING_AM_1_30> <BR /> <OUTSTANDING_AM_31_60></OUTSTANDING_AM_31_60> <BR /> <OUTSTANDING_AM_61_90></OUTSTANDING_AM_61_90> <BR /> <OUTSTANDING_AM_91_180></OUTSTANDING_AM_91_180> <BR /> <OUTSTANDING_AM_GT_180></OUTSTANDING_AM_GT_180> <BR /> <UNAPPLIED_CREDITS></UNAPPLIED_CREDITS> <BR /> <TOTAL_BAL>0</TOTAL_BAL> <BR /> <FB2_CORRESPONDENCE_DT>20071211</FB2_CORRESPONDENCE_DT> <BR /> <FB2_NOTICE_AMOUNT>394.36</FB2_NOTICE_AMOUNT> <BR /> <PA_GRANTED_CNT></PA_GRANTED_CNT> <BR /> <PA_COMPLETED_CNT></PA_COMPLETED_CNT> <BR /> <PA_SATISFIED_CNT></PA_SATISFIED_CNT> <BR /> <PA_DROPPED_CNT></PA_DROPPED_CNT> <BR /> <PA_CANCELLED_CNT></PA_CANCELLED_CNT> <BR /> <TOTAL_DNPL_EVENTS>1</TOTAL_DNPL_EVENTS> <BR /> <MONTHS_DNP_COUNT></MONTHS_DNP_COUNT> <BR /> <TOTAL_NSF_COUNT>0</TOTAL_NSF_COUNT> <BR /> <LPC_COUNT>0</LPC_COUNT> <BR /> <RATED_USAGE>N</RATED_USAGE> <BR /> - <ENERGY_PRICE><BR /> - <DETAIL><BR /> <CHARGE_TY_CD>KWH</CHARGE_TY_CD> <BR /> <BLOCK_START_NO>0</BLOCK_START_NO> <BR /> <BLOCK_END_NO>0</BLOCK_END_NO> <BR /> <BLOCK_UNIT_CD>KH</BLOCK_UNIT_CD> <BR /> <SIGNIFICANCE_CD>TOT</SIGNIFICANCE_CD> <BR /> <PRICE_PER_UNIT_NO>.132</PRICE_PER_UNIT_NO> <BR /> <SEASON_NM>All</SEASON_NM> <BR /> <USAGE_QUAL_CD>M</USAGE_QUAL_CD> <BR /> </DETAIL><BR /> </ENERGY_PRICE><BR /> <CUSTOMER_VALUE></CUSTOMER_VALUE> <BR /> </FBE_ROW><BR /> - <FBE_ROW><BR /> <CUSTOMER_NUMBER>8888888888</CUSTOMER_NUMBER> <BR /> <CUSTOMER_TYPE>RES</CUSTOMER_TYPE> <BR /> <ACCOUNT_ID>78787878</ACCOUNT_ID> <BR /> <ACCOUNT_NAME>Test Name2</ACCOUNT_NAME> <BR /> <ACCOUNT_NUMBER>655777777777</ACCOUNT_NUMBER> <BR /> <ACCOUNT_TYPE>RES</ACCOUNT_TYPE> <BR /> <PROFIT_CENTER>MASS</PROFIT_CENTER> <BR /> <CREDIT_SCORE></CREDIT_SCORE> <BR /> <TDSP>Centerpoint Energy Houston Electric LLC</TDSP> <BR /> <LDC_ACCT_ID>449748</LDC_ACCT_ID> <BR /> <LDC_START_DT>20060728</LDC_START_DT> <BR /> <LDC_END_DT>20080904</LDC_END_DT> <BR /> <LDC_BUILDING_TY_CD>House</LDC_BUILDING_TY_CD> <BR /> <LDC_BUILDING_SUB_TY_CD></LDC_BUILDING_SUB_TY_CD> <BR /> <COUNTY_NM>HARRIS</COUNTY_NM> <BR /> <DOS>769</DOS> <BR /> <LDC_CLASS_TYPE>RES</LDC_CLASS_TYPE> <BR /> <TOTAL_ESI_ON_ACCOUNT>1</TOTAL_ESI_ON_ACCOUNT> <BR /> <COLLECTION_RULE_NM>RESIDENTIAL DEFAULT</COLLECTION_RULE_NM> <BR /> <MAX_INVOICE_ID>82530017771066</MAX_INVOICE_ID> <BR /> <FINAL_INVOICE_DT>20080909</FINAL_INVOICE_DT> <BR /> <FINAL_INVOICE_CREATION_DT>20080909</FINAL_INVOICE_CREATION_DT> <BR /> <FINAL_BILL_DUE_DT>20080926</FINAL_BILL_DUE_DT> <BR /> <RATING_GROUP>COMPMMRESREL137GREEN</RATING_GROUP> <BR /> <RATING_GROUP_START_DT>20070907</RATING_GROUP_START_DT> <BR /> <RATING_GROUP_END_DT>0</RATING_GROUP_END_DT> <BR /> <OFFER_PROMO_CODE>RENEW-100% RENEWABLE-CP1</OFFER_PROMO_CODE> <BR /> <AGREEMENT_MAX_ID>5119789</AGREEMENT_MAX_ID> <BR /> <AGREEMENT_START_DATE>20070907</AGREEMENT_START_DATE> <BR /> <AGREEMENT_END_DATE>20080910</AGREEMENT_END_DATE> <BR /> <AGREEMENT_RATE_CODE>COMPMMRESREL137GREEN</AGREEMENT_RATE_CODE> <BR /> <AGREEMENT_RENEWAL_OFFER>RENEW-DEFAULT-CP1</AGREEMENT_RENEWAL_OFFER> <BR /> <AGREEMENT_CONTRACT_DURATION>12</AGREEMENT_CONTRACT_DURATION> <BR /> <AGREEMENT_STATUS>COMPL</AGREEMENT_STATUS> <BR /> <AGREEMENT_TYPE>TERM</AGREEMENT_TYPE> <BR /> <RENEWAL_DEFAULT_INDICATOR>Y</RENEWAL_DEFAULT_INDICATOR> <BR /> <CONTRACT_INDICATOR>N</CONTRACT_INDICATOR> <BR /> <PRICE_PLAN_NAME>SIMPLY BETTER EARTH SAVER PLAN</PRICE_PLAN_NAME> <BR /> <SALES_VENDOR_NAME>FCP</SALES_VENDOR_NAME> <BR /> <CHANNEL_NAME>Call Center</CHANNEL_NAME> <BR /> <FINAL_BILL_FEES></FINAL_BILL_FEES> <BR /> <ETRM_BILL_SUB_TYPE>0</ETRM_BILL_SUB_TYPE> <BR /> <NSF_BILL_SUB_TYPE>0</NSF_BILL_SUB_TYPE> <BR /> <LPC_BILL_SUB_TYPE>0</LPC_BILL_SUB_TYPE> <BR /> <CCF_BILL_SUB_TYPE>0</CCF_BILL_SUB_TYPE> <BR /> <BILL_SUB_TYPE_650F>0</BILL_SUB_TYPE_650F> <BR /> <DNPF_BILL_SUB_TYPE>0</DNPF_BILL_SUB_TYPE> <BR /> <BDE_WRITE_OFF_DT></BDE_WRITE_OFF_DT> <BR /> <BDE_WRITE_OFF_AMT>0</BDE_WRITE_OFF_AMT> <BR /> <PDE_WRITE_OFF_DT></PDE_WRITE_OFF_DT> <BR /> <PDE_WRITE_OFF_AMT>0</PDE_WRITE_OFF_AMT> <BR /> <MOVE_OUT_TYPE>Switch-Away</MOVE_OUT_TYPE> <BR /> <DREF_AMT_ON_FINAL_BILL></DREF_AMT_ON_FINAL_BILL> <BR /> <DREF_AMT_AFTER_FINAL_BILL>0</DREF_AMT_AFTER_FINAL_BILL> <BR /> <TOTAL_AMOUNT_DUE>53.33</TOTAL_AMOUNT_DUE> <BR /> <TOTAL_NEW_CHARGES>53.33</TOTAL_NEW_CHARGES> <BR /> <CAM_ASSIGNED_AMOUNT></CAM_ASSIGNED_AMOUNT> <BR /> <ASSIGNED_AGENCY_NAME></ASSIGNED_AGENCY_NAME> <BR /> <CAM_ASSIGNED_DT></CAM_ASSIGNED_DT> <BR /> <ACH_RCC_STATUS>ACH</ACH_RCC_STATUS> <BR /> <LITE_UP_STATUS>N</LITE_UP_STATUS> <BR /> <BUDGET_BILL_STATUS>N</BUDGET_BILL_STATUS> <BR /> <UNBILLED_RECEIVABLES></UNBILLED_RECEIVABLES> <BR /> <CURRENT_RECEIVABLES></CURRENT_RECEIVABLES> <BR /> <OUTSTANDING_AM_1_30></OUTSTANDING_AM_1_30> <BR /> <OUTSTANDING_AM_31_60></OUTSTANDING_AM_31_60> <BR /> <OUTSTANDING_AM_61_90></OUTSTANDING_AM_61_90> <BR /> <OUTSTANDING_AM_91_180></OUTSTANDING_AM_91_180> <BR /> <OUTSTANDING_AM_GT_180></OUTSTANDING_AM_GT_180> <BR /> <UNAPPLIED_CREDITS></UNAPPLIED_CREDITS> <BR /> <TOTAL_BAL>0</TOTAL_BAL> <BR /> <FB2_CORRESPONDENCE_DT></FB2_CORRESPONDENCE_DT> <BR /> <FB2_NOTICE_AMOUNT></FB2_NOTICE_AMOUNT> <BR /> <PA_GRANTED_CNT></PA_GRANTED_CNT> <BR /> <PA_COMPLETED_CNT></PA_COMPLETED_CNT> <BR /> <PA_SATISFIED_CNT></PA_SATISFIED_CNT> <BR /> <PA_DROPPED_CNT></PA_DROPPED_CNT> <BR /> <PA_CANCELLED_CNT></PA_CANCELLED_CNT> <BR /> <TOTAL_DNPL_EVENTS></TOTAL_DNPL_EVENTS> <BR /> <MONTHS_DNP_COUNT></MONTHS_DNP_COUNT> <BR /> <TOTAL_NSF_COUNT>0</TOTAL_NSF_COUNT> <BR /> <LPC_COUNT>0</LPC_COUNT> <BR /> <RATED_USAGE>Y</RATED_USAGE> <BR /> - <ENERGY_PRICE><BR /> - <DETAIL><BR /> <CHARGE_TY_CD>KWH</CHARGE_TY_CD> <BR /> <BLOCK_START_NO>0</BLOCK_START_NO> <BR /> <BLOCK_END_NO>0</BLOCK_END_NO> <BR /> <BLOCK_UNIT_CD>KH</BLOCK_UNIT_CD> <BR /> <SIGNIFICANCE_CD>TOT</SIGNIFICANCE_CD> <BR /> <PRICE_PER_UNIT_NO>.132</PRICE_PER_UNIT_NO> <BR /> <SEASON_NM>All</SEASON_NM> <BR /> <USAGE_QUAL_CD>M</USAGE_QUAL_CD> <BR /> </DETAIL><BR /> </ENERGY_PRICE><BR /> <CUSTOMER_VALUE></CUSTOMER_VALUE> <BR /> </FBE_ROW><BR /> - <FBE_ROW><BR /> <CUSTOMER_NUMBER>1111111</CUSTOMER_NUMBER> <BR /> <CUSTOMER_TYPE>RES</CUSTOMER_TYPE> <BR /> <ACCOUNT_ID>232323234</ACCOUNT_ID> <BR /> <ACCOUNT_NAME>Tes Name3</ACCOUNT_NAME> <BR /> <ACCOUNT_NUMBER>655123456789000000</ACCOUNT_NUMBER> <BR /> <ACCOUNT_TYPE>RES</ACCOUNT_TYPE> <BR /> <PROFIT_CENTER>MASS</PROFIT_CENTER> <BR /> <CREDIT_SCORE>521</CREDIT_SCORE> <BR /> <TDSP>Centerpoint Energy Houston Electric LLC</TDSP> <BR /> <LDC_ACCT_ID>1782796</LDC_ACCT_ID> <BR /> <LDC_START_DT>20080506</LDC_START_DT> <BR /> <LDC_END_DT>20080507</LDC_END_DT> <BR /> <LDC_BUILDING_TY_CD>House</LDC_BUILDING_TY_CD> <BR /> <LDC_BUILDING_SUB_TY_CD>1 Story House Three Bedroom</LDC_BUILDING_SUB_TY_CD> <BR /> <COUNTY_NM>HARRIS</COUNTY_NM> <BR /> <DOS>1</DOS> <BR /> <LDC_CLASS_TYPE>RES</LDC_CLASS_TYPE> <BR /> <TOTAL_ESI_ON_ACCOUNT>1</TOTAL_ESI_ON_ACCOUNT> <BR /> <COLLECTION_RULE_NM>RESIDENTIAL DEFAULT</COLLECTION_RULE_NM> <BR /> <MAX_INVOICE_ID>83200019422386</MAX_INVOICE_ID> <BR /> <FINAL_INVOICE_DT>20081114</FINAL_INVOICE_DT> <BR /> <FINAL_INVOICE_CREATION_DT>20081115</FINAL_INVOICE_CREATION_DT> <BR /> <FINAL_BILL_DUE_DT>20081202</FINAL_BILL_DUE_DT> <BR /> <RATING_GROUP>COMPMMRESREL137GREEN</RATING_GROUP> <BR /> <RATING_GROUP_START_DT>20070904</RATING_GROUP_START_DT> <BR /> <RATING_GROUP_END_DT>0</RATING_GROUP_END_DT> <BR /> <OFFER_PROMO_CODE>WHITE-CP02</OFFER_PROMO_CODE> <BR /> <AGREEMENT_MAX_ID>4066866</AGREEMENT_MAX_ID> <BR /> <AGREEMENT_START_DATE>20070904</AGREEMENT_START_DATE> <BR /> <AGREEMENT_END_DATE>20080817</AGREEMENT_END_DATE> <BR /> <AGREEMENT_RATE_CODE>COMPMMRESREL137GREEN</AGREEMENT_RATE_CODE> <BR /> <AGREEMENT_RENEWAL_OFFER></AGREEMENT_RENEWAL_OFFER> <BR /> <AGREEMENT_CONTRACT_DURATION>12</AGREEMENT_CONTRACT_DURATION> <BR /> <AGREEMENT_STATUS>CANCL</AGREEMENT_STATUS> <BR /> <AGREEMENT_TYPE>TERM</AGREEMENT_TYPE> <BR /> <RENEWAL_DEFAULT_INDICATOR>N</RENEWAL_DEFAULT_INDICATOR> <BR /> <CONTRACT_INDICATOR>N</CONTRACT_INDICATOR> <BR /> <PRICE_PLAN_NAME>SIMPLY BETTER EARTH SAVER PLAN</PRICE_PLAN_NAME> <BR /> <SALES_VENDOR_NAME>WhiteFence</SALES_VENDOR_NAME> <BR /> <CHANNEL_NAME>Third Party Website</CHANNEL_NAME> <BR /> <FINAL_BILL_FEES>0</FINAL_BILL_FEES> <BR /> <ETRM_BILL_SUB_TYPE>0</ETRM_BILL_SUB_TYPE> <BR /> <NSF_BILL_SUB_TYPE>0</NSF_BILL_SUB_TYPE> <BR /> <LPC_BILL_SUB_TYPE>0</LPC_BILL_SUB_TYPE> <BR /> <CCF_BILL_SUB_TYPE>0</CCF_BILL_SUB_TYPE> <BR /> <BILL_SUB_TYPE_650F>0</BILL_SUB_TYPE_650F> <BR /> <DNPF_BILL_SUB_TYPE>0</DNPF_BILL_SUB_TYPE> <BR /> <BDE_WRITE_OFF_DT>20090221</BDE_WRITE_OFF_DT> <BR /> <BDE_WRITE_OFF_AMT>-9.62</BDE_WRITE_OFF_AMT> <BR /> <PDE_WRITE_OFF_DT></PDE_WRITE_OFF_DT> <BR /> <PDE_WRITE_OFF_AMT>0</PDE_WRITE_OFF_AMT> <BR /> <MOVE_OUT_TYPE>Force Move-Out</MOVE_OUT_TYPE> <BR /> <DREF_AMT_ON_FINAL_BILL>0</DREF_AMT_ON_FINAL_BILL> <BR /> <DREF_AMT_AFTER_FINAL_BILL>0</DREF_AMT_AFTER_FINAL_BILL> <BR /> <TOTAL_AMOUNT_DUE>9.62</TOTAL_AMOUNT_DUE> <BR /> <TOTAL_NEW_CHARGES>9.62</TOTAL_NEW_CHARGES> <BR /> <CAM_ASSIGNED_AMOUNT></CAM_ASSIGNED_AMOUNT> <BR /> <ASSIGNED_AGENCY_NAME></ASSIGNED_AGENCY_NAME> <BR /> <CAM_ASSIGNED_DT></CAM_ASSIGNED_DT> <BR /> <ACH_RCC_STATUS></ACH_RCC_STATUS> <BR /> <LITE_UP_STATUS>N</LITE_UP_STATUS> <BR /> <BUDGET_BILL_STATUS>N</BUDGET_BILL_STATUS> <BR /> <UNBILLED_RECEIVABLES></UNBILLED_RECEIVABLES> <BR /> <CURRENT_RECEIVABLES></CURRENT_RECEIVABLES> <BR /> <OUTSTANDING_AM_1_30></OUTSTANDING_AM_1_30> <BR /> <OUTSTANDING_AM_31_60></OUTSTANDING_AM_31_60> <BR /> <OUTSTANDING_AM_61_90></OUTSTANDING_AM_61_90> <BR /> <OUTSTANDING_AM_91_180></OUTSTANDING_AM_91_180> <BR /> <OUTSTANDING_AM_GT_180></OUTSTANDING_AM_GT_180> <BR /> <UNAPPLIED_CREDITS></UNAPPLIED_CREDITS> <BR /> <TOTAL_BAL>0</TOTAL_BAL> <BR /> <FB2_CORRESPONDENCE_DT>20081205</FB2_CORRESPONDENCE_DT> <BR /> <FB2_NOTICE_AMOUNT>9.62</FB2_NOTICE_AMOUNT> <BR /> <PA_GRANTED_CNT></PA_GRANTED_CNT> <BR /> <PA_COMPLETED_CNT></PA_COMPLETED_CNT> <BR /> <PA_SATISFIED_CNT></PA_SATISFIED_CNT> <BR /> <PA_DROPPED_CNT></PA_DROPPED_CNT> <BR /> <PA_CANCELLED_CNT></PA_CANCELLED_CNT> <BR /> <TOTAL_DNPL_EVENTS></TOTAL_DNPL_EVENTS> <BR /> <MONTHS_DNP_COUNT></MONTHS_DNP_COUNT> <BR /> <TOTAL_NSF_COUNT>0</TOTAL_NSF_COUNT> <BR /> <LPC_COUNT>0</LPC_COUNT> <BR /> <RATED_USAGE>Y</RATED_USAGE> <BR /> - <ENERGY_PRICE><BR /> - <DETAIL><BR /> <CHARGE_TY_CD>KWH</CHARGE_TY_CD> <BR /> <BLOCK_START_NO>0</BLOCK_START_NO> <BR /> <BLOCK_END_NO>0</BLOCK_END_NO> <BR /> <BLOCK_UNIT_CD>KH</BLOCK_UNIT_CD> <BR /> <SIGNIFICANCE_CD>TOT</SIGNIFICANCE_CD> <BR /> <PRICE_PER_UNIT_NO>.132</PRICE_PER_UNIT_NO> <BR /> <SEASON_NM>All</SEASON_NM> <BR /> <USAGE_QUAL_CD>M</USAGE_QUAL_CD> <BR /> </DETAIL><BR /> </ENERGY_PRICE><BR /> <CUSTOMER_VALUE></CUSTOMER_VALUE> <BR /> </FBE_ROW><BR /> - <FBE_ROW><BR /> <CUSTOMER_NUMBER>0000000000121213</CUSTOMER_NUMBER> <BR /> <CUSTOMER_TYPE>RES</CUSTOMER_TYPE> <BR /> <ACCOUNT_ID>13456789</ACCOUNT_ID> <BR /> <ACCOUNT_NAME>Test Name4</ACCOUNT_NAME> <BR /> <ACCOUNT_NUMBER>6550987654321</ACCOUNT_NUMBER> <BR /> <ACCOUNT_TYPE>RES</ACCOUNT_TYPE> <BR /> <PROFIT_CENTER>MASS</PROFIT_CENTER> <BR /> <CREDIT_SCORE>640</CREDIT_SCORE> <BR /> <TDSP>Centerpoint Energy Houston Electric LLC</TDSP> <BR /> <LDC_ACCT_ID>1782826</LDC_ACCT_ID> <BR /> <LDC_START_DT>20070829</LDC_START_DT> <BR /> <LDC_END_DT>20071211</LDC_END_DT> <BR /> <LDC_BUILDING_TY_CD>Apartment</LDC_BUILDING_TY_CD> <BR /> <LDC_BUILDING_SUB_TY_CD>Apartment/Condo Two Bedroom</LDC_BUILDING_SUB_TY_CD> <BR /> <COUNTY_NM>HARRIS</COUNTY_NM> <BR /> <DOS>104</DOS> <BR /> <LDC_CLASS_TYPE>RES</LDC_CLASS_TYPE> <BR /> <TOTAL_ESI_ON_ACCOUNT>1</TOTAL_ESI_ON_ACCOUNT> <BR /> <COLLECTION_RULE_NM>RESIDENTIAL DEFAULT</COLLECTION_RULE_NM> <BR /> <MAX_INVOICE_ID>73480010888877</MAX_INVOICE_ID> <BR /> <FINAL_INVOICE_DT>20071214</FINAL_INVOICE_DT> <BR /> <FINAL_INVOICE_CREATION_DT>20071214</FINAL_INVOICE_CREATION_DT> <BR /> <FINAL_BILL_DUE_DT>20071231</FINAL_BILL_DUE_DT> <BR /> <RATING_GROUP>COMPMMRESREL137GREEN</RATING_GROUP> <BR /> <RATING_GROUP_START_DT>20070829</RATING_GROUP_START_DT> <BR /> <RATING_GROUP_END_DT>0</RATING_GROUP_END_DT> <BR /> <OFFER_PROMO_CODE>WHITE-CP02</OFFER_PROMO_CODE> <BR /> <AGREEMENT_MAX_ID>4067477</AGREEMENT_MAX_ID> <BR /> <AGREEMENT_START_DATE>20070829</AGREEMENT_START_DATE> <BR /> <AGREEMENT_END_DATE>20080817</AGREEMENT_END_DATE> <BR /> <AGREEMENT_RATE_CODE>COMPMMRESREL137GREEN</AGREEMENT_RATE_CODE> <BR /> <AGREEMENT_RENEWAL_OFFER></AGREEMENT_RENEWAL_OFFER> <BR /> <AGREEMENT_CONTRACT_DURATION>12</AGREEMENT_CONTRACT_DURATION> <BR /> <AGREEMENT_STATUS>CANCL</AGREEMENT_STATUS> <BR /> <AGREEMENT_TYPE>TERM</AGREEMENT_TYPE> <BR /> <RENEWAL_DEFAULT_INDICATOR>N</RENEWAL_DEFAULT_INDICATOR> <BR /> <CONTRACT_INDICATOR>N</CONTRACT_INDICATOR> <BR /> <PRICE_PLAN_NAME>SIMPLY BETTER EARTH SAVER PLAN</PRICE_PLAN_NAME> <BR /> <SALES_VENDOR_NAME>WhiteFence</SALES_VENDOR_NAME> <BR /> <CHANNEL_NAME>Third Party Website</CHANNEL_NAME> <BR /> <FINAL_BILL_FEES></FINAL_BILL_FEES> <BR /> <ETRM_BILL_SUB_TYPE>0</ETRM_BILL_SUB_TYPE> <BR /> <NSF_BILL_SUB_TYPE>0</NSF_BILL_SUB_TYPE> <BR /> <LPC_BILL_SUB_TYPE>14.12</LPC_BILL_SUB_TYPE> <BR /> <CCF_BILL_SUB_TYPE>0</CCF_BILL_SUB_TYPE> <BR /> <BILL_SUB_TYPE_650F>15</BILL_SUB_TYPE_650F> <BR /> <DNPF_BILL_SUB_TYPE>0</DNPF_BILL_SUB_TYPE> <BR /> <BDE_WRITE_OFF_DT>20080322</BDE_WRITE_OFF_DT> <BR /> <BDE_WRITE_OFF_AMT>-240.69</BDE_WRITE_OFF_AMT> <BR /> <PDE_WRITE_OFF_DT></PDE_WRITE_OFF_DT> <BR /> <PDE_WRITE_OFF_AMT>0</PDE_WRITE_OFF_AMT> <BR /> <MOVE_OUT_TYPE>Force Move-Out</MOVE_OUT_TYPE> <BR /> <DREF_AMT_ON_FINAL_BILL></DREF_AMT_ON_FINAL_BILL> <BR /> <DREF_AMT_AFTER_FINAL_BILL>0</DREF_AMT_AFTER_FINAL_BILL> <BR /> <TOTAL_AMOUNT_DUE>240.69</TOTAL_AMOUNT_DUE> <BR /> <TOTAL_NEW_CHARGES>52.77</TOTAL_NEW_CHARGES> <BR /> <CAM_ASSIGNED_AMOUNT>240.69</CAM_ASSIGNED_AMOUNT> <BR /> <ASSIGNED_AGENCY_NAME>CREDIT SYSTEMS INTERNATIONAL</ASSIGNED_AGENCY_NAME> <BR /> <CAM_ASSIGNED_DT>20080117</CAM_ASSIGNED_DT> <BR /> <ACH_RCC_STATUS></ACH_RCC_STATUS> <BR /> <LITE_UP_STATUS>N</LITE_UP_STATUS> <BR /> <BUDGET_BILL_STATUS>N</BUDGET_BILL_STATUS> <BR /> <UNBILLED_RECEIVABLES></UNBILLED_RECEIVABLES> <BR /> <CURRENT_RECEIVABLES></CURRENT_RECEIVABLES> <BR /> <OUTSTANDING_AM_1_30></OUTSTANDING_AM_1_30> <BR /> <OUTSTANDING_AM_31_60></OUTSTANDING_AM_31_60> <BR /> <OUTSTANDING_AM_61_90></OUTSTANDING_AM_61_90> <BR /> <OUTSTANDING_AM_91_180></OUTSTANDING_AM_91_180> <BR /> <OUTSTANDING_AM_GT_180></OUTSTANDING_AM_GT_180> <BR /> <UNAPPLIED_CREDITS></UNAPPLIED_CREDITS> <BR /> <TOTAL_BAL>0</TOTAL_BAL> <BR /> <FB2_CORRESPONDENCE_DT>20080102</FB2_CORRESPONDENCE_DT> <BR /> <FB2_NOTICE_AMOUNT>240.69</FB2_NOTICE_AMOUNT> <BR /> <PA_GRANTED_CNT></PA_GRANTED_CNT> <BR /> <PA_COMPLETED_CNT></PA_COMPLETED_CNT> <BR /> <PA_SATISFIED_CNT></PA_SATISFIED_CNT> <BR /> <PA_DROPPED_CNT></PA_DROPPED_CNT> <BR /> <PA_CANCELLED_CNT></PA_CANCELLED_CNT> <BR /> <TOTAL_DNPL_EVENTS>2</TOTAL_DNPL_EVENTS> <BR /> <MONTHS_DNP_COUNT>1</MONTHS_DNP_COUNT> <BR /> <TOTAL_NSF_COUNT>0</TOTAL_NSF_COUNT> <BR /> <LPC_COUNT>2</LPC_COUNT> <BR /> <RATED_USAGE>Y</RATED_USAGE> <BR /> - <ENERGY_PRICE><BR /> - <DETAIL><BR /> <CHARGE_TY_CD>KWH</CHARGE_TY_CD> <BR /> <BLOCK_START_NO>0</BLOCK_START_NO> <BR /> <BLOCK_END_NO>0</BLOCK_END_NO> <BR /> <BLOCK_UNIT_CD>KH</BLOCK_UNIT_CD> <BR /> <SIGNIFICANCE_CD>TOT</SIGNIFICANCE_CD> <BR /> <PRICE_PER_UNIT_NO>.132</PRICE_PER_UNIT_NO> <BR /> <SEASON_NM>All</SEASON_NM> <BR /> <USAGE_QUAL_CD>M</USAGE_QUAL_CD> <BR /> </DETAIL><BR /> </ENERGY_PRICE><BR /> <CUSTOMER_VALUE></CUSTOMER_VALUE> <BR /> </FBE_ROW><BR /> - <FBE_ROW><BR /> <CUSTOMER_NUMBER>1012134567</CUSTOMER_NUMBER> <BR /> <CUSTOMER_TYPE>RES</CUSTOMER_TYPE> <BR /> <ACCOUNT_ID>000000001</ACCOUNT_ID> <BR /> <ACCOUNT_NAME>Test Name5</ACCOUNT_NAME> <BR /> <ACCOUNT_NUMBER>65598789054</ACCOUNT_NUMBER> <BR /> <ACCOUNT_TYPE>RES</ACCOUNT_TYPE> <BR /> <PROFIT_CENTER>MASS</PROFIT_CENTER> <BR /> <CREDIT_SCORE>579</CREDIT_SCORE> <BR /> <TDSP>Centerpoint Energy Houston Electric LLC</TDSP> <BR /> <LDC_ACCT_ID>1234567</LDC_ACCT_ID> <BR /> <LDC_START_DT>20070830</LDC_START_DT> <BR /> <LDC_END_DT>20080424</LDC_END_DT> <BR /> <LDC_BUILDING_TY_CD>Apartment</LDC_BUILDING_TY_CD> <BR /> <LDC_BUILDING_SUB_TY_CD>Apartment/Condo Two Bedroom</LDC_BUILDING_SUB_TY_CD> <BR /> <COUNTY_NM>HARRIS</COUNTY_NM> <BR /> <DOS>238</DOS> <BR /> <LDC_CLASS_TYPE>RES</LDC_CLASS_TYPE> <BR /> <TOTAL_ESI_ON_ACCOUNT>1</TOTAL_ESI_ON_ACCOUNT> <BR /> <COLLECTION_RULE_NM>RESIDENTIAL DEFAULT</COLLECTION_RULE_NM> <BR /> <MAX_INVOICE_ID>81440014929542</MAX_INVOICE_ID> <BR /> <FINAL_INVOICE_DT>20080523</FINAL_INVOICE_DT> <BR /> <FINAL_INVOICE_CREATION_DT>20080523</FINAL_INVOICE_CREATION_DT> <BR /> <FINAL_BILL_DUE_DT>20080611</FINAL_BILL_DUE_DT> <BR /> <RATING_GROUP>COMPMMRESREL137GREEN</RATING_GROUP> <BR /> <RATING_GROUP_START_DT>20070830</RATING_GROUP_START_DT> <BR /> <RATING_GROUP_END_DT>0</RATING_GROUP_END_DT> <BR /> <OFFER_PROMO_CODE>STD-CP05</OFFER_PROMO_CODE> <BR /> <AGREEMENT_MAX_ID>4285525</AGREEMENT_MAX_ID> <BR /> <AGREEMENT_START_DATE>20070830</AGREEMENT_START_DATE> <BR /> <AGREEMENT_END_DATE>20080817</AGREEMENT_END_DATE> <BR /> <AGREEMENT_RATE_CODE>COMPMMRESREL137GREEN</AGREEMENT_RATE_CODE> <BR /> <AGREEMENT_RENEWAL_OFFER></AGREEMENT_RENEWAL_OFFER> <BR /> <AGREEMENT_CONTRACT_DURATION>12</AGREEMENT_CONTRACT_DURATION> <BR /> <AGREEMENT_STATUS>CANCL</AGREEMENT_STATUS> <BR /> <AGREEMENT_TYPE>TERM</AGREEMENT_TYPE> <BR /> <RENEWAL_DEFAULT_INDICATOR>N</RENEWAL_DEFAULT_INDICATOR> <BR /> <CONTRACT_INDICATOR>N</CONTRACT_INDICATOR> <BR /> <PRICE_PLAN_NAME>SIMPLY BETTER EARTH SAVER PLAN</PRICE_PLAN_NAME> <BR /> <SALES_VENDOR_NAME>FCP</SALES_VENDOR_NAME> <BR /> <CHANNEL_NAME>Call Center</CHANNEL_NAME> <BR /> <FINAL_BILL_FEES>0</FINAL_BILL_FEES> <BR /> <ETRM_BILL_SUB_TYPE>0</ETRM_BILL_SUB_TYPE> <BR /> <NSF_BILL_SUB_TYPE>25</NSF_BILL_SUB_TYPE> <BR /> <LPC_BILL_SUB_TYPE>63.62</LPC_BILL_SUB_TYPE> <BR /> <CCF_BILL_SUB_TYPE>0</CCF_BILL_SUB_TYPE> <BR /> <BILL_SUB_TYPE_650F>0</BILL_SUB_TYPE_650F> <BR /> <DNPF_BILL_SUB_TYPE>0</DNPF_BILL_SUB_TYPE> <BR /> <BDE_WRITE_OFF_DT>20080831</BDE_WRITE_OFF_DT> <BR /> <BDE_WRITE_OFF_AMT>-809.67</BDE_WRITE_OFF_AMT> <BR /> <PDE_WRITE_OFF_DT></PDE_WRITE_OFF_DT> <BR /> <PDE_WRITE_OFF_AMT>0</PDE_WRITE_OFF_AMT> <BR /> <MOVE_OUT_TYPE>Collections Generated</MOVE_OUT_TYPE> <BR /> <DREF_AMT_ON_FINAL_BILL>0</DREF_AMT_ON_FINAL_BILL> <BR /> <DREF_AMT_AFTER_FINAL_BILL>0</DREF_AMT_AFTER_FINAL_BILL> <BR /> <TOTAL_AMOUNT_DUE>809.67</TOTAL_AMOUNT_DUE> <BR /> <TOTAL_NEW_CHARGES>8.78</TOTAL_NEW_CHARGES> <BR /> <CAM_ASSIGNED_AMOUNT>809.85</CAM_ASSIGNED_AMOUNT> <BR /> <ASSIGNED_AGENCY_NAME>CREDIT SYSTEMS INTERNATIONAL</ASSIGNED_AGENCY_NAME> <BR /> <CAM_ASSIGNED_DT>20080627</CAM_ASSIGNED_DT> <BR /> <ACH_RCC_STATUS></ACH_RCC_STATUS> <BR /> <LITE_UP_STATUS>N</LITE_UP_STATUS> <BR /> <BUDGET_BILL_STATUS>N</BUDGET_BILL_STATUS> <BR /> <UNBILLED_RECEIVABLES></UNBILLED_RECEIVABLES> <BR /> <CURRENT_RECEIVABLES></CURRENT_RECEIVABLES> <BR /> <OUTSTANDING_AM_1_30></OUTSTANDING_AM_1_30> <BR /> <OUTSTANDING_AM_31_60></OUTSTANDING_AM_31_60> <BR /> <OUTSTANDING_AM_61_90></OUTSTANDING_AM_61_90> <BR /> <OUTSTANDING_AM_91_180></OUTSTANDING_AM_91_180> <BR /> <OUTSTANDING_AM_GT_180></OUTSTANDING_AM_GT_180> <BR /> <UNAPPLIED_CREDITS></UNAPPLIED_CREDITS> <BR /> <TOTAL_BAL>0</TOTAL_BAL> <BR /> <FB2_CORRESPONDENCE_DT>20080612</FB2_CORRESPONDENCE_DT> <BR /> <FB2_NOTICE_AMOUNT>809.67</FB2_NOTICE_AMOUNT> <BR /> <PA_GRANTED_CNT></PA_GRANTED_CNT> <BR /> <PA_COMPLETED_CNT></PA_COMPLETED_CNT> <BR /> <PA_SATISFIED_CNT></PA_SATISFIED_CNT> <BR /> <PA_DROPPED_CNT></PA_DROPPED_CNT> <BR /> <PA_CANCELLED_CNT></PA_CANCELLED_CNT> <BR /> <TOTAL_DNPL_EVENTS>4</TOTAL_DNPL_EVENTS> <BR /> <MONTHS_DNP_COUNT>1</MONTHS_DNP_COUNT> <BR /> <TOTAL_NSF_COUNT>1</TOTAL_NSF_COUNT> <BR /> <LPC_COUNT>4</LPC_COUNT> <BR /> <RATED_USAGE>Y</RATED_USAGE> <BR /> - <ENERGY_PRICE><BR /> - <DETAIL><BR /> <CHARGE_TY_CD>KWH</CHARGE_TY_CD> <BR /> <BLOCK_START_NO>0</BLOCK_START_NO> <BR /> <BLOCK_END_NO>0</BLOCK_END_NO> <BR /> <BLOCK_UNIT_CD>KH</BLOCK_UNIT_CD> <BR /> <SIGNIFICANCE_CD>TOT</SIGNIFICANCE_CD> <BR /> <PRICE_PER_UNIT_NO>.132</PRICE_PER_UNIT_NO> <BR /> <SEASON_NM>All</SEASON_NM> <BR /> <USAGE_QUAL_CD>M</USAGE_QUAL_CD> <BR /> </DETAIL><BR /> </ENERGY_PRICE><BR /> <CUSTOMER_VALUE></CUSTOMER_VALUE> <BR /> </FBE_ROW><BR /> - <FBE_ROW><BR /> <CUSTOMER_NUMBER>4444444498</CUSTOMER_NUMBER> <BR /> <CUSTOMER_TYPE>RES</CUSTOMER_TYPE> <BR /> <ACCOUNT_ID>55555567</ACCOUNT_ID> <BR /> <ACCOUNT_NAME>Test Name6</ACCOUNT_NAME> <BR /> <ACCOUNT_NUMBER>655555555555789</ACCOUNT_NUMBER> <BR /> <ACCOUNT_TYPE>RES</ACCOUNT_TYPE> <BR /> <PROFIT_CENTER>MASS</PROFIT_CENTER> <BR /> <CREDIT_SCORE></CREDIT_SCORE> <BR /> <TDSP>Centerpoint Energy Houston Electric LLC</TDSP> <BR /> <LDC_ACCT_ID>2967926</LDC_ACCT_ID> <BR /> <LDC_START_DT>20071130</LDC_START_DT> <BR /> <LDC_END_DT>20080822</LDC_END_DT> <BR /> <LDC_BUILDING_TY_CD>Apartment</LDC_BUILDING_TY_CD> <BR /> <LDC_BUILDING_SUB_TY_CD>Apartment/Condo Two Bedroom</LDC_BUILDING_SUB_TY_CD> <BR /> <COUNTY_NM>HARRIS</COUNTY_NM> <BR /> <DOS>266</DOS> <BR /> <LDC_CLASS_TYPE>RES</LDC_CLASS_TYPE> <BR /> <TOTAL_ESI_ON_ACCOUNT>2</TOTAL_ESI_ON_ACCOUNT> <BR /> <COLLECTION_RULE_NM>RESIDENTIAL DEFAULT</COLLECTION_RULE_NM> <BR /> <MAX_INVOICE_ID>82390017437668</MAX_INVOICE_ID> <BR /> <FINAL_INVOICE_DT>20080826</FINAL_INVOICE_DT> <BR /> <FINAL_INVOICE_CREATION_DT>20080826</FINAL_INVOICE_CREATION_DT> <BR /> <FINAL_BILL_DUE_DT>20080912</FINAL_BILL_DUE_DT> <BR /> <RATING_GROUP>1R53</RATING_GROUP> <BR /> <RATING_GROUP_START_DT>20071130</RATING_GROUP_START_DT> <BR /> <RATING_GROUP_END_DT>0</RATING_GROUP_END_DT> <BR /> <OFFER_PROMO_CODE>STD</OFFER_PROMO_CODE> <BR /> <AGREEMENT_MAX_ID>9007542</AGREEMENT_MAX_ID> <BR /> <AGREEMENT_START_DATE>20071130</AGREEMENT_START_DATE> <BR /> <AGREEMENT_END_DATE>20080827</AGREEMENT_END_DATE> <BR /> <AGREEMENT_RATE_CODE>1R53</AGREEMENT_RATE_CODE> <BR /> <AGREEMENT_RENEWAL_OFFER>RENEW-DEFAULT-CP1</AGREEMENT_RENEWAL_OFFER> <BR /> <AGREEMENT_CONTRACT_DURATION>12</AGREEMENT_CONTRACT_DURATION> <BR /> <AGREEMENT_STATUS>COMPL</AGREEMENT_STATUS> <BR /> <AGREEMENT_TYPE>TERM</AGREEMENT_TYPE> <BR /> <RENEWAL_DEFAULT_INDICATOR>N</RENEWAL_DEFAULT_INDICATOR> <BR /> <CONTRACT_INDICATOR>N</CONTRACT_INDICATOR> <BR /> <PRICE_PLAN_NAME></PRICE_PLAN_NAME> <BR /> <SALES_VENDOR_NAME>ADS</SALES_VENDOR_NAME> <BR /> <CHANNEL_NAME>Standard-APR</CHANNEL_NAME> <BR /> <FINAL_BILL_FEES>0</FINAL_BILL_FEES> <BR /> <ETRM_BILL_SUB_TYPE>0</ETRM_BILL_SUB_TYPE> <BR /> <NSF_BILL_SUB_TYPE>0</NSF_BILL_SUB_TYPE> <BR /> <LPC_BILL_SUB_TYPE>75.08</LPC_BILL_SUB_TYPE> <BR /> <CCF_BILL_SUB_TYPE>0</CCF_BILL_SUB_TYPE> <BR /> <BILL_SUB_TYPE_650F>30</BILL_SUB_TYPE_650F> <BR /> <DNPF_BILL_SUB_TYPE>0</DNPF_BILL_SUB_TYPE> <BR /> <BDE_WRITE_OFF_DT>20081220</BDE_WRITE_OFF_DT> <BR /> <BDE_WRITE_OFF_AMT>-1200.12</BDE_WRITE_OFF_AMT> <BR /> <PDE_WRITE_OFF_DT></PDE_WRITE_OFF_DT> <BR /> <PDE_WRITE_OFF_AMT>0</PDE_WRITE_OFF_AMT> <BR /> <MOVE_OUT_TYPE>Force Move-Out</MOVE_OUT_TYPE> <BR /> <DREF_AMT_ON_FINAL_BILL>-286.91</DREF_AMT_ON_FINAL_BILL> <BR /> <DREF_AMT_AFTER_FINAL_BILL>0</DREF_AMT_AFTER_FINAL_BILL> <BR /> <TOTAL_AMOUNT_DUE>1200.12</TOTAL_AMOUNT_DUE> <BR /> <TOTAL_NEW_CHARGES>321.67</TOTAL_NEW_CHARGES> <BR /> <CAM_ASSIGNED_AMOUNT>1200.12</CAM_ASSIGNED_AMOUNT> <BR /> <ASSIGNED_AGENCY_NAME></ASSIGNED_AGENCY_NAME> <BR /> <CAM_ASSIGNED_DT>20081121</CAM_ASSIGNED_DT> <BR /> <ACH_RCC_STATUS></ACH_RCC_STATUS> <BR /> <LITE_UP_STATUS>N</LITE_UP_STATUS> <BR /> <BUDGET_BILL_STATUS>N</BUDGET_BILL_STATUS> <BR /> <UNBILLED_RECEIVABLES></UNBILLED_RECEIVABLES> <BR /> <CURRENT_RECEIVABLES></CURRENT_RECEIVABLES> <BR /> <OUTSTANDING_AM_1_30></OUTSTANDING_AM_1_30> <BR /> <OUTSTANDING_AM_31_60></OUTSTANDING_AM_31_60> <BR /> <OUTSTANDING_AM_61_90></OUTSTANDING_AM_61_90> <BR /> <OUTSTANDING_AM_91_180></OUTSTANDING_AM_91_180> <BR /> <OUTSTANDING_AM_GT_180></OUTSTANDING_AM_GT_180> <BR /> <UNAPPLIED_CREDITS></UNAPPLIED_CREDITS> <BR /> <TOTAL_BAL>0</TOTAL_BAL> <BR /> <FB2_CORRESPONDENCE_DT>20081106</FB2_CORRESPONDENCE_DT> <BR /> <FB2_NOTICE_AMOUNT>1200.12</FB2_NOTICE_AMOUNT> <BR /> <PA_GRANTED_CNT>2</PA_GRANTED_CNT> <BR /> <PA_COMPLETED_CNT>1</PA_COMPLETED_CNT> <BR /> <PA_SATISFIED_CNT>0</PA_SATISFIED_CNT> <BR /> <PA_DROPPED_CNT>1</PA_DROPPED_CNT> <BR /> <PA_CANCELLED_CNT>0</PA_CANCELLED_CNT> <BR /> <TOTAL_DNPL_EVENTS>6</TOTAL_DNPL_EVENTS> <BR /> <MONTHS_DNP_COUNT>2</MONTHS_DNP_COUNT> <BR /> <TOTAL_NSF_COUNT>0</TOTAL_NSF_COUNT> <BR /> <LPC_COUNT>2</LPC_COUNT> <BR /> <RATED_USAGE>Y</RATED_USAGE> <BR /> - <ENERGY_PRICE><BR /> - <DETAIL><BR /> <CHARGE_TY_CD>KWH</CHARGE_TY_CD> <BR /> <BLOCK_START_NO>0</BLOCK_START_NO> <BR /> <BLOCK_END_NO>2000</BLOCK_END_NO> <BR /> <BLOCK_UNIT_CD>KH</BLOCK_UNIT_CD> <BR /> <SIGNIFICANCE_CD>TOT</SIGNIFICANCE_CD> <BR /> <PRICE_PER_UNIT_NO>.136</PRICE_PER_UNIT_NO> <BR /> <SEASON_NM>All</SEASON_NM> <BR /> <USAGE_QUAL_CD>M</USAGE_QUAL_CD> <BR /> </DETAIL><BR /> - <DETAIL><BR /> <CHARGE_TY_CD>KWH</CHARGE_TY_CD> <BR /> <BLOCK_START_NO>2001</BLOCK_START_NO> <BR /> <BLOCK_END_NO>4000</BLOCK_END_NO> <BR /> <BLOCK_UNIT_CD>KH</BLOCK_UNIT_CD> <BR /> <SIGNIFICANCE_CD>TOT</SIGNIFICANCE_CD> <BR /> <PRICE_PER_UNIT_NO>.128</PRICE_PER_UNIT_NO> <BR /> <SEASON_NM>All</SEASON_NM> <BR /> <USAGE_QUAL_CD>M</USAGE_QUAL_CD> <BR /> </DETAIL><BR /> </ENERGY_PRICE><BR /> <CUSTOMER_VALUE></CUSTOMER_VALUE> <BR /> </FBE_ROW><BR /> </ROWSET> Tue, 16 Jun 2009 14:49:55 GMT https://communities.sas.com/t5/SAS-Programming/I-can-not-read-the-attached-XML-file/m-p/45290#M9343 deleted_user 2009-06-16T14:49:55Z Re: I can not read the attached XML file https://communities.sas.com/t5/SAS-Programming/I-can-not-read-the-attached-XML-file/m-p/45291#M9344 Share what code you have tried, for more focused response/reply to your post. Also, maybe you can be more specific about which record type(s) are giving you some difficulty -- important to share code and maybe even some SAS log output (pasted in your reply)?<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Tue, 16 Jun 2009 15:00:21 GMT https://communities.sas.com/t5/SAS-Programming/I-can-not-read-the-attached-XML-file/m-p/45291#M9344 sbb 2009-06-16T15:00:21Z Re: I can not read the attached XML file https://communities.sas.com/t5/SAS-Programming/I-can-not-read-the-attached-XML-file/m-p/45292#M9345 Have you provided a XML map for that data?<BR /> <BR /> It seems you have a complex structure in there.<BR /> <BR /> Cheers from Portugal.<BR /> <BR /> Daniel Santos @ <A href="http://www.cgd.pt" target="_blank">www.cgd.pt</A> Tue, 16 Jun 2009 15:15:45 GMT https://communities.sas.com/t5/SAS-Programming/I-can-not-read-the-attached-XML-file/m-p/45292#M9345 DanielSantos 2009-06-16T15:15:45Z Re: I can not read the attached XML file https://communities.sas.com/t5/SAS-Programming/I-can-not-read-the-attached-XML-file/m-p/45293#M9346 Listed below is my libname statment. The data fields prior to the Energy Price section come in OK. All fields after the Energy Price section come in blank. Thanks..<BR /> <BR /> libname newzz xml "P:\vertzz_fb_html_test.xml" XMLTYPE=ORACLE; Tue, 16 Jun 2009 15:45:34 GMT https://communities.sas.com/t5/SAS-Programming/I-can-not-read-the-attached-XML-file/m-p/45293#M9346 deleted_user 2009-06-16T15:45:34Z Re: I can not read the attached XML file https://communities.sas.com/t5/SAS-Programming/I-can-not-read-the-attached-XML-file/m-p/45294#M9347 Hi:<BR /> This would be a question for Tech Support. I know that SAS and the XML Libname engine can CREATE Oracle-compliant XML -- for OUTPUT. But, with complex XML, even Oracle XML, you may need to still have an XML Map for INPUT -- to read an XML file into a SAS dataset.<BR /> <BR /> To open a track with Tech Support, go here:<BR /> <A href="http://support.sas.com/ctx/supportform/createForm" target="_blank">http://support.sas.com/ctx/supportform/createForm</A><BR /> <BR /> cynthia<BR /> <BR /> You can refer to the XMLMap facility and the XMLMapper tool in the documentation and notes here:<BR /> <A href="http://support.sas.com/documentation/cdl/en/engxml/61740/HTML/default/a002592242.htm" target="_blank">http://support.sas.com/documentation/cdl/en/engxml/61740/HTML/default/a002592242.htm</A><BR /> <A href="http://support.sas.com/documentation/cdl/en/engxml/61740/HTML/default/a002592927.htm" target="_blank">http://support.sas.com/documentation/cdl/en/engxml/61740/HTML/default/a002592927.htm</A><BR /> <BR /> And some other info:<BR /> <A href="http://support.sas.com/kb/33/584.html" target="_blank">http://support.sas.com/kb/33/584.html</A><BR /> <A href="http://support.sas.com/rnd/base/xmlengine/index.html" target="_blank">http://support.sas.com/rnd/base/xmlengine/index.html</A><BR /> <A href="http://support.sas.com/rnd/base/xmlengine/sxle913/index.html" target="_blank">http://support.sas.com/rnd/base/xmlengine/sxle913/index.html</A><BR /> <A href="http://support.sas.com/rnd/base/xmlengine/sxle90/#xmlmap" target="_blank">http://support.sas.com/rnd/base/xmlengine/sxle90/#xmlmap</A> Tue, 16 Jun 2009 17:56:25 GMT https://communities.sas.com/t5/SAS-Programming/I-can-not-read-the-attached-XML-file/m-p/45294#M9347 Cynthia_sas 2009-06-16T17:56:25Z