Sample XML Format for Uploading Price Items

The following table lists the price items that you want to upload using the XML format:
Price Item	Related Price Item	Relationship Type
Overdraft Returned	-	-
Additional Negative Balance Fees	-	-
Overdraft Assistance	Overdraft Returned	Service
Overdraft Assistance	Additional Negative Balance Fees	Service Group
Note: The system will create the above price items when the required contract types, parameters, predefined parameter values, divisions, SQIs, characteristic types, predefined characteristic values are defined in the application.
<root>
<request>
<payload>
<C1_PRICEITEM_BO>
<priceItemCode>OVRDTRD</priceItemCode>
<description>Overdraft Returned</description>
<priceItemAvailFor>PRBL</priceItemAvailFor>
<priceItemType></priceItemType>
<piStatusFlag>ACTV</piStatusFlag>
<priceItemTypeFlg></priceItemTypeFlg>
<bundleSw>N</bundleSw>
<bundleTypeFlg></bundleTypeFlg>
<asgnGlobalPlSw>N</asgnGlobalPlSw>
<saType>SAVINGS</saType>
<priceItemParm>
<startDate>2019-01-01</startDate>
<endDate></endDate>
<priceParmCode>COUNTRY</priceParmCode>
<overridePriceParmLabel></overridePriceParmLabel>
<displayOrder>1</displayOrder>
<parmUsageFlg>PRI</parmUsageFlg>
<isRequired>Y</isRequired>
<priorityNum></priorityNum>
<priceItemParmVal>
<priceParmVal>USA</priceParmVal>
<priceParmVal>SWE</priceParmVal>
<priceParmVal>CHE</priceParmVal>
<priceParmVal>IND</priceParmVal>
<priceParmVal>LKA</priceParmVal>
<priceParmVal>MEX</priceParmVal>
<priceParmVal>CHN</priceParmVal>
<priceParmVal>JPN</priceParmVal>
</priceItemParmVal>
</priceItemParm>
<priceItemParm>
<startDate>2019-01-01</startDate>
<endDate></endDate>
<priceParmCode>CURRENCY</priceParmCode>
<overridePriceParmLabel></overridePriceParmLabel>
<displayOrder>2</displayOrder>
<parmUsageFlg>AGG</parmUsageFlg>
<isRequired>N</isRequired>
<priorityNum>1</priorityNum>
 				<priceItemParmVal>
<priceParmVal>USD</priceParmVal>
<priceParmVal>GBP</priceParmVal>
<priceParmVal>EUR</priceParmVal>
<priceParmVal>INR</priceParmVal>
<priceParmVal>LKR</priceParmVal>
<priceParmVal>PESO</priceParmVal>
<priceParmVal>YUAN</priceParmVal>
<priceParmVal>YEN</priceParmVal>
</priceItemParmVal>
</priceItemParm>
<divPriceitem> 
<division>DIV001</division>
<priceItemSqi>
<serviceQuantityIdentifier>ACCTBAL</serviceQuantityIdentifier>
<sqlFragment></sqlFragment>
<sqiCalcAlgCd></sqiCalcAlgCd>
<allowIncrUpdateSw></allowIncrUpdateSw>
</priceItemSqi>
<priceItemSqi>
<serviceQuantityIdentifier>AVGDBAL</serviceQuantityIdentifier>
<sqlFragment></sqlFragment>
<sqiCalcAlgCd></sqiCalcAlgCd>
<allowIncrUpdateSw></allowIncrUpdateSw>
</priceItemSqi>
<divPriceItemChar>
<characteristicType>OVERDRTPLAN</characteristicType>
<effectiveDate>2019-01-01</effectiveDate>
<characteristicValue>LINECRD</characteristicValue>
</divPriceItemChar>
</divPriceitem>
<divPriceitem>
<division>DIV002</division>
<priceItemSqi>
<serviceQuantityIdentifier>ACCTBAL</serviceQuantityIdentifier>
<sqlFragment></sqlFragment>
<sqiCalcAlgCd></sqiCalcAlgCd>
<allowIncrUpdateSw></allowIncrUpdateSw>
</priceItemSqi>
<divPriceItemChar>
<characteristicType>OVERDRTPLAN</characteristicType>
<effectiveDate>2019-01-01</effectiveDate>
<characteristicValue>LKDPTACT</characteristicValue>
</divPriceItemChar>
</divPriceitem>
<priceItemChar>
<characteristicType>ACCTTYPE</characteristicType>
<effectiveDate>2019-01-01</effectiveDate>
<characteristicValue>SAVINGS</characteristicValue> 
</priceItemChar>
<priceItemRel>
<priceItemChildCd></priceItemChildCd> 
<startDate></startDate>
<endDate></endDate>
<priceItemReTypeFlg></priceItemReTypeFlg>
<priceItemParmGroup>
<priceParmCode></priceParmCode>
<priceParmVal></priceParmVal>
</priceItemParmGroup>
<priceItemRelCharacteristic>
<effectiveDate></effectiveDate>
<characteristicType></characteristicType>
<characteristicValue></characteristicValue>
</priceItemRelCharacteristic>
</priceItemRel>
</C1_PRICEITEM_BO>
<C1_PRICEITEM_BO>
<priceItemCode>ADDNGFEE</priceItemCode>
<description>Additional Negative Balance Fees</description>
<priceItemAvailFor>PRBL</priceItemAvailFor>
<priceItemType></priceItemType>
<piStatusFlag>ACTV</piStatusFlag>
<priceItemTypeFlg></priceItemTypeFlg>
<bundleSw>N</bundleSw>
<bundleTypeFlg></bundleTypeFlg>
<asgnGlobalPlSw>N</asgnGlobalPlSw>
<saType>SAVINGS</saType>
<priceItemParm>
<startDate>2019-01-01</startDate>
<endDate></endDate>
<priceParmCode>COUNTRY</priceParmCode>
<overridePriceParmLabel></overridePriceParmLabel>
<displayOrder>1</displayOrder>
<parmUsageFlg>PRI</parmUsageFlg>
<isRequired>Y</isRequired>
<priorityNum></priorityNum>
<priceItemParmVal>
<priceParmVal>USA</priceParmVal>
<priceParmVal>SWE</priceParmVal>
<priceParmVal>CHE</priceParmVal>
<priceParmVal>IND</priceParmVal>
<priceParmVal>LKA</priceParmVal>
<priceParmVal>MEX</priceParmVal>
<priceParmVal>CHN</priceParmVal>
<priceParmVal>JPN</priceParmVal>
</priceItemParmVal>
</priceItemParm>
          <priceItemParm>
<startDate>2019-01-01</startDate>
<endDate></endDate>
<priceParmCode>CURRENCY</priceParmCode>
<overridePriceParmLabel></overridePriceParmLabel>
<displayOrder>2</displayOrder>
<parmUsageFlg>AGG</parmUsageFlg>
<isRequired>N</isRequired>
<priorityNum>1</priorityNum>
<priceItemParmVal>
<priceParmVal>USD</priceParmVal>
<priceParmVal>GBP</priceParmVal>
<priceParmVal>EUR</priceParmVal>
<priceParmVal>INR</priceParmVal>
<priceParmVal>LKR</priceParmVal>
<priceParmVal>PESO</priceParmVal>
<priceParmVal>YUAN</priceParmVal>
<priceParmVal>YEN</priceParmVal>
</priceItemParmVal>
</priceItemParm>
          <divPriceitem>
              <division>DIV001</division>
              <priceItemSqi>
                  <serviceQuantityIdentifier>OVDLMT</serviceQuantityIdentifier>
                  <sqlFragment></sqlFragment>
                  <sqiCalcAlgCd></sqiCalcAlgCd>
                  <allowIncrUpdateSw></allowIncrUpdateSw>
              </priceItemSqi>
              <divPriceItemChar>
                  <characteristicType>OVERDRTPLAN</characteristicType>
                  <effectiveDate>2019-01-01</effectiveDate>
                  <characteristicValue>LINECRD</characteristicValue>
              </divPriceItemChar>
          </divPriceitem>
          <priceItemChar>
              <characteristicType>ACCTTYPE</characteristicType>
              <effectiveDate>2019-01-01</effectiveDate>
              <characteristicValue>SAVINGS</characteristicValue>
          </priceItemChar>
          <priceItemRel>
              <priceItemChildCd></priceItemChildCd>
              <startDate></startDate>
              <endDate></endDate>
              <priceItemReTypeFlg></priceItemReTypeFlg>
              <priceItemParmGroup>
                  <priceParmCode></priceParmCode>
                  <priceParmVal></priceParmVal>
              </priceItemParmGroup>
              <priceItemRelCharacteristic>
                  <effectiveDate></effectiveDate>
                  <characteristicType></characteristicType>
                  <characteristicValue></characteristicValue>
              </priceItemRelCharacteristic>
          </priceItemRel>
</C1_PRICEITEM_BO>
<C1_PRICEITEM_BO>
    <priceItemCode>OVRDFT</priceItemCode>
    <description>Overdraft Assistance</description>
    <priceItemAvailFor>PRBL</priceItemAvailFor>
    <priceItemType></priceItemType>
    <piStatusFlag>ACTV</piStatusFlag>
    <bundleSw>N</bundleSw>
    <bundleTypeFlg></bundleTypeFlg>
    <asgnGlobalPlSw>N</asgnGlobalPlSw>
    <saType>SAVINGS</saType>
    <priceItemParm>
        <startDate>2019-01-01</startDate>
        <endDate></endDate>
        <priceParmCode>COUNTRY</priceParmCode>
        <overridePriceParmLabel></overridePriceParmLabel>
        <displayOrder>1</displayOrder>
        <parmUsageFlg>PRI</parmUsageFlg>
        <isRequired>Y</isRequired>
        <priorityNum></priorityNum>
        <priceItemParmVal>
            <priceParmVal>USA</priceParmVal>
            <priceParmVal>SWE</priceParmVal>
            <priceParmVal>CHE</priceParmVal>
            <priceParmVal>IND</priceParmVal>
            <priceParmVal>LKA</priceParmVal>
            <priceParmVal>MEX</priceParmVal>
            <priceParmVal>CHN</priceParmVal>
            <priceParmVal>JPN</priceParmVal>
        </priceItemParmVal>
    </priceItemParm>
    <priceItemParm>
        <startDate>2019-01-01</startDate>
        <endDate></endDate>
        <priceParmCode>CURRENCY</priceParmCode>
        <overridePriceParmLabel></overridePriceParmLabel>
        <displayOrder>2</displayOrder>
        <parmUsageFlg>AGG</parmUsageFlg>
        <isRequired>N</isRequired>
        <priorityNum>1</priorityNum>
        <priceItemParmVal>
            <priceParmVal>USD</priceParmVal>
            <priceParmVal>GBP</priceParmVal>
            <priceParmVal>EUR</priceParmVal>
            <priceParmVal>INR</priceParmVal>
            <priceParmVal>LKR</priceParmVal>
            <priceParmVal>PESO</priceParmVal>
            <priceParmVal>YUAN</priceParmVal>
            <priceParmVal>YEN</priceParmVal>
        </priceItemParmVal>
    </priceItemParm>
    <divPriceitem>
        <division>DIV001</division>
        <priceItemSqi>
            <serviceQuantityIdentifier>ACCTBAL</serviceQuantityIdentifier>
            <sqlFragment></sqlFragment> 
            <sqiCalcAlgCd></sqiCalcAlgCd>
            <allowIncrUpdateSw></allowIncrUpdateSw>
        </priceItemSqi>
        <priceItemSqi>
            <serviceQuantityIdentifier>AVGDBAL</serviceQuantityIdentifier> 
            <sqlFragment></sqlFragment>
            <sqiCalcAlgCd></sqiCalcAlgCd>
            <allowIncrUpdateSw></allowIncrUpdateSw> 
        </priceItemSqi>
        <divPriceItemChar>
            <characteristicType>OVERDRTPLAN</characteristicType>
            <effectiveDate>2019-01-01</effectiveDate>
            <characteristicValue>LINECRD</characteristicValue>
        </divPriceItemChar>
    </divPriceitem>
    <divPriceitem>
        <division>DIV002</division>
        <priceItemSqi>
            <serviceQuantityIdentifier>ACCTBAL</serviceQuantityIdentifier>
            <sqlFragment></sqlFragment>
            <sqiCalcAlgCd></sqiCalcAlgCd>
            <allowIncrUpdateSw></allowIncrUpdateSw>
        </priceItemSqi>
        <divPriceItemChar>
            <characteristicType>OVERDRTPLAN</characteristicType>
            <effectiveDate>2019-01-01</effectiveDate>
            <characteristicValue>LKDPTACT</characteristicValue>
        </divPriceItemChar>
    </divPriceitem>
    <priceItemChar>
        <characteristicType>ACCTTYPE</characteristicType>
        <effectiveDate>2019-01-01</effectiveDate>
        <characteristicValue>SAVINGS</characteristicValue>
    </priceItemChar>
    <priceItemRel>
        <priceItemChildCd>OVRDTRD</priceItemChildCd>
        <startDate>2019-01-01</startDate>
        <endDate></endDate>
        <priceItemReTypeFlg>SVC</priceItemReTypeFlg>
        <priceItemParmGroup>
            <priceParmCode>COUNTRY</priceParmCode>
            <priceParmVal>INDIA</priceParmVal>
        </priceItemParmGroup>
        <priceItemParmGroup>
            <priceParmCode>CURRENCY</priceParmCode>
            <priceParmVal>INR</priceParmVal>
        </priceItemParmGroup>
        <priceItemRelCharacteristic>
            <effectiveDate>2019-01-01</effectiveDate>
            <characteristicType>APPRD</characteristicType>
            <characteristicValue>Y</characteristicValue>
        </priceItemRelCharacteristic>
    </priceItemRel>
    <priceItemRel>
        <priceItemChildCd>ADDNGFEE</priceItemChildCd>
        <startDate>2019-01-01</startDate>
        <endDate></endDate>
        <priceItemReTypeFlg>SVCG</priceItemReTypeFlg>
        <priceItemParmGroup>
            <priceParmCode>COUNTRY</priceParmCode>
            <priceParmVal>INDIA</priceParmVal>
        </priceItemParmGroup>
        <priceItemParmGroup>
            <priceParmCode>CURRENCY</priceParmCode>
            <priceParmVal>INR</priceParmVal>
        </priceItemParmGroup>
        <priceItemRelCharacteristic>
            <effectiveDate>2019-01-01</effectiveDate>
            <characteristicType>APPRD</characteristicType>
            <characteristicValue>Y</characteristicValue>
        </priceItemRelCharacteristic>
    </priceItemRel>
</C1_PRICEITEM_BO>
</payload>
</request>
</root>
Related Topics
For more information on...	See...
XML File Format for Uploading Price Items	XML File Format for Uploading Price Items