[Home] [Help] [Dependency Information]
Object Name: | OKL_LTE_CHRG_SETUPS |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_LTE_CHRG_SETUPS |
Subobject Name: | |
Status: | VALID |
When a lessee/borrower does not pay an invoice prior to the due date, a penalty can be assessed. This penalty can be done in two ways.
The first method is a one-time fee charged after a grace period.
The second method is to charge interest when payment is made.
This can be state specific.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_LTE_CHRG_SETUPS_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE | ID |
OKL_LTE_CHRG_SETUPS_U2 | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
ISE_ID
PDT_ID |
LCS_PDT_FK_I | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | PDT_ID |
LCS_TDF_FK_I | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | TDF_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
ISE_ID | NUMBER | Yes | Foreign Key to view OKX_STATES_V | |
PDT_ID | NUMBER | Yes | Foreign key to table OKL_PRODUCTS | |
TDF_ID | NUMBER | Foreign Key to table OKL_TUOM_DFNTNS_B | ||
DESCRIPTION | VARCHAR2 | (1995) | Yes | User entered description |
ALLOWED_YN | VARCHAR2 | (3) | Yes | Whether late charge is applicable |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
FIXED_YN | VARCHAR2 | (3) | Fixed Amount or Percentage of Balance | |
AMOUNT | NUMBER | (14) | Amount | |
FIXED_RATE | NUMBER | (5) | Only if FIXED YN = 'N' | |
GRACE_PERIOD | NUMBER | (4) | Number of days before penalty is assesed | |
MINIMUM_BALANCE | NUMBER | (14) | Monetary amount | |
MINIMUM_LATE_CHARGE | NUMBER | (14) | Monetary amount | |
MAXIMUM_LATE_CHARGE | NUMBER | (14) | Monetary amount | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, ISE_ID
, PDT_ID
, TDF_ID
, DESCRIPTION
, ALLOWED_YN
, OBJECT_VERSION_NUMBER
, FIXED_YN
, AMOUNT
, FIXED_RATE
, GRACE_PERIOD
, MINIMUM_BALANCE
, MINIMUM_LATE_CHARGE
, MAXIMUM_LATE_CHARGE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM OKL.OKL_LTE_CHRG_SETUPS;
OKL.OKL_LTE_CHRG_SETUPS does not reference any database object
OKL.OKL_LTE_CHRG_SETUPS is referenced by following:
|
|
|