1. Tables and Views for Financials
  2. AR_APP_RULE_DETAILS_

AR_APP_RULE_DETAILS_

The AR_APP_RULE_DETAILS table stores detailed information about an application rule, including amounts rounding, tax treatment, and line type. For example, if you define an application rule to prorate partial payments across all line types, a record in this table would have Line in the LINE_TYPE column and Prorate in the TAX_TREATMENT column. . The primary key for this table is RULE_DETAIL_ID.

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

AR_APP_RULE_DETAILS_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, RULE_DETAIL_ID

Columns

Name Datatype Length Precision Not-null Comments
RULE_DETAIL_ID NUMBER Yes Rule set identifier.
RULE_ID NUMBER Rule identifier.
ROUNDING_CORRECTION_FLAG VARCHAR2 1 Y or N indicates whether this rule contains amounts that rounding corrections create or not.
TAX_TREATMENT VARCHAR2 30 Tax handling information for this rule, prorate, before, after, or none.
LINE_TYPE VARCHAR2 30 The line type for this rule, line, freight, or charges
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.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated 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.
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
AR_APP_RULE_DETAILSN1_ Non Unique Default RULE_DETAIL_ID, LAST_UPDATE_DATE
AR_APP_RULE_DETAILS_U1_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, RULE_DETAIL_ID