VIEW: AP.AP_PREPAY_HISTORY_ALL#

Source

View Text - Preformatted

select PREPAY_HISTORY_ID PREPAY_HISTORY_ID, PREPAY_INVOICE_ID PREPAY_INVOICE_ID, PREPAY_LINE_NUM PREPAY_LINE_NUM, ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID, HISTORICAL_FLAG HISTORICAL_FLAG, INVOICE_ID INVOICE_ID, INVOICE_ADJUSTMENT_EVENT_ID INVOICE_ADJUSTMENT_EVENT_ID, ORG_ID ORG_ID, POSTED_FLAG POSTED_FLAG, RELATED_PREPAY_APP_EVENT_ID RELATED_PREPAY_APP_EVENT_ID, TRANSACTION_TYPE TRANSACTION_TYPE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER, ACCOUNTING_DATE ACCOUNTING_DATE, BC_EVENT_ID BC_EVENT_ID, GAIN_LOSS_INDICATOR GAIN_LOSS_INDICATOR from "AP"."AP_PREPAY_HISTORY_ALL"

View Text - HTML Formatted

SELECT PREPAY_HISTORY_ID PREPAY_HISTORY_ID
, PREPAY_INVOICE_ID PREPAY_INVOICE_ID
, PREPAY_LINE_NUM PREPAY_LINE_NUM
, ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID
, HISTORICAL_FLAG HISTORICAL_FLAG
, INVOICE_ID INVOICE_ID
, INVOICE_ADJUSTMENT_EVENT_ID INVOICE_ADJUSTMENT_EVENT_ID
, ORG_ID ORG_ID
, POSTED_FLAG POSTED_FLAG
, RELATED_PREPAY_APP_EVENT_ID RELATED_PREPAY_APP_EVENT_ID
, TRANSACTION_TYPE TRANSACTION_TYPE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER
, ACCOUNTING_DATE ACCOUNTING_DATE
, BC_EVENT_ID BC_EVENT_ID
, GAIN_LOSS_INDICATOR GAIN_LOSS_INDICATOR
FROM "AP"."AP_PREPAY_HISTORY_ALL"