[Home] [Help] [Dependency Information]
Object Name: | IGS_FI_COM_RECS_INT |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_FI_COM_RECS_INT |
Subobject Name: | |
Status: | VALID |
Commercial Receivables Open Interface table.
An interface table for exporting student finance transaction to a Commercial Receivables System.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Commercial Receivables Transactions Extract
Category: BUSINESS_ENTITY IGS_PARTY_CHARGE
Category: BUSINESS_ENTITY IGS_PARTY_CREDIT
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_FI_COM_RECS_INT_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TRANSACTION_CATEGORY
TRANSACTION_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_CATEGORY | VARCHAR2 | (30) | Yes | This column indicates the type of the Transaction. The valid values are Charge and Credit. |
TRANSACTION_HEADER_ID | NUMBER | Yes | This column indicates the unique identifier for the Charge or Credit Transaction. | |
TRANSACTION_NUMBER | VARCHAR2 | (60) | Yes | Transaction Number of the Transaction. |
PARTY_ID | NUMBER | Yes | Unique Identifier for the Party. | |
TRANSACTION_DATE | DATE | Yes | Transaction Date for the transaction. | |
EFFECTIVE_DATE | DATE | Yes | Effective Date of the transaction. | |
FEE_TYPE | VARCHAR2 | (10) | Fee Type for the Charge Transaction. Null for the Credit Transaction. | |
S_FEE_TYPE | VARCHAR2 | (10) | System Fee Type identifier for the Charge transaction. Null for the Credit Transaction. | |
FEE_CAL_TYPE | VARCHAR2 | (10) | This column indicates the Fee Calendar Type for the Charge or Credit transaction. | |
FEE_CI_SEQUENCE_NUMBER | NUMBER | (6) | This column indicates the Fee Calendar Instance for the Charge or Credit transaction. | |
FEE_CATEGORY | VARCHAR2 | (10) | This column indicates the Fee Category for the Charge Transaction. | |
COURSE_CD | VARCHAR2 | (10) | This column indicates the Program Code for the Charge transaction. | |
ATTENDANCE_MODE | VARCHAR2 | (2) | This column indicates the Attendance Mode for the Charge Transaction. | |
ATTENDANCE_TYPE | VARCHAR2 | (2) | This column indicates the Attendance Type for the Charge Transaction. | |
COURSE_DESCRIPTION | VARCHAR2 | (90) | This column indicates the Program Description of the Program Code. | |
REVERSAL_FLAG | VARCHAR2 | (1) | This column indicates the Reversal Flag for the Charge transaction. | |
REVERSAL_REASON | VARCHAR2 | (240) | This column indicates the Reversal Reason for the Charge transaction. | |
LINE_NUMBER | NUMBER | (15) | This column indicates the Line Number of the Charge or credit transaction. | |
TRANSACTION_LINE_ID | NUMBER | (15) | This column indicates the Line Identifier for the transaction. | |
CHARGE_METHOD_TYPE | VARCHAR2 | (30) | This column indicates the Charge Method Type for the Charge transaction. | |
DESCRIPTION | VARCHAR2 | (240) | This column indicates the Description for the Charge transaction. | |
CHARGE_ELEMENTS | NUMBER | This column indicates the Charge Elements for the Charge transaction. | ||
AMOUNT | NUMBER | Yes | This column indicates the Amount for the Charge transaction. | |
CREDIT_POINTS | NUMBER | This column indicates the Credit Points for the Charge transaction. | ||
UNIT_OFFERING_OPTION_ID | NUMBER | (7) | This column indicates the Unit Offering Option Identifier for the Charge transaction. | |
CREDIT_GL_CODE_COMBINATION_ID | NUMBER | This column indicates the Credit Code Combination Identifier for the Charge or Credit transaction. | ||
DEBIT_GL_CODE_COMBINATION_ID | NUMBER | This column indicates the Debit Code Combination Identifier for the Charge or Credit transaction. | ||
CREDIT_ACCOUNT_CODE | VARCHAR2 | (40) | This column indicates the Credit Account Code for the Charge or Credit transaction. | |
DEBIT_ACCOUNT_CODE | VARCHAR2 | (40) | This column indicates the Debit Account Code for the Charge or Credit transaction. | |
ORG_UNIT_CD | VARCHAR2 | (30) | This column indicates the Organization Unit Code for the Charge transaction. | |
LOCATION_CD | VARCHAR2 | (10) | This column indicates the Location Code for the Charge transaction. | |
GL_DATE | DATE | Yes | GL Date for the Charge or Credit transaction. | |
CREDIT_TYPE_ID | NUMBER | (15) | This column indicates the Credit Type Identifier for the Credit transaction. | |
CREDIT_CLASS | VARCHAR2 | (30) | This column indicates the Credit Class for the Credit transaction. | |
CURRENCY_CD | VARCHAR2 | (15) | Yes | This column indicates the Currency Code for the Charge or Credit transaction. |
EXTRACT_FLAG | VARCHAR2 | (1) | Single character field updated by Institution's own extract process. | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column. |
CREATION_DATE | DATE | Yes | Standard Who Column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column. | |
REQUEST_ID | NUMBER | (15) | Standard Concurrent Program Who Column. | |
PROGRAM_ID | NUMBER | (15) | Standard Concurrent Program Who Column. | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Concurrent Program Who Column. | |
PROGRAM_UPDATE_DATE | DATE | Standard Concurrent Program Who Column. | ||
STUDENT_PARTY_ID | NUMBER | (15) | Party Identifier for the Student | |
SOURCE_INVOICE_ID | NUMBER | (15) | Invoice Identifier for the Source Invoice transaction |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_CATEGORY
, TRANSACTION_HEADER_ID
, TRANSACTION_NUMBER
, PARTY_ID
, TRANSACTION_DATE
, EFFECTIVE_DATE
, FEE_TYPE
, S_FEE_TYPE
, FEE_CAL_TYPE
, FEE_CI_SEQUENCE_NUMBER
, FEE_CATEGORY
, COURSE_CD
, ATTENDANCE_MODE
, ATTENDANCE_TYPE
, COURSE_DESCRIPTION
, REVERSAL_FLAG
, REVERSAL_REASON
, LINE_NUMBER
, TRANSACTION_LINE_ID
, CHARGE_METHOD_TYPE
, DESCRIPTION
, CHARGE_ELEMENTS
, AMOUNT
, CREDIT_POINTS
, UNIT_OFFERING_OPTION_ID
, CREDIT_GL_CODE_COMBINATION_ID
, DEBIT_GL_CODE_COMBINATION_ID
, CREDIT_ACCOUNT_CODE
, DEBIT_ACCOUNT_CODE
, ORG_UNIT_CD
, LOCATION_CD
, GL_DATE
, CREDIT_TYPE_ID
, CREDIT_CLASS
, CURRENCY_CD
, EXTRACT_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, STUDENT_PARTY_ID
, SOURCE_INVOICE_ID
FROM IGS.IGS_FI_COM_RECS_INT;
IGS.IGS_FI_COM_RECS_INT does not reference any database object
IGS.IGS_FI_COM_RECS_INT is referenced by following:
|
|
|