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: AR.AR_INTEREST_HEADERS_ALL

Object Details

Object Name:	AR_INTEREST_HEADERS_ALL
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_INTEREST_HEADERS_ALL
Subobject Name:
Status:	VALID

Late Charges interest decoument headers

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_INTEREST_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INTEREST_HEADER_ID
AR_INTEREST_HEADERS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	INTEREST_BATCH_ID INTEREST_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INTEREST_HEADER_ID	NUMBER	(15)	Yes	Primary Key
INTEREST_BATCH_ID	NUMBER	(15)	Yes	Foreign key to ra_interest_batches_all.interest_batch_id
CUSTOMER_ID	NUMBER	(15)	Yes	Foreign key to hz_cust_accounts_all.cust_account_id
CUSTOMER_SITE_USE_ID	NUMBER	(15)	Yes	Foreign Key to hz_cust_site_uses_all.site_use_id
HEADER_TYPE	VARCHAR2	(30)	Yes	Type of late charges documents ADJ, DM, INV
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code from fnd_currencies
LATE_CHARGE_CALCULATION_TRX	VARCHAR2	(30)	Yes	Eligibility criteria to select transactions for late charge processing based on overdue invoices and orlate payments.
CREDIT_ITEMS_FLAG	VARCHAR2	(1)		Eligibility criteria to select transactions for late charge processing based on optional late charges
DISPUTED_TRANSACTIONS_FLAG	VARCHAR2	(1)		Eligibility criteria to select transactions for late charge processing based on optional late charges
PAYMENT_GRACE_DAYS	NUMBER			Receipt grace days
LATE_CHARGE_TERM_ID	NUMBER	(15)		If late charge type is DEBIT_MEMO/INTEREST_INVOICE then the payment term must be populated,this is used to create the Invoice or Debit Memo
INTEREST_PERIOD_DAYS	NUMBER			Days in interest period
INTEREST_CALCULATION_PERIOD	VARCHAR2	(30)		Interest calculation period
CHARGE_ON_FINANCE_CHARGE_FLAG	VARCHAR2	(1)		Formulae on overdue amount to compute interest
HOLD_CHARGED_INVOICES_FLAG	VARCHAR2	(1)		Place a hold on charged invoices
MESSAGE_TEXT_ID	NUMBER	(15)		Message text ar_standard_text.standard_text_id
MULTIPLE_INTEREST_RATES_FLAG	VARCHAR2	(1)		Use Multiple Interest Rates
CHARGE_BEGIN_DATE	DATE			Charge begin date
CUST_ACCT_PROFILE_AMT_ID	NUMBER	(15)		Foreign Key to HZ_CUST_PROFILE_AMTS.CUST_ACCT_PROFILE_AMT_ID
EXCHANGE_RATE	NUMBER	(15)		Exchange rate
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Exchange rate type
MIN_FC_INVOICE_OVERDUE_TYPE	VARCHAR2	(30)		Minimum Invoice amount overdue type
MIN_FC_INVOICE_AMOUNT	NUMBER			Invoice balance threshold amount below which late charges must not be charged.
MIN_FC_INVOICE_PERCENT	NUMBER			Invoice balance threshold percentage below which late charges must not be charged.
MIN_FC_BALANCE_OVERDUE_TYPE	VARCHAR2	(30)		Minimum customer balance overdue type
MIN_FC_BALANCE_AMOUNT	NUMBER			Customer balance threshold amount below which the late charge must not be charged
MIN_FC_BALANCE_PERCENT	NUMBER			Customer balance percentage threshold below which the late charge must not be charged
MIN_INTEREST_CHARGE	NUMBER			Threshold amount below which the late charge must not charged.
MAX_INTEREST_CHARGE	NUMBER			Threshold amount above which the late charge must not be charged.
INTEREST_TYPE	VARCHAR2	(30)		Fixed amount, percent, charges schedule based interest.
INTEREST_RATE	NUMBER			Interest rate
INTEREST_FIXED_AMOUNT	NUMBER			Interest amount
INTEREST_SCHEDULE_ID	NUMBER	(15)		Foreign key to ar_charges_schedules.schedule_id
PENALTY_TYPE	VARCHAR2	(30)		Fixed amount, percent, charges schedule based penalty.
PENALTY_RATE	NUMBER			Penalty rate
PENALTY_FIXED_AMOUNT	NUMBER			Penalty amount
PENALTY_SCHEDULE_ID	NUMBER	(15)		Foreign key to ar_charges_schedules.schedule_id
LAST_ACCRUE_CHARGE_DATE	DATE			Date as of which last compounded
CUSTOMER_PROFILE_ID	NUMBER	(15)		Foreign key to hz_customer_profiles.cust_account_profile_id
COLLECTOR_ID	NUMBER	(15)		Foreign key to collectors entity
LEGAL_ENTITY_ID	NUMBER	(15)		Foreign key of the legal entity
PROCESS_MESSAGE	VARCHAR2	(2000)		Error message text
PROCESS_STATUS	VARCHAR2	(30)		Status code to indicate Success or Error
CUST_TRX_TYPE_ID	NUMBER	(15)		Interest Type i.e. Invoice/Debit Memo, ar_receivables_trx_all.receivable_trx_id
ORG_ID	NUMBER	(15)	Yes	Organization Id
OBJECT_VERSION_NUMBER	NUMBER			Object version number
WORKER_NUM	NUMBER	(15)		Worker Id which created the header for the request id
REQUEST_ID	NUMBER	(15)		Request id which created the header
FINANCE_CHARGE_DATE	DATE			Date as of which the finance charge was generated
LAST_UPDATE_DATE	DATE		Yes	Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Who Column
CREATED_BY	NUMBER	(15)	Yes	Who Column
CREATION_DATE	DATE		Yes	Who Column
DISPLAY_FLAG	VARCHAR2	(1)		For Internal processing only

Query Text

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


SELECT INTEREST_HEADER_ID
,      INTEREST_BATCH_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      HEADER_TYPE
,      CURRENCY_CODE
,      LATE_CHARGE_CALCULATION_TRX
,      CREDIT_ITEMS_FLAG
,      DISPUTED_TRANSACTIONS_FLAG
,      PAYMENT_GRACE_DAYS
,      LATE_CHARGE_TERM_ID
,      INTEREST_PERIOD_DAYS
,      INTEREST_CALCULATION_PERIOD
,      CHARGE_ON_FINANCE_CHARGE_FLAG
,      HOLD_CHARGED_INVOICES_FLAG
,      MESSAGE_TEXT_ID
,      MULTIPLE_INTEREST_RATES_FLAG
,      CHARGE_BEGIN_DATE
,      CUST_ACCT_PROFILE_AMT_ID
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      MIN_FC_INVOICE_OVERDUE_TYPE
,      MIN_FC_INVOICE_AMOUNT
,      MIN_FC_INVOICE_PERCENT
,      MIN_FC_BALANCE_OVERDUE_TYPE
,      MIN_FC_BALANCE_AMOUNT
,      MIN_FC_BALANCE_PERCENT
,      MIN_INTEREST_CHARGE
,      MAX_INTEREST_CHARGE
,      INTEREST_TYPE
,      INTEREST_RATE
,      INTEREST_FIXED_AMOUNT
,      INTEREST_SCHEDULE_ID
,      PENALTY_TYPE
,      PENALTY_RATE
,      PENALTY_FIXED_AMOUNT
,      PENALTY_SCHEDULE_ID
,      LAST_ACCRUE_CHARGE_DATE
,      CUSTOMER_PROFILE_ID
,      COLLECTOR_ID
,      LEGAL_ENTITY_ID
,      PROCESS_MESSAGE
,      PROCESS_STATUS
,      CUST_TRX_TYPE_ID
,      ORG_ID
,      OBJECT_VERSION_NUMBER
,      WORKER_NUM
,      REQUEST_ID
,      FINANCE_CHARGE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      DISPLAY_FLAG
FROM AR.AR_INTEREST_HEADERS_ALL;

Dependencies

[top of page]

AR.AR_INTEREST_HEADERS_ALL does not reference any database object

AR.AR_INTEREST_HEADERS_ALL is referenced by following:

APPS: AR_INTEREST_HEADERS; AR_INTEREST_HEADERS_ALL