PPCEXTDATA

This table stores the non-standard protocol data required in the financial transaction which goes beyond the standard attributes defined in the payment instruction. It can be associated with a payment instruction or a financial transaction. When associated with a payment instruction, it can be used by all the financial transactions executed against the same payment instruction. When associated with a financial transaction, this extra data can be used by this same transaction and subsequent transactions.

Column Descriptions:

Name	Type	Description
PPCEXTDATA_ID	BIGINT NOT NULL	The generated identifier for this extended data
PPCPAYINST_ID	BIGINT	The identifier of the payment instruction in the payments subsystem to which this extended data is associated. Null when this extended data is associated to a financial transaction. This column contains the CMR relationship with PPCPAYINST
PPCPAYTRAN_ID	BIGINT	The identifier of the financial transaction in the payments subsystem to which this extended data is associated. Null when this extended data is associated to a payment instruction. This column contains the CMR relationship with PPCPAYTRAN
ATTRIBUTETYPE	SMALLINT NOT NULL	The type of the attribute value. 0: TYPE_BOOLEAN 1: TYPE_INTEGER 2: TYPE_LONG 3: TYPE_BIG_DECIMAL 4: TYPE_STRING
ENCRYPTED	SMALLINT NOT NULL	The flag indicates whether the value is encrypted or not using the merchant key.
MARKFORDELETE	INTEGER NOT NULL DEFAULT 0	The flag indicates whether this object has been marked for deletion. 0: not marked for deletion 1: marked for deletion
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.
ATTRIBUTENAME	VARCHAR (64) NOT NULL	The name used by the plug-in or WebSphere Commerce to identify this extended data.
SEARCHVALUE	VARCHAR (64)	The searchable part of the value of this extended data. If this attribute is not searchable, NULL will be set to this column.
DATAVALUE	VARCHAR (4000)	The value of this extended data.
PPCBATCH_ID	BIGINT	The batch ID of this extended data referring to, and if it is not an extended data for a batch, then this column is null. This column is the foreign key referring to PPCBATCH.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	PPCEXTDATA_ID	Primary Key
I0000926	PPCPAYINST_ID	Non-Unique Index
I0000927	PPCPAYTRAN_ID	Non-Unique Index
I0000962	SEARCHVALUE	Non-Unique Index
I0001106	PPCBATCH_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_1174	PPCPAYINST_ID	PPCPAYINST	PPCPAYINST_ID	Cascade
F_1175	PPCPAYTRAN_ID	PPCPAYTRAN	PPCPAYTRAN_ID	Cascade
R_3479	PPCBATCH_ID	PPCBATCH	PPCBATCH_ID	Cascade