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

TABLE: IGS.IGS_FI_INVLN_INT_ALL

Object Details
Object Name: IGS_FI_INVLN_INT_ALL
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_FI_INVLN_INT_ALL
Subobject Name:
Status: VALID


IGS_FI_INVLN_INT_ALL interface table stores invoice lines data generated by invoice process.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_FI_INVLN_INT_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVOICE_LINES_ID
IGS_FI_INVLN_INT_ALL_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVOICE_ID
ColumnLINE_NUMBER
Columns
Name Datatype Length Mandatory Comments
INVOICE_LINES_ID NUMBER (15) Yes Invoice Line Identifier uniquely identifies an Invoice Line
INVOICE_ID NUMBER (15) Yes Invoice Identifier uniquely identifies an Invoice
LINE_NUMBER NUMBER (15) Yes Invoice Line number
S_CHG_METHOD_TYPE VARCHAR2 (30)
Charge method type for this assessment item
DESCRIPTION VARCHAR2 (240)
Description of the charge
CHG_ELEMENTS NUMBER (7)
Charge elements used if this is not an enrollment based charge.
AMOUNT NUMBER

Charge Amount
UNIT_CD VARCHAR2 (10)
Unit Code - Obsolete column
UNIT_VERSION_NUMBER NUMBER (3)
Unit Version Number - Obsolete column
UNIT_ATTEMPT_STATUS VARCHAR2 (10)
Unit Attempt Status
UNIT_LOCATION_CD VARCHAR2 (10)
Unit Location Code- Obsolete column
CAL_TYPE VARCHAR2 (10)
Unit Load Calendar Type - Obsolete column
CI_SEQUENCE_NUMBER NUMBER (6)
Unit Load Calendar Instance - Obsolete column
EFTSU NUMBER (7)
Unit Effective Full Time Student Units
CREDIT_POINTS NUMBER (6)
Unit Credit Points
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Structure Defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Segment column
ORG_ID NUMBER (15)
Operating Unit Identifier.
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
UNIT_CLASS VARCHAR2 (10)
Unit Class of the Unit Section - Obsolete column
REC_ACCOUNT_CD VARCHAR2 (40)
Receivables Account Code
REV_ACCOUNT_CD VARCHAR2 (40)
Revenue Account Code
REC_GL_CCID NUMBER (15)
Receivables Key Accounting Flexfield
REV_GL_CCID NUMBER (15)
Revenue Key Accounting Flexfield
ORG_UNIT_CD VARCHAR2 (30)
Org Unit Code
POSTING_ID NUMBER (15)
Posting Id
SOURCE_TRANSACTION_ID NUMBER (15)
Obsolete - As part of Enh bug #2228910
ATTRIBUTE11 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE12 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE13 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE14 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE15 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE16 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE17 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE18 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE19 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE20 VARCHAR2 (150)
Standard DFF Column
REQUEST_ID NUMBER (15)
Standard Concurrent Process Column
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Concurrent Process Column
PROGRAM_ID NUMBER (15)
Standard Concurrent Process Column
PROGRAM_UPDATE_DATE DATE

Standard Concurrent Process Column
ERROR_STRING VARCHAR2 (1000)
Error string that is generated by Build accounts process when it fails to generate account code.It also contains the concatenated segments of the account
ERROR_ACCOUNT VARCHAR2 (1)
Error Account Flag.Default value is 'N'
LOCATION_CD VARCHAR2 (10)
The location to which the transaction belongs
UOO_ID NUMBER (7)
The unit offering option to which the student is enrolled
GL_DATE DATE

General Ledger Date of the Charge Record.
GL_POSTED_DATE DATE

The Date on which the charge record is posted to the interface.
POSTING_CONTROL_ID NUMBER (15)
The Posting Batch Identifier.
UNIT_LEVEL VARCHAR2 (10)
Unit Level
UNIT_TYPE_ID NUMBER

Unit Program Type Level Identifier
Query Text

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


SELECT INVOICE_LINES_ID
,      INVOICE_ID
,      LINE_NUMBER
,      S_CHG_METHOD_TYPE
,      DESCRIPTION
,      CHG_ELEMENTS
,      AMOUNT
,      UNIT_CD
,      UNIT_VERSION_NUMBER
,      UNIT_ATTEMPT_STATUS
,      UNIT_LOCATION_CD
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      EFTSU
,      CREDIT_POINTS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      UNIT_CLASS
,      REC_ACCOUNT_CD
,      REV_ACCOUNT_CD
,      REC_GL_CCID
,      REV_GL_CCID
,      ORG_UNIT_CD
,      POSTING_ID
,      SOURCE_TRANSACTION_ID
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ERROR_STRING
,      ERROR_ACCOUNT
,      LOCATION_CD
,      UOO_ID
,      GL_DATE
,      GL_POSTED_DATE
,      POSTING_CONTROL_ID
,      UNIT_LEVEL
,      UNIT_TYPE_ID
FROM IGS.IGS_FI_INVLN_INT_ALL;

Dependencies

[top of page]

IGS.IGS_FI_INVLN_INT_ALL does not reference any database object

IGS.IGS_FI_INVLN_INT_ALL is referenced by following:

SchemaAPPS
SynonymIGS_FI_INVLN_INT_ALL