WebSphere Commerce database table: POLICYTYPE
This table stores information about the type of business policy for a policy.
Column Descriptions
| Column Name
| Column Type
| Description |
| 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.
|
Indexes
| Index Name
| Indexed Column Names
| Index Type |
| SQL060903235234110
| POLICYTYPE_ID
| Primary Key
|
| Constraint Name
| Referenced Column Name
| Foreign Table Name
| Foreign Column Names
| 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
|
Related reference