VIEW: OKS.OKS_HEADERS_INTERFACE#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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