VIEW: AP.JE_NO_INVEST_LINES#

Source

View Text - Preformatted

select INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID, ACCOUNTING_DATE ACCOUNTING_DATE, ACCRUAL_POSTED_FLAG ACCRUAL_POSTED_FLAG, ASSETS_ADDITION_FLAG ASSETS_ADDITION_FLAG, ASSETS_TRACKING_FLAG ASSETS_TRACKING_FLAG, CASH_POSTED_FLAG CASH_POSTED_FLAG, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER, DIST_CODE_COMBINATION_ID DIST_CODE_COMBINATION_ID, INVOICE_ID INVOICE_ID, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LINE_TYPE_LOOKUP_CODE LINE_TYPE_LOOKUP_CODE, PERIOD_NAME PERIOD_NAME, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID, AMOUNT AMOUNT, BASE_AMOUNT BASE_AMOUNT, BASE_INVOICE_PRICE_VARIANCE BASE_INVOICE_PRICE_VARIANCE, BATCH_ID BATCH_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, DESCRIPTION DESCRIPTION, EXCHANGE_RATE_VARIANCE EXCHANGE_RATE_VARIANCE, FINAL_MATCH_FLAG FINAL_MATCH_FLAG, INCOME_TAX_REGION INCOME_TAX_REGION, INVOICE_PRICE_VARIANCE INVOICE_PRICE_VARIANCE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MATCH_STATUS_FLAG MATCH_STATUS_FLAG, POSTED_FLAG POSTED_FLAG, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, QUANTITY_INVOICED QUANTITY_INVOICED, RATE_VAR_CODE_COMBINATION_ID RATE_VAR_CODE_COMBINATION_ID, REQUEST_ID REQUEST_ID, REVERSAL_FLAG REVERSAL_FLAG, TYPE_1099 TYPE_1099, UNIT_PRICE UNIT_PRICE, VAT_CODE VAT_CODE, AMOUNT_ENCUMBERED AMOUNT_ENCUMBERED, BASE_AMOUNT_ENCUMBERED BASE_AMOUNT_ENCUMBERED, ENCUMBERED_FLAG ENCUMBERED_FLAG, EXCHANGE_DATE EXCHANGE_DATE, EXCHANGE_RATE EXCHANGE_RATE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, PRICE_ADJUSTMENT_FLAG PRICE_ADJUSTMENT_FLAG, PRICE_VAR_CODE_COMBINATION_ID PRICE_VAR_CODE_COMBINATION_ID, QUANTITY_UNENCUMBERED QUANTITY_UNENCUMBERED, STAT_AMOUNT STAT_AMOUNT, AMOUNT_TO_POST AMOUNT_TO_POST, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, BASE_AMOUNT_TO_POST BASE_AMOUNT_TO_POST, CASH_JE_BATCH_ID CASH_JE_BATCH_ID, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, JE_BATCH_ID JE_BATCH_ID, PARENT_INVOICE_ID PARENT_INVOICE_ID, PA_ADDITION_FLAG PA_ADDITION_FLAG, PA_QUANTITY PA_QUANTITY, POSTED_AMOUNT POSTED_AMOUNT, POSTED_BASE_AMOUNT POSTED_BASE_AMOUNT, PREPAY_AMOUNT_REMAINING PREPAY_AMOUNT_REMAINING, PROJECT_ACCOUNTING_CONTEXT PROJECT_ACCOUNTING_CONTEXT, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, USSGL_TRX_CODE_CONTEXT USSGL_TRX_CODE_CONTEXT, EARLIEST_SETTLEMENT_DATE EARLIEST_SETTLEMENT_DATE, REQ_DISTRIBUTION_ID REQ_DISTRIBUTION_ID, QUANTITY_VARIANCE QUANTITY_VARIANCE, BASE_QUANTITY_VARIANCE BASE_QUANTITY_VARIANCE, PACKET_ID PACKET_ID, W_SESSIONID W_SESSIONID, W_ENTRYID W_ENTRYID, ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID, PREPAY_DISTRIBUTION_ID PREPAY_DISTRIBUTION_ID, TAX_CODE_ID TAX_CODE_ID, AWARD_ID AWARD_ID, GMS_BURDENABLE_RAW_COST GMS_BURDENABLE_RAW_COST, DIST_MATCH_TYPE DIST_MATCH_TYPE, RCV_TRANSACTION_ID RCV_TRANSACTION_ID, PARENT_REVERSAL_ID PARENT_REVERSAL_ID, MATCHED_UOM_LOOKUP_CODE MATCHED_UOM_LOOKUP_CODE, AR_INVOICE_ID AR_INVOICE_ID, AR_INVOICE_LINE_NUM AR_INVOICE_LINE_NUM, PA_IC_PROCESSED_FLAG PA_IC_PROCESSED_FLAG, TAX_RECOVERY_RATE TAX_RECOVERY_RATE, TAX_RECOVERY_OVERRIDE_FLAG TAX_RECOVERY_OVERRIDE_FLAG, TAX_RECOVERABLE_FLAG TAX_RECOVERABLE_FLAG, TAX_CODE_OVERRIDE_FLAG TAX_CODE_OVERRIDE_FLAG, MERCHANT_DOCUMENT_NUMBER MERCHANT_DOCUMENT_NUMBER, MERCHANT_NAME MERCHANT_NAME, MERCHANT_REFERENCE MERCHANT_REFERENCE, MERCHANT_TAX_REG_NUMBER MERCHANT_TAX_REG_NUMBER, MERCHANT_TAXPAYER_ID MERCHANT_TAXPAYER_ID, COUNTRY_OF_SUPPLY COUNTRY_OF_SUPPLY, PA_CC_AR_INVOICE_ID PA_CC_AR_INVOICE_ID, PA_CC_AR_INVOICE_LINE_NUM PA_CC_AR_INVOICE_LINE_NUM, PA_CC_PROCESSED_CODE PA_CC_PROCESSED_CODE, CREDIT_CARD_TRX_ID CREDIT_CARD_TRX_ID from "AP"."JE_NO_INVEST_LINES"

View Text - HTML Formatted

SELECT INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
, ACCOUNTING_DATE ACCOUNTING_DATE
, ACCRUAL_POSTED_FLAG ACCRUAL_POSTED_FLAG
, ASSETS_ADDITION_FLAG ASSETS_ADDITION_FLAG
, ASSETS_TRACKING_FLAG ASSETS_TRACKING_FLAG
, CASH_POSTED_FLAG CASH_POSTED_FLAG
, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER
, DIST_CODE_COMBINATION_ID DIST_CODE_COMBINATION_ID
, INVOICE_ID INVOICE_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LINE_TYPE_LOOKUP_CODE LINE_TYPE_LOOKUP_CODE
, PERIOD_NAME PERIOD_NAME
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID
, AMOUNT AMOUNT
, BASE_AMOUNT BASE_AMOUNT
, BASE_INVOICE_PRICE_VARIANCE BASE_INVOICE_PRICE_VARIANCE
, BATCH_ID BATCH_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, DESCRIPTION DESCRIPTION
, EXCHANGE_RATE_VARIANCE EXCHANGE_RATE_VARIANCE
, FINAL_MATCH_FLAG FINAL_MATCH_FLAG
, INCOME_TAX_REGION INCOME_TAX_REGION
, INVOICE_PRICE_VARIANCE INVOICE_PRICE_VARIANCE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MATCH_STATUS_FLAG MATCH_STATUS_FLAG
, POSTED_FLAG POSTED_FLAG
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, QUANTITY_INVOICED QUANTITY_INVOICED
, RATE_VAR_CODE_COMBINATION_ID RATE_VAR_CODE_COMBINATION_ID
, REQUEST_ID REQUEST_ID
, REVERSAL_FLAG REVERSAL_FLAG
, TYPE_1099 TYPE_1099
, UNIT_PRICE UNIT_PRICE
, VAT_CODE VAT_CODE
, AMOUNT_ENCUMBERED AMOUNT_ENCUMBERED
, BASE_AMOUNT_ENCUMBERED BASE_AMOUNT_ENCUMBERED
, ENCUMBERED_FLAG ENCUMBERED_FLAG
, EXCHANGE_DATE EXCHANGE_DATE
, EXCHANGE_RATE EXCHANGE_RATE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, PRICE_ADJUSTMENT_FLAG PRICE_ADJUSTMENT_FLAG
, PRICE_VAR_CODE_COMBINATION_ID PRICE_VAR_CODE_COMBINATION_ID
, QUANTITY_UNENCUMBERED QUANTITY_UNENCUMBERED
, STAT_AMOUNT STAT_AMOUNT
, AMOUNT_TO_POST AMOUNT_TO_POST
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, BASE_AMOUNT_TO_POST BASE_AMOUNT_TO_POST
, CASH_JE_BATCH_ID CASH_JE_BATCH_ID
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, JE_BATCH_ID JE_BATCH_ID
, PARENT_INVOICE_ID PARENT_INVOICE_ID
, PA_ADDITION_FLAG PA_ADDITION_FLAG
, PA_QUANTITY PA_QUANTITY
, POSTED_AMOUNT POSTED_AMOUNT
, POSTED_BASE_AMOUNT POSTED_BASE_AMOUNT
, PREPAY_AMOUNT_REMAINING PREPAY_AMOUNT_REMAINING
, PROJECT_ACCOUNTING_CONTEXT PROJECT_ACCOUNTING_CONTEXT
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, USSGL_TRX_CODE_CONTEXT USSGL_TRX_CODE_CONTEXT
, EARLIEST_SETTLEMENT_DATE EARLIEST_SETTLEMENT_DATE
, REQ_DISTRIBUTION_ID REQ_DISTRIBUTION_ID
, QUANTITY_VARIANCE QUANTITY_VARIANCE
, BASE_QUANTITY_VARIANCE BASE_QUANTITY_VARIANCE
, PACKET_ID PACKET_ID
, W_SESSIONID W_SESSIONID
, W_ENTRYID W_ENTRYID
, ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID
, PREPAY_DISTRIBUTION_ID PREPAY_DISTRIBUTION_ID
, TAX_CODE_ID TAX_CODE_ID
, AWARD_ID AWARD_ID
, GMS_BURDENABLE_RAW_COST GMS_BURDENABLE_RAW_COST
, DIST_MATCH_TYPE DIST_MATCH_TYPE
, RCV_TRANSACTION_ID RCV_TRANSACTION_ID
, PARENT_REVERSAL_ID PARENT_REVERSAL_ID
, MATCHED_UOM_LOOKUP_CODE MATCHED_UOM_LOOKUP_CODE
, AR_INVOICE_ID AR_INVOICE_ID
, AR_INVOICE_LINE_NUM AR_INVOICE_LINE_NUM
, PA_IC_PROCESSED_FLAG PA_IC_PROCESSED_FLAG
, TAX_RECOVERY_RATE TAX_RECOVERY_RATE
, TAX_RECOVERY_OVERRIDE_FLAG TAX_RECOVERY_OVERRIDE_FLAG
, TAX_RECOVERABLE_FLAG TAX_RECOVERABLE_FLAG
, TAX_CODE_OVERRIDE_FLAG TAX_CODE_OVERRIDE_FLAG
, MERCHANT_DOCUMENT_NUMBER MERCHANT_DOCUMENT_NUMBER
, MERCHANT_NAME MERCHANT_NAME
, MERCHANT_REFERENCE MERCHANT_REFERENCE
, MERCHANT_TAX_REG_NUMBER MERCHANT_TAX_REG_NUMBER
, MERCHANT_TAXPAYER_ID MERCHANT_TAXPAYER_ID
, COUNTRY_OF_SUPPLY COUNTRY_OF_SUPPLY
, PA_CC_AR_INVOICE_ID PA_CC_AR_INVOICE_ID
, PA_CC_AR_INVOICE_LINE_NUM PA_CC_AR_INVOICE_LINE_NUM
, PA_CC_PROCESSED_CODE PA_CC_PROCESSED_CODE
, CREDIT_CARD_TRX_ID CREDIT_CARD_TRX_ID
FROM "AP"."JE_NO_INVEST_LINES"