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 |