Sample: Bill XML import file
Copy
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<BillImportDocument>
<Header>
<DataFormat DateFormat="YYYY-MM-DDTHH:mm:SS" />
<Creation_Datetime Datetime="2007-10-10T14:39:54" />
<Version Number="5.2.12.1" />
</Header>
<Configurations>
<? Add a new Bill Item Class Category ?>
<BillItemClassCategory ID="BICC_TEST1" Description="BICC_TEST1" CommodityTypeID="Electric" UnitClassID="Energy">
<TaskInfo TaskOperation="Add"/>
</BillItemClassCategory>
<? Add a new Bill Item Class with Default Mapping ?>
<BillItemClass ID="BIC_TEST1" Description="BIC_TEST1" BillItemClassCategoryID="BICC_TEST1">
<TaskInfo TaskOperation="Add" UseModeledRate="0"/>
<Links>
<DeterminantLink UnitID="KWH"/>
</Links>
</BillItemClass>
<? Add a new Bill Item Class with Modeled Rate Mapping IE - Add Charge and Determinant Links ?>
<BillItemClass ID="BIC_TEST2" Description="BIC_TEST2" BillItemClassCategoryID="BICC_TEST2">
<TaskInfo TaskOperation="Add" UseModeledRate="1"/>
<Links>
<ChargeLink ID="ChargeID2"/>
<DeterminantLink Name="DeterminantNM2" UnitID="KWH"/>
</Links>
</BillItemClass>
<? Delete Charge and Determinant Links from Bill Item Class ?>
<BillItemClass ID="BIC_TEST3" Description="BIC_TEST3" BillItemClassCategoryID="BICC_TEST3">
<TaskInfo TaskOperation="DeleteLink"/>
<Links>
<ChargeLink ID="ChargeID3"/>
<DeterminantLink Name="DeterminantNM3"/>
</Links>
</BillItemClass>
<? Add GL Account Type for Account Entity ?>
<GLAccountType ID="GACT_ForAcct" Description="GACT_ForAcct" CustomerID="TestCustomer">
<TaskInfo TaskOperation="Add"/>
<Links>
<GLEntityLink ID="Account"/>
</Links>
</GLAccountType>
<? Add GL Account Type for Premise Entity NOTE: Valid GLEntityLinks are 'Account', 'Premise', 'ServicePoint', 'ServiceProvider', 'BillItemCharge' ?>
<GLAccountType ID="GACT_ForPrem" Description="GACT_ForPrem" CustomerID="TestCustomer">
<TaskInfo TaskOperation="Add"/>
<Links>
<GLEntityLink ID="Premise"/>
</Links>
</GLAccountType>
<? Delete GL Account Type, Cascade Delete GL Accounts Force is Yes / 1 ?>
<GLAccountType ID="GACT_DelTest" Description="GACT_DelTest" CustomerID="TestCustomer">
<TaskInfo TaskOperation="Delete" Force=1/>
</GLAccountType>
<? Add GL Account Code with IEE Account Entity Link ?>
<GLAccount ID="GAC_Acc1" Description="GAC_Acc1" GLAccountTypeID="GACT_ForAcct" EffectiveStartDate="2002-01-01T00:00:00Z"
EffectiveEndDate="2071-01-01T00:00:00Z">
<TaskInfo TaskOperation="Add"/>
<Links>
<AccountLink ID="1111_Account" EffectiveStartDate="2002-01-01" EffectiveEndDate="2071-01-01"/>
</Links>
</GLAccount>
<? Add GL Account Code with IEE Service Point Entity Link ?>
<GLAccount ID="GAC_Spt1" Description="GAC_Spt1" GLAccountTypeID="GACT_ForSpt" EffectiveStartDate="1970-01-01T00:00:00Z"
EffectiveEndDate="2071-01-01T00:00:00Z">
<TaskInfo TaskOperation="Add"/>
<Links>
<ServicePointLink ID="5555_ServicePoint" EffectiveStartDate="1970-01-01" EffectiveEndDate="2071-01-01"/>
</Links>
</GLAccount>
<? Add GL Account Code with IEE Bill Item Charge Link ?>
<GLAccount ID="GAC_ItmChg1" Description="GAC_ItmChg1" GLAccountTypeID="GACT_ForItmChg" EffectiveStartDate="2000-01-01T00:00:00Z"
EffectiveEndDate="2071-01-01T00:00:00Z">
<TaskInfo TaskOperation="Add"/>
</GLAccount>
<? Change existing GL Account Code and Add Multiple IEE Service Point Entity Links
?>
<GLAccount ID="GAC_Spt100" Description="GAC_Spt100"
GLAccountTypeID="GACT_ForSpt100" EffectiveStartDate="2002-01-01T00:00:00Z" EffectiveEndDate="2071-01-01T00:00:00Z">
<TaskInfo TaskOperation="Change"/>
<Links>
<ServicePointLink ID="111_ServicePoint" EffectiveStartDate="2002-01-01" EffectiveEndDate="2071-01-01"/>
<ServicePointLink ID="222_ServicePoint" EffectiveStartDate="2002-01-01" EffectiveEndDate="2071-01-01"/>
</Links>
</GLAccount>
<? Change existing GL Account Code with Temporal IEE Service Point Changes ?>
<GLAccount ID="GAC_Spt100" Description="GAC_Spt100" GLAccountTypeID="GACT_ForSpt100" EffectiveStartDate="2000-01-01T00:00:00Z"
EffectiveEndDate="2001-12-31T00:00:00Z">
<TaskInfo TaskOperation="Change"/>
<Links>
<ServicePointLink ID="222_ServicePoint" EffectiveStartDate="2000-01-01" EffectiveEndDate="2001-12-31"/>
</Links>
</GLAccount>
<? Change GL Account Code with Association Deletion. Be sure to Adjust Time Change
?>
<GLAccount ID="GAC_Spt100" Description="GAC_Spt100"
GLAccountTypeID="GACT_ForSpt100" EffectiveStartDate="2000-01-01T00:00:00Z" EffectiveEndDate="2001-12-31T00:00:00Z">
<TaskInfo TaskOperation="DeleteLink"/>
<Links>
<ServicePointLink ID="222_ServicePoint" EffectiveStartDate="2000-01-01" EffectiveEndDate="2001-12-31"/>
</Links>
</GLAccount>
<? Delete existing GL Account Code ?>
<GLAccount ID="GAC_Spt1" Description="GAC_Spt1" GLAccountTypeID="GACT_ForSpt" EffectiveStartDate="2000-01-01T00:00:00Z"
EffectiveEndDate="2001-12-31T00:00:00Z">
<TaskInfo TaskOperation="Delete"/>
</GLAccount>
</Configurations>
<Bills>
<? Bill with Bill Number, Bill Status, and GL Account Code Association ?>
<Bill BillNumber="9877" AccountID="1234_Acct" CustomerID="TestCustomer" BillType="Actual"
StartDate="2005-01-01" EndDate="2005-01-31" BillPeriod="2005-01" BillDate="2005- 02-05"
Notes="Sample Bill" >
<TaskInfo TaskOperation="Add"/>
<BillStatuses>
<BillStatus Status="BillStatusReceived" EffectiveDate="2005-01-01" LastChangedBy="BPSP Operator" />
<BillStatus Status="BillStatusCreated" EffectiveDate="2005-01-15" LastChangedBy="BPSP Operator" />
<BillStatus Status="BillStatusApproved" EffectiveDate="2005-01-16" LastChangedBy="BPSP Operator" />
</BillStatuses>
<BillItems>
<Item Seq="1" BillItemClassID="BIC_Test1" ServicePointID="98765_Spt">
<Charge ID="BIC_Test1_Charge" Amount="1230.00"/>
<ChargeGLAccountLink GLAccountID="GAC_ItmChg" GLAcccountTypeID="GACT_ItmChg"
EffectiveStartDate="2001-01-01" EffectiveEndDate="2071-01-01"/>
IsExclude="0"/>
<Determinant Name="BIC_Test1_Determinant" Quantity="232"
</Item>
</BillItems>
<BillImages>
<Image ID="Bill_1234_5_200501_1" Seq="1"
FileName="\\servername\development\5.0_CC_BillMgmt\BillImage\Bill_1234-5_200501_1.jpg"/>
<Image ID="Bill_1234_5_200501_2" Seq="2"
FileName="\\servername\development\5.0_CC_BillMgmt\BillImage\Bill_1234-5_200501_2.jpg"/>
</BillImages>
</Bill>
</Bills>
</BillImportDocument>