ORDPAYINFO

Each row in this table holds a name-value pair representing payment information for a particular Order. Values added to this table are encrypted when the "Instance/PDIEncrypt" configuration flag is "on".

Column Descriptions:

Name	Type	Description
ORDERS_ID	BIGINT NOT NULL	The Order.
ORDPAYINFO_ID	BIGINT NOT NULL	Generated unique key.
NAME	CHAR (64) NOT NULL	The name-value pair name.
VALUE	VARCHAR (512) NOT NULL	The name-value pair value. If the first character of the value is a space, then the value has been encrypted.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	ORDPAYINFO_ID	Primary Key
I0000179	ORDERS_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_534	ORDERS_ID	ORDERS	ORDERS_ID	Cascade

Related reference
Order data model