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

VIEW: APPS.IGSBV_PARTY_REFUNDS

Object Details
Object Name: IGSBV_PARTY_REFUNDS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSBV_PARTY_REFUNDS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Stores all refund transactions, which have been created due to excess unapplied credits.


[View Source]

Columns
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 (71)
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
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 that a calendar instance becomes effective.
CAL_END_EFFECTIVE_DATE DATE
Yes Date from that 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_GL_CODE_COMBINATION_ID NUMBER (38)
General ledger Debit account code combination identifier
CREDIT_GL_CODE_COMBINATION_ID NUMBER (38)
General ledger Credit account code combination identifier
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 identifier 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
Query Text

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
,      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_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.IGSBV_PARTY_REFUNDS;

Dependencies

[top of page]

APPS.IGSBV_PARTY_REFUNDS references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymIGS_CA_INST_ALL
SynonymIGS_FI_FEE_TYPE_ALL
SynonymIGS_FI_INV_INT_ALL
SynonymIGS_FI_REFUNDS

APPS.IGSBV_PARTY_REFUNDS is not referenced by any database object