Skip to content

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

TABLE: CS.CS_CONTRACTS_ALL

Object Details
Object Name: CS_CONTRACTS_ALL
Object Type: TABLE
Owner: CS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CONTRACT_ID NUMBER
Yes
CONTRACT_NUMBER NUMBER
Yes
WORKFLOW VARCHAR2 (30)
AGREEMENT_ID NUMBER

PRICE_LIST_ID NUMBER
Yes
CURRENCY_CODE VARCHAR2 (15) Yes
CONVERSION_TYPE_CODE VARCHAR2 (30)
CONVERSION_RATE NUMBER

CONVERSION_DATE DATE

INVOICING_RULE_ID NUMBER

ACCOUNTING_RULE_ID NUMBER

BILLING_FREQUENCY_PERIOD VARCHAR2 (3)
FIRST_BILL_DATE DATE

NEXT_BILL_DATE DATE

CREATE_SALES_ORDER VARCHAR2 (1)
RENEWAL_RULE VARCHAR2 (2000)
TERMINATION_RULE VARCHAR2 (2000)
BILL_TO_SITE_USE_ID NUMBER
Yes
CONTRACT_STATUS_ID NUMBER
Yes
CONTRACT_TYPE_ID NUMBER
Yes
CONTRACT_TEMPLATE_ID NUMBER

CONTRACT_GROUP_ID NUMBER
Yes
CUSTOMER_ID NUMBER
Yes
DURATION NUMBER
Yes
PERIOD_CODE VARCHAR2 (30) Yes
SHIP_TO_SITE_USE_ID NUMBER

SALESPERSON_ID NUMBER

ORG_ID NUMBER

ORDERED_BY_CONTACT_ID NUMBER

SOURCE_CODE VARCHAR2 (30)
SOURCE_REFERENCE VARCHAR2 (50)
TERMS_ID NUMBER
Yes
PO_NUMBER NUMBER

BILL_ON NUMBER

TAX_HANDLING VARCHAR2 (80)
TAX_EXEMPT_NUM VARCHAR2 (80)
TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
CONTRACT_AMOUNT NUMBER

AUTO_RENEWAL_FLAG VARCHAR2 (1)
ORIGINAL_END_DATE DATE

TERMINATE_REASON_CODE VARCHAR2 (30)
DISCOUNT_ID NUMBER

PO_REQUIRED_TO_SERVICE VARCHAR2 (1)
PRE_PAYMENT_REQUIRED VARCHAR2 (1)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

START_DATE_ACTIVE DATE
Yes
END_DATE_ACTIVE DATE
Yes
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
CONTEXT VARCHAR2 (150)
OBJECT_VERSION_NUMBER NUMBER

WORKFLOW_PROCESS_ID NUMBER (15)
Query Text

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


SELECT CONTRACT_ID
,      CONTRACT_NUMBER
,      WORKFLOW
,      AGREEMENT_ID
,      PRICE_LIST_ID
,      CURRENCY_CODE
,      CONVERSION_TYPE_CODE
,      CONVERSION_RATE
,      CONVERSION_DATE
,      INVOICING_RULE_ID
,      ACCOUNTING_RULE_ID
,      BILLING_FREQUENCY_PERIOD
,      FIRST_BILL_DATE
,      NEXT_BILL_DATE
,      CREATE_SALES_ORDER
,      RENEWAL_RULE
,      TERMINATION_RULE
,      BILL_TO_SITE_USE_ID
,      CONTRACT_STATUS_ID
,      CONTRACT_TYPE_ID
,      CONTRACT_TEMPLATE_ID
,      CONTRACT_GROUP_ID
,      CUSTOMER_ID
,      DURATION
,      PERIOD_CODE
,      SHIP_TO_SITE_USE_ID
,      SALESPERSON_ID
,      ORG_ID
,      ORDERED_BY_CONTACT_ID
,      SOURCE_CODE
,      SOURCE_REFERENCE
,      TERMS_ID
,      PO_NUMBER
,      BILL_ON
,      TAX_HANDLING
,      TAX_EXEMPT_NUM
,      TAX_EXEMPT_REASON_CODE
,      CONTRACT_AMOUNT
,      AUTO_RENEWAL_FLAG
,      ORIGINAL_END_DATE
,      TERMINATE_REASON_CODE
,      DISCOUNT_ID
,      PO_REQUIRED_TO_SERVICE
,      PRE_PAYMENT_REQUIRED
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CONTEXT
,      OBJECT_VERSION_NUMBER
,      WORKFLOW_PROCESS_ID
FROM CS.CS_CONTRACTS_ALL;

Dependencies

[top of page]

CS.CS_CONTRACTS_ALL does not reference any database object

CS.CS_CONTRACTS_ALL is referenced by following:

SchemaCS
ViewCS_CONTRACTS_ALL#