VIEW: OKS.OKS_K_HEADERS_B#

Source

View Text - Preformatted

select ID ID, CHR_ID CHR_ID, ACCT_RULE_ID ACCT_RULE_ID, PAYMENT_TYPE PAYMENT_TYPE, CC_NO CC_NO, CC_EXPIRY_DATE CC_EXPIRY_DATE, CC_BANK_ACCT_ID CC_BANK_ACCT_ID, CC_AUTH_CODE CC_AUTH_CODE, COMMITMENT_ID COMMITMENT_ID, GRACE_DURATION GRACE_DURATION, GRACE_PERIOD GRACE_PERIOD, EST_REV_PERCENT EST_REV_PERCENT, EST_REV_DATE EST_REV_DATE, TAX_AMOUNT TAX_AMOUNT, TAX_STATUS TAX_STATUS, TAX_CODE TAX_CODE, TAX_EXEMPTION_ID TAX_EXEMPTION_ID, BILLING_PROFILE_ID BILLING_PROFILE_ID, RENEWAL_STATUS RENEWAL_STATUS, ELECTRONIC_RENEWAL_FLAG ELECTRONIC_RENEWAL_FLAG, QUOTE_TO_CONTACT_ID QUOTE_TO_CONTACT_ID, QUOTE_TO_SITE_ID QUOTE_TO_SITE_ID, QUOTE_TO_EMAIL_ID QUOTE_TO_EMAIL_ID, QUOTE_TO_PHONE_ID QUOTE_TO_PHONE_ID, QUOTE_TO_FAX_ID QUOTE_TO_FAX_ID, RENEWAL_PO_REQUIRED RENEWAL_PO_REQUIRED, RENEWAL_PO_NUMBER RENEWAL_PO_NUMBER, RENEWAL_PRICE_LIST RENEWAL_PRICE_LIST, RENEWAL_PRICING_TYPE RENEWAL_PRICING_TYPE, RENEWAL_MARKUP_PERCENT RENEWAL_MARKUP_PERCENT, RENEWAL_GRACE_DURATION RENEWAL_GRACE_DURATION, RENEWAL_GRACE_PERIOD RENEWAL_GRACE_PERIOD, RENEWAL_EST_REV_PERCENT RENEWAL_EST_REV_PERCENT, RENEWAL_EST_REV_DURATION RENEWAL_EST_REV_DURATION, RENEWAL_EST_REV_PERIOD RENEWAL_EST_REV_PERIOD, RENEWAL_PRICE_LIST_USED RENEWAL_PRICE_LIST_USED, RENEWAL_TYPE_USED RENEWAL_TYPE_USED, RENEWAL_NOTIFICATION_TO RENEWAL_NOTIFICATION_TO, RENEWAL_PO_USED RENEWAL_PO_USED, RENEWAL_PRICING_TYPE_USED RENEWAL_PRICING_TYPE_USED, RENEWAL_MARKUP_PERCENT_USED RENEWAL_MARKUP_PERCENT_USED, REV_EST_PERCENT_USED REV_EST_PERCENT_USED, REV_EST_DURATION_USED REV_EST_DURATION_USED, REV_EST_PERIOD_USED REV_EST_PERIOD_USED, BILLING_PROFILE_USED BILLING_PROFILE_USED, ERN_FLAG_USED_YN ERN_FLAG_USED_YN, EVN_THRESHOLD_AMT EVN_THRESHOLD_AMT, EVN_THRESHOLD_CUR EVN_THRESHOLD_CUR, ERN_THRESHOLD_AMT ERN_THRESHOLD_AMT, ERN_THRESHOLD_CUR ERN_THRESHOLD_CUR, RENEWAL_GRACE_DURATION_USED RENEWAL_GRACE_DURATION_USED, RENEWAL_GRACE_PERIOD_USED RENEWAL_GRACE_PERIOD_USED, INV_TRX_TYPE INV_TRX_TYPE, INV_PRINT_PROFILE INV_PRINT_PROFILE, AR_INTERFACE_YN AR_INTERFACE_YN, HOLD_BILLING HOLD_BILLING, SUMMARY_TRX_YN SUMMARY_TRX_YN, SERVICE_PO_NUMBER SERVICE_PO_NUMBER, SERVICE_PO_REQUIRED SERVICE_PO_REQUIRED, BILLING_SCHEDULE_TYPE BILLING_SCHEDULE_TYPE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SECURITY_GROUP_ID SECURITY_GROUP_ID, REQUEST_ID REQUEST_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, FOLLOW_UP_ACTION FOLLOW_UP_ACTION, FOLLOW_UP_DATE FOLLOW_UP_DATE, TRXN_EXTENSION_ID TRXN_EXTENSION_ID, DATE_ACCEPTED DATE_ACCEPTED, ACCEPTED_BY ACCEPTED_BY, RMNDR_SUPPRESS_FLAG RMNDR_SUPPRESS_FLAG, RMNDR_SENT_FLAG RMNDR_SENT_FLAG, QUOTE_SENT_FLAG QUOTE_SENT_FLAG, PROCESS_REQUEST_ID PROCESS_REQUEST_ID, WF_ITEM_KEY WF_ITEM_KEY, PERIOD_START PERIOD_START, PERIOD_TYPE PERIOD_TYPE, PRICE_UOM PRICE_UOM, PERSON_PARTY_ID PERSON_PARTY_ID, TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE, EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON_CODE EXEMPT_REASON_CODE, APPROVAL_TYPE_USED APPROVAL_TYPE_USED, RENEWAL_COMMENT RENEWAL_COMMENT, CC_EMAIL_ADDRESS CC_EMAIL_ADDRESS from "OKS"."OKS_K_HEADERS_B"

View Text - HTML Formatted

SELECT ID ID
, CHR_ID CHR_ID
, ACCT_RULE_ID ACCT_RULE_ID
, PAYMENT_TYPE PAYMENT_TYPE
, CC_NO CC_NO
, CC_EXPIRY_DATE CC_EXPIRY_DATE
, CC_BANK_ACCT_ID CC_BANK_ACCT_ID
, CC_AUTH_CODE CC_AUTH_CODE
, COMMITMENT_ID COMMITMENT_ID
, GRACE_DURATION GRACE_DURATION
, GRACE_PERIOD GRACE_PERIOD
, EST_REV_PERCENT EST_REV_PERCENT
, EST_REV_DATE EST_REV_DATE
, TAX_AMOUNT TAX_AMOUNT
, TAX_STATUS TAX_STATUS
, TAX_CODE TAX_CODE
, TAX_EXEMPTION_ID TAX_EXEMPTION_ID
, BILLING_PROFILE_ID BILLING_PROFILE_ID
, RENEWAL_STATUS RENEWAL_STATUS
, ELECTRONIC_RENEWAL_FLAG ELECTRONIC_RENEWAL_FLAG
, QUOTE_TO_CONTACT_ID QUOTE_TO_CONTACT_ID
, QUOTE_TO_SITE_ID QUOTE_TO_SITE_ID
, QUOTE_TO_EMAIL_ID QUOTE_TO_EMAIL_ID
, QUOTE_TO_PHONE_ID QUOTE_TO_PHONE_ID
, QUOTE_TO_FAX_ID QUOTE_TO_FAX_ID
, RENEWAL_PO_REQUIRED RENEWAL_PO_REQUIRED
, RENEWAL_PO_NUMBER RENEWAL_PO_NUMBER
, RENEWAL_PRICE_LIST RENEWAL_PRICE_LIST
, RENEWAL_PRICING_TYPE RENEWAL_PRICING_TYPE
, RENEWAL_MARKUP_PERCENT RENEWAL_MARKUP_PERCENT
, RENEWAL_GRACE_DURATION RENEWAL_GRACE_DURATION
, RENEWAL_GRACE_PERIOD RENEWAL_GRACE_PERIOD
, RENEWAL_EST_REV_PERCENT RENEWAL_EST_REV_PERCENT
, RENEWAL_EST_REV_DURATION RENEWAL_EST_REV_DURATION
, RENEWAL_EST_REV_PERIOD RENEWAL_EST_REV_PERIOD
, RENEWAL_PRICE_LIST_USED RENEWAL_PRICE_LIST_USED
, RENEWAL_TYPE_USED RENEWAL_TYPE_USED
, RENEWAL_NOTIFICATION_TO RENEWAL_NOTIFICATION_TO
, RENEWAL_PO_USED RENEWAL_PO_USED
, RENEWAL_PRICING_TYPE_USED RENEWAL_PRICING_TYPE_USED
, RENEWAL_MARKUP_PERCENT_USED RENEWAL_MARKUP_PERCENT_USED
, REV_EST_PERCENT_USED REV_EST_PERCENT_USED
, REV_EST_DURATION_USED REV_EST_DURATION_USED
, REV_EST_PERIOD_USED REV_EST_PERIOD_USED
, BILLING_PROFILE_USED BILLING_PROFILE_USED
, ERN_FLAG_USED_YN ERN_FLAG_USED_YN
, EVN_THRESHOLD_AMT EVN_THRESHOLD_AMT
, EVN_THRESHOLD_CUR EVN_THRESHOLD_CUR
, ERN_THRESHOLD_AMT ERN_THRESHOLD_AMT
, ERN_THRESHOLD_CUR ERN_THRESHOLD_CUR
, RENEWAL_GRACE_DURATION_USED RENEWAL_GRACE_DURATION_USED
, RENEWAL_GRACE_PERIOD_USED RENEWAL_GRACE_PERIOD_USED
, INV_TRX_TYPE INV_TRX_TYPE
, INV_PRINT_PROFILE INV_PRINT_PROFILE
, AR_INTERFACE_YN AR_INTERFACE_YN
, HOLD_BILLING HOLD_BILLING
, SUMMARY_TRX_YN SUMMARY_TRX_YN
, SERVICE_PO_NUMBER SERVICE_PO_NUMBER
, SERVICE_PO_REQUIRED SERVICE_PO_REQUIRED
, BILLING_SCHEDULE_TYPE BILLING_SCHEDULE_TYPE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, REQUEST_ID REQUEST_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FOLLOW_UP_ACTION FOLLOW_UP_ACTION
, FOLLOW_UP_DATE FOLLOW_UP_DATE
, TRXN_EXTENSION_ID TRXN_EXTENSION_ID
, DATE_ACCEPTED DATE_ACCEPTED
, ACCEPTED_BY ACCEPTED_BY
, RMNDR_SUPPRESS_FLAG RMNDR_SUPPRESS_FLAG
, RMNDR_SENT_FLAG RMNDR_SENT_FLAG
, QUOTE_SENT_FLAG QUOTE_SENT_FLAG
, PROCESS_REQUEST_ID PROCESS_REQUEST_ID
, WF_ITEM_KEY WF_ITEM_KEY
, PERIOD_START PERIOD_START
, PERIOD_TYPE PERIOD_TYPE
, PRICE_UOM PRICE_UOM
, PERSON_PARTY_ID PERSON_PARTY_ID
, TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER
, EXEMPT_REASON_CODE EXEMPT_REASON_CODE
, APPROVAL_TYPE_USED APPROVAL_TYPE_USED
, RENEWAL_COMMENT RENEWAL_COMMENT
, CC_EMAIL_ADDRESS CC_EMAIL_ADDRESS
FROM "OKS"."OKS_K_HEADERS_B"