[Home] [Help] [Dependency Information]
Object Name: | AR_TRANSMISSION_FORMATS |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.AR_TRANSMISSION_FORMATS |
Subobject Name: | |
Status: | VALID |
The AR_TRANSMISSION_FORMATS table stores information about the Lockbox transmission formats that you define, such as format name and creation date. You 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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AR_TRANSMISSION_FORMATS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TRANSMISSION_FORMAT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSMISSION_FORMAT_ID | NUMBER | (15) | Yes | Identifies the transmission format |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this 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 column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ZENGIN_CHAR_SET | VARCHAR2 | (80) | Determines the character set used when importing bank files in the Zengin format using autobox. Replaces the AR: Zengin Character Set profile option. |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSMISSION_FORMAT_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, FORMAT_NAME
, STATUS_LOOKUP_CODE
, DESCRIPTION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ZENGIN_CHAR_SET
FROM AR.AR_TRANSMISSION_FORMATS;
AR.AR_TRANSMISSION_FORMATS does not reference any database object
AR.AR_TRANSMISSION_FORMATS is referenced by following:
|
|
|