AR_TRANSMISSION_FORMATS
The AR_TRANSMISSION_FORMATS table contains information about the Lockbox transmission formats that you define, such as format name and creation date. You can define transmission formats so that Oracle Receivables can interpret your bank files. Each row includes the format name and description. The primary key for this table is TRANSMISSION_FORMAT_ID.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
AR_TRANSMISSION_FORMATS_PK |
TRANSMISSION_FORMAT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| TRANSMISSION_FORMAT_ID | NUMBER | Yes | Identifies the transmission format | |||
| MODULE_ID | VARCHAR2 | 32 | Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data. | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated 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. | |||
| FORMAT_NAME | VARCHAR2 | 25 | Yes | Name of this transmission format | ||
| STATUS_LOOKUP_CODE | VARCHAR2 | 1 | Yes | Lookup code for the status of this transmission format | ||
| DESCRIPTION | VARCHAR2 | 240 | Description given to this transmission format | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Transmission Formats (AR_TRANSMISSION_FORMATS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transmission Formats (AR_TRANSMISSION_FORMATS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transmission Formats (AR_TRANSMISSION_FORMATS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transmission Formats (AR_TRANSMISSION_FORMATS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transmission Formats (AR_TRANSMISSION_FORMATS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transmission Formats (AR_TRANSMISSION_FORMATS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transmission Formats (AR_TRANSMISSION_FORMATS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transmission Formats (AR_TRANSMISSION_FORMATS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transmission Formats (AR_TRANSMISSION_FORMATS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transmission Formats (AR_TRANSMISSION_FORMATS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transmission Formats (AR_TRANSMISSION_FORMATS) | ||
| 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. | |||
| ZENGIN_CHAR_SET | VARCHAR2 | 80 | Determines the character set used when importing bank files in the Zengin format using Lockbox. | |||
| 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. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | |||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | ||
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| ar_trans_record_formats | ar_transmission_formats | TRANSMISSION_FORMAT_ID |
| ar_transmissions_all | ar_transmission_formats | REQUESTED_TRANS_FORMAT_ID |
| ar_trans_field_formats | ar_transmission_formats | TRANSMISSION_FORMAT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AR_TRANSMISSION_FORMATS_U1 | Unique | Default | TRANSMISSION_FORMAT_ID, ORA_SEED_SET1 |
| AR_TRANSMISSION_FORMATS_U11 | Unique | Default | TRANSMISSION_FORMAT_ID, ORA_SEED_SET2 |