DBA Data[Home] [Help] [Dependency Information]

TABLE: PSA.PSA_MF_RCT_REC_BUF

Object Details
Object Name: PSA_MF_RCT_REC_BUF
Object Type: TABLE
Owner: PSA
FND Design Data: TablePSA.PSA_MF_RCT_REC_BUF
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSA_MF_RCT_REC_BUF_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnPST_CTRL_ID
Columns
Name Datatype Length Mandatory Comments
RA_RECEIVABLE_APPLICATION_ID NUMBER

Receivable Application Id
USER_ID NUMBER

User Id
STATUS VARCHAR2 (240)
Status
ACTUAL_FLAG VARCHAR2 (240)
Actual Flag
PST_CTRL_ID NUMBER

Posting Control Id
SOB_ID NUMBER

Set of Books Id
SOURCE VARCHAR2 (240)
Source
TRADE_CAT_NAME VARCHAR2 (240)
Trade Category Name
CCURR_CAT_NAME VARCHAR2 (240)
Cross Currency Categoory Name
CMAPP_CAT_NAME VARCHAR2 (240)
Credit Memo Application Category Name
FUNC_CURR VARCHAR2 (240)
Functional Currency
PRE_TRADEAPP VARCHAR2 (240)
Pre Trade Application
APP_ONACC VARCHAR2 (240)
On Account
APP_UNAPP VARCHAR2 (240)
Unapplied
APP_UNID VARCHAR2 (240)
Unidnetified
APP_APPLIED VARCHAR2 (240)
Applied
PRE_ERDISC VARCHAR2 (240)
Earned Discount
PRE_REC_ERDISC_NRTAX VARCHAR2 (240)
Earned Discount Tax
PRE_UNDISC VARCHAR2 (240)
Unearned Discount
PRE_REC_UNDISC_NRTAX VARCHAR2 (240)
Unearned Discount Tax
PRE_REC_GAIN VARCHAR2 (240)
Gain
PRE_REC_LOSS VARCHAR2 (240)
Loss
PRE_REC_CURR_ROUND VARCHAR2 (240)
Currency Rounding
PRE_REC_TAX VARCHAR2 (240)
Tax
PRE_REC_DEFTAX VARCHAR2 (240)
Deferred Tax
CLASS_CB VARCHAR2 (240)
Chargeback
CLASS_CM VARCHAR2 (240)
Credit Memo
CLASS_DEP VARCHAR2 (240)
Deposit
CLASS_DM VARCHAR2 (240)
Debit Memo
CLASS_GUAR VARCHAR2 (240)
Guarantee
CLASS_INV VARCHAR2 (240)
Invoice
POST_GENERAL VARCHAR2 (240)
Post General
PRE_CMAPP VARCHAR2 (240)
Pre Credit Memo Application
PRE_CMGAIN VARCHAR2 (240)
Pre Credit Memo Gain
PRE_CMLOSS VARCHAR2 (240)
Pre Credit Memo Loss
BATCH_PREFIX VARCHAR2 (240)
Batch Prefix
SUMMARY_FLAG VARCHAR2 (240)
Summary Flag
PRE_RECEIPT VARCHAR2 (240)
Pre Receipt
POST_RECEIPT VARCHAR2 (240)
Post Receipt
NXTVAL_ID NUMBER

Next Value Id
START_DATE DATE

Start Date
POST_THRU_DATE DATE

Post thru date
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RA_RECEIVABLE_APPLICATION_ID
,      USER_ID
,      STATUS
,      ACTUAL_FLAG
,      PST_CTRL_ID
,      SOB_ID
,      SOURCE
,      TRADE_CAT_NAME
,      CCURR_CAT_NAME
,      CMAPP_CAT_NAME
,      FUNC_CURR
,      PRE_TRADEAPP
,      APP_ONACC
,      APP_UNAPP
,      APP_UNID
,      APP_APPLIED
,      PRE_ERDISC
,      PRE_REC_ERDISC_NRTAX
,      PRE_UNDISC
,      PRE_REC_UNDISC_NRTAX
,      PRE_REC_GAIN
,      PRE_REC_LOSS
,      PRE_REC_CURR_ROUND
,      PRE_REC_TAX
,      PRE_REC_DEFTAX
,      CLASS_CB
,      CLASS_CM
,      CLASS_DEP
,      CLASS_DM
,      CLASS_GUAR
,      CLASS_INV
,      POST_GENERAL
,      PRE_CMAPP
,      PRE_CMGAIN
,      PRE_CMLOSS
,      BATCH_PREFIX
,      SUMMARY_FLAG
,      PRE_RECEIPT
,      POST_RECEIPT
,      NXTVAL_ID
,      START_DATE
,      POST_THRU_DATE
,      LAST_UPDATE_DATE
FROM PSA.PSA_MF_RCT_REC_BUF;

Dependencies

[top of page]

PSA.PSA_MF_RCT_REC_BUF does not reference any database object

PSA.PSA_MF_RCT_REC_BUF is referenced by following:

SchemaAPPS
SynonymPSA_MF_RCT_REC_BUF