eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: OKL.OKL_TERMS_INTERFACE#

Source

View Text - Preformatted


select CONTRACT_NUMBER_OLD CONTRACT_NUMBER_OLD, LINE_NUMBER LINE_NUMBER, BILL_TO_ADDRESS_ID BILL_TO_ADDRESS_ID, BILL_TO_ADDRESS BILL_TO_ADDRESS, BANK_ACCOUNT_ID BANK_ACCOUNT_ID, BANK_ACCOUNT_NUMBER BANK_ACCOUNT_NUMBER, REASON_FOR_INVOICE_REVIEW REASON_FOR_INVOICE_REVIEW, INVOICE_REVIEW_UNTIL_DATE INVOICE_REVIEW_UNTIL_DATE, INVOICE_FORMAT_ID INVOICE_FORMAT_ID, INVOICE_FORMAT_CODE INVOICE_FORMAT_CODE, REVIEW_INVOICE_FLAG REVIEW_INVOICE_FLAG, PAYMENT_METHOD_ID PAYMENT_METHOD_ID, PAYMENT_METHOD PAYMENT_METHOD, PRESCRIBED_ASSET_FLAG PRESCRIBED_ASSET_FLAG, SCREEN_SECTION_NAME SCREEN_SECTION_NAME, SCREEN_FIELD_LABEL SCREEN_FIELD_LABEL, SCREEN_FIELD_VALUE SCREEN_FIELD_VALUE, CASH_APPL_RULE_NAME CASH_APPL_RULE_NAME from "OKL"."OKL_TERMS_INTERFACE"

View Text - HTML Formatted

SELECT CONTRACT_NUMBER_OLD CONTRACT_NUMBER_OLD
, LINE_NUMBER LINE_NUMBER
, BILL_TO_ADDRESS_ID BILL_TO_ADDRESS_ID
, BILL_TO_ADDRESS BILL_TO_ADDRESS
, BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, BANK_ACCOUNT_NUMBER BANK_ACCOUNT_NUMBER
, REASON_FOR_INVOICE_REVIEW REASON_FOR_INVOICE_REVIEW
, INVOICE_REVIEW_UNTIL_DATE INVOICE_REVIEW_UNTIL_DATE
, INVOICE_FORMAT_ID INVOICE_FORMAT_ID
, INVOICE_FORMAT_CODE INVOICE_FORMAT_CODE
, REVIEW_INVOICE_FLAG REVIEW_INVOICE_FLAG
, PAYMENT_METHOD_ID PAYMENT_METHOD_ID
, PAYMENT_METHOD PAYMENT_METHOD
, PRESCRIBED_ASSET_FLAG PRESCRIBED_ASSET_FLAG
, SCREEN_SECTION_NAME SCREEN_SECTION_NAME
, SCREEN_FIELD_LABEL SCREEN_FIELD_LABEL
, SCREEN_FIELD_VALUE SCREEN_FIELD_VALUE
, CASH_APPL_RULE_NAME CASH_APPL_RULE_NAME
FROM "OKL"."OKL_TERMS_INTERFACE"