IBY_EXT_FD_DOC_1_0

Details

Schema: FUSION
Object owner: IBY
Object type: VIEW

Columns

Name
PAYMENT_ID DOCUMENT_PAYABLE_ID PAYMENT_SERVICE_REQUEST_ID CALLING_APP_DOC_UNIQUE_REF1 CALLING_APP_DOC_UNIQUE_REF2 CALLING_APP_DOC_UNIQUE_REF3 CALLING_APP_DOC_UNIQUE_REF4 CALLING_APP_DOC_UNIQUE_REF5 CALLING_APP_ID PAY_PROC_TRXN_TYPE_CODE CALLING_APP_DOCUMENT_UNIQUE_ID CALLING_APP_DOC_REF_NUMBER BANK_ASSIGNED_REF_CODE UNIQUE_REMITTANCE_IDENTIFIER URI_CHECK_DIGIT DOC_CATEGORY DOC_SEQUENCE_NAME DOC_SEQUENCE_VALUE PO_NUMBER DOCUMENT_STATUS DOCUMENT_STATUS_MEANING DOCUMENT_DATE DOCUMENT_CREATION_DATE PAYMENT_DUE_DATE DOCUMENT_TYPE DOCUMENT_TYPE_MEANING DOCUMENT_DESCRIPTION DOCUMENT_AMOUNT DOCUMENT_CURRENCY_CODE PAYMENT_AMOUNT PAYMENT_CURRENCY_CODE DISCOUNT_DATE PAYMENT_CURR_DISCOUNT_TAKEN DOCUMENT_CURR_CHARGE_AMOUNT INTEREST_RATE BANK_CHARGE_BEARER BANK_CHARGE_BEARER_MEANING EXCLUSIVE_PAYMENT_FLAG DELIVERY_CHANNEL_CODE DELIVERY_CHANNEL_MEANING DELIVERY_CHANNEL_FORMAT_VALUE SETTLEMENT_PRIORITY SETTLEMENT_PRIORITY_MEANING AMOUNT_WITHHELD PAYMENT_REASON_CODE PAYMENT_REASON_MEANING PAYMENT_REASON_FORMAT_VALUE PAYMENT_REASON_COMMENTS REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE3 ROUTING_ATTRIBUTE1 ROUTING_ATTRIBUTE2 ROUTING_ATTRIBUTE3 ROUTING_ATTRIBUTE4 ROUTING_ATTRIBUTE5 DOC_PAYABLE_ATTR_CAT FORMATTING_PAYMENT_ID EMPLOYEE_PAYMENT_FLAG BORDERO_INT_AMT BORDERO_ABATEMENT DOCUMENT_CURRENCY_TAX_AMOUNT EXPENSE_RPT_CC_NUM INVOICING_ORG_ID INVOICING_ORG_TYPE INVOICING_ORG_TYPE_MEANING INVOICING_ORG_NAME CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY DOC_CURRENCY_PAYMENT_AMOUNT DOC_CURR_AMOUNT_WITHHELD DOC_CURR_DISCOUNT_TAKEN

Name

PAYMENT_ID

DOCUMENT_PAYABLE_ID

PAYMENT_SERVICE_REQUEST_ID

CALLING_APP_DOC_UNIQUE_REF1

CALLING_APP_DOC_UNIQUE_REF2

CALLING_APP_DOC_UNIQUE_REF3

CALLING_APP_DOC_UNIQUE_REF4

CALLING_APP_DOC_UNIQUE_REF5

CALLING_APP_ID

PAY_PROC_TRXN_TYPE_CODE

CALLING_APP_DOCUMENT_UNIQUE_ID

CALLING_APP_DOC_REF_NUMBER

BANK_ASSIGNED_REF_CODE

UNIQUE_REMITTANCE_IDENTIFIER

URI_CHECK_DIGIT

DOC_CATEGORY

DOC_SEQUENCE_NAME

DOC_SEQUENCE_VALUE

PO_NUMBER

DOCUMENT_STATUS

DOCUMENT_STATUS_MEANING

DOCUMENT_DATE

DOCUMENT_CREATION_DATE

PAYMENT_DUE_DATE

DOCUMENT_TYPE

DOCUMENT_TYPE_MEANING

DOCUMENT_DESCRIPTION

DOCUMENT_AMOUNT

DOCUMENT_CURRENCY_CODE

PAYMENT_AMOUNT

PAYMENT_CURRENCY_CODE

DISCOUNT_DATE

PAYMENT_CURR_DISCOUNT_TAKEN

DOCUMENT_CURR_CHARGE_AMOUNT

INTEREST_RATE

BANK_CHARGE_BEARER

BANK_CHARGE_BEARER_MEANING

EXCLUSIVE_PAYMENT_FLAG

DELIVERY_CHANNEL_CODE

DELIVERY_CHANNEL_MEANING

DELIVERY_CHANNEL_FORMAT_VALUE

SETTLEMENT_PRIORITY

SETTLEMENT_PRIORITY_MEANING

AMOUNT_WITHHELD

PAYMENT_REASON_CODE

PAYMENT_REASON_MEANING

PAYMENT_REASON_FORMAT_VALUE

PAYMENT_REASON_COMMENTS

REMITTANCE_MESSAGE1

REMITTANCE_MESSAGE2

REMITTANCE_MESSAGE3

ROUTING_ATTRIBUTE1

ROUTING_ATTRIBUTE2

ROUTING_ATTRIBUTE3

ROUTING_ATTRIBUTE4

ROUTING_ATTRIBUTE5

DOC_PAYABLE_ATTR_CAT

FORMATTING_PAYMENT_ID

EMPLOYEE_PAYMENT_FLAG

BORDERO_INT_AMT

BORDERO_ABATEMENT

DOCUMENT_CURRENCY_TAX_AMOUNT

EXPENSE_RPT_CC_NUM

INVOICING_ORG_ID

INVOICING_ORG_TYPE

INVOICING_ORG_TYPE_MEANING

INVOICING_ORG_NAME

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

DOC_CURRENCY_PAYMENT_AMOUNT

DOC_CURR_AMOUNT_WITHHELD

DOC_CURR_DISCOUNT_TAKEN

Query

SQL_Statement
SELECT PAYMENT_ID, DOCUMENT_PAYABLE_ID, PAYMENT_SERVICE_REQUEST_ID, CALLING_APP_DOC_UNIQUE_REF1, CALLING_APP_DOC_UNIQUE_REF2, CALLING_APP_DOC_UNIQUE_REF3, CALLING_APP_DOC_UNIQUE_REF4, CALLING_APP_DOC_UNIQUE_REF5, CALLING_APP_ID, PAY_PROC_TRXN_TYPE_CODE, CALLING_APP_DOCUMENT_UNIQUE_ID, CALLING_APP_DOC_REF_NUMBER, BANK_ASSIGNED_REF_CODE, UNIQUE_REMITTANCE_IDENTIFIER, URI_CHECK_DIGIT, DOC_CATEGORY, DOC_SEQUENCE_NAME, DOC_SEQUENCE_VALUE, PO_NUMBER, DOCUMENT_STATUS, DOCUMENT_STATUS_MEANING, DOCUMENT_DATE, DOCUMENT_CREATION_DATE, PAYMENT_DUE_DATE, DOCUMENT_TYPE, DOCUMENT_TYPE_MEANING, DOCUMENT_DESCRIPTION, DOCUMENT_AMOUNT, DOCUMENT_CURRENCY_CODE, PAYMENT_AMOUNT, PAYMENT_CURRENCY_CODE, DISCOUNT_DATE, PAYMENT_CURR_DISCOUNT_TAKEN, DOCUMENT_CURR_CHARGE_AMOUNT, INTEREST_RATE, BANK_CHARGE_BEARER, BANK_CHARGE_BEARER_MEANING, EXCLUSIVE_PAYMENT_FLAG, DELIVERY_CHANNEL_CODE, DELIVERY_CHANNEL_MEANING, DELIVERY_CHANNEL_FORMAT_VALUE, SETTLEMENT_PRIORITY, SETTLEMENT_PRIORITY_MEANING, AMOUNT_WITHHELD, PAYMENT_REASON_CODE, PAYMENT_REASON_MEANING, PAYMENT_REASON_FORMAT_VALUE, PAYMENT_REASON_COMMENTS, REMITTANCE_MESSAGE1, REMITTANCE_MESSAGE2, REMITTANCE_MESSAGE3, ROUTING_ATTRIBUTE1, ROUTING_ATTRIBUTE2, ROUTING_ATTRIBUTE3, ROUTING_ATTRIBUTE4, ROUTING_ATTRIBUTE5, DOC_PAYABLE_ATTR_CAT, FORMATTING_PAYMENT_ID, EMPLOYEE_PAYMENT_FLAG, BORDERO_INT_AMT, BORDERO_ABATEMENT, DOCUMENT_CURRENCY_TAX_AMOUNT, EXPENSE_RPT_CC_NUM, INVOICING_ORG_ID, INVOICING_ORG_TYPE, INVOICING_ORG_TYPE_MEANING, INVOICING_ORG_NAME, CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, LAST_UPDATED_BY, DOC_CURRENCY_PAYMENT_AMOUNT, DOC_CURR_AMOUNT_WITHHELD, DOC_CURR_DISCOUNT_TAKEN FROM IBY_EXT_FD_DOC_1_0_VT ORDER BY CALLING_APP_DOC_REF_NUMBER

SQL_Statement

SELECT

PAYMENT_ID,

DOCUMENT_PAYABLE_ID,

PAYMENT_SERVICE_REQUEST_ID,

CALLING_APP_DOC_UNIQUE_REF1,

CALLING_APP_DOC_UNIQUE_REF2,

CALLING_APP_DOC_UNIQUE_REF3,

CALLING_APP_DOC_UNIQUE_REF4,

CALLING_APP_DOC_UNIQUE_REF5,

CALLING_APP_ID,

PAY_PROC_TRXN_TYPE_CODE,

CALLING_APP_DOCUMENT_UNIQUE_ID,

CALLING_APP_DOC_REF_NUMBER,

BANK_ASSIGNED_REF_CODE,

UNIQUE_REMITTANCE_IDENTIFIER,

URI_CHECK_DIGIT,

DOC_CATEGORY,

DOC_SEQUENCE_NAME,

DOC_SEQUENCE_VALUE,

PO_NUMBER,

DOCUMENT_STATUS,

DOCUMENT_STATUS_MEANING,

DOCUMENT_DATE,

DOCUMENT_CREATION_DATE,

PAYMENT_DUE_DATE,

DOCUMENT_TYPE,

DOCUMENT_TYPE_MEANING,

DOCUMENT_DESCRIPTION,

DOCUMENT_AMOUNT,

DOCUMENT_CURRENCY_CODE,

PAYMENT_AMOUNT,

PAYMENT_CURRENCY_CODE,

DISCOUNT_DATE,

PAYMENT_CURR_DISCOUNT_TAKEN,

DOCUMENT_CURR_CHARGE_AMOUNT,

INTEREST_RATE,

BANK_CHARGE_BEARER,

BANK_CHARGE_BEARER_MEANING,

EXCLUSIVE_PAYMENT_FLAG,

DELIVERY_CHANNEL_CODE,

DELIVERY_CHANNEL_MEANING,

DELIVERY_CHANNEL_FORMAT_VALUE,

SETTLEMENT_PRIORITY,

SETTLEMENT_PRIORITY_MEANING,

AMOUNT_WITHHELD,

PAYMENT_REASON_CODE,

PAYMENT_REASON_MEANING,

PAYMENT_REASON_FORMAT_VALUE,

PAYMENT_REASON_COMMENTS,

REMITTANCE_MESSAGE1,

REMITTANCE_MESSAGE2,

REMITTANCE_MESSAGE3,

ROUTING_ATTRIBUTE1,

ROUTING_ATTRIBUTE2,

ROUTING_ATTRIBUTE3,

ROUTING_ATTRIBUTE4,

ROUTING_ATTRIBUTE5,

DOC_PAYABLE_ATTR_CAT,

FORMATTING_PAYMENT_ID,

EMPLOYEE_PAYMENT_FLAG,

BORDERO_INT_AMT,

BORDERO_ABATEMENT,

DOCUMENT_CURRENCY_TAX_AMOUNT,

EXPENSE_RPT_CC_NUM,

INVOICING_ORG_ID,

INVOICING_ORG_TYPE,

INVOICING_ORG_TYPE_MEANING,

INVOICING_ORG_NAME,

CREATED_BY,

CREATION_DATE,

LAST_UPDATE_DATE,

LAST_UPDATE_LOGIN,

LAST_UPDATED_BY,

DOC_CURRENCY_PAYMENT_AMOUNT,

DOC_CURR_AMOUNT_WITHHELD,

DOC_CURR_DISCOUNT_TAKEN

FROM

IBY_EXT_FD_DOC_1_0_VT

ORDER BY

CALLING_APP_DOC_REF_NUMBER