VIEW: OKS.OKS_LINES_INTERFACE#

Source

View Text - Preformatted

select LINE_INTERFACE_ID LINE_INTERFACE_ID, HEADER_INTERFACE_ID HEADER_INTERFACE_ID, LINE_NUMBER LINE_NUMBER, LINE_TYPE LINE_TYPE, ITEM_ORGANIZATION_ID ITEM_ORGANIZATION_ID, ITEM_NAME ITEM_NAME, ITEM_ID ITEM_ID, REFERENCE_TEMPLATE_ID REFERENCE_TEMPLATE_ID, LINE_REFERENCE LINE_REFERENCE, STATUS_CODE STATUS_CODE, START_DATE START_DATE, END_DATE END_DATE, 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, BILLING_CONTACT_NAME BILLING_CONTACT_NAME, BILLING_CONTACT_ID BILLING_CONTACT_ID, SHIPPING_CONTACT_NAME SHIPPING_CONTACT_NAME, SHIPPING_CONTACT_ID SHIPPING_CONTACT_ID, RENEWAL_TYPE_CODE RENEWAL_TYPE_CODE, CANCELLATION_DATE CANCELLATION_DATE, CANCELLATION_REASON CANCELLATION_REASON, PRICE_LIST_NAME PRICE_LIST_NAME, PRICE_LIST_ID PRICE_LIST_ID, INVOICE_TEXT INVOICE_TEXT, PRINT_INVOICE PRINT_INVOICE, SUBTOTAL SUBTOTAL, TAX_AMOUNT TAX_AMOUNT, TAX_EXEMPTION_CONTROL TAX_EXEMPTION_CONTROL, TAX_EXEMPTION_NUMBER TAX_EXEMPTION_NUMBER, TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE, PAYMENT_INSTRUCTION PAYMENT_INSTRUCTION, PO_REQUIRED PO_REQUIRED, PAYMENT_INSTRUCTION_DETAILS PAYMENT_INSTRUCTION_DETAILS, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE, COMMITMENT_ID COMMITMENT_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, BILLING_INTERVAL_DURATION BILLING_INTERVAL_DURATION, BILLING_INTERVAL_PERIOD BILLING_INTERVAL_PERIOD, FIRST_BILL_UPTO_DATE FIRST_BILL_UPTO_DATE, EXEMPT_REASON_CODE EXEMPT_REASON_CODE, RECUR_BILL_OCCURANCES RECUR_BILL_OCCURANCES, SUBSCRIPTION_QUANTITY SUBSCRIPTION_QUANTITY, QUANTITY_UOM QUANTITY_UOM, PRICE_UOM PRICE_UOM, UNIT_PRICE UNIT_PRICE, FIRST_BILLED_AMOUNT FIRST_BILLED_AMOUNT, LAST_BILLED_AMOUNT LAST_BILLED_AMOUNT, USAGE_TYPE USAGE_TYPE, USAGE_PERIOD USAGE_PERIOD, AVERAGING_INTERVAL AVERAGING_INTERVAL, SETTLEMENT_INTERVAL SETTLEMENT_INTERVAL, USAGE_TERMINATION_METHOD USAGE_TERMINATION_METHOD from "OKS"."OKS_LINES_INTERFACE"

View Text - HTML Formatted

SELECT LINE_INTERFACE_ID LINE_INTERFACE_ID
, HEADER_INTERFACE_ID HEADER_INTERFACE_ID
, LINE_NUMBER LINE_NUMBER
, LINE_TYPE LINE_TYPE
, ITEM_ORGANIZATION_ID ITEM_ORGANIZATION_ID
, ITEM_NAME ITEM_NAME
, ITEM_ID ITEM_ID
, REFERENCE_TEMPLATE_ID REFERENCE_TEMPLATE_ID
, LINE_REFERENCE LINE_REFERENCE
, STATUS_CODE STATUS_CODE
, START_DATE START_DATE
, END_DATE END_DATE
, 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
, BILLING_CONTACT_NAME BILLING_CONTACT_NAME
, BILLING_CONTACT_ID BILLING_CONTACT_ID
, SHIPPING_CONTACT_NAME SHIPPING_CONTACT_NAME
, SHIPPING_CONTACT_ID SHIPPING_CONTACT_ID
, RENEWAL_TYPE_CODE RENEWAL_TYPE_CODE
, CANCELLATION_DATE CANCELLATION_DATE
, CANCELLATION_REASON CANCELLATION_REASON
, PRICE_LIST_NAME PRICE_LIST_NAME
, PRICE_LIST_ID PRICE_LIST_ID
, INVOICE_TEXT INVOICE_TEXT
, PRINT_INVOICE PRINT_INVOICE
, SUBTOTAL SUBTOTAL
, TAX_AMOUNT TAX_AMOUNT
, TAX_EXEMPTION_CONTROL TAX_EXEMPTION_CONTROL
, TAX_EXEMPTION_NUMBER TAX_EXEMPTION_NUMBER
, TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, PAYMENT_INSTRUCTION PAYMENT_INSTRUCTION
, PO_REQUIRED PO_REQUIRED
, PAYMENT_INSTRUCTION_DETAILS PAYMENT_INSTRUCTION_DETAILS
, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE
, COMMITMENT_ID COMMITMENT_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
, BILLING_INTERVAL_DURATION BILLING_INTERVAL_DURATION
, BILLING_INTERVAL_PERIOD BILLING_INTERVAL_PERIOD
, FIRST_BILL_UPTO_DATE FIRST_BILL_UPTO_DATE
, EXEMPT_REASON_CODE EXEMPT_REASON_CODE
, RECUR_BILL_OCCURANCES RECUR_BILL_OCCURANCES
, SUBSCRIPTION_QUANTITY SUBSCRIPTION_QUANTITY
, QUANTITY_UOM QUANTITY_UOM
, PRICE_UOM PRICE_UOM
, UNIT_PRICE UNIT_PRICE
, FIRST_BILLED_AMOUNT FIRST_BILLED_AMOUNT
, LAST_BILLED_AMOUNT LAST_BILLED_AMOUNT
, USAGE_TYPE USAGE_TYPE
, USAGE_PERIOD USAGE_PERIOD
, AVERAGING_INTERVAL AVERAGING_INTERVAL
, SETTLEMENT_INTERVAL SETTLEMENT_INTERVAL
, USAGE_TERMINATION_METHOD USAGE_TERMINATION_METHOD
FROM "OKS"."OKS_LINES_INTERFACE"