FedIPACTransactionData
Returns the Intra-Governmental Payment and Collection transaction data captured for federal financials processing.
Columns
| Name | Type | SupportedFinders | Description |
| TransactionDataId [KEY] | Long | PrimaryKey | The unique identifier of the IPAC transaction data. |
| LoadDate | Date | The date on which the transaction data was loaded into Oracle Fusion Financials tables. | |
| ProcessDate | Date | The date on which the IPAC outbound process was run. | |
| Status | String | The status of the record being loaded. | |
| Message | String | Additional description for the transaction activity. | |
| TransactionId | Long | The unique identifier of the IPAC transaction. | |
| DetailLineNumber | Int | The transaction detail line number. | |
| DocumentId | Long | Used to store a unique identifier value which can be used for drill-down or reconciling flexibility. | |
| InvoiceNumber | String | Invoice number of the transaction. | |
| InvoiceAmount | Decimal | Invoice amount of the transaction. | |
| UserAttribute1 | String | Used for storing User Attribute 8. | |
| UserAttribute2 | String | Used for storing User Attribute 1. | |
| UserAttribute3 | String | Used for storing User Attribute 7. | |
| UserAttribute4 | String | Used for storing User Attribute 6. | |
| UserAttribute5 | String | Used for storing User Attribute 10. | |
| UserAttribute6 | String | Used for storing User Attribute 13. | |
| UserAttribute7 | String | Used for storing User Attribute 3. | |
| UserAttribute8 | String | Used for storing User Attribute 12. | |
| UserAttribute9 | String | Used for storing User Attribute 2. | |
| UserAttribute10 | String | Used for storing User Attribute 11. | |
| UserAttribute11 | String | Used for storing User Attribute 15 | |
| UserAttribute12 | String | Used for storing User Attribute 5. | |
| UserAttribute13 | String | Used for storing User Attribute 4. | |
| UserAttribute14 | String | Used for storing User Attribute 14. | |
| UserAttribute15 | String | Used for storing User Attribute 9. | |
| SubmitterALC | String | The agency location code (ALC) of the submitter. | |
| OriginatorALC | String | The agency location code (ALC) of the originator. | |
| CustomerALC | String | The agency location code of the customer. | |
| ContactName | String | The name of the contact person for the transaction. | |
| ContactEmailAddress | String | The email address of the contact person. | |
| ContactPhoneNumber | String | The phone number of the contact person. | |
| NumberOfDetailItems | Int | Number of detail lines in the transaction. | |
| AccomplishedDate | Date | The date on which the transaction occurred. | |
| AccountingDate | Date | Date on which the transaction was accounted in the system. | |
| PurchaseOrderNumber | String | The purchase order number of the transaction. | |
| CLIN | String | The Contract Line Item Number (CLIN) of the transaction. | |
| RequisitionNumber | String | The requisition number of the transaction. | |
| Quantity | Decimal | The number of items in the transaction. | |
| UnitOfIssue | String | The number of items that are being issued. | |
| UnitPrice | Decimal | The unit price of an item in the transaction. | |
| DetailAmount | Decimal | The detail amount of the transaction. | |
| PaymentCode | String | Indicates whether the payment for the transaction line amount is full or partial. | |
| FYObligationId | Long | The obligation identifier for the fiscal year. | |
| ReceiverTreasuryAccountSymbol | String | The receiver's treasury account symbol. | |
| ReceiverBETC | String | The receiver's type of activity. | |
| SenderTreasuryAccountSymbol | String | The sender's treasury account symbol. | |
| SenderBETC | String | The Identifier of the sender's type of activity. | |
| ReceiverDepartmentCode | String | The department code of the receiver. | |
| AccountingClassificationCode | String | Accounting classification code for the transaction. | |
| ACRN | String | The Accounting Classification Reference Number that identifies a line of accounting on a contract. | |
| JobProjectNumber | String | The job number of the transaction being processed. | |
| JASNumber | String | A number that's a combination of the Job Order Number, Accounting Classification Record Number, and Site-ID for the transaction being processed. | |
| FSNAAAADSN | Int | The accountable station code which is a combination of the Fiscal Station Number (FSN), the Authorization Accounting Activity (AAA), and the Accounting and Disbursing Station Number (ADSN). This is a subdivision of the agency location code (ALC). | |
| ObligatingDocumentNumber | String | The billing agency's internal accounting document associated with a specific bill or disbursement. | |
| ACTTraceNumber | Long | The Accounting Trace (ACT) number for the transaction being processed. | |
| Description | String | Additional information to describe and support the transaction. | |
| MiscellaneousInformation | String | Additional miscellaneous transaction information. | |
| OriginalTransactionType | String | The type of the transaction from the original transaction. | |
| IPACDocumentReferenceNumber | Long | Document reference number for a transaction. | |
| DoDAAC | String | Identifier for a Department of Defense activity location. | |
| TransactionContactEmailAddress | String | The email address of the IPAC transaction contact of the seller agency. | |
| TransactionContactPhone | String | The phone number of the IPAC transaction contact of the seller agency. | |
| VoucherNumber | String | The voucher number for the transaction. | |
| OriginalAccomplishedDate | Date | The original accomplished date of the transaction. | |
| OriginalAccountingDate | Date | The original accounting date of the transaction. | |
| OriginalDocumentReferenceNumber | Long | The original document reference number for the transaction. | |
| OriginalDoSymbolALC | String | The IPAC Disbursing Office Symbol (DOS) of the sender of the original payment or collection transaction. | |
| SenderDoSymbolALC | String | The IPAC Disbursing Office Symbol (DOS) for the agency location code (ALC) sending the transaction. | |
| ContractNumber | String | A unique number used to identify a contract between two trading partners. | |
| ReceiverDUNSorUEI | String | The Dun and Bradstreet Data Universal Numbering System (D-U-N-S) number of the receiver. | |
| ReceiverDUNSplus4OrEFT | String | The Dun and Bradstreet Data Universal Numbering System (D-U-N-S) number plus 4 of the receiver. | |
| SenderDUNSorUEI | String | The Dun and Bradstreet Data Universal Numbering System (D-U-N-S) number of the sender. | |
| SenderDUNSplus4OrEFT | String | The Dun and Bradstreet Data Universal Numbering System (D-U-N-S) number plus 4 of the sender. | |
| USSGLTransactionCode | String | USSGL transaction code for outbound transactions. | |
| TaxpayerNumber | String | Taxpayer number of the transaction. | |
| TransactionSetId | String | The code that identifies the transaction set. | |
| IPACBillingId | Long | Billing identification number for the transaction. | |
| CustomerId | Long | Unique identifier of the customer. | |
| CustomerName | String | Name of the customer involved in the transaction. | |
| CreditDebitCode | String | Identifier for the type of transaction whether it's a credit transaction or a debit transaction. | |
| CustomerTransactionId | Long | Identifier for the customer transaction. | |
| RecordType | String | RecordTypeFinder | The code for the IPAC transaction record type that indicates whether the transaction is inbound or outbound. |
| TransactionType | String | The type of the transaction being processed. | |
| Accounted | String | Value that identifies whether the transaction is accounted. | |
| CreatedBy | String | The user who created the row. | |
| CreationDate | Datetime | The date and time of the creation of the row. | |
| LastUpdatedBy | String | The user who last updated the row. | |
| LastUpdateDate | Datetime | The date and time of the last update of the row. | |
| LastUpdateLogin | String | The session login associated to the user who last updated the row. | |
| Finder | String | A named finder reference used to filter or locate specific IPAC transaction records when querying. |