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 |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035038000 | POLICYTYPE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
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 |