[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_FI_REFUNDS |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_FI_REFUNDS
|
| Subobject Name: | |
| Status: | VALID |
Stores all refund transactions which have been created due to excess unapplied credits.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGS_FI_REFUNDS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 REFUND_ID
|
| IGS_FI_REFUNDS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
PERSON_ID
PAY_PERSON_ID
FEE_TYPE
FEE_CAL_TYPE
FEE_CI_SEQUENCE_NUMBER
REVERSAL_IND
INVOICE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REFUND_ID | NUMBER | (15) | Yes | Sequence generated primary key. |
| VOUCHER_DATE | DATE | Yes | Date on which voucher was created | |
| PERSON_ID | NUMBER | (15) | Yes | Person Identifier |
| PAY_PERSON_ID | NUMBER | (15) | Yes | Identifier for payee |
| DR_GL_CCID | NUMBER | (38) | General ledger account code combination identifier | |
| CR_GL_CCID | NUMBER | (38) | General ledger account code combination identifier | |
| DR_ACCOUNT_CD | VARCHAR2 | (40) | Account code | |
| CR_ACCOUNT_CD | VARCHAR2 | (40) | Account code | |
| REFUND_AMOUNT | NUMBER | Yes | Refund amount,cannot be zero. | |
| FEE_TYPE | VARCHAR2 | (10) | Yes | Fee type identifier |
| FEE_CAL_TYPE | VARCHAR2 | (10) | Yes | Fee calendar identifier |
| FEE_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | fee calendar instance identifier |
| PAYMENT_NUMBER | VARCHAR2 | (40) | Payment number - No longer used | |
| PAYMENT_DATE | DATE | Payment date - No longer used | ||
| PAYMENT_MODE | VARCHAR2 | (30) | Mode of payment i.e. CHECK or EFT - No longer used | |
| SOURCE_REFUND_ID | NUMBER | (15) | refund id of reversed charge | |
| INVOICE_ID | NUMBER | (15) | Invoice id of charge created for refund transaction | |
| TRANSFER_STATUS | VARCHAR2 | (30) | Status field for interface processes for selecting records which have not been transferred to Refunds Interface.The default value is TODO. | |
| REVERSAL_IND | VARCHAR2 | (1) | Mandatory if the refund transaction has been reversed. | |
| REASON | VARCHAR2 | (2000) | Mandatory if refunds transaction has been reversed. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| 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) | Concurrent manager columns | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent manager columns | |
| PROGRAM_ID | NUMBER | (15) | Concurrent manager columns | |
| PROGRAM_UPDATE_DATE | DATE | Concurrent manager column | ||
| GL_DATE | DATE | The General Ledger Date of the Refund record. | ||
| REVERSAL_GL_DATE | DATE | The General Ledger Date used for the Refund Voucher Reversal record. |
Cut, paste (and edit) the following text to query this object:
SELECT REFUND_ID
, VOUCHER_DATE
, PERSON_ID
, PAY_PERSON_ID
, DR_GL_CCID
, CR_GL_CCID
, DR_ACCOUNT_CD
, CR_ACCOUNT_CD
, REFUND_AMOUNT
, FEE_TYPE
, FEE_CAL_TYPE
, FEE_CI_SEQUENCE_NUMBER
, PAYMENT_NUMBER
, PAYMENT_DATE
, PAYMENT_MODE
, SOURCE_REFUND_ID
, INVOICE_ID
, TRANSFER_STATUS
, REVERSAL_IND
, REASON
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, GL_DATE
, REVERSAL_GL_DATE
FROM IGS.IGS_FI_REFUNDS;
IGS.IGS_FI_REFUNDS does not reference any database object
IGS.IGS_FI_REFUNDS is referenced by following:
APPS
IGS_FI_REFUNDS
|
|
|
|