Siebel Database Upgrade Guide for DB2 UDB for z/OS > Preparing Siebel Application Data for Upgrade >

Setting the Value of the TYPE_CD Column

Upgrades: Releases 6.x, 7.0.x.

Environments: All environments.

At Siebel 7.5, S_SRC_PAYMENT.TYPE_CD became a required (NOT NULL) column. If TYPE_CD is null, the value is set to Payment during the upgrade.

Payment indicates that this is a payment from your organization to an external organization. For example, this might denote a payment of marketing funds to your customer.

Before the upgrade, review records where TYPE_CD is null. For those where you do not want the upgrade to set the value of TYPE_CD to Payment, set the value of TYPE_CD.

To set the value of TYPE_CD

1. In S_SRC_PAYMENT, query for records where TYPE_CD is null.
2. For the desired records, use Siebel EIM to set a value for TYPE_CD.

   Use the values in the field's LOV.