ORDER_REVIEW
Description:
This table contains a list of all the users that have reviewed the order and whether that review was accepted or not.

Primary Key
Column Name Ordinal Position
ORDER_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ORDER_ID NUMERIC No
The unique identifier for the order record.
2 LINE INTEGER No
The line count for this table is determined by the number of users who reviewed this order.
3 REVIEW_USER_ID VARCHAR No
The user that reviewed the order.
4 REVIEW_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
5 REVIEWED_TIME DATETIME (UTC) No
The date and time when the order was reviewed.
6 REVIEW_ACCEPTED_YN VARCHAR No
This column contains Y/N to determine if the reviewer accepted the order.
May contain organization-specific values: No
Category Entries:
Yes
No