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

TABLE: IGS.IGS_FI_INV_INT_ALL

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


IGS_FI_INV_INT_ALL stores invoice 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_INV_INT_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVOICE_ID
IGS_FI_INV_INT_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_ID
ColumnFEE_TYPE
ColumnFEE_CAL_TYPE
ColumnFEE_CI_SEQUENCE_NUMBER
Columns
Name Datatype Length Mandatory Comments
INVOICE_ID NUMBER (15) Yes Invoice Identifier
PERSON_ID NUMBER (15) Yes Student identifier
SPONSOR_CD VARCHAR2 (10)
OBSOLETE (Sponsor Code if student is sponsored )- Obsolete
FEE_TYPE VARCHAR2 (10) Yes Fee Type
FEE_CAT VARCHAR2 (10)
Fee Category
FEE_CAL_TYPE VARCHAR2 (10) Yes Fee Calendar Type
FEE_CI_SEQUENCE_NUMBER NUMBER (6) Yes Fee Calendar Instance Sequence Number
COURSE_CD VARCHAR2 (6)
Program Code
ATTENDANCE_MODE VARCHAR2 (2)
Attendance Mode
ATTENDANCE_TYPE VARCHAR2 (2)
Attendance Type
INVOICE_AMOUNT_DUE NUMBER
Yes Invoice or Transaction Amount
INVOICE_CREATION_DATE DATE
Yes Invoice Date
INVOICE_DESC VARCHAR2 (240)
Invoice Description
TRANSACTION_TYPE VARCHAR2 (30) Yes Transaction Type
CURRENCY_CD VARCHAR2 (15) Yes Currency Code
ACCOUNT_ID NUMBER (15)
Oracle Student System Account Identifier - No longer used
TERM_ID NUMBER (15)
Oracle Student System Payment Term Identifier - No longer used
STATUS VARCHAR2 (30) Yes Initial Value should be 'LOAD', Other values are 'TODO', 'TRANSFER', 'SUCCESS', 'ERROR'
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.
MERCHANT_ID VARCHAR2 (80)
Merchant ID - No longer used
CREDIT_CARD_CODE VARCHAR2 (80)
Represent Type of Credit Card - No longer used
CREDIT_CARD_HOLDER_NAME VARCHAR2 (80)
Credit Card Holder Name - No longer used
CREDIT_CARD_EXPIRATION_DATE DATE

Credit card expiration date - No longer used
CREDIT_CARD_APPROVAL_CODE VARCHAR2 (80)
Authorization Code - No longer used
CREDIT_CARD_APPROVAL_DATE DATE

Date of Approval - No longer used
PAYMENT_SERVER_ORDER_NUMBER VARCHAR2 (80)
Payment Server Order Number - No longer used
PAYMENT_SERVER_TXN_DATE DATE

Payment Server Taxation Date - No longer used
PAYMENT_SERVER_TXN_STATUS VARCHAR2 (80)
Payment Server Taxation Status - No longer used
PAYMENT_SERVER_ERROR_CODE VARCHAR2 (40)
Payment Server Error Code - No longer used
PAYMENT_SERVER_ERROR_MSG VARCHAR2 (255)
Payment Server Error Message - No longer used
BEP_ERROR_CODE VARCHAR2 (40)
Error Code - No longer used
BEP_ERROR_MSG VARCHAR2 (255)
Error Message - No longer used
ERROR_LOCATION NUMBER

Error Location - No longer used
AUTHORIZED_AMOUNT NUMBER

Authorized Amount - No longer used
RECEIPT_METHOD_ID NUMBER (15)
Receipt Method Identifier - No longer used
RECEIPT_METHOD_NAME VARCHAR2 (30)
Receipt Method Name - No longer used
CUSTOMER_BANK_ACCOUNT_ID NUMBER (15)
Bank Account Identifier of the customer - No longer used
CUSTOMER_BANK_ACCOUNT_NAME VARCHAR2 (25)
Customer Bank Account Name - No longer used
PROCESSED_IN_SSA VARCHAR2 (15)
Processed in SSA - No longer used
PAYMENT_METHOD VARCHAR2 (15)
Payment Method - No longer used
PAYMENT_STATUS VARCHAR2 (15)
Payment Status - No longer used
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
SUBACCOUNT_ID NUMBER (15)
OBSOLETE. Sub Account ID that this transaction belongs to
INVOICE_AMOUNT NUMBER

Invoice Transaction Amount
BILL_ID NUMBER

Bill Id that this transaction included in
BILL_NUMBER VARCHAR2 (50)
Bill Number
BILL_DATE DATE

Bill Date
WAIVER_FLAG VARCHAR2 (1)
Waiver Flag - if this Transaction is waived
WAIVER_REASON VARCHAR2 (240)
Waiver Reason - if this Transaction is waived
EFFECTIVE_DATE DATE

Effective Date of this Charge Transaction
INVOICE_NUMBER VARCHAR2 (60)
Invoice Number
EXCHANGE_RATE NUMBER

Exchange Rate for the Transaction , used is the transaction is not in local currency.
BILL_PAYMENT_DUE_DATE DATE

This field would be updated by the Bill Process
SOURCE_TRANSACTION_ID NUMBER (15)
Obsolete - As part of Enh bug #2228910
REQUEST_ID NUMBER (15)
Standard Concurrent Program WHO
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Concurrent Program WHO
PROGRAM_ID NUMBER (15)
Standard Concurrent Program WHO
PROGRAM_UPDATE_DATE DATE

Standard Concurrent Program WHO
OPTIONAL_FEE_FLAG VARCHAR2 (1)
Decline Optional Fee Status
REVERSAL_GL_DATE DATE

The General Ledger Date for the Reversed Charge Record.
TAX_YEAR_CODE VARCHAR2 (30)
Indicates the 1098-T Reporting Tax Year, in which the charge is reported to the Internal Revenue Services
WAIVER_NAME VARCHAR2 (30)
Indicates the Waiver Program Name attached to fee calendar instance for which waiver adjustment charge was created.
Query Text

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


SELECT INVOICE_ID
,      PERSON_ID
,      SPONSOR_CD
,      FEE_TYPE
,      FEE_CAT
,      FEE_CAL_TYPE
,      FEE_CI_SEQUENCE_NUMBER
,      COURSE_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      INVOICE_AMOUNT_DUE
,      INVOICE_CREATION_DATE
,      INVOICE_DESC
,      TRANSACTION_TYPE
,      CURRENCY_CD
,      ACCOUNT_ID
,      TERM_ID
,      STATUS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ORG_ID
,      MERCHANT_ID
,      CREDIT_CARD_CODE
,      CREDIT_CARD_HOLDER_NAME
,      CREDIT_CARD_EXPIRATION_DATE
,      CREDIT_CARD_APPROVAL_CODE
,      CREDIT_CARD_APPROVAL_DATE
,      PAYMENT_SERVER_ORDER_NUMBER
,      PAYMENT_SERVER_TXN_DATE
,      PAYMENT_SERVER_TXN_STATUS
,      PAYMENT_SERVER_ERROR_CODE
,      PAYMENT_SERVER_ERROR_MSG
,      BEP_ERROR_CODE
,      BEP_ERROR_MSG
,      ERROR_LOCATION
,      AUTHORIZED_AMOUNT
,      RECEIPT_METHOD_ID
,      RECEIPT_METHOD_NAME
,      CUSTOMER_BANK_ACCOUNT_ID
,      CUSTOMER_BANK_ACCOUNT_NAME
,      PROCESSED_IN_SSA
,      PAYMENT_METHOD
,      PAYMENT_STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SUBACCOUNT_ID
,      INVOICE_AMOUNT
,      BILL_ID
,      BILL_NUMBER
,      BILL_DATE
,      WAIVER_FLAG
,      WAIVER_REASON
,      EFFECTIVE_DATE
,      INVOICE_NUMBER
,      EXCHANGE_RATE
,      BILL_PAYMENT_DUE_DATE
,      SOURCE_TRANSACTION_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      OPTIONAL_FEE_FLAG
,      REVERSAL_GL_DATE
,      TAX_YEAR_CODE
,      WAIVER_NAME
FROM IGS.IGS_FI_INV_INT_ALL;

Dependencies

[top of page]

IGS.IGS_FI_INV_INT_ALL does not reference any database object

IGS.IGS_FI_INV_INT_ALL is referenced by following:

SchemaAPPS
SynonymIGS_FI_INV_INT_ALL