[Home] [Help] [Dependency Information]
Object Name: | FV_BE_BA_FD_DTL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FV.FV_BE_BA_FD_DTL_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
The main purpose of this view is used as Transaction Extract lines for SLA to identify the sources
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_ID | NUMBER | (15) | Sub Ledger Accounting Event Identifier | |
LINE_NUMBER | NUMBER | (15) | Detail budgetary transaction identifier | |
TRANSACTION_TYPE_ID | NUMBER | (15) | Transaction Type identifier. | |
SUB_TYPE | VARCHAR2 | (30) | Sub Type code | |
FUND_DISTRIBUTION_ACCOUNT | NUMBER | Distribution account code combination identifier | ||
LINE_SEGMENT1 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT2 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT3 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT4 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT5 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT6 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT7 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT8 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT9 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT10 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT11 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT12 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT13 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT14 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT15 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT16 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT17 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT18 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT19 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT20 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT21 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT22 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT23 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT24 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT25 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT26 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT27 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT28 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT29 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
LINE_SEGMENT30 | VARCHAR2 | (25) | Accounting flexfield segment from FV_BE_TRX_DTLS | |
INCREASE_DECREASE_FLAG | VARCHAR2 | (1) | Flag used to indicate Increase or Decrease in amount | |
ACCOUNTED_AMOUNT | NUMBER | Transaction amount | ||
LINE_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment from FV_BE_TRX_DTLS | |
LINE_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment from FV_BE_TRX_DTLS | |
LINE_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment from FV_BE_TRX_DTLS | |
LINE_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment from FV_BE_TRX_DTLS | |
LINE_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment from FV_BE_TRX_DTLS | |
LINE_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment from FV_BE_TRX_DTLS | |
LINE_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment from FV_BE_TRX_DTLS | |
LINE_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment from FV_BE_TRX_DTLS | |
LINE_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment from FV_BE_TRX_DTLS | |
LINE_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment from FV_BE_TRX_DTLS | |
LINE_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment from FV_BE_TRX_DTLS | |
LINE_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment from FV_BE_TRX_DTLS | |
LINE_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment from FV_BE_TRX_DTLS | |
LINE_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment from FV_BE_TRX_DTLS | |
LINE_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment from FV_BE_TRX_DTLS | |
LINE_ATTR_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure column from FV_BE_TRX_DTLS | |
CORRECTED_FLAG | VARCHAR2 | (1) | Corrected flag, used to indicate whether the original interface record was modified | |
GROUP_ID | NUMBER | Group ID, identifies which group_id the record came from | ||
TRANSACTION_TYPE | VARCHAR2 | (25) | Transaction Type | |
DR_ACCOUNT_SEGMENT_VALUE | VARCHAR2 | (25) | Debit account segment value for the transaction type | |
CR_ACCOUNT_SEGMENT_VALUE | VARCHAR2 | (25) | Credit account segment value for the transaction type | |
APPROVAL_DATE | DATE | Approval date of the record | ||
PUBLIC_LAW_CODE | VARCHAR2 | (7) | Public Law Code. Used only for appropriation transactions | |
ADVANCE_TYPE | VARCHAR2 | (25) | Advance Type. Used only for appropriation transactions. Valid values are "P" Advanced in prior year "F" Advanced from future year | |
DEPT_ID | VARCHAR2 | (2) | Department identifier | |
MAIN_ACCOUNT | VARCHAR2 | (4) | Main account | |
TRANSFER_DESCRIPTION | VARCHAR2 | (30) | Description for direct transfer |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_ID
, LINE_NUMBER
, TRANSACTION_TYPE_ID
, SUB_TYPE
, FUND_DISTRIBUTION_ACCOUNT
, LINE_SEGMENT1
, LINE_SEGMENT2
, LINE_SEGMENT3
, LINE_SEGMENT4
, LINE_SEGMENT5
, LINE_SEGMENT6
, LINE_SEGMENT7
, LINE_SEGMENT8
, LINE_SEGMENT9
, LINE_SEGMENT10
, LINE_SEGMENT11
, LINE_SEGMENT12
, LINE_SEGMENT13
, LINE_SEGMENT14
, LINE_SEGMENT15
, LINE_SEGMENT16
, LINE_SEGMENT17
, LINE_SEGMENT18
, LINE_SEGMENT19
, LINE_SEGMENT20
, LINE_SEGMENT21
, LINE_SEGMENT22
, LINE_SEGMENT23
, LINE_SEGMENT24
, LINE_SEGMENT25
, LINE_SEGMENT26
, LINE_SEGMENT27
, LINE_SEGMENT28
, LINE_SEGMENT29
, LINE_SEGMENT30
, INCREASE_DECREASE_FLAG
, ACCOUNTED_AMOUNT
, LINE_ATTRIBUTE1
, LINE_ATTRIBUTE2
, LINE_ATTRIBUTE3
, LINE_ATTRIBUTE4
, LINE_ATTRIBUTE5
, LINE_ATTRIBUTE6
, LINE_ATTRIBUTE7
, LINE_ATTRIBUTE8
, LINE_ATTRIBUTE9
, LINE_ATTRIBUTE10
, LINE_ATTRIBUTE11
, LINE_ATTRIBUTE12
, LINE_ATTRIBUTE13
, LINE_ATTRIBUTE14
, LINE_ATTRIBUTE15
, LINE_ATTR_CATEGORY
, CORRECTED_FLAG
, GROUP_ID
, TRANSACTION_TYPE
, DR_ACCOUNT_SEGMENT_VALUE
, CR_ACCOUNT_SEGMENT_VALUE
, APPROVAL_DATE
, PUBLIC_LAW_CODE
, ADVANCE_TYPE
, DEPT_ID
, MAIN_ACCOUNT
, TRANSFER_DESCRIPTION
FROM APPS.FV_BE_BA_FD_DTL_V;
|
|
|