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: FV.FV_PYA_TRANSACTION_HISTORY

Object Details

Object Name:	FV_PYA_TRANSACTION_HISTORY
Object Type:	TABLE
Owner:	FV
FND Design Data:	FV.FV_PYA_TRANSACTION_HISTORY
Subobject Name:
Status:	VALID

FV_PYA_TRANSACTION_HISTORY stores all the Prior Year Adjustment transactions processed in the PYA Journal Creation Program. The data stored in this table is a combination of the data in the FV_PYA_TRANSACTIONS table and the data that is generated by the PYA Journal Creation Program. This is the base table for the Transaction History form.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FV_PYA_TRANSACTION_HISTORY_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_HISTORY_ID
FV_PYA_TRANSACTION_HISTORY_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	JE_BATCH_ID JE_HEADER_ID JE_LINE_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_HISTORY_ID	NUMBER	(15)	Yes	Unique system-generated identifier, generated by using the sequence FV_PYA_TRANSACTION_HISTORY_S
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
CODE_COMBINATION_ID	NUMBER	(38)	Yes	Transaction code combination identifier that references the GL_CODE_COMBINATIONS table
AMOUNT	NUMBER	(20)	Yes	Amount
PERIOD	VARCHAR2	(15)	Yes	General Ledger period
SOURCE_MODULE	VARCHAR2	(240)		Source module name
SOURCE_DOCUMENT_NUMBER	VARCHAR2	(240)		Source document number
JE_BATCH_ID	NUMBER	(15)	Yes	Journal Entry Batch defining column
JE_HEADER_ID	NUMBER	(15)	Yes	Journal Entry header defining column
JE_LINE_NUM	NUMBER	(15)	Yes	Journal Entry line number
TRANSACTION_ID	NUMBER	(15)	Yes	References the FV_PYA_TRANSACTIONS table
JE_BATCH_NAME	VARCHAR2	(100)		Journal Entry batch name
CATEGORY	VARCHAR2	(1)	Yes	General Ledger category. Valid values are U for Upward Adjustments and D for Downward Adjustments.
OFFSET_ACCT_NUMBER	VARCHAR2	(25)		Offset account number
TRANSACTION_CODE	VARCHAR2	(30)		Transaction code
NEVER_PROCESSED_FLAG	VARCHAR2	(1)	Yes	Indicates the transaction was never selected in the Journal Creation Program. Valid values are Y for Yes and N for No.
REFERENCE_2	VARCHAR2	(240)		Maps to Reference_2 column in the GL_JE_LINES table. For a Standard PO, this column holds the value of the PO Header ID. For a Requisition, this column holds the value of the Requisition Header ID.
REFERENCE_3	VARCHAR2	(240)		Maps to Reference_3 column in the GL_JE_LINES table. For a Standard PO, this column holds the value of the PO Distribution I'. For a Requisition, this column holds the value of the Requisition Distribution ID.
REFERENCE_5	VARCHAR2	(240)		Maps to Reference_5 column in the GL_JE_LINES table. For a Standard PO, this column holds the value of the PO Header ID. For a Requisition, this column holds the value of the Requisition Header ID.
ORG_ID	NUMBER	(15)		Organization identifier
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
FUND_VALUE	VARCHAR2	(25)		Not currently used
PARENT_REVERSAL_ID	NUMBER	(15)		Parent reversal identifier is used to map to the parent of the unmatched invoice reversal line.
INVOICE_DISTRIBUTION_ID	NUMBER	(15)		Invoice distribution identifier
ACCOUNT_VALUE	VARCHAR2	(25)		Account value of the transaction
TRANSACTION_DATE	DATE			Transaction date of the transaction. This is the effective date from GL_JE_LINES table.
FUND_CLASS	VARCHAR2	(1)		Fund Class valid values are A for Anticipated, U for Unanticipated, and R for Reimbursable.
FUND_STATUS	VARCHAR2	(1)		Fund Status valid values are E for Expired and U for Unexpired.
EXPENDED_UNEXPENDED	VARCHAR2	(1)		Expended or Unexpended flag. Valid values are E for Expended and U for Unexpended.
PAID_UNPAID	VARCHAR2	(1)		Paid or Unpaid flag. Valid values are P for Paid, and U for Unpaid.
APPORTIONED_FLAG	VARCHAR2	(1)		Apportioned flag

Query Text

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


SELECT TRANSACTION_HISTORY_ID
,      SET_OF_BOOKS_ID
,      CODE_COMBINATION_ID
,      AMOUNT
,      PERIOD
,      SOURCE_MODULE
,      SOURCE_DOCUMENT_NUMBER
,      JE_BATCH_ID
,      JE_HEADER_ID
,      JE_LINE_NUM
,      TRANSACTION_ID
,      JE_BATCH_NAME
,      CATEGORY
,      OFFSET_ACCT_NUMBER
,      TRANSACTION_CODE
,      NEVER_PROCESSED_FLAG
,      REFERENCE_2
,      REFERENCE_3
,      REFERENCE_5
,      ORG_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      FUND_VALUE
,      PARENT_REVERSAL_ID
,      INVOICE_DISTRIBUTION_ID
,      ACCOUNT_VALUE
,      TRANSACTION_DATE
,      FUND_CLASS
,      FUND_STATUS
,      EXPENDED_UNEXPENDED
,      PAID_UNPAID
,      APPORTIONED_FLAG
FROM FV.FV_PYA_TRANSACTION_HISTORY;

Dependencies

[top of page]

FV.FV_PYA_TRANSACTION_HISTORY does not reference any database object

FV.FV_PYA_TRANSACTION_HISTORY is referenced by following:

FV: FV_PYA_TRANSACTION_HISTORY#