DBA Data[Home] [Help] [Dependency Information]

TABLE: AR.AR_TRANS_RECORD_FORMATS

Object Details
Object Name: AR_TRANS_RECORD_FORMATS
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.AR_TRANS_RECORD_FORMATS
Subobject Name:
Status: VALID


The AR_TRANS_RECORD_FORMATS table stores information about each record in a transmission format, such as the record identifier, description, and the transmission format ID. You specify the records that are a part of each transmission format, and Oracle Receivables stores this information in this table.
.
The primary key for this table is RECORD_FORMAT_ID.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_TRANS_RECORD_FORMATS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRECORD_FORMAT_ID
ColumnZD_EDITION_NAME
AR_TRANS_RECORD_FORMATS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSMISSION_FORMAT_ID
AR_TRANS_RECORD_FORMATS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRECORD_TYPE_LOOKUP_CODE
Columns
Name Datatype Length Mandatory Comments
RECORD_FORMAT_ID NUMBER (15) Yes Identifies the record 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.
TRANSMISSION_FORMAT_ID NUMBER (15) Yes Identifies the Lockbox transmission format associated with this record
RECORD_IDENTIFIER VARCHAR2 (2) Yes Uniquely identifies each record within each record type
RECORD_TYPE_LOOKUP_CODE VARCHAR2 (30) Yes Lookup code for the record type
DESCRIPTION VARCHAR2 (240)
Describes the record
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
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RECORD_FORMAT_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      TRANSMISSION_FORMAT_ID
,      RECORD_IDENTIFIER
,      RECORD_TYPE_LOOKUP_CODE
,      DESCRIPTION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ZD_EDITION_NAME
FROM AR.AR_TRANS_RECORD_FORMATS;

Dependencies

[top of page]

AR.AR_TRANS_RECORD_FORMATS does not reference any database object

AR.AR_TRANS_RECORD_FORMATS is referenced by following:

SchemaAR
ViewAR_TRANS_RECORD_FORMATS#