POLICYTYPE

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

Column Descriptions:

NameTypeDescription
POLICYTYPE_IDCHAR (64) NOT NULLThe policy type. This is a primary key. Possible values are as follows: Price ProductSet ShippingMode ShippingCharge Payment ReturnCharge ReturnApproval ReturnPayment InvoiceFormat ReferralInterface
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>POLICYTYPE_IDPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_605POLICYTYPE_IDPLCYTYCMIFPOLICYTYPE_IDCascade
F_607POLICYTYPE_IDPLCYTYPDSCPOLICYTYPE_IDCascade
F_609POLICYTYPE_IDPOLICYPOLICYTYPE_IDCascade