FINANCIAL DETAIL Table
Stores detailed financial transaction line items from the general ledger, including amounts, dates, document attributes, cost collector and account assignments, vendor/customer references, and payment and purchasing details for financial reporting and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTUAL_AMOUNT |
Transaction amount in document currency. |
NUMBER |
13,2 |
ACTUAL_AMOUNT_LC |
Transaction amount in local currency. |
NUMBER |
13,2 |
ALLOCATION_NUMBER |
Allocation number associated with the transaction. |
VARCHAR2 |
25 |
ALTERNATIVE_ACCOUNT_NUMBER |
Alternative account number associated with the transaction. |
VARCHAR2 |
10 |
BLOCKED_PAYMENT_TEXT |
Text describing payment blocking reason. |
VARCHAR2 |
20 |
CHECK_ENCASHMENT_DATE |
Date the check was cashed. |
DATE |
|
CHECK_NUMBER |
Check number associated with the payment transaction. |
VARCHAR2 |
13 |
CLEARING_DATE |
Date the transaction was cleared. |
DATE |
|
CLEARING_DOCUMENT_NUMBER |
Document number used to clear the transaction. |
VARCHAR2 |
10 |
CLEARING_ENTRY_DATE |
Date the clearing document was entered. |
DATE |
|
COMMITMENT_ITEM |
Commitment item associated with the transaction. |
VARCHAR2 |
14 |
COMPANY_CODE |
Company code associated with the transaction. |
VARCHAR2 |
4 |
COST_COLLECTOR_FY_KEY |
Key representing the cost collector by fiscal year. |
VARCHAR2 |
12 |
COST_COLLECTOR_KEY |
Key identifier for the cost collector associated with the financial transaction. |
VARCHAR2 |
12 |
CUSTOMER_KEY |
Key identifier for the customer associated with the transaction. |
VARCHAR2 |
11 |
DEBIT_CREDIT_INDICATOR |
Indicator identifying whether the transaction is a debit or credit. |
VARCHAR2 |
1 |
DELIVERY_COMPLETE_INDICATOR |
Indicator identifying whether delivery is complete (Y/N). |
VARCHAR2 |
1 |
DOCUMENT_CURRENCY |
Currency code of the financial document. |
VARCHAR2 |
5 |
DOCUMENT_DATE |
Date the financial document was created. |
DATE |
|
DOCUMENT_ENTRY_DATE |
Date the document was entered into the system. |
DATE |
|
DOCUMENT_LAST_CHANGE_DATE |
Date the document was last modified. |
DATE |
|
DOCUMENT_LINE_DATE |
Date associated with the document line item. |
DATE |
|
DOCUMENT_LINE_ITEM |
Line item number within the financial document. |
NUMBER |
3 |
DOCUMENT_NUMBER |
Unique identifier for the financial document. |
VARCHAR2 |
10 |
DOCUMENT_TYPE_KEY |
Key identifying the document type. |
VARCHAR2 |
3 |
DUNNING_AREA_KEY |
Key identifying the dunning area associated with the transaction. |
VARCHAR2 |
7 |
FINANCIAL_DETAIL_KEY |
Unique key identifier for the financial detail record. |
VARCHAR2 |
17 |
FUND_CENTER_KEY |
Key identifier for the fund center associated with the transaction. |
VARCHAR2 |
16 |
FUND_KEY |
Key identifier for the fund associated with the transaction. |
VARCHAR2 |
10 |
GL_ACCOUNT_KEY |
Key identifier for the general ledger account associated with the transaction. |
VARCHAR2 |
10 |
HOUSE_BANK |
Identifier for the house bank associated with the transaction. |
VARCHAR2 |
5 |
INTERCOMPANY_TRANSACTION_ID |
Identifier for intercompany transactions. |
VARCHAR2 |
16 |
LINE_ITEM_TEXT |
Descriptive text for the document line item. |
VARCHAR2 |
100 |
LOCAL_CURRENCY |
Local currency code associated with the transaction. |
VARCHAR2 |
5 |
MANUAL_BLOCKING_INDICATOR |
Indicator identifying whether the transaction was manually blocked (Y/N). |
VARCHAR2 |
1 |
MATERIAL_GROUP_CODE |
Code identifying the material group. |
VARCHAR2 |
9 |
MORE_CHECKS_FLAG |
Indicator identifying whether additional checks are associated with the transaction (Y/N). |
VARCHAR2 |
1 |
OFFSET_COST_COLLECTOR_KEY |
Key identifier for the offsetting cost collector associated with the transaction. |
VARCHAR2 |
12 |
ORIGINAL_PROCEDURE_CODE |
Code identifying the original processing procedure. |
VARCHAR2 |
5 |
PARKED_BY_USER_NAME |
User identifier for the individual who parked the document. |
VARCHAR2 |
12 |
POSTING_DATE |
Date the transaction was posted to the general ledger. |
DATE |
|
POSTING_KEY |
Posting key associated with the transaction. |
VARCHAR2 |
3 |
POSTING_KEY_CODE |
Code identifying the posting key. |
VARCHAR2 |
2 |
PO_LINE_ITEM_TEXT |
Descriptive text for 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 for the purchase order quantity. |
VARCHAR2 |
5 |
PROBABLE_PAYMENT_DATE |
Expected or probable payment date. |
DATE |
|
PURCHASE_ORDER_ACCT_ASSIGNMENT |
Account assignment number for 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. |
VARCHAR2 |
10 |
REFERENCE_DOCUMENT_NUMBER |
Reference document number associated with the transaction. |
VARCHAR2 |
30 |
REFERENCE_TEXT |
Reference text associated with the financial document. |
VARCHAR2 |
50 |
REVERSE_DOCUMENT_NUMBER |
Document number of the reversing transaction, if applicable. |
VARCHAR2 |
10 |
REVERSE_DOCUMENT_YEAR |
Fiscal year of the reversing document. |
VARCHAR2 |
4 |
SPECIAL_GL_INDICATOR |
Indicator identifying special general ledger transactions. |
VARCHAR2 |
1 |
SPECIAL_GL_TRANS_TYPE |
Code identifying the special general ledger transaction type. |
VARCHAR2 |
1 |
TIME_MONTH_KEY |
Key representing the fiscal month associated with the transaction. |
VARCHAR2 |
6 |
TRANSACTION_CODE |
Code identifying the transaction type or process. |
VARCHAR2 |
20 |
TRANSACTION_COUNTER |
Counter indicating transaction sequencing or versioning. |
NUMBER |
1 |
USER_NAME |
User identifier for the individual who created or posted the transaction. |
VARCHAR2 |
12 |
VENDOR_KEY |
Key identifier for the vendor associated with the transaction. |
VARCHAR2 |
11 |
VENDOR_NAME |
Name of the vendor associated with the transaction. |
VARCHAR2 |
144 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the warehouse. |
DATE |