1. Tables and Views for SCM
  2. CMF_TOLERANCE_RULES_B

CMF_TOLERANCE_RULES_B

Fiscal Document Tolerance Rules - Base Table

Details

  • Schema: FUSION

  • Object owner: CMF

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

CMF_TOLERANCE_RULES_B_PK

TOLERANCE_RULE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
TOLERANCE_RULE_ID NUMBER 18 Yes Generated Identifier for tolerance rules. Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes 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. Active
TOLERANCE_RULE_CODE VARCHAR2 30 Yes Indicates the Tolerance code of the tolerance. Active
TOLERANCE_RULE_TYPE_PRICE VARCHAR2 30 Indicates the type of tolerance. Active
TOLERANCE_RULE_TYPE_FISCAL VARCHAR2 30 Tolerance Rule Type for fiscal Qty Active
TOLERANCE_RULE_TYPE_SOURCE VARCHAR2 30 Tolerance Rule Type for Source receipt Active
DOCUMENT_TYPE VARCHAR2 30 Indicates the type of the document to which tolerance rule is applicable. Active
PARTY_ID NUMBER 18 Indicates the party to which tolerance rule is applicable. Active
ORGANIZATION_ID NUMBER 18 Indicates the inventory organization to which tolerance rule is applicable. Active
ITEM_CATEGORY_ID NUMBER 18 Indicates the item category to which tolerance rule is applicable. Active
INVENTORY_ITEM_ID NUMBER 18 Indicates the item to which tolerance rule is applicable. Active
ITEM_ORGANIZATION_ID NUMBER 18 Indicates the inventory organization of the item corresponding to item id.
TOLERANCE_BASIS VARCHAR2 30 Yes Indicates the basis for the tolerance verification. Active
UPPER_LIMIT_PRICE NUMBER Indicates the upper tolerance limit for the current tolerance type. Active
UPPER_LIMIT_ACTION_PRICE VARCHAR2 30 Indicates the system action when the current tolerance type is out of the upper tolerance defined. Active
LOWER_LIMIT_PRICE NUMBER Indicates the lower tolerance limit for the current tolerance type. Active
LOWER_LIMIT_ACTION_PRICE VARCHAR2 30 Indicates the system action when the current tolerance type is out of the lower tolerance defined. Active
UPPER_LIMIT_FISCAL NUMBER Upper Limit for the Fiscal Quantity. Active
UPPER_LIMIT_ACTION_FISCAL VARCHAR2 30 Upper Limit action for Fiscal Qty Active
LOWER_LIMIT_FISCAL NUMBER It indicates the lower tolerance limit for the tolerance type informed. Active
LOWER_LIMIT_ACTION_FISCAL VARCHAR2 30 Lower limit action for Fiscal Document Quantity. Active
UPPER_LIMIT_SOURCE NUMBER upper limit for source document Active
UPPER_LIMIT_ACTION_SOURCE VARCHAR2 30 Upper limit action for Source Receipt Active
LOWER_LIMIT_SOURCE NUMBER Lower limit for source document Active
LOWER_LIMIT_ACTION_SOURCE VARCHAR2 30 Lower limit action for source receipt Active
INACTIVE_FLAG VARCHAR2 1 Flag identifying if the tolerance rule is inactive or not. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE_CHAR1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Active

Foreign Keys

Table Foreign Table Foreign Key Column
cmf_tolerance_rules_tl cmf_tolerance_rules_b TOLERANCE_RULE_ID

Indexes

Index Uniqueness Tablespace Columns Status
CMF_TOLERANCE_RULES_B_PK Unique FUSION_TS_TX_IDX TOLERANCE_RULE_ID Active
CMF_TOLERANCE_RULES_B_U1 Unique FUSION_TS_TX_IDX TOLERANCE_RULE_CODE Active