ODBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

StandardReceipts

Tracks standard incoming payments (for example, checks, wire transfers), mapping them to customer accounts for settlement.

Table-Specific Information

Select

The driver uses the Oracle Fusion Cloud Financials API to process some of the filters having 'queryable'='true' in metadata. The driver processes other filters within the driver.

For example, the following query is processed server-side: 

SELECT * FROM [Cdata].[Financials].[StandardReceipts] WHERE StandardReceiptId = 10003

Insert

Create an StandardReceipt. 

INSERT INTO [Cdata].[Financials].[StandardReceipts] (RemittanceBankAccountNumber,ReceiptMethod,Amount,Currency,ReceiptNumber,BusinessUnit) VALUES ('XXXXXXX8642','Check (Directly/No Remit)',2212.75,'USD','140811-11','ABCD')

If you want to add child views/tables along with the parent table, you can add the child in one of the following ways.

  • Using the TEMP table: 

    INSERT INTO StandardReceiptsremittanceReferences#TEMP(ReceiptMatchBy,ReferenceNumber,ReferenceAmount) VALUES ('Purchase Order','SK_PO_1012',25.35);
INSERT INTO [Cdata].[Financials].[StandardReceipts] (RemittanceBankAccountNumber,ReceiptMethod,Amount,Currency,ReceiptNumber,BusinessUnit,remittanceReferences) VALUES ('XXXXXXX8642','Check (Directly/No Remit)',2212.75,'USD','140811-11','ABCD','StandardReceiptsremittanceReferences#TEMP')

  • Directly providing the aggregate: 

    INSERT INTO [Cdata].[Financials].[StandardReceipts] (RemittanceBankAccountNumber,ReceiptMethod,Amount,Currency,ReceiptNumber,BusinessUnit,remittanceReferences) VALUES ('XXXXXXX8642','Check (Directly/No Remit)',2212.75,'USD','140811-11','ABCD','[{
    "ReceiptMatchBy":"Purchase Order",
    "ReferenceNumber":"SK_PO_1012",
    "ReferenceAmount":8774.45
}]')

Update

The Oracle Fusion Cloud Financials API uses StandardReceiptUniqId instead of StandardReceiptId as a path parameter in the URL to update the record.

If you want to update a record directly using the Id (without any other filter), you can update the record in the following way: 

UPDATE [Cdata].[Financials].[StandardReceipts] SET Comments='abcd' WHERE StandardReceiptUniqId=454545454

Note: This does not require an extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter, use StandardReceiptId instead of StandardReceiptUniqId. You can update the record in the following way: 

UPDATE [Cdata].[Financials].[StandardReceipts] SET Comments='abcd' WHERE StandardReceiptId=454545454 AND CustomerAccountNumber="1004"

Note: Update on aggregates are not allowed by the API. Use the child tables to add/update/delete aggregates.

Delete

The Oracle Fusion Cloud Financials API uses StandardReceiptUniqId instead of StandardReceiptId as a path parameter in the URL to delete the record.

If you want to delete a record directly using the Id (without any other filter), you can delete the record in the following way: 

DELETE FROM [Cdata].[Financials].[StandardReceipts] WHERE StandardReceiptUniqId=454545454

Note: This does not require an extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter, use StandardReceiptId instead of StandardReceiptUniqId. You can delete the record in the following way: 

DELETE FROM [Cdata].[Financials].[StandardReceipts] WHERE StandardReceiptId=454545454 AND CustomerAccountNumber="1004"

Columns

Name Type ReadOnly Description
StandardReceiptId [KEY] Long False

The unique identifier of the standard receipt, used to reference and manage the receipt in the system.

StandardReceiptUniqId [KEY] String True

The unique identifier for the standard receipt. This value should be used in insert, update, and delete operations, replacing StandardReceiptId where applicable.

ReceiptNumber String False

The unique number assigned to the standard receipt, used for tracking and managing the receipt in the financial system.

BusinessUnit String False

A unit within the organization that performs specific business functions. Business units are used to classify receipts for reporting and management purposes.

ReceiptMethod String False

The method of payment or receipt used, such as cash, check, or bank transfer.

ReceiptDate Date False

The date when the standard receipt was created or processed.

DocumentNumber Long False

The document sequence number associated with the standard receipt, used for document management and identification.

Amount Decimal False

The total amount of the standard receipt in the receipt's currency.

Currency String False

The currency used for the standard receipt, reflecting the type of money in which the receipt is issued.

ConversionRateType String False

The type of conversion rate used for converting the receipt currency into the ledger's functional currency.

ConversionDate Date False

The date on which the conversion rate was applied to the receipt, typically aligned with the transaction date.

ConversionRate Decimal False

The specific conversion rate between the receipt's currency and the ledger's functional currency, used for financial reporting.

State String True

The state of the current payment entry progress, indicating the status of funds applied to the receipt. Valid states include APPLIED, UNAPPLIED, UNIDENTIFIED, INSUFFICIENT FUNDS, REVERSE PAYMENT, and STOP PAYMENT.

Status String True

The current status of the entered payment, indicating the processing stage. Valid statuses include CONFIRMED, CLEARED, APPROVED, and REMITTED.

RemittanceBankName String True

The name of the bank used for remitting funds related to the standard receipt.

RemittanceBankBranch String True

The name of the specific bank branch handling the remittance for the standard receipt.

RemittanceBankAccountNumber String False

The account number at the remittance bank where the funds for the standard receipt are deposited.

RemittanceBankDepositDate Date False

The date when the funds for the standard receipt were deposited by the remittance bank.

RemittanceBankAllowOverride String False

An option that allows for overriding the remittance account used during the receipt process.

CustomerName String False

The name of the customer associated with the standard receipt, typically reflecting the payer or the entity receiving the receipt.

TaxpayerIdentificationNumber String True

The Tax Indentification Number (TIN) of the customer associated with the standard receipt, used for tax reporting and identification.

CustomerSite String False

The customer site associated with the receipt, indicating the physical or legal address associated with the transaction.

CustomerAccountNumber String False

The account number of the customer within the receivables system, used for account tracking and reconciliation.

CustomerBank String True

The name of the bank where the customer holds their account, used for financial transactions related to the receipt.

CustomerBankBranch String True

The specific branch of the bank where the customer holds their account, used for detailed banking operations.

CustomerBankAccountNumber String False

The bank account number held by the customer, which is linked to the standard receipt for payment processing.

UnappliedAmount Decimal True

The portion of the receipt that has not yet been applied to any transactions or balances in the system.

AccountedAmount Decimal True

The portion of the receipt that has been accounted for in the ledger currency, used for financial reporting.

AccountingDate Date False

The date when the standard receipt is accounted in the financial records.

MaturityDate Date False

The date when the standard receipt reaches maturity and payment is expected or due.

PostmarkDate Date False

The date when the receipt was postmarked, typically used for cash receipt processing or deposit timing.

ReceiptAtRisk String True

Indicates whether the receipt is at risk with the remittance bank, typically referring to issues like a potential reversal or a stop payment.

ReceivablesSpecialist String True

The specialist within the receivables department responsible for managing and overseeing the standard receipt.

Comments String False

User-defined comments providing additional context or information about the receipt.

CreditCardTokenNumber String False

The token number generated by a tokenization service provider to securely represent a credit card number used for the standard receipt.

CreditCardAuthorizationRequestIdentifier Long False

The identifier associated with the credit card authorization request used to verify the transaction.

CardHolderFirstName String False

The first name of the credit card holder who is associated with the standard receipt.

CardHolderLastName String False

The last name of the credit card holder associated with the standard receipt.

CreditCardIssuerCode String False

The code representing the credit card issuer, such as Visa, MasterCard, or American Express.

CreditCardExpirationDate String False

The expiration date of the credit card used for the payment of the standard receipt.

VoiceAuthorizationCode String False

The voice authorization code provided by the tokenization service for phone-based credit card authorization.

ReversalCategory String True

The category of the reversal, if the standard receipt is reversed, indicating the reason for the reversal.

ReversalReason String True

The reason for reversing the standard receipt, used for tracking and reporting purposes.

ReversalDate Date True

The date when the standard receipt was reversed, if applicable.

ReversalComments String True

Comments associated with the reversal of the standard receipt, used to document the reason for reversal.

ReceiptBatchName String True

The name of the batch to which the standard receipt belongs, typically used for organizing and processing multiple receipts together.

ReceiptBatchDate Date True

The date when the receipt batch was processed, used for tracking the timing of grouped receipt entries.

StructuredPaymentReference String False

A standardized reference code used to identify the transaction and its payments between the customer and the bank.

CreatedBy String True

The user who created the standard receipt record, used for auditing and tracking purposes.

CreationDate Datetime True

The date and time when the standard receipt record was created in the system.

LastUpdateDate Datetime True

The date and time when the standard receipt record was last updated in the system.

LastUpdatedBy String True

The user who last updated the standard receipt record, used for auditing and tracking purposes.

remittanceReferences String False

This field is used for insert operations and should not be used for update or delete actions directly. Refer to the child table for these operations.

standardReceiptGdf String False

This field is used for insert operations only. For updates and deletions, refer to the child table's operations.

standardReceiptDFF String False

This field is used for insert operations only. For updates and deletions, refer to the child table's operations.

Finder String True

A generic identifier used for finding the standard receipt in queries or searches.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434