FRC LINE DETAIL Table
View exposing detailed financial line records subject to Financial Review and Control review, monitoring, and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CGCOMMENT |
Cgcomment associated with the record. |
VARCHAR2 |
2050 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
DAY_COUNT |
Day count associated with the record. |
NUMBER |
|
DOCUMENT_LINE_ITEM |
Document line item associated with the record. |
NUMBER |
|
DOCUMENT_NUMBER |
Document number associated with the record. |
VARCHAR2 |
10 |
FINANCIAL_DETAIL_KEY |
Surrogate key identifying the financial detail. |
VARCHAR2 |
261 |
FRC_SELECTION_REASON |
Frc selection reason associated with the record. |
VARCHAR2 |
50 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
IS_SELECTED_FOR_REVIEW |
Indicator identifying whether selected for review (Y/N). |
VARCHAR2 |
1 |
REASON_CODE |
Code identifying reason. |
VARCHAR2 |
100 |
REASON_DESC |
Description of reason. |
VARCHAR2 |
100 |
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 |
17 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |