[Home] [Help] [Dependency Information]
Object Name: | OKL_TRX_CSH_RECEIPT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_TRX_CSH_RECEIPT_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
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
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Auto-generated by Headstart Utilities | |
ID | NUMBER | Yes | Auto-generated by Headstart Utilities | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
SFWT_FLAG | VARCHAR2 | (3) | Yes | Column used by the translation batch program |
BTC_ID | NUMBER | Foreign key to table OKL_TRX_CSH_BATCH_B | ||
IBA_ID | NUMBER | Obsolete | ||
ILE_ID | NUMBER | Foreign Key to table OKX_CUSTOMER_ACCOUNTS_V | ||
IRM_ID | NUMBER | Foreign Key to table OKX_RECEIPT_METHODS_V | ||
CHECK_NUMBER | VARCHAR2 | (90) | Receipt identifier | |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code |
AMOUNT | NUMBER | (14) | Amount | |
GL_DATE | DATE | GL processing date | ||
DATE_EFFECTIVE | DATE | Date payment becomes effective | ||
EXCHANGE_RATE | NUMBER | Exchange Rate | ||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange Rate Type | |
EXCHANGE_RATE_DATE | DATE | Exchange Date | ||
DESCRIPTION | VARCHAR2 | (1995) | A general description of something | |
RCPT_STATUS_CODE | VARCHAR2 | (30) | Receipt Status Code | |
RECEIPT_TYPE | VARCHAR2 | (10) | Receipt type | |
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 | |
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 | |
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 | |
CASH_RECEIPT_ID | NUMBER | Cash Receipt Id | ||
FULLY_APPLIED_FLAG | VARCHAR2 | (3) | Flag to identify whether the invoice is fully applied or not | |
EXPIRED_FLAG | VARCHAR2 | (3) | Flag to identify whether the cash receipt is expired or not |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, BTC_ID
, IBA_ID
, ILE_ID
, IRM_ID
, CHECK_NUMBER
, CURRENCY_CODE
, AMOUNT
, GL_DATE
, DATE_EFFECTIVE
, EXCHANGE_RATE
, EXCHANGE_RATE_TYPE
, EXCHANGE_RATE_DATE
, DESCRIPTION
, RCPT_STATUS_CODE
, RECEIPT_TYPE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CASH_RECEIPT_ID
, FULLY_APPLIED_FLAG
, EXPIRED_FLAG
FROM APPS.OKL_TRX_CSH_RECEIPT_V;
|
|
|