Reference > Database > WebSphere Commerce database tables > P
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 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 SQL100520030407950 PAYMTHD_ID Primary Key
Referenced By 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 _vcc_freeselect_bottom_