[Home] [Help] [Dependency Information]
Object Name: | IGS_FI_ANC_INT_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_FI_ANC_INT_ALL |
Subobject Name: | |
Status: | VALID |
The interface table for the Ancillary attributes for the students.
An interface table for the import of Ancillary attributes of the students.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import and Calculate Ancillary Charges
Category: BUSINESS_ENTITY IGS_PARTY_CHARGE
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_FI_ANC_INT_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ANCILLARY_INT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ANCILLARY_INT_ID | NUMBER | (15) | Yes | The unique identifier which distinguishes the interface records. |
PERSON_ID | NUMBER | (15) | A unique identification number, used to identify a particular person. | |
PERSON_ID_TYPE | VARCHAR2 | (10) | The Alternate Person ID Type used to classify the Alternate person ID | |
API_PERSON_ID | VARCHAR2 | (20) | Alternate identification for a Person . | |
STATUS | VARCHAR2 | (30) | Yes | Holds the status of the record. The different statuses are 'TODO' , 'ERROR' , 'SUCCESS' |
FEE_TYPE | VARCHAR2 | (10) | Yes | This field describes the fee types used for the purpose of applying fees and charges. |
FEE_CAL_TYPE | VARCHAR2 | (10) | Yes | The code of a Fee calendar type which defines the period of time in which the fee type will operate. |
FEE_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | This field uniquely identifies the calendar instance. |
OVERRIDE_DR_REC_ACCOUNT_CD | VARCHAR2 | (40) | Receivables Account Code. Used if Oracle Accounts Receivables is not Installed.This column is OBSOLETE | |
OVERRIDE_DR_REC_CCID | NUMBER | (15) | Receivables Account Flex Field (Code Combination ID) . Used if Oracle Receivables is installed.This column is OBSOLETE | |
OVERRIDE_CR_REV_ACCOUNT_CD | VARCHAR2 | (40) | Revenue Account Code. Used if Oracle Accounts Receivables is not Installed.This column is OBSOLETE | |
OVERRIDE_CR_REV_CCID | NUMBER | (15) | Revenue Account Flex Field (Code Combination ID) . Used if Oracle Receivables is installed.This column is OBSOLETE. | |
ANCILLARY_ATTRIBUTE1 | VARCHAR2 | (30) | Ancillary Attributes for the Student | |
ANCILLARY_ATTRIBUTE2 | VARCHAR2 | (30) | Ancillary Attributes for the Student | |
ANCILLARY_ATTRIBUTE3 | VARCHAR2 | (30) | Ancillary Attributes for the Student | |
ANCILLARY_ATTRIBUTE4 | VARCHAR2 | (30) | Ancillary Attributes for the Student | |
ANCILLARY_ATTRIBUTE5 | VARCHAR2 | (30) | Ancillary Attributes for the Student | |
ANCILLARY_ATTRIBUTE6 | VARCHAR2 | (30) | Ancillary Attributes for the Student | |
ANCILLARY_ATTRIBUTE7 | VARCHAR2 | (30) | Ancillary Attributes for the Student | |
ANCILLARY_ATTRIBUTE8 | VARCHAR2 | (30) | Ancillary Attributes for the Student | |
ANCILLARY_ATTRIBUTE9 | VARCHAR2 | (30) | Ancillary Attributes for the Student | |
ANCILLARY_ATTRIBUTE10 | VARCHAR2 | (30) | Ancillary Attributes for the Student | |
ANCILLARY_ATTRIBUTE11 | VARCHAR2 | (30) | Ancillary Attributes for the Student | |
ANCILLARY_ATTRIBUTE12 | VARCHAR2 | (30) | Ancillary Attributes for the Student | |
ANCILLARY_ATTRIBUTE13 | VARCHAR2 | (30) | Ancillary Attributes for the Student | |
ANCILLARY_ATTRIBUTE14 | VARCHAR2 | (30) | Ancillary Attributes for the Student | |
ANCILLARY_ATTRIBUTE15 | VARCHAR2 | (30) | Ancillary Attributes for the Student | |
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 | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ORG_ID | NUMBER | (15) | Operating Unit Identifier | |
EFFECTIVE_DT | DATE | The date from which the charges are effective. | ||
TRANSACTION_DT | DATE | The Date of the transaction - OBSOLETE. | ||
ERROR_MSG | VARCHAR2 | (2000) | Holds the error message if Ancillary Charge calculation failed. | |
VALIDATION_FLAG | VARCHAR2 | (1) | This denotes whether the data elements entered are validated or not. The valid values are 'Y' and 'N'. If 'Y' they are not validated again in the process for importing the attributes | |
REQUEST_ID | NUMBER | (15) | Concurrent Manager WHO Columns | |
PROGRAM_ID | NUMBER | (15) | Concurrent Manager WHO Columns | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Manager WHO Columns | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Manager WHO Columns | ||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT ANCILLARY_INT_ID
, PERSON_ID
, PERSON_ID_TYPE
, API_PERSON_ID
, STATUS
, FEE_TYPE
, FEE_CAL_TYPE
, FEE_CI_SEQUENCE_NUMBER
, OVERRIDE_DR_REC_ACCOUNT_CD
, OVERRIDE_DR_REC_CCID
, OVERRIDE_CR_REV_ACCOUNT_CD
, OVERRIDE_CR_REV_CCID
, ANCILLARY_ATTRIBUTE1
, ANCILLARY_ATTRIBUTE2
, ANCILLARY_ATTRIBUTE3
, ANCILLARY_ATTRIBUTE4
, ANCILLARY_ATTRIBUTE5
, ANCILLARY_ATTRIBUTE6
, ANCILLARY_ATTRIBUTE7
, ANCILLARY_ATTRIBUTE8
, ANCILLARY_ATTRIBUTE9
, ANCILLARY_ATTRIBUTE10
, ANCILLARY_ATTRIBUTE11
, ANCILLARY_ATTRIBUTE12
, ANCILLARY_ATTRIBUTE13
, ANCILLARY_ATTRIBUTE14
, ANCILLARY_ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ORG_ID
, EFFECTIVE_DT
, TRANSACTION_DT
, ERROR_MSG
, VALIDATION_FLAG
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_FI_ANC_INT_ALL;
IGS.IGS_FI_ANC_INT_ALL does not reference any database object
IGS.IGS_FI_ANC_INT_ALL is referenced by following:
|
|
|