AR_LATE_CHARGE_TRX_T

Table which stores the eligible transactions for late charge processing

Details

• Schema: FUSION

• Object owner: AR

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
AR_LATE_CHARGE_TRX_PK	LATE_CHARGE_TRX_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
LATE_CHARGE_TRX_ID	NUMBER		18	Yes	The primary column for this table
CUSTOMER_ID	NUMBER		18		The Customer Identifier
CUSTOMER_SITE_USE_ID	NUMBER		18		The Customer Site Use Identifier for the Bill To Site
CURRENCY_CODE	VARCHAR2	15			Currency Code
CUSTOMER_TRX_ID	NUMBER		18		The Customer Transaction Identifier for the Eligible Items
LEGAL_ENTITY_ID	NUMBER		18		The Legal Entity Identifier
PAYMENT_SCHEDULE_ID	NUMBER		18		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				Amount of the late charge already charged.
TRX_DATE	DATE				Transaction Date of the Eligible Items
LAST_CHARGE_DATE	DATE				The last date on which late charge was computed on the item
EXCHANGE_RATE	NUMBER		18		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 eligible items.
RECEIPT_DATE	DATE				Receipt date of the Eligible Receipts
FINANCE_CHARGE_DATE	DATE				The date on which the late charges are calculated.
CHARGE_TYPE	VARCHAR2	30			The charge type indicates the basis of late charge computation if OVERDUE, LATE, AG_DAILY_BALANCE (average 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				Amount of calculated late charge.
LATE_CHARGE_TYPE	VARCHAR2	30			Document that will be created by the late charges program
LATE_CHARGE_TERM_ID	NUMBER		18		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		18		Message text field identifier that allows messages to print on late charge invoices and debit memos. This is a foreign key to AR_STANDARD_TEXT.STANDARD_TEXT_ID.
INTEREST_TYPE	VARCHAR2	30			Indicates fixed amount, percent, charges schedule based interest
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
CHARGE_LINE_TYPE	VARCHAR2	30			Indicates whether this line is a INTEREST or PENALTY
ORG_ID	NUMBER		18	Yes	Indicates the identifier of the business unit associated to the row.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
DISPLAY_FLAG	VARCHAR2	1			Oracle internal use only.
CUST_TRX_TYPE_SEQ_ID	NUMBER		18		Transaction type sequence identifier.

Foreign Keys

Table	Foreign Table	Foreign Key Column
AR_LATE_CHARGE_TRX_T	hz_cust_accounts	CUSTOMER_ID
AR_LATE_CHARGE_TRX_T	hz_cust_site_uses_all	CUSTOMER_SITE_USE_ID
AR_LATE_CHARGE_TRX_T	ra_customer_trx_all	CUSTOMER_TRX_ID
AR_LATE_CHARGE_TRX_T	xle_entity_profiles	LEGAL_ENTITY_ID
AR_LATE_CHARGE_TRX_T	ar_payment_schedules_all	PAYMENT_SCHEDULE_ID
AR_LATE_CHARGE_TRX_T	ra_terms_b	LATE_CHARGE_TERM_ID
AR_LATE_CHARGE_TRX_T	ar_standard_text_b	MESSAGE_TEXT_ID
AR_LATE_CHARGE_TRX_T	ra_cust_trx_types_all	CUST_TRX_TYPE_SEQ_ID

Indexes

Index	Uniqueness	Tablespace	Columns
AR_LATE_CHARGE_TRX_U1	Unique	Default	LATE_CHARGE_TRX_ID
AR_LATE_CHARGE_TRX_N1	Non Unique	Default	CUSTOMER_ID, CUSTOMER_SITE_USE_ID, CURRENCY_CODE, ORG_ID