1. Extract Data Stores for Financials
  2. Receipt Batch

Receipt Batch

The receipt batch view object contains information about the receipt batch, including receipt batch name, batch date, accounting date, batch status, payment type, number of receipts, batch receipt amount, batch application status, transmission request, lockbox batch name, receipt class, receipt method, remittance bank account, and business unit. The receipt batch view object stores batch source information about each receipt and remittance batch.

Data Store Key : FscmTopModelAM.FinExtractAM.ArBiccExtractAM.ReceiptBatchExtractPVO

Primary Keys : ArBatchBatchId

Initial Extract Date : ArBatchCreationDate

Incremental Extract Date : ArBatchLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
ArBatchActualAmount The receipt batch total amount.
ArBatchActualCount The number of receipts in the receipt batch.
ArBatchAttribute1 A segment of the Receipt Batch descriptive flexfield 1.
ArBatchAttribute10 A segment of the Receipt Batch descriptive flexfield 10.
ArBatchAttribute11 A segment of the Receipt Batch descriptive flexfield 11.
ArBatchAttribute12 A segment of the Receipt Batch descriptive flexfield 12.
ArBatchAttribute13 A segment of the Receipt Batch descriptive flexfield 13.
ArBatchAttribute14 A segment of the Receipt Batch descriptive flexfield 14.
ArBatchAttribute15 A segment of the Receipt Batch descriptive flexfield 15.
ArBatchAttribute2 A segment of the Receipt Batch descriptive flexfield 2.
ArBatchAttribute3 A segment of the Receipt Batch descriptive flexfield 3.
ArBatchAttribute4 A segment of the Receipt Batch descriptive flexfield 4.
ArBatchAttribute5 A segment of the Receipt Batch descriptive flexfield 5.
ArBatchAttribute6 A segment of the Receipt Batch descriptive flexfield 6.
ArBatchAttribute7 A segment of the Receipt Batch descriptive flexfield 7.
ArBatchAttribute8 A segment of the Receipt Batch descriptive flexfield 8.
ArBatchAttribute9 A segment of the Receipt Batch descriptive flexfield 9.
ArBatchAttributeCategory The descriptive flexfield context name of the Receipt Batch descriptive flexfield.
ArBatchAutoPrintProgramId The identifier of the print program used for the receipt remittance batch.
ArBatchAutoTransProgramId The identifier of the magnetic format print program used for the receipt remittance batch.
ArBatchAutomatchRequestId The AutoMatch request identifier of the receipt batch.
ArBatchBankDepositNumber The user-defined reference number of the receipt batch.
ArBatchBatchAppliedStatus The receipt batch status. Valid values are: IN_PROCESS, PROCESSED, and POSTBATCH_WAITING.
ArBatchBatchDate The receipt batch date.
ArBatchBatchId The identifier of the receipt batch.
ArBatchBatchSourceSeqId The receipt batch sequence identifier.
ArBatchClosedDate The receipt batch closed date.
ArBatchComments The user-defined comments to accompany the receipt batch.
ArBatchControlAmount The receipt batch control amount.
ArBatchControlCount The receipt batch item control count.
ArBatchCreatedBy The user who created the receipt batch.
ArBatchCreationDate The date and time the receipt batch was created.
ArBatchCurrencyCode The receipt batch currency code.
ArBatchDepositDate The receipt batch deposit date.
ArBatchExchangeDate The receipt batch conversion date.
ArBatchExchangeRate The receipt batch conversion rate.
ArBatchExchangeRateType The receipt batch conversion rate type.
ArBatchGlDate The receipt batch accounting date.
ArBatchLastUpdateDate The date and time the receipt batch was last updated.
ArBatchLastUpdateLogin The session login of the user who last updated the receipt batch.
ArBatchLastUpdatedBy The user who last updated the receipt batch.
ArBatchLockboxBatchName The name of the lockbox associated with the receipt batch.
ArBatchLockboxId The identifier of the lockbox associated with the receipt batch.
ArBatchMediaReference The name of the transmission media used for the receipt batch.
ArBatchName The name of the receipt batch.
ArBatchObjectVersionNumber The number used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a receipt batch to detect whether another session has updated the row since it was queried.
ArBatchOldRemittanceBankBranchId The identifier of the previous default remittance bank branch of the receipt batch.
ArBatchOperationRequestId The request identifier of the process that created the receipt batch.
ArBatchOrgId The identifier of the business unit associated with the receipt batch.
ArBatchProgramApplicationId The identifier of the application that last updated the receipt batch (foreign key to FND_APPLICATION.APPLICATION_ID).
ArBatchProgramId The identifier of the process that last updated the receipt batch (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
ArBatchProgramUpdateDate The date the process last updated the receipt batch.
ArBatchPurgedChildrenFlag The option that indicates whether information in the receipt batch was purged.
ArBatchReceiptClassId The identifier of the receipt class associated with the receipt batch (foreign key reference to RECEIPT_CLASS_ID from AR_RECEIPT_CLASSES).
ArBatchReceiptMethodId The identifier of the receipt method associated with the receipt batch (foreign key reference to AR_RECEIPT_METHODS).
ArBatchRemitBankAcctUseId The business use identifier of the target remittance bank account for the receipt batch.
ArBatchRemitMethodCode The receipt batch remittance method. Valid values are: Standard, Factoring, and Standard and Factoring.
ArBatchRemittanceBankAccountId The identifier of the remittance bank account assigned to the receipt batch (foreign key reference to AP_BANK_ACCOUNTS).
ArBatchRemittanceBankBranchId The identifier of the bank branch of the remittance bank account assigned to the receipt batch.
ArBatchRequestId The request identifier of the receipt batch.
ArBatchSetOfBooksId The identifier of the primary ledger associated with the receipt batch.
ArBatchStatus The status of the receipt batch.
ArBatchTransmissionId The identifier of the lockbox transmission that processed the receipt batch.
ArBatchTransmissionRequestId The request identifier of the lockbox transmission that processed the receipt batch.
ArBatchType 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.
ArBatchWithRecourseFlag The option on a bills receivable remittance batch that indicates whether to create factored bills receivable remittances with recourse.