WebSphere Commerce database table: PAYMTHD

WebSphere Commerce database table: PAYMTHD

This table is a site-wide table that lists all the Cashier profiles used in the store group. Each profile has a unique integer ID and a name. This table is deprecated and is provided for backward compatibility only.
Column Descriptions
Column Name Column Type Description
PAYMTHD_ID INTEGER NOT NULL The unique integer ID of the profile.
PROFILENAME VARCHAR(64) NOT NULL The name of the profile. It must be the same as the simple filename, without the suffix .profile, of the XML file that contains the cashier profile. (Note that the name is case-sensitive and must include the name of the Cassette as a substring.)
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000186 PROFILENAME Unique Index
SQL060903235226360 PAYMTHD_ID Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_575 PAYMTHD_ID PAYMTHDDSC PAYMTHD_ID Cascade
F_576 PAYMTHD_ID PAYMTHDSUP PAYMTHD_ID Cascade

Column Name	Column Type	Description
PAYMTHD_ID	INTEGER NOT NULL	The unique integer ID of the profile.
PROFILENAME	VARCHAR(64) NOT NULL	The name of the profile. It must be the same as the simple filename, without the suffix .profile, of the XML file that contains the cashier profile. (Note that the name is case-sensitive and must include the name of the Cassette as a substring.)
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Index Name	Indexed Column Names	Index Type
I0000186	PROFILENAME	Unique Index
SQL060903235226360	PAYMTHD_ID	Primary Key

Constraint Name	Referenced Column Name	Foreign Table Name	Foreign Column Names	Constraint Type
F_575	PAYMTHD_ID	PAYMTHDDSC	PAYMTHD_ID	Cascade
F_576	PAYMTHD_ID	PAYMTHDSUP	PAYMTHD_ID	Cascade