1. Tables and Views for Financials
  2. RA_GROUP_BYS_

RA_GROUP_BYS_

The RA_GROUP_BYS table holds a row for every column that each grouping rule uses to group invoice lines. For example, if you define a grouping rule that groups invoice lines by purchase order number and shipping date, two rows will exist in this table for each combination of transaction class, as defined in the RA_GROUPING_TRX_TYPES table, and grouping rule. . The primary keys for this table are GROUPING_TRX_TYPE_ID and COLUMN_ID.

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

RA_GROUP_BYS_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, GROUPING_TRX_TYPE_ID, COLUMN_ID

Columns

Name Datatype Length Precision Not-null Comments
GROUPING_TRX_TYPE_ID NUMBER 18 Yes Grouping transaction type identifier. Foreign key to the RA_GROUPING_TRX_TYPES table.
COLUMN_ID NUMBER 18 Yes Grouping column identifier. Foreign key to the RA_GROUP_BY_COLUMNS table.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Original Impersonator User.

Indexes

Index Uniqueness Tablespace Columns
RA_GROUP_BYSN1_ Non Unique Default GROUPING_TRX_TYPE_ID, COLUMN_ID, LAST_UPDATE_DATE
RA_GROUP_BYS_U1_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, GROUPING_TRX_TYPE_ID, COLUMN_ID