VIEW: AR.AR_PAYMENT_SCHEDULES_ALL#

Source

View Text - Preformatted

select PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID, STAGED_DUNNING_LEVEL STAGED_DUNNING_LEVEL, DUNNING_LEVEL_OVERRIDE_DATE DUNNING_LEVEL_OVERRIDE_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DUE_DATE DUE_DATE, AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL, AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING, NUMBER_OF_DUE_DATES NUMBER_OF_DUE_DATES, STATUS STATUS, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE, CLASS CLASS, CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID, CUSTOMER_TRX_ID CUSTOMER_TRX_ID, CASH_RECEIPT_ID CASH_RECEIPT_ID, ASSOCIATED_CASH_RECEIPT_ID ASSOCIATED_CASH_RECEIPT_ID, TERM_ID TERM_ID, TERMS_SEQUENCE_NUMBER TERMS_SEQUENCE_NUMBER, GL_DATE_CLOSED GL_DATE_CLOSED, ACTUAL_DATE_CLOSED ACTUAL_DATE_CLOSED, DISCOUNT_DATE DISCOUNT_DATE, AMOUNT_LINE_ITEMS_ORIGINAL AMOUNT_LINE_ITEMS_ORIGINAL, AMOUNT_LINE_ITEMS_REMAINING AMOUNT_LINE_ITEMS_REMAINING, AMOUNT_APPLIED AMOUNT_APPLIED, AMOUNT_ADJUSTED AMOUNT_ADJUSTED, AMOUNT_IN_DISPUTE AMOUNT_IN_DISPUTE, AMOUNT_CREDITED AMOUNT_CREDITED, RECEIVABLES_CHARGES_CHARGED RECEIVABLES_CHARGES_CHARGED, RECEIVABLES_CHARGES_REMAINING RECEIVABLES_CHARGES_REMAINING, FREIGHT_ORIGINAL FREIGHT_ORIGINAL, FREIGHT_REMAINING FREIGHT_REMAINING, TAX_ORIGINAL TAX_ORIGINAL, TAX_REMAINING TAX_REMAINING, DISCOUNT_ORIGINAL DISCOUNT_ORIGINAL, DISCOUNT_REMAINING DISCOUNT_REMAINING, DISCOUNT_TAKEN_EARNED DISCOUNT_TAKEN_EARNED, DISCOUNT_TAKEN_UNEARNED DISCOUNT_TAKEN_UNEARNED, IN_COLLECTION IN_COLLECTION, CASH_APPLIED_ID_LAST CASH_APPLIED_ID_LAST, CASH_APPLIED_DATE_LAST CASH_APPLIED_DATE_LAST, CASH_APPLIED_AMOUNT_LAST CASH_APPLIED_AMOUNT_LAST, CASH_APPLIED_STATUS_LAST CASH_APPLIED_STATUS_LAST, CASH_GL_DATE_LAST CASH_GL_DATE_LAST, CASH_RECEIPT_ID_LAST CASH_RECEIPT_ID_LAST, CASH_RECEIPT_DATE_LAST CASH_RECEIPT_DATE_LAST, CASH_RECEIPT_AMOUNT_LAST CASH_RECEIPT_AMOUNT_LAST, CASH_RECEIPT_STATUS_LAST CASH_RECEIPT_STATUS_LAST, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, EXCHANGE_DATE EXCHANGE_DATE, EXCHANGE_RATE EXCHANGE_RATE, ADJUSTMENT_ID_LAST ADJUSTMENT_ID_LAST, ADJUSTMENT_DATE_LAST ADJUSTMENT_DATE_LAST, ADJUSTMENT_GL_DATE_LAST ADJUSTMENT_GL_DATE_LAST, ADJUSTMENT_AMOUNT_LAST ADJUSTMENT_AMOUNT_LAST, FOLLOW_UP_DATE_LAST FOLLOW_UP_DATE_LAST, FOLLOW_UP_CODE_LAST FOLLOW_UP_CODE_LAST, PROMISE_DATE_LAST PROMISE_DATE_LAST, PROMISE_AMOUNT_LAST PROMISE_AMOUNT_LAST, COLLECTOR_LAST COLLECTOR_LAST, CALL_DATE_LAST CALL_DATE_LAST, TRX_NUMBER TRX_NUMBER, TRX_DATE TRX_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, REVERSED_CASH_RECEIPT_ID REVERSED_CASH_RECEIPT_ID, AMOUNT_ADJUSTED_PENDING AMOUNT_ADJUSTED_PENDING, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, GL_DATE GL_DATE, ACCTD_AMOUNT_DUE_REMAINING ACCTD_AMOUNT_DUE_REMAINING, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, RECEIPT_CONFIRMED_FLAG RECEIPT_CONFIRMED_FLAG, REQUEST_ID REQUEST_ID, SELECTED_FOR_RECEIPT_BATCH_ID SELECTED_FOR_RECEIPT_BATCH_ID, LAST_CHARGE_DATE LAST_CHARGE_DATE, SECOND_LAST_CHARGE_DATE SECOND_LAST_CHARGE_DATE, DISPUTE_DATE DISPUTE_DATE, 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, CONS_INV_ID CONS_INV_ID, CONS_INV_ID_REV CONS_INV_ID_REV, EXCLUDE_FROM_DUNNING_FLAG EXCLUDE_FROM_DUNNING_FLAG, MRC_CUSTOMER_TRX_ID MRC_CUSTOMER_TRX_ID, MRC_EXCHANGE_RATE_TYPE MRC_EXCHANGE_RATE_TYPE, MRC_EXCHANGE_DATE MRC_EXCHANGE_DATE, MRC_EXCHANGE_RATE MRC_EXCHANGE_RATE, MRC_ACCTD_AMOUNT_DUE_REMAINING MRC_ACCTD_AMOUNT_DUE_REMAINING, BR_AMOUNT_ASSIGNED BR_AMOUNT_ASSIGNED, RESERVED_TYPE RESERVED_TYPE, RESERVED_VALUE RESERVED_VALUE, ACTIVE_CLAIM_FLAG ACTIVE_CLAIM_FLAG, EXCLUDE_FROM_CONS_BILL_FLAG EXCLUDE_FROM_CONS_BILL_FLAG, PAYMENT_APPROVAL PAYMENT_APPROVAL, ZD_EDITION_NAME ZD_EDITION_NAME from "AR"."AR_PAYMENT_SCHEDULES_ALL"

View Text - HTML Formatted

SELECT PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, STAGED_DUNNING_LEVEL STAGED_DUNNING_LEVEL
, DUNNING_LEVEL_OVERRIDE_DATE DUNNING_LEVEL_OVERRIDE_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DUE_DATE DUE_DATE
, AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL
, AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING
, NUMBER_OF_DUE_DATES NUMBER_OF_DUE_DATES
, STATUS STATUS
, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, CLASS CLASS
, CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, CASH_RECEIPT_ID CASH_RECEIPT_ID
, ASSOCIATED_CASH_RECEIPT_ID ASSOCIATED_CASH_RECEIPT_ID
, TERM_ID TERM_ID
, TERMS_SEQUENCE_NUMBER TERMS_SEQUENCE_NUMBER
, GL_DATE_CLOSED GL_DATE_CLOSED
, ACTUAL_DATE_CLOSED ACTUAL_DATE_CLOSED
, DISCOUNT_DATE DISCOUNT_DATE
, AMOUNT_LINE_ITEMS_ORIGINAL AMOUNT_LINE_ITEMS_ORIGINAL
, AMOUNT_LINE_ITEMS_REMAINING AMOUNT_LINE_ITEMS_REMAINING
, AMOUNT_APPLIED AMOUNT_APPLIED
, AMOUNT_ADJUSTED AMOUNT_ADJUSTED
, AMOUNT_IN_DISPUTE AMOUNT_IN_DISPUTE
, AMOUNT_CREDITED AMOUNT_CREDITED
, RECEIVABLES_CHARGES_CHARGED RECEIVABLES_CHARGES_CHARGED
, RECEIVABLES_CHARGES_REMAINING RECEIVABLES_CHARGES_REMAINING
, FREIGHT_ORIGINAL FREIGHT_ORIGINAL
, FREIGHT_REMAINING FREIGHT_REMAINING
, TAX_ORIGINAL TAX_ORIGINAL
, TAX_REMAINING TAX_REMAINING
, DISCOUNT_ORIGINAL DISCOUNT_ORIGINAL
, DISCOUNT_REMAINING DISCOUNT_REMAINING
, DISCOUNT_TAKEN_EARNED DISCOUNT_TAKEN_EARNED
, DISCOUNT_TAKEN_UNEARNED DISCOUNT_TAKEN_UNEARNED
, IN_COLLECTION IN_COLLECTION
, CASH_APPLIED_ID_LAST CASH_APPLIED_ID_LAST
, CASH_APPLIED_DATE_LAST CASH_APPLIED_DATE_LAST
, CASH_APPLIED_AMOUNT_LAST CASH_APPLIED_AMOUNT_LAST
, CASH_APPLIED_STATUS_LAST CASH_APPLIED_STATUS_LAST
, CASH_GL_DATE_LAST CASH_GL_DATE_LAST
, CASH_RECEIPT_ID_LAST CASH_RECEIPT_ID_LAST
, CASH_RECEIPT_DATE_LAST CASH_RECEIPT_DATE_LAST
, CASH_RECEIPT_AMOUNT_LAST CASH_RECEIPT_AMOUNT_LAST
, CASH_RECEIPT_STATUS_LAST CASH_RECEIPT_STATUS_LAST
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, EXCHANGE_DATE EXCHANGE_DATE
, EXCHANGE_RATE EXCHANGE_RATE
, ADJUSTMENT_ID_LAST ADJUSTMENT_ID_LAST
, ADJUSTMENT_DATE_LAST ADJUSTMENT_DATE_LAST
, ADJUSTMENT_GL_DATE_LAST ADJUSTMENT_GL_DATE_LAST
, ADJUSTMENT_AMOUNT_LAST ADJUSTMENT_AMOUNT_LAST
, FOLLOW_UP_DATE_LAST FOLLOW_UP_DATE_LAST
, FOLLOW_UP_CODE_LAST FOLLOW_UP_CODE_LAST
, PROMISE_DATE_LAST PROMISE_DATE_LAST
, PROMISE_AMOUNT_LAST PROMISE_AMOUNT_LAST
, COLLECTOR_LAST COLLECTOR_LAST
, CALL_DATE_LAST CALL_DATE_LAST
, TRX_NUMBER TRX_NUMBER
, TRX_DATE TRX_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, REVERSED_CASH_RECEIPT_ID REVERSED_CASH_RECEIPT_ID
, AMOUNT_ADJUSTED_PENDING AMOUNT_ADJUSTED_PENDING
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, GL_DATE GL_DATE
, ACCTD_AMOUNT_DUE_REMAINING ACCTD_AMOUNT_DUE_REMAINING
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, RECEIPT_CONFIRMED_FLAG RECEIPT_CONFIRMED_FLAG
, REQUEST_ID REQUEST_ID
, SELECTED_FOR_RECEIPT_BATCH_ID SELECTED_FOR_RECEIPT_BATCH_ID
, LAST_CHARGE_DATE LAST_CHARGE_DATE
, SECOND_LAST_CHARGE_DATE SECOND_LAST_CHARGE_DATE
, DISPUTE_DATE DISPUTE_DATE
, 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
, CONS_INV_ID CONS_INV_ID
, CONS_INV_ID_REV CONS_INV_ID_REV
, EXCLUDE_FROM_DUNNING_FLAG EXCLUDE_FROM_DUNNING_FLAG
, MRC_CUSTOMER_TRX_ID MRC_CUSTOMER_TRX_ID
, MRC_EXCHANGE_RATE_TYPE MRC_EXCHANGE_RATE_TYPE
, MRC_EXCHANGE_DATE MRC_EXCHANGE_DATE
, MRC_EXCHANGE_RATE MRC_EXCHANGE_RATE
, MRC_ACCTD_AMOUNT_DUE_REMAINING MRC_ACCTD_AMOUNT_DUE_REMAINING
, BR_AMOUNT_ASSIGNED BR_AMOUNT_ASSIGNED
, RESERVED_TYPE RESERVED_TYPE
, RESERVED_VALUE RESERVED_VALUE
, ACTIVE_CLAIM_FLAG ACTIVE_CLAIM_FLAG
, EXCLUDE_FROM_CONS_BILL_FLAG EXCLUDE_FROM_CONS_BILL_FLAG
, PAYMENT_APPROVAL PAYMENT_APPROVAL
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "AR"."AR_PAYMENT_SCHEDULES_ALL"