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 |