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_ADJ_REC_BUF

Object Details

Object Name:	PSA_MF_ADJ_REC_BUF
Object Type:	TABLE
Owner:	PSA
FND Design Data:	PSA.PSA_MF_ADJ_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_ADJ_REC_BUF_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	PST_CTRL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ADJUSTMENT_ID	NUMBER			Adjustment 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
ADJ_CAT_NAME	VARCHAR2	(240)		Adjustment category name
BATCH_PREFIX	VARCHAR2	(240)		Batch prefix
SUMMARY_FLAG	VARCHAR2	(240)		Summary flag
PRE_ADJCR_AR	VARCHAR2	(240)		Precredit receivable
PRE_ADJDR_AR	VARCHAR2	(240)		Predebit receivable
PRE_ADJDR_ADJ	VARCHAR2	(240)		Predebit adjustment
PRE_ADJCR_ADJ	VARCHAR2	(240)		Precredit adjustment
PRE_ADJDR	VARCHAR2	(240)		Predebit
PRE_ADJCR	VARCHAR2	(240)		Precredit
PRE_ADJ_NRTAX	VARCHAR2	(240)		Preadjustment tax
PRE_ADJ_FINCHRG	VARCHAR2	(240)		Preadjustment finance charge
PRE_ADJ_FINCHRG_NRTAX	VARCHAR2	(240)		Pre adjsutment finance charge tax
PRE_ADJ_TAX	VARCHAR2	(240)		Preadjustment tax
PRE_ADJ_DEFTAX	VARCHAR2	(240)		Pre adjsutment deferred tax
CLASS_CB	VARCHAR2	(240)		Class chargeback
CLASS_CM	VARCHAR2	(240)		Class credit memo
CLASS_DEP	VARCHAR2	(240)		Class deposit
CLASS_DM	VARCHAR2	(240)		Class debit memo
CLASS_GUAR	VARCHAR2	(240)		Class guarantee
CLASS_INV	VARCHAR2	(240)		Class invoice
POST_GENERAL	VARCHAR2	(240)		Post general
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 ADJUSTMENT_ID
,      USER_ID
,      STATUS
,      ACTUAL_FLAG
,      PST_CTRL_ID
,      SOB_ID
,      SOURCE
,      ADJ_CAT_NAME
,      BATCH_PREFIX
,      SUMMARY_FLAG
,      PRE_ADJCR_AR
,      PRE_ADJDR_AR
,      PRE_ADJDR_ADJ
,      PRE_ADJCR_ADJ
,      PRE_ADJDR
,      PRE_ADJCR
,      PRE_ADJ_NRTAX
,      PRE_ADJ_FINCHRG
,      PRE_ADJ_FINCHRG_NRTAX
,      PRE_ADJ_TAX
,      PRE_ADJ_DEFTAX
,      CLASS_CB
,      CLASS_CM
,      CLASS_DEP
,      CLASS_DM
,      CLASS_GUAR
,      CLASS_INV
,      POST_GENERAL
,      NXTVAL_ID
,      START_DATE
,      POST_THRU_DATE
,      LAST_UPDATE_DATE
FROM PSA.PSA_MF_ADJ_REC_BUF;

Dependencies

[top of page]

PSA.PSA_MF_ADJ_REC_BUF does not reference any database object

PSA.PSA_MF_ADJ_REC_BUF is referenced by following:

PSA: PSA_MF_ADJ_REC_BUF#