VIEW: FV.FV_IPAC_IMPORT_HISTORY#

Source

View Text - Preformatted

select IPAC_IMPORT_ID IPAC_IMPORT_ID, BATCH_NAME BATCH_NAME, TRANSACTION_ID TRANSACTION_ID, SUBMITTER_ALC SUBMITTER_ALC, ORIGINATING_ALC ORIGINATING_ALC, CUSTOMER_ALC CUSTOMER_ALC, CONTACT_NAME CONTACT_NAME, CONTACT_EMAIL_ADDRESS CONTACT_EMAIL_ADDRESS, CONTACT_PHONE_NUMBER CONTACT_PHONE_NUMBER, SUMMARY_AMOUNT SUMMARY_AMOUNT, NUMER_OF_DETAIL_LINES NUMER_OF_DETAIL_LINES, ACCOMPLISHED_DATE ACCOMPLISHED_DATE, ACCOUNTING_DATE ACCOUNTING_DATE, DETAIL_LINE_NUMBER DETAIL_LINE_NUMBER, CONTRACT_NUMBER CONTRACT_NUMBER, PURCHASE_ORDER_NUMBER PURCHASE_ORDER_NUMBER, CLIN CLIN, INVOICE_NUMBER INVOICE_NUMBER, REQUISITION_NUMBER REQUISITION_NUMBER, QUANTITY QUANTITY, UNIT_OF_ISSUE UNIT_OF_ISSUE, UNIT_PRICE UNIT_PRICE, DETAIL_AMOUNT DETAIL_AMOUNT, PAY_FLAG PAY_FLAG, FY_OBLIGATION_ID FY_OBLIGATION_ID, RECEIVER_TRES_ACCT_SYMBOL RECEIVER_TRES_ACCT_SYMBOL, RECEIVER_BETC RECEIVER_BETC, RECEIVER_DUNS RECEIVER_DUNS, RECEIVER_DUNS_4 RECEIVER_DUNS_4, SENDER_TRES_ACCT_SYMBOL SENDER_TRES_ACCT_SYMBOL, SENDER_BETC SENDER_BETC, SENDER_DUNS SENDER_DUNS, SENDER_DUNS_4 SENDER_DUNS_4, RECEIVER_DEPARTMENT_CODE RECEIVER_DEPARTMENT_CODE, ACCOUNTING_CLASS_CODE ACCOUNTING_CLASS_CODE, ACRN ACRN, JOB_PROJECT_NUMBER JOB_PROJECT_NUMBER, JAS_NUMBER JAS_NUMBER, FSN_AAA_ADSN FSN_AAA_ADSN, OBLIGATING_DOC_NUMBER OBLIGATING_DOC_NUMBER, ACT_TRACE_NUMBER ACT_TRACE_NUMBER, DESCRIPTION DESCRIPTION, MISC_INFORMATION MISC_INFORMATION, TRANSACTION_TYPE TRANSACTION_TYPE, IPAC_DOC_REF_NUMBER IPAC_DOC_REF_NUMBER, SENDER_DO_SYMBOL SENDER_DO_SYMBOL, DODACC DODACC, TRANSACTION_CONTACT TRANSACTION_CONTACT, TRANSCATION_CONTACT_PHONE TRANSCATION_CONTACT_PHONE, VOUCHER_NUMBER VOUCHER_NUMBER, ORIGINAL_DO_SYMBOL ORIGINAL_DO_SYMBOL, ORIG_ACCOMPLISHED_DATE ORIG_ACCOMPLISHED_DATE, ORIG_ACCOUNTING_DATE ORIG_ACCOUNTING_DATE, ORIG_DOC_REF_NUMBER ORIG_DOC_REF_NUMBER, ORIG_TRANSACTION_TYPE ORIG_TRANSACTION_TYPE, SENDER_SGL_COMMENT SENDER_SGL_COMMENT, RECEIVER_SGL_COMMENT RECEIVER_SGL_COMMENT, SGL_NUMBER1 SGL_NUMBER1, SGL_SENDER_RECEIVER_FLAG1 SGL_SENDER_RECEIVER_FLAG1, SGL_FEDERAL_FLAG1 SGL_FEDERAL_FLAG1, SGL_DEBIT_CREDIT_FLAG1 SGL_DEBIT_CREDIT_FLAG1, SGL_AMOUNT1 SGL_AMOUNT1, SGL_NUMBER2 SGL_NUMBER2, SGL_SENDER_RECEIVER_FLAG2 SGL_SENDER_RECEIVER_FLAG2, SGL_FEDERAL_FLAG2 SGL_FEDERAL_FLAG2, SGL_DEBIT_CREDIT_FLAG2 SGL_DEBIT_CREDIT_FLAG2, SGL_AMOUNT2 SGL_AMOUNT2, SGL_NUMBER3 SGL_NUMBER3, SGL_SENDER_RECEIVER_FLAG3 SGL_SENDER_RECEIVER_FLAG3, SGL_FEDERAL_FLAG3 SGL_FEDERAL_FLAG3, SGL_DEBIT_CREDIT_FLAG3 SGL_DEBIT_CREDIT_FLAG3, SGL_AMOUNT3 SGL_AMOUNT3, SGL_NUMBER4 SGL_NUMBER4, SGL_SENDER_RECEIVER_FLAG4 SGL_SENDER_RECEIVER_FLAG4, SGL_FEDERAL_FLAG4 SGL_FEDERAL_FLAG4, SGL_DEBIT_CREDIT_FLAG4 SGL_DEBIT_CREDIT_FLAG4, SGL_AMOUNT4 SGL_AMOUNT4, SGL_NUMBER5 SGL_NUMBER5, SGL_SENDER_RECEIVER_FLAG5 SGL_SENDER_RECEIVER_FLAG5, SGL_FEDERAL_FLAG5 SGL_FEDERAL_FLAG5, SGL_DEBIT_CREDIT_FLAG5 SGL_DEBIT_CREDIT_FLAG5, SGL_AMOUNT5 SGL_AMOUNT5, SGL_NUMBER6 SGL_NUMBER6, SGL_SENDER_RECEIVER_FLAG6 SGL_SENDER_RECEIVER_FLAG6, SGL_FEDERAL_FLAG6 SGL_FEDERAL_FLAG6, SGL_DEBIT_CREDIT_FLAG6 SGL_DEBIT_CREDIT_FLAG6, SGL_AMOUNT6 SGL_AMOUNT6, SGL_NUMBER7 SGL_NUMBER7, SGL_SENDER_RECEIVER_FLAG7 SGL_SENDER_RECEIVER_FLAG7, SGL_FEDERAL_FLAG7 SGL_FEDERAL_FLAG7, SGL_DEBIT_CREDIT_FLAG7 SGL_DEBIT_CREDIT_FLAG7, SGL_AMOUNT7 SGL_AMOUNT7, SGL_NUMBER8 SGL_NUMBER8, SGL_SENDER_RECEIVER_FLAG8 SGL_SENDER_RECEIVER_FLAG8, SGL_FEDERAL_FLAG8 SGL_FEDERAL_FLAG8, SGL_DEBIT_CREDIT_FLAG8 SGL_DEBIT_CREDIT_FLAG8, SGL_AMOUNT8 SGL_AMOUNT8, SGL_NUMBER9 SGL_NUMBER9, SGL_SENDER_RECEIVER_FLAG9 SGL_SENDER_RECEIVER_FLAG9, SGL_FEDERAL_FLAG9 SGL_FEDERAL_FLAG9, SGL_DEBIT_CREDIT_FLAG9 SGL_DEBIT_CREDIT_FLAG9, SGL_AMOUNT9 SGL_AMOUNT9, SGL_NUMBER10 SGL_NUMBER10, SGL_SENDER_RECEIVER_FLAG10 SGL_SENDER_RECEIVER_FLAG10, SGL_FEDERAL_FLAG10 SGL_FEDERAL_FLAG10, SGL_DEBIT_CREDIT_FLAG10 SGL_DEBIT_CREDIT_FLAG10, SGL_AMOUNT10 SGL_AMOUNT10, SGL_NUMBER11 SGL_NUMBER11, SGL_SENDER_RECEIVER_FLAG11 SGL_SENDER_RECEIVER_FLAG11, SGL_FEDERAL_FLAG11 SGL_FEDERAL_FLAG11, SGL_DEBIT_CREDIT_FLAG11 SGL_DEBIT_CREDIT_FLAG11, SGL_AMOUNT11 SGL_AMOUNT11, SGL_NUMBER12 SGL_NUMBER12, SGL_SENDER_RECEIVER_FLAG12 SGL_SENDER_RECEIVER_FLAG12, SGL_FEDERAL_FLAG12 SGL_FEDERAL_FLAG12, SGL_DEBIT_CREDIT_FLAG12 SGL_DEBIT_CREDIT_FLAG12, SGL_AMOUNT12 SGL_AMOUNT12, SGL_NUMBER13 SGL_NUMBER13, SGL_SENDER_RECEIVER_FLAG13 SGL_SENDER_RECEIVER_FLAG13, SGL_FEDERAL_FLAG13 SGL_FEDERAL_FLAG13, SGL_DEBIT_CREDIT_FLAG13 SGL_DEBIT_CREDIT_FLAG13, SGL_AMOUNT13 SGL_AMOUNT13, SGL_NUMBER14 SGL_NUMBER14, SGL_SENDER_RECEIVER_FLAG14 SGL_SENDER_RECEIVER_FLAG14, SGL_FEDERAL_FLAG14 SGL_FEDERAL_FLAG14, SGL_DEBIT_CREDIT_FLAG14 SGL_DEBIT_CREDIT_FLAG14, SGL_AMOUNT14 SGL_AMOUNT14, SGL_NUMBER15 SGL_NUMBER15, SGL_SENDER_RECEIVER_FLAG15 SGL_SENDER_RECEIVER_FLAG15, SGL_FEDERAL_FLAG15 SGL_FEDERAL_FLAG15, SGL_DEBIT_CREDIT_FLAG15 SGL_DEBIT_CREDIT_FLAG15, SGL_AMOUNT15 SGL_AMOUNT15, SGL_NUMBER16 SGL_NUMBER16, SGL_SENDER_RECEIVER_FLAG16 SGL_SENDER_RECEIVER_FLAG16, SGL_FEDERAL_FLAG16 SGL_FEDERAL_FLAG16, SGL_DEBIT_CREDIT_FLAG16 SGL_DEBIT_CREDIT_FLAG16, SGL_AMOUNT16 SGL_AMOUNT16, RECORD_STATUS RECORD_STATUS, ORG_ID ORG_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, INVOICE_ID INVOICE_ID, INVOICE_LINE_ID INVOICE_LINE_ID, ACTUAL_PO_NUMBER ACTUAL_PO_NUMBER, ACTUAL_PO_LINE_NUMBER ACTUAL_PO_LINE_NUMBER, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, REQUEST_ID REQUEST_ID, GROUP_ID GROUP_ID, DATA_FILE DATA_FILE, INT_INVOICE_ID INT_INVOICE_ID, INT_INVOICE_LINE_ID INT_INVOICE_LINE_ID from "FV"."FV_IPAC_IMPORT_HISTORY"

View Text - HTML Formatted

SELECT IPAC_IMPORT_ID IPAC_IMPORT_ID
, BATCH_NAME BATCH_NAME
, TRANSACTION_ID TRANSACTION_ID
, SUBMITTER_ALC SUBMITTER_ALC
, ORIGINATING_ALC ORIGINATING_ALC
, CUSTOMER_ALC CUSTOMER_ALC
, CONTACT_NAME CONTACT_NAME
, CONTACT_EMAIL_ADDRESS CONTACT_EMAIL_ADDRESS
, CONTACT_PHONE_NUMBER CONTACT_PHONE_NUMBER
, SUMMARY_AMOUNT SUMMARY_AMOUNT
, NUMER_OF_DETAIL_LINES NUMER_OF_DETAIL_LINES
, ACCOMPLISHED_DATE ACCOMPLISHED_DATE
, ACCOUNTING_DATE ACCOUNTING_DATE
, DETAIL_LINE_NUMBER DETAIL_LINE_NUMBER
, CONTRACT_NUMBER CONTRACT_NUMBER
, PURCHASE_ORDER_NUMBER PURCHASE_ORDER_NUMBER
, CLIN CLIN
, INVOICE_NUMBER INVOICE_NUMBER
, REQUISITION_NUMBER REQUISITION_NUMBER
, QUANTITY QUANTITY
, UNIT_OF_ISSUE UNIT_OF_ISSUE
, UNIT_PRICE UNIT_PRICE
, DETAIL_AMOUNT DETAIL_AMOUNT
, PAY_FLAG PAY_FLAG
, FY_OBLIGATION_ID FY_OBLIGATION_ID
, RECEIVER_TRES_ACCT_SYMBOL RECEIVER_TRES_ACCT_SYMBOL
, RECEIVER_BETC RECEIVER_BETC
, RECEIVER_DUNS RECEIVER_DUNS
, RECEIVER_DUNS_4 RECEIVER_DUNS_4
, SENDER_TRES_ACCT_SYMBOL SENDER_TRES_ACCT_SYMBOL
, SENDER_BETC SENDER_BETC
, SENDER_DUNS SENDER_DUNS
, SENDER_DUNS_4 SENDER_DUNS_4
, RECEIVER_DEPARTMENT_CODE RECEIVER_DEPARTMENT_CODE
, ACCOUNTING_CLASS_CODE ACCOUNTING_CLASS_CODE
, ACRN ACRN
, JOB_PROJECT_NUMBER JOB_PROJECT_NUMBER
, JAS_NUMBER JAS_NUMBER
, FSN_AAA_ADSN FSN_AAA_ADSN
, OBLIGATING_DOC_NUMBER OBLIGATING_DOC_NUMBER
, ACT_TRACE_NUMBER ACT_TRACE_NUMBER
, DESCRIPTION DESCRIPTION
, MISC_INFORMATION MISC_INFORMATION
, TRANSACTION_TYPE TRANSACTION_TYPE
, IPAC_DOC_REF_NUMBER IPAC_DOC_REF_NUMBER
, SENDER_DO_SYMBOL SENDER_DO_SYMBOL
, DODACC DODACC
, TRANSACTION_CONTACT TRANSACTION_CONTACT
, TRANSCATION_CONTACT_PHONE TRANSCATION_CONTACT_PHONE
, VOUCHER_NUMBER VOUCHER_NUMBER
, ORIGINAL_DO_SYMBOL ORIGINAL_DO_SYMBOL
, ORIG_ACCOMPLISHED_DATE ORIG_ACCOMPLISHED_DATE
, ORIG_ACCOUNTING_DATE ORIG_ACCOUNTING_DATE
, ORIG_DOC_REF_NUMBER ORIG_DOC_REF_NUMBER
, ORIG_TRANSACTION_TYPE ORIG_TRANSACTION_TYPE
, SENDER_SGL_COMMENT SENDER_SGL_COMMENT
, RECEIVER_SGL_COMMENT RECEIVER_SGL_COMMENT
, SGL_NUMBER1 SGL_NUMBER1
, SGL_SENDER_RECEIVER_FLAG1 SGL_SENDER_RECEIVER_FLAG1
, SGL_FEDERAL_FLAG1 SGL_FEDERAL_FLAG1
, SGL_DEBIT_CREDIT_FLAG1 SGL_DEBIT_CREDIT_FLAG1
, SGL_AMOUNT1 SGL_AMOUNT1
, SGL_NUMBER2 SGL_NUMBER2
, SGL_SENDER_RECEIVER_FLAG2 SGL_SENDER_RECEIVER_FLAG2
, SGL_FEDERAL_FLAG2 SGL_FEDERAL_FLAG2
, SGL_DEBIT_CREDIT_FLAG2 SGL_DEBIT_CREDIT_FLAG2
, SGL_AMOUNT2 SGL_AMOUNT2
, SGL_NUMBER3 SGL_NUMBER3
, SGL_SENDER_RECEIVER_FLAG3 SGL_SENDER_RECEIVER_FLAG3
, SGL_FEDERAL_FLAG3 SGL_FEDERAL_FLAG3
, SGL_DEBIT_CREDIT_FLAG3 SGL_DEBIT_CREDIT_FLAG3
, SGL_AMOUNT3 SGL_AMOUNT3
, SGL_NUMBER4 SGL_NUMBER4
, SGL_SENDER_RECEIVER_FLAG4 SGL_SENDER_RECEIVER_FLAG4
, SGL_FEDERAL_FLAG4 SGL_FEDERAL_FLAG4
, SGL_DEBIT_CREDIT_FLAG4 SGL_DEBIT_CREDIT_FLAG4
, SGL_AMOUNT4 SGL_AMOUNT4
, SGL_NUMBER5 SGL_NUMBER5
, SGL_SENDER_RECEIVER_FLAG5 SGL_SENDER_RECEIVER_FLAG5
, SGL_FEDERAL_FLAG5 SGL_FEDERAL_FLAG5
, SGL_DEBIT_CREDIT_FLAG5 SGL_DEBIT_CREDIT_FLAG5
, SGL_AMOUNT5 SGL_AMOUNT5
, SGL_NUMBER6 SGL_NUMBER6
, SGL_SENDER_RECEIVER_FLAG6 SGL_SENDER_RECEIVER_FLAG6
, SGL_FEDERAL_FLAG6 SGL_FEDERAL_FLAG6
, SGL_DEBIT_CREDIT_FLAG6 SGL_DEBIT_CREDIT_FLAG6
, SGL_AMOUNT6 SGL_AMOUNT6
, SGL_NUMBER7 SGL_NUMBER7
, SGL_SENDER_RECEIVER_FLAG7 SGL_SENDER_RECEIVER_FLAG7
, SGL_FEDERAL_FLAG7 SGL_FEDERAL_FLAG7
, SGL_DEBIT_CREDIT_FLAG7 SGL_DEBIT_CREDIT_FLAG7
, SGL_AMOUNT7 SGL_AMOUNT7
, SGL_NUMBER8 SGL_NUMBER8
, SGL_SENDER_RECEIVER_FLAG8 SGL_SENDER_RECEIVER_FLAG8
, SGL_FEDERAL_FLAG8 SGL_FEDERAL_FLAG8
, SGL_DEBIT_CREDIT_FLAG8 SGL_DEBIT_CREDIT_FLAG8
, SGL_AMOUNT8 SGL_AMOUNT8
, SGL_NUMBER9 SGL_NUMBER9
, SGL_SENDER_RECEIVER_FLAG9 SGL_SENDER_RECEIVER_FLAG9
, SGL_FEDERAL_FLAG9 SGL_FEDERAL_FLAG9
, SGL_DEBIT_CREDIT_FLAG9 SGL_DEBIT_CREDIT_FLAG9
, SGL_AMOUNT9 SGL_AMOUNT9
, SGL_NUMBER10 SGL_NUMBER10
, SGL_SENDER_RECEIVER_FLAG10 SGL_SENDER_RECEIVER_FLAG10
, SGL_FEDERAL_FLAG10 SGL_FEDERAL_FLAG10
, SGL_DEBIT_CREDIT_FLAG10 SGL_DEBIT_CREDIT_FLAG10
, SGL_AMOUNT10 SGL_AMOUNT10
, SGL_NUMBER11 SGL_NUMBER11
, SGL_SENDER_RECEIVER_FLAG11 SGL_SENDER_RECEIVER_FLAG11
, SGL_FEDERAL_FLAG11 SGL_FEDERAL_FLAG11
, SGL_DEBIT_CREDIT_FLAG11 SGL_DEBIT_CREDIT_FLAG11
, SGL_AMOUNT11 SGL_AMOUNT11
, SGL_NUMBER12 SGL_NUMBER12
, SGL_SENDER_RECEIVER_FLAG12 SGL_SENDER_RECEIVER_FLAG12
, SGL_FEDERAL_FLAG12 SGL_FEDERAL_FLAG12
, SGL_DEBIT_CREDIT_FLAG12 SGL_DEBIT_CREDIT_FLAG12
, SGL_AMOUNT12 SGL_AMOUNT12
, SGL_NUMBER13 SGL_NUMBER13
, SGL_SENDER_RECEIVER_FLAG13 SGL_SENDER_RECEIVER_FLAG13
, SGL_FEDERAL_FLAG13 SGL_FEDERAL_FLAG13
, SGL_DEBIT_CREDIT_FLAG13 SGL_DEBIT_CREDIT_FLAG13
, SGL_AMOUNT13 SGL_AMOUNT13
, SGL_NUMBER14 SGL_NUMBER14
, SGL_SENDER_RECEIVER_FLAG14 SGL_SENDER_RECEIVER_FLAG14
, SGL_FEDERAL_FLAG14 SGL_FEDERAL_FLAG14
, SGL_DEBIT_CREDIT_FLAG14 SGL_DEBIT_CREDIT_FLAG14
, SGL_AMOUNT14 SGL_AMOUNT14
, SGL_NUMBER15 SGL_NUMBER15
, SGL_SENDER_RECEIVER_FLAG15 SGL_SENDER_RECEIVER_FLAG15
, SGL_FEDERAL_FLAG15 SGL_FEDERAL_FLAG15
, SGL_DEBIT_CREDIT_FLAG15 SGL_DEBIT_CREDIT_FLAG15
, SGL_AMOUNT15 SGL_AMOUNT15
, SGL_NUMBER16 SGL_NUMBER16
, SGL_SENDER_RECEIVER_FLAG16 SGL_SENDER_RECEIVER_FLAG16
, SGL_FEDERAL_FLAG16 SGL_FEDERAL_FLAG16
, SGL_DEBIT_CREDIT_FLAG16 SGL_DEBIT_CREDIT_FLAG16
, SGL_AMOUNT16 SGL_AMOUNT16
, RECORD_STATUS RECORD_STATUS
, ORG_ID ORG_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, INVOICE_ID INVOICE_ID
, INVOICE_LINE_ID INVOICE_LINE_ID
, ACTUAL_PO_NUMBER ACTUAL_PO_NUMBER
, ACTUAL_PO_LINE_NUMBER ACTUAL_PO_LINE_NUMBER
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, GROUP_ID GROUP_ID
, DATA_FILE DATA_FILE
, INT_INVOICE_ID INT_INVOICE_ID
, INT_INVOICE_LINE_ID INT_INVOICE_LINE_ID
FROM "FV"."FV_IPAC_IMPORT_HISTORY"