FRC SELECTION Table
View exposing records selected for Financial Review and Control review based on control, monitoring, or risk criteria.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COMPANY_CODE |
Code identifying company. |
VARCHAR2 |
4 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
DOCUMENT_LINE_ITEM |
Document line item associated with the record. |
NUMBER |
|
DOCUMENT_NUMBER |
Document number associated with the record. |
VARCHAR2 |
10 |
DOCUMENT_TYPE_ID |
Business identifier for the document type. |
VARCHAR2 |
3 |
FINANCIAL_DETAIL_KEY |
Surrogate key identifying the financial detail. |
VARCHAR2 |
17 |
FRC_SELECTION_REASON |
Frc selection reason associated with the record. |
VARCHAR2 |
50 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
IS_BLANKET_PO |
Indicator identifying whether blanket po (Y/N). |
VARCHAR2 |
1 |
IS_DOC_TYPE_SA |
Indicator identifying whether doc type sa (Y/N). |
VARCHAR2 |
1 |
IS_DOC_TYPE_SI |
Indicator identifying whether doc type si (Y/N). |
VARCHAR2 |
1 |
IS_EQUIPMENT |
Indicator identifying whether equipment (Y/N). |
VARCHAR2 |
1 |
IS_FABRICATED_EQUIPMENT |
Indicator identifying whether fabricated equipment (Y/N). |
VARCHAR2 |
1 |
IS_OVER_LIMIT |
Indicator identifying whether over limit (Y/N). |
VARCHAR2 |
1 |
IS_REMAINING_PERCENT |
Indicator identifying whether remaining percent (Y/N). |
VARCHAR2 |
1 |
IS_SELECTED_FOR_FRC_REVIEW |
Indicator identifying whether selected for frc review (Y/N). |
VARCHAR2 |
1 |
IS_UNALLOWABLE |
Indicator identifying whether unallowable (Y/N). |
VARCHAR2 |
1 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |