IBY_DOCUMENTS_PAYABLE

Details

  • Schema: FUSION

  • Object owner: IBY

  • Object type: VIEW

Columns

Name

PAY_PROC_TRXN_TYPE_CODE

CALLING_APP_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_DOC_REF_NUMBER

CALL_APP_PAY_SERVICE_REQ_CODE

PAYMENT_FUNCTION

PAYMENT_DATE

DOCUMENT_DATE

DOCUMENT_TYPE

DOCUMENT_CURRENCY_CODE

DOCUMENT_AMOUNT

PAYMENT_CURRENCY_CODE

PAYMENT_AMOUNT

PAYMENT_METHOD_CODE

EXCLUSIVE_PAYMENT_FLAG

PAYEE_PARTY_ID

PARTY_SITE_ID

SUPPLIER_SITE_ID

BENEFICIARY_PARTY

LEGAL_ENTITY_ID

ORG_ID

ORG_TYPE

INVOICING_ORG_ID

INVOICING_ORG_TYPE

ALLOW_REMOVING_DOCUMENT_FLAG

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

ANTICIPATED_VALUE_DATE

PO_NUMBER

DOCUMENT_DESCRIPTION

DOCUMENT_CURRENCY_TAX_AMOUNT

DOCUMENT_CURR_CHARGE_AMOUNT

AMOUNT_WITHHELD

PAYMENT_CURR_DISCOUNT_TAKEN

DISCOUNT_DATE

PAYMENT_DUE_DATE

PAYMENT_PROFILE_ID

INTERNAL_BANK_ACCOUNT_ID

EXTERNAL_BANK_ACCOUNT_ID

BANK_CHARGE_BEARER

INTEREST_RATE

PAYMENT_GROUPING_NUMBER

PAYMENT_REASON_CODE

PAYMENT_REASON_COMMENTS

SETTLEMENT_PRIORITY

REMITTANCE_MESSAGE1

REMITTANCE_MESSAGE2

REMITTANCE_MESSAGE3

UNIQUE_REMITTANCE_IDENTIFIER

URI_CHECK_DIGIT

DELIVERY_CHANNEL_CODE

PAYMENT_FORMAT_CODE

DOCUMENT_SEQUENCE_ID

DOCUMENT_SEQUENCE_VALUE

DOCUMENT_CATEGORY_CODE

BANK_ASSIGNED_REF_CODE

REMIT_TO_LOCATION_ID

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ADDRESS_SOURCE

EMPLOYEE_ADDRESS_CODE

EMPLOYEE_PERSON_ID

EMPLOYEE_PAYMENT_FLAG

EMPLOYEE_ADDRESS_ID

Query

SQL_Statement

SELECT

IBY_GEN_DOCS_PAYABLE.PAY_PROC_TRXN_TYPE_CODE PAY_PROC_TRXN_TYPE_CODE,

IBY_GEN_DOCS_PAYABLE.CALLING_APP_ID CALLING_APP_ID,

IBY_GEN_DOCS_PAYABLE.CALLING_APP_DOC_UNIQUE_REF1 CALLING_APP_DOC_UNIQUE_REF1,

IBY_GEN_DOCS_PAYABLE.CALLING_APP_DOC_UNIQUE_REF2 CALLING_APP_DOC_UNIQUE_REF2,

IBY_GEN_DOCS_PAYABLE.CALLING_APP_DOC_UNIQUE_REF3 CALLING_APP_DOC_UNIQUE_REF3,

IBY_GEN_DOCS_PAYABLE.CALLING_APP_DOC_UNIQUE_REF4 CALLING_APP_DOC_UNIQUE_REF4,

IBY_GEN_DOCS_PAYABLE.CALLING_APP_DOC_UNIQUE_REF5 CALLING_APP_DOC_UNIQUE_REF5,

IBY_GEN_DOCS_PAYABLE.CALLING_APP_DOC_REF_NUMBER CALLING_APP_DOC_REF_NUMBER,

IBY_GEN_DOCS_PAYABLE.CALL_APP_PAY_SERVICE_REQ_CODE CALL_APP_PAY_SERVICE_REQ_CODE,

IBY_GEN_DOCS_PAYABLE.PAYMENT_FUNCTION PAYMENT_FUNCTION,

IBY_GEN_DOCS_PAYABLE.PAYMENT_DATE PAYMENT_DATE,

IBY_GEN_DOCS_PAYABLE.DOCUMENT_DATE DOCUMENT_DATE,

IBY_GEN_DOCS_PAYABLE.DOCUMENT_TYPE DOCUMENT_TYPE,

IBY_GEN_DOCS_PAYABLE.DOCUMENT_CURRENCY_CODE DOCUMENT_CURRENCY_CODE,

IBY_GEN_DOCS_PAYABLE.DOCUMENT_AMOUNT DOCUMENT_AMOUNT,

IBY_GEN_DOCS_PAYABLE.PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE,

IBY_GEN_DOCS_PAYABLE.PAYMENT_AMOUNT PAYMENT_AMOUNT,

IBY_GEN_DOCS_PAYABLE.PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE,

IBY_GEN_DOCS_PAYABLE.EXCLUSIVE_PAYMENT_FLAG EXCLUSIVE_PAYMENT_FLAG,

IBY_GEN_DOCS_PAYABLE.PAYEE_PARTY_ID PAYEE_PARTY_ID,

IBY_GEN_DOCS_PAYABLE.PARTY_SITE_ID PARTY_SITE_ID,

IBY_GEN_DOCS_PAYABLE.SUPPLIER_SITE_ID SUPPLIER_SITE_ID,

IBY_GEN_DOCS_PAYABLE.BENEFICIARY_PARTY BENEFICIARY_PARTY,

IBY_GEN_DOCS_PAYABLE.LEGAL_ENTITY_ID LEGAL_ENTITY_ID,

IBY_GEN_DOCS_PAYABLE.ORG_ID ORG_ID,

IBY_GEN_DOCS_PAYABLE.ORG_TYPE ORG_TYPE,

IBY_GEN_DOCS_PAYABLE.INVOICING_ORG_ID INVOICING_ORG_ID,

IBY_GEN_DOCS_PAYABLE.INVOICING_ORG_TYPE INVOICING_ORG_TYPE,

IBY_GEN_DOCS_PAYABLE.ALLOW_REMOVING_DOCUMENT_FLAG ALLOW_REMOVING_DOCUMENT_FLAG,

IBY_GEN_DOCS_PAYABLE.CREATED_BY CREATED_BY,

IBY_GEN_DOCS_PAYABLE.CREATION_DATE CREATION_DATE,

IBY_GEN_DOCS_PAYABLE.LAST_UPDATED_BY LAST_UPDATED_BY,

IBY_GEN_DOCS_PAYABLE.LAST_UPDATE_DATE LAST_UPDATE_DATE,

IBY_GEN_DOCS_PAYABLE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

IBY_GEN_DOCS_PAYABLE.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

IBY_GEN_DOCS_PAYABLE.ANTICIPATED_VALUE_DATE ANTICIPATED_VALUE_DATE,

IBY_GEN_DOCS_PAYABLE.PO_NUMBER PO_NUMBER,

IBY_GEN_DOCS_PAYABLE.DOCUMENT_DESCRIPTION DOCUMENT_DESCRIPTION,

IBY_GEN_DOCS_PAYABLE.DOCUMENT_CURRENCY_TAX_AMOUNT DOCUMENT_CURRENCY_TAX_AMOUNT,

IBY_GEN_DOCS_PAYABLE.DOCUMENT_CURR_CHARGE_AMOUNT DOCUMENT_CURR_CHARGE_AMOUNT,

IBY_GEN_DOCS_PAYABLE.AMOUNT_WITHHELD AMOUNT_WITHHELD,

IBY_GEN_DOCS_PAYABLE.PAYMENT_CURR_DISCOUNT_TAKEN PAYMENT_CURR_DISCOUNT_TAKEN,

IBY_GEN_DOCS_PAYABLE.DISCOUNT_DATE DISCOUNT_DATE,

IBY_GEN_DOCS_PAYABLE.PAYMENT_DUE_DATE PAYMENT_DUE_DATE,

IBY_GEN_DOCS_PAYABLE.PAYMENT_PROFILE_ID PAYMENT_PROFILE_ID,

IBY_GEN_DOCS_PAYABLE.INTERNAL_BANK_ACCOUNT_ID INTERNAL_BANK_ACCOUNT_ID,

IBY_GEN_DOCS_PAYABLE.EXTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID,

IBY_GEN_DOCS_PAYABLE.BANK_CHARGE_BEARER BANK_CHARGE_BEARER,

IBY_GEN_DOCS_PAYABLE.INTEREST_RATE INTEREST_RATE,

IBY_GEN_DOCS_PAYABLE.PAYMENT_GROUPING_NUMBER PAYMENT_GROUPING_NUMBER,

IBY_GEN_DOCS_PAYABLE.PAYMENT_REASON_CODE PAYMENT_REASON_CODE,

IBY_GEN_DOCS_PAYABLE.PAYMENT_REASON_COMMENTS PAYMENT_REASON_COMMENTS,

IBY_GEN_DOCS_PAYABLE.SETTLEMENT_PRIORITY SETTLEMENT_PRIORITY,

IBY_GEN_DOCS_PAYABLE.REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE1,

IBY_GEN_DOCS_PAYABLE.REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE2,

IBY_GEN_DOCS_PAYABLE.REMITTANCE_MESSAGE3 REMITTANCE_MESSAGE3,

IBY_GEN_DOCS_PAYABLE.UNIQUE_REMITTANCE_IDENTIFIER UNIQUE_REMITTANCE_IDENTIFIER,

IBY_GEN_DOCS_PAYABLE.URI_CHECK_DIGIT URI_CHECK_DIGIT,

IBY_GEN_DOCS_PAYABLE.DELIVERY_CHANNEL_CODE DELIVERY_CHANNEL_CODE,

IBY_GEN_DOCS_PAYABLE.PAYMENT_FORMAT_CODE PAYMENT_FORMAT_CODE,

IBY_GEN_DOCS_PAYABLE.DOCUMENT_SEQUENCE_ID DOCUMENT_SEQUENCE_ID,

IBY_GEN_DOCS_PAYABLE.DOCUMENT_SEQUENCE_VALUE DOCUMENT_SEQUENCE_VALUE,

IBY_GEN_DOCS_PAYABLE.DOCUMENT_CATEGORY_CODE DOCUMENT_CATEGORY_CODE,

IBY_GEN_DOCS_PAYABLE.BANK_ASSIGNED_REF_CODE BANK_ASSIGNED_REF_CODE,

IBY_GEN_DOCS_PAYABLE.REMIT_TO_LOCATION_ID REMIT_TO_LOCATION_ID,

IBY_GEN_DOCS_PAYABLE.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

IBY_GEN_DOCS_PAYABLE.ATTRIBUTE1 ATTRIBUTE1,

IBY_GEN_DOCS_PAYABLE.ATTRIBUTE2 ATTRIBUTE2,

IBY_GEN_DOCS_PAYABLE.ATTRIBUTE3 ATTRIBUTE3,

IBY_GEN_DOCS_PAYABLE.ATTRIBUTE4 ATTRIBUTE4,

IBY_GEN_DOCS_PAYABLE.ATTRIBUTE5 ATTRIBUTE5,

IBY_GEN_DOCS_PAYABLE.ATTRIBUTE6 ATTRIBUTE6,

IBY_GEN_DOCS_PAYABLE.ATTRIBUTE7 ATTRIBUTE7,

IBY_GEN_DOCS_PAYABLE.ATTRIBUTE8 ATTRIBUTE8,

IBY_GEN_DOCS_PAYABLE.ATTRIBUTE9 ATTRIBUTE9,

IBY_GEN_DOCS_PAYABLE.ATTRIBUTE10 ATTRIBUTE10,

IBY_GEN_DOCS_PAYABLE.ATTRIBUTE11 ATTRIBUTE11,

IBY_GEN_DOCS_PAYABLE.ATTRIBUTE12 ATTRIBUTE12,

IBY_GEN_DOCS_PAYABLE.ATTRIBUTE13 ATTRIBUTE13,

IBY_GEN_DOCS_PAYABLE.ATTRIBUTE14 ATTRIBUTE14,

IBY_GEN_DOCS_PAYABLE.ATTRIBUTE15 ATTRIBUTE15,

IBY_GEN_DOCS_PAYABLE.ADDRESS_SOURCE ADDRESS_SOURCE,

IBY_GEN_DOCS_PAYABLE.EMPLOYEE_ADDRESS_CODE EMPLOYEE_ADDRESS_CODE,

IBY_GEN_DOCS_PAYABLE.EMPLOYEE_PERSON_ID EMPLOYEE_PERSON_ID,

IBY_GEN_DOCS_PAYABLE.EMPLOYEE_PAYMENT_FLAG EMPLOYEE_PAYMENT_FLAG,

IBY_GEN_DOCS_PAYABLE.EMPLOYEE_ADDRESS_ID EMPLOYEE_ADDRESS_ID

FROM

IBY_GEN_DOCS_PAYABLE