[Home] [Help] [Dependency Information]
Object Name: | OKL_TRX_CSH_BATCH_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_TRX_CSH_BATCH_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Batch of manual cash receipt entered via OKL
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 | Primary key column | |
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 |
NAME | VARCHAR2 | (150) | Yes | Name of a batch |
TRX_STATUS_CODE | VARCHAR2 | (30) | Yes | Transaction status |
DATE_ENTERED | DATE | Date batch created | ||
DATE_GL_REQUESTED | DATE | GL processing date | ||
DATE_DEPOSIT | DATE | Date of receipt deposit into account | ||
BATCH_QTY | NUMBER | (15) | Number of invoices with payments applied | |
BATCH_TOTAL | NUMBER | (14) | monetary amount | |
BATCH_CURRENCY | VARCHAR2 | (15) | Batch Currency | |
DESCRIPTION | VARCHAR2 | (1995) | A general description of something | |
IRM_ID | NUMBER | IRM_ID | ||
BATCH_COMPLETE_YN | VARCHAR2 | (3) | Batch ready for submission | |
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 | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion Type | |
CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
REMIT_BANK_ID | NUMBER | Remittance Bank Id |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, NAME
, TRX_STATUS_CODE
, DATE_ENTERED
, DATE_GL_REQUESTED
, DATE_DEPOSIT
, BATCH_QTY
, BATCH_TOTAL
, BATCH_CURRENCY
, DESCRIPTION
, IRM_ID
, BATCH_COMPLETE_YN
, 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
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
, REMIT_BANK_ID
FROM APPS.OKL_TRX_CSH_BATCH_V;
|
|
|