Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: ALCHARGE
Reserved for IBM internal use.
Column Name Column Type Description ALCHRFNBR INTEGER NOT NULL Reserved for IBM internal use. ALCHORRFNBR INTEGER Reserved for IBM internal use. ALCHOIRFNBR INTEGER Reserved for IBM internal use. ALCHTYPE CHAR(4) NOT NULL Reserved for IBM internal use. ALCHAMT DECIMAL (20,5) Reserved for IBM internal use. ALCHCUR CHAR(10) Reserved for IBM internal use. ALCHPERT DECIMAL (20,5) Reserved for IBM internal use. ALCHCALCODE CHAR(2) Reserved for IBM internal use. ALCHDES VARCHAR(80) Reserved for IBM internal use. ALCHFIELD1 VARCHAR(30) Reserved for IBM internal use. ALCHFIELD2 VARCHAR(30) Reserved for IBM internal use. ALCHFIELD3 VARCHAR(30) Reserved for IBM internal use. ORDERS_ID BIGINT Reserved for IBM internal use. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030256260 ALCHRFNBR Primary Key I0000450 ORDERS_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_60 ORDERS_ID ORDERS ORDERS_ID Cascade _vcc_freeselect_bottom_