WebSphere Commerce database table: POLICYTYPE

This table stores information about the type of business policy for a policy.


Column Description(s):
Column NameColumn TypeDescription
POLICYTYPE_ID CHAR(64) NOT NULL The policy type. This is a primary key. Possible values are as follows:
Price
ProductSet
ShippingMode
ShippingCharge
Payment
ReturnCharge
ReturnApproval
ReturnPayment
InvoiceFormat
ReferralInterface
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031257030 POLICYTYPE_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_605 POLICYTYPE_ID PLCYTYCMIF POLICYTYPE_ID Cascade
F_607 POLICYTYPE_ID PLCYTYPDSC POLICYTYPE_ID Cascade
F_609 POLICYTYPE_ID POLICY POLICYTYPE_ID Cascade

Feedback