AR_TRANSMISSIONS_ALL
The AR_TRANSMISSIONS_ALL table stores information about each Lockbox transmission. Each row includes the original transmission request ID, the transmission date, time, count, and amount. Use this information to review the status of your transmissions. Possible statuses include New, Out of Balance, and Closed, stored as NEW, OOB, and CL. . The primary key for this table is TRANSMISSION_REQUEST_ID.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AR_TRANSMISSIONS_PK |
TRANSMISSION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| TRANSMISSION_REQUEST_ID | NUMBER | 18 | Yes | Identifies the concurrent request of the transmission | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| TRANS_DATE | DATE | Deposit date that corresponds to the transmission | ||||
| TIME | VARCHAR2 | 5 | Deposit time that corresponds to the transmission | |||
| COUNT | NUMBER | Number of records read in the transmission | ||||
| AMOUNT | NUMBER | Sum of payments in the transmission | ||||
| VALIDATED_COUNT | NUMBER | Number of records read in the transmission that passed the validation | ||||
| VALIDATED_AMOUNT | NUMBER | Sum of the validated payments within the transmission | ||||
| ORIGIN | VARCHAR2 | 25 | Identifier of the institution from which the transmission originated | |||
| DESTINATION | VARCHAR2 | 25 | Bank account to which the lockbox is being transmitted. | |||
| STATUS | VARCHAR2 | 30 | Lookup code for the status of the transmission | |||
| COMMENTS | VARCHAR2 | 240 | User's comments entered at submission | |||
| REQUESTED_LOCKBOX_ID | NUMBER | 18 | Identifies the selected originating Lockbox | |||
| REQUESTED_TRANS_FORMAT_ID | NUMBER | 18 | Identifies the selected transmission format | |||
| REQUESTED_GL_DATE | DATE | Selected General Ledger date for payments | ||||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Transmissions (AR_TRANSMISSIONS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transmissions (AR_TRANSMISSIONS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transmissions (AR_TRANSMISSIONS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transmissions (AR_TRANSMISSIONS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transmissions (AR_TRANSMISSIONS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transmissions (AR_TRANSMISSIONS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transmissions (AR_TRANSMISSIONS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transmissions (AR_TRANSMISSIONS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transmissions (AR_TRANSMISSIONS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transmissions (AR_TRANSMISSIONS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transmissions (AR_TRANSMISSIONS) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| TRANSMISSION_NAME | VARCHAR2 | 30 | Yes | Name that the user has specified to identify transmission | ||
| TRANSMISSION_ID | NUMBER | 18 | Yes | Uniquely identifies the transmission | ||
| LATEST_REQUEST_ID | NUMBER | 18 | Identifies the concurrent request that last processed the transmission | |||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | ||
| SOURCE_TYPE_FLAG | VARCHAR2 | 1 | Indicates interfaced data source | |||
| SCORING_MODEL_ID | NUMBER | 18 | Indicates scoring model | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | 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 to detect whether another session has updated the row since it was queried. | ||
| ERROR_COUNT | NUMBER | Number of error records in payment interface for this transaction | ||||
| DOCUMENT_ID | NUMBER | 18 | Document IO file Identifier. Foreign key to DocIO file record. | |||
| DOCUMENT_NAME | VARCHAR2 | 1000 | Name of the inbound file received for processing, as uploaded, transmitted, or imported into the application. | |||
| DOCIO_DOCUMENT_ID | NUMBER | 18 | Identifier of the corresponding Doc IO document, when the inbound file is stored or tracked through Doc IO. This enables linkage between product processing records and Doc IO ingestion/transmission details. | |||
| OBJECT_STORE_REFERENCE_ID | NUMBER | 18 | Reference identifier for the file object stored in object storage or Doc IO-backed storage. Used to locate or retrieve the physical file content or related stored object. | |||
| FILE_TYPE | VARCHAR2 | 30 | File extension or physical file type of the inbound file, such as PDF, CSV, TXT, or XML. | |||
| DOCUMENT_FORMAT | VARCHAR2 | 30 | Business or banking format of the inbound file, such as CAMT52, BAI2, lockbox format, bank statement format, or remittance advice format. | |||
| DOCUMENT_STATUS_CODE | VARCHAR2 | 30 | Status of the inbound file transfer or ingestion activity, indicating whether the file was received, transferred, failed, or completed before product-level processing. | |||
| PROCESSING_SUMMARY | VARCHAR2 | 4000 | Summary of file processing outcome, including success, warning, or failure details captured during import or downstream processing. This can include high-level error context when transactional parent records are not created. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AR_TRANSMISSIONS_ALL | ar_lockboxes_all | REQUESTED_LOCKBOX_ID |
| AR_TRANSMISSIONS_ALL | ar_transmission_formats | REQUESTED_TRANS_FORMAT_ID |
| AR_TRANSMISSIONS_ALL | fun_docio_incoming_documents | DOCIO_DOCUMENT_ID |
| ar_batches_all | ar_transmissions_all | TRANSMISSION_REQUEST_ID |
| ar_batches_all | ar_transmissions_all | TRANSMISSION_ID |
| ar_payments_interface_all | ar_transmissions_all | TRANSMISSION_ID |
| ar_payments_interface_all | ar_transmissions_all | TRANSMISSION_REQUEST_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AR_TRANSMISSIONS_N1 | Non Unique | Default | CREATION_DATE |
| AR_TRANSMISSIONS_N2 | Non Unique | Default | DOCUMENT_ID |
| AR_TRANSMISSIONS_U1 | Unique | Default | TRANSMISSION_ID |
| AR_TRANSMISSIONS_U2 | Unique | Default | TRANSMISSION_NAME, ORG_ID |