ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9111

StandardReceipts

The standard receipts resource is used to create standard receipts in Receivables to record payment from customers for goods received or services rendered.

Table Specific Information

Select

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

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 following ways:

  • Using 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 any extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter. Please 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 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 any extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter. Please 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.

StandardReceiptUniqId [KEY] String True

The unique identifier of the standard receipt. Use this column's value in insert, update and delete operations, wherever applicable, instead of StandardReceiptId

ReceiptNumber String False

The receipt number of the standard receipt.

BusinessUnit String False

A unit of an enterprise that performs one or more business functions that can be accumulated in a management hierarchy.

ReceiptMethod String False

The receipt method used on the standard receipt.

ReceiptDate Date False

The date when the standard receipt was created.

DocumentNumber Long False

The document sequence number on the standard receipt.

Amount Decimal False

The amount of a standard receipt.

Currency String False

The currency of a standard receipt.

ConversionRateType String False

The conversion rate type of a standard receipt.

ConversionDate Date False

The date when the standard receipt was converted.

ConversionRate Decimal False

The conversion rate between the standard receipt currency and the ledger currency.

State String True

The state of the current payment entry progress in the standard receipt. The valid values are APPLIED, UNAPPLIED, UNIDENTIFIED, INSUFFICIENT FUNDS, REVERSE PAYMENT, and STOP PAYMENT.

Status String True

The status of the entered payment. The valid values are CONFIRMED, CLEARED, APPROVED, and REMITTED.

RemittanceBankName String True

The remittance bank name on the standard receipt.

RemittanceBankBranch String True

The remittance bank branch name on the standard receipt.

RemittanceBankAccountNumber String False

The remittance bank account number on the standard receipt.

RemittanceBankDepositDate Date False

The date when the standard receipt was deposited.

RemittanceBankAllowOverride String False

The options that allow the remittance selection process to override the remittance account on a standard receipt.

CustomerName String False

The name of the customer on the standard receipt.

TaxpayerIdentificationNumber String True

The tax payer identification number of the customer on the standard receipt.

CustomerSite String False

The customer site of the customer on the standard receipt.

CustomerAccountNumber String False

The customer account number of the customer on the standard receipt.

CustomerBank String True

The bank name of the customer on the standard receipt.

CustomerBankBranch String True

The bank branch name of the customer on the standard receipt.

CustomerBankAccountNumber String False

The bank account number of the customer on the standard receipt.

UnappliedAmount Decimal True

The receipt amount that is unapplied to any transaction in the receipt currency.

AccountedAmount Decimal True

The receipt amount in the functional currency.

AccountingDate Date False

The date when the standard receipt is accounted.

MaturityDate Date False

The date when the standard receipt is matured.

PostmarkDate Date False

The date when the standard receipt is postmarked.

ReceiptAtRisk String True

Identifies whether the receipt is currently at risk with the remittance bank.

ReceivablesSpecialist String True

The Receivables specialist assigned to the standard receipt.

Comments String False

The comments about this receipt.

CreditCardTokenNumber String False

The token number issued by tokenization service provider corresponding to a credit card number.

CreditCardAuthorizationRequestIdentifier Long False

The authorization request identifier received from the tokenization service provider to authorize the credit card number.

CardHolderFirstName String False

The first name of the credit card holder.

CardHolderLastName String False

The last name of the credit card holder.

CreditCardIssuerCode String False

The code for the credit card issuer, such as Visa or MasterCard.

CreditCardExpirationDate String False

The date when the credit card expires.

VoiceAuthorizationCode String False

The voice authorization code received from tokenization service provider for authorization.

ReversalCategory String True

ReversalCategory of StandardReceipts

ReversalReason String True

ReversalReason of StandardReceipts

ReversalDate Date True

ReversalDate of StandardReceipts

ReversalComments String True

ReversalComments of StandardReceipts

ReceiptBatchName String True

ReceiptBatchName of StandardReceipts

ReceiptBatchDate Date True

ReceiptBatchDate of StandardReceipts

StructuredPaymentReference String False

An industry standard reference on Receivables transactions composed of letters, check digits, and transaction information, used to identify the transaction and its payments to the customer and bank.

CreatedBy String True

The user who created the record.

CreationDate Datetime True

The date when the record was created.

LastUpdateDate Datetime True

The date when the record was last updated.

LastUpdatedBy String True

The user who last updated the record.

remittanceReferences String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

standardReceiptGdf String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

standardReceiptDFF String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

Finder String True

finder

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9111