[Home] [Help] [Dependency Information]
Object Name: | OKL_TRX_CSH_BATCH_ALL_B |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_TRX_CSH_BATCH_ALL_B |
Subobject Name: | |
Status: | VALID |
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_TRX_CSH_BATCH_ALL_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKL_TRX_CSH_BATCH_ALL_B_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRX_STATUS_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
TRX_STATUS_CODE | VARCHAR2 | (30) | Yes | Transaction status |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
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_COMPLETE_YN | VARCHAR2 | (3) | Batch ready for submission | |
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 | |
BATCH_CURRENCY | VARCHAR2 | (15) | Batch Currency | |
IRM_ID | NUMBER | IRM_ID | ||
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 ID
, TRX_STATUS_CODE
, OBJECT_VERSION_NUMBER
, DATE_ENTERED
, DATE_GL_REQUESTED
, DATE_DEPOSIT
, BATCH_QTY
, BATCH_TOTAL
, BATCH_COMPLETE_YN
, 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
, BATCH_CURRENCY
, IRM_ID
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
, REMIT_BANK_ID
FROM OKL.OKL_TRX_CSH_BATCH_ALL_B;
OKL.OKL_TRX_CSH_BATCH_ALL_B does not reference any database object
OKL.OKL_TRX_CSH_BATCH_ALL_B is referenced by following:
|
|
|