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: LNS.LNS_DISB_LINES#

Source

View Text - Preformatted


select DISB_LINE_ID DISB_LINE_ID, DISB_HEADER_ID DISB_HEADER_ID, DISB_LINE_NUMBER DISB_LINE_NUMBER, LINE_AMOUNT LINE_AMOUNT, LINE_PERCENT LINE_PERCENT, PAYEE_PARTY_ID PAYEE_PARTY_ID, BANK_ACCOUNT_ID BANK_ACCOUNT_ID, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE, REQUEST_DATE REQUEST_DATE, DISBURSEMENT_DATE DISBURSEMENT_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, STATUS STATUS, INVOICE_INTERFACE_ID INVOICE_INTERFACE_ID, INVOICE_ID INVOICE_ID, PARTY_SITE_ID PARTY_SITE_ID, INCOME_TAX_REGION INCOME_TAX_REGION, TYPE_1099 TYPE_1099 from "LNS"."LNS_DISB_LINES"

View Text - HTML Formatted

SELECT DISB_LINE_ID DISB_LINE_ID
, DISB_HEADER_ID DISB_HEADER_ID
, DISB_LINE_NUMBER DISB_LINE_NUMBER
, LINE_AMOUNT LINE_AMOUNT
, LINE_PERCENT LINE_PERCENT
, PAYEE_PARTY_ID PAYEE_PARTY_ID
, BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE
, REQUEST_DATE REQUEST_DATE
, DISBURSEMENT_DATE DISBURSEMENT_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, STATUS STATUS
, INVOICE_INTERFACE_ID INVOICE_INTERFACE_ID
, INVOICE_ID INVOICE_ID
, PARTY_SITE_ID PARTY_SITE_ID
, INCOME_TAX_REGION INCOME_TAX_REGION
, TYPE_1099 TYPE_1099
FROM "LNS"."LNS_DISB_LINES"