[Home] [Help] [Dependency Information]
Object Name: | RA_GROUPING_RULES |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.RA_GROUPING_RULES |
Subobject Name: | |
Status: | VALID |
The RA_GROUPING_RULES table stores grouping rules used by AutoInvoice. Grouping rules determine how different invoice lines from the RA_INTERFACE_LINES_ALL AutoInvoice table are grouped together to create an invoice.
.
Grouping rules contain various transaction attributes that must be identical for the same transaction. For example, if transaction number is part of your grouping rule and you have two records in the interface tables with different transaction numbers, AutoInvoice will create two transactions.
.
The primary key for this table is GROUPING_RULE_ID.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
RA_GROUPING_RULES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
GROUPING_RULE_ID
ZD_EDITION_NAME |
RA_GROUPING_RULES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
NAME
ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUPING_RULE_ID | NUMBER | (15) | Yes | Grouping rule identifier |
NAME | VARCHAR2 | (40) | Yes | Grouping rule name |
START_DATE | DATE | Yes | Grouping rule start date | |
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. | |
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. | |
DESCRIPTION | VARCHAR2 | (80) | Grouping rule description | |
ORDERING_RULE_ID | NUMBER | (15) | Ordering rule identifier associated with this grouping rule. Foreign key to the RA_LINE_ORDERING_RULES table. | |
END_DATE | DATE | Grouping rule end date | ||
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 | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT GROUPING_RULE_ID
, NAME
, START_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, DESCRIPTION
, ORDERING_RULE_ID
, END_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, LAST_UPDATE_LOGIN
, ZD_EDITION_NAME
FROM AR.RA_GROUPING_RULES;
AR.RA_GROUPING_RULES does not reference any database object
AR.RA_GROUPING_RULES is referenced by following:
|
|
|