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: PA.PA_DEDUCTIONS_ALL

Object Details

Object Name:	PA_DEDUCTIONS_ALL
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_DEDUCTIONS_ALL
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_DEDUCTIONS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DEDUCTION_REQ_ID
PA_DEDUCTIONS_ALL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	DEDUCTION_REQ_NUM
PA_DEDUCTIONS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID VENDOR_ID CI_ID
PA_DEDUCTIONS_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID PO_HEADER_ID
PA_DEDUCTIONS_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID DEDUCTION_REQ_DATE VENDOR_ID
PA_DEDUCTIONS_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID STATUS

Columns

Name	Datatype	Length	Mandatory	Comments
DEDUCTION_REQ_ID	NUMBER	(15)	Yes	This is a system generated number that uniquely identifies a deduction request.
PROJECT_ID	NUMBER	(15)	Yes	This is the ID of the project for which the deduction request is created.
VENDOR_ID	NUMBER	(15)	Yes	This is the ID of the supplier against whom the debit memo needs to be raised.
VENDOR_SITE_ID	NUMBER		Yes	This is the supplier site ID.
CHANGE_DOC_NUM	VARCHAR2	(30)		This is the denormalized change document number. A change document can be a change order or change request.
CHANGE_DOC_TYPE	VARCHAR2	(15)		This is the change document type.
CI_ID	NUMBER			This is the ID of the control item associated with the change document that is used in the deduction request.
PO_HEADER_ID	NUMBER			This is the ID of the purchase order associated with the deduction request.
PO_NUMBER	VARCHAR2	(20)		This is the denormalized purchase order number and is taken from column "Segment1" of PO_HEADER_ALL table.
DEDUCTION_REQ_NUM	VARCHAR2	(30)	Yes	This is the deduction request number.
DEBIT_MEMO_NUM	VARCHAR2	(30)		This is the debit memo number associated with the deduction request.
CURRENCY_CODE	VARCHAR2	(30)	Yes	This is the debit memo transaction currency code.
CONVERSION_RATETYPE	VARCHAR2	(30)		This is the currency conversion rate type used to convert the project functional currency to transaction currency.
CONVERSION_RATEDATE	DATE			This is the date on which the defined currency conversion rate is applicable.
CONVERSION_RATE	NUMBER			This is the currency conversion rate used to convert projects functional currency amount to the transaction currency amount.
TOTAL_AMOUNT	NUMBER			This is the total deduction request amount expressed in the transaction currency
TOTAL_PFC_AMOUNT	NUMBER			This is the total deduction request amount expressed in the projects functional currency.
DEDUCTION_REQ_DATE	DATE		Yes	This is the date on which the deduction request is created.
DEBIT_MEMO_DATE	DATE			This is the date on which the debit memo is created.
DESCRIPTION	VARCHAR2	(4000)		This is a description of the debit memo
STATUS	VARCHAR2	(15)		This is the status of the deduction request.
ORG_ID	NUMBER		Yes	This is the organization ID.
DOCUMENT_TYPE	VARCHAR2	(1)		This is the type of document associated with the deduction request. The document type can be M for miscellaneous deductions or C for deductions created with a change order.
CREATION_DATE	DATE		Yes	This is the date on which the deduction request was created.
CREATED_BY	NUMBER	(15)	Yes	This is the ID of the user who created the deductions request.
LAST_UPDATION_DATE	DATE			This is the date on which the deduction request was last updated.
LAST_UPDATED_BY	NUMBER	(15)		This is the ID of the user who last updated the deductions request.

Query Text

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


SELECT DEDUCTION_REQ_ID
,      PROJECT_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      CHANGE_DOC_NUM
,      CHANGE_DOC_TYPE
,      CI_ID
,      PO_HEADER_ID
,      PO_NUMBER
,      DEDUCTION_REQ_NUM
,      DEBIT_MEMO_NUM
,      CURRENCY_CODE
,      CONVERSION_RATETYPE
,      CONVERSION_RATEDATE
,      CONVERSION_RATE
,      TOTAL_AMOUNT
,      TOTAL_PFC_AMOUNT
,      DEDUCTION_REQ_DATE
,      DEBIT_MEMO_DATE
,      DESCRIPTION
,      STATUS
,      ORG_ID
,      DOCUMENT_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATION_DATE
,      LAST_UPDATED_BY
FROM PA.PA_DEDUCTIONS_ALL;

Dependencies

[top of page]

PA.PA_DEDUCTIONS_ALL does not reference any database object

PA.PA_DEDUCTIONS_ALL is referenced by following:

PA: PA_DEDUCTIONS_ALL#