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 Description(s):
Column NameColumn TypeDescription
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(es):
Index NameIndexed Column NamesIndex Type
I0000186 PROFILENAME Unique Index
SQL050212031253600 PAYMTHD_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_575 PAYMTHD_ID PAYMTHDDSC PAYMTHD_ID Cascade
F_576 PAYMTHD_ID PAYMTHDSUP PAYMTHD_ID Cascade

Feedback