[Home] [Help] [Dependency Information]
Object Name: | OKL_PARTY_PAYMENT_DTLS |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_PARTY_PAYMENT_DTLS |
Subobject Name: | |
Status: | VALID |
Party payment details table is used for storing payables payment details for a lease contract party . This information s used to to create Oracle Payables transactions against the relevant party. For subsidies and discounts this table will store the subsidy vendor payment details for the purpose of subsidy refunds. For funding borrower payments this table will store the coressponding vendor and payment details for a Lessee.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_PARTY_PAYMENT_DTLS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKL_PARTY_PAYMENT_DTLS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CPL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Unique identifier for payment details record | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
CPL_ID | NUMBER | Yes | Identifier for contract party role record. Foreign key to OKC_K_PARTY_ROLES_B.ID | |
VENDOR_ID | NUMBER | Yes | Identifier for vendor. It is the vendor to whom payment is to be made. In case the party role is a TCA party this is the vendor corresponding to TCA party | |
PAY_SITE_ID | NUMBER | Identifier for Vendor payment site | ||
PAYMENT_TERM_ID | NUMBER | Identifier for paybles payment term | ||
PAYMENT_METHOD_CODE | VARCHAR2 | (30) | Payment method code | |
PAY_GROUP_CODE | VARCHAR2 | (30) | Pay group code | |
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 | |
PAYMENT_HDR_ID | NUMBER | Foreign key from party payment header table | ||
PAYMENT_START_DATE | DATE | Payment Start Date for base term only | ||
PAYMENT_FREQUENCY | VARCHAR2 | (15) | Payment Frequency for base term only | |
REMIT_DAYS | NUMBER | Remit days | ||
DISBURSEMENT_BASIS | VARCHAR2 | (10) | Disbursement Basis: Fixed amount, Percent | |
DISBURSEMENT_FIXED_AMOUNT | NUMBER | Disbursement Fixed Amount | ||
DISBURSEMENT_PERCENT | NUMBER | Disbursement Percent | ||
PROCESSING_FEE_BASIS | VARCHAR2 | (10) | Processing Fee Basis: Fixed amount, Percent | |
PROCESSING_FEE_FIXED_AMOUNT | NUMBER | Processing Fee Fixed Amount | ||
PROCESSING_FEE_PERCENT | NUMBER | Processing Fee Percent | ||
PAYMENT_BASIS | VARCHAR2 | (15) | Payment Basis: Scheduled, Process Date, Source Date | |
ORIG_CONTRACT_LINE_ID | NUMBER | Reference to the original contract line identifier |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, OBJECT_VERSION_NUMBER
, CPL_ID
, VENDOR_ID
, PAY_SITE_ID
, PAYMENT_TERM_ID
, PAYMENT_METHOD_CODE
, PAY_GROUP_CODE
, 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
, PAYMENT_HDR_ID
, PAYMENT_START_DATE
, PAYMENT_FREQUENCY
, REMIT_DAYS
, DISBURSEMENT_BASIS
, DISBURSEMENT_FIXED_AMOUNT
, DISBURSEMENT_PERCENT
, PROCESSING_FEE_BASIS
, PROCESSING_FEE_FIXED_AMOUNT
, PROCESSING_FEE_PERCENT
, PAYMENT_BASIS
, ORIG_CONTRACT_LINE_ID
FROM OKL.OKL_PARTY_PAYMENT_DTLS;
OKL.OKL_PARTY_PAYMENT_DTLS does not reference any database object
OKL.OKL_PARTY_PAYMENT_DTLS is referenced by following:
|
|
|