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.
OPTCOUNTERSMALLINTThe 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