1. Tables and Views for Financials
  2. FV_IPAC_TRANSACTION_DATA_INT

FV_IPAC_TRANSACTION_DATA_INT

This is an interface table to transfer data from IPAC file to federal finance transaction table.

Details

  • Schema: FUSION

  • Object owner: FV

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

fv_ipac_transaction_data_i_PK

TRANSACTION_ID, DETAIL_LINE_NUMBER, LOAD_REQUEST_ID

Columns

Name Datatype Length Precision Not-null Comments Status
TRANSACTION_ID NUMBER 18 Yes Unique identifier of the IPAC transaction data.
DETAIL_LINE_NUMBER NUMBER 3 Yes The transaction detail line number.
LOAD_REQUEST_ID NUMBER 18 Yes Enterprise Service Scheduler: Indicates the request ID of the interface load job that created the row.
TRANSACTION_TYPE_CODE VARCHAR2 30 Yes Type of the transaction being processed. Valid values are P, C, or A.
INVOICE_NUMBER VARCHAR2 30 Yes Invoice number of the transaction.
INVOICE_AMOUNT NUMBER Yes Invoice amount of the transaction.
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 Yes Number of items in the transaction.
UNIT_OF_ISSUE VARCHAR2 10 Yes Number of items that are being issued.
UNIT_PRICE NUMBER Yes Unit price of an item in the transaction.
DETAIL_AMOUNT NUMBER Yes 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 accomplished 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 the transaction.
SUMMARY_AMOUNT NUMBER Summary amount of the transaction.
CREATED_BY VARCHAR2 64 Yes 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.
OBJECT_VERSION_NUMBER NUMBER 9 Yes 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.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.

Indexes

Index Uniqueness Tablespace Columns
FV_IPAC_TRANS_DATA_INT_U1 Unique FUSION_TS_INTERFACE TRANSACTION_ID, DETAIL_LINE_NUMBER, LOAD_REQUEST_ID