FINANCIAL DETAIL FRC Table
View exposing financial transaction detail records associated with financial reporting categories and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTUAL_AMOUNT |
Actual amount associated with the record. |
NUMBER |
13,2 |
ACTUAL_AMOUNT_LC |
Actual amount lc associated with the record. |
NUMBER |
13,2 |
ALLOCATION_NUMBER |
Allocation number associated with the record. |
VARCHAR2 |
25 |
ALTERNATIVE_ACCOUNT_NUMBER |
Alternative account number associated with the record. |
VARCHAR2 |
10 |
BLOCKED_PAYMENT_TEXT |
Blocked payment text associated with the record. |
VARCHAR2 |
20 |
CHECK_ENCASHMENT_DATE |
Date associated with check encashment. |
DATE |
|
CHECK_NUMBER |
Check number associated with the record. |
VARCHAR2 |
13 |
CLEARING_DATE |
Date associated with clearing. |
DATE |
|
CLEARING_DOCUMENT_NUMBER |
Clearing document number associated with the record. |
VARCHAR2 |
10 |
CLEARING_ENTRY_DATE |
Date associated with clearing entry. |
DATE |
|
COMMITMENT_ITEM |
Commitment item associated with the record. |
VARCHAR2 |
14 |
COMPANY_CODE |
Code identifying company. |
VARCHAR2 |
4 |
COST_COLLECTOR_FY_KEY |
Surrogate key identifying the cost collector fy. |
VARCHAR2 |
12 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
COUPA_NUMBER |
Coupa number associated with the record. |
VARCHAR2 |
35 |
CUSTOMER_KEY |
Surrogate key identifying the customer. |
VARCHAR2 |
11 |
DEBIT_CREDIT_INDICATOR |
Debit credit indicator associated with the record. |
VARCHAR2 |
1 |
DELIVERY_COMPLETE_INDICATOR |
Delivery complete indicator associated with the record. |
VARCHAR2 |
1 |
DOCUMENT_CURRENCY |
Document currency associated with the record. |
VARCHAR2 |
5 |
DOCUMENT_DATE |
Date associated with document. |
DATE |
|
DOCUMENT_ENTRY_DATE |
Date associated with document entry. |
DATE |
|
DOCUMENT_LAST_CHANGE_DATE |
Date associated with document last change. |
DATE |
|
DOCUMENT_LINE_DATE |
Date associated with document line. |
DATE |
|
DOCUMENT_LINE_ITEM |
Document line item associated with the record. |
NUMBER |
|
DOCUMENT_NUMBER |
Document number associated with the record. |
VARCHAR2 |
10 |
DOCUMENT_TYPE_KEY |
Surrogate key identifying the document type. |
VARCHAR2 |
3 |
DUNNING_AREA_KEY |
Surrogate key identifying the dunning area. |
VARCHAR2 |
7 |
FINANCIAL_DETAIL_KEY |
Surrogate key identifying the financial detail. |
VARCHAR2 |
17 |
FUND_CENTER_KEY |
Surrogate key identifying the fund center. |
VARCHAR2 |
16 |
FUND_KEY |
Surrogate key identifying the fund. |
VARCHAR2 |
10 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
HOUSE_BANK |
House bank associated with the record. |
VARCHAR2 |
5 |
INTERCOMPANY_TRANSACTION_ID |
Business identifier for the intercompany transaction. |
VARCHAR2 |
16 |
LINE_ITEM_TEXT |
Line item text associated with the record. |
VARCHAR2 |
100 |
LOCAL_CURRENCY |
Local currency associated with the record. |
VARCHAR2 |
5 |
MANUAL_BLOCKING_INDICATOR |
Manual blocking indicator associated with the record. |
VARCHAR2 |
1 |
MATERIAL_GROUP_CODE |
Code identifying material group. |
VARCHAR2 |
9 |
MORE_CHECKS_FLAG |
More checks flag associated with the record. |
VARCHAR2 |
1 |
OFFSET_COST_COLLECTOR_KEY |
Surrogate key identifying the offset cost collector. |
VARCHAR2 |
12 |
ORIGINAL_PROCEDURE_CODE |
Code identifying original procedure. |
VARCHAR2 |
5 |
PARKED_BY_USER_NAME |
Parked by user name associated with the record. |
VARCHAR2 |
12 |
POSTING_DATE |
Date associated with posting. |
DATE |
|
POSTING_KEY |
Surrogate key identifying the posting. |
VARCHAR2 |
3 |
POSTING_KEY_CODE |
Code identifying posting key. |
VARCHAR2 |
2 |
PO_LINE_ITEM_TEXT |
Po line item text associated with the record. |
VARCHAR2 |
100 |
PO_QUANTITY |
Po quantity associated with the record. |
NUMBER |
|
PO_UNIT_OF_MEASURE |
Po unit of measure associated with the record. |
VARCHAR2 |
5 |
PROBABLE_PAYMENT_DATE |
Date associated with probable payment. |
DATE |
|
PURCHASE_ORDER_ACCT_ASSIGNMENT |
Purchase order acct assignment associated with the record. |
NUMBER |
|
PURCHASE_ORDER_ITEM |
Purchase order item associated with the record. |
NUMBER |
|
PURCHASE_ORDER_NUMBER |
Purchase order number associated with the record. |
VARCHAR2 |
10 |
REFERENCE_DOCUMENT_NUMBER |
Reference document number associated with the record. |
VARCHAR2 |
30 |
REFERENCE_TEXT |
Reference text associated with the record. |
VARCHAR2 |
50 |
REVERSE_DOCUMENT_NUMBER |
Reverse document number associated with the record. |
VARCHAR2 |
10 |
REVERSE_DOCUMENT_YEAR |
Reverse document year associated with the record. |
VARCHAR2 |
4 |
SPECIAL_GL_INDICATOR |
Special gl indicator associated with the record. |
VARCHAR2 |
1 |
SPECIAL_GL_TRANS_TYPE |
Special gl trans type associated with the record. |
VARCHAR2 |
1 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
TRANSACTION_CODE |
Code identifying transaction. |
VARCHAR2 |
20 |
TRANSACTION_COUNTER |
Transaction counter associated with the record. |
NUMBER |
|
USER_NAME |
User name associated with the record. |
VARCHAR2 |
12 |
VENDOR_KEY |
Surrogate key identifying the vendor. |
VARCHAR2 |
11 |
VENDOR_NAME |
Vendor name associated with the record. |
VARCHAR2 |
144 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |