1. Tables and Views for Financials
  2. FV_IPAC_TRANSACTION_DATA_

FV_IPAC_TRANSACTION_DATA_

This is an audit table that tracks changes to the fv_ipac_transaction_data table.

Details

  • Schema: FUSION

  • Object owner: FV

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

fv_ipac_transaction_data_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, TRANSACTION_DATA_ID

Columns

Name Datatype Length Precision Not-null Comments Status
TRANSACTION_DATA_ID NUMBER 18 Yes Unique identifier of the IPAC transaction data.
TRANSACTION_LOAD_DATE DATE Date on which the transaction data was loaded into Oracle Fusion Financials tables.
STATUS_CODE VARCHAR2 30 Status of the record being loaded. Valid values are SUCCESS, FAIL.
COMMENTS VARCHAR2 500 Additional description for the transaction activity.
TRANSACTION_TYPE_CODE VARCHAR2 30 Type of the transaction being processed. Valid values are P, C, or A.
TRANSACTION_ID NUMBER 18 Unique identifier of the IPAC transaction.
DETAIL_LINE_NUMBER NUMBER 3 The transaction detail line number.
DOCUMENT_ID NUMBER 18 Used to store a unique identifier value which can be used for drill-down or reconciling flexibility.
INVOICE_NUMBER VARCHAR2 30 Invoice number of the transaction.
INVOICE_AMOUNT NUMBER Invoice amount of the transaction.
USER_ATTRIBUTE_1 VARCHAR2 150 Used for storing reference values.
USER_ATTRIBUTE_2 VARCHAR2 150 Used for storing reference values.
USER_ATTRIBUTE_3 VARCHAR2 150 Used for storing reference values.
USER_ATTRIBUTE_4 VARCHAR2 150 Used for storing reference values.
USER_ATTRIBUTE_5 VARCHAR2 150 Used for storing reference values.
USER_ATTRIBUTE_6 VARCHAR2 150 Used for storing reference values.
USER_ATTRIBUTE_7 VARCHAR2 150 Used for storing reference values.
USER_ATTRIBUTE_8 VARCHAR2 150 Used for storing reference values.
USER_ATTRIBUTE_9 VARCHAR2 150 Used for storing reference values.
USER_ATTRIBUTE_10 VARCHAR2 150 Used for storing reference values.
USER_ATTRIBUTE_11 VARCHAR2 150 Used for storing reference values.
USER_ATTRIBUTE_12 VARCHAR2 150 Used for storing reference values.
USER_ATTRIBUTE_13 VARCHAR2 150 Used for storing reference values.
USER_ATTRIBUTE_14 VARCHAR2 150 Used for storing reference values.
USER_ATTRIBUTE_15 VARCHAR2 150 Used for storing reference values.
SUBMITTER_ALC VARCHAR2 30 Agency location code of the submitter.
ORIGINATOR_ALC VARCHAR2 30 Agency location code of the originator.
CUSTOMER_ALC VARCHAR2 30 Agency location code of the customer.
CONTACT_NAME VARCHAR2 360 Name of the contact person for the transaction.
CONTACT_EMAIL_ADDRESS VARCHAR2 320 Email address of the contact person.
CONTACT_PHONE_NUMBER VARCHAR2 60 Phone number of the contact person.
NUMBER_OF_DETAIL_ITEMS NUMBER 3 Number of detail lines in the transaction.
ACCOMPLISHED_DATE DATE Date on which the transaction occurred.
ACCOUNTING_DATE DATE Date on which the transaction was accounted in the system.
CONTRACT_NUMBER NUMBER 18 Unique number used to identify a contract between two trading partners. Obsolete
TRX_CONTRACT_NUMBER VARCHAR2 30 Unique number used to identify a contract between two trading partners.
PURCHASE_ORDER_NUMBER VARCHAR2 30 Purchase order number of the transaction.
CLIN_NUMBER VARCHAR2 30 Contract line item number of the transaction.
REQUISITION_NUMBER VARCHAR2 30 Requisition number of the transaction.
QUANTITY NUMBER Number of items in the transaction.
UNIT_OF_ISSUE VARCHAR2 10 Number of items that are being issued.
UNIT_PRICE NUMBER Unit price of an item in the transaction.
DETAIL_AMOUNT NUMBER Detail amount of the transaction.
PAYMENT_FLAG VARCHAR2 1 Indicates whether the payment for the transaction line amount is full or partial. Valid values are F and P.
FY_OBLIGATION_ID NUMBER 18 Obligation identifier for the fiscal year.
RECEIVER_TAS VARCHAR2 35 Receiver's treasury account symbol.
RECEIVER_BETC VARCHAR2 8 Identifies the receiver's type of activity (gross disbursement, offsetting collection, investment in Treasury securities, etc.) and the effect of a transaction on the Fund Balance With Treasury. It is used in combination with the Treasury Account Symbol to classify transactions reported to Treasury through all Governmentwide Accounting financial management systems.
RECEIVER_DUNS NUMBER 9 The Dun and Bradstreet Data Universal Numbering System (DUNS) number of the receiver. Obsolete
RECEIVER_DUNS_OR_UEI VARCHAR2 12 The Dun and Bradstreet Data Universal Numbering System (DUNS) number of the receiver or the Unique Entity Identifier (UEI) for the System for Award Management (SAM) database that uniquely identifies entities that do business with the federal government.
RECEIVER_DUNS_PLUS_4 NUMBER 4 The Dun and Bradstreet Data Universal Numbering System (DUNS) number plus 4 of the receiver. Obsolete
RECEIVER_DUNS_PLUS_4_OR_EFT VARCHAR2 4 The Dun and Bradstreet Data Universal Numbering System (DUNS) plus 4 or the Electronic Funds Transfer (EFT) indicator of the receiver.
SENDER_TAS VARCHAR2 35 Sender's treasury account symbol.
SENDER_BETC VARCHAR2 8 Identifies the sender's type of activity (gross disbursement, offsetting collection, investment in Treasury securities, etc.) and the effect of a transaction on the Fund Balance With Treasury. It is used in combination with the Treasury Account Symbol to classify transactions reported to Treasury through all Governmentwide Accounting financial management systems.
SENDER_DUNS NUMBER 9 The Dun and Bradstreet Data Universal Numbering System (DUNS) number of the sender. Obsolete
SENDER_DUNS_OR_UEI VARCHAR2 12 The Dun and Bradstreet Data Universal Numbering System (DUNS) number of the sender or the Unique Entity Identifier (UEI) for the System for Award Management (SAM) database that uniquely identifies entities that do business with the federal government.
SENDER_DUNS_PLUS_4 NUMBER 4 The Dun and Bradstreet Data Universal Numbering System (DUNS) number plus 4 of the sender. Obsolete
SENDER_DUNS_PLUS_4_OR_EFT VARCHAR2 4 The Dun and Bradstreet Data Universal Numbering System (DUNS) plus 4 or the Electronic Funds Transfer (EFT) indicator of the sender.
RECEIVER_DEPARTMENT_CODE VARCHAR2 30 Department code of the receiver.
ACCOUNTING_CLASSIFICATION_CODE VARCHAR2 30 Accounting classification code for the transaction.
ACRN_NUMBER VARCHAR2 30 Accounting Classification Reference Number that identifies a line of accounting on a contract.
JOB_PROJECT_NUMBER VARCHAR2 30 Job (Project) Number of the transaction being processed.
JAS_NUMBER VARCHAR2 30 A number that is a combination of the Job Order Number, Accounting Classification Record Number, and Site-ID for the transaction being processed.
FSN_AAA_ADSN_NUMBER NUMBER 9 Subdivision of ALC, an accounting station.
OBLIGATING_DOCUMENT_NUMBER VARCHAR2 30 The billing agency’s internal accounting document associated with a specific bill or disbursement.
ACT_TRACE_NUMBER NUMBER 30 The Accounting Trace (ACT) Number, a user-assigned identification number, for the transaction being processed.
DESCRIPTION VARCHAR2 500 Additional information to describe and support the transaction.
MISCELLANEOUS_INFORMATION VARCHAR2 500 Additional miscellaneous transaction information.
ORIGINAL_TRX_TYPE_CODE VARCHAR2 30 Type of the transaction from the original transaction. Valid values are P, C, or A.
IPAC_DOCUMENT_REF_NUMBER NUMBER 18 Document Reference Number for a transaction.
SENDER_DOS NUMBER 23 IPAC Disbursing Office Symbol for the ALC sending the transaction. Obsolete
SENDER_DOS_ALC VARCHAR2 25 IPAC Disbursing Office Symbol for the ALC sending the transaction.
DODAAC_CODE VARCHAR2 30 Identifies a Department of Defense activity location.
TRX_CONTACT_EMAIL_ADDRESS VARCHAR2 320 The email address of the IPAC transaction contact of the seller agency.
TRANSACTION_CONTACT_PHONE VARCHAR2 60 The phone number of the IPAC transaction contact of the seller agency.
VOUCHER_NUMBER VARCHAR2 30 Voucher number for the transaction.
ORIGINAL_DOS NUMBER 23 IPAC Disbursing Office Symbol of the sender of the original Payment or Collection transaction. Obsolete
ORIGINAL_DOS_ALC VARCHAR2 25 IPAC Disbursing Office Symbol of the sender of the original Payment or Collection transaction.
ORIGINAL_ACCOMPLISHED_DATE DATE Original accoumplished date of the transaction.
ORIGINAL_ACCOUNTING_DATE DATE Original accounting date of the transaction.
ORIGINAL_DOCUMENT_REF_NUMBER NUMBER 18 Original document reference number for a transaction.
SUMMARY_AMOUNT NUMBER Summary amount of the transaction.
RECORD_TYPE_CODE VARCHAR2 30 The code for the IPAC transaction record type that indicates whether the transaction is inbound or outbound. It is based on the lookup type ORA_FV_IPAC_RECORD_TYPE. Valid values are I and O.
USSGL_TRANSACTION_CODE VARCHAR2 30 USSGL transaction code for outbound transactions.
TAXPAYER_NUMBER VARCHAR2 50 USSGL transaction code for outbound transactions.
TAXPAYER_NAME VARCHAR2 360 Taxpayer name for the transaction.
TRX_SET_CODE VARCHAR2 30 The code that identifies the transaction set. Examples of values are 820 (indicating payment), 810 (indicating collection), and so on.
IPAC_BILLING_ID NUMBER 18 Billing identification number for the transaction.
CUSTOMER_ID NUMBER 18 Unique identifier of the customer.
CUSTOMER_NAME VARCHAR2 360 Name of the customer involved in the transaction.
CUSTOMER_TRX_ID NUMBER 18 Identifier for the customer transaction.
CREDIT_DEBIT_CODE VARCHAR2 30 Indicates the type of transaction and whether it is a credit transaction or a debit transaction. Valid values are: C, D.
ACCOUNTED_FLAG VARCHAR2 1 Indicates whether the transaction is accounted. Valid values are: Y,N.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield.
OBJECT_VERSION_NUMBER NUMBER 9 Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
AUDIT_ACTION_TYPE_ VARCHAR2 10 Audit action type. Valid values are INSERT, UPDATE, and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Stores a bitmap of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Audit impersonator account profile. All actions performed using the impersonator account are audited. Users can view audit history to retrieve the audited information that was filtered by an impersonated profile.

Indexes

Index Uniqueness Tablespace Columns
FV_IPAC_TRANSACTION_DATA_N1_ Non Unique FUSION_TS_TX_DATA TRANSACTION_DATA_ID
FV_IPAC_TRANSACTION_DATA_U1_ Unique FUSION_TS_TX_DATA LAST_UPDATE_DATE, LAST_UPDATED_BY, TRANSACTION_DATA_ID