AR_LC_CUST_SITES_T
Table which stores the eligible customers for late charge processing
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AR_LC_CUST_SITES_PK |
LC_CUST_SITES_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LC_CUST_SITES_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_PROFILE_ID | NUMBER | 18 | The Customer Profile Identifier | ||
| COLLECTOR_ID | NUMBER | 18 | 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 | 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) | ||
| HOLD_CHARGED_INVOICES_FLAG | VARCHAR2 | 1 | Place a hold on charged invoices | ||
| 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. | ||
| 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. Can either the customer account or customer site. | ||
| LAST_CONS_BILL_ID | NUMBER | 18 | Balance Forward Bill Identifier 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 | 18 | Customer Account Profile Amount Identifier | ||
| EXCHANGE_RATE | NUMBER | 18 | Conversion rate. | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Conversion 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 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 | 18 | 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 | 18 | 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 | 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. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| AR_LC_CUST_SITES_U1 | Unique | LC_CUST_SITES_ID |
| AR_LC_CUST_SITES_N1 | Non Unique | REQUEST_ID, CUSTOMER_SITE_USE_ID |