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: CE.CE_CP_WORKSHEET_LINES#

Source

View Text - Preformatted


select WORKSHEET_HEADER_ID WORKSHEET_HEADER_ID, WORKSHEET_LINE_ID WORKSHEET_LINE_ID, SOURCE_TYPE SOURCE_TYPE, INCLUDE_FLAG INCLUDE_FLAG, DESCRIPTION DESCRIPTION, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, BANK_NAME BANK_NAME, BANK_ACCOUNT_ID BANK_ACCOUNT_ID, BALANCE_TYPE BALANCE_TYPE, FLOAT_TYPE FLOAT_TYPE, TRX_TYPE TRX_TYPE, PAYMENT_METHOD PAYMENT_METHOD, RECEIPT_METHOD_ID RECEIPT_METHOD_ID, CLEARED_TRX_FLAG CLEARED_TRX_FLAG, OVERDUE_TRX_FLAG OVERDUE_TRX_FLAG, CUT_OFF_DAYS CUT_OFF_DAYS, EXT_SOURCE_TYPE EXT_SOURCE_TYPE, AMOUNT AMOUNT, PAYROLL_ID PAYROLL_ID, INDICATIVE_FLAG INDICATIVE_FLAG, CRITERIA_CATEGORY CRITERIA_CATEGORY, CRITERIA1 CRITERIA1, CRITERIA2 CRITERIA2, CRITERIA3 CRITERIA3, CRITERIA4 CRITERIA4, CRITERIA5 CRITERIA5, CRITERIA6 CRITERIA6, CRITERIA7 CRITERIA7, CRITERIA8 CRITERIA8, CRITERIA9 CRITERIA9, CRITERIA10 CRITERIA10, CRITERIA11 CRITERIA11, CRITERIA12 CRITERIA12, CRITERIA13 CRITERIA13, CRITERIA14 CRITERIA14, CRITERIA15 CRITERIA15, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, CASHPOOL_ID CASHPOOL_ID, TRXN_SUBTYPE_CODE_ID TRXN_SUBTYPE_CODE_ID from "CE"."CE_CP_WORKSHEET_LINES"

View Text - HTML Formatted

SELECT WORKSHEET_HEADER_ID WORKSHEET_HEADER_ID
, WORKSHEET_LINE_ID WORKSHEET_LINE_ID
, SOURCE_TYPE SOURCE_TYPE
, INCLUDE_FLAG INCLUDE_FLAG
, DESCRIPTION DESCRIPTION
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, BANK_NAME BANK_NAME
, BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, BALANCE_TYPE BALANCE_TYPE
, FLOAT_TYPE FLOAT_TYPE
, TRX_TYPE TRX_TYPE
, PAYMENT_METHOD PAYMENT_METHOD
, RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, CLEARED_TRX_FLAG CLEARED_TRX_FLAG
, OVERDUE_TRX_FLAG OVERDUE_TRX_FLAG
, CUT_OFF_DAYS CUT_OFF_DAYS
, EXT_SOURCE_TYPE EXT_SOURCE_TYPE
, AMOUNT AMOUNT
, PAYROLL_ID PAYROLL_ID
, INDICATIVE_FLAG INDICATIVE_FLAG
, CRITERIA_CATEGORY CRITERIA_CATEGORY
, CRITERIA1 CRITERIA1
, CRITERIA2 CRITERIA2
, CRITERIA3 CRITERIA3
, CRITERIA4 CRITERIA4
, CRITERIA5 CRITERIA5
, CRITERIA6 CRITERIA6
, CRITERIA7 CRITERIA7
, CRITERIA8 CRITERIA8
, CRITERIA9 CRITERIA9
, CRITERIA10 CRITERIA10
, CRITERIA11 CRITERIA11
, CRITERIA12 CRITERIA12
, CRITERIA13 CRITERIA13
, CRITERIA14 CRITERIA14
, CRITERIA15 CRITERIA15
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, CASHPOOL_ID CASHPOOL_ID
, TRXN_SUBTYPE_CODE_ID TRXN_SUBTYPE_CODE_ID
FROM "CE"."CE_CP_WORKSHEET_LINES"