eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: PSA.PSA_MF_TRX_REC_BUF

Object Details

Object Name:	PSA_MF_TRX_REC_BUF
Object Type:	TABLE
Owner:	PSA
FND Design Data:	PSA.PSA_MF_TRX_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:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSA_MF_TRX_REC_BUF_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	PST_CTRL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMER_TRX_ID	NUMBER			Customer transaction identifier
USER_ID	NUMBER			User identifier
STATUS	VARCHAR2	(240)		Status
ACTUAL_FLAG	VARCHAR2	(240)		Actual flag
PST_CTRL_ID	NUMBER			Posting control identifier
SOB_ID	NUMBER			Set of Books identifier
SOURCE	VARCHAR2	(240)		Source
CM_CAT_NAME	VARCHAR2	(240)		Credit memo category name
DM_CAT_NAME	VARCHAR2	(240)		Debit memo category name
CB_CAT_NAME	VARCHAR2	(240)		Chargeback category name
INV_CAT_NAME	VARCHAR2	(240)		Invoice category name
BATCH_PREFIX	VARCHAR2	(240)		Batch prefix
SUMMARY_FLAG	VARCHAR2	(240)		Summary flag
PRE_CT_LINE	VARCHAR2	(240)		Precustomer transaction line
POST_CT_LINE	VARCHAR2	(240)		Postcustomer transaction line
CLASS_CB	VARCHAR2	(240)		Class chargeback
CLASS_CM	VARCHAR2	(240)		Class credit memo
CLASS_DM	VARCHAR2	(240)		Class debit memo
CLASS_DEP	VARCHAR2	(240)		Class deposit
CLASS_GUAR	VARCHAR2	(240)		Class guarantee
CLASS_INV	VARCHAR2	(240)		Class invoice
NXTVAL_ID	NUMBER			Next value identifier
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 CUSTOMER_TRX_ID
,      USER_ID
,      STATUS
,      ACTUAL_FLAG
,      PST_CTRL_ID
,      SOB_ID
,      SOURCE
,      CM_CAT_NAME
,      DM_CAT_NAME
,      CB_CAT_NAME
,      INV_CAT_NAME
,      BATCH_PREFIX
,      SUMMARY_FLAG
,      PRE_CT_LINE
,      POST_CT_LINE
,      CLASS_CB
,      CLASS_CM
,      CLASS_DM
,      CLASS_DEP
,      CLASS_GUAR
,      CLASS_INV
,      NXTVAL_ID
,      START_DATE
,      POST_THRU_DATE
,      LAST_UPDATE_DATE
FROM PSA.PSA_MF_TRX_REC_BUF;

Dependencies

[top of page]

PSA.PSA_MF_TRX_REC_BUF does not reference any database object

PSA.PSA_MF_TRX_REC_BUF is referenced by following:

PSA: PSA_MF_TRX_REC_BUF#