Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PPCBATCH
The batch object representing the batch transaction
Column Name Column 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 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030412040 PPCBATCH_ID Primary Key I0001107 MERCHCONF_ID Non-Unique Index I0001108 STATE Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3477 MERCHCONF_ID MERCHCONF MERCHCONF_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type R_3479 PPCBATCH_ID PPCEXTDATA PPCBATCH_ID Cascade F_3478 PPCBATCH_ID PPCPAYTRAN PPCBATCH_ID Cascade _vcc_freeselect_bottom_