eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGI.IGI_DUN_CHARGE_ALL

Object Details

Object Name:	IGI_DUN_CHARGE_ALL
Object Type:	TABLE
Owner:	IGI
FND Design Data:	IGI.IGI_DUN_CHARGE_ALL
Subobject Name:
Status:	VALID

IGI_DUN_CHARGE_ALL temporarily holds the calculated charges for a dunning charge run.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGI_DUN_CHARGE_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INVOICE_CURRENCY_CODE PAYMENT_SCHEDULE_ID REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
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).
INVOICE_CURRENCY_CODE	VARCHAR2	(15)	Yes	Identifier of invoice currency
PAYMENT_SCHEDULE_ID	NUMBER	(15)	Yes	Identifies associated payment schedule
CUSTOMER_ID	NUMBER	(15)	Yes	Identifier of customer associated with this profile
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)		Transaction 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
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
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 Invoice (I). Adjustment Type will create adjustments in Receivables.
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 REQUEST_ID
,      INVOICE_CURRENCY_CODE
,      PAYMENT_SCHEDULE_ID
,      CUSTOMER_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
,      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
,      CHARGE_PER_INVOICE
,      DUNNING_CHARGE_TYPE
,      APP_CHARGE_RATIO
,      CHARGE_VALUE
,      CUST_CHARGE_VALUE
,      RULE
FROM IGI.IGI_DUN_CHARGE_ALL;

Dependencies

[top of page]

IGI.IGI_DUN_CHARGE_ALL does not reference any database object

IGI.IGI_DUN_CHARGE_ALL is referenced by following:

IGI: IGI_DUN_CHARGE_ALL#