[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
FV.FV_PYA_TRANSACTION_HISTORY does not reference any database object
FV.FV_PYA_TRANSACTION_HISTORY is referenced by following:
|
|
|