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 |
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_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_U1 | Unique | Default | TRANSMISSION_ID |
| AR_TRANSMISSIONS_U2 | Unique | Default | TRANSMISSION_NAME, ORG_ID |