[Home] [Help] [Dependency Information]
Object Name: | AR_STANDARD_TEXT_B |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.AR_STANDARD_TEXT_B |
Subobject Name: | |
Status: | VALID |
The AR_STANDARD_TEXT_B table stores information for standard statement messages. Oracle Receivables creates one row in this table for each statement message. Define standard messages to provide the text that Receivables prints on the bottom of your customer's statements. You can use messages to inform your customers of special promotions or to make your statements more personal. Messages that are stored in this table display as list of values choices in the Print Statements window.
.
The primary key for this table is STANDARD_TEXT_ID.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AR_STANDARD_TEXT_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | STANDARD_TEXT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STANDARD_TEXT_ID | NUMBER | (15) | Yes | Identifier of standard message text |
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. | |
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). | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
START_DATE | DATE | Yes | Date when the standard message is active | |
END_DATE | DATE | Date when the standard message becomes inactive | ||
NAME | VARCHAR2 | (30) | Yes | Name of the standard statement message |
TEXT_TYPE | VARCHAR2 | (15) | Type of statement message | |
TEXT_USE_TYPE | VARCHAR2 | (15) | Indicates the type of statement message | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT STANDARD_TEXT_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, START_DATE
, END_DATE
, NAME
, TEXT_TYPE
, TEXT_USE_TYPE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM AR.AR_STANDARD_TEXT_B;
AR.AR_STANDARD_TEXT_B does not reference any database object
AR.AR_STANDARD_TEXT_B is referenced by following:
|
|
|