[Home] [Help] [Dependency Information]
Object Name: | FV_SF1219_TEMP |
---|---|
Object Type: | TABLE |
Owner: | FV |
FND Design Data: | FV.FV_SF1219_TEMP |
Subobject Name: | |
Status: | VALID |
FV_SF1219_TEMP stores the transactions that are processed by the FMS Form 1219/1220 process. These are transactions stored in the GL_JE_LINES table and are classified as Payables, Receivables, Treasury, and VOID by the FMS Form 1219/1220 process. Any other type of transactions are classified as MANUAL.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FV_SF1219_TEMP_PK | NORMAL | UNIQUE | APPS_TS_INTERFACE | TEMP_RECORD_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEMP_RECORD_ID | NUMBER | (8) | Yes | Unique record identifier |
BATCH_ID | NUMBER | (15) | Yes | Journal entry batch defining column |
FUND_CODE | VARCHAR2 | (25) | Yes | Fund balancing segment value |
NAME | VARCHAR2 | (100) | Yes | Batch name |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of Books identifier |
GL_PERIOD | VARCHAR2 | (15) | Yes | Batch accounting period |
RECORD_TYPE | VARCHAR2 | (1) | Yes | Record type set to transaction internally by FMS Form 1219/1220 process |
LINES_EXIST | VARCHAR2 | (1) | Yes | Flag to indicate whether there are report lines assigned to transaction. Used in FMS Form 1219/1220 Transaction Correction form as an indicator. |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
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) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
POSTED_DATE | DATE | Date batch was posted | ||
REPORTED_GL_PERIOD | VARCHAR2 | (6) | Period for which FMS Form 1219/1220 process was run. Used in FMS Form 1219/1220 Transaction Correction form and report. | |
AMOUNT | NUMBER | Sum of line ENTERED_DR or ENTERED_CR on FMS Form 224 Statement of Transactions report | ||
SF1219_TYPE_CODE | VARCHAR2 | (25) | Indicates type of fund for FMS Form 1219/1220 reporting | |
REFERENCE_1 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_2 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_3 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_4 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_5 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_6 | VARCHAR2 | (240) | Journal entry line reference column | |
REPORTED_MONTH | VARCHAR2 | (25) | Category of month reported | |
DEFAULT_PERIOD_NAME | VARCHAR2 | (20) | Name of period if defaulted | |
EXCEPTION_CATEGORY | VARCHAR2 | (25) | Reason transaction appears on exception report | |
ACCOMPLISH_MONTH | VARCHAR2 | (6) | Month journal entry was accomplished. Stored in MMYYYY format. | |
ACCOMPLISH_DATE | DATE | Date journal entry was accomplished | ||
OBLIGATION_DATE | DATE | Date refunded or voided dollars were obligated | ||
INTER_AGENCY_FLAG | VARCHAR2 | (1) | Interagency fund flag | |
TREASURY_SYMBOL | VARCHAR2 | (35) | Treasury symbol | |
ALC_CODE | VARCHAR2 | (12) | Agency location code | |
ORG_ID | NUMBER | (15) | Organization identifier | |
GROUP_NAME | VARCHAR2 | (4) | Stores group name derived by FMS Form 1219/1220 process | |
UPDATE_TYPE | VARCHAR2 | (25) | Used by FMS Form 1219/1220 process internally for updating processed flag in case of Interagency and Refunds Voids transactions | |
TYPE | VARCHAR2 | (10) | Used by FMS Form 1219/1220 process internally for updating processed flag in case of Interagency and Refunds Voids transactions | |
GL_PERIOD_NAME | VARCHAR2 | (15) | Reported General Ledger period name for updating processed flag in case of Interagency and Refunds Voids transactions. Used internally by FMS Form 1219/1220 process. | |
PROCESSED_FLAG | VARCHAR2 | (1) | Used to update processed flag value in FV_INTERAGENCY_FUNDS_ALL and FV_REFUNDS_VOIDS_ALL tables | |
TREASURY_SYMBOL_ID | NUMBER | (15) | References treasury_symbol_id of the table FV_TREASURY_SYMBOLS | |
JE_HEADER_ID | NUMBER | Not currently used | ||
JE_LINE_NUM | NUMBER | Not currently used | ||
REFERENCE_9 | VARCHAR2 | (240) | Journal entry line reference column | |
SUPPLEMENT_NUMBER | NUMBER | Supplement number | ||
JE_FROM_SLA_FLAG | VARCHAR2 | (1) | JE from SLA Flag |
Cut, paste (and edit) the following text to query this object:
SELECT TEMP_RECORD_ID
, BATCH_ID
, FUND_CODE
, NAME
, SET_OF_BOOKS_ID
, GL_PERIOD
, RECORD_TYPE
, LINES_EXIST
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, POSTED_DATE
, REPORTED_GL_PERIOD
, AMOUNT
, SF1219_TYPE_CODE
, REFERENCE_1
, REFERENCE_2
, REFERENCE_3
, REFERENCE_4
, REFERENCE_5
, REFERENCE_6
, REPORTED_MONTH
, DEFAULT_PERIOD_NAME
, EXCEPTION_CATEGORY
, ACCOMPLISH_MONTH
, ACCOMPLISH_DATE
, OBLIGATION_DATE
, INTER_AGENCY_FLAG
, TREASURY_SYMBOL
, ALC_CODE
, ORG_ID
, GROUP_NAME
, UPDATE_TYPE
, TYPE
, GL_PERIOD_NAME
, PROCESSED_FLAG
, TREASURY_SYMBOL_ID
, JE_HEADER_ID
, JE_LINE_NUM
, REFERENCE_9
, SUPPLEMENT_NUMBER
, JE_FROM_SLA_FLAG
FROM FV.FV_SF1219_TEMP;
FV.FV_SF1219_TEMP does not reference any database object
FV.FV_SF1219_TEMP is referenced by following:
|
|
|