Database Table: POLICYTYPE

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

Column Name Column Type Column Description
POLICYTYPE_ID CHARACTER (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
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035038000 POLICYTYPE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

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