FRC COGNOS Table
View exposing reporting and integration attributes used in Financial Review and Control processes and related Cognos reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTUAL_AMOUNT |
Actual amount associated with the record. |
NUMBER |
13,2 |
CALENDAR_PERIOD_DESCRIPTION |
Description of calendar period. |
VARCHAR2 |
30 |
COST_COLLECTOR_ID |
Business identifier for the cost collector. |
VARCHAR2 |
7 |
COST_COLLECTOR_NAME |
Cost collector name associated with the record. |
VARCHAR2 |
40 |
COST_OBJECT_ID_NAME |
Cost object id name associated with the record. |
VARCHAR2 |
50 |
COUPA_NUMBER |
Coupa number associated with the record. |
VARCHAR2 |
35 |
DOCUMENT_DATE |
Date associated with document. |
DATE |
|
DOCUMENT_LINE_ITEM |
Document line item associated with the record. |
NUMBER |
|
DOCUMENT_NUMBER |
Document number associated with the record. |
VARCHAR2 |
10 |
DOCUMENT_TYPE_DESC |
Description of document type. |
VARCHAR2 |
26 |
DOCUMENT_TYPE_DESCRIPTION |
Description of document type. |
VARCHAR2 |
20 |
DOCUMENT_TYPE_ID |
Business identifier for the document type. |
VARCHAR2 |
3 |
FINANCIAL_DETAIL_KEY |
Surrogate key identifying the financial detail. |
VARCHAR2 |
17 |
FISCAL_PERIOD |
Fiscal period associated with the record. |
VARCHAR2 |
6 |
GL_ACCOUNT_ID |
Business identifier for the gl account. |
VARCHAR2 |
6 |
GL_ACCOUNT_ID_NAME |
Gl account id name associated with the record. |
VARCHAR2 |
59 |
GL_ACCOUNT_NAME |
Gl account name associated with the record. |
VARCHAR2 |
50 |
GL_CATEGORY |
Gl category associated with the record. |
VARCHAR2 |
40 |
GL_CATEGORY_SORT |
Gl category sort associated with the record. |
NUMBER |
6 |
HIGH_RISK |
High risk associated with the record. |
VARCHAR2 |
1 |
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_OVER_LIMIT |
Indicator identifying whether over limit (Y/N). |
VARCHAR2 |
1 |
IS_SELECTED_FOR_FRC_REVIEW |
Indicator identifying whether selected for frc review (Y/N). |
VARCHAR2 |
1 |
IS_UNALLOWABLE_GL_POSTING |
Indicator identifying whether unallowable gl posting (Y/N). |
VARCHAR2 |
1 |
LINE_ITEM_DISPLAY_TEXT |
Line item display text associated with the record. |
VARCHAR2 |
120 |
PROFIT_CENTER_ID |
Business identifier for the profit center. |
VARCHAR2 |
7 |
PURCHASE_ORDER_NUMBER |
Purchase order number associated with the record. |
VARCHAR2 |
10 |
REFERENCE |
Reference associated with the record. |
VARCHAR2 |
30 |
REVIEW_ITEM |
Review item associated with the record. |
CHAR |
|
STATUS |
Status associated with the record. |
VARCHAR2 |
25 |
SUPERVISOR |
Supervisor associated with the record. |
VARCHAR2 |
30 |
SUPERVISOR_MIT_ID |
Business identifier for the supervisor mit. |
VARCHAR2 |
9 |
TOTAL_ACTUAL_AMOUNT |
Total actual amount associated with the record. |
NUMBER |
13,2 |
TRANSACTION_DETAIL |
Transaction detail associated with the record. |
VARCHAR2 |
144 |
TRANSACTION_TYPE |
Transaction type associated with the record. |
VARCHAR2 |
7 |
TRANSACTION_TYPE_DESC |
Description of transaction type. |
VARCHAR2 |
50 |
USE_FRC_ROLE_FLAG |
Use frc role flag associated with the record. |
VARCHAR2 |
1 |