Reserved for IBM internal use.
Column Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031156660 |
ALCHRFNBR |
Primary Key |
I0000450 |
ORDERS_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_60 |
ORDERS_ID |
ORDERS |
ORDERS_ID |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.