FRC REVIEWS Table
View exposing Financial Review and Control review records including review assignments, status, and related control workflow attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CGCOMMENT |
Cgcomment associated with the record. |
VARCHAR2 |
4000 |
COST_COLLECTOR_ID |
Business identifier for the cost collector. |
VARCHAR2 |
25 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
DOCUMENT_LINE_ITEM |
Document line item associated with the record. |
VARCHAR2 |
50 |
DOCUMENT_NUMBER |
Document number associated with the record. |
VARCHAR2 |
50 |
FINANCIAL_DETAIL_KEY |
Surrogate key identifying the financial detail. |
VARCHAR2 |
20 |
GL_ACCOUNT_ID |
Business identifier for the gl account. |
VARCHAR2 |
25 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
REASON |
Reason associated with the record. |
VARCHAR2 |
50 |
REASON_CODE |
Code identifying reason. |
VARCHAR2 |
100 |
REPORT_ID |
Business identifier for the report. |
VARCHAR2 |
128 |
REPORT_NAME |
Report name associated with the record. |
VARCHAR2 |
255 |
REVIEWED_BY |
Reviewed by associated with the record. |
VARCHAR2 |
255 |
REVIEW_DATE |
Date associated with review. |
DATE |
|
RE_ID |
Business identifier for the re. |
VARCHAR2 |
255 |
STATUS |
Status associated with the record. |
VARCHAR2 |
25 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |