[Home] [Help] [Dependency Information]
Object Name: | FA_LEASE_PAYMENT_ITEMS |
---|---|
Object Type: | TABLE |
Owner: | FA |
FND Design Data: | OFA.FA_LEASE_PAYMENT_ITEMS |
Subobject Name: | |
Status: | VALID |
This table stores all the payment items of leases in Oracle Assets
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FA_LEASE_PAYMENT_ITEMS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LEASE_ID
PAYMENT_SCHEDULE_ID SCHEDULE_AMORT_LINE_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEASE_ID | NUMBER | (15) | Yes | Unique Lease ID number |
PAYMENT_SCHEDULE_ID | NUMBER | (15) | Yes | Unique payment schedule ID number |
SCHEDULE_AMORT_LINE_NUM | NUMBER | (15) | Yes | Corresponding line from the Amortization Payment schedule |
EXPORT_STATUS | VARCHAR2 | (15) | Yes | Current status, can be: NEW, ON HOLD, POST, POSTED |
LESSOR_ID | NUMBER | (15) | Yes | The lessor id |
LESSOR_SITE_ID | NUMBER | (15) | Yes | The specific site of the lessor |
DIST_CODE_COMBINATION_ID | NUMBER | (15) | Yes | Account ID for Accounting |
INVOICE_ID | NUMBER | (15) | Unique Invoice ID from AP, created using sequence | |
INVOICE_LINE_ID | NUMBER | (15) | Unique Invoice Line ID | |
INVOICE_NUMBER | VARCHAR2 | (50) | Invoice number | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
REQUEST_ID | NUMBER | (15) | Concurrent Request Number of the Lease Payment Export Program | |
TERMS_ID | NUMBER | (15) | Payment terms unique identifier |
Cut, paste (and edit) the following text to query this object:
SELECT LEASE_ID
, PAYMENT_SCHEDULE_ID
, SCHEDULE_AMORT_LINE_NUM
, EXPORT_STATUS
, LESSOR_ID
, LESSOR_SITE_ID
, DIST_CODE_COMBINATION_ID
, INVOICE_ID
, INVOICE_LINE_ID
, INVOICE_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, TERMS_ID
FROM FA.FA_LEASE_PAYMENT_ITEMS;
FA.FA_LEASE_PAYMENT_ITEMS does not reference any database object
FA.FA_LEASE_PAYMENT_ITEMS is referenced by following:
|
|
|