VIEW: JL.JL_BR_AR_PAY_SCHED_AUX#

Source

View Text - Preformatted

select PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID, AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING, DUE_DATE DUE_DATE, SELECT_ACCOUNT_ID SELECT_ACCOUNT_ID, CUSTOMER_NUMBER CUSTOMER_NUMBER, BANK_INSTRUCTION_CODE1 BANK_INSTRUCTION_CODE1, BANK_INSTRUCTION_CODE2 BANK_INSTRUCTION_CODE2, BANK_NUMBER BANK_NUMBER, BANK_ACCOUNT_ID BANK_ACCOUNT_ID, BRANCH_NUMBER BRANCH_NUMBER, PORTFOLIO_CODE PORTFOLIO_CODE, BATCH_SOURCE_ID BATCH_SOURCE_ID, RECEIPT_METHOD_ID RECEIPT_METHOD_ID, CUSTOMER_TRX_TYPE_ID CUSTOMER_TRX_TYPE_ID, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM, CUSTOMER_TRX_ID CUSTOMER_TRX_ID, TERMS_SEQUENCE_NUMBER TERMS_SEQUENCE_NUMBER, CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID, BANK_CHARGE_AMOUNT BANK_CHARGE_AMOUNT, BANK_PARTY_ID BANK_PARTY_ID, BRANCH_PARTY_ID BRANCH_PARTY_ID, BANK_ACCT_USE_ID BANK_ACCT_USE_ID from "JL"."JL_BR_AR_PAY_SCHED_AUX"

View Text - HTML Formatted

SELECT PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING
, DUE_DATE DUE_DATE
, SELECT_ACCOUNT_ID SELECT_ACCOUNT_ID
, CUSTOMER_NUMBER CUSTOMER_NUMBER
, BANK_INSTRUCTION_CODE1 BANK_INSTRUCTION_CODE1
, BANK_INSTRUCTION_CODE2 BANK_INSTRUCTION_CODE2
, BANK_NUMBER BANK_NUMBER
, BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, BRANCH_NUMBER BRANCH_NUMBER
, PORTFOLIO_CODE PORTFOLIO_CODE
, BATCH_SOURCE_ID BATCH_SOURCE_ID
, RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, CUSTOMER_TRX_TYPE_ID CUSTOMER_TRX_TYPE_ID
, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, TERMS_SEQUENCE_NUMBER TERMS_SEQUENCE_NUMBER
, CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, BANK_CHARGE_AMOUNT BANK_CHARGE_AMOUNT
, BANK_PARTY_ID BANK_PARTY_ID
, BRANCH_PARTY_ID BRANCH_PARTY_ID
, BANK_ACCT_USE_ID BANK_ACCT_USE_ID
FROM "JL"."JL_BR_AR_PAY_SCHED_AUX"