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

VIEW: APPS.IGI_DUN_CHARGE

Object Details
Object Name: IGI_DUN_CHARGE
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGI.IGI_DUN_CHARGE
Subobject Name:
Status: VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.


IGI_DUN_CHARGE is a multi-org view which temporarily holds the calculated charges for a dunning charge run. It is based on IGI_DUN_CHARGE_ALL table.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CUSTOMER_ID NUMBER (15) Yes Identifier of customer associated with this profile
REQUEST_ID NUMBER (15) Yes Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
CUSTOMER_NUMBER VARCHAR2 (30)
Stores customer number assigned to customer by users
CUSTOMER_NAME VARCHAR2 (50)
Customer name
SITE_USE_ID NUMBER (15)
Site use identifier
ORG_ID NUMBER (15)
Organization identifier
CUSTOMER_TRX_ID NUMBER (15) Yes Unique identifier of customer transaction
TRX_NUMBER VARCHAR2 (20)
Transation not generated by user or third party systems
CUST_TRX_TYPE_ID NUMBER (15)
Transaction type identifier
SET_OF_BOOKS_ID NUMBER (15) Yes Set of Books identifier
TRX_DATE DATE

Transaction date
BILL_TO_CUSTOMER_ID NUMBER (15)
Billing address of customer identifier
BILL_TO_CONTACT_ID NUMBER (15)
Identifier of contact at customer billing address
AMOUNT_DUE_ORIGINAL NUMBER

Original invoice amount
AMOUNT_DUE_REMAINING NUMBER

Invoice amount at time of dunning run
SUM_AMT NUMBER

Summary amount
INVOICE_CURRENCY_CODE VARCHAR2 (15) Yes Identifier of invoice currency
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CUSTOMER_PROFILE_CLASS_ID NUMBER

Customer profile class identifier
DUNNING_CHARGE NUMBER

Charge for dunning letter within dunning letter set
DUNNING_LETTER_ID NUMBER (15) Yes Identifier for dunning letter that printed for this dunning letter set
DUNNING_LETTER_SET_ID NUMBER (15) Yes Identifier for dunning letter that printed for this dunning letter set
LETTER_NAME VARCHAR2 (24)
Letter name
PAYMENT_SCHEDULE_ID NUMBER (15) Yes Identifies associated payment schedule
CHARGE_PER_INVOICE NUMBER

Charge per invoice for dunning letter within dunning letter set
DUNNING_CHARGE_TYPE VARCHAR2 (1) Yes Dunning Charge Type to be created, Adjustment (A), or (I)nvoice.Adjustment Type will create adjustements in Receivables, Invoice Type will call AutoInvoice and create an invoice detailing the charges.
APP_CHARGE_RATIO NUMBER (9)
Apportionment charge ratio
CHARGE_VALUE NUMBER

Value of charge to be posted against invoice
CUST_CHARGE_VALUE NUMBER

Customer charge value
RULE VARCHAR2 (3)
Apportion charge per invoice, INV, or per letter, LET
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CUSTOMER_ID
,      REQUEST_ID
,      CUSTOMER_NUMBER
,      CUSTOMER_NAME
,      SITE_USE_ID
,      ORG_ID
,      CUSTOMER_TRX_ID
,      TRX_NUMBER
,      CUST_TRX_TYPE_ID
,      SET_OF_BOOKS_ID
,      TRX_DATE
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_CONTACT_ID
,      AMOUNT_DUE_ORIGINAL
,      AMOUNT_DUE_REMAINING
,      SUM_AMT
,      INVOICE_CURRENCY_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CUSTOMER_PROFILE_CLASS_ID
,      DUNNING_CHARGE
,      DUNNING_LETTER_ID
,      DUNNING_LETTER_SET_ID
,      LETTER_NAME
,      PAYMENT_SCHEDULE_ID
,      CHARGE_PER_INVOICE
,      DUNNING_CHARGE_TYPE
,      APP_CHARGE_RATIO
,      CHARGE_VALUE
,      CUST_CHARGE_VALUE
,      RULE
FROM APPS.IGI_DUN_CHARGE;

Dependencies

[top of page]

APPS.IGI_DUN_CHARGE references the following:

SchemaAPPS
SynonymIGI_DUN_CHARGE_ALL

APPS.IGI_DUN_CHARGE is not referenced by any database object