Database Table: SCHORDERS

This table contains the entries for scheduled orders.

Column Name Column Type Column Description
JOB_RN BIGINT
NOT NULL
Scheduled job reference number.
ORDERS_ID BIGINT
NOT NULL
Scheduled order ID.
Indexes:
Index Name Indexed Column Names Index Type
I0000227 JOB_RN Unique Index
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_739 JOB_RN SCHCONFIG SCCJOBREFNUM Cascade
F_740 ORDERS_ID ORDERS ORDERS_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable