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

TABLE: OKS.OKS_HEADERS_INTERFACE

Object Details
Object Name: OKS_HEADERS_INTERFACE
Object Type: TABLE
Owner: OKS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKS_HEADERS_INTERFACE_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEADER_INTERFACE_ID
OKS_HEADER_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
Columns
Name Datatype Length Mandatory Comments
HEADER_INTERFACE_ID NUMBER
Yes Primary Key
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract Number
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract Number modifier
CATEGORY VARCHAR2 (30) Yes Contract Category. Possible values are �SUBSCRIPTION�, �SERVICE� or �WARRANTY�
START_DATE DATE
Yes Contract start date
END_DATE DATE
Yes Contract end date
STATUS_CODE VARCHAR2 (240) Yes Contract status code.
KNOWN_AS VARCHAR2 (300)
Known as
DESCRIPTION VARCHAR2 (1995) Yes Contract description
OPERATING_UNIT_ID NUMBER
Yes Operating Unit
CUSTOMER_PARTY_NAME VARCHAR2 (360)
Customer Party Name
CUSTOMER_PARTY_NUMBER VARCHAR2 (30)
Customer Party
CUSTOMER_PARTY_ID NUMBER

Customer Id
THIRD_PARTY_NAME VARCHAR2 (360)
Third Party Name
THIRD_PARTY_NUMBER VARCHAR2 (30)
Third Party Number
THIRD_PARTY_ID NUMBER

Third Party
BILL_TO_SITE_USAGE_CODE VARCHAR2 (40)
Not supported
BILL_TO_SITE_USAGE_ID NUMBER

Bill to site usage id
SHIP_TO_SITE_USAGE_CODE VARCHAR2 (40)
Not supported
SHIP_TO_SITE_USAGE_ID NUMBER

Ship to usage id
SALESPERSON_NAME VARCHAR2 (360)
Sales Person
SALESPERSON_ID NUMBER

Sales Person ID
SALESGROUP_ID NUMBER

Sales Group ID
CUSTOMER_CONTRACT_ADMIN_NAME VARCHAR2 (360)
Customer Contract administrator
CUSTOMER_CONTRACT_ADMIN_ID NUMBER

Customer Contract Administrator
CONTRACT_CURRENCY_CODE VARCHAR2 (15) Yes Contract Currency code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
AGREEMENT_NAME VARCHAR2 (240)
Agreement Name
AGREEMENT_ID NUMBER

Agreement Id
PRICE_LIST_NAME VARCHAR2 (240)
Price List Name
PRICE_LIST_ID NUMBER

Price List Id
PAYMENT_TERMS_NAME VARCHAR2 (15)
Payment Terms
PAYMENT_TERMS_ID NUMBER

Payment Terms Id
PAYMENT_INSTRUCTION VARCHAR2 (3)
Payment Instruction
PO_REQUIRED VARCHAR2 (3)
Po Required
PAYMENT_INSTRUCTION_DETAILS VARCHAR2 (150)
Payment Instruction Details
PAYMENT_METHOD_CODE VARCHAR2 (30)
Payment Method Code
COMMITMENT_ID NUMBER

Commitment ID
TAX_EXEMPTION_CONTROL VARCHAR2 (30)
Tax Status
TAX_EXEMPTION_NUMBER VARCHAR2 (80)
Tax Exemption Number
BILL_SERVICES VARCHAR2 (1)
AR Interface flag
BILLING_TRANSACTION_TYPE_ID NUMBER

Inventory Transaction type.
ACCOUNTING_RULE_NAME VARCHAR2 (30)
Accounting Rule
ACCOUNTING_RULE_ID NUMBER

Accounting Rule ID
INVOICING_RULE_NAME VARCHAR2 (30)
Invoicing Rule
INVOICING_RULE_ID NUMBER

Invoicing Rule ID
HOLD_CREDITS VARCHAR2 (1)
Hold credits
SUMMARY_PRINT VARCHAR2 (1)
Inventory Print Profile
SUMMARY_TRANSACTIONS VARCHAR2 (1)
Summary Transaction.
SERVICE_CHRG_PREPAY_REQ VARCHAR2 (1)
Service Charges Prepay Required flag
SERVICE_CHARGES_PO_REQUIRED VARCHAR2 (1)
Service PO required flag
SERVICE_CHARGES_PO_NUMBER VARCHAR2 (240)
Service PO Number
RENEWAL_PROCESS VARCHAR2 (30)
Renewal Type Code
APPROVAL_REQUIRED VARCHAR2 (30)
Approval Type
RENEW_UP_TO DATE

Renew up to date
PRICING_METHOD VARCHAR2 (30)
Renewal Pricing Method
RENEWAL_PRICE_LIST_NAME VARCHAR2 (240)
Renewal Price List Name
RENEWAL_PRICE_LIST_ID NUMBER

Renewal Price List ID
RENEWAL_MARKUP NUMBER

Markup %
RENEWAL_BILLING_PROFILE_ID NUMBER

Billing Profile ID
RENEWAL_PO_NUMBER VARCHAR2 (240)
Renewal PO Number
RENEWAL_PO_REQUIRED VARCHAR2 (1)
Renewal PO Required flag
RENEWAL_GRACE_DURATION NUMBER

Renewal grace duration
RENEWAL_GRACE_PERIOD VARCHAR2 (30)
Renewal Grace Period
RENEWAL_ESTIMATED_PERCENT NUMBER

Renewal Estimated Percent
RENEWAL_ESTIMATED_DURATION NUMBER

Renewal Estimated Duration
RENEWAL_ESTIMATED_PERIOD VARCHAR2 (30)
Renewal Estimated Period
QUOTE_TO_PARTY_SITE NUMBER

Quote to party site id
QUOTE_TO_CONTACT NUMBER

Quote To Contact
QUOTE_TO_PHONE NUMBER

Quote To Phone Number
QUOTE_TO_FAX NUMBER

Quote To Fax number
QUOTE_TO_EMAIL NUMBER

Quote To Email
DATE_APPROVED DATE

Approval Date
DATE_SIGNED DATE

Signed Date
DATE_CANCELED DATE

Canceled date
CANCELLATION_REASON VARCHAR2 (30)
Cancellation Reason Code
GRACE_DURATION NUMBER

Grace Duration
GRACE_PERIOD VARCHAR2 (30)
Grace Period
ESTIMATION_PERCENT NUMBER

Estimated Percent
ESTIMATION_DATE DATE

Estimation Date
FOLLOW_UP_DUE_DATE DATE

Follow up due date
FOLLOW_UP_ACTION VARCHAR2 (30)
Follow up action
QA_CHECKLIST NUMBER

QA Checklist
CONTRACT_GROUP_NAME VARCHAR2 (150)
Contract group name
CONTRACT_GROUP_ID NUMBER

Contract Group
APPROVAL_PROCESS_ID NUMBER

Approval process used
FULLY_BILLED VARCHAR2 (1) Yes Fully Billed
SOURCE VARCHAR2 (80)
Source
DOCUMENT VARCHAR2 (240)
Document
INTERFACE_STATUS VARCHAR2 (1)
E=Error, S=Success, R=Reprocess
INV_ORGANIZATION_ID NUMBER

Inventory Organization Id
EXEMPT_REASON_CODE VARCHAR2 (30)
Exempt Reason Code
BATCH_ID NUMBER
Yes Batch Number
PARENT_REQUEST_ID NUMBER

Request Id to be stamped by the import process
Query Text

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


SELECT HEADER_INTERFACE_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      CATEGORY
,      START_DATE
,      END_DATE
,      STATUS_CODE
,      KNOWN_AS
,      DESCRIPTION
,      OPERATING_UNIT_ID
,      CUSTOMER_PARTY_NAME
,      CUSTOMER_PARTY_NUMBER
,      CUSTOMER_PARTY_ID
,      THIRD_PARTY_NAME
,      THIRD_PARTY_NUMBER
,      THIRD_PARTY_ID
,      BILL_TO_SITE_USAGE_CODE
,      BILL_TO_SITE_USAGE_ID
,      SHIP_TO_SITE_USAGE_CODE
,      SHIP_TO_SITE_USAGE_ID
,      SALESPERSON_NAME
,      SALESPERSON_ID
,      SALESGROUP_ID
,      CUSTOMER_CONTRACT_ADMIN_NAME
,      CUSTOMER_CONTRACT_ADMIN_ID
,      CONTRACT_CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      AGREEMENT_NAME
,      AGREEMENT_ID
,      PRICE_LIST_NAME
,      PRICE_LIST_ID
,      PAYMENT_TERMS_NAME
,      PAYMENT_TERMS_ID
,      PAYMENT_INSTRUCTION
,      PO_REQUIRED
,      PAYMENT_INSTRUCTION_DETAILS
,      PAYMENT_METHOD_CODE
,      COMMITMENT_ID
,      TAX_EXEMPTION_CONTROL
,      TAX_EXEMPTION_NUMBER
,      BILL_SERVICES
,      BILLING_TRANSACTION_TYPE_ID
,      ACCOUNTING_RULE_NAME
,      ACCOUNTING_RULE_ID
,      INVOICING_RULE_NAME
,      INVOICING_RULE_ID
,      HOLD_CREDITS
,      SUMMARY_PRINT
,      SUMMARY_TRANSACTIONS
,      SERVICE_CHRG_PREPAY_REQ
,      SERVICE_CHARGES_PO_REQUIRED
,      SERVICE_CHARGES_PO_NUMBER
,      RENEWAL_PROCESS
,      APPROVAL_REQUIRED
,      RENEW_UP_TO
,      PRICING_METHOD
,      RENEWAL_PRICE_LIST_NAME
,      RENEWAL_PRICE_LIST_ID
,      RENEWAL_MARKUP
,      RENEWAL_BILLING_PROFILE_ID
,      RENEWAL_PO_NUMBER
,      RENEWAL_PO_REQUIRED
,      RENEWAL_GRACE_DURATION
,      RENEWAL_GRACE_PERIOD
,      RENEWAL_ESTIMATED_PERCENT
,      RENEWAL_ESTIMATED_DURATION
,      RENEWAL_ESTIMATED_PERIOD
,      QUOTE_TO_PARTY_SITE
,      QUOTE_TO_CONTACT
,      QUOTE_TO_PHONE
,      QUOTE_TO_FAX
,      QUOTE_TO_EMAIL
,      DATE_APPROVED
,      DATE_SIGNED
,      DATE_CANCELED
,      CANCELLATION_REASON
,      GRACE_DURATION
,      GRACE_PERIOD
,      ESTIMATION_PERCENT
,      ESTIMATION_DATE
,      FOLLOW_UP_DUE_DATE
,      FOLLOW_UP_ACTION
,      QA_CHECKLIST
,      CONTRACT_GROUP_NAME
,      CONTRACT_GROUP_ID
,      APPROVAL_PROCESS_ID
,      FULLY_BILLED
,      SOURCE
,      DOCUMENT
,      INTERFACE_STATUS
,      INV_ORGANIZATION_ID
,      EXEMPT_REASON_CODE
,      BATCH_ID
,      PARENT_REQUEST_ID
FROM OKS.OKS_HEADERS_INTERFACE;

Dependencies

[top of page]

OKS.OKS_HEADERS_INTERFACE does not reference any database object

OKS.OKS_HEADERS_INTERFACE is referenced by following:

SchemaOKS
ViewOKS_HEADERS_INTERFACE#