VIEW: AR.AR_RECEIVABLE_APPLICATIONS_AL#

Source

View Text - Preformatted

select RECEIVABLE_APPLICATION_ID RECEIVABLE_APPLICATION_ID, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, AMOUNT_APPLIED AMOUNT_APPLIED, AMOUNT_APPLIED_FROM AMOUNT_APPLIED_FROM, TRANS_TO_RECEIPT_RATE TRANS_TO_RECEIPT_RATE, GL_DATE GL_DATE, CODE_COMBINATION_ID CODE_COMBINATION_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, DISPLAY DISPLAY, APPLY_DATE APPLY_DATE, APPLICATION_TYPE APPLICATION_TYPE, STATUS STATUS, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CASH_RECEIPT_ID CASH_RECEIPT_ID, APPLIED_CUSTOMER_TRX_ID APPLIED_CUSTOMER_TRX_ID, APPLIED_CUSTOMER_TRX_LINE_ID APPLIED_CUSTOMER_TRX_LINE_ID, APPLIED_PAYMENT_SCHEDULE_ID APPLIED_PAYMENT_SCHEDULE_ID, CUSTOMER_TRX_ID CUSTOMER_TRX_ID, LINE_APPLIED LINE_APPLIED, TAX_APPLIED TAX_APPLIED, FREIGHT_APPLIED FREIGHT_APPLIED, RECEIVABLES_CHARGES_APPLIED RECEIVABLES_CHARGES_APPLIED, EARNED_DISCOUNT_TAKEN EARNED_DISCOUNT_TAKEN, UNEARNED_DISCOUNT_TAKEN UNEARNED_DISCOUNT_TAKEN, DAYS_LATE DAYS_LATE, APPLICATION_RULE APPLICATION_RULE, GL_POSTED_DATE GL_POSTED_DATE, COMMENTS COMMENTS, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, POSTABLE POSTABLE, POSTING_CONTROL_ID POSTING_CONTROL_ID, ACCTD_AMOUNT_APPLIED_FROM ACCTD_AMOUNT_APPLIED_FROM, ACCTD_AMOUNT_APPLIED_TO ACCTD_AMOUNT_APPLIED_TO, ACCTD_EARNED_DISCOUNT_TAKEN ACCTD_EARNED_DISCOUNT_TAKEN, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CONFIRMED_FLAG CONFIRMED_FLAG, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, USSGL_TRANSACTION_CODE_CONTEXT USSGL_TRANSACTION_CODE_CONTEXT, EARNED_DISCOUNT_CCID EARNED_DISCOUNT_CCID, UNEARNED_DISCOUNT_CCID UNEARNED_DISCOUNT_CCID, ACCTD_UNEARNED_DISCOUNT_TAKEN ACCTD_UNEARNED_DISCOUNT_TAKEN, REVERSAL_GL_DATE REVERSAL_GL_DATE, CASH_RECEIPT_HISTORY_ID CASH_RECEIPT_HISTORY_ID, ORG_ID ORG_ID, TAX_CODE TAX_CODE, 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, CONS_INV_ID CONS_INV_ID, CONS_INV_ID_TO CONS_INV_ID_TO, RULE_SET_ID RULE_SET_ID, LINE_EDISCOUNTED LINE_EDISCOUNTED, TAX_EDISCOUNTED TAX_EDISCOUNTED, FREIGHT_EDISCOUNTED FREIGHT_EDISCOUNTED, CHARGES_EDISCOUNTED CHARGES_EDISCOUNTED, LINE_UEDISCOUNTED LINE_UEDISCOUNTED, TAX_UEDISCOUNTED TAX_UEDISCOUNTED, FREIGHT_UEDISCOUNTED FREIGHT_UEDISCOUNTED, CHARGES_UEDISCOUNTED CHARGES_UEDISCOUNTED, RECEIVABLES_TRX_ID RECEIVABLES_TRX_ID, ON_ACCOUNT_CUSTOMER ON_ACCOUNT_CUSTOMER, MRC_AMOUNT_APPLIED MRC_AMOUNT_APPLIED, MRC_AMOUNT_APPLIED_FROM MRC_AMOUNT_APPLIED_FROM, MRC_DISPLAY MRC_DISPLAY, MRC_STATUS MRC_STATUS, MRC_PAYMENT_SCHEDULE_ID MRC_PAYMENT_SCHEDULE_ID, MRC_CASH_RECEIPT_ID MRC_CASH_RECEIPT_ID, MRC_GL_POSTED_DATE MRC_GL_POSTED_DATE, MRC_POSTING_CONTROL_ID MRC_POSTING_CONTROL_ID, MRC_ACCTD_AMOUNT_APPLIED_FROM MRC_ACCTD_AMOUNT_APPLIED_FROM, MRC_ACCTD_AMOUNT_APPLIED_TO MRC_ACCTD_AMOUNT_APPLIED_TO, MRC_ACCTD_EARNED_DISC_TAKEN MRC_ACCTD_EARNED_DISC_TAKEN, MRC_ACCTD_UNEARNED_DISC_TAKEN MRC_ACCTD_UNEARNED_DISC_TAKEN, EDISC_TAX_ACCT_RULE EDISC_TAX_ACCT_RULE, UNEDISC_TAX_ACCT_RULE UNEDISC_TAX_ACCT_RULE, LINK_TO_TRX_HIST_ID LINK_TO_TRX_HIST_ID, LINK_TO_CUSTOMER_TRX_ID LINK_TO_CUSTOMER_TRX_ID, APPLICATION_REF_TYPE APPLICATION_REF_TYPE, APPLICATION_REF_ID APPLICATION_REF_ID, APPLICATION_REF_NUM APPLICATION_REF_NUM, CHARGEBACK_CUSTOMER_TRX_ID CHARGEBACK_CUSTOMER_TRX_ID, SECONDARY_APPLICATION_REF_ID SECONDARY_APPLICATION_REF_ID, PAYMENT_SET_ID PAYMENT_SET_ID, APPLICATION_REF_REASON APPLICATION_REF_REASON, CUSTOMER_REFERENCE CUSTOMER_REFERENCE, CUSTOMER_REASON CUSTOMER_REASON, APPLIED_REC_APP_ID APPLIED_REC_APP_ID, SECONDARY_APPLICATION_REF_TYPE SECONDARY_APPLICATION_REF_TYPE, SECONDARY_APPLICATION_REF_NUM SECONDARY_APPLICATION_REF_NUM, EVENT_ID EVENT_ID, UPGRADE_METHOD UPGRADE_METHOD, AX_ACCOUNTED_FLAG AX_ACCOUNTED_FLAG, INCLUDE_IN_ACCUMULATION INCLUDE_IN_ACCUMULATION, ON_ACCT_CUST_ID ON_ACCT_CUST_ID, ON_ACCT_CUST_SITE_USE_ID ON_ACCT_CUST_SITE_USE_ID, ON_ACCT_PO_NUM ON_ACCT_PO_NUM from "AR"."AR_RECEIVABLE_APPLICATIONS_ALL"

View Text - HTML Formatted

SELECT RECEIVABLE_APPLICATION_ID RECEIVABLE_APPLICATION_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, AMOUNT_APPLIED AMOUNT_APPLIED
, AMOUNT_APPLIED_FROM AMOUNT_APPLIED_FROM
, TRANS_TO_RECEIPT_RATE TRANS_TO_RECEIPT_RATE
, GL_DATE GL_DATE
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, DISPLAY DISPLAY
, APPLY_DATE APPLY_DATE
, APPLICATION_TYPE APPLICATION_TYPE
, STATUS STATUS
, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CASH_RECEIPT_ID CASH_RECEIPT_ID
, APPLIED_CUSTOMER_TRX_ID APPLIED_CUSTOMER_TRX_ID
, APPLIED_CUSTOMER_TRX_LINE_ID APPLIED_CUSTOMER_TRX_LINE_ID
, APPLIED_PAYMENT_SCHEDULE_ID APPLIED_PAYMENT_SCHEDULE_ID
, CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, LINE_APPLIED LINE_APPLIED
, TAX_APPLIED TAX_APPLIED
, FREIGHT_APPLIED FREIGHT_APPLIED
, RECEIVABLES_CHARGES_APPLIED RECEIVABLES_CHARGES_APPLIED
, EARNED_DISCOUNT_TAKEN EARNED_DISCOUNT_TAKEN
, UNEARNED_DISCOUNT_TAKEN UNEARNED_DISCOUNT_TAKEN
, DAYS_LATE DAYS_LATE
, APPLICATION_RULE APPLICATION_RULE
, GL_POSTED_DATE GL_POSTED_DATE
, COMMENTS COMMENTS
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, POSTABLE POSTABLE
, POSTING_CONTROL_ID POSTING_CONTROL_ID
, ACCTD_AMOUNT_APPLIED_FROM ACCTD_AMOUNT_APPLIED_FROM
, ACCTD_AMOUNT_APPLIED_TO ACCTD_AMOUNT_APPLIED_TO
, ACCTD_EARNED_DISCOUNT_TAKEN ACCTD_EARNED_DISCOUNT_TAKEN
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CONFIRMED_FLAG CONFIRMED_FLAG
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, USSGL_TRANSACTION_CODE_CONTEXT USSGL_TRANSACTION_CODE_CONTEXT
, EARNED_DISCOUNT_CCID EARNED_DISCOUNT_CCID
, UNEARNED_DISCOUNT_CCID UNEARNED_DISCOUNT_CCID
, ACCTD_UNEARNED_DISCOUNT_TAKEN ACCTD_UNEARNED_DISCOUNT_TAKEN
, REVERSAL_GL_DATE REVERSAL_GL_DATE
, CASH_RECEIPT_HISTORY_ID CASH_RECEIPT_HISTORY_ID
, ORG_ID ORG_ID
, TAX_CODE TAX_CODE
, 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
, CONS_INV_ID CONS_INV_ID
, CONS_INV_ID_TO CONS_INV_ID_TO
, RULE_SET_ID RULE_SET_ID
, LINE_EDISCOUNTED LINE_EDISCOUNTED
, TAX_EDISCOUNTED TAX_EDISCOUNTED
, FREIGHT_EDISCOUNTED FREIGHT_EDISCOUNTED
, CHARGES_EDISCOUNTED CHARGES_EDISCOUNTED
, LINE_UEDISCOUNTED LINE_UEDISCOUNTED
, TAX_UEDISCOUNTED TAX_UEDISCOUNTED
, FREIGHT_UEDISCOUNTED FREIGHT_UEDISCOUNTED
, CHARGES_UEDISCOUNTED CHARGES_UEDISCOUNTED
, RECEIVABLES_TRX_ID RECEIVABLES_TRX_ID
, ON_ACCOUNT_CUSTOMER ON_ACCOUNT_CUSTOMER
, MRC_AMOUNT_APPLIED MRC_AMOUNT_APPLIED
, MRC_AMOUNT_APPLIED_FROM MRC_AMOUNT_APPLIED_FROM
, MRC_DISPLAY MRC_DISPLAY
, MRC_STATUS MRC_STATUS
, MRC_PAYMENT_SCHEDULE_ID MRC_PAYMENT_SCHEDULE_ID
, MRC_CASH_RECEIPT_ID MRC_CASH_RECEIPT_ID
, MRC_GL_POSTED_DATE MRC_GL_POSTED_DATE
, MRC_POSTING_CONTROL_ID MRC_POSTING_CONTROL_ID
, MRC_ACCTD_AMOUNT_APPLIED_FROM MRC_ACCTD_AMOUNT_APPLIED_FROM
, MRC_ACCTD_AMOUNT_APPLIED_TO MRC_ACCTD_AMOUNT_APPLIED_TO
, MRC_ACCTD_EARNED_DISC_TAKEN MRC_ACCTD_EARNED_DISC_TAKEN
, MRC_ACCTD_UNEARNED_DISC_TAKEN MRC_ACCTD_UNEARNED_DISC_TAKEN
, EDISC_TAX_ACCT_RULE EDISC_TAX_ACCT_RULE
, UNEDISC_TAX_ACCT_RULE UNEDISC_TAX_ACCT_RULE
, LINK_TO_TRX_HIST_ID LINK_TO_TRX_HIST_ID
, LINK_TO_CUSTOMER_TRX_ID LINK_TO_CUSTOMER_TRX_ID
, APPLICATION_REF_TYPE APPLICATION_REF_TYPE
, APPLICATION_REF_ID APPLICATION_REF_ID
, APPLICATION_REF_NUM APPLICATION_REF_NUM
, CHARGEBACK_CUSTOMER_TRX_ID CHARGEBACK_CUSTOMER_TRX_ID
, SECONDARY_APPLICATION_REF_ID SECONDARY_APPLICATION_REF_ID
, PAYMENT_SET_ID PAYMENT_SET_ID
, APPLICATION_REF_REASON APPLICATION_REF_REASON
, CUSTOMER_REFERENCE CUSTOMER_REFERENCE
, CUSTOMER_REASON CUSTOMER_REASON
, APPLIED_REC_APP_ID APPLIED_REC_APP_ID
, SECONDARY_APPLICATION_REF_TYPE SECONDARY_APPLICATION_REF_TYPE
, SECONDARY_APPLICATION_REF_NUM SECONDARY_APPLICATION_REF_NUM
, EVENT_ID EVENT_ID
, UPGRADE_METHOD UPGRADE_METHOD
, AX_ACCOUNTED_FLAG AX_ACCOUNTED_FLAG
, INCLUDE_IN_ACCUMULATION INCLUDE_IN_ACCUMULATION
, ON_ACCT_CUST_ID ON_ACCT_CUST_ID
, ON_ACCT_CUST_SITE_USE_ID ON_ACCT_CUST_SITE_USE_ID
, ON_ACCT_PO_NUM ON_ACCT_PO_NUM
FROM "AR"."AR_RECEIVABLE_APPLICATIONS_ALL"