[Home] [Help] [Dependency Information]
Object Name: | OKL_XTL_CSH_APPS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_XTL_CSH_APPS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Receipt application specyfing amount applied to Receivables invoices
Cash application data to be exported to Receivables lockbox interface
DEFINITION
super type entity for lines of external, financial (ERP / CRM) 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 |
RCA_ID | NUMBER | Foreign key to table OKL_TXL_RCPT_APPS_B | ||
LSM_ID | NUMBER | Foreign key to table OKL_CNSLD_AR_STRMS_B | ||
IRP_ID | NUMBER | Obsolete foreign key to view ZOKX_RCVBL_APPLCTNS_V | ||
CAT_ID | NUMBER | CAT_ID | ||
XCR_ID_DETAILS | NUMBER | Yes | Foreign Key to table OKL_EXT_CSH_RCPTS_B | |
INVOICE_NUMBER | VARCHAR2 | (150) | AR invoice number | |
AMOUNT_APPLIED | NUMBER | Amount applied to ar invoice | ||
INVOICE_INSTALLMENT | NUMBER | The installment number if an invoice has multiple payment schedules | ||
AMOUNT_APPLIED_FROM | NUMBER | If the receipt currency and the transaction currency are different, the amount of the receipt to apply in the receipt currency | ||
INVOICE_CURRENCY_CODE | VARCHAR2 | (45) | If the receipt currency and the transaction currency are different, the currency of the transaction | |
TRANS_TO_RECEIPT_RATE | NUMBER | If the receipt currency and the transaction currency are different, the exchange rate used to | ||
TRX_DATE | DATE | Transaction date of the AR invoice | ||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, RCA_ID
, LSM_ID
, IRP_ID
, CAT_ID
, XCR_ID_DETAILS
, INVOICE_NUMBER
, AMOUNT_APPLIED
, INVOICE_INSTALLMENT
, AMOUNT_APPLIED_FROM
, INVOICE_CURRENCY_CODE
, TRANS_TO_RECEIPT_RATE
, TRX_DATE
, 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
FROM APPS.OKL_XTL_CSH_APPS_V;
|
|
|