[Home] [Help] [Dependency Information]
Object Name: | OKS_K_DEFAULTS# |
---|---|
Object Type: | VIEW |
Owner: | OKS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | ||
CDT_TYPE | VARCHAR2 | (3) | Yes | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
SEGMENT_ID1 | VARCHAR2 | (40) | ||
SEGMENT_ID2 | VARCHAR2 | (40) | ||
JTOT_OBJECT_CODE | VARCHAR2 | (30) | ||
PDF_ID | NUMBER | |||
QCL_ID | NUMBER | |||
CGP_NEW_ID | NUMBER | |||
CGP_RENEW_ID | NUMBER | |||
PRICE_LIST_ID1 | VARCHAR2 | (40) | ||
PRICE_LIST_ID2 | VARCHAR2 | (40) | ||
RENEWAL_TYPE | VARCHAR2 | (30) | ||
PO_REQUIRED_YN | VARCHAR2 | (3) | ||
RENEWAL_PRICING_TYPE | VARCHAR2 | (3) | ||
MARKUP_PERCENT | NUMBER | (5) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
SECURITY_GROUP_ID | NUMBER | |||
RLE_CODE | VARCHAR2 | (30) | ||
REVENUE_ESTIMATED_PERCENT | NUMBER | (5) | ||
REVENUE_ESTIMATED_DURATION | NUMBER | |||
REVENUE_ESTIMATED_PERIOD | VARCHAR2 | (20) | ||
TEMPLATE_SET_ID | NUMBER | |||
THRESHOLD_CURRENCY | VARCHAR2 | (30) | ||
THRESHOLD_AMOUNT | NUMBER | |||
EMAIL_ADDRESS | VARCHAR2 | (2000) | ||
BILLING_PROFILE_ID | NUMBER | |||
USER_ID | NUMBER | |||
THRESHOLD_ENABLED_YN | VARCHAR2 | (3) | ||
GRACE_PERIOD | VARCHAR2 | (20) | ||
GRACE_DURATION | NUMBER | |||
PAYMENT_TERMS_ID1 | VARCHAR2 | (40) | ||
PAYMENT_TERMS_ID2 | VARCHAR2 | (40) | ||
EVERGREEN_THRESHOLD_CURR | VARCHAR2 | (30) | ||
EVERGREEN_THRESHOLD_AMT | NUMBER | |||
PAYMENT_METHOD | VARCHAR2 | (3) | ||
PAYMENT_THRESHOLD_CURR | VARCHAR2 | (30) | ||
PAYMENT_THRESHOLD_AMT | NUMBER | |||
INTERFACE_PRICE_BREAK | VARCHAR2 | (3) | ||
CREDIT_AMOUNT | VARCHAR2 | (50) | ||
BASE_CURRENCY | VARCHAR2 | (30) | ||
APPROVAL_TYPE | VARCHAR2 | (30) | ||
EVERGREEN_APPROVAL_TYPE | VARCHAR2 | (30) | ||
ONLINE_APPROVAL_TYPE | VARCHAR2 | (30) | ||
PURCHASE_ORDER_FLAG | VARCHAR2 | (3) | ||
CREDIT_CARD_FLAG | VARCHAR2 | (3) | ||
WIRE_FLAG | VARCHAR2 | (3) | ||
COMMITMENT_NUMBER_FLAG | VARCHAR2 | (3) | ||
CHECK_FLAG | VARCHAR2 | (3) | ||
PERIOD_TYPE | VARCHAR2 | (10) | ||
PERIOD_START | VARCHAR2 | (30) | ||
PRICE_UOM | VARCHAR2 | (10) | ||
TEMPLATE_LANGUAGE | VARCHAR2 | (50) |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, CDT_TYPE
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, SEGMENT_ID1
, SEGMENT_ID2
, JTOT_OBJECT_CODE
, PDF_ID
, QCL_ID
, CGP_NEW_ID
, CGP_RENEW_ID
, PRICE_LIST_ID1
, PRICE_LIST_ID2
, RENEWAL_TYPE
, PO_REQUIRED_YN
, RENEWAL_PRICING_TYPE
, MARKUP_PERCENT
, START_DATE
, END_DATE
, SECURITY_GROUP_ID
, RLE_CODE
, REVENUE_ESTIMATED_PERCENT
, REVENUE_ESTIMATED_DURATION
, REVENUE_ESTIMATED_PERIOD
, TEMPLATE_SET_ID
, THRESHOLD_CURRENCY
, THRESHOLD_AMOUNT
, EMAIL_ADDRESS
, BILLING_PROFILE_ID
, USER_ID
, THRESHOLD_ENABLED_YN
, GRACE_PERIOD
, GRACE_DURATION
, PAYMENT_TERMS_ID1
, PAYMENT_TERMS_ID2
, EVERGREEN_THRESHOLD_CURR
, EVERGREEN_THRESHOLD_AMT
, PAYMENT_METHOD
, PAYMENT_THRESHOLD_CURR
, PAYMENT_THRESHOLD_AMT
, INTERFACE_PRICE_BREAK
, CREDIT_AMOUNT
, BASE_CURRENCY
, APPROVAL_TYPE
, EVERGREEN_APPROVAL_TYPE
, ONLINE_APPROVAL_TYPE
, PURCHASE_ORDER_FLAG
, CREDIT_CARD_FLAG
, WIRE_FLAG
, COMMITMENT_NUMBER_FLAG
, CHECK_FLAG
, PERIOD_TYPE
, PERIOD_START
, PRICE_UOM
, TEMPLATE_LANGUAGE
FROM OKS.OKS_K_DEFAULTS#;
|
|
|