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

OKC_PRICING_TERMS_STD_INT

Interface table for okc_pricing_terms

Details

  • Schema: FUSION

  • Object owner: OKC

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

OKC_PRICING_TERMS_STD_INT_PK

BATCH_ID, INTERFACE_ROW_ID

Columns

Name Datatype Length Precision Not-null Comments
BATCH_ID NUMBER 18 Yes Import Batch Id, every batch of data being imported should be assigned a batch id.
INTERFACE_ROW_ID NUMBER 18 Yes Unique identifier for a record within a batch, source system should populate this.
IMPORT_STATUS_CODE VARCHAR2 30 Status of row in the interface table, source system should leave this as null.
FILE_RECORD_NUM NUMBER 18 Used by import utility to relate the record in interface table to the file row.
ACTION_CODE VARCHAR2 30 ACTION_CODE
INTERNAL_ACTION_CODE VARCHAR2 30 Used internally by the bulk import ODI program.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
FUSION_PRICING_TERM_ID NUMBER 18 PRICING_TERM_ID of this record in FUSION.
MAJOR_VERSION NUMBER 18 Identifies the contract major version.
PRICING_TERMS_PUID VARCHAR2 120 PRICING_TERMS_PUID
EXTERNAL_SOURCE VARCHAR2 120 EXTERNAL_SOURCE
EXTERNAL_KEY VARCHAR2 120 EXTERNAL_KEY
DNZ_CHR_ID NUMBER 18 Contract ID. Denormalized for performance.
CLE_ID NUMBER 18 Parent Line ID of this record
LINE_PUID VARCHAR2 120 LINE_PUID
ADJUSTMENT_TYPE VARCHAR2 80 e.g. %Discount, %Markup, etc. Based on a lookup type OKC_SAGR_ADJ_TYPES
ADJUSTMENT_TYPE_CODE VARCHAR2 30 Lookup type OKC_SAGR_ADJ_TYPES
ADJUSTMENT_AMOUNT NUMBER Adjustment numeric value associated with the Adjustment Type.
LIST_PRICE NUMBER LIST_PRICE
ALLOW_CUSTOM_ADJUSTMENTS_FLAG VARCHAR2 1 ALLOW_CUSTOM_ADJUSTMENTS_FLAG
PRICE_TYPE_CODE VARCHAR2 30 PRICE_TYPE_CODE
PRICE_PERIODICITY_CODE VARCHAR2 3 PRICE_PERIODICITY_CODE
ADJUSTMENT_BASIS_CODE VARCHAR2 30 ADJUSTMENT_BASIS_CODE
FLOOR_PRICE NUMBER FLOOR_PRICE
PERIOD_NAME VARCHAR2 30 PERIOD_NAME
START_DATE DATE START_DATE
END_DATE DATE END_DATE
ORIG_SYSTEM_ID NUMBER 18 ORIG_SYSTEM_ID
TIERED_YN VARCHAR2 1 Yes TIERED_YN
TIER_BASIS_TYPE_CODE VARCHAR2 30 TIER_BASIS_TYPE_CODE
TIER_BASIS_CODE VARCHAR2 30 TIER_BASIS_CODE
AGGREGATION_METHOD_CODE VARCHAR2 30 AGGREGATION_METHOD_CODE
GRADUATED_CODE VARCHAR2 30 GRADUATED_CODE
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.
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP 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.
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.
FILE_NAME_SYSTASK_ID NUMBER 18 Save the individual sys task id for each input csv file
INTERNAL_PRICING_TERMS_OVN NUMBER 9 INTERNAL_PRICING_TERMS_OVN

Indexes

Index Uniqueness Tablespace Columns
OKC_PRICING_TERMS_STD_INT_N1 Non Unique FUSION_TS_INTERFACE BATCH_ID, INTERNAL_ACTION_CODE, IMPORT_STATUS_CODE
OKC_PRICING_TERMS_STD_INT_N2 Non Unique FUSION_TS_INTERFACE BATCH_ID, PRICING_TERMS_PUID
OKC_PRICING_TERMS_STD_INT_U1 Unique FUSION_TS_INTERFACE BATCH_ID, INTERFACE_ROW_ID