[Home] [Help] [Dependency Information]
Object Name: | OKL_TXL_RCPT_APPS_ALL_B |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_TXL_RCPT_APPS_ALL_B |
Subobject Name: | |
Status: | VALID |
apply cash to
1) consolidated bill
2) stream group (invoice format line)
3) stream type
4) a contract
5) or none of these, ie. any & all invoices for customer
if not at the detail level
further work is required to apply the amount down at the lowest ie. streaml level
where it may be matched to actual AR invoices
Cash manually applied via OKL
DEFINITION
A subtype of "transaction", but a supertype of all OKL transaction lines.
EXAMPLE
MISCELLANEOUS
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_TXL_RCPT_APPS_ALL_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKL_TXL_RCPT_APPS_ALL_B_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CNR_ID |
OKL_TXL_RCPT_APPS_ALL_B_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ILE_ID |
OKL_TXL_RCPT_APPS_ALL_B_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | KHR_ID |
OKL_TXL_RCPT_APPS_ALL_B_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LLN_ID |
OKL_TXL_RCPT_APPS_ALL_B_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LSM_ID |
OKL_TXL_RCPT_APPS_ALL_B_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RCT_ID_DETAILS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
RCT_ID_DETAILS | NUMBER | Yes | Foreign Key to table OKL_TRX_CSH_RECEIPT_B | |
CNR_ID | NUMBER | Foreign key to table OKL_CNSLD_AR_HDRS_B | ||
KHR_ID | NUMBER | Foreign key to table OKL_K_HEADERS | ||
LLN_ID | NUMBER | Foreign key to table OKL_CNSLD_AR_LINES_B | ||
LSM_ID | NUMBER | Foreign key to table OKL_CNSLD_AR_STRMS_B | ||
ILE_ID | NUMBER | Foreign Key to table OKX_CUSTOMER_ACCOUNTS_V | ||
LINE_NUMBER | NUMBER | Yes | Line number | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
AMOUNT | NUMBER | (14) | Amount | |
REQUEST_ID | NUMBER | (15) | Concurrent Manager column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Manager column | |
PROGRAM_ID | NUMBER | (15) | Concurrent Manager column | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Manager column | ||
ORG_ID | NUMBER | (15) | Operating unit identifier | |
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 | |
STY_ID | NUMBER | Foreign Key to table OKL_STRM_TYPES | ||
AR_INVOICE_ID | NUMBER | Invoice ID |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, RCT_ID_DETAILS
, CNR_ID
, KHR_ID
, LLN_ID
, LSM_ID
, ILE_ID
, LINE_NUMBER
, OBJECT_VERSION_NUMBER
, AMOUNT
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
, 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
, STY_ID
, AR_INVOICE_ID
FROM OKL.OKL_TXL_RCPT_APPS_ALL_B;
OKL.OKL_TXL_RCPT_APPS_ALL_B does not reference any database object
OKL.OKL_TXL_RCPT_APPS_ALL_B is referenced by following:
|
|
|