Database Table: PAYMTHDSUP

This table lists all the profiles supported by the Store or StoreGroup. This table is deprecated and is provided for backward compatibility only.

Column Name Column Type Column Description
FIELD1 VARCHAR (254)
NULL
Customizable.
PAYMTHD_ID INTEGER
NOT NULL
The unique integer ID of the Cashier profile. Foreign key that references the PAYMTHD_ID column of the PAYMTHD table.
STOREENT_ID INTEGER
NOT NULL
The Store Entity ID of the Store or StoreGroup. Foreign key that references the STOREENT_ID column of the STOREENT table.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035029930 PAYMTHD_ID, STOREENT_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_576 PAYMTHD_ID PAYMTHD PAYMTHD_ID Cascade
F_577 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable