VIEW: PN.PN_PAYMENT_ITEMS_EFC#

Source

View Text - Preformatted

select PAYMENT_ITEM_ID PAYMENT_ITEM_ID, DUE_DATE DUE_DATE, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, CURRENCY_CODE CURRENCY_CODE, EXPORT_CURRENCY_CODE EXPORT_CURRENCY_CODE, RATE RATE, PAYMENT_ITEM_TYPE_LOOKUP_CODE PAYMENT_ITEM_TYPE_LOOKUP_CODE, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID, PAYMENT_TERM_ID PAYMENT_TERM_ID, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, ACTUAL_AMOUNT ACTUAL_AMOUNT, EXPORT_CURRENCY_AMOUNT EXPORT_CURRENCY_AMOUNT, ESTIMATED_AMOUNT ESTIMATED_AMOUNT, PERIOD_FRACTION PERIOD_FRACTION, EXPORT_TO_AP_FLAG EXPORT_TO_AP_FLAG, TRANSFERRED_TO_AP_FLAG TRANSFERRED_TO_AP_FLAG, AP_INVOICE_NUM AP_INVOICE_NUM, GROUP_ID GROUP_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID, EXPORT_TO_AR_FLAG EXPORT_TO_AR_FLAG, TRANSFERRED_TO_AR_FLAG TRANSFERRED_TO_AR_FLAG, AR_TRX_NUM AR_TRX_NUM, EXPORT_GROUP_ID EXPORT_GROUP_ID, ORG_ID ORG_ID from "PN"."PN_PAYMENT_ITEMS_EFC"

View Text - HTML Formatted

SELECT PAYMENT_ITEM_ID PAYMENT_ITEM_ID
, DUE_DATE DUE_DATE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CURRENCY_CODE CURRENCY_CODE
, EXPORT_CURRENCY_CODE EXPORT_CURRENCY_CODE
, RATE RATE
, PAYMENT_ITEM_TYPE_LOOKUP_CODE PAYMENT_ITEM_TYPE_LOOKUP_CODE
, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, PAYMENT_TERM_ID PAYMENT_TERM_ID
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, ACTUAL_AMOUNT ACTUAL_AMOUNT
, EXPORT_CURRENCY_AMOUNT EXPORT_CURRENCY_AMOUNT
, ESTIMATED_AMOUNT ESTIMATED_AMOUNT
, PERIOD_FRACTION PERIOD_FRACTION
, EXPORT_TO_AP_FLAG EXPORT_TO_AP_FLAG
, TRANSFERRED_TO_AP_FLAG TRANSFERRED_TO_AP_FLAG
, AP_INVOICE_NUM AP_INVOICE_NUM
, GROUP_ID GROUP_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, EXPORT_TO_AR_FLAG EXPORT_TO_AR_FLAG
, TRANSFERRED_TO_AR_FLAG TRANSFERRED_TO_AR_FLAG
, AR_TRX_NUM AR_TRX_NUM
, EXPORT_GROUP_ID EXPORT_GROUP_ID
, ORG_ID ORG_ID
FROM "PN"."PN_PAYMENT_ITEMS_EFC"