Reference > Database > WebSphere Commerce database tables > P

WebSphere Commerce database table: POLICYTYPE

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

Column Name	Column Type	Description
POLICYTYPE_ID	CHAR(64) NOT NULL	The policy type. This is a primary key. Possible values are... 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
SQL100520030411890	POLICYTYPE_ID	Primary Key

Referenced By

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

• Contract data model

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search