Transaction Batch
The transaction batch view object contains information about invoice transaction or bills receivable batches, including transaction source set, batch name, legal entity, source type, and transaction number. Each row includes information about a batch belonging to a batch source. The STATUS and BATCH_SOURCE_ID columns are required.
Data Store Key : FscmTopModelAM.FinExtractAM.ArBiccExtractAM.TransactionBatchExtractPVO
Primary Keys : RaBatchBatchId
Initial Extract Date : RaBatchCreationDate
Incremental Extract Date : RaBatchLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
RaBatchAttribute1 | A segment of the Transaction Batch descriptive flexfield 1. |
RaBatchAttribute10 | A segment of the Transaction Batch descriptive flexfield 10. |
RaBatchAttribute11 | A segment of the Transaction Batch descriptive flexfield 11. |
RaBatchAttribute12 | A segment of the Transaction Batch descriptive flexfield 12. |
RaBatchAttribute13 | A segment of the Transaction Batch descriptive flexfield 13. |
RaBatchAttribute14 | A segment of the Transaction Batch descriptive flexfield 14. |
RaBatchAttribute15 | A segment of the Transaction Batch descriptive flexfield 15. |
RaBatchAttribute2 | A segment of the Transaction Batch descriptive flexfield 2. |
RaBatchAttribute3 | A segment of the Transaction Batch descriptive flexfield 3. |
RaBatchAttribute4 | A segment of the Transaction Batch descriptive flexfield 4. |
RaBatchAttribute5 | A segment of the Transaction Batch descriptive flexfield 5. |
RaBatchAttribute6 | A segment of the Transaction Batch descriptive flexfield 6. |
RaBatchAttribute7 | A segment of the Transaction Batch descriptive flexfield 7. |
RaBatchAttribute8 | A segment of the Transaction Batch descriptive flexfield 8. |
RaBatchAttribute9 | A segment of the Transaction Batch descriptive flexfield 9. |
RaBatchAttributeCategory | The descriptive flexfield context name of the Transaction Batch descriptive flexfield. |
RaBatchBatchDate | The date the transaction batch was submitted for processing. |
RaBatchBatchId | The identifier of the transaction batch. |
RaBatchBatchProcessStatus | The transaction batch status. Valid values are: DRAFT, CREATION_STARTED, and CREATION_COMPLETED. |
RaBatchBatchSourceId | The identifier of the transaction source assigned to the transaction batch. |
RaBatchBatchSourceSeqId | The sequence identifier of the transaction source assigned to the transaction batch. |
RaBatchComments | The user-entered comments for the transaction batch. |
RaBatchControlAmount | The sum of all transaction amounts in the transaction batch. |
RaBatchControlCount | The total number of transactions in the transaction batch. |
RaBatchCreatedBy | The user who created the transaction batch. |
RaBatchCreationDate | The date and time the transaction batch was created. |
RaBatchCurrencyCode | The transaction batch currency. |
RaBatchExchangeDate | The transaction batch conversion date. |
RaBatchExchangeRate | The transaction batch conversion rate. |
RaBatchExchangeRateType | The transaction batch conversion rate type. |
RaBatchGlDate | The transaction batch accounting date. |
RaBatchIssueDate | The issue date applied to the transactions in the transaction batch. |
RaBatchLastUpdateDate | The date the transaction batch was last updated. |
RaBatchLastUpdateLogin | The session login of the user who last updated the transaction batch. |
RaBatchLastUpdatedBy | The user who last updated the transaction batch. |
RaBatchMaturityDate | The transaction batch maturity date. |
RaBatchName | The name of the transaction batch. |
RaBatchObjectVersionNumber | 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 transaction batch to detect whether another session has updated the row since it was queried. |
RaBatchOrgId | The identifier of the business unit associated with the transaction batch. |
RaBatchProgramApplicationId | The identifier of the application that last updated the transaction batch. |
RaBatchProgramId | The identifier of the process that last updated the transaction batch. |
RaBatchProgramUpdateDate | The date a process last updated the transaction batch. |
RaBatchPurgedChildrenFlag | The option that indicates the purge status of the transaction batch. |
RaBatchRequestId | The request identifier of the process that created or last updated the transaction batch. |
RaBatchSelectionCriteriaId | The identifier of the selection criteria used in transaction batch creation. |
RaBatchSetOfBooksId | The identifier of the primary ledger of the business unit associated with the transaction batch. |
RaBatchSpecialInstructions | The special instructions for the transaction batch. |
RaBatchStatus | The transaction batch status. A list of accepted values is defined in the lookup type BATCH_STATUS. |
RaBatchType | The transaction batch type. |