Database Table: ALCHARGE

Reserved for IBM internal use.

Column Name Column Type Column Description
ALCHAMT DECIMAL (20,5)
NULL
Reserved for IBM internal use.
ALCHCALCODE CHARACTER (2)
NULL
Reserved for IBM internal use.
ALCHCUR CHARACTER (10)
NULL
Reserved for IBM internal use.
ALCHDES VARCHAR (80)
NULL
Reserved for IBM internal use.
ALCHFIELD1 VARCHAR (30)
NULL
Reserved for IBM internal use.
ALCHFIELD2 VARCHAR (30)
NULL
Reserved for IBM internal use.
ALCHFIELD3 VARCHAR (30)
NULL
Reserved for IBM internal use.
ALCHOIRFNBR INTEGER
NULL
Reserved for IBM internal use.
ALCHORRFNBR INTEGER
NULL
Reserved for IBM internal use.
ALCHPERT DECIMAL (20,5)
NULL
Reserved for IBM internal use.
ALCHRFNBR INTEGER
NOT NULL
Reserved for IBM internal use.
ALCHTYPE CHARACTER (4)
NOT NULL
Reserved for IBM internal use.
ORDERS_ID BIGINT
NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034835480 ALCHRFNBR Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_60 ORDERS_ID ORDERS ORDERS_ID Cascade

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