[Home] [Help] [Dependency Information]
Object Name: | OKS_INT_HEADER_STG_TEMP# |
---|---|
Object Type: | VIEW |
Owner: | OKS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HEADER_INTERFACE_ID | NUMBER | |||
HEADER_INTERFACE_ROWID | ROWID | (10) | ||
CONTRACT_NUMBER | VARCHAR2 | (120) | ||
CONTRACT_NUMBER_MODIFIER | VARCHAR2 | (120) | ||
INTERFACE_STATUS | VARCHAR2 | (1) | ||
CATEGORY | VARCHAR2 | (30) | ||
STATUS_CODE | VARCHAR2 | (30) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
KNOWN_AS | VARCHAR2 | (300) | ||
DESCRIPTION | VARCHAR2 | (1995) | ||
INV_ORGANIZATION_ID | NUMBER | |||
OPERATING_UNIT_ID | NUMBER | |||
BILL_TO_SITE_USAGE_ID | NUMBER | |||
SHIP_TO_SITE_USAGE_ID | NUMBER | |||
CONTRACT_CURRENCY_CODE | VARCHAR2 | (15) | ||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_RATE | NUMBER | |||
CURRENCY_CONVERSION_DATE | DATE | |||
PRICE_LIST_ID | NUMBER | |||
PAYMENT_TERMS_ID | NUMBER | (15) | ||
PAYMENT_INSTRUCTION | VARCHAR2 | (3) | ||
PO_REQUIRED | VARCHAR2 | (3) | ||
PAYMENT_INSTRUCTION_DETAILS | VARCHAR2 | (150) | ||
INVOICING_RULE_ID | NUMBER | (15) | ||
SERVICE_CHRG_PREPAY_REQ | VARCHAR2 | (1) | ||
RENEWAL_PROCESS | VARCHAR2 | (30) | ||
APPROVAL_REQUIRED | VARCHAR2 | (30) | ||
RENEW_UP_TO | DATE | |||
DATE_APPROVED | DATE | |||
DATE_SIGNED | DATE | |||
DATE_CANCELED | DATE | |||
CANCELLATION_REASON | VARCHAR2 | (30) | ||
QA_CHECKLIST | NUMBER | |||
PAYMENT_METHOD_CODE | VARCHAR2 | (30) | ||
COMMITMENT_ID | NUMBER | |||
TAX_EXEMPTION_CONTROL | VARCHAR2 | (30) | ||
TAX_EXEMPTION_NUMBER | VARCHAR2 | (80) | ||
EXEMPT_REASON_CODE | VARCHAR2 | (30) | ||
BILL_SERVICES | VARCHAR2 | (1) | ||
BILLING_TRANSACTION_TYPE_ID | NUMBER | |||
ACCOUNTING_RULE_ID | NUMBER | |||
HOLD_CREDITS | VARCHAR2 | (1) | ||
SUMMARY_PRINT | VARCHAR2 | (1) | ||
SUMMARY_TRANSACTIONS | VARCHAR2 | (1) | ||
SERVICE_CHARGES_PO_REQUIRED | VARCHAR2 | (1) | ||
SERVICE_CHARGES_PO_NUMBER | VARCHAR2 | (240) | ||
PRICING_METHOD | VARCHAR2 | (30) | ||
RENEWAL_PRICE_LIST_ID | NUMBER | |||
RENEWAL_MARKUP | NUMBER | |||
RENEWAL_BILLING_PROFILE_ID | NUMBER | |||
RENEWAL_PO_NUMBER | VARCHAR2 | (240) | ||
RENEWAL_PO_REQUIRED | VARCHAR2 | (1) | ||
RENEWAL_GRACE_DURATION | NUMBER | |||
RENEWAL_GRACE_PERIOD | VARCHAR2 | (30) | ||
RENEWAL_ESTIMATED_PERCENT | NUMBER | |||
RENEWAL_ESTIMATED_DURATION | NUMBER | |||
RENEWAL_ESTIMATED_PERIOD | VARCHAR2 | (30) | ||
QUOTE_TO_PARTY_SITE | NUMBER | |||
QUOTE_TO_CONTACT | NUMBER | |||
QUOTE_TO_PHONE | NUMBER | |||
QUOTE_TO_FAX | NUMBER | |||
QUOTE_TO_EMAIL | NUMBER | |||
GRACE_DURATION | NUMBER | |||
GRACE_PERIOD | VARCHAR2 | (30) | ||
ESTIMATION_PERCENT | NUMBER | |||
ESTIMATION_DATE | DATE | |||
FOLLOW_UP_DUE_DATE | DATE | |||
FOLLOW_UP_ACTION | VARCHAR2 | (30) | ||
CUSTOMER_PARTY_ID | NUMBER | |||
THIRD_PARTY_ID | NUMBER | |||
CONTRACT_GROUP_ID | NUMBER | |||
APPROVAL_PROCESS_ID | NUMBER | |||
AGREEMENT_ID | NUMBER | |||
SALESPERSON_ID | NUMBER | |||
CUSTOMER_CONTRACT_ADMIN_ID | NUMBER | |||
SALESGROUP_ID | NUMBER | |||
FULLY_BILLED | VARCHAR2 | (1) | ||
SOURCE | VARCHAR2 | (80) | ||
DOCUMENT | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT HEADER_INTERFACE_ID
, HEADER_INTERFACE_ROWID
, CONTRACT_NUMBER
, CONTRACT_NUMBER_MODIFIER
, INTERFACE_STATUS
, CATEGORY
, STATUS_CODE
, START_DATE
, END_DATE
, KNOWN_AS
, DESCRIPTION
, INV_ORGANIZATION_ID
, OPERATING_UNIT_ID
, BILL_TO_SITE_USAGE_ID
, SHIP_TO_SITE_USAGE_ID
, CONTRACT_CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
, PRICE_LIST_ID
, PAYMENT_TERMS_ID
, PAYMENT_INSTRUCTION
, PO_REQUIRED
, PAYMENT_INSTRUCTION_DETAILS
, INVOICING_RULE_ID
, SERVICE_CHRG_PREPAY_REQ
, RENEWAL_PROCESS
, APPROVAL_REQUIRED
, RENEW_UP_TO
, DATE_APPROVED
, DATE_SIGNED
, DATE_CANCELED
, CANCELLATION_REASON
, QA_CHECKLIST
, PAYMENT_METHOD_CODE
, COMMITMENT_ID
, TAX_EXEMPTION_CONTROL
, TAX_EXEMPTION_NUMBER
, EXEMPT_REASON_CODE
, BILL_SERVICES
, BILLING_TRANSACTION_TYPE_ID
, ACCOUNTING_RULE_ID
, HOLD_CREDITS
, SUMMARY_PRINT
, SUMMARY_TRANSACTIONS
, SERVICE_CHARGES_PO_REQUIRED
, SERVICE_CHARGES_PO_NUMBER
, PRICING_METHOD
, 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
, GRACE_DURATION
, GRACE_PERIOD
, ESTIMATION_PERCENT
, ESTIMATION_DATE
, FOLLOW_UP_DUE_DATE
, FOLLOW_UP_ACTION
, CUSTOMER_PARTY_ID
, THIRD_PARTY_ID
, CONTRACT_GROUP_ID
, APPROVAL_PROCESS_ID
, AGREEMENT_ID
, SALESPERSON_ID
, CUSTOMER_CONTRACT_ADMIN_ID
, SALESGROUP_ID
, FULLY_BILLED
, SOURCE
, DOCUMENT
FROM OKS.OKS_INT_HEADER_STG_TEMP#;
|
|
|