eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FV.FV_SF224_TEMP

Object Details

Object Name:	FV_SF224_TEMP
Object Type:	TABLE
Owner:	FV
FND Design Data:	FV.FV_SF224_TEMP
Subobject Name:
Status:	VALID

FV_SF224_TEMP contains those records selected for reporting in the specified period.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
JE_BATCH_ID	NUMBER	(15)	Yes	Journal entry batch defining column
FUND_CODE	VARCHAR2	(25)		Fund balancing segment value
FUND_DESCRIPTION	VARCHAR2	(255)		Fund description containing Treasury symbol
NAME	VARCHAR2	(100)		Batch name
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
POSTED_DATE	DATE			Date batch was posted
GL_PERIOD	VARCHAR2	(25)		Batch accounting period
DEFAULT_PERIOD_NAME	VARCHAR2	(20)		Name of period if defaulted
AMOUNT	NUMBER			Sum of line ENTERED_DR or ENTERED_CR on FMS Form 224 Statement of Transactions report
SF224_TYPE_CODE	VARCHAR2	(25)		Indicates type of fund for FMS Form 224 reporting
D_R_FLAG	VARCHAR2	(2)		Flag value. D for disbursing account, R for receipt account.
ACCOMPLISH_DATE	DATE			Date journal entry was accomplished
REPORTED_MONTH	VARCHAR2	(25)		Category of month reported
REFERENCE_1	VARCHAR2	(240)		Journal entry line reference column
REFERENCE_2	VARCHAR2	(240)		Journal entry line reference column
EXCEPTION_CATEGORY	VARCHAR2	(25)		Reason for transaction to appear on exception report
COLUMN_GROUP	NUMBER			Indicates group in which transaction gets reported in FMS Form 224 report
INTER_AGENCY_FLAG	VARCHAR2	(1)		Interagency fund flag
RECORD_TYPE	VARCHAR2	(30)		Record type of transaction for column placement
OBLIGATION_DATE	DATE			Date refunded or voided dollars were obligated
EXTERNAL_REFERENCE	VARCHAR2	(80)		Reference column for invoice identifier
TREASURY_SYMBOL	VARCHAR2	(35)		Treasury symbol
REFERENCE_3	VARCHAR2	(240)		Journal entry line reference column
SUPPLEMENTAL_FLAG	VARCHAR2	(1)		Indicates whether transaction was reported on original or supplemental FMS Form 224 Statement of Transactions report. Valid values are N for original and Y for supplemental.
REFERENCE_4	VARCHAR2	(240)		Journal entry line reference column
REPORTED_GL_PERIOD	VARCHAR2	(25)		Used in GOALS to indicate General Ledger period passed to 224 process
ALC_CODE	VARCHAR2	(30)		Agency location code
ORG_ID	NUMBER	(15)		Organization identifier
REFERENCE_5	VARCHAR2	(240)		Journal entry line reference column
REFERENCE_6	VARCHAR2	(240)		Journal entry line reference column
REPORTED_FLAG	VARCHAR2	(1)		Flag to indicate whether transaction is reported in FMS Form 224 report. Valid values are Y and N.
EXCEPTION_EXISTS	VARCHAR2	(12)		Indicates whether associated exception record was created for General Ledger transaction. Valid values are Y and N.
RECORD_CATEGORY	VARCHAR2	(15)		Indicates category of transaction record. Valid values are GLRECORD, EXCEPTION, and CREATED.
JE_LINE_NUM	NUMBER	(15)		Journal entry line
JE_HEADER_ID	NUMBER	(15)		Journal entry header
SF224_PROCESSED_FLAG	VARCHAR2	(1)		Flag to indicate whether General Ledger transaction is processed by FMS Form 224 process. Valid values are Y and N.
DEF_ORG_ID	NUMBER	(15)		Default multi-organization identifier. Used by FMS Form 224 process when no valid ORG_ID value could be derived.
PROCESSED_FLAG	VARCHAR2	(1)		Processed flag
REFERENCE_9	VARCHAR2	(240)		Journal entry line reference column containing payment invoice identifier
PROCESS_ID	NUMBER	(15)		Process identifier
TREASURY_SYMBOL_ID	NUMBER	(15)		references treasury_symbol_id of the table FV_TREASURY_SYMBOLS
FEDERAL_RPT_ID	NUMBER	(15)		No currently used
JE_SOURCE	VARCHAR2	(25)		No currently used
JE_CATEGORY	VARCHAR2	(25)		No currently used
DOCUMENT_NUMBER	VARCHAR2	(50)		No currently used
REFERENCE_8	VARCHAR2	(240)		Reference column for invoice distribution identifier
EXCEPTION_SECTION	NUMBER			The Section where the record should go in Exception report
START_PERIOD_DATE	DATE			The Start Period Date of the period of transaction
END_PERIOD_DATE	DATE			The End Period Date of the period of transaction
UPDATE_TYPE	VARCHAR2	(25)		Update Type
TXN_CATEGORY	VARCHAR2	(10)		Transaction category
SIGN_NUMBER	NUMBER			Sign Number
ACTUAL_AMOUNT	NUMBER			Actual Amount
CREATED_BY	NUMBER			Standard Who Column
CREATION_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER			Standard Who Column
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column
CREATED_REQUEST_ID	NUMBER			The Request Id that created the Transaction
UPDATED_REQUEST_ID	NUMBER			The Request Id that updated the Transaction
GL_DATE	DATE			GL Date of transaction
RECLASS	VARCHAR2	(1)		Reclassification
ACCOUNT	VARCHAR2	(25)		Account
JE_FROM_SLA_FLAG	VARCHAR2	(1)		Journal Entry from SLA flag

Query Text

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


SELECT JE_BATCH_ID
,      FUND_CODE
,      FUND_DESCRIPTION
,      NAME
,      SET_OF_BOOKS_ID
,      POSTED_DATE
,      GL_PERIOD
,      DEFAULT_PERIOD_NAME
,      AMOUNT
,      SF224_TYPE_CODE
,      D_R_FLAG
,      ACCOMPLISH_DATE
,      REPORTED_MONTH
,      REFERENCE_1
,      REFERENCE_2
,      EXCEPTION_CATEGORY
,      COLUMN_GROUP
,      INTER_AGENCY_FLAG
,      RECORD_TYPE
,      OBLIGATION_DATE
,      EXTERNAL_REFERENCE
,      TREASURY_SYMBOL
,      REFERENCE_3
,      SUPPLEMENTAL_FLAG
,      REFERENCE_4
,      REPORTED_GL_PERIOD
,      ALC_CODE
,      ORG_ID
,      REFERENCE_5
,      REFERENCE_6
,      REPORTED_FLAG
,      EXCEPTION_EXISTS
,      RECORD_CATEGORY
,      JE_LINE_NUM
,      JE_HEADER_ID
,      SF224_PROCESSED_FLAG
,      DEF_ORG_ID
,      PROCESSED_FLAG
,      REFERENCE_9
,      PROCESS_ID
,      TREASURY_SYMBOL_ID
,      FEDERAL_RPT_ID
,      JE_SOURCE
,      JE_CATEGORY
,      DOCUMENT_NUMBER
,      REFERENCE_8
,      EXCEPTION_SECTION
,      START_PERIOD_DATE
,      END_PERIOD_DATE
,      UPDATE_TYPE
,      TXN_CATEGORY
,      SIGN_NUMBER
,      ACTUAL_AMOUNT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_REQUEST_ID
,      UPDATED_REQUEST_ID
,      GL_DATE
,      RECLASS
,      ACCOUNT
,      JE_FROM_SLA_FLAG
FROM FV.FV_SF224_TEMP;

Dependencies

[top of page]

FV.FV_SF224_TEMP does not reference any database object

FV.FV_SF224_TEMP is referenced by following:

FV: FV_SF224_TEMP#