TDV Adapter for Oracle Financials Cloud

Build 22.0.8462

StandardReceipts

StandardReceipts

Columns

Name Type Description
StandardReceiptId [KEY] String 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 String The document sequence number on the standard receipt.
Amount String 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 String The conversion rate between the standard receipt currency and the ledger currency.
State String 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 The status of the entered payment. The valid values are CONFIRMED, CLEARED, APPROVED, and REMITTED.
RemittanceBankName String The remittance bank name on the standard receipt.
RemittanceBankBranch String The remittance bank branch name on the standard receipt.
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 The tax payer identification number of the customer on the standard receipt.
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 The bank name of the customer on the standard receipt.
CustomerBankBranch String The bank branch name of the customer on the standard receipt.
CustomerBankAccountNumber String The bank account number of the customer on the standard receipt.
UnappliedAmount String The receipt amount that is unapplied to any transaction in the receipt currency.
AccountedAmount String The receipt amount in the functional currency.
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 Identifies whether the receipt is currently at risk with the remittance bank.
ReceivablesSpecialist String The Receivables specialist assigned to the standard receipt.
Comments String The comments about this receipt.
CreditCardTokenNumber String The token number issued by tokenization service provider corresponding to a credit card number.
CreditCardAuthorizationRequestIdentifier String 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
ReversalReason String ReversalReason
ReversalDate Date ReversalDate
ReversalComments String ReversalComments
ReceiptBatchName String ReceiptBatchName
ReceiptBatchDate Date ReceiptBatchDate
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 The user who created the record.
CreationDate Datetime The date when the record was created.
LastUpdateDate Datetime The date when the record was last updated.
LastUpdatedBy String The user who last updated the record.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462