[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGSFV_PARTY_REFUNDS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGSFV_PARTY_REFUNDS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Stores all refund transactions, which have been created due to excess unapplied credits.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| FEE_TYPE | VARCHAR2 | (10) | Yes | Fee type identifier |
| FEE_CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Fee calendar identifier |
| REVERSAL_INDICATOR | VARCHAR2 | (1) | Indicates that the refund transaction has been reversed. | |
| VOUCHER_DATE | DATE | Yes | Date on which voucher was created | |
| GL_DATE | DATE | The General Ledger Date of the Refund record. | ||
| REFUND_AMOUNT | NUMBER | Yes | Refund amount, cannot be zero. | |
| _LA:TRANSFER_STATUS | CHAR | (72) | Status field for interface processes for selecting records, which have not been transferred to Refunds Interface. The default value is TODO. | |
| REVERSAL_REASON | VARCHAR2 | (2000) | Reason for which the refund transaction has been reversed. | |
| REVERSAL_GL_DATE | DATE | The General Ledger Date used for the Refund Voucher Reversal record. | ||
| DEBIT_ACCOUNT_CODE | VARCHAR2 | (40) | Debit Account code | |
| CREDIT_ACCOUNT_CODE | VARCHAR2 | (40) | Credit Account code | |
| _KF:ACCOUNT_NUMBER:DEBIT | CHAR | (18) | Debit Accounting Flex field | |
| _KF:ACCOUNT_NUMBER:CREDIT | CHAR | (18) | Credit Accounting Flex field | |
| PARTY_NUMBER | VARCHAR2 | (30) | Yes | Party Number |
| PARTY_NAME | VARCHAR2 | (360) | Yes | Party Name |
| PAYEE_PARTY_NUMBER | VARCHAR2 | (30) | Yes | Payee Number |
| PAYEE_PARTY_NAME | VARCHAR2 | (360) | Yes | Payee Name |
| FEE_TYPE_DESCRIPTION | VARCHAR2 | (60) | Yes | Provides a description of the fee type. |
| CAL_START_EFFECTIVE_DATE | DATE | Yes | Date from which a calendar instance becomes effective. | |
| CAL_END_EFFECTIVE_DATE | DATE | Yes | Date from which a calendar instance is no longer effective. | |
| CALENDAR_DESCRIPTION | VARCHAR2 | (30) | Description of calendar type used within the institution. | |
| CALENDAR_ALTERNATE_CODE | VARCHAR2 | (10) | Alternate Code of Calendar | |
| CHARGE_NUMBER | VARCHAR2 | (60) | Invoice Number of charge created for refund transaction | |
| DEBIT_ACCOUNT_CODE_DESC | VARCHAR2 | (60) | Description of the debit account. | |
| CREDIT_ACCOUNT_CODE_DESC | VARCHAR2 | (60) | Description of the credit account. | |
| SOURCE_REFUND_VOUCHER_DATE | DATE | Voucher Date of reversed refund | ||
| _DF | CHAR | (31) | Standard Descriptive Flex Field Column. | |
| DEBIT_GL_CODE_COMBINATION_ID | NUMBER | (38) | Debit Accounting Flex field | |
| CREDIT_GL_CODE_COMBINATION_ID | NUMBER | (38) | Credit Accounting Flex field | |
| REFUND_VOUCHER_IDENTIFIER | NUMBER | (15) | Yes | Sequence generated primary key for the refunds entity, to identify a refund. |
| PARTY_IDENTIFIER | NUMBER | (15) | Yes | Party Identifier |
| PAYEE_PARTY_IDENTIFIER | NUMBER | (15) | Yes | Identifier for payee |
| FEE_CAL_INST_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Fee calendar instance identifier |
| INVOICE_IDENTIFIER | NUMBER | (15) | Invoice id of charge created for refund transaction | |
| SOURCE_REFUND_IDENTIFIER | NUMBER | (15) | Refund identifier of reversed refund | |
| CREATION_DATE | DATE | Yes | Standard who column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT FEE_TYPE
, FEE_CALENDAR_TYPE
, REVERSAL_INDICATOR
, VOUCHER_DATE
, GL_DATE
, REFUND_AMOUNT
, _LA:TRANSFER_STATUS
, REVERSAL_REASON
, REVERSAL_GL_DATE
, DEBIT_ACCOUNT_CODE
, CREDIT_ACCOUNT_CODE
, _KF:ACCOUNT_NUMBER:DEBIT
, _KF:ACCOUNT_NUMBER:CREDIT
, PARTY_NUMBER
, PARTY_NAME
, PAYEE_PARTY_NUMBER
, PAYEE_PARTY_NAME
, FEE_TYPE_DESCRIPTION
, CAL_START_EFFECTIVE_DATE
, CAL_END_EFFECTIVE_DATE
, CALENDAR_DESCRIPTION
, CALENDAR_ALTERNATE_CODE
, CHARGE_NUMBER
, DEBIT_ACCOUNT_CODE_DESC
, CREDIT_ACCOUNT_CODE_DESC
, SOURCE_REFUND_VOUCHER_DATE
, _DF
, DEBIT_GL_CODE_COMBINATION_ID
, CREDIT_GL_CODE_COMBINATION_ID
, REFUND_VOUCHER_IDENTIFIER
, PARTY_IDENTIFIER
, PAYEE_PARTY_IDENTIFIER
, FEE_CAL_INST_SEQUENCE_NUMBER
, INVOICE_IDENTIFIER
, SOURCE_REFUND_IDENTIFIER
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM APPS.IGSFV_PARTY_REFUNDS;
APPS
GL_CODE_COMBINATIONS
HZ_PARTIES
IGS_CA_INST_ALL
IGS_FI_ACC_ALL
IGS_FI_FEE_TYPE_ALL
IGS_FI_INV_INT_ALL
IGS_FI_REFUNDS
APPS.IGSFV_PARTY_REFUNDS is not referenced by any database object
|
|
|
|