The batch object representing the batch
transaction
Column Descriptions:
| Name | Type | Description |
| PPCBATCH_ID | BIGINT NOT NULL | Batch identifier |
| MERCHCONF_ID | BIGINT NOT NULL | The merchant configuration ID, which is the
foreign key referring to MERCHCONF. |
| STATE | SMALLINT NOT NULL DEFAULT 0 | The current state of the batch.
- 0
- New
- 1
- Sent
- 2
- Partial closed
- 3
- Closed
|
| TIMECREATED | TIMESTAMP NOT NULL | The time when the batch is created with OPEN
state. |
| TIMEUPDATED | TIMESTAMP NOT NULL | The timestamp of when the batch was last
updated. |
| TIMECLOSED | TIMESTAMP | The timestamp of when the batch was closed. |
| 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
|
| FIELD1 | INTEGER | Customizable. |
| FIELD2 | VARCHAR (254) | Customizable. |
| FIELD3 | VARCHAR (254) | Customizable. |
| 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> | PPCBATCH_ID | Primary Key |
| I0001107 | MERCHCONF_ID | Non-Unique Index |
| I0001108 | STATE | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3477 | MERCHCONF_ID | MERCHCONF | MERCHCONF_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_3478 | PPCBATCH_ID | PPCPAYTRAN | PPCBATCH_ID | Cascade |
| R_3479 | PPCBATCH_ID | PPCEXTDATA | PPCBATCH_ID | Cascade |