[Home] [Help] [Dependency Information]
Object Name: | OKL_TRX_CSH_RCPT_ALL_B |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_TRX_CSH_RCPT_ALL_B |
Subobject Name: | |
Status: | VALID |
Individual receipt processed in a batch
Cash manually applied in batches to consolidated billing invoices
DEFINITION
super type entity for headers of internal contracts transactions
EXAMPLE
MISCELLANEOUS
DEFINITION
The supertype of OKL transactions.
EXAMPLE
MISCELLANEOUS
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_TRX_CSH_RCPT_ALL_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKL_TRX_CSH_RCPT_ALL_B_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BTC_ID |
OKL_TRX_CSH_RCPT_ALL_B_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CURRENCY_CODE |
OKL_TRX_CSH_RCPT_ALL_B_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | IBA_ID |
OKL_TRX_CSH_RCPT_ALL_B_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ILE_ID |
OKL_TRX_CSH_RCPT_ALL_B_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | IRM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code |
BTC_ID | NUMBER | Foreign key to table OKL_TRX_CSH_BATCH_B | ||
IBA_ID | NUMBER | Bank Account Id | ||
GL_DATE | DATE | GL processing date | ||
ILE_ID | NUMBER | Foreign Key to table OKX_CUSTOMER_ACCOUNTS_V | ||
IRM_ID | NUMBER | Foreign Key to table OKX_RECEIPT_METHODS_V | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
CHECK_NUMBER | VARCHAR2 | (90) | Receipt identifier | |
AMOUNT | NUMBER | (14) | Amount | |
ACCOUNT | VARCHAR2 | (240) | Bank account number from the receipt. Together with transit routing number, the attribute is used to identify customer (MICR number) | |
CUSTOMER_BANK_NAME | VARCHAR2 | (240) | The name of the customer's bank | |
DATE_EFFECTIVE | DATE | Date payment becomes effective | ||
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 | |
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange Rate Type | |
EXCHANGE_RATE | NUMBER | Exchange Rate | ||
EXCHANGE_RATE_DATE | DATE | Exchange Rate Date | ||
RCPT_STATUS_CODE | VARCHAR2 | (30) | RCPT_STATUS_CODE | |
CRL_CURE_REFUND_LINE_ID | NUMBER | OBSOLETE | ||
CRL_CURE_REFUND_LINE_ID2 | NUMBER | OBSOLETE | ||
RECEIPT_TYPE | VARCHAR2 | (10) | RECEIPT TYPE | |
CASH_RECEIPT_ID | NUMBER | Foreign Key to ar_Cash_receipts_all.cash_receipt_id | ||
FULLY_APPLIED_FLAG | VARCHAR2 | (3) | This column indicates if the receipt has been fully applied ot not. | |
EXPIRED_FLAG | VARCHAR2 | (3) | THis column indicates if an advanced receipt is still available for application based on allocation specified for the receipt. |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, CURRENCY_CODE
, BTC_ID
, IBA_ID
, GL_DATE
, ILE_ID
, IRM_ID
, OBJECT_VERSION_NUMBER
, CHECK_NUMBER
, AMOUNT
, ACCOUNT
, CUSTOMER_BANK_NAME
, DATE_EFFECTIVE
, 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
, EXCHANGE_RATE_TYPE
, EXCHANGE_RATE
, EXCHANGE_RATE_DATE
, RCPT_STATUS_CODE
, CRL_CURE_REFUND_LINE_ID
, CRL_CURE_REFUND_LINE_ID2
, RECEIPT_TYPE
, CASH_RECEIPT_ID
, FULLY_APPLIED_FLAG
, EXPIRED_FLAG
FROM OKL.OKL_TRX_CSH_RCPT_ALL_B;
OKL.OKL_TRX_CSH_RCPT_ALL_B does not reference any database object
OKL.OKL_TRX_CSH_RCPT_ALL_B is referenced by following:
|
|
|