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:

NameTypeDescription
ORDERS_IDBIGINT NOT NULLThe Order.
ORDPAYINFO_IDBIGINT NOT NULLGenerated unique key.
NAMECHAR (64) NOT NULLThe name-value pair name.
VALUEVARCHAR (512) NOT NULLThe name-value pair value. If the first character of the value is a space, then the value has been encrypted.
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>ORDPAYINFO_IDPrimary Key
I0000179ORDERS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_534ORDERS_IDORDERSORDERS_IDCascade