Reserved for IBM internal use.
Column Descriptions:
| Name | 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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | ALCHRFNBR | Primary Key |
| I0000450 | ORDERS_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_60 | ORDERS_ID | ORDERS | ORDERS_ID | Cascade |