SCHORDERS

This table contains the entries for scheduled orders.

Column Descriptions:

NameTypeDescription
ORDERS_IDBIGINT NOT NULLScheduled order ID.
JOB_RNBIGINT NOT NULLScheduled job reference number.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
I0000227JOB_RNUnique Index
I0000761ORDERS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_739JOB_RNSCHCONFIGSCCJOBREFNUMCascade
F_740ORDERS_IDORDERSORDERS_IDCascade