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

TABLE: FV.FV_SF224_AUDITS

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


FV_SF224_AUDITS tracks records that have already been reported on the FMS Form 224 Statement of Transactions report. This table is used in the selection process of the FMS Form 224 Statement of Transactions process. Batches that have been processed by the FMS Form 224 Statement of Transactions in prior periods are stored here. The FV_SF224_AUDITS table is updated during the FMS Form 224 Statement of Transactions report process if the RUN_TYPE of the report run parameters is Final.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FV_SF224_AUDITS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
ColumnJE_HEADER_ID
ColumnJE_LINE_NUM
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15) Yes Journal entry batch defining column
SF224_MONTH_REPORTED VARCHAR2 (25) Yes Month record was reported on FMS Form 224 Statement of Transactions report, in MMM-YYYY format
REPORTED_MONTH VARCHAR2 (25) Yes Category of month reported
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
COLUMN_GROUP VARCHAR2 (2)
Indicates group in which transaction gets reported in FMS Form 224 report
TREASURY_SYMBOL VARCHAR2 (35)
Treasury symbol
EXCEPTION_CATEGORY VARCHAR2 (25)
Reason transaction appears on Exception report
GL_PERIOD VARCHAR2 (25)
Period for which FMS Form 224 is reported
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.
REPORTED_GL_PERIOD VARCHAR2 (25)
General Ledger period for which FMS Form 224 is reported
SET_OF_BOOKS_ID NUMBER (15)
Set of Books identifier
ALC_CODE VARCHAR2 (30)
Agency location code
ORG_ID NUMBER (15)
Organization identifier
JE_HEADER_ID NUMBER (15)
Journal entry header
JE_LINE_NUM NUMBER (15)
Journal entry line
PROCESS_ID NUMBER (15)
Process identifier
TREASURY_SYMBOL_ID NUMBER (15) Yes References treasury_symbol_id of the table FV_TREASURY_SYMBOLS
INTER_AGENCY_FLAG VARCHAR2 (1)
Not currently used
RECORD_TYPE VARCHAR2 (30)
Not currently used
JE_SOURCE VARCHAR2 (25)
Not currently used
JE_CATEGORY VARCHAR2 (25)
Not currently used
DOCUMENT_NUMBER VARCHAR2 (50)
Not currently used
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 BATCH_ID
,      SF224_MONTH_REPORTED
,      REPORTED_MONTH
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      COLUMN_GROUP
,      TREASURY_SYMBOL
,      EXCEPTION_CATEGORY
,      GL_PERIOD
,      SUPPLEMENTAL_FLAG
,      REPORTED_GL_PERIOD
,      SET_OF_BOOKS_ID
,      ALC_CODE
,      ORG_ID
,      JE_HEADER_ID
,      JE_LINE_NUM
,      PROCESS_ID
,      TREASURY_SYMBOL_ID
,      INTER_AGENCY_FLAG
,      RECORD_TYPE
,      JE_SOURCE
,      JE_CATEGORY
,      DOCUMENT_NUMBER
,      JE_FROM_SLA_FLAG
FROM FV.FV_SF224_AUDITS;

Dependencies

[top of page]

FV.FV_SF224_AUDITS does not reference any database object

FV.FV_SF224_AUDITS is referenced by following:

SchemaAPPS
SynonymFV_SF224_AUDITS