[Home] [Help] [Dependency Information]
Object Name: | AR_TRANS_FIELD_FORMATS |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.AR_TRANS_FIELD_FORMATS |
Subobject Name: | |
Status: | VALID |
The AR_TRANS_FIELD_FORMATS table stores information about each field in a transmission format. You specify the records that are part of each transmission format. Each record has specific field types that are stored in this table. Each row includes field starting position, field ending position, description, and justification information.
.
The primary key for this table is FIELD_FORMAT_ID.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AR_TRANS_FIELD_FORMATS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
FIELD_FORMAT_ID
ZD_EDITION_NAME |
AR_TRANS_FIELD_FORMATS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RECORD_FORMAT_ID |
AR_TRANS_FIELD_FORMATS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | FIELD_TYPE_LOOKUP_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FIELD_FORMAT_ID | NUMBER | Yes | Identifies each transmission field 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. | |
RECORD_FORMAT_ID | NUMBER | (15) | Yes | Identifies the record within which the field appears |
TRANSMISSION_FORMAT_ID | NUMBER | (15) | Yes | Identifies the transmission format with which this field is associated |
FIELD_START_POSITION | NUMBER | Yes | Start position of field | |
FIELD_END_POSITION | NUMBER | Yes | End position of field | |
FIELD_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | Yes | Lookup code for the type of field |
DESCRIPTION | VARCHAR2 | (240) | Description of field | |
DATE_PICTURE_LOOKUP_CODE | VARCHAR2 | (30) | Lookup code for the date format | |
TIME_PICTURE_LOOKUP_CODE | VARCHAR2 | (30) | Lookup code for the time format | |
JUSTIFICATION_LOOKUP_CODE | VARCHAR2 | (30) | Lookup code for the field justification | |
AMOUNT_FORMAT_LOOKUP_CODE | VARCHAR2 | (30) | Lookup code for the amount format | |
OVERFLOW_REC_INDICATOR | VARCHAR2 | (1) | Indicates whether this field is an overflow of the preceding payment record | |
FILL_CHARACTER_LOOKUP_CODE | VARCHAR2 | (30) | Lookup code for the field fill character | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT FIELD_FORMAT_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, RECORD_FORMAT_ID
, TRANSMISSION_FORMAT_ID
, FIELD_START_POSITION
, FIELD_END_POSITION
, FIELD_TYPE_LOOKUP_CODE
, DESCRIPTION
, DATE_PICTURE_LOOKUP_CODE
, TIME_PICTURE_LOOKUP_CODE
, JUSTIFICATION_LOOKUP_CODE
, AMOUNT_FORMAT_LOOKUP_CODE
, OVERFLOW_REC_INDICATOR
, FILL_CHARACTER_LOOKUP_CODE
, ZD_EDITION_NAME
FROM AR.AR_TRANS_FIELD_FORMATS;
AR.AR_TRANS_FIELD_FORMATS does not reference any database object
AR.AR_TRANS_FIELD_FORMATS is referenced by following:
|
|
|