Tableau Connector for Oracle Fusion Cloud Financials

Build 24.0.9062

StandardReceipts

The standard receipts resource is used to create standard receipts in Receivables to record payment from customers for goods received or services rendered. Standard receipts can be applied to one or more transactions. One or more remittance references can also be provided for applying the receipt to the transactions when the Apply Receipts Using AutoMatch process is run asynchronously.

Columns

Name Type Description
StandardReceiptId [KEY] Long The unique identifier of the standard receipt.
ReceiptNumber String The receipt number of the standard receipt.
BusinessUnit String A unit of an enterprise that performs one or more business functions that can be accumulated in a management hierarchy.
ReceiptMethod String The receipt method used on the standard receipt.
ReceiptDate Date The date when the standard receipt was created.
DocumentNumber Long The document sequence number on the standard receipt.
Amount Decimal The amount of a standard receipt.
Currency String The currency of a standard receipt.
ConversionRateType String The conversion rate type of a standard receipt.
ConversionDate Date The date when the standard receipt was converted.
ConversionRate Decimal The conversion rate between the standard receipt currency and the ledger currency.
State String State of StandardReceipts
Status String Status of StandardReceipts
RemittanceBankName String RemittanceBankName of StandardReceipts
RemittanceBankBranch String RemittanceBankBranch of StandardReceipts
RemittanceBankAccountNumber String The remittance bank account number on the standard receipt.
RemittanceBankDepositDate Date The date when the standard receipt was deposited.
RemittanceBankAllowOverride String The options that allow the remittance selection process to override the remittance account on a standard receipt.
CustomerName String The name of the customer on the standard receipt.
TaxpayerIdentificationNumber String TaxpayerIdentificationNumber of StandardReceipts
CustomerSite String The customer site of the customer on the standard receipt.
CustomerAccountNumber String The customer account number of the customer on the standard receipt.
CustomerBank String CustomerBank of StandardReceipts
CustomerBankBranch String CustomerBankBranch of StandardReceipts
CustomerBankAccountNumber String The bank account number of the customer on the standard receipt.
UnappliedAmount Decimal UnappliedAmount of StandardReceipts
AccountedAmount Decimal AccountedAmount of StandardReceipts
AccountingDate Date The date when the standard receipt is accounted.
MaturityDate Date The date when the standard receipt is matured.
PostmarkDate Date The date when the standard receipt is postmarked.
ReceiptAtRisk String ReceiptAtRisk of StandardReceipts
ReceivablesSpecialist String ReceivablesSpecialist of StandardReceipts
Comments String The comments about this receipt.
CreditCardTokenNumber String The token number issued by tokenization service provider corresponding to a credit card number.
CreditCardAuthorizationRequestIdentifier Long The authorization request identifier received from the tokenization service provider to authorize the credit card number.
CardHolderFirstName String The first name of the credit card holder.
CardHolderLastName String The last name of the credit card holder.
CreditCardIssuerCode String The code for the credit card issuer, such as Visa or MasterCard.
CreditCardExpirationDate String The date when the credit card expires.
VoiceAuthorizationCode String The voice authorization code received from tokenization service provider for authorization.
ReversalCategory String ReversalCategory of StandardReceipts
ReversalReason String ReversalReason of StandardReceipts
ReversalDate Date ReversalDate of StandardReceipts
ReversalComments String ReversalComments of StandardReceipts
ReceiptBatchName String ReceiptBatchName of StandardReceipts
ReceiptBatchDate Date ReceiptBatchDate of StandardReceipts
StructuredPaymentReference String 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 CreatedBy of StandardReceipts
CreationDate Datetime CreationDate of StandardReceipts
LastUpdateDate Datetime LastUpdateDate of StandardReceipts
LastUpdatedBy String LastUpdatedBy of StandardReceipts
Finder String Finder of StandardReceipts

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