FINANCIAL DETAIL Table
View exposing detailed general ledger line-item transactions by cost collector, general ledger account, document, and fiscal period, including posting dates, transaction amounts, purchasing references, clearing activity, and financial control attributes used for financial reporting and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTUAL_AMOUNT |
Transaction amount recorded in the document currency. |
NUMBER |
13,2 |
ACTUAL_AMOUNT_LC |
Transaction amount converted to the local currency. |
NUMBER |
13,2 |
ALLOCATION_NUMBER |
Allocation number associated with the financial transaction. |
VARCHAR2 |
25 |
ALTERNATIVE_ACCOUNT_NUMBER |
Alternative account number used for financial reporting. |
VARCHAR2 |
10 |
BLOCKED_PAYMENT_TEXT |
Description of the reason for payment blocking. |
VARCHAR2 |
20 |
CHECK_ENCASHMENT_DATE |
Date the associated check was cashed. |
DATE |
|
CHECK_NUMBER |
Check number associated with the payment transaction. |
VARCHAR2 |
13 |
CLEARING_DATE |
Date the transaction was cleared through a clearing document. |
DATE |
|
CLEARING_DOCUMENT_NUMBER |
Identifier of the document used to clear the transaction. |
VARCHAR2 |
10 |
CLEARING_ENTRY_DATE |
Date the clearing document was entered into the system. |
DATE |
|
COMMITMENT_ITEM |
Commitment item classification associated with the transaction. |
VARCHAR2 |
14 |
COMPANY_CODE |
Financial company code under which the transaction was posted. |
VARCHAR2 |
4 |
COST_COLLECTOR_FY_KEY |
Identifier representing the cost collector aggregated at the fiscal year level. |
VARCHAR2 |
12 |
COST_COLLECTOR_KEY |
Surrogate identifier of the cost collector associated with the transaction. |
VARCHAR2 |
12 |
CUSTOMER_KEY |
Identifier of the customer associated with the transaction when applicable. |
VARCHAR2 |
11 |
DEBIT_CREDIT_INDICATOR |
Indicator identifying whether the transaction represents a debit or credit posting. |
VARCHAR2 |
1 |
DELIVERY_COMPLETE_INDICATOR |
Indicator identifying whether delivery associated with the transaction is complete. |
VARCHAR2 |
1 |
DOCUMENT_CURRENCY |
Currency code of the financial document. |
VARCHAR2 |
5 |
DOCUMENT_DATE |
Date the financial document was created in the source system. |
DATE |
|
DOCUMENT_ENTRY_DATE |
Date the document was entered into the source system. |
DATE |
|
DOCUMENT_LAST_CHANGE_DATE |
Date the document was last modified in the source system. |
DATE |
|
DOCUMENT_LINE_DATE |
Date associated with the individual document line item. |
DATE |
|
DOCUMENT_LINE_ITEM |
Line item number within the financial document. |
NUMBER |
3 |
DOCUMENT_NUMBER |
Identifier of the financial document containing the transaction line item. |
VARCHAR2 |
10 |
DOCUMENT_TYPE_KEY |
Identifier of the financial document type associated with the transaction. |
VARCHAR2 |
3 |
DUNNING_AREA_KEY |
Identifier of the dunning area associated with the transaction. |
VARCHAR2 |
7 |
FINANCIAL_DETAIL_KEY |
Surrogate identifier uniquely identifying the financial transaction record. |
VARCHAR2 |
17 |
FUND_CENTER_KEY |
Identifier of the fund center associated with the transaction. |
VARCHAR2 |
16 |
FUND_KEY |
Identifier of the fund associated with the transaction. |
VARCHAR2 |
10 |
GL_ACCOUNT_KEY |
Surrogate identifier of the general ledger account associated with the transaction. |
VARCHAR2 |
10 |
HOUSE_BANK |
Identifier of the house bank associated with the payment transaction. |
VARCHAR2 |
5 |
INTERCOMPANY_TRANSACTION_ID |
Identifier used to link related intercompany transactions. |
VARCHAR2 |
16 |
LINE_ITEM_TEXT |
Descriptive text associated with the document line item. |
VARCHAR2 |
100 |
LOCAL_CURRENCY |
Local currency code used for financial reporting. |
VARCHAR2 |
5 |
MANUAL_BLOCKING_INDICATOR |
Indicator identifying whether the transaction was manually blocked for payment. |
VARCHAR2 |
1 |
MATERIAL_GROUP_CODE |
Code identifying the material group classification. |
VARCHAR2 |
9 |
MORE_CHECKS_FLAG |
Indicator identifying whether additional checks are associated with the transaction. |
VARCHAR2 |
1 |
OFFSET_COST_COLLECTOR_KEY |
Identifier of the offsetting cost collector associated with the transaction. |
VARCHAR2 |
12 |
ORIGINAL_PROCEDURE_CODE |
Code identifying the original system procedure used to create the transaction. |
VARCHAR2 |
5 |
PARKED_BY_USER_NAME |
Identifier of the user who parked the document prior to posting. |
VARCHAR2 |
12 |
POSTING_DATE |
Date the transaction was posted to the general ledger. |
DATE |
|
POSTING_KEY |
Posting key associated with the transaction line item. |
VARCHAR2 |
3 |
POSTING_KEY_CODE |
Code identifying the posting key classification. |
VARCHAR2 |
2 |
PO_LINE_ITEM_TEXT |
Descriptive text associated with the purchase order line item. |
VARCHAR2 |
100 |
PO_QUANTITY |
Quantity associated with the purchase order line item. |
NUMBER |
|
PO_UNIT_OF_MEASURE |
Unit of measure associated with the purchase order quantity. |
VARCHAR2 |
5 |
PROBABLE_PAYMENT_DATE |
Expected payment date associated with the transaction. |
DATE |
|
PURCHASE_ORDER_ACCT_ASSIGNMENT |
Account assignment number associated with the purchase order line item. |
NUMBER |
2 |
PURCHASE_ORDER_ITEM |
Line item number within the purchase order. |
NUMBER |
5 |
PURCHASE_ORDER_NUMBER |
Purchase order number associated with the transaction when applicable. |
VARCHAR2 |
10 |
REFERENCE_DOCUMENT_NUMBER |
Identifier of a related reference document. |
VARCHAR2 |
30 |
REFERENCE_TEXT |
Reference text associated with the financial document. |
VARCHAR2 |
50 |
REVERSE_DOCUMENT_NUMBER |
Identifier of the reversing document when the transaction has been reversed. |
VARCHAR2 |
10 |
REVERSE_DOCUMENT_YEAR |
Fiscal year associated with the reversing document. |
VARCHAR2 |
4 |
SPECIAL_GL_INDICATOR |
Indicator identifying special general ledger transaction classifications. |
VARCHAR2 |
1 |
SPECIAL_GL_TRANS_TYPE |
Code identifying the special general ledger transaction type. |
VARCHAR2 |
1 |
TIME_MONTH_KEY |
Identifier representing the fiscal reporting month associated with the transaction. |
VARCHAR2 |
6 |
TRANSACTION_CODE |
Code identifying the system transaction or business process that generated the entry. |
VARCHAR2 |
20 |
TRANSACTION_COUNTER |
System-generated counter used to differentiate transaction records. |
NUMBER |
1 |
USER_NAME |
Identifier of the user who created or posted the transaction in the source system. |
VARCHAR2 |
12 |
VENDOR_KEY |
Identifier of the vendor associated with the transaction when applicable. |
VARCHAR2 |
11 |
VENDOR_NAME |
Name of the vendor associated with the transaction. |
VARCHAR2 |
144 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |