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 financal 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
| Column Name
| Column Type
| Description |
| PPCEXTDATA_ID
| BIGINT NOT NULL
| The generated identifier for this extended data
|
| PPCPAYINST_ID
| BIGINT
| The identifier of the payment instruction in WebSphere Commerce Payments 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 WebSphere Commerce Payments 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
| Reserved for IBM internal use.
|
| ATTRIBUTENAME
| VARCHAR(64) NOT NULL
| The name used by the plug-in or WebSphere Commerce to indentify 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.
|