IBY_PAYMENTS_SEC

Details

Schema: FUSION
Object owner: IBY
Object type: VIEW

Columns

Name
PAPER_DOCUMENT_NUMBER BANK_ASSIGNED_REF_CODE EXTERNAL_BANK_ACCOUNT_ID DOCUMENT_SEQUENCE_ID DOCUMENT_SEQUENCE_VALUE DOCUMENT_CATEGORY_CODE UNIQUE_REMITTANCE_IDENTIFIER URI_CHECK_DIGIT BANK_INSTRUCTION1_CODE BANK_INSTRUCTION2_CODE PAYMENT_TEXT_MESSAGE1 PAYMENT_TEXT_MESSAGE2 PAYMENT_TEXT_MESSAGE3 BILL_PAYABLE_FLAG MATURITY_DATE PAYMENT_DUE_DATE STOP_REQUEST_PLACED_FLAG STOP_REQUEST_REASON STOP_REQUEST_PLACED_BY STOP_REQUEST_DATE STOP_REQUEST_REFERENCE STOP_RELEASED_FLAG STOP_RELEASE_REASON STOP_RELEASED_BY STOP_RELEASE_DATE STOP_RELEASE_REFERENCE STOP_CONFIRMED_FLAG STOP_CONFIRM_REASON STOP_CONFIRMED_BY STOP_CONFIRM_DATE STOP_CONFIRM_REFERENCE VOID_REASON VOIDED_BY VOID_DATE REMIT_TO_LOCATION_ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 PAYMENT_ID PAYMENT_METHOD_CODE PAYMENT_SERVICE_REQUEST_ID PROCESS_TYPE PAYMENT_STATUS PAYMENTS_COMPLETE_FLAG PAYMENT_FUNCTION PAYMENT_AMOUNT PAYMENT_CURRENCY_CODE SEPARATE_REMIT_ADVICE_REQ_FLAG INTERNAL_BANK_ACCOUNT_ID SUPPLIER_SITE_ID PAYEE_PARTY_ID PARTY_SITE_ID DECLARE_PAYMENT_FLAG DECLARATION_AMOUNT DECLARATION_CURRENCY_CODE DISCOUNT_AMOUNT_TAKEN PAYMENT_DETAILS BANK_CHARGE_BEARER BANK_CHARGE_AMOUNT DELIVERY_CHANNEL_CODE SETTLEMENT_PRIORITY REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE3 PAYMENT_REFERENCE_NUMBER ORG_TYPE LEGAL_ENTITY_ID EXT_PAYEE_ID ORG_ID PREGROUPED_PAYMENT_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER PAYMENT_PROFILE_ID PAYMENT_INSTRUCTION_ID PAYMENT_REASON_CODE PAYMENT_REASON_COMMENTS PAYMENT_DATE ANTICIPATED_VALUE_DATE COMPLETED_PMTS_GROUP_ID EXT_BRANCH_NUMBER EXT_BANK_NUMBER EXT_BANK_ACCOUNT_NAME EXT_BANK_ACCOUNT_NUMBER EXT_BANK_ACCOUNT_TYPE EXT_BANK_ACCOUNT_IBAN_NUMBER PAYEE_NAME PAYEE_ADDRESS1 PAYEE_ADDRESS2 PAYEE_ADDRESS3 PAYEE_ADDRESS4 PAYEE_CITY PAYEE_POSTAL_CODE PAYEE_STATE PAYEE_PROVINCE PAYEE_COUNTY PAYEE_COUNTRY REQUEST_ID

Name

PAPER_DOCUMENT_NUMBER

BANK_ASSIGNED_REF_CODE

EXTERNAL_BANK_ACCOUNT_ID

DOCUMENT_SEQUENCE_ID

DOCUMENT_SEQUENCE_VALUE

DOCUMENT_CATEGORY_CODE

UNIQUE_REMITTANCE_IDENTIFIER

URI_CHECK_DIGIT

BANK_INSTRUCTION1_CODE

BANK_INSTRUCTION2_CODE

PAYMENT_TEXT_MESSAGE1

PAYMENT_TEXT_MESSAGE2

PAYMENT_TEXT_MESSAGE3

BILL_PAYABLE_FLAG

MATURITY_DATE

PAYMENT_DUE_DATE

STOP_REQUEST_PLACED_FLAG

STOP_REQUEST_REASON

STOP_REQUEST_PLACED_BY

STOP_REQUEST_DATE

STOP_REQUEST_REFERENCE

STOP_RELEASED_FLAG

STOP_RELEASE_REASON

STOP_RELEASED_BY

STOP_RELEASE_DATE

STOP_RELEASE_REFERENCE

STOP_CONFIRMED_FLAG

STOP_CONFIRM_REASON

STOP_CONFIRMED_BY

STOP_CONFIRM_DATE

STOP_CONFIRM_REFERENCE

VOID_REASON

VOIDED_BY

VOID_DATE

REMIT_TO_LOCATION_ID

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

PAYMENT_ID

PAYMENT_METHOD_CODE

PAYMENT_SERVICE_REQUEST_ID

PROCESS_TYPE

PAYMENT_STATUS

PAYMENTS_COMPLETE_FLAG

PAYMENT_FUNCTION

PAYMENT_AMOUNT

PAYMENT_CURRENCY_CODE

SEPARATE_REMIT_ADVICE_REQ_FLAG

INTERNAL_BANK_ACCOUNT_ID

SUPPLIER_SITE_ID

PAYEE_PARTY_ID

PARTY_SITE_ID

DECLARE_PAYMENT_FLAG

DECLARATION_AMOUNT

DECLARATION_CURRENCY_CODE

DISCOUNT_AMOUNT_TAKEN

PAYMENT_DETAILS

BANK_CHARGE_BEARER

BANK_CHARGE_AMOUNT

DELIVERY_CHANNEL_CODE

SETTLEMENT_PRIORITY

REMITTANCE_MESSAGE1

REMITTANCE_MESSAGE2

REMITTANCE_MESSAGE3

PAYMENT_REFERENCE_NUMBER

ORG_TYPE

LEGAL_ENTITY_ID

EXT_PAYEE_ID

ORG_ID

PREGROUPED_PAYMENT_FLAG

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

PAYMENT_PROFILE_ID

PAYMENT_INSTRUCTION_ID

PAYMENT_REASON_CODE

PAYMENT_REASON_COMMENTS

PAYMENT_DATE

ANTICIPATED_VALUE_DATE

COMPLETED_PMTS_GROUP_ID

EXT_BRANCH_NUMBER

EXT_BANK_NUMBER

EXT_BANK_ACCOUNT_NAME

EXT_BANK_ACCOUNT_NUMBER

EXT_BANK_ACCOUNT_TYPE

EXT_BANK_ACCOUNT_IBAN_NUMBER

PAYEE_NAME

PAYEE_ADDRESS1

PAYEE_ADDRESS2

PAYEE_ADDRESS3

PAYEE_ADDRESS4

PAYEE_CITY

PAYEE_POSTAL_CODE

PAYEE_STATE

PAYEE_PROVINCE

PAYEE_COUNTY

PAYEE_COUNTRY

REQUEST_ID

Query

SQL_Statement
SELECT iby_pay.paper_document_number paper_document_number, iby_pay.bank_assigned_ref_code bank_assigned_ref_code, iby_pay.external_bank_account_id external_bank_account_id, iby_pay.document_sequence_id document_sequence_id, iby_pay.document_sequence_value document_sequence_value, iby_pay.document_category_code document_category_code, iby_pay.unique_remittance_identifier unique_remittance_identifier, iby_pay.uri_check_digit uri_check_digit, iby_pay.bank_instruction1_code bank_instruction1_code, iby_pay.bank_instruction2_code bank_instruction2_code, iby_pay.payment_text_message1 payment_text_message1, iby_pay.payment_text_message2 payment_text_message2, iby_pay.payment_text_message3 payment_text_message3, iby_pay.bill_payable_flag bill_payable_flag, iby_pay.maturity_date maturity_date, iby_pay.payment_due_date payment_due_date, iby_pay.stop_request_placed_flag stop_request_placed_flag, iby_pay.stop_request_reason stop_request_reason, iby_pay.stop_request_placed_by stop_request_placed_by, iby_pay.stop_request_date stop_request_date, iby_pay.stop_request_reference stop_request_reference, iby_pay.stop_released_flag stop_released_flag, iby_pay.stop_release_reason stop_release_reason, iby_pay.stop_released_by stop_released_by, iby_pay.stop_release_date stop_release_date, iby_pay.stop_release_reference stop_release_reference, iby_pay.stop_confirmed_flag stop_confirmed_flag, iby_pay.stop_confirm_reason stop_confirm_reason, iby_pay.stop_confirmed_by stop_confirmed_by, iby_pay.stop_confirm_date stop_confirm_date, iby_pay.stop_confirm_reference stop_confirm_reference, iby_pay.void_reason void_reason, iby_pay.voided_by voided_by, iby_pay.void_date void_date, iby_pay.remit_to_location_id, iby_pay.attribute_category attribute_category, iby_pay.attribute1 attribute1, iby_pay.attribute2 attribute2, iby_pay.attribute3 attribute3, iby_pay.attribute4 attribute4, iby_pay.attribute5 attribute5, iby_pay.attribute6 attribute6, iby_pay.attribute7 attribute7, iby_pay.attribute8 attribute8, iby_pay.attribute9 attribute9, iby_pay.attribute10 attribute10, iby_pay.attribute11 attribute11, iby_pay.attribute12 attribute12, iby_pay.attribute13 attribute13, iby_pay.attribute14 attribute14, iby_pay.attribute15 attribute15, iby_pay.payment_id payment_id, iby_pay.payment_method_code payment_method_code, iby_pay.payment_service_request_id payment_service_request_id, iby_pay.process_type process_type, iby_pay.payment_status payment_status, iby_pay.payments_complete_flag payments_complete_flag, iby_pay.payment_function payment_function, iby_pay.payment_amount payment_amount, iby_pay.payment_currency_code payment_currency_code, iby_pay.separate_remit_advice_req_flag separate_remit_advice_req_flag, iby_pay.internal_bank_account_id internal_bank_account_id, iby_pay.supplier_site_id supplier_site_id, iby_pay.payee_party_id payee_party_id, iby_pay.party_site_id party_site_id, iby_pay.declare_payment_flag declare_payment_flag, iby_pay.declaration_amount declaration_amount, iby_pay.declaration_currency_code declaration_currency_code, iby_pay.discount_amount_taken discount_amount_taken, iby_pay.payment_details payment_details, iby_pay.bank_charge_bearer bank_charge_bearer, iby_pay.bank_charge_amount bank_charge_amount, iby_pay.delivery_channel_code delivery_channel_code, iby_pay.settlement_priority settlement_priority, iby_pay.remittance_message1 remittance_message1, iby_pay.remittance_message2 remittance_message2, iby_pay.remittance_message3 remittance_message3, iby_pay.payment_reference_number payment_reference_number, iby_pay.org_type org_type, iby_pay.legal_entity_id legal_entity_id, iby_pay.ext_payee_id ext_payee_id, iby_pay.org_id org_id, iby_pay.pregrouped_payment_flag pregrouped_payment_flag, iby_pay.created_by created_by, iby_pay.creation_date creation_date, iby_pay.last_updated_by last_updated_by, iby_pay.last_update_date last_update_date, iby_pay.last_update_login last_update_login, iby_pay.object_version_number object_version_number, iby_pay.payment_profile_id payment_profile_id, iby_pay.payment_instruction_id payment_instruction_id, iby_pay.payment_reason_code payment_reason_code, iby_pay.payment_reason_comments payment_reason_comments, iby_pay.payment_date payment_date, iby_pay.anticipated_value_date anticipated_value_date, iby_pay.completed_pmts_group_id completed_pmts_group_id, iby_pay.ext_branch_number ext_branch_number, iby_pay.ext_bank_number ext_bank_number, iby_pay.ext_bank_account_name ext_bank_account_name, iby_pay.ext_bank_account_number ext_bank_account_number, iby_pay.ext_bank_account_type ext_bank_account_type, iby_pay.ext_bank_account_iban_number ext_bank_account_iban_number, iby_pay.payee_name payee_name, iby_pay.payee_address1 payee_address1, iby_pay.payee_address2 payee_address2, iby_pay.payee_address3 payee_address3, iby_pay.payee_address4 payee_address4, iby_pay.payee_city payee_city, iby_pay.payee_postal_code payee_postal_code, iby_pay.payee_state payee_state, iby_pay.payee_province payee_province, iby_pay.payee_county payee_county, iby_pay.payee_country payee_country, iby_pay.request_id request_id FROM iby_payments_all iby_pay WHERE(iby_pay.org_id = -1) OR((iby_pay.org_id <> -1) AND(iby_pay.org_id, iby_pay.org_type) IN (SELECT mo_goa.organization_id, 'OPERATING_UNIT' FROM mo_glob_org_access_tmp mo_goa) AND iby_pay.payment_function IN (SELECT fu.payment_function FROM iby_user_pay_funs_sec_v fu) )

SQL_Statement

SELECT iby_pay.paper_document_number paper_document_number,

iby_pay.bank_assigned_ref_code bank_assigned_ref_code,

iby_pay.external_bank_account_id external_bank_account_id,

iby_pay.document_sequence_id document_sequence_id,

iby_pay.document_sequence_value document_sequence_value,

iby_pay.document_category_code document_category_code,

iby_pay.unique_remittance_identifier unique_remittance_identifier,

iby_pay.uri_check_digit uri_check_digit,

iby_pay.bank_instruction1_code bank_instruction1_code,

iby_pay.bank_instruction2_code bank_instruction2_code,

iby_pay.payment_text_message1 payment_text_message1,

iby_pay.payment_text_message2 payment_text_message2,

iby_pay.payment_text_message3 payment_text_message3,

iby_pay.bill_payable_flag bill_payable_flag,

iby_pay.maturity_date maturity_date,

iby_pay.payment_due_date payment_due_date,

iby_pay.stop_request_placed_flag stop_request_placed_flag,

iby_pay.stop_request_reason stop_request_reason,

iby_pay.stop_request_placed_by stop_request_placed_by,

iby_pay.stop_request_date stop_request_date,

iby_pay.stop_request_reference stop_request_reference,

iby_pay.stop_released_flag stop_released_flag,

iby_pay.stop_release_reason stop_release_reason,

iby_pay.stop_released_by stop_released_by,

iby_pay.stop_release_date stop_release_date,

iby_pay.stop_release_reference stop_release_reference,

iby_pay.stop_confirmed_flag stop_confirmed_flag,

iby_pay.stop_confirm_reason stop_confirm_reason,

iby_pay.stop_confirmed_by stop_confirmed_by,

iby_pay.stop_confirm_date stop_confirm_date,

iby_pay.stop_confirm_reference stop_confirm_reference,

iby_pay.void_reason void_reason,

iby_pay.voided_by voided_by,

iby_pay.void_date void_date,

iby_pay.remit_to_location_id,

iby_pay.attribute_category attribute_category,

iby_pay.attribute1 attribute1,

iby_pay.attribute2 attribute2,

iby_pay.attribute3 attribute3,

iby_pay.attribute4 attribute4,

iby_pay.attribute5 attribute5,

iby_pay.attribute6 attribute6,

iby_pay.attribute7 attribute7,

iby_pay.attribute8 attribute8,

iby_pay.attribute9 attribute9,

iby_pay.attribute10 attribute10,

iby_pay.attribute11 attribute11,

iby_pay.attribute12 attribute12,

iby_pay.attribute13 attribute13,

iby_pay.attribute14 attribute14,

iby_pay.attribute15 attribute15,

iby_pay.payment_id payment_id,

iby_pay.payment_method_code payment_method_code,

iby_pay.payment_service_request_id payment_service_request_id,

iby_pay.process_type process_type,

iby_pay.payment_status payment_status,

iby_pay.payments_complete_flag payments_complete_flag,

iby_pay.payment_function payment_function,

iby_pay.payment_amount payment_amount,

iby_pay.payment_currency_code payment_currency_code,

iby_pay.separate_remit_advice_req_flag separate_remit_advice_req_flag,

iby_pay.internal_bank_account_id internal_bank_account_id,

iby_pay.supplier_site_id supplier_site_id,

iby_pay.payee_party_id payee_party_id,

iby_pay.party_site_id party_site_id,

iby_pay.declare_payment_flag declare_payment_flag,

iby_pay.declaration_amount declaration_amount,

iby_pay.declaration_currency_code declaration_currency_code,

iby_pay.discount_amount_taken discount_amount_taken,

iby_pay.payment_details payment_details,

iby_pay.bank_charge_bearer bank_charge_bearer,

iby_pay.bank_charge_amount bank_charge_amount,

iby_pay.delivery_channel_code delivery_channel_code,

iby_pay.settlement_priority settlement_priority,

iby_pay.remittance_message1 remittance_message1,

iby_pay.remittance_message2 remittance_message2,

iby_pay.remittance_message3 remittance_message3,

iby_pay.payment_reference_number payment_reference_number,

iby_pay.org_type org_type,

iby_pay.legal_entity_id legal_entity_id,

iby_pay.ext_payee_id ext_payee_id,

iby_pay.org_id org_id,

iby_pay.pregrouped_payment_flag pregrouped_payment_flag,

iby_pay.created_by created_by,

iby_pay.creation_date creation_date,

iby_pay.last_updated_by last_updated_by,

iby_pay.last_update_date last_update_date,

iby_pay.last_update_login last_update_login,

iby_pay.object_version_number object_version_number,

iby_pay.payment_profile_id payment_profile_id,

iby_pay.payment_instruction_id payment_instruction_id,

iby_pay.payment_reason_code payment_reason_code,

iby_pay.payment_reason_comments payment_reason_comments,

iby_pay.payment_date payment_date,

iby_pay.anticipated_value_date anticipated_value_date,

iby_pay.completed_pmts_group_id completed_pmts_group_id,

iby_pay.ext_branch_number ext_branch_number,

iby_pay.ext_bank_number ext_bank_number,

iby_pay.ext_bank_account_name ext_bank_account_name,

iby_pay.ext_bank_account_number ext_bank_account_number,

iby_pay.ext_bank_account_type ext_bank_account_type,

iby_pay.ext_bank_account_iban_number ext_bank_account_iban_number,

iby_pay.payee_name payee_name,

iby_pay.payee_address1 payee_address1,

iby_pay.payee_address2 payee_address2,

iby_pay.payee_address3 payee_address3,

iby_pay.payee_address4 payee_address4,

iby_pay.payee_city payee_city,

iby_pay.payee_postal_code payee_postal_code,

iby_pay.payee_state payee_state,

iby_pay.payee_province payee_province,

iby_pay.payee_county payee_county,

iby_pay.payee_country payee_country,

iby_pay.request_id request_id

FROM iby_payments_all iby_pay

WHERE(iby_pay.org_id = -1) OR((iby_pay.org_id <> -1)

AND(iby_pay.org_id, iby_pay.org_type) IN

(SELECT mo_goa.organization_id, 'OPERATING_UNIT'

FROM mo_glob_org_access_tmp mo_goa)

AND iby_pay.payment_function IN

(SELECT fu.payment_function

FROM iby_user_pay_funs_sec_v fu)

)