IBY_FD_DOCS_PAYABLE

Details

Schema: FUSION
Object owner: IBY
Object type: VIEW

Columns

Name
DOCUMENT_AMOUNT PAYMENT_CURRENCY_CODE PAYMENT_AMOUNT ALLOW_REMOVING_DOCUMENT_FLAG REMIT_TO_LOCATION_ID STRAIGHT_THROUGH_FLAG PAYMENT_SERVICE_REQUEST_ID PAYMENT_METHOD_CODE EXCLUSIVE_PAYMENT_FLAG EXT_PAYEE_ID PAYEE_PARTY_ID LEGAL_ENTITY_ID ORG_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE OBJECT_VERSION_NUMBER CALLING_APP_DOC_UNIQUE_REF1 CALLING_APP_DOC_UNIQUE_REF2 ORG_TYPE COMPLETED_PMTS_GROUP_ID REJECTED_DOCS_GROUP_ID DELIVERY_CHANNEL_CODE PAYMENT_FORMAT_CODE PAY_PROC_TRXN_TYPE_CODE CALLING_APP_ID CALLING_APP_DOC_REF_NUMBER DOCUMENT_PAYABLE_ID PAYMENT_FUNCTION PAYMENT_DATE DOCUMENT_DATE DOCUMENT_TYPE DOCUMENT_STATUS DOCUMENT_CURRENCY_CODE PAYMENT_REASON_CODE REMITTANCE_MESSAGE1 DOCUMENT_SEQUENCE_ID DOCUMENT_SEQUENCE_VALUE DOCUMENT_CATEGORY_CODE BANK_ASSIGNED_REF_CODE PO_NUMBER CALLING_APP_DOC_UNIQUE_REF4 CALLING_APP_DOC_UNIQUE_REF5 LAST_UPDATE_LOGIN PARTY_SITE_ID SUPPLIER_SITE_ID REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE3 PAYMENT_REASON_COMMENTS ANTICIPATED_VALUE_DATE DOCUMENT_DESCRIPTION DOCUMENT_CURRENCY_TAX_AMOUNT DOCUMENT_CURR_CHARGE_AMOUNT AMOUNT_WITHHELD PAYMENT_CURR_DISCOUNT_TAKEN DISCOUNT_DATE PAYMENT_DUE_DATE PAYMENT_PROFILE_ID PAYMENT_ID FORMATTING_PAYMENT_ID INTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID BANK_CHARGE_BEARER INTEREST_RATE PAYMENT_GROUPING_NUMBER UNIQUE_REMITTANCE_IDENTIFIER URI_CHECK_DIGIT CALLING_APP_DOC_UNIQUE_REF3 BENEFICIARY_PARTY ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 SETTLEMENT_PRIORITY ADDRESS_SOURCE EMPLOYEE_ADDRESS_CODE EMPLOYEE_PERSON_ID EMPLOYEE_PAYMENT_FLAG EMPLOYEE_ADDRESS_ID

Name

DOCUMENT_AMOUNT

PAYMENT_CURRENCY_CODE

PAYMENT_AMOUNT

ALLOW_REMOVING_DOCUMENT_FLAG

REMIT_TO_LOCATION_ID

STRAIGHT_THROUGH_FLAG

PAYMENT_SERVICE_REQUEST_ID

PAYMENT_METHOD_CODE

EXCLUSIVE_PAYMENT_FLAG

EXT_PAYEE_ID

PAYEE_PARTY_ID

LEGAL_ENTITY_ID

ORG_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

OBJECT_VERSION_NUMBER

CALLING_APP_DOC_UNIQUE_REF1

CALLING_APP_DOC_UNIQUE_REF2

ORG_TYPE

COMPLETED_PMTS_GROUP_ID

REJECTED_DOCS_GROUP_ID

DELIVERY_CHANNEL_CODE

PAYMENT_FORMAT_CODE

PAY_PROC_TRXN_TYPE_CODE

CALLING_APP_ID

CALLING_APP_DOC_REF_NUMBER

DOCUMENT_PAYABLE_ID

PAYMENT_FUNCTION

PAYMENT_DATE

DOCUMENT_DATE

DOCUMENT_TYPE

DOCUMENT_STATUS

DOCUMENT_CURRENCY_CODE

PAYMENT_REASON_CODE

REMITTANCE_MESSAGE1

DOCUMENT_SEQUENCE_ID

DOCUMENT_SEQUENCE_VALUE

DOCUMENT_CATEGORY_CODE

BANK_ASSIGNED_REF_CODE

PO_NUMBER

CALLING_APP_DOC_UNIQUE_REF4

CALLING_APP_DOC_UNIQUE_REF5

LAST_UPDATE_LOGIN

PARTY_SITE_ID

SUPPLIER_SITE_ID

REMITTANCE_MESSAGE2

REMITTANCE_MESSAGE3

PAYMENT_REASON_COMMENTS

ANTICIPATED_VALUE_DATE

DOCUMENT_DESCRIPTION

DOCUMENT_CURRENCY_TAX_AMOUNT

DOCUMENT_CURR_CHARGE_AMOUNT

AMOUNT_WITHHELD

PAYMENT_CURR_DISCOUNT_TAKEN

DISCOUNT_DATE

PAYMENT_DUE_DATE

PAYMENT_PROFILE_ID

PAYMENT_ID

FORMATTING_PAYMENT_ID

INTERNAL_BANK_ACCOUNT_ID

EXTERNAL_BANK_ACCOUNT_ID

BANK_CHARGE_BEARER

INTEREST_RATE

PAYMENT_GROUPING_NUMBER

UNIQUE_REMITTANCE_IDENTIFIER

URI_CHECK_DIGIT

CALLING_APP_DOC_UNIQUE_REF3

BENEFICIARY_PARTY

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

SETTLEMENT_PRIORITY

ADDRESS_SOURCE

EMPLOYEE_ADDRESS_CODE

EMPLOYEE_PERSON_ID

EMPLOYEE_PAYMENT_FLAG

EMPLOYEE_ADDRESS_ID

Query

SQL_Statement
SELECT IBY_DOCS.DOCUMENT_AMOUNT,IBY_DOCS.PAYMENT_CURRENCY_CODE,IBY_DOCS.PAYMENT_AMOUNT,IBY_DOCS.ALLOW_REMOVING_DOCUMENT_FLAG,IBY_DOCS.REMIT_TO_LOCATION_ID,IBY_DOCS.STRAIGHT_THROUGH_FLAG,IBY_DOCS.PAYMENT_SERVICE_REQUEST_ID,IBY_DOCS.PAYMENT_METHOD_CODE,IBY_DOCS.EXCLUSIVE_PAYMENT_FLAG,IBY_DOCS.EXT_PAYEE_ID,IBY_DOCS.PAYEE_PARTY_ID,IBY_DOCS.LEGAL_ENTITY_ID,IBY_DOCS.ORG_ID,IBY_DOCS.CREATED_BY,IBY_DOCS.CREATION_DATE,IBY_DOCS.LAST_UPDATED_BY,IBY_DOCS.LAST_UPDATE_DATE,IBY_DOCS.OBJECT_VERSION_NUMBER,IBY_DOCS.CALLING_APP_DOC_UNIQUE_REF1,IBY_DOCS.CALLING_APP_DOC_UNIQUE_REF2,IBY_DOCS.ORG_TYPE,IBY_DOCS.COMPLETED_PMTS_GROUP_ID,IBY_DOCS.REJECTED_DOCS_GROUP_ID,IBY_DOCS.DELIVERY_CHANNEL_CODE,IBY_DOCS.PAYMENT_FORMAT_CODE,IBY_DOCS.PAY_PROC_TRXN_TYPE_CODE,IBY_DOCS.CALLING_APP_ID,IBY_DOCS.CALLING_APP_DOC_REF_NUMBER,IBY_DOCS.DOCUMENT_PAYABLE_ID,IBY_DOCS.PAYMENT_FUNCTION,IBY_DOCS.PAYMENT_DATE,IBY_DOCS.DOCUMENT_DATE,IBY_DOCS.DOCUMENT_TYPE,IBY_DOCS.DOCUMENT_STATUS,IBY_DOCS.DOCUMENT_CURRENCY_CODE,IBY_DOCS.PAYMENT_REASON_CODE,IBY_DOCS.REMITTANCE_MESSAGE1,IBY_DOCS.DOCUMENT_SEQUENCE_ID,IBY_DOCS.DOCUMENT_SEQUENCE_VALUE,IBY_DOCS.DOCUMENT_CATEGORY_CODE,IBY_DOCS.BANK_ASSIGNED_REF_CODE,IBY_DOCS.PO_NUMBER,IBY_DOCS.CALLING_APP_DOC_UNIQUE_REF4,IBY_DOCS.CALLING_APP_DOC_UNIQUE_REF5,IBY_DOCS.LAST_UPDATE_LOGIN,IBY_DOCS.PARTY_SITE_ID,IBY_DOCS.SUPPLIER_SITE_ID,IBY_DOCS.REMITTANCE_MESSAGE2,IBY_DOCS.REMITTANCE_MESSAGE3,IBY_DOCS.PAYMENT_REASON_COMMENTS,IBY_DOCS.ANTICIPATED_VALUE_DATE,IBY_DOCS.DOCUMENT_DESCRIPTION,IBY_DOCS.DOCUMENT_CURRENCY_TAX_AMOUNT,IBY_DOCS.DOCUMENT_CURR_CHARGE_AMOUNT,IBY_DOCS.AMOUNT_WITHHELD,IBY_DOCS.PAYMENT_CURR_DISCOUNT_TAKEN,IBY_DOCS.DISCOUNT_DATE,IBY_DOCS.PAYMENT_DUE_DATE,IBY_DOCS.PAYMENT_PROFILE_ID,IBY_DOCS.PAYMENT_ID,IBY_DOCS.FORMATTING_PAYMENT_ID,IBY_DOCS.INTERNAL_BANK_ACCOUNT_ID,IBY_DOCS.EXTERNAL_BANK_ACCOUNT_ID,IBY_DOCS.BANK_CHARGE_BEARER,IBY_DOCS.INTEREST_RATE,IBY_DOCS.PAYMENT_GROUPING_NUMBER,IBY_DOCS.UNIQUE_REMITTANCE_IDENTIFIER,IBY_DOCS.URI_CHECK_DIGIT,IBY_DOCS.CALLING_APP_DOC_UNIQUE_REF3,IBY_DOCS.BENEFICIARY_PARTY,IBY_DOCS.ATTRIBUTE_CATEGORY,IBY_DOCS.ATTRIBUTE1,IBY_DOCS.ATTRIBUTE2,IBY_DOCS.ATTRIBUTE3,IBY_DOCS.ATTRIBUTE4,IBY_DOCS.ATTRIBUTE5,IBY_DOCS.ATTRIBUTE6,IBY_DOCS.ATTRIBUTE7,IBY_DOCS.ATTRIBUTE8,IBY_DOCS.ATTRIBUTE9,IBY_DOCS.ATTRIBUTE10,IBY_DOCS.ATTRIBUTE11,IBY_DOCS.ATTRIBUTE12,IBY_DOCS.ATTRIBUTE13,IBY_DOCS.ATTRIBUTE14,IBY_DOCS.ATTRIBUTE15,IBY_DOCS.SETTLEMENT_PRIORITY,IBY_DOCS.ADDRESS_SOURCE,IBY_DOCS.EMPLOYEE_ADDRESS_CODE,IBY_DOCS.EMPLOYEE_PERSON_ID,IBY_DOCS.EMPLOYEE_PAYMENT_FLAG,IBY_DOCS.EMPLOYEE_ADDRESS_ID FROM IBY_DOCS_PAYABLE_ALL IBY_DOCS

SQL_Statement

SELECT IBY_DOCS.DOCUMENT_AMOUNT,IBY_DOCS.PAYMENT_CURRENCY_CODE,IBY_DOCS.PAYMENT_AMOUNT,IBY_DOCS.ALLOW_REMOVING_DOCUMENT_FLAG,IBY_DOCS.REMIT_TO_LOCATION_ID,IBY_DOCS.STRAIGHT_THROUGH_FLAG,IBY_DOCS.PAYMENT_SERVICE_REQUEST_ID,IBY_DOCS.PAYMENT_METHOD_CODE,IBY_DOCS.EXCLUSIVE_PAYMENT_FLAG,IBY_DOCS.EXT_PAYEE_ID,IBY_DOCS.PAYEE_PARTY_ID,IBY_DOCS.LEGAL_ENTITY_ID,IBY_DOCS.ORG_ID,IBY_DOCS.CREATED_BY,IBY_DOCS.CREATION_DATE,IBY_DOCS.LAST_UPDATED_BY,IBY_DOCS.LAST_UPDATE_DATE,IBY_DOCS.OBJECT_VERSION_NUMBER,IBY_DOCS.CALLING_APP_DOC_UNIQUE_REF1,IBY_DOCS.CALLING_APP_DOC_UNIQUE_REF2,IBY_DOCS.ORG_TYPE,IBY_DOCS.COMPLETED_PMTS_GROUP_ID,IBY_DOCS.REJECTED_DOCS_GROUP_ID,IBY_DOCS.DELIVERY_CHANNEL_CODE,IBY_DOCS.PAYMENT_FORMAT_CODE,IBY_DOCS.PAY_PROC_TRXN_TYPE_CODE,IBY_DOCS.CALLING_APP_ID,IBY_DOCS.CALLING_APP_DOC_REF_NUMBER,IBY_DOCS.DOCUMENT_PAYABLE_ID,IBY_DOCS.PAYMENT_FUNCTION,IBY_DOCS.PAYMENT_DATE,IBY_DOCS.DOCUMENT_DATE,IBY_DOCS.DOCUMENT_TYPE,IBY_DOCS.DOCUMENT_STATUS,IBY_DOCS.DOCUMENT_CURRENCY_CODE,IBY_DOCS.PAYMENT_REASON_CODE,IBY_DOCS.REMITTANCE_MESSAGE1,IBY_DOCS.DOCUMENT_SEQUENCE_ID,IBY_DOCS.DOCUMENT_SEQUENCE_VALUE,IBY_DOCS.DOCUMENT_CATEGORY_CODE,IBY_DOCS.BANK_ASSIGNED_REF_CODE,IBY_DOCS.PO_NUMBER,IBY_DOCS.CALLING_APP_DOC_UNIQUE_REF4,IBY_DOCS.CALLING_APP_DOC_UNIQUE_REF5,IBY_DOCS.LAST_UPDATE_LOGIN,IBY_DOCS.PARTY_SITE_ID,IBY_DOCS.SUPPLIER_SITE_ID,IBY_DOCS.REMITTANCE_MESSAGE2,IBY_DOCS.REMITTANCE_MESSAGE3,IBY_DOCS.PAYMENT_REASON_COMMENTS,IBY_DOCS.ANTICIPATED_VALUE_DATE,IBY_DOCS.DOCUMENT_DESCRIPTION,IBY_DOCS.DOCUMENT_CURRENCY_TAX_AMOUNT,IBY_DOCS.DOCUMENT_CURR_CHARGE_AMOUNT,IBY_DOCS.AMOUNT_WITHHELD,IBY_DOCS.PAYMENT_CURR_DISCOUNT_TAKEN,IBY_DOCS.DISCOUNT_DATE,IBY_DOCS.PAYMENT_DUE_DATE,IBY_DOCS.PAYMENT_PROFILE_ID,IBY_DOCS.PAYMENT_ID,IBY_DOCS.FORMATTING_PAYMENT_ID,IBY_DOCS.INTERNAL_BANK_ACCOUNT_ID,IBY_DOCS.EXTERNAL_BANK_ACCOUNT_ID,IBY_DOCS.BANK_CHARGE_BEARER,IBY_DOCS.INTEREST_RATE,IBY_DOCS.PAYMENT_GROUPING_NUMBER,IBY_DOCS.UNIQUE_REMITTANCE_IDENTIFIER,IBY_DOCS.URI_CHECK_DIGIT,IBY_DOCS.CALLING_APP_DOC_UNIQUE_REF3,IBY_DOCS.BENEFICIARY_PARTY,IBY_DOCS.ATTRIBUTE_CATEGORY,IBY_DOCS.ATTRIBUTE1,IBY_DOCS.ATTRIBUTE2,IBY_DOCS.ATTRIBUTE3,IBY_DOCS.ATTRIBUTE4,IBY_DOCS.ATTRIBUTE5,IBY_DOCS.ATTRIBUTE6,IBY_DOCS.ATTRIBUTE7,IBY_DOCS.ATTRIBUTE8,IBY_DOCS.ATTRIBUTE9,IBY_DOCS.ATTRIBUTE10,IBY_DOCS.ATTRIBUTE11,IBY_DOCS.ATTRIBUTE12,IBY_DOCS.ATTRIBUTE13,IBY_DOCS.ATTRIBUTE14,IBY_DOCS.ATTRIBUTE15,IBY_DOCS.SETTLEMENT_PRIORITY,IBY_DOCS.ADDRESS_SOURCE,IBY_DOCS.EMPLOYEE_ADDRESS_CODE,IBY_DOCS.EMPLOYEE_PERSON_ID,IBY_DOCS.EMPLOYEE_PAYMENT_FLAG,IBY_DOCS.EMPLOYEE_ADDRESS_ID FROM IBY_DOCS_PAYABLE_ALL IBY_DOCS