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

TABLE: ONT.OE_CREDIT_CHECK_RULES

Object Details
Object Name: OE_CREDIT_CHECK_RULES
Object Type: TABLE
Owner: ONT
FND Design Data: TableONT.OE_CREDIT_CHECK_RULES
Subobject Name:
Status: VALID


This table stores information about the credit check rules.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OE_CREDIT_CHECK_RULES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCREDIT_CHECK_RULE_ID
ColumnZD_EDITION_NAME
OE_CREDIT_CHECK_RULES_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnNAME
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
CREDIT_CHECK_RULE_ID NUMBER
Yes ID of the Credit Check Rule
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
NAME VARCHAR2 (240) Yes Credit Check Rule Name
FAILURE_RESULT_CODE VARCHAR2 (30) Yes Code of the failure result
OPEN_AR_BALANCE_FLAG VARCHAR2 (1) Yes Include Open AR Balance
UNINVOICED_ORDERS_FLAG VARCHAR2 (1) Yes Include Uninvoiced Orders
ORDERS_ON_HOLD_FLAG VARCHAR2 (1) Yes Include Orders Currently on Hold
SHIPPING_INTERVAL NUMBER

Shipping Interval
OPEN_AR_DAYS NUMBER

Open Receivable Days
START_DATE_ACTIVE DATE

Start valid date for the Rule
END_DATE_ACTIVE DATE

End Valid date for the Credit Check Rule
INCLUDE_PAYMENTS_AT_RISK_FLAG VARCHAR2 (1) Yes Include payments when doing credit checking
CONTEXT VARCHAR2 (30)
Descriptive Flexfield segment
ATTRIBUTE1 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive Flexfield segment
INCLUDE_TAX_FLAG VARCHAR2 (1)
Include Tax Flag.
MAXIMUM_DAYS_PAST_DUE NUMBER

Number of days any invoice can be unpaid beyond its due date before orders using this credit check rule are put on credit check failure hold
BACKGRD_CR_CHECK_FLAG VARCHAR2 (1)
used to enable background credit checking
QUICK_CR_CHECK_FLAG VARCHAR2 (1)
used to enable quick credit checking
INCL_FREIGHT_CHARGES_FLAG VARCHAR2 (1)
used to exclude freight charges
CREDIT_CHECK_LEVEL_CODE VARCHAR2 (30)
Determine whether to perform credit check at the order or order line bill-to site level. Sales order (Default) Sales order line.
CREDIT_HOLD_LEVEL_CODE VARCHAR2 (30)
Determine whether to place the credit hold on the order or the order lines. Sales order (Default) Sales order line
CONVERSION_TYPE VARCHAR2 (30)
GL_DAILY_CONVERSION_TYPES.conversion_type Limit currency conversion type.
CHECK_ITEM_CATEGORIES_FLAG VARCHAR2 (1)
Determine whether to check item categories credit limits Y - to check N - not to check (Default)
SEND_HOLD_NOTIFICATIONS_FLAG VARCHAR2 (1)
Determine whether to semd notifications when the order fails credit check. Y - send N - do not send (Default)
INCLUDE_EXTERNAL_EXPOSURE_FLAG VARCHAR2 (1)
This column is used to indicate the inclusion of the external credit exposure during credit checking process.ValuesY : Include external credit exposure in credit check.N: Exclude external credit exposure from credit check (Default).
DAYS_HONOR_MANUAL_RELEASE NUMBER

Indicates for how many days manually released holds can be honored and not overridden.
INCLUDE_RETURNS_FLAG VARCHAR2 (1)
Allows inclusion of return lines amount when validating transaction or overall credit limit. Values Y : Include return lines amount. N: Exclude return lines amount (Default).
TOLERANCE_AMOUNT NUMBER

Stores the Tolerance Amount for the Credit Check Rule
TOLERANCE_CURR_CODE VARCHAR2 (15)
Stores the Tolerance Currency for the Credit Check Rule
TOLERANCE_PERCENTAGE NUMBER

Stores the Tolerance Percentage for the Credit Check Rule
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT CREDIT_CHECK_RULE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      NAME
,      FAILURE_RESULT_CODE
,      OPEN_AR_BALANCE_FLAG
,      UNINVOICED_ORDERS_FLAG
,      ORDERS_ON_HOLD_FLAG
,      SHIPPING_INTERVAL
,      OPEN_AR_DAYS
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      INCLUDE_PAYMENTS_AT_RISK_FLAG
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      INCLUDE_TAX_FLAG
,      MAXIMUM_DAYS_PAST_DUE
,      BACKGRD_CR_CHECK_FLAG
,      QUICK_CR_CHECK_FLAG
,      INCL_FREIGHT_CHARGES_FLAG
,      CREDIT_CHECK_LEVEL_CODE
,      CREDIT_HOLD_LEVEL_CODE
,      CONVERSION_TYPE
,      CHECK_ITEM_CATEGORIES_FLAG
,      SEND_HOLD_NOTIFICATIONS_FLAG
,      INCLUDE_EXTERNAL_EXPOSURE_FLAG
,      DAYS_HONOR_MANUAL_RELEASE
,      INCLUDE_RETURNS_FLAG
,      TOLERANCE_AMOUNT
,      TOLERANCE_CURR_CODE
,      TOLERANCE_PERCENTAGE
,      ZD_EDITION_NAME
FROM ONT.OE_CREDIT_CHECK_RULES;

Dependencies

[top of page]

ONT.OE_CREDIT_CHECK_RULES does not reference any database object

ONT.OE_CREDIT_CHECK_RULES is referenced by following:

SchemaONT
ViewOE_CREDIT_CHECK_RULES#