WebSphere Commerce database table: ALCHARGE

Reserved for IBM internal use.

Column Descriptions

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
SQL060903235122920	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