VIEW: AP.AP_MC_INVOICE_DISTS#

Source

View Text - Preformatted

select INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID, INVOICE_ID INVOICE_ID, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, DIST_CODE_COMBINATION_ID DIST_CODE_COMBINATION_ID, AMOUNT AMOUNT, BASE_AMOUNT BASE_AMOUNT, BASE_INVOICE_PRICE_VARIANCE BASE_INVOICE_PRICE_VARIANCE, EXCHANGE_RATE_VARIANCE EXCHANGE_RATE_VARIANCE, RATE_VAR_CODE_COMBINATION_ID RATE_VAR_CODE_COMBINATION_ID, EXCHANGE_DATE EXCHANGE_DATE, EXCHANGE_RATE EXCHANGE_RATE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, RECEIPT_CONVERSION_RATE RECEIPT_CONVERSION_RATE, LINE_TYPE_LOOKUP_CODE LINE_TYPE_LOOKUP_CODE, QUANTITY_INVOICED QUANTITY_INVOICED, AMOUNT_TO_POST AMOUNT_TO_POST, BASE_AMOUNT_TO_POST BASE_AMOUNT_TO_POST, UPGRADE_POSTED_AMT UPGRADE_POSTED_AMT, UPGRADE_BASE_POSTED_AMT UPGRADE_BASE_POSTED_AMT, POSTED_AMOUNT POSTED_AMOUNT, POSTED_BASE_AMOUNT POSTED_BASE_AMOUNT from "AP"."AP_MC_INVOICE_DISTS"

View Text - HTML Formatted

SELECT INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
, INVOICE_ID INVOICE_ID
, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, DIST_CODE_COMBINATION_ID DIST_CODE_COMBINATION_ID
, AMOUNT AMOUNT
, BASE_AMOUNT BASE_AMOUNT
, BASE_INVOICE_PRICE_VARIANCE BASE_INVOICE_PRICE_VARIANCE
, EXCHANGE_RATE_VARIANCE EXCHANGE_RATE_VARIANCE
, RATE_VAR_CODE_COMBINATION_ID RATE_VAR_CODE_COMBINATION_ID
, EXCHANGE_DATE EXCHANGE_DATE
, EXCHANGE_RATE EXCHANGE_RATE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, RECEIPT_CONVERSION_RATE RECEIPT_CONVERSION_RATE
, LINE_TYPE_LOOKUP_CODE LINE_TYPE_LOOKUP_CODE
, QUANTITY_INVOICED QUANTITY_INVOICED
, AMOUNT_TO_POST AMOUNT_TO_POST
, BASE_AMOUNT_TO_POST BASE_AMOUNT_TO_POST
, UPGRADE_POSTED_AMT UPGRADE_POSTED_AMT
, UPGRADE_BASE_POSTED_AMT UPGRADE_BASE_POSTED_AMT
, POSTED_AMOUNT POSTED_AMOUNT
, POSTED_BASE_AMOUNT POSTED_BASE_AMOUNT
FROM "AP"."AP_MC_INVOICE_DISTS"