PPCBATCH

The batch object representing the batch transaction

Column Descriptions:

NameTypeDescription
PPCBATCH_IDBIGINT NOT NULLBatch identifier
MERCHCONF_IDBIGINT NOT NULLThe merchant configuration ID, which is the foreign key referring to MERCHCONF.
STATESMALLINT NOT NULL DEFAULT 0The current state of the batch.
0
New
1
Sent
2
Partial closed
3
Closed
TIMECREATEDTIMESTAMP NOT NULLThe time when the batch is created with OPEN state.
TIMEUPDATEDTIMESTAMP NOT NULLThe timestamp of when the batch was last updated.
TIMECLOSEDTIMESTAMPThe timestamp of when the batch was closed.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0The flag indicates whether this object has been marked for deletion.
0
Not marked for deletion
1
Marked for deletion
FIELD1INTEGERCustomizable.
FIELD2VARCHAR (254)Customizable.
FIELD3VARCHAR (254)Customizable.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PPCBATCH_IDPrimary Key
I0001107MERCHCONF_IDNon-Unique Index
I0001108STATENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3477MERCHCONF_IDMERCHCONFMERCHCONF_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3478PPCBATCH_IDPPCPAYTRANPPCBATCH_IDCascade
R_3479PPCBATCH_IDPPCEXTDATAPPCBATCH_IDCascade