1. Tables and Views for Sales, Fusion Service, and Field Service
  2. OKC_CONTRACT_TYPES_B

OKC_CONTRACT_TYPES_B

This entity has the Contract Type Setup information.

Details

  • Schema: FUSION

  • Object owner: OKC

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

OKC_CONTRACT_TYPES_B_PK

CONTRACT_TYPE_ID

Columns

Name Datatype Length Precision Not-null Comments
CONTRACT_TYPE_ID NUMBER 18 Yes CONTRACT_TYPE_ID
CONTRACT_CLASS VARCHAR2 30 Contract Class
SET_ID NUMBER 18 Yes Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs.
INTENT VARCHAR2 30 Yes INTENT
START_DATE DATE Yes The beginning of the active period, one second after midnight on the date indicated.
END_DATE DATE The end of the active period, one second before midnight on the date indicated.
LAYOUT_TEMPLATE_ID NUMBER 18 LAYOUT_TEMPLATE_ID
QCL_ID NUMBER 18 QCL_ID
CONTRACT_GROUP_ID NUMBER CONTRACT_GROUP_ID
SIGNATURE_REQUIRED_FLAG VARCHAR2 1 SIGNATURE_REQUIRED_FLAG
LINE_AUTONUMBER_ENABLED_FLAG VARCHAR2 1 LINE_AUTONUMBER_ENABLED_FLAG
INTER_COMPANY_FLAG VARCHAR2 1 INTER_COMPANY_FLAG
INTER_PROJECT_FLAG VARCHAR2 1 INTER_PROJECT_FLAG
ENABLE_BILLING_CTRL_FLAG VARCHAR2 1 ENABLE_BILLING_CTRL_FLAG
BILLING_LIMIT_TYPE VARCHAR2 30 BILLING_LIMIT_TYPE
TERMS_ENABLED_FLAG VARCHAR2 1 TERMS_ENABLED_FLAG
RISKS_ENABLED_FLAG VARCHAR2 1 RISKS_ENABLED_FLAG
INTERACTIONS_ENABLED_FLAG VARCHAR2 1 INTERACTIONS_ENABLED_FLAG
RELATED_K_ENABLED_FLAG VARCHAR2 1 RELATED_K_ENABLED_FLAG
CONTRACT_LAYOUT_TEMPLATE VARCHAR2 200 Contract Print Layout Template
TERMS_LAYOUT_TEMPLATE VARCHAR2 200 Terms Print Layout Template
CONTRACT_TYPE_CODE VARCHAR2 80 Yes GUID generated code
PRIMARY_BUYER_ROLE VARCHAR2 30 Buyer Contact Role
REQUESTER_CONTACT_ROLE VARCHAR2 30 Requester Contact Role
NOTIFY_BEFORE_EXP_FLAG VARCHAR2 1 Notify Before Expiration
DAYS_TO_EXPIRATION NUMBER 18 Days to Expiration
NOTIFY_CONTACT_ROLE VARCHAR2 30 Contact Role to be Notified
AGREEMENT_ENABLED_FLAG VARCHAR2 1 Agreement Enabled Flag
ALLOW_LINES_FLAG VARCHAR2 1 Flag to indicate if lines are allowed on Contract Type
ALLOW_EXTERNAL_ITEM_FLAG VARCHAR2 1 Flag to indicate if external item master is allowed on contract lines using the current contract type.
CONTRACT_NUMB_METHOD VARCHAR2 30 Contract Numbering Method
CONTRACT_NUMB_SEQ_CAT VARCHAR2 30 Contract Numbering Sequence Category
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.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
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.
ITEM_SOURCE_CODE VARCHAR2 30 Lookup Code for Item Source: PIM, CRM or EXT
CONTRACT_NUMB_LEVEL VARCHAR2 30 Contract Numbering Level
ENABLE_ELECTRONIC_SIGN_FLAG VARCHAR2 1 Enable Electronic Signature Flag
SOLUTION_PROVIDER_CODE VARCHAR2 30 Electronic Solution Provider
CHR_TYPE VARCHAR2 30 Unique user defined contract type code that can be used as attribute_category in contract header DFF
LINE_CLASS VARCHAR2 30 Indicates if the Sell Intent Contract Type with Enterprise Contract Class has SERVICE or PROJECT Lines.
PRICING_SYSTEM_CODE VARCHAR2 30 For Sales Agreement with the contract type class as 'Agreement', intent as 'Sell', allow lines as 'Y', Pricing system can be Fusion SCM Pricer or Fusion Sales Cloud Price Book.
PRICE_DURING_BILLING_YN VARCHAR2 1 Flag to check if price will be determined during billing
CONTRACT_MODIFIER_FLAG VARCHAR2 1 Flag to indicate if contract modifier is allowed on contract
AMEND_NO_VERSION_FLAG VARCHAR2 1 Flag to indicate if contract needs to be versioned during amendment.
ESIGN_TEMPLATE_FLAG VARCHAR2 1 Flag to indicate the usage of esignature template.
ESIGN_TEMPLATE_ID VARCHAR2 120 Esignature Template Id
ENABLE_TXN_ADJ_ON_AMEND VARCHAR2 30 When the option is enabled, the applicable billing transactions are marked for adjustment on the approval of the project contract amendment based on the amendment effective date provided. If the option is disabled, billing transactions are not marked for adjustment on the approval of the project contract amendment, irrespective of the amendment effective date provided. Valid values are Y or N.
COPY_AMEND_DOC_FLAG VARCHAR2 1 This flag indicates to copy contract documents during amendment versioning; Possible values Y/N. Default is Y.

Foreign Keys

Table Foreign Table Foreign Key Column
pjf_rate_overrides_int okc_contract_types_b CONTRACT_TYPE_ID
okc_contract_type_parties okc_contract_types_b CONTRACT_TYPE_ID
okc_contract_types_tl okc_contract_types_b CONTRACT_TYPE_ID
okc_k_headers_all_b_h okc_contract_types_b CONTRACT_TYPE_ID
okc_contract_type_lines okc_contract_types_b CONTRACT_TYPE_ID
okc_ktype_key_terms okc_contract_types_b CONTRACT_TYPE_ID
okc_k_headers_all_b okc_contract_types_b CONTRACT_TYPE_ID

Indexes

Index Uniqueness Tablespace Columns
OKC_CONTRACT_TYPES_B_N1 Non Unique Default SET_ID
OKC_CONTRACT_TYPES_B_U1 Unique Default CONTRACT_TYPE_ID
OKC_CONTRACT_TYPES_B_U2 Unique Default CONTRACT_TYPE_CODE, SET_ID
OKC_CONTRACT_TYPES_B_U3 Unique Default CHR_TYPE