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_LATE_CHARGE_TRX_T

Object Details

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

Table which stores the eligible transactions for late charge processing

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_LATE_CHARGE_TRX_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LATE_CHARGE_TRX_ID
AR_LATE_CHARGE_TRX_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID CUSTOMER_SITE_USE_ID CURRENCY_CODE ORG_ID
AR_LATE_CHARGE_TRX_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID CUSTOMER_SITE_USE_ID
AR_LATE_CHARGE_TRX_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_SCHEDULE_ID DISPLAY_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
LATE_CHARGE_TRX_ID	NUMBER	(15)	Yes	The primary column for this table
CUSTOMER_ID	NUMBER	(15)		The Customer Identifier
CUSTOMER_SITE_USE_ID	NUMBER	(15)		The Customer Site Use Identifier for the Bill To Site
CURRENCY_CODE	VARCHAR2	(15)		Currency Code
CUSTOMER_TRX_ID	NUMBER	(15)		The Customer Transaction Identifier for the Eligible Items
LEGAL_ENTITY_ID	NUMBER	(15)		The Legal Entity Identifier
PAYMENT_SCHEDULE_ID	NUMBER	(15)		The Payment Schedule Identifier for the Eligible Items
CLASS	VARCHAR2	(30)		Indicates the Transaction Class associated with the Eligible Items
AMOUNT_DUE_ORIGINAL	NUMBER			Amount Due Original of the Eligible Items
AMOUNT_DUE_REMAINING	NUMBER			Amount Due Remaining of the Eligible Items
FIN_CHARGE_CHARGED	NUMBER			Finance charge Already charged
TRX_DATE	DATE			Transaction Date of the Eligible Items
CUST_TRX_TYPE_ID	NUMBER	(15)		Transaction Type Identifier for the Eligible Items
LAST_CHARGE_DATE	DATE			The last date on which late charge was computed on the item
EXCHANGE_RATE	NUMBER	(15)		Exchange Rate of the eligible items
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Exchange Rate Type of the eligible items
MIN_INTEREST_CHARGE	NUMBER			Threshold amount below which the late charge must not charged
MAX_INTEREST_CHARGE	NUMBER			Threshold amount which limits the late charge amount
OVERDUE_LATE_PAY_AMOUNT	NUMBER			The amount on which finance charge is computed
ORIGINAL_BALANCE	NUMBER			The balance as of the finance charge date or receipt application date
DUE_DATE	DATE			Due date of the Eligible Items
RECEIPT_DATE	DATE			Receipt date of the Eligible Receipts
FINANCE_CHARGE_DATE	DATE			Date as of which the Late Chargs are calculated
CHARGE_TYPE	VARCHAR2	(30)		Indicates the basis of late charge computation. Whether OVERDUE / LATE / AG_DAILY_BALANCE or PENALTY
ACTUAL_DATE_CLOSED	DATE			Date on which the eligible item is closed
INTEREST_RATE	NUMBER			Applicable Interest Rate
INTEREST_DAYS	NUMBER			Number of days for which Interest will be charged
RATE_START_DATE	DATE			The start date on which the rate is active
RATE_END_DATE	DATE			The end date active for the rate
SCHEDULE_DAYS_START	NUMBER			Indicates the minimum days late for which the rate schedule is effective
SCHEDULE_DAYS_TO	NUMBER			Indicates the maximum days late for which the rate schedule is effective
LATE_CHARGE_AMOUNT	NUMBER			Calculated late charge
LATE_CHARGE_TYPE	VARCHAR2	(30)		Document that will be created by the late charges program
LATE_CHARGE_TERM_ID	NUMBER	(15)		Payment Term Identifier used for creating Interest Invoice or Debit Memo
INTEREST_PERIOD_DAYS	NUMBER			Days in interest period
INTEREST_CALCULATION_PERIOD	VARCHAR2	(30)		Indicates whether the interest calculation is Daily or Monthly
CHARGE_ON_FINANCE_CHARGE_FLAG	VARCHAR2	(1)		Formula used for interest calculation. Simple(N), Compound(Y) and Flat(F)
MESSAGE_TEXT_ID	NUMBER	(15)		Message Text Identifier
INTEREST_TYPE	VARCHAR2	(30)		Indicates fixed amount, percent, charges schedule based interest
MIN_FC_INVOICE_OVERDUE_TYPE	VARCHAR2	(30)		Mimimum 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
CHARGE_LINE_TYPE	VARCHAR2	(30)		Indicates whether this line is a INTEREST or PENALTY
ORG_ID	NUMBER	(15)		Operating Unit Identifier
REQUEST_ID	NUMBER	(15)	Yes	Concurrent Request Identifier which created this record
DISPLAY_FLAG	VARCHAR2	(1)		For Internal processing only

Query Text

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


SELECT LATE_CHARGE_TRX_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      CURRENCY_CODE
,      CUSTOMER_TRX_ID
,      LEGAL_ENTITY_ID
,      PAYMENT_SCHEDULE_ID
,      CLASS
,      AMOUNT_DUE_ORIGINAL
,      AMOUNT_DUE_REMAINING
,      FIN_CHARGE_CHARGED
,      TRX_DATE
,      CUST_TRX_TYPE_ID
,      LAST_CHARGE_DATE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      MIN_INTEREST_CHARGE
,      MAX_INTEREST_CHARGE
,      OVERDUE_LATE_PAY_AMOUNT
,      ORIGINAL_BALANCE
,      DUE_DATE
,      RECEIPT_DATE
,      FINANCE_CHARGE_DATE
,      CHARGE_TYPE
,      ACTUAL_DATE_CLOSED
,      INTEREST_RATE
,      INTEREST_DAYS
,      RATE_START_DATE
,      RATE_END_DATE
,      SCHEDULE_DAYS_START
,      SCHEDULE_DAYS_TO
,      LATE_CHARGE_AMOUNT
,      LATE_CHARGE_TYPE
,      LATE_CHARGE_TERM_ID
,      INTEREST_PERIOD_DAYS
,      INTEREST_CALCULATION_PERIOD
,      CHARGE_ON_FINANCE_CHARGE_FLAG
,      MESSAGE_TEXT_ID
,      INTEREST_TYPE
,      MIN_FC_INVOICE_OVERDUE_TYPE
,      MIN_FC_INVOICE_AMOUNT
,      MIN_FC_INVOICE_PERCENT
,      CHARGE_LINE_TYPE
,      ORG_ID
,      REQUEST_ID
,      DISPLAY_FLAG
FROM AR.AR_LATE_CHARGE_TRX_T;

Dependencies

[top of page]

AR.AR_LATE_CHARGE_TRX_T does not reference any database object

AR.AR_LATE_CHARGE_TRX_T is referenced by following:

APPS: AR_LATE_CHARGE_TRX_T