ReceivablesManualReceiptBatch
The Receivables Manual Receipt Batch and Receivables Automatic Receipt Batch business object provides information that includes the receipt batch name, the total number of receipts in the batch, the total receipt amount, currency, and the deposit date and accounting date, as well as information about each receipt in the manual or automatic receipt batch.
Business Views
** Available for extracting data- receivablesManualReceiptBatchesExtract**
The Receivables Manual Receipt Batch and Receivables Automatic Receipt Batch business object provides information that includes the receipt batch name, the total number of receipts in the batch, the total receipt amount, currency, and the deposit date and accounting date, as well as information about each receipt in the manual or automatic receipt batch.
Label, Plural Label
Receivables Manual Receipt Batches, Receivables Manual Receipt Batches
Data Source
Read-optimized data store
Fields
- accountingDate (date)
The receipt batch accounting date.
Label
Accounting Date
- actualAmount (big-decimal)
The receipt batch total amount.
Label
Actual Amount
- actualCount (int64)
The number of receipts in the receipt batch.
Label
Actual Count
- appliedStatus (enumeration: BatchAppliedStatus)
The receipt batch status. Valid values are: IN_PROCESS, PROCESSED, and POSTBATCH_WAITING.
Label
Applied Status
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: BatchAppliedStatus
Properties
- not nullable
Valid Values
- COMPLETED_APPROVAL
- COMPLETED_CANCELLATION
- COMPLETED_CREATION
- COMPLETED_DELETION
- COMPLETED_FORMAT
- POSTBATCH_WAITING
- PROCESSED
- STARTED_APPROVAL
- STARTED_CANCELLATION
- STARTED_CREATION
For a complete list of valid values, see the BatchAppliedStatus enumeration type.
-
- batchDate (date)
The receipt batch date.
Label
Batch Date
Properties
- not nullable
- batchId (int64)
The identifier of the receipt batch.
Label
Batch ID
Properties
- searchable
- sortable
- not nullable
- closedDate (date)
The receipt batch closed date.
Label
Closed Date
- comments (string)
The user-defined comments to accompany the receipt batch.
Label
Comments
- controlAmount (big-decimal)
The receipt batch control amount.
Label
Control Amount
- controlCount (int64)
The receipt batch item control count.
Label
Control Count
- conversionDate (date)
The receipt batch conversion date.
Label
Conversion Date
- conversionRate (big-decimal)
The receipt batch conversion rate.
Label
Conversion Rate
- createdBy (string)
The user who created the record.
Label
Created By
Properties
- not nullable
- depositDate (date)
The receipt batch deposit date.
Label
Deposit Date
- lockboxBatch (string)
The name of the lockbox associated with the receipt batch.
Label
Lockbox Batch
- mediaReference (string)
The name of the transmission media used for the receipt batch.
Label
Media Reference
- name (string)
The name of the receipt batch.
Label
Name
Properties
- not nullable
- purged (enumeration: PurgedDetailsIndicator)
The option that indicates whether information in the receipt batch was purged.
Label
Purged
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: PurgedDetailsIndicator
Valid Values
- N
- Y
-
- status (enumeration: BatchStatus)
The status of the receipt batch.
Label
Status
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: BatchStatus
Properties
- searchable
- sortable
Valid Values
- CL
- NB
- OOB
- OP
- PENDING_APPROVAL
- PENDING_CONFIRMATION
- READY_TO_POST
-
- timeCreated (date-time)
The date and time when the record was created.
Label
Creation Date
Properties
- searchable
- not nullable
- timeUpdated (date-time)
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- searchable
- not nullable
- type (enumeration: BatchType)
The receipt batch type. Valid values are: MANUAL for manually created batches, CREATION for automatic receipt batches, REMITTANCE for remittance batches, CLEARANCE for clearance batches, and BR_REMITTANCE for bills receivable remittance batches.
Label
Type
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: BatchType
Properties
- searchable
- sortable
- not nullable
Valid Values
- AUTOMATIC
- CASH
- LOCKBOX
- MANUAL
- REMITTANCE
-
- updatedBy (string)
The user who last updated the record.
Label
Last Updated By
Properties
- not nullable
Reference Object
- bankAccountUse (BankAccountBusinessUnitAssignment)
A bank account business unit assignment provides details of how each business unit can use a bank account for payables, receivables, payroll, and treasury activities. For example, a business unit might restrict a bank account to payroll disbursements or enable it for multiple application uses. This ensures that only authorized business processes access or use specific bank accounts, supporting operational requirements and internal controls.
Business Object
BankAccountBusinessUnitAssignmentFields
- id (int64)
Unique identifier for the bank account use.
Label
Bank Account Use Identifier
Properties
- searchable
- sortable
- not nullable
- id (int64)
- businessUnit (BusinessUnit)
A business unit represents a unit of an enterprise that performs one or more business functions and may have service provider relationships between the units. It typically focuses on a specific market segment, product line, geographic region, or set of services. The business transactions are recorded, reported, and accounted against the business unit.
Business Object
BusinessUnitFields
- id (int64)
The unique identifier of the business unit.
Label
Business Unit ID
Properties
- inherited
- searchable
- sortable
- not nullable
- overridable
- id (int64)
- currency (Currency)
A currency is a standardization of money used for displaying monetary amounts, assigning to ledgers, entering transactions, recording balances, and reporting. All currencies listed in the International Organization for Standardization 4217 standard are supported. The statistical unit currency is used for financial statistics in financial reports, allocation formulas, and other calculations.
Business Object
CurrencyFields
- currencyCode (string)
The currency in which an amount or a conversion rate is denominated.
Label
Currency Code
Properties
- searchable
- sortable
- not nullable
- currencyCode (string)
- exchangeRateTypeLookup (CurrencyConversionRateType)
A currency conversion rate type defines conversion rate types such as Corporate, Daily, Period End, and Period Average. These conversion rate types are used to convert foreign currency journal amounts to ledger currency equivalents or translate and remeasure account balances to a reporting currency.
Business Object
CurrencyConversionRateTypeFields
- conversionRateType (string)
The rate type of the conversion rate used for the currency conversion, such as Corporate, Daily, Period End, and Period Average.
Label
Conversion Rate Type
Properties
- searchable
- sortable
- not nullable
- conversionRateType (string)
- ledger (Ledger)
A ledger represents a record-keeping book used to track financial transactions. It serves as a central repository for all financial activities within an organization, providing a chronological and systematic account of debits, credits, and balances. Ledgers play a crucial role in financial management, budgeting, and maintaining accurate financial records, tracking expenses, revenues, assets, liabilities, and equity.
Business Object
LedgerFields
- ledgerId (int64)
The unique identifier of the ledger for which the accounting entry is created.
Label
Ledger ID
Properties
- searchable
- sortable
- not nullable
- ledgerId (int64)
- lockbox (ReceivablesLockbox)
The Receivables Lockbox provides details about the lockbox service, which is offered by commercial banks to corporate customers for outsourcing their accounts receivable payment processing. Oracle Fusion Receivables ensures that the data is valid before creating receipt batches. This verification occurs using Lockbox definitions when transferring receipts from your bank file into the Receivables system.
Business Object
ReceivablesLockboxFields
- lockboxId (int64)
The identifier of the lockbox associated with the receipt batch.
Label
Lockbox ID
Properties
- searchable
- sortable
- not nullable
- lockboxId (int64)
- lockboxTransmission (ReceivablesLockboxTransmission)
The Receivables Lockbox Transmission business object provides the details of the validation of the data imported from the bank file using a lockbox file transmission.
Business Object
ReceivablesLockboxTransmissionFields
- transmissionId (int64)
The unique identifier of the lockbox transmission.
Label
Transmission ID
Properties
- searchable
- sortable
- not nullable
- transmissionId (int64)
- receiptClass (ReceivablesReceiptClass)
The Receivables Receipt Class business object determines the required processing steps for receipts. These steps include bills receivable, automatic or manual receipt creation, the remittance method, the bank clearance method, and whether receipts require confirmation by the customer. The receipt methods assigned to a receipt class define the receipt entries and applications, and determine the customer remittance bank information.
Business Object
ReceivablesReceiptClassFields
- receiptClassId (int64)
Identifier of the receipt class.
Label
Receipt Class ID
Properties
- searchable
- sortable
- not nullable
- receiptClassId (int64)
- receiptMethod (ReceivablesReceiptMethod)
The receipt method contains information that defines how payments are applied or allocated within receivables. The information includes the receipt class, receipt method name and description, the option for debit memos to inherit receipt numbers, the option for receipt to inherit transaction numbers, grouping number of receipts rule, receipt maturity date rule, and lead days. For automatically created receipts, receipt methods define the rules for creating these receipts. For manually created receipts, receipt methods define user-definable receipt types. Each receipt method is linked with a specific set of remittance bank accounts, which can be assigned to a receipt. For instance, if you receive lockbox transmissions from multiple banks, you can create a lockbox receipt method with the bank accounts from the banks assigned to them.
Business Object
ReceivablesReceiptMethodFields
- receiptMethodId (int64)
The identifier of the receipt method.
Label
Receipt Method ID
Properties
- searchable
- sortable
- not nullable
- receiptMethodId (int64)
- receiptSource (ReceivablesReceiptSource)
The Receivables Receipt Source outlines the default values for the receipt class, bank account, and payment method for each receipt within a receipt batch, which are grouped for batch processing. This functionality also assists Oracle Receivables in managing the grouping, processing, and accounting of receipts effectively.
Business Object
ReceivablesReceiptSourceFields
- receiptSourceSequenceId (int64)
Identifier of the payment batch source sequence.
Label
Receipt Source Sequence ID
Properties
- searchable
- sortable
- not nullable
- receiptSourceSequenceId (int64)
- remittanceBankAccount (BankAccount)
The bank account provides the details of the internal bank accounts of a company that are used to receive payments and disburse funds. It contains legal entity-level bank account information. Each bank account must be affiliated with one bank branch.
Business Object
BankAccountFields
- id (int64)
Unique identifier for the bank account.
Label
Bank Account ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- remittanceBankBranch (BankBranch)
Business Object
BankBranchFields
- id (int64)
Unique identifier for the bank branch.
Label
Bank Branch ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- remittanceMethod (ERPLookupCode)
The receipt batch remittance method. Valid values are: Standard, Factoring, and Standard and Factoring.
Business Object
ERPLookupCodeFields
- lookupCode (string)
The unique identifier of the Lookup Code.
Label
Lookup Code ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupType (string)
The unique identifier of the Lookup Type.
Label
Lookup Type ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupCode (string)
- accountingDate (date)