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: PN.PN_VAR_DEDUCT_ARCH_ALL

Object Details

Object Name:	PN_VAR_DEDUCT_ARCH_ALL
Object Type:	TABLE
Owner:	PN
FND Design Data:	PN.PN_VAR_DEDUCT_ARCH_ALL
Subobject Name:
Status:	VALID

PN_VAR_DEDUCT_ARCH_ALL stores deduction data that was modified during batch import.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PN_VAR_DEDUCT_ARCH_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DEDUCT_ARCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DEDUCT_ARCH_ID	NUMBER		Yes	Identifier of the deduction archive
DEDUCTION_ID	NUMBER		Yes	Identifier of the deduction
DEDUCTION_NUM	NUMBER		Yes	Number of the deduction
HIST_LAST_UPDATE_DATE	DATE		Yes	Standard Who column
HIST_LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
HIST_CREATION_DATE	DATE		Yes	Standard Who column
HIST_CREATED_BY	NUMBER		Yes	Standard Who column
HIST_LAST_UPDATE_LOGIN	NUMBER			Standard Who column
LINE_ITEM_ID	NUMBER			Identifier of the line in the PN_VAR_LINES_ALL table for this deduction
PERIOD_ID	NUMBER			Identifier of the period in the PN_VAR_PERIODS_ALL table for this deduction
START_DATE	DATE		Yes	Start date for applying deduction to variable rent
END_DATE	DATE		Yes	End date for applying deduction to variable rent
GRP_DATE_ID	NUMBER			Identifier of the group date in the PN_VAR_GRP_DATES_ALL table for this deduction
GROUP_DATE	DATE		Yes	Group date in the PN_VAR_GRP_DATES_ALL table that is based on the dates for this deduction
INVOICING_DATE	DATE		Yes	Invoice date in the PN_VAR_GRP_DATES_ALL table that is based on the dates for this deduction
GL_ACCOUNT_ID	NUMBER			Identifier of the account in the GL_CODE_COMBINATIONS table for this deduction
DEDUCTION_TYPE_CODE	VARCHAR2	(30)		Code specifying deduction type
DEDUCTION_AMOUNT	NUMBER		Yes	Deduction Amount.
EXPORTED_CODE	VARCHAR2	(1)	Yes	Code specifying whether this deduction has been used in an exported variable rent
COMMENTS	VARCHAR2	(2000)		Comments for this deduction
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield segment
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
HIST_ORG_ID	NUMBER	(15)		Identifier of the operating unit for this deduction
LAST_UPDATE_DATE	DATE		Yes	Standard Who column.
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column.
CREATION_DATE	DATE		Yes	Standard Who column.
CREATED_BY	NUMBER		Yes	Standard Who column.
LAST_UPDATE_LOGIN	NUMBER			Standard Who column.
ORG_ID	NUMBER			Identifier of the operating unit for the deduction archive

Query Text

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


SELECT DEDUCT_ARCH_ID
,      DEDUCTION_ID
,      DEDUCTION_NUM
,      HIST_LAST_UPDATE_DATE
,      HIST_LAST_UPDATED_BY
,      HIST_CREATION_DATE
,      HIST_CREATED_BY
,      HIST_LAST_UPDATE_LOGIN
,      LINE_ITEM_ID
,      PERIOD_ID
,      START_DATE
,      END_DATE
,      GRP_DATE_ID
,      GROUP_DATE
,      INVOICING_DATE
,      GL_ACCOUNT_ID
,      DEDUCTION_TYPE_CODE
,      DEDUCTION_AMOUNT
,      EXPORTED_CODE
,      COMMENTS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      HIST_ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM PN.PN_VAR_DEDUCT_ARCH_ALL;

Dependencies

[top of page]

PN.PN_VAR_DEDUCT_ARCH_ALL does not reference any database object

PN.PN_VAR_DEDUCT_ARCH_ALL is referenced by following:

PN: PN_VAR_DEDUCT_ARCH_ALL#