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: AR.AR_RECEIPT_METHOD_ACCOUNTS_AL#

Source

View Text - Preformatted


select REMIT_BANK_ACCT_USE_ID REMIT_BANK_ACCT_USE_ID, RECEIPT_METHOD_ID RECEIPT_METHOD_ID, CASH_CCID CASH_CCID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, EARNED_CCID EARNED_CCID, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, ON_ACCOUNT_CCID ON_ACCOUNT_CCID, START_DATE START_DATE, UNAPPLIED_CCID UNAPPLIED_CCID, UNEARNED_CCID UNEARNED_CCID, UNIDENTIFIED_CCID UNIDENTIFIED_CCID, BANK_CHARGES_CCID BANK_CHARGES_CCID, END_DATE END_DATE, FACTOR_CCID FACTOR_CCID, FACTOR_PRINT_PROGRAM_ID FACTOR_PRINT_PROGRAM_ID, FACTOR_TRANSMISSION_PROGRAM_ID FACTOR_TRANSMISSION_PROGRAM_ID, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MIN_RECEIPT_AMOUNT MIN_RECEIPT_AMOUNT, RECEIPT_CLEARING_CCID RECEIPT_CLEARING_CCID, REMITTANCE_CCID REMITTANCE_CCID, REMIT_PRINT_PROGRAM_ID REMIT_PRINT_PROGRAM_ID, REMIT_TRANSMISSION_PROGRAM_ID REMIT_TRANSMISSION_PROGRAM_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, PRIMARY_FLAG PRIMARY_FLAG, CLEARING_DAYS CLEARING_DAYS, SHORT_TERM_DEBT_CCID SHORT_TERM_DEBT_CCID, OVERRIDE_REMIT_ACCOUNT_FLAG OVERRIDE_REMIT_ACCOUNT_FLAG, RISK_ELIMINATION_DAYS RISK_ELIMINATION_DAYS, ORG_ID ORG_ID, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, EDISC_RECEIVABLES_TRX_ID EDISC_RECEIVABLES_TRX_ID, UNEDISC_RECEIVABLES_TRX_ID UNEDISC_RECEIVABLES_TRX_ID, BR_COLLECTION_DAYS BR_COLLECTION_DAYS, BR_STD_RECEIVABLES_TRX_ID BR_STD_RECEIVABLES_TRX_ID, BR_REMITTANCE_CCID BR_REMITTANCE_CCID, BR_FACTOR_CCID BR_FACTOR_CCID, CLAIM_RECEIVABLES_TRX_ID CLAIM_RECEIVABLES_TRX_ID, OLD_BANK_ACCOUNT_ID OLD_BANK_ACCOUNT_ID, ZD_EDITION_NAME ZD_EDITION_NAME from "AR"."AR_RECEIPT_METHOD_ACCOUNTS_ALL"

View Text - HTML Formatted

SELECT REMIT_BANK_ACCT_USE_ID REMIT_BANK_ACCT_USE_ID
, RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, CASH_CCID CASH_CCID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, EARNED_CCID EARNED_CCID
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, ON_ACCOUNT_CCID ON_ACCOUNT_CCID
, START_DATE START_DATE
, UNAPPLIED_CCID UNAPPLIED_CCID
, UNEARNED_CCID UNEARNED_CCID
, UNIDENTIFIED_CCID UNIDENTIFIED_CCID
, BANK_CHARGES_CCID BANK_CHARGES_CCID
, END_DATE END_DATE
, FACTOR_CCID FACTOR_CCID
, FACTOR_PRINT_PROGRAM_ID FACTOR_PRINT_PROGRAM_ID
, FACTOR_TRANSMISSION_PROGRAM_ID FACTOR_TRANSMISSION_PROGRAM_ID
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MIN_RECEIPT_AMOUNT MIN_RECEIPT_AMOUNT
, RECEIPT_CLEARING_CCID RECEIPT_CLEARING_CCID
, REMITTANCE_CCID REMITTANCE_CCID
, REMIT_PRINT_PROGRAM_ID REMIT_PRINT_PROGRAM_ID
, REMIT_TRANSMISSION_PROGRAM_ID REMIT_TRANSMISSION_PROGRAM_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, PRIMARY_FLAG PRIMARY_FLAG
, CLEARING_DAYS CLEARING_DAYS
, SHORT_TERM_DEBT_CCID SHORT_TERM_DEBT_CCID
, OVERRIDE_REMIT_ACCOUNT_FLAG OVERRIDE_REMIT_ACCOUNT_FLAG
, RISK_ELIMINATION_DAYS RISK_ELIMINATION_DAYS
, ORG_ID ORG_ID
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, EDISC_RECEIVABLES_TRX_ID EDISC_RECEIVABLES_TRX_ID
, UNEDISC_RECEIVABLES_TRX_ID UNEDISC_RECEIVABLES_TRX_ID
, BR_COLLECTION_DAYS BR_COLLECTION_DAYS
, BR_STD_RECEIVABLES_TRX_ID BR_STD_RECEIVABLES_TRX_ID
, BR_REMITTANCE_CCID BR_REMITTANCE_CCID
, BR_FACTOR_CCID BR_FACTOR_CCID
, CLAIM_RECEIVABLES_TRX_ID CLAIM_RECEIVABLES_TRX_ID
, OLD_BANK_ACCOUNT_ID OLD_BANK_ACCOUNT_ID
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "AR"."AR_RECEIPT_METHOD_ACCOUNTS_ALL"