Get all external transactions
get
/fscmRestApi/resources/11.13.18.05/cashExternalTransactions
Request
Query Parameters
-
expand: string
When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
-
fields: string
This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
Format: ?fields=Attribute1,Attribute2
Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2 -
finder: string
Used as a predefined finder to search the collection.
Format: ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>
The following are the available finder names and corresponding finder variables:- ExternalCashTransactionsFinder: Finds external transactions based on a combination of different query parameters.
Finder Variables:- bindBankAccountId; integer; The bank account identifier associated to the external transaction.
- bindBankAccountName; string; The name of the bank account associated with the external transaction.
- bindCurrencyCode; string; The currency code of the external transaction.
- bindTransactionDate; string; The transaction date of the external transaction.
- bindTransactionId; integer; The transaction identifier of the external transaction.
- bindTransactionReference; string; The reconciliation reference of the external transaction.
- bindTransactionSource; string; The source of the external transaction.
- bindTransactionStatus; string; The status of the external transaction.
- bindTransactionType; string; The transaction type of the external transaction.
- PrimaryKey: Find the external transaction based on the primary key.
Finder Variables:- ExternalTransactionId; integer; The unique identifier of the external transaction.
- findByTransactionBankAccountId: Finds the external transaction that matches the specified bank account identifier.
Finder Variables:- bindBankAccountId; integer; The bank account identifier associated to the external transaction.
- findByTransactionCurrencyCode: Finds external transactions based on the specified currency code.
Finder Variables:- bindCurrencyCode; string; The currency code of the external transaction.
- findByTransactionDate: Finds external transactions based on the specified transaction date.
Finder Variables:- bindTransactionDate; string; The transaction date of the external transaction.
- findByTransactionId: Finds the external transaction based on the specified transaction identifier.
Finder Variables:- bindTransactionId; integer; The transaction identifier of the external transaction.
- findByTransactionReference: Finds external transactions based on the specified transaction reference.
Finder Variables:- bindTransactionReference; string; The transaction reference of the external transaction.
- findByTransactionSource: Finds external transactions based on the specified transaction source.
Finder Variables:- bindTransactionSource; string; Transaction source of the external transaction.
- findByTransactionStatus: Finds external transactions based on the specified transaction status.
Finder Variables:- bindTransactionStatus; string; The status of the external transaction.
- findByTransactionType: Finds external transactions based on the specified transaction type.
Finder Variables:- bindTransactionType; string; Transaction type of the external transaction.
- ExternalCashTransactionsFinder: Finds external transactions based on a combination of different query parameters.
-
limit: integer
This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
-
links: string
This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
Example:
self,canonical -
offset: integer
Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
-
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
-
orderBy: string
This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
-
q: string
This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY
Format: ?q=expression1;expression2
You can use these queryable attributes to filter this collection resource using the q query parameter:- AccntServicerReference; string; The reference number assigned by the account servicing institution for the underlying payment, receipt, external transaction, or payroll payment.
- AccountingFlag; boolean; The option that indicates whether the accounting event is raised when the external transaction is reconciled.
- AddendaTxt; string; Additional information about the entry details.
- Amount; number; The transaction amount of the external transaction.
- AssetAccountCombination; string; The cash general ledger account code combination of the external transaction.
- BankAccountName; string; The name of the bank account associated to the external transaction.
- BankConversionRate; number; The accounting conversion rate used to convert the external transaction amount from the bank account currency to the ledger currency.
- BankConversionRateType; string; The accounting conversion rate type used to convert the external transaction amount from the bank account currency to the ledger currency.
- BankTransactionId; string; Unique identifier of the bank transaction on the statement line.
- BusinessUnitName; string; The name of the business unit associated to the external transaction.
- CheckNumber; string; The check number of the underlying transaction.
- ClearedDate; string; The date when the external transaction is cleared.
- ClearingSystemReference; string; The unique identifier assigned by the clearing system to a payment instruction.
- CreatedBy; string; The user who created the external transaction.
- CreationDate; string; The date and time when the external transaction was created.
- CurrencyCode; string; The currency code of the external transaction.
- CustomerReference; string; The customer reference used by BAI format.
- Description; string; The description of the external transaction.
- EndToEndId; string; The unique identification assigned by the initiating party to the transaction. It's passed on unchanged throughout the entire end to end chain.
- ExternalTransactionId; integer; The unique identifier of the external transaction.
- InstructionIdentification; string; The unique identification which is a point to point reference used between the instructing party and the instructed party to refer to an individual instruction. It's assigned by the instructing party to the instructed party and can be included in several messages related to the instruction.
- LastUpdateDate; string; The date and time when the external transaction was last updated.
- LastUpdateLogin; string; The session login associated with the user who last updated the external transaction.
- LastUpdatedBy; string; The user who last updated the external transaction.
- LegalEntityName; string; The name of the legal entity associated to the external transaction.
- OffsetAccountCombination; string; The offset general ledger account code combination of the external transaction.
- ReconReference; string; The reference to the underlying transaction information.
- ReferenceText; string; The reconciliation reference of the external transaction.
- Source; string; The source of the external transaction. The default value is Imported.
- Status; string; The status of the external transaction. The default value is UNR for Unreconciled. Unreconciled external transactions can be rendered as void by updating this attribute to VOID.
- StructuredPaymentReference; string; The structured payment reference or receipt reference on the bank statement line.
- TransactionDate; string; The date when the external transaction is created.
- TransactionId; integer; The sequence number transaction identifier of the external transaction.
- TransactionType; string; The transaction type of the external transaction. Examples include Bank adjustment, Fee, Check, Electronic funds transfer, Interest, Zero balancing, Lockbox, Miscellaneous, and Automated clearing house. A list of accepted values is defined in the lookup type CE_TRX_TYPE.
- TransferId; integer; The unique identifier of the bank account transfer or the ad hoc payment that created the external transaction.
- ValueDate; string; The actual value date of the external transaction.
-
totalResults: boolean
The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
Header Parameters
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
Default Response
The following table describes the default response for this task.
Headers
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Root Schema : cashExternalTransactions
Type:
Show Source
object
-
count(required): integer
The number of resource instances returned in the current range.
-
hasMore(required): boolean
Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
-
items: array
Items
Title:
Items
The items in the collection. -
limit(required): integer
The actual paging size used by the server.
-
links(required): array
Links
Title:
Links
The link relations associated with the resource instance. -
offset(required): integer
The offset value used in the current page.
-
totalResults: integer
The estimated row count when "?totalResults=true", otherwise the count is not included.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : cashExternalTransactions-item-response
Type:
Show Source
object
-
AccntServicerReference: string
Title:
Account Servicer Reference
Read Only:true
Maximum Length:50
The reference number assigned by the account servicing institution for the underlying payment, receipt, external transaction, or payroll payment. -
AccountingFlag: boolean
Maximum Length:
1
Default Value:true
The option that indicates whether the accounting event is raised when the external transaction is reconciled. -
AddendaTxt: string
Title:
Additional Entry Information
Read Only:true
Maximum Length:1000
Additional information about the entry details. -
Amount: number
The transaction amount of the external transaction.
-
AssetAccountCombination: string
The cash general ledger account code combination of the external transaction.
-
attachments: array
Attachments
Title:
Attachments
The attachments resource manages documents that are attached by the user to the external transaction. -
BankAccountName: string
Maximum Length:
360
The name of the bank account associated to the external transaction. -
BankConversionRate: number
The accounting conversion rate used to convert the external transaction amount from the bank account currency to the ledger currency.
-
BankConversionRateType: string
Maximum Length:
30
The accounting conversion rate type used to convert the external transaction amount from the bank account currency to the ledger currency. -
BankTransactionId: string
Read Only:
true
Maximum Length:20
Unique identifier of the bank transaction on the statement line. -
BusinessUnitName: string
The name of the business unit associated to the external transaction.
-
cashExternalTransactionDFF: array
Descriptive Flexfields
Title:
Descriptive Flexfields
The descriptive flexfields resource manages details about the descriptive flexfield references for an external transaction. -
CheckNumber: string
Title:
Check Number
Read Only:true
Maximum Length:40
The check number of the underlying transaction. -
ClearedDate: string
(date)
The date when the external transaction is cleared.
-
ClearingSystemReference: string
Title:
Clearing System Reference
Read Only:true
Maximum Length:50
The unique identifier assigned by the clearing system to a payment instruction. -
CreatedBy: string
Read Only:
true
Maximum Length:64
The user who created the external transaction. -
CreationDate: string
(date-time)
Read Only:
true
The date and time when the external transaction was created. -
CurrencyCode: string
Maximum Length:
15
The currency code of the external transaction. -
CustomerReference: string
Title:
Customer Reference
Read Only:true
Maximum Length:30
The customer reference used by BAI format. -
Description: string
Maximum Length:
360
The description of the external transaction. -
EndToEndId: string
Title:
End to End ID
Read Only:true
Maximum Length:100
The unique identification assigned by the initiating party to the transaction. It's passed on unchanged throughout the entire end to end chain. -
ExternalTransactionId: integer
(int64)
The unique identifier of the external transaction.
-
InstructionIdentification: string
Title:
Instruction ID
Read Only:true
Maximum Length:100
The unique identification which is a point to point reference used between the instructing party and the instructed party to refer to an individual instruction. It's assigned by the instructing party to the instructed party and can be included in several messages related to the instruction. -
LastUpdateDate: string
(date-time)
Read Only:
true
The date and time when the external transaction was last updated. -
LastUpdatedBy: string
Read Only:
true
Maximum Length:64
The user who last updated the external transaction. -
LastUpdateLogin: string
Read Only:
true
Maximum Length:32
The session login associated with the user who last updated the external transaction. -
LegalEntityName: string
The name of the legal entity associated to the external transaction.
-
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
OffsetAccountCombination: string
The offset general ledger account code combination of the external transaction.
-
ReconReference: string
Title:
Reconciliation Reference
Read Only:true
Maximum Length:50
The reference to the underlying transaction information. -
ReferenceText: string
Maximum Length:
50
The reconciliation reference of the external transaction. -
Source: string
Maximum Length:
30
Default Value:MANUAL
The source of the external transaction. The default value is Imported. -
Status: string
Maximum Length:
30
Default Value:UNR
The status of the external transaction. The default value is UNR for Unreconciled. Unreconciled external transactions can be rendered as void by updating this attribute to VOID. -
StructuredPaymentReference: string
Read Only:
true
Maximum Length:256
The structured payment reference or receipt reference on the bank statement line. -
TransactionDate: string
(date)
The date when the external transaction is created.
-
TransactionId: integer
(int64)
The sequence number transaction identifier of the external transaction.
-
TransactionType: string
Maximum Length:
30
The transaction type of the external transaction. Examples include Bank adjustment, Fee, Check, Electronic funds transfer, Interest, Zero balancing, Lockbox, Miscellaneous, and Automated clearing house. A list of accepted values is defined in the lookup type CE_TRX_TYPE. -
TransferId: integer
(int64)
The unique identifier of the bank account transfer or the ad hoc payment that created the external transaction.
-
ValueDate: string
(date)
The actual value date of the external transaction.
Nested Schema : Attachments
Type:
array
Title:
Attachments
The attachments resource manages documents that are attached by the user to the external transaction.
Show Source
Nested Schema : Descriptive Flexfields
Type:
array
Title:
Descriptive Flexfields
The descriptive flexfields resource manages details about the descriptive flexfield references for an external transaction.
Show Source
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : cashExternalTransactions-attachments-item-response
Type:
Show Source
object
-
AsyncTrackerId: string
Title:
Asynchronous Upload Tracker Id
Attribute provided for the exclusive use by the Attachment UI components to assist in uploading files. -
AttachedDocumentId: integer
(int64)
Title:
Attached Document Id
The unique identifier of the attached document. -
CategoryName: string
Title:
Category
Maximum Length:30
The category of the attachment. - ContentRepositoryFileShared: boolean
-
CreatedBy: string
Title:
Created By
Read Only:true
Maximum Length:255
The user who created the record. -
CreatedByUserName: string
Title:
Created By User Name
Read Only:true
The user who created the record. -
CreationDate: string
(date-time)
Title:
Creation Date
Read Only:true
The date and time when the record was created. -
DatatypeCode: string
Title:
Type
Maximum Length:30
Default Value:FILE
The type of the attachment. -
Description: string
Title:
Description
Maximum Length:255
The description for the attachment. -
DmDocumentId: string
Maximum Length:
255
The unique identifier of the attachment. -
DmFolderPath: string
Title:
Dm Folder Path
Maximum Length:1000
The folder path of the attachment. -
DmVersionNumber: string
Maximum Length:
255
The version number of the attachment. -
DownloadInfo: string
Title:
DownloadInfo
JSON object represented as a string containing information used to programmatically retrieve a file attachment. -
ErrorStatusCode: string
Title:
Error Status Code
The error code, if any, for the attachment. -
ErrorStatusMessage: string
Title:
Error Status Message
The error message, if any, for the attachment. -
ExpirationDate: string
(date-time)
Title:
Expiration Date
The expiration date of the contents in the attachment. -
FileContents: string
(byte)
Title:
File Contents
The contents of the attachment. -
FileName: string
Title:
File Name
Maximum Length:2048
The file name of the attachment. -
FileUrl: string
Title:
File Url
The URL of the attachment. -
FileWebImage: string
(byte)
Title:
File Web Image
Read Only:true
The base64 encoded image of the file displayed in .png format if the source is a convertible image. -
LastUpdateDate: string
(date-time)
Title:
Last Update Date
Read Only:true
The date when the record was last updated. -
LastUpdatedBy: string
Title:
Last Updated By
Read Only:true
Maximum Length:255
The user who last updated the record. -
LastUpdatedByUserName: string
Title:
Last Updated By User
Read Only:true
The user who last updated the record. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
PostProcessingAction: string
Title:
PostProcessingAction
The name of the action that can be performed after an attachment is uploaded. -
Title: string
Title:
Title
The title of the attachment. -
UploadedFileContentType: string
Title:
Uploaded File Content Type
The content type of the attachment. -
UploadedFileLength: integer
Title:
File Size
The length of the attachment file. -
UploadedFileName: string
Title:
Uploaded File Name
The name of the attachment file. -
UploadedText: string
Title:
Uploaded Text
The text of the attachment. -
Uri: string
Title:
Uri
Maximum Length:4000
The URI of the attachment. -
Url: string
Title:
Url
Maximum Length:4000
The URL of the attachment. -
UserName: string
Title:
User Name
Read Only:true
Maximum Length:255
The user who created the attachment.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object
-
href: string
Title:
hyperlink reference
The URI to the related resource. -
kind: string
Title:
kind
Allowed Values:[ "collection", "item", "describe", "other" ]
The kind of the related resource. -
name: string
Title:
name
The name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relation
Allowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]
The name of the relation to the resource instance. Example: self.
Nested Schema : properties
Type:
Show Source
object
-
changeIndicator: string
Change indicator or the ETag value of the resource instance.
Nested Schema : cashExternalTransactions-cashExternalTransactionDFF-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Context Value
Maximum Length:30
The descriptive flexfield context name for external transactions. -
__FLEX_Context_DisplayValue: string
Title:
Context Value
The descriptive flexfield context display value for external transactions. -
ExternalTransactionId: integer
(int64)
The unique external transaction identifier.
-
links: array
Links
Title:
Links
The link relations associated with the resource instance.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Links
- getCurrentDatabaseDate
-
Custom actions are deprecated for this resource.
- getbindBankAccountId
-
Custom actions are deprecated for this resource.
- getbindCurrencyCode
-
Custom actions are deprecated for this resource.
- getbindTransactionDate
-
Custom actions are deprecated for this resource.
- getbindTransactionReference
-
Custom actions are deprecated for this resource.
- getbindTransactionSource
-
Custom actions are deprecated for this resource.
- getbindTransactionStatus
-
Custom actions are deprecated for this resource.
- getbindTransactionType
-
Custom actions are deprecated for this resource.
- gettransactionId
-
Custom actions are deprecated for this resource.
- initMOAC
-
Custom actions are deprecated for this resource.
- prepareVOForQuery
-
Custom actions are deprecated for this resource.
- setbindBankAccountId
-
Custom actions are deprecated for this resource.
- setbindCurrencyCode
-
Custom actions are deprecated for this resource.
- setbindTransactionDate
-
Custom actions are deprecated for this resource.
- setbindTransactionReference
-
Custom actions are deprecated for this resource.
- setbindTransactionSource
-
Custom actions are deprecated for this resource.
- setbindTransactionStatus
-
Custom actions are deprecated for this resource.
- setbindTransactionType
-
Custom actions are deprecated for this resource.
- settransactionId
-
Custom actions are deprecated for this resource.
Examples
The following example shows how to retrieve all the external transactions by submitting a GET request on the REST resource using cURL.
curl -i -u "<username>:<password>" -H "Content-Type: application/vnd.oracle.adf.resourcecollection+json" -X GET https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/cashExternalTransactions
Example Response Body
The following example shows the contents of the response body in JSON format:
{ "items" : [ { "AccountingFlag" : true, "Amount" : 1250, "ClearedDate" : null, "CreatedBy" : "CASH_MANAGER", ... "links" : [ { "rel" : "self", "href" : "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/cashExternalTransactions/100000012512575", "name" : "cashExternalTransactions", "kind" : "item", "properties" : { "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000378" } }, { "rel" : "child", "href" : "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/cashExternalTransactions/100000012512575/child/attachments", "name" : "attachments", "kind" : "collection" }, ... ] }, ... ], "count" : 177, "hasMore" : false, "limit" : 500, "offset" : 0, "links" : [ { "rel" : "self", "href" : "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/cashExternalTransactions", "name" : "cashExternalTransactions", "kind" : "collection" }, { "rel" : "action", "href" : "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/cashExternalTransactions/action/prepareVOForQuery", "name" : "prepareVOForQuery", "kind" : "other" }, ... ] }