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

TABLE: IGI.IGI_BUD_SHEET_HEADERS

Object Details
Object Name: IGI_BUD_SHEET_HEADERS
Object Type: TABLE
Owner: IGI
FND Design Data: TableIGI.IGI_BUD_SHEET_HEADERS
Subobject Name:
Status: VALID


IGI_BUD_SHEET_HEADERS stores budget journal headers from a budget spreadsheet transfer file. The table contains the following information: set of books name, fiscal year, budget name, organization name and reason code.
Scope: public
Product: IGI
Lifecycle: active
Display Name: Budget Spreadsheet Header File
Category: BUSINESS_ENTITY GL_JOURNAL


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGI_BUD_SHEET_HEADER_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSPREADSHEET_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
RECORD_TYPE VARCHAR2 (2) Yes Record type. Spreadsheet header transaction line.
STATUS VARCHAR2 (1) Yes Values are N for Not posted or P for Posted.
SPREADSHEET_HEADER_ID NUMBER (15) Yes Spreadsheet header identifier
FISCAL_YEAR NUMBER
Yes Financial year
BUDGET_NAME VARCHAR2 (30) Yes Budget name
ORGANIZATION_NAME VARCHAR2 (30) Yes Organization name
REASON_CODE VARCHAR2 (30) Yes Reason code
SET_OF_BOOKS_NAME VARCHAR2 (30) Yes Set of Books name
SET_OF_BOOKS_ID NUMBER (15)
Set of Books identifier
Query Text

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


SELECT RECORD_TYPE
,      STATUS
,      SPREADSHEET_HEADER_ID
,      FISCAL_YEAR
,      BUDGET_NAME
,      ORGANIZATION_NAME
,      REASON_CODE
,      SET_OF_BOOKS_NAME
,      SET_OF_BOOKS_ID
FROM IGI.IGI_BUD_SHEET_HEADERS;

Dependencies

[top of page]

IGI.IGI_BUD_SHEET_HEADERS does not reference any database object

IGI.IGI_BUD_SHEET_HEADERS is referenced by following:

SchemaAPPS
SynonymIGI_BUD_SHEET_HEADERS