DBA Data[Home] [Help] [Dependency Information]

TABLE: FV.FV_EXTRACT_DETAIL_GT_LOGS

Object Details
Object Name: FV_EXTRACT_DETAIL_GT_LOGS
Object Type: TABLE
Owner: FV
FND Design Data: TableFV.FV_EXTRACT_DETAIL_GT_LOGS
Subobject Name:
Status: VALID


Base table used for the AR/AP Netting Customer Vendor Cross Reference form


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER

Event ID
LINE_NUMBER NUMBER

Line Number
APPLICATION_ID NUMBER

Application ID
FUND_VALUE VARCHAR2 (30)
Fund Value
FUND_CATEGORY VARCHAR2 (1)
Fund Category
FUND_EXPIRED_STATUS VARCHAR2 (15)
Fund Expired Status
PRIOR_YEAR_FLAG VARCHAR2 (1)
Prior Year Flag
ADJUSTMENT_TYPE VARCHAR2 (15)
Adjustment Type
NET_PYA_ADJ_AMT NUMBER

Net PYA Adjusted Amount
ENTERED_PYA_AMT NUMBER

Entered PYA Amount
ENTERED_PYA_DIFF_AMT NUMBER

Entered PYA Difference Amount
ANTICIPATION VARCHAR2 (15)
Anticipation
ANTICIPATED_AMT NUMBER

Anticipated Amount
UNANTICIPATED_AMT NUMBER

Unanticipated Amount
TCF_AMT NUMBER

TCF Amount
UNEXPENDED_OBLIGATION NUMBER

Unexpended Obligation
PAID_UNEXPENDED_OBLIGATION NUMBER

Paid Unexpended Obligation
PAID_RECEIVED_AMT NUMBER

Paid Received Amount
UNPAID_UNEXPENDED_OBLIGATION NUMBER

Unpaid Unexpended Obligation
UNPAID_RECEIVED_AMT NUMBER

Unpaid Received Amount
UNPAID_OPEN_AMT NUMBER

Unpaid Open Amount
FUND_TIME_FRAME VARCHAR2 (25)
Fund Time Frame
RCV_PARENT_SUB_LEDGER_ID NUMBER

Rcv Parent Subledger ID
ACCOUNT_VALID_FLAG VARCHAR2 (1)
Account Valid Flag
ACCOUNT_RULE VARCHAR2 (50)
Account Rule
OLD_CCID NUMBER

Old CCID
RECEIVABLE_WITH_ADVANCE VARCHAR2 (1)
Receivable With Advance
ENT_COMMITMENT_AMOUNT NUMBER

Ent Commitment Amount
ENT_UNPAID_OBL_AMOUNT NUMBER

Ent Unpaid Obligation Amount
ACC_COMMITMENT_AMOUNT NUMBER

Acc Commitment Amount
ACC_UNPAID_OBL_AMOUNT NUMBER

Acc Unpaid Obligation Amount
ENT_UNPAID_OBL_PYA_AMOUNT NUMBER

Ent Unpaid Obligation PYA Amount
ACC_UNPAID_OBL_PYA_AMOUNT NUMBER

Acc Unpaid Obligation PYA Amount
ENT_UNPAID_OBL_PYA_OFF_AMOUNT NUMBER

Ent Unpaid Obligation PYA Offset Amount
ACC_UNPAID_OBL_PYA_OFF_AMOUNT NUMBER

Acc Unpaid Obligation PYA Offset Amount
ENT_ANTICIPATED_BUDGET_AMOUNT NUMBER

Ent Anticipated Budget Amount
ACC_ANTICIPATED_BUDGET_AMOUNT NUMBER

Acc Anticipated Budget Amount
ENT_UNANTICIPATED_BUD_AMOUNT NUMBER

Ent Unanticipated Budget Amount
ACC_UNANTICIPATED_BUD_AMOUNT NUMBER

Acc Unanticipated Budget Amount
ENT_UNRESERVED_BUDGET_AMOUNT NUMBER

Ent Unreserved Budget Amount
ACC_UNRESERVED_BUDGET_AMOUNT NUMBER

Acc Unreserved Budget Amount
ENT_CHARGE_AMOUNT NUMBER

Ent Charge Amount
ACC_CHARGE_AMOUNT NUMBER

Acc Charge Amount
ENT_UNPAID_EXP_AMOUNT NUMBER

Ent Unpaid Expenditure Amount
ACC_UNPAID_EXP_AMOUNT NUMBER

Acc Unpaid Expenditure Amount
ENT_PAID_EXP_AMOUNT NUMBER

Ent Paid Expenditure Amount
ACC_PAID_EXP_AMOUNT NUMBER

Acc Paid Expenditure Amount
AR_TRANSACTION_CATEGORY VARCHAR2 (50)
AR Transaction Category
ENT_PAID_OBL_AMOUNT NUMBER

FV Entered Paid Obligation Amount
ACC_PAID_OBL_AMOUNT NUMBER

FV Accounted Paid Obligation Amount
ENT_UNPAID_EXP_PYA_AMOUNT NUMBER

FV Entered Unpaid Expenditure PYA Amount
ACC_UNPAID_EXP_PYA_AMOUNT NUMBER

FV Accounted Unpaid Expenditure PYA Amount
ENT_UNPAID_EXP_PYA_OFF_AMOUNT NUMBER

FV Entered Unpaid Expenditure PYA Offset Amount
ACC_UNPAID_EXP_PYA_OFF_AMOUNT NUMBER

FV Accounted Unpaid Expenditure PYA Offset Amount
ACC_EXPENDED_APPROP_AMOUNT NUMBER

FV Accounted Expended Appropriations Amount
ENT_EXPENDED_APPROP_AMOUNT NUMBER

FV Entered Expended Appropriations Amount
ENT_PAID_EXP_PYA_AMOUNT NUMBER

FV Entered Paid Expenditure PYA Amount
ACC_PAID_EXP_PYA_AMOUNT NUMBER

FV Accounted Paid Expenditure PYA Amount
ENT_PAID_EXP_PYA_OFF_AMOUNT NUMBER

FV Entered Paid Expenditure PYA Offset Amount
ACC_PAID_EXP_PYA_OFF_AMOUNT NUMBER

FV Accounted Paid Expenditure PYA Offset Amount
TREASURY_SYMBOL_ID NUMBER

Treasury Symbol Identifier
DIRECT_OR_REIMB VARCHAR2 (1)
Direct or Reimbursable
PO_DISTRIBUTION_ID NUMBER

PO Distribution ID
FUND_TYPE VARCHAR2 (5)
Fund Type
FED_NON_FED_IND VARCHAR2 (1)
Federal or Non Federal Indicator
ENT_REFUND_AMOUNT NUMBER

Entered Refund Amount
ACC_REFUND_AMOUNT NUMBER

Accounted Refund Amount
ADVANCE_REQUIRED VARCHAR2 (1)
Advance Required
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EVENT_ID
,      LINE_NUMBER
,      APPLICATION_ID
,      FUND_VALUE
,      FUND_CATEGORY
,      FUND_EXPIRED_STATUS
,      PRIOR_YEAR_FLAG
,      ADJUSTMENT_TYPE
,      NET_PYA_ADJ_AMT
,      ENTERED_PYA_AMT
,      ENTERED_PYA_DIFF_AMT
,      ANTICIPATION
,      ANTICIPATED_AMT
,      UNANTICIPATED_AMT
,      TCF_AMT
,      UNEXPENDED_OBLIGATION
,      PAID_UNEXPENDED_OBLIGATION
,      PAID_RECEIVED_AMT
,      UNPAID_UNEXPENDED_OBLIGATION
,      UNPAID_RECEIVED_AMT
,      UNPAID_OPEN_AMT
,      FUND_TIME_FRAME
,      RCV_PARENT_SUB_LEDGER_ID
,      ACCOUNT_VALID_FLAG
,      ACCOUNT_RULE
,      OLD_CCID
,      RECEIVABLE_WITH_ADVANCE
,      ENT_COMMITMENT_AMOUNT
,      ENT_UNPAID_OBL_AMOUNT
,      ACC_COMMITMENT_AMOUNT
,      ACC_UNPAID_OBL_AMOUNT
,      ENT_UNPAID_OBL_PYA_AMOUNT
,      ACC_UNPAID_OBL_PYA_AMOUNT
,      ENT_UNPAID_OBL_PYA_OFF_AMOUNT
,      ACC_UNPAID_OBL_PYA_OFF_AMOUNT
,      ENT_ANTICIPATED_BUDGET_AMOUNT
,      ACC_ANTICIPATED_BUDGET_AMOUNT
,      ENT_UNANTICIPATED_BUD_AMOUNT
,      ACC_UNANTICIPATED_BUD_AMOUNT
,      ENT_UNRESERVED_BUDGET_AMOUNT
,      ACC_UNRESERVED_BUDGET_AMOUNT
,      ENT_CHARGE_AMOUNT
,      ACC_CHARGE_AMOUNT
,      ENT_UNPAID_EXP_AMOUNT
,      ACC_UNPAID_EXP_AMOUNT
,      ENT_PAID_EXP_AMOUNT
,      ACC_PAID_EXP_AMOUNT
,      AR_TRANSACTION_CATEGORY
,      ENT_PAID_OBL_AMOUNT
,      ACC_PAID_OBL_AMOUNT
,      ENT_UNPAID_EXP_PYA_AMOUNT
,      ACC_UNPAID_EXP_PYA_AMOUNT
,      ENT_UNPAID_EXP_PYA_OFF_AMOUNT
,      ACC_UNPAID_EXP_PYA_OFF_AMOUNT
,      ACC_EXPENDED_APPROP_AMOUNT
,      ENT_EXPENDED_APPROP_AMOUNT
,      ENT_PAID_EXP_PYA_AMOUNT
,      ACC_PAID_EXP_PYA_AMOUNT
,      ENT_PAID_EXP_PYA_OFF_AMOUNT
,      ACC_PAID_EXP_PYA_OFF_AMOUNT
,      TREASURY_SYMBOL_ID
,      DIRECT_OR_REIMB
,      PO_DISTRIBUTION_ID
,      FUND_TYPE
,      FED_NON_FED_IND
,      ENT_REFUND_AMOUNT
,      ACC_REFUND_AMOUNT
,      ADVANCE_REQUIRED
FROM FV.FV_EXTRACT_DETAIL_GT_LOGS;

Dependencies

[top of page]

FV.FV_EXTRACT_DETAIL_GT_LOGS does not reference any database object

FV.FV_EXTRACT_DETAIL_GT_LOGS is referenced by following:

SchemaFV
ViewFV_EXTRACT_DETAIL_GT_LOGS#