CL_ORD_FST_LST_SCH

Description: |
This table stores an order's first and last scheduled date and time, along with the type of review notice for the expire items (i.e. let expire or review).

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORDER_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_ID | NUMERIC | No |
The unique ID of the order record associated with this order.
2 | DATE_FIRST_ORDEREN | DATETIME | No |
Date of the first schedule.
3 | TIME_FIRST_ORDEREN | DATETIME (Local) | No |
Time of the first schedule.
4 | DATE_LAST_ORDERENT | DATETIME | No |
Date of the last schedule.
5 | TIME_LAST_ORDERENT | DATETIME (Local) | No |
Time of the last schedule.
6 | LET_EXPIRE_TYPE_C_NAME | VARCHAR | No |
Determines the type of review notice for the former "let expire" items
May contain organization-specific values: No
Category Entries:
Let Expire
Review