VIEW: AP.AP_INVOICES_INTERFACE#

Source

View Text - Preformatted

select INVOICE_ID INVOICE_ID, INVOICE_NUM INVOICE_NUM, INVOICE_TYPE_LOOKUP_CODE INVOICE_TYPE_LOOKUP_CODE, INVOICE_DATE INVOICE_DATE, PO_NUMBER PO_NUMBER, VENDOR_ID VENDOR_ID, VENDOR_NUM VENDOR_NUM, VENDOR_NAME VENDOR_NAME, VENDOR_SITE_ID VENDOR_SITE_ID, VENDOR_SITE_CODE VENDOR_SITE_CODE, INVOICE_AMOUNT INVOICE_AMOUNT, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE, EXCHANGE_RATE EXCHANGE_RATE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, EXCHANGE_DATE EXCHANGE_DATE, TERMS_ID TERMS_ID, TERMS_NAME TERMS_NAME, DESCRIPTION DESCRIPTION, AWT_GROUP_ID AWT_GROUP_ID, AWT_GROUP_NAME AWT_GROUP_NAME, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, STATUS STATUS, SOURCE SOURCE, GROUP_ID GROUP_ID, REQUEST_ID REQUEST_ID, PAYMENT_CROSS_RATE_TYPE PAYMENT_CROSS_RATE_TYPE, PAYMENT_CROSS_RATE_DATE PAYMENT_CROSS_RATE_DATE, PAYMENT_CROSS_RATE PAYMENT_CROSS_RATE, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE, WORKFLOW_FLAG WORKFLOW_FLAG, DOC_CATEGORY_CODE DOC_CATEGORY_CODE, VOUCHER_NUM VOUCHER_NUM, PAYMENT_METHOD_LOOKUP_CODE PAYMENT_METHOD_LOOKUP_CODE, PAY_GROUP_LOOKUP_CODE PAY_GROUP_LOOKUP_CODE, GOODS_RECEIVED_DATE GOODS_RECEIVED_DATE, INVOICE_RECEIVED_DATE INVOICE_RECEIVED_DATE, GL_DATE GL_DATE, ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, EXCLUSIVE_PAYMENT_FLAG EXCLUSIVE_PAYMENT_FLAG, ORG_ID ORG_ID, AMOUNT_APPLICABLE_TO_DISCOUNT AMOUNT_APPLICABLE_TO_DISCOUNT, PREPAY_NUM PREPAY_NUM, PREPAY_DIST_NUM PREPAY_DIST_NUM, PREPAY_APPLY_AMOUNT PREPAY_APPLY_AMOUNT, PREPAY_GL_DATE PREPAY_GL_DATE, INVOICE_INCLUDES_PREPAY_FLAG INVOICE_INCLUDES_PREPAY_FLAG, NO_XRATE_BASE_AMOUNT NO_XRATE_BASE_AMOUNT, VENDOR_EMAIL_ADDRESS VENDOR_EMAIL_ADDRESS, TERMS_DATE TERMS_DATE, REQUESTER_ID REQUESTER_ID, SHIP_TO_LOCATION SHIP_TO_LOCATION, EXTERNAL_DOC_REF EXTERNAL_DOC_REF, PREPAY_LINE_NUM PREPAY_LINE_NUM, REQUESTER_FIRST_NAME REQUESTER_FIRST_NAME, REQUESTER_LAST_NAME REQUESTER_LAST_NAME, APPLICATION_ID APPLICATION_ID, PRODUCT_TABLE PRODUCT_TABLE, REFERENCE_KEY1 REFERENCE_KEY1, REFERENCE_KEY2 REFERENCE_KEY2, REFERENCE_KEY3 REFERENCE_KEY3, REFERENCE_KEY4 REFERENCE_KEY4, REFERENCE_KEY5 REFERENCE_KEY5, APPLY_ADVANCES_FLAG APPLY_ADVANCES_FLAG, CALC_TAX_DURING_IMPORT_FLAG CALC_TAX_DURING_IMPORT_FLAG, CONTROL_AMOUNT CONTROL_AMOUNT, ADD_TAX_TO_INV_AMT_FLAG ADD_TAX_TO_INV_AMT_FLAG, TAX_RELATED_INVOICE_ID TAX_RELATED_INVOICE_ID, TAXATION_COUNTRY TAXATION_COUNTRY, DOCUMENT_SUB_TYPE DOCUMENT_SUB_TYPE, SUPPLIER_TAX_INVOICE_NUMBER SUPPLIER_TAX_INVOICE_NUMBER, SUPPLIER_TAX_INVOICE_DATE SUPPLIER_TAX_INVOICE_DATE, SUPPLIER_TAX_EXCHANGE_RATE SUPPLIER_TAX_EXCHANGE_RATE, TAX_INVOICE_RECORDING_DATE TAX_INVOICE_RECORDING_DATE, TAX_INVOICE_INTERNAL_SEQ TAX_INVOICE_INTERNAL_SEQ, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME, REFERENCE_1 REFERENCE_1, REFERENCE_2 REFERENCE_2, OPERATING_UNIT OPERATING_UNIT, BANK_CHARGE_BEARER BANK_CHARGE_BEARER, REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE1, REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE2, REMITTANCE_MESSAGE3 REMITTANCE_MESSAGE3, UNIQUE_REMITTANCE_IDENTIFIER UNIQUE_REMITTANCE_IDENTIFIER, URI_CHECK_DIGIT URI_CHECK_DIGIT, SETTLEMENT_PRIORITY SETTLEMENT_PRIORITY, PAYMENT_REASON_CODE PAYMENT_REASON_CODE, PAYMENT_REASON_COMMENTS PAYMENT_REASON_COMMENTS, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE, DELIVERY_CHANNEL_CODE DELIVERY_CHANNEL_CODE, PAID_ON_BEHALF_EMPLOYEE_ID PAID_ON_BEHALF_EMPLOYEE_ID, NET_OF_RETAINAGE_FLAG NET_OF_RETAINAGE_FLAG, REQUESTER_EMPLOYEE_NUM REQUESTER_EMPLOYEE_NUM, CUST_REGISTRATION_CODE CUST_REGISTRATION_CODE, CUST_REGISTRATION_NUMBER CUST_REGISTRATION_NUMBER, PARTY_ID PARTY_ID, PARTY_SITE_ID PARTY_SITE_ID, PAY_PROC_TRXN_TYPE_CODE PAY_PROC_TRXN_TYPE_CODE, PAYMENT_FUNCTION PAYMENT_FUNCTION, PAYMENT_PRIORITY PAYMENT_PRIORITY, PORT_OF_ENTRY_CODE PORT_OF_ENTRY_CODE, EXTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID, ACCTS_PAY_CODE_CONCATENATED ACCTS_PAY_CODE_CONCATENATED, PAY_AWT_GROUP_ID PAY_AWT_GROUP_ID, PAY_AWT_GROUP_NAME PAY_AWT_GROUP_NAME, ORIGINAL_INVOICE_AMOUNT ORIGINAL_INVOICE_AMOUNT, DISPUTE_REASON DISPUTE_REASON, REMIT_TO_SUPPLIER_NAME REMIT_TO_SUPPLIER_NAME, REMIT_TO_SUPPLIER_ID REMIT_TO_SUPPLIER_ID, REMIT_TO_SUPPLIER_SITE REMIT_TO_SUPPLIER_SITE, REMIT_TO_SUPPLIER_SITE_ID REMIT_TO_SUPPLIER_SITE_ID, RELATIONSHIP_ID RELATIONSHIP_ID, REMIT_TO_SUPPLIER_NUM REMIT_TO_SUPPLIER_NUM from "AP"."AP_INVOICES_INTERFACE"

View Text - HTML Formatted

SELECT INVOICE_ID INVOICE_ID
, INVOICE_NUM INVOICE_NUM
, INVOICE_TYPE_LOOKUP_CODE INVOICE_TYPE_LOOKUP_CODE
, INVOICE_DATE INVOICE_DATE
, PO_NUMBER PO_NUMBER
, VENDOR_ID VENDOR_ID
, VENDOR_NUM VENDOR_NUM
, VENDOR_NAME VENDOR_NAME
, VENDOR_SITE_ID VENDOR_SITE_ID
, VENDOR_SITE_CODE VENDOR_SITE_CODE
, INVOICE_AMOUNT INVOICE_AMOUNT
, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, EXCHANGE_RATE EXCHANGE_RATE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, EXCHANGE_DATE EXCHANGE_DATE
, TERMS_ID TERMS_ID
, TERMS_NAME TERMS_NAME
, DESCRIPTION DESCRIPTION
, AWT_GROUP_ID AWT_GROUP_ID
, AWT_GROUP_NAME AWT_GROUP_NAME
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, STATUS STATUS
, SOURCE SOURCE
, GROUP_ID GROUP_ID
, REQUEST_ID REQUEST_ID
, PAYMENT_CROSS_RATE_TYPE PAYMENT_CROSS_RATE_TYPE
, PAYMENT_CROSS_RATE_DATE PAYMENT_CROSS_RATE_DATE
, PAYMENT_CROSS_RATE PAYMENT_CROSS_RATE
, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, WORKFLOW_FLAG WORKFLOW_FLAG
, DOC_CATEGORY_CODE DOC_CATEGORY_CODE
, VOUCHER_NUM VOUCHER_NUM
, PAYMENT_METHOD_LOOKUP_CODE PAYMENT_METHOD_LOOKUP_CODE
, PAY_GROUP_LOOKUP_CODE PAY_GROUP_LOOKUP_CODE
, GOODS_RECEIVED_DATE GOODS_RECEIVED_DATE
, INVOICE_RECEIVED_DATE INVOICE_RECEIVED_DATE
, GL_DATE GL_DATE
, ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, EXCLUSIVE_PAYMENT_FLAG EXCLUSIVE_PAYMENT_FLAG
, ORG_ID ORG_ID
, AMOUNT_APPLICABLE_TO_DISCOUNT AMOUNT_APPLICABLE_TO_DISCOUNT
, PREPAY_NUM PREPAY_NUM
, PREPAY_DIST_NUM PREPAY_DIST_NUM
, PREPAY_APPLY_AMOUNT PREPAY_APPLY_AMOUNT
, PREPAY_GL_DATE PREPAY_GL_DATE
, INVOICE_INCLUDES_PREPAY_FLAG INVOICE_INCLUDES_PREPAY_FLAG
, NO_XRATE_BASE_AMOUNT NO_XRATE_BASE_AMOUNT
, VENDOR_EMAIL_ADDRESS VENDOR_EMAIL_ADDRESS
, TERMS_DATE TERMS_DATE
, REQUESTER_ID REQUESTER_ID
, SHIP_TO_LOCATION SHIP_TO_LOCATION
, EXTERNAL_DOC_REF EXTERNAL_DOC_REF
, PREPAY_LINE_NUM PREPAY_LINE_NUM
, REQUESTER_FIRST_NAME REQUESTER_FIRST_NAME
, REQUESTER_LAST_NAME REQUESTER_LAST_NAME
, APPLICATION_ID APPLICATION_ID
, PRODUCT_TABLE PRODUCT_TABLE
, REFERENCE_KEY1 REFERENCE_KEY1
, REFERENCE_KEY2 REFERENCE_KEY2
, REFERENCE_KEY3 REFERENCE_KEY3
, REFERENCE_KEY4 REFERENCE_KEY4
, REFERENCE_KEY5 REFERENCE_KEY5
, APPLY_ADVANCES_FLAG APPLY_ADVANCES_FLAG
, CALC_TAX_DURING_IMPORT_FLAG CALC_TAX_DURING_IMPORT_FLAG
, CONTROL_AMOUNT CONTROL_AMOUNT
, ADD_TAX_TO_INV_AMT_FLAG ADD_TAX_TO_INV_AMT_FLAG
, TAX_RELATED_INVOICE_ID TAX_RELATED_INVOICE_ID
, TAXATION_COUNTRY TAXATION_COUNTRY
, DOCUMENT_SUB_TYPE DOCUMENT_SUB_TYPE
, SUPPLIER_TAX_INVOICE_NUMBER SUPPLIER_TAX_INVOICE_NUMBER
, SUPPLIER_TAX_INVOICE_DATE SUPPLIER_TAX_INVOICE_DATE
, SUPPLIER_TAX_EXCHANGE_RATE SUPPLIER_TAX_EXCHANGE_RATE
, TAX_INVOICE_RECORDING_DATE TAX_INVOICE_RECORDING_DATE
, TAX_INVOICE_INTERNAL_SEQ TAX_INVOICE_INTERNAL_SEQ
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME
, REFERENCE_1 REFERENCE_1
, REFERENCE_2 REFERENCE_2
, OPERATING_UNIT OPERATING_UNIT
, BANK_CHARGE_BEARER BANK_CHARGE_BEARER
, REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE1
, REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE2
, REMITTANCE_MESSAGE3 REMITTANCE_MESSAGE3
, UNIQUE_REMITTANCE_IDENTIFIER UNIQUE_REMITTANCE_IDENTIFIER
, URI_CHECK_DIGIT URI_CHECK_DIGIT
, SETTLEMENT_PRIORITY SETTLEMENT_PRIORITY
, PAYMENT_REASON_CODE PAYMENT_REASON_CODE
, PAYMENT_REASON_COMMENTS PAYMENT_REASON_COMMENTS
, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE
, DELIVERY_CHANNEL_CODE DELIVERY_CHANNEL_CODE
, PAID_ON_BEHALF_EMPLOYEE_ID PAID_ON_BEHALF_EMPLOYEE_ID
, NET_OF_RETAINAGE_FLAG NET_OF_RETAINAGE_FLAG
, REQUESTER_EMPLOYEE_NUM REQUESTER_EMPLOYEE_NUM
, CUST_REGISTRATION_CODE CUST_REGISTRATION_CODE
, CUST_REGISTRATION_NUMBER CUST_REGISTRATION_NUMBER
, PARTY_ID PARTY_ID
, PARTY_SITE_ID PARTY_SITE_ID
, PAY_PROC_TRXN_TYPE_CODE PAY_PROC_TRXN_TYPE_CODE
, PAYMENT_FUNCTION PAYMENT_FUNCTION
, PAYMENT_PRIORITY PAYMENT_PRIORITY
, PORT_OF_ENTRY_CODE PORT_OF_ENTRY_CODE
, EXTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID
, ACCTS_PAY_CODE_CONCATENATED ACCTS_PAY_CODE_CONCATENATED
, PAY_AWT_GROUP_ID PAY_AWT_GROUP_ID
, PAY_AWT_GROUP_NAME PAY_AWT_GROUP_NAME
, ORIGINAL_INVOICE_AMOUNT ORIGINAL_INVOICE_AMOUNT
, DISPUTE_REASON DISPUTE_REASON
, REMIT_TO_SUPPLIER_NAME REMIT_TO_SUPPLIER_NAME
, REMIT_TO_SUPPLIER_ID REMIT_TO_SUPPLIER_ID
, REMIT_TO_SUPPLIER_SITE REMIT_TO_SUPPLIER_SITE
, REMIT_TO_SUPPLIER_SITE_ID REMIT_TO_SUPPLIER_SITE_ID
, RELATIONSHIP_ID RELATIONSHIP_ID
, REMIT_TO_SUPPLIER_NUM REMIT_TO_SUPPLIER_NUM
FROM "AP"."AP_INVOICES_INTERFACE"