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

TABLE: AR.AR_LC_CUST_SITES_T

Object Details
Object Name: AR_LC_CUST_SITES_T
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.AR_LC_CUST_SITES_T
Subobject Name:
Status: VALID


Table which stores the eligible customers for late charge processing


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_LC_CUST_SITES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLC_CUST_SITES_ID
AR_LC_CUST_SITES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
ColumnCUSTOMER_SITE_USE_ID
Columns
Name Datatype Length Mandatory Comments
LC_CUST_SITES_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_PROFILE_ID NUMBER (15)
The Customer Profile Identifier
COLLECTOR_ID NUMBER (15)
The Collector Identifier
LATE_CHARGE_CALCULATION_TRX VARCHAR2 (30)
Eligibility criteria to select transactions for late charge processing
CREDIT_ITEMS_FLAG VARCHAR2 (1)
Indicates whether credit items are considered for late charge processing
DISPUTED_TRANSACTIONS_FLAG VARCHAR2 (1)
Indicates whether disputed transactions are considered for late charge processing
PAYMENT_GRACE_DAYS NUMBER

Maximum number of overdue days allowed before action is taken
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)
HOLD_CHARGED_INVOICES_FLAG VARCHAR2 (1)
Place a hold on charged invoices
MESSAGE_TEXT_ID NUMBER (15)
Message Text Identifier
MULTIPLE_INTEREST_RATES_FLAG VARCHAR2 (1)
Use Multiple Interest Rates for interest calculation
CHARGE_BEGIN_DATE DATE

Date from which the late charge set up is effective
CONS_INV_FLAG VARCHAR2 (1)
Indicates whether Balance Forward Billing is enabled
CONS_BILL_LEVEL VARCHAR2 (30)
Balance Forward Bill level
LAST_CONS_BILL_ID NUMBER (15)
Balance Forward Bill Identifer for the last bill
LAST_CONS_BILL_AMOUNT NUMBER

Last Balance Forward Bill amount
LAST_CONS_BILL_DATE DATE

Last Balance Forward Bill date
LAST_CONS_BILL_DUE_DATE DATE

Last Balance Forward Bill due date
CUST_ACCT_PROFILE_AMT_ID NUMBER (15)
Customer Account Profile Amount Identifier
EXCHANGE_RATE NUMBER (15)
Exchange Rate
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange Rate Type
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
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 which limits the late charge amount
INTEREST_TYPE VARCHAR2 (30)
Indicates fixed amount, percent, charges schedule based interest
INTEREST_RATE NUMBER

Interest Rate for fixed percentage set up
INTEREST_FIXED_AMOUNT NUMBER

Interest for fixed amount set up
INTEREST_SCHEDULE_ID NUMBER (15)
Charge Schedule Identifier for Interest rate
PENALTY_TYPE VARCHAR2 (30)
Indicates fixed amount, percent, charges schedule based penalty
PENALTY_RATE NUMBER

Penalty Rate for fixed percentage set up
PENALTY_FIXED_AMOUNT NUMBER

Penalty for fixed amount set up
PENALTY_SCHEDULE_ID NUMBER (15)
Charge Schedule Identifier for Penalty rate
LAST_ACCRUE_CHARGE_DATE DATE

Late date on which late charge was calculated for this site
ORG_ID NUMBER (15)
Operating Unit Identifier
REQUEST_ID NUMBER (15) Yes Concurrent Request Identifier which created this record
Query Text

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


SELECT LC_CUST_SITES_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      CURRENCY_CODE
,      CUSTOMER_PROFILE_ID
,      COLLECTOR_ID
,      LATE_CHARGE_CALCULATION_TRX
,      CREDIT_ITEMS_FLAG
,      DISPUTED_TRANSACTIONS_FLAG
,      PAYMENT_GRACE_DAYS
,      LATE_CHARGE_TYPE
,      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
,      CONS_INV_FLAG
,      CONS_BILL_LEVEL
,      LAST_CONS_BILL_ID
,      LAST_CONS_BILL_AMOUNT
,      LAST_CONS_BILL_DATE
,      LAST_CONS_BILL_DUE_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
,      ORG_ID
,      REQUEST_ID
FROM AR.AR_LC_CUST_SITES_T;

Dependencies

[top of page]

AR.AR_LC_CUST_SITES_T does not reference any database object

AR.AR_LC_CUST_SITES_T is referenced by following:

SchemaAR
ViewAR_LC_CUST_SITES_T#