[Home] [Help] [Dependency Information]
Object Name: | OKS_HEADERS_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | OKS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKS_HEADERS_INTERFACE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | HEADER_INTERFACE_ID |
OKS_HEADER_INTERFACE_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BATCH_ID |
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 |
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;
OKS.OKS_HEADERS_INTERFACE does not reference any database object
OKS.OKS_HEADERS_INTERFACE is referenced by following:
|
|
|