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.

VIEW: IBY.IBY_PAYMENTS_ALL#

Source

View Text - Preformatted


select PAYMENT_ID PAYMENT_ID, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE, PAYMENT_SERVICE_REQUEST_ID PAYMENT_SERVICE_REQUEST_ID, PROCESS_TYPE PROCESS_TYPE, PAYMENT_STATUS PAYMENT_STATUS, PAYMENTS_COMPLETE_FLAG PAYMENTS_COMPLETE_FLAG, PAYMENT_FUNCTION PAYMENT_FUNCTION, PAYMENT_AMOUNT PAYMENT_AMOUNT, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE, BILL_PAYABLE_FLAG BILL_PAYABLE_FLAG, EXCLUSIVE_PAYMENT_FLAG EXCLUSIVE_PAYMENT_FLAG, SEPARATE_REMIT_ADVICE_REQ_FLAG SEPARATE_REMIT_ADVICE_REQ_FLAG, INTERNAL_BANK_ACCOUNT_ID INTERNAL_BANK_ACCOUNT_ID, ORG_ID ORG_ID, ORG_TYPE ORG_TYPE, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, DECLARE_PAYMENT_FLAG DECLARE_PAYMENT_FLAG, DELIVERY_CHANNEL_CODE DELIVERY_CHANNEL_CODE, EXT_PAYEE_ID EXT_PAYEE_ID, PAYMENT_INSTRUCTION_ID PAYMENT_INSTRUCTION_ID, PAYMENT_PROFILE_ID PAYMENT_PROFILE_ID, PREGROUPED_PAYMENT_FLAG PREGROUPED_PAYMENT_FLAG, STOP_CONFIRMED_FLAG STOP_CONFIRMED_FLAG, STOP_RELEASED_FLAG STOP_RELEASED_FLAG, STOP_REQUEST_PLACED_FLAG STOP_REQUEST_PLACED_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PAYEE_PARTY_ID PAYEE_PARTY_ID, PARTY_SITE_ID PARTY_SITE_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, PAYMENT_REASON_CODE PAYMENT_REASON_CODE, PAYMENT_REASON_COMMENTS PAYMENT_REASON_COMMENTS, PAYMENT_DATE PAYMENT_DATE, ANTICIPATED_VALUE_DATE ANTICIPATED_VALUE_DATE, DECLARATION_AMOUNT DECLARATION_AMOUNT, DECLARATION_CURRENCY_CODE DECLARATION_CURRENCY_CODE, DISCOUNT_AMOUNT_TAKEN DISCOUNT_AMOUNT_TAKEN, PAYMENT_DETAILS PAYMENT_DETAILS, BANK_CHARGE_BEARER BANK_CHARGE_BEARER, BANK_CHARGE_AMOUNT BANK_CHARGE_AMOUNT, SETTLEMENT_PRIORITY SETTLEMENT_PRIORITY, REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE1, REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE2, REMITTANCE_MESSAGE3 REMITTANCE_MESSAGE3, PAYMENT_REFERENCE_NUMBER PAYMENT_REFERENCE_NUMBER, PAPER_DOCUMENT_NUMBER PAPER_DOCUMENT_NUMBER, BANK_ASSIGNED_REF_CODE BANK_ASSIGNED_REF_CODE, EXTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID, UNIQUE_REMITTANCE_IDENTIFIER UNIQUE_REMITTANCE_IDENTIFIER, URI_CHECK_DIGIT URI_CHECK_DIGIT, BANK_INSTRUCTION1_CODE BANK_INSTRUCTION1_CODE, BANK_INSTRUCTION2_CODE BANK_INSTRUCTION2_CODE, BANK_INSTRUCTION_DETAILS BANK_INSTRUCTION_DETAILS, PAYMENT_TEXT_MESSAGE1 PAYMENT_TEXT_MESSAGE1, PAYMENT_TEXT_MESSAGE2 PAYMENT_TEXT_MESSAGE2, PAYMENT_TEXT_MESSAGE3 PAYMENT_TEXT_MESSAGE3, MATURITY_DATE MATURITY_DATE, PAYMENT_DUE_DATE PAYMENT_DUE_DATE, DOCUMENT_CATEGORY_CODE DOCUMENT_CATEGORY_CODE, DOCUMENT_SEQUENCE_ID DOCUMENT_SEQUENCE_ID, DOCUMENT_SEQUENCE_VALUE DOCUMENT_SEQUENCE_VALUE, BENEFICIARY_PARTY BENEFICIARY_PARTY, STOP_CONFIRMED_BY STOP_CONFIRMED_BY, STOP_CONFIRM_DATE STOP_CONFIRM_DATE, STOP_CONFIRM_REASON STOP_CONFIRM_REASON, STOP_CONFIRM_REFERENCE STOP_CONFIRM_REFERENCE, STOP_RELEASED_BY STOP_RELEASED_BY, STOP_RELEASE_DATE STOP_RELEASE_DATE, STOP_RELEASE_REASON STOP_RELEASE_REASON, STOP_RELEASE_REFERENCE STOP_RELEASE_REFERENCE, STOP_REQUEST_DATE STOP_REQUEST_DATE, STOP_REQUEST_PLACED_BY STOP_REQUEST_PLACED_BY, STOP_REQUEST_REASON STOP_REQUEST_REASON, STOP_REQUEST_REFERENCE STOP_REQUEST_REFERENCE, VOIDED_BY VOIDED_BY, VOID_DATE VOID_DATE, VOID_REASON VOID_REASON, REMIT_TO_LOCATION_ID REMIT_TO_LOCATION_ID, COMPLETED_PMTS_GROUP_ID COMPLETED_PMTS_GROUP_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, EXT_BRANCH_NUMBER EXT_BRANCH_NUMBER, EXT_BANK_NUMBER EXT_BANK_NUMBER, EXT_BANK_ACCOUNT_NAME EXT_BANK_ACCOUNT_NAME, EXT_BANK_ACCOUNT_NUMBER EXT_BANK_ACCOUNT_NUMBER, EXT_BANK_ACCOUNT_TYPE EXT_BANK_ACCOUNT_TYPE, EXT_BANK_ACCOUNT_IBAN_NUMBER EXT_BANK_ACCOUNT_IBAN_NUMBER, PAYEE_NAME PAYEE_NAME, PAYEE_ADDRESS1 PAYEE_ADDRESS1, PAYEE_ADDRESS2 PAYEE_ADDRESS2, PAYEE_ADDRESS3 PAYEE_ADDRESS3, PAYEE_ADDRESS4 PAYEE_ADDRESS4, PAYEE_CITY PAYEE_CITY, PAYEE_POSTAL_CODE PAYEE_POSTAL_CODE, PAYEE_STATE PAYEE_STATE, PAYEE_PROVINCE PAYEE_PROVINCE, PAYEE_COUNTY PAYEE_COUNTY, PAYEE_COUNTRY PAYEE_COUNTRY, REMIT_ADVICE_DELIVERY_METHOD REMIT_ADVICE_DELIVERY_METHOD, REMIT_ADVICE_EMAIL REMIT_ADVICE_EMAIL, REMIT_ADVICE_FAX REMIT_ADVICE_FAX, PAYMENT_PROFILE_SYS_NAME PAYMENT_PROFILE_SYS_NAME, PAYMENT_PROFILE_ACCT_NAME PAYMENT_PROFILE_ACCT_NAME, PAYMENT_PROCESS_REQUEST_NAME PAYMENT_PROCESS_REQUEST_NAME, SOURCE_PRODUCT SOURCE_PRODUCT, PAYMENT_REASON_FORMAT_VALUE PAYMENT_REASON_FORMAT_VALUE, DECLARATION_EXCH_RATE_TYPE DECLARATION_EXCH_RATE_TYPE, DECLARATION_FORMAT DECLARATION_FORMAT, DELIVERY_CHANNEL_FORMAT_VALUE DELIVERY_CHANNEL_FORMAT_VALUE, BANK_INSTRUCTION1_FORMAT_VALUE BANK_INSTRUCTION1_FORMAT_VALUE, BANK_INSTRUCTION2_FORMAT_VALUE BANK_INSTRUCTION2_FORMAT_VALUE, SRA_DELIVERY_METHOD SRA_DELIVERY_METHOD, INT_BANK_NAME INT_BANK_NAME, INT_BANK_NUMBER INT_BANK_NUMBER, INT_EFT_SWIFT_CODE INT_EFT_SWIFT_CODE, INT_BANK_BRANCH_NAME INT_BANK_BRANCH_NAME, INT_BANK_BRANCH_NUMBER INT_BANK_BRANCH_NUMBER, INT_BANK_ACCOUNT_NAME INT_BANK_ACCOUNT_NAME, INT_BANK_ACCOUNT_NUMBER INT_BANK_ACCOUNT_NUMBER, INT_BANK_ACCOUNT_IBAN INT_BANK_ACCOUNT_IBAN, EXT_BANK_NAME EXT_BANK_NAME, EXT_EFT_SWIFT_CODE EXT_EFT_SWIFT_CODE, EXT_BANK_BRANCH_NAME EXT_BANK_BRANCH_NAME, ORG_NAME ORG_NAME, PAYER_LEGAL_ENTITY_NAME PAYER_LEGAL_ENTITY_NAME, PAYER_LE_REGISTRATION_NUM PAYER_LE_REGISTRATION_NUM, PAYER_TAX_REGISTRATION_NUM PAYER_TAX_REGISTRATION_NUM, PAYEE_PARTY_NAME PAYEE_PARTY_NAME, PAYEE_LE_REGISTRATION_NUM PAYEE_LE_REGISTRATION_NUM, PAYEE_TAX_REGISTRATION_NUM PAYEE_TAX_REGISTRATION_NUM, PAYER_PARTY_SITE_NAME PAYER_PARTY_SITE_NAME, PAYEE_ADDRESS_CONCAT PAYEE_ADDRESS_CONCAT, BENEFICIARY_NAME BENEFICIARY_NAME, PAYER_PARTY_NUMBER PAYER_PARTY_NUMBER, PAYEE_PARTY_NUMBER PAYEE_PARTY_NUMBER, PAYEE_ALTERNATE_NAME PAYEE_ALTERNATE_NAME, PAYEE_SITE_ALTERNATE_NAME PAYEE_SITE_ALTERNATE_NAME, PAYEE_SUPPLIER_NUMBER PAYEE_SUPPLIER_NUMBER, PAYEE_FIRST_PARTY_REFERENCE PAYEE_FIRST_PARTY_REFERENCE, INT_BANK_BRANCH_RFC_IDENTIFIER INT_BANK_BRANCH_RFC_IDENTIFIER, INT_BANK_ACCT_AGENCY_LOC_CODE INT_BANK_ACCT_AGENCY_LOC_CODE, PAYER_ABBREVIATED_AGENCY_CODE PAYER_ABBREVIATED_AGENCY_CODE, PAYER_FEDERAL_US_EMPLOYER_ID PAYER_FEDERAL_US_EMPLOYER_ID, EXT_BANK_ACCT_OWNER_PARTY_ID EXT_BANK_ACCT_OWNER_PARTY_ID, EXT_BANK_ACCT_PMT_FACTOR_FLAG EXT_BANK_ACCT_PMT_FACTOR_FLAG, ADDRESS_SOURCE ADDRESS_SOURCE, EMPLOYEE_ADDRESS_CODE EMPLOYEE_ADDRESS_CODE, EMPLOYEE_PERSON_ID EMPLOYEE_PERSON_ID, EMPLOYEE_PAYMENT_FLAG EMPLOYEE_PAYMENT_FLAG, EMPLOYEE_ADDRESS_ID EMPLOYEE_ADDRESS_ID, REQUEST_ID REQUEST_ID, EXT_BANK_BRANCH_PARTY_ID EXT_BANK_BRANCH_PARTY_ID, EXT_BANK_ALT_NAME EXT_BANK_ALT_NAME, EXT_BANK_BRANCH_ALT_NAME EXT_BANK_BRANCH_ALT_NAME, EXT_BANK_ACCOUNT_ALT_NAME EXT_BANK_ACCOUNT_ALT_NAME, EXT_BANK_ACCOUNT_NUM_ELEC EXT_BANK_ACCOUNT_NUM_ELEC, EXT_BANK_BRANCH_LOCATION_ID EXT_BANK_BRANCH_LOCATION_ID, EXT_BANK_ACCT_OWNER_PARTY_NAME EXT_BANK_ACCT_OWNER_PARTY_NAME, INT_BANK_BRANCH_PARTY_ID INT_BANK_BRANCH_PARTY_ID, INT_BANK_ALT_NAME INT_BANK_ALT_NAME, INT_BANK_BRANCH_ALT_NAME INT_BANK_BRANCH_ALT_NAME, INT_BANK_ACCOUNT_ALT_NAME INT_BANK_ACCOUNT_ALT_NAME, INT_BANK_ACCOUNT_NUM_ELEC INT_BANK_ACCOUNT_NUM_ELEC, INT_BANK_BRANCH_LOCATION_ID INT_BANK_BRANCH_LOCATION_ID, INT_BANK_BRANCH_EFT_USER_NUM INT_BANK_BRANCH_EFT_USER_NUM, PAYER_PARTY_ID PAYER_PARTY_ID, PAYER_LOCATION_ID PAYER_LOCATION_ID, PAYER_PARTY_ATTR_CATEGORY PAYER_PARTY_ATTR_CATEGORY, PAYER_LE_ATTR_CATEGORY PAYER_LE_ATTR_CATEGORY, PAYEE_PARTY_ATTR_CATEGORY PAYEE_PARTY_ATTR_CATEGORY, PAYEE_SUPPLIER_ATTR_CATEGORY PAYEE_SUPPLIER_ATTR_CATEGORY, PAYEE_SPPLR_SITE_ATTR_CATEGORY PAYEE_SPPLR_SITE_ATTR_CATEGORY, PAYEE_SUPPLIER_SITE_NAME PAYEE_SUPPLIER_SITE_NAME, PAYEE_SUPPLIER_SITE_ALT_NAME PAYEE_SUPPLIER_SITE_ALT_NAME, PAYEE_SUPPLIER_ID PAYEE_SUPPLIER_ID, LOGICAL_GROUP_REFERENCE LOGICAL_GROUP_REFERENCE, POSITIVE_PAY_FILE_CREATED_FLAG POSITIVE_PAY_FILE_CREATED_FLAG, EXT_INV_PAYEE_ID EXT_INV_PAYEE_ID, INV_PAYEE_PARTY_ID INV_PAYEE_PARTY_ID, INV_PARTY_SITE_ID INV_PARTY_SITE_ID, INV_SUPPLIER_SITE_ID INV_SUPPLIER_SITE_ID, INV_BENEFICIARY_PARTY INV_BENEFICIARY_PARTY, INV_PAYEE_NAME INV_PAYEE_NAME, INV_PAYEE_ADDRESS1 INV_PAYEE_ADDRESS1, INV_PAYEE_ADDRESS2 INV_PAYEE_ADDRESS2, INV_PAYEE_ADDRESS3 INV_PAYEE_ADDRESS3, INV_PAYEE_ADDRESS4 INV_PAYEE_ADDRESS4, INV_PAYEE_CITY INV_PAYEE_CITY, INV_PAYEE_POSTAL_CODE INV_PAYEE_POSTAL_CODE, INV_PAYEE_STATE INV_PAYEE_STATE, INV_PAYEE_PROVINCE INV_PAYEE_PROVINCE, INV_PAYEE_COUNTY INV_PAYEE_COUNTY, INV_PAYEE_COUNTRY INV_PAYEE_COUNTRY, INV_PAYEE_PARTY_NAME INV_PAYEE_PARTY_NAME, INV_PAYEE_LE_REG_NUM INV_PAYEE_LE_REG_NUM, INV_PAYEE_TAX_REG_NUM INV_PAYEE_TAX_REG_NUM, INV_PAYEE_ADDRESS_CONCAT INV_PAYEE_ADDRESS_CONCAT, INV_BENEFICIARY_NAME INV_BENEFICIARY_NAME, INV_PAYEE_PARTY_NUMBER INV_PAYEE_PARTY_NUMBER, INV_PAYEE_ALTERNATE_NAME INV_PAYEE_ALTERNATE_NAME, INV_PAYEE_SITE_ALT_NAME INV_PAYEE_SITE_ALT_NAME, INV_PAYEE_SUPPLIER_NUMBER INV_PAYEE_SUPPLIER_NUMBER, INV_PAYEE_FIRST_PARTY_REF INV_PAYEE_FIRST_PARTY_REF, EXT_BNK_ACCT_OWNR_INV_PRTY_ID EXT_BNK_ACCT_OWNR_INV_PRTY_ID, EXT_BNK_BRANCH_INV_PRTY_ID EXT_BNK_BRANCH_INV_PRTY_ID, EXT_BNK_ACCT_OWNR_INV_PRTY_NME EXT_BNK_ACCT_OWNR_INV_PRTY_NME, INV_PAYEE_PARTY_ATTR_CAT INV_PAYEE_PARTY_ATTR_CAT, INV_PAYEE_SUPPLIER_ATTR_CAT INV_PAYEE_SUPPLIER_ATTR_CAT, INV_PAYEE_SPPLR_SITE_ATTR_CAT INV_PAYEE_SPPLR_SITE_ATTR_CAT, INV_PAYEE_SUPPLIER_SITE_NAME INV_PAYEE_SUPPLIER_SITE_NAME, INV_PAYEE_SPPLR_SITE_ALT_NAME INV_PAYEE_SPPLR_SITE_ALT_NAME, INV_PAYEE_SUPPLIER_ID INV_PAYEE_SUPPLIER_ID, PAYEE_ADDRESSEE PAYEE_ADDRESSEE, PAYEE_PARTY_SITE_NAME PAYEE_PARTY_SITE_NAME, INV_PAYEE_PARTY_SITE_NAME INV_PAYEE_PARTY_SITE_NAME, ACKNOWLEDGED_FLAG ACKNOWLEDGED_FLAG, AFFECTS_REJECTION_LEVEL AFFECTS_REJECTION_LEVEL from "IBY"."IBY_PAYMENTS_ALL"

View Text - HTML Formatted

SELECT PAYMENT_ID PAYMENT_ID
, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE
, PAYMENT_SERVICE_REQUEST_ID PAYMENT_SERVICE_REQUEST_ID
, PROCESS_TYPE PROCESS_TYPE
, PAYMENT_STATUS PAYMENT_STATUS
, PAYMENTS_COMPLETE_FLAG PAYMENTS_COMPLETE_FLAG
, PAYMENT_FUNCTION PAYMENT_FUNCTION
, PAYMENT_AMOUNT PAYMENT_AMOUNT
, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, BILL_PAYABLE_FLAG BILL_PAYABLE_FLAG
, EXCLUSIVE_PAYMENT_FLAG EXCLUSIVE_PAYMENT_FLAG
, SEPARATE_REMIT_ADVICE_REQ_FLAG SEPARATE_REMIT_ADVICE_REQ_FLAG
, INTERNAL_BANK_ACCOUNT_ID INTERNAL_BANK_ACCOUNT_ID
, ORG_ID ORG_ID
, ORG_TYPE ORG_TYPE
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, DECLARE_PAYMENT_FLAG DECLARE_PAYMENT_FLAG
, DELIVERY_CHANNEL_CODE DELIVERY_CHANNEL_CODE
, EXT_PAYEE_ID EXT_PAYEE_ID
, PAYMENT_INSTRUCTION_ID PAYMENT_INSTRUCTION_ID
, PAYMENT_PROFILE_ID PAYMENT_PROFILE_ID
, PREGROUPED_PAYMENT_FLAG PREGROUPED_PAYMENT_FLAG
, STOP_CONFIRMED_FLAG STOP_CONFIRMED_FLAG
, STOP_RELEASED_FLAG STOP_RELEASED_FLAG
, STOP_REQUEST_PLACED_FLAG STOP_REQUEST_PLACED_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PAYEE_PARTY_ID PAYEE_PARTY_ID
, PARTY_SITE_ID PARTY_SITE_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, PAYMENT_REASON_CODE PAYMENT_REASON_CODE
, PAYMENT_REASON_COMMENTS PAYMENT_REASON_COMMENTS
, PAYMENT_DATE PAYMENT_DATE
, ANTICIPATED_VALUE_DATE ANTICIPATED_VALUE_DATE
, DECLARATION_AMOUNT DECLARATION_AMOUNT
, DECLARATION_CURRENCY_CODE DECLARATION_CURRENCY_CODE
, DISCOUNT_AMOUNT_TAKEN DISCOUNT_AMOUNT_TAKEN
, PAYMENT_DETAILS PAYMENT_DETAILS
, BANK_CHARGE_BEARER BANK_CHARGE_BEARER
, BANK_CHARGE_AMOUNT BANK_CHARGE_AMOUNT
, SETTLEMENT_PRIORITY SETTLEMENT_PRIORITY
, REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE1
, REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE2
, REMITTANCE_MESSAGE3 REMITTANCE_MESSAGE3
, PAYMENT_REFERENCE_NUMBER PAYMENT_REFERENCE_NUMBER
, PAPER_DOCUMENT_NUMBER PAPER_DOCUMENT_NUMBER
, BANK_ASSIGNED_REF_CODE BANK_ASSIGNED_REF_CODE
, EXTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID
, UNIQUE_REMITTANCE_IDENTIFIER UNIQUE_REMITTANCE_IDENTIFIER
, URI_CHECK_DIGIT URI_CHECK_DIGIT
, BANK_INSTRUCTION1_CODE BANK_INSTRUCTION1_CODE
, BANK_INSTRUCTION2_CODE BANK_INSTRUCTION2_CODE
, BANK_INSTRUCTION_DETAILS BANK_INSTRUCTION_DETAILS
, PAYMENT_TEXT_MESSAGE1 PAYMENT_TEXT_MESSAGE1
, PAYMENT_TEXT_MESSAGE2 PAYMENT_TEXT_MESSAGE2
, PAYMENT_TEXT_MESSAGE3 PAYMENT_TEXT_MESSAGE3
, MATURITY_DATE MATURITY_DATE
, PAYMENT_DUE_DATE PAYMENT_DUE_DATE
, DOCUMENT_CATEGORY_CODE DOCUMENT_CATEGORY_CODE
, DOCUMENT_SEQUENCE_ID DOCUMENT_SEQUENCE_ID
, DOCUMENT_SEQUENCE_VALUE DOCUMENT_SEQUENCE_VALUE
, BENEFICIARY_PARTY BENEFICIARY_PARTY
, STOP_CONFIRMED_BY STOP_CONFIRMED_BY
, STOP_CONFIRM_DATE STOP_CONFIRM_DATE
, STOP_CONFIRM_REASON STOP_CONFIRM_REASON
, STOP_CONFIRM_REFERENCE STOP_CONFIRM_REFERENCE
, STOP_RELEASED_BY STOP_RELEASED_BY
, STOP_RELEASE_DATE STOP_RELEASE_DATE
, STOP_RELEASE_REASON STOP_RELEASE_REASON
, STOP_RELEASE_REFERENCE STOP_RELEASE_REFERENCE
, STOP_REQUEST_DATE STOP_REQUEST_DATE
, STOP_REQUEST_PLACED_BY STOP_REQUEST_PLACED_BY
, STOP_REQUEST_REASON STOP_REQUEST_REASON
, STOP_REQUEST_REFERENCE STOP_REQUEST_REFERENCE
, VOIDED_BY VOIDED_BY
, VOID_DATE VOID_DATE
, VOID_REASON VOID_REASON
, REMIT_TO_LOCATION_ID REMIT_TO_LOCATION_ID
, COMPLETED_PMTS_GROUP_ID COMPLETED_PMTS_GROUP_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
, EXT_BRANCH_NUMBER EXT_BRANCH_NUMBER
, EXT_BANK_NUMBER EXT_BANK_NUMBER
, EXT_BANK_ACCOUNT_NAME EXT_BANK_ACCOUNT_NAME
, EXT_BANK_ACCOUNT_NUMBER EXT_BANK_ACCOUNT_NUMBER
, EXT_BANK_ACCOUNT_TYPE EXT_BANK_ACCOUNT_TYPE
, EXT_BANK_ACCOUNT_IBAN_NUMBER EXT_BANK_ACCOUNT_IBAN_NUMBER
, PAYEE_NAME PAYEE_NAME
, PAYEE_ADDRESS1 PAYEE_ADDRESS1
, PAYEE_ADDRESS2 PAYEE_ADDRESS2
, PAYEE_ADDRESS3 PAYEE_ADDRESS3
, PAYEE_ADDRESS4 PAYEE_ADDRESS4
, PAYEE_CITY PAYEE_CITY
, PAYEE_POSTAL_CODE PAYEE_POSTAL_CODE
, PAYEE_STATE PAYEE_STATE
, PAYEE_PROVINCE PAYEE_PROVINCE
, PAYEE_COUNTY PAYEE_COUNTY
, PAYEE_COUNTRY PAYEE_COUNTRY
, REMIT_ADVICE_DELIVERY_METHOD REMIT_ADVICE_DELIVERY_METHOD
, REMIT_ADVICE_EMAIL REMIT_ADVICE_EMAIL
, REMIT_ADVICE_FAX REMIT_ADVICE_FAX
, PAYMENT_PROFILE_SYS_NAME PAYMENT_PROFILE_SYS_NAME
, PAYMENT_PROFILE_ACCT_NAME PAYMENT_PROFILE_ACCT_NAME
, PAYMENT_PROCESS_REQUEST_NAME PAYMENT_PROCESS_REQUEST_NAME
, SOURCE_PRODUCT SOURCE_PRODUCT
, PAYMENT_REASON_FORMAT_VALUE PAYMENT_REASON_FORMAT_VALUE
, DECLARATION_EXCH_RATE_TYPE DECLARATION_EXCH_RATE_TYPE
, DECLARATION_FORMAT DECLARATION_FORMAT
, DELIVERY_CHANNEL_FORMAT_VALUE DELIVERY_CHANNEL_FORMAT_VALUE
, BANK_INSTRUCTION1_FORMAT_VALUE BANK_INSTRUCTION1_FORMAT_VALUE
, BANK_INSTRUCTION2_FORMAT_VALUE BANK_INSTRUCTION2_FORMAT_VALUE
, SRA_DELIVERY_METHOD SRA_DELIVERY_METHOD
, INT_BANK_NAME INT_BANK_NAME
, INT_BANK_NUMBER INT_BANK_NUMBER
, INT_EFT_SWIFT_CODE INT_EFT_SWIFT_CODE
, INT_BANK_BRANCH_NAME INT_BANK_BRANCH_NAME
, INT_BANK_BRANCH_NUMBER INT_BANK_BRANCH_NUMBER
, INT_BANK_ACCOUNT_NAME INT_BANK_ACCOUNT_NAME
, INT_BANK_ACCOUNT_NUMBER INT_BANK_ACCOUNT_NUMBER
, INT_BANK_ACCOUNT_IBAN INT_BANK_ACCOUNT_IBAN
, EXT_BANK_NAME EXT_BANK_NAME
, EXT_EFT_SWIFT_CODE EXT_EFT_SWIFT_CODE
, EXT_BANK_BRANCH_NAME EXT_BANK_BRANCH_NAME
, ORG_NAME ORG_NAME
, PAYER_LEGAL_ENTITY_NAME PAYER_LEGAL_ENTITY_NAME
, PAYER_LE_REGISTRATION_NUM PAYER_LE_REGISTRATION_NUM
, PAYER_TAX_REGISTRATION_NUM PAYER_TAX_REGISTRATION_NUM
, PAYEE_PARTY_NAME PAYEE_PARTY_NAME
, PAYEE_LE_REGISTRATION_NUM PAYEE_LE_REGISTRATION_NUM
, PAYEE_TAX_REGISTRATION_NUM PAYEE_TAX_REGISTRATION_NUM
, PAYER_PARTY_SITE_NAME PAYER_PARTY_SITE_NAME
, PAYEE_ADDRESS_CONCAT PAYEE_ADDRESS_CONCAT
, BENEFICIARY_NAME BENEFICIARY_NAME
, PAYER_PARTY_NUMBER PAYER_PARTY_NUMBER
, PAYEE_PARTY_NUMBER PAYEE_PARTY_NUMBER
, PAYEE_ALTERNATE_NAME PAYEE_ALTERNATE_NAME
, PAYEE_SITE_ALTERNATE_NAME PAYEE_SITE_ALTERNATE_NAME
, PAYEE_SUPPLIER_NUMBER PAYEE_SUPPLIER_NUMBER
, PAYEE_FIRST_PARTY_REFERENCE PAYEE_FIRST_PARTY_REFERENCE
, INT_BANK_BRANCH_RFC_IDENTIFIER INT_BANK_BRANCH_RFC_IDENTIFIER
, INT_BANK_ACCT_AGENCY_LOC_CODE INT_BANK_ACCT_AGENCY_LOC_CODE
, PAYER_ABBREVIATED_AGENCY_CODE PAYER_ABBREVIATED_AGENCY_CODE
, PAYER_FEDERAL_US_EMPLOYER_ID PAYER_FEDERAL_US_EMPLOYER_ID
, EXT_BANK_ACCT_OWNER_PARTY_ID EXT_BANK_ACCT_OWNER_PARTY_ID
, EXT_BANK_ACCT_PMT_FACTOR_FLAG EXT_BANK_ACCT_PMT_FACTOR_FLAG
, ADDRESS_SOURCE ADDRESS_SOURCE
, EMPLOYEE_ADDRESS_CODE EMPLOYEE_ADDRESS_CODE
, EMPLOYEE_PERSON_ID EMPLOYEE_PERSON_ID
, EMPLOYEE_PAYMENT_FLAG EMPLOYEE_PAYMENT_FLAG
, EMPLOYEE_ADDRESS_ID EMPLOYEE_ADDRESS_ID
, REQUEST_ID REQUEST_ID
, EXT_BANK_BRANCH_PARTY_ID EXT_BANK_BRANCH_PARTY_ID
, EXT_BANK_ALT_NAME EXT_BANK_ALT_NAME
, EXT_BANK_BRANCH_ALT_NAME EXT_BANK_BRANCH_ALT_NAME
, EXT_BANK_ACCOUNT_ALT_NAME EXT_BANK_ACCOUNT_ALT_NAME
, EXT_BANK_ACCOUNT_NUM_ELEC EXT_BANK_ACCOUNT_NUM_ELEC
, EXT_BANK_BRANCH_LOCATION_ID EXT_BANK_BRANCH_LOCATION_ID
, EXT_BANK_ACCT_OWNER_PARTY_NAME EXT_BANK_ACCT_OWNER_PARTY_NAME
, INT_BANK_BRANCH_PARTY_ID INT_BANK_BRANCH_PARTY_ID
, INT_BANK_ALT_NAME INT_BANK_ALT_NAME
, INT_BANK_BRANCH_ALT_NAME INT_BANK_BRANCH_ALT_NAME
, INT_BANK_ACCOUNT_ALT_NAME INT_BANK_ACCOUNT_ALT_NAME
, INT_BANK_ACCOUNT_NUM_ELEC INT_BANK_ACCOUNT_NUM_ELEC
, INT_BANK_BRANCH_LOCATION_ID INT_BANK_BRANCH_LOCATION_ID
, INT_BANK_BRANCH_EFT_USER_NUM INT_BANK_BRANCH_EFT_USER_NUM
, PAYER_PARTY_ID PAYER_PARTY_ID
, PAYER_LOCATION_ID PAYER_LOCATION_ID
, PAYER_PARTY_ATTR_CATEGORY PAYER_PARTY_ATTR_CATEGORY
, PAYER_LE_ATTR_CATEGORY PAYER_LE_ATTR_CATEGORY
, PAYEE_PARTY_ATTR_CATEGORY PAYEE_PARTY_ATTR_CATEGORY
, PAYEE_SUPPLIER_ATTR_CATEGORY PAYEE_SUPPLIER_ATTR_CATEGORY
, PAYEE_SPPLR_SITE_ATTR_CATEGORY PAYEE_SPPLR_SITE_ATTR_CATEGORY
, PAYEE_SUPPLIER_SITE_NAME PAYEE_SUPPLIER_SITE_NAME
, PAYEE_SUPPLIER_SITE_ALT_NAME PAYEE_SUPPLIER_SITE_ALT_NAME
, PAYEE_SUPPLIER_ID PAYEE_SUPPLIER_ID
, LOGICAL_GROUP_REFERENCE LOGICAL_GROUP_REFERENCE
, POSITIVE_PAY_FILE_CREATED_FLAG POSITIVE_PAY_FILE_CREATED_FLAG
, EXT_INV_PAYEE_ID EXT_INV_PAYEE_ID
, INV_PAYEE_PARTY_ID INV_PAYEE_PARTY_ID
, INV_PARTY_SITE_ID INV_PARTY_SITE_ID
, INV_SUPPLIER_SITE_ID INV_SUPPLIER_SITE_ID
, INV_BENEFICIARY_PARTY INV_BENEFICIARY_PARTY
, INV_PAYEE_NAME INV_PAYEE_NAME
, INV_PAYEE_ADDRESS1 INV_PAYEE_ADDRESS1
, INV_PAYEE_ADDRESS2 INV_PAYEE_ADDRESS2
, INV_PAYEE_ADDRESS3 INV_PAYEE_ADDRESS3
, INV_PAYEE_ADDRESS4 INV_PAYEE_ADDRESS4
, INV_PAYEE_CITY INV_PAYEE_CITY
, INV_PAYEE_POSTAL_CODE INV_PAYEE_POSTAL_CODE
, INV_PAYEE_STATE INV_PAYEE_STATE
, INV_PAYEE_PROVINCE INV_PAYEE_PROVINCE
, INV_PAYEE_COUNTY INV_PAYEE_COUNTY
, INV_PAYEE_COUNTRY INV_PAYEE_COUNTRY
, INV_PAYEE_PARTY_NAME INV_PAYEE_PARTY_NAME
, INV_PAYEE_LE_REG_NUM INV_PAYEE_LE_REG_NUM
, INV_PAYEE_TAX_REG_NUM INV_PAYEE_TAX_REG_NUM
, INV_PAYEE_ADDRESS_CONCAT INV_PAYEE_ADDRESS_CONCAT
, INV_BENEFICIARY_NAME INV_BENEFICIARY_NAME
, INV_PAYEE_PARTY_NUMBER INV_PAYEE_PARTY_NUMBER
, INV_PAYEE_ALTERNATE_NAME INV_PAYEE_ALTERNATE_NAME
, INV_PAYEE_SITE_ALT_NAME INV_PAYEE_SITE_ALT_NAME
, INV_PAYEE_SUPPLIER_NUMBER INV_PAYEE_SUPPLIER_NUMBER
, INV_PAYEE_FIRST_PARTY_REF INV_PAYEE_FIRST_PARTY_REF
, EXT_BNK_ACCT_OWNR_INV_PRTY_ID EXT_BNK_ACCT_OWNR_INV_PRTY_ID
, EXT_BNK_BRANCH_INV_PRTY_ID EXT_BNK_BRANCH_INV_PRTY_ID
, EXT_BNK_ACCT_OWNR_INV_PRTY_NME EXT_BNK_ACCT_OWNR_INV_PRTY_NME
, INV_PAYEE_PARTY_ATTR_CAT INV_PAYEE_PARTY_ATTR_CAT
, INV_PAYEE_SUPPLIER_ATTR_CAT INV_PAYEE_SUPPLIER_ATTR_CAT
, INV_PAYEE_SPPLR_SITE_ATTR_CAT INV_PAYEE_SPPLR_SITE_ATTR_CAT
, INV_PAYEE_SUPPLIER_SITE_NAME INV_PAYEE_SUPPLIER_SITE_NAME
, INV_PAYEE_SPPLR_SITE_ALT_NAME INV_PAYEE_SPPLR_SITE_ALT_NAME
, INV_PAYEE_SUPPLIER_ID INV_PAYEE_SUPPLIER_ID
, PAYEE_ADDRESSEE PAYEE_ADDRESSEE
, PAYEE_PARTY_SITE_NAME PAYEE_PARTY_SITE_NAME
, INV_PAYEE_PARTY_SITE_NAME INV_PAYEE_PARTY_SITE_NAME
, ACKNOWLEDGED_FLAG ACKNOWLEDGED_FLAG
, AFFECTS_REJECTION_LEVEL AFFECTS_REJECTION_LEVEL
FROM "IBY"."IBY_PAYMENTS_ALL"