WebSphere Commerce database table: ALCHARGE

Reserved for IBM internal use.


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031156660 ALCHRFNBR Primary Key
I0000450 ORDERS_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_60 ORDERS_ID ORDERS ORDERS_ID Cascade

Feedback