ALCHARGE

Reserved for IBM internal use.

Column Descriptions:

NameTypeDescription
ALCHRFNBRINTEGER NOT NULLReserved for IBM internal use.
ALCHORRFNBRINTEGERReserved for IBM internal use.
ALCHOIRFNBRINTEGERReserved for IBM internal use.
ALCHTYPECHAR (4) NOT NULLReserved for IBM internal use.
ALCHAMTDECIMAL (20,5)Reserved for IBM internal use.
ALCHCURCHAR (10)Reserved for IBM internal use.
ALCHPERTDECIMAL (20,5)Reserved for IBM internal use.
ALCHCALCODECHAR (2)Reserved for IBM internal use.
ALCHDESVARCHAR (80)Reserved for IBM internal use.
ALCHFIELD1VARCHAR (30)Reserved for IBM internal use.
ALCHFIELD2VARCHAR (30)Reserved for IBM internal use.
ALCHFIELD3VARCHAR (30)Reserved for IBM internal use.
ORDERS_IDBIGINTReserved for IBM internal use.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ALCHRFNBRPrimary Key
I0000450ORDERS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_60ORDERS_IDORDERSORDERS_IDCascade