VIEW: PA.PA_CUST_REV_DIST_LINES_ALL#

Source

View Text - Preformatted

select EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID, LINE_NUM LINE_NUM, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, PROJECT_ID PROJECT_ID, DRAFT_REVENUE_NUM DRAFT_REVENUE_NUM, DRAFT_REVENUE_ITEM_LINE_NUM DRAFT_REVENUE_ITEM_LINE_NUM, AMOUNT AMOUNT, CODE_COMBINATION_ID CODE_COMBINATION_ID, BILL_AMOUNT BILL_AMOUNT, FUNCTION_CODE FUNCTION_CODE, FUNCTION_TRANSACTION_CODE FUNCTION_TRANSACTION_CODE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, BATCH_NAME BATCH_NAME, ADDITIONAL_REVENUE_FLAG ADDITIONAL_REVENUE_FLAG, INVOICE_ELIGIBLE_FLAG INVOICE_ELIGIBLE_FLAG, DRAFT_INVOICE_NUM DRAFT_INVOICE_NUM, DRAFT_INVOICE_ITEM_LINE_NUM DRAFT_INVOICE_ITEM_LINE_NUM, REVERSED_FLAG REVERSED_FLAG, LINE_NUM_REVERSED LINE_NUM_REVERSED, REV_IND_COMPILED_SET_ID REV_IND_COMPILED_SET_ID, INV_IND_COMPILED_SET_ID INV_IND_COMPILED_SET_ID, RAW_COST RAW_COST, ORG_ID ORG_ID, OUTPUT_VAT_TAX_ID OUTPUT_VAT_TAX_ID, OUTPUT_TAX_EXEMPT_FLAG OUTPUT_TAX_EXEMPT_FLAG, OUTPUT_TAX_EXEMPT_REASON_CODE OUTPUT_TAX_EXEMPT_REASON_CODE, OUTPUT_TAX_EXEMPT_NUMBER OUTPUT_TAX_EXEMPT_NUMBER, PRC_GENERATED_FLAG PRC_GENERATED_FLAG, BILL_TRANS_CURRENCY_CODE BILL_TRANS_CURRENCY_CODE, BILL_TRANS_AMOUNT BILL_TRANS_AMOUNT, BILL_TRANS_BILL_AMOUNT BILL_TRANS_BILL_AMOUNT, BILL_RATE BILL_RATE, REVPROC_CURRENCY_CODE REVPROC_CURRENCY_CODE, REVPROC_RATE_TYPE REVPROC_RATE_TYPE, REVPROC_RATE_DATE REVPROC_RATE_DATE, REVPROC_EXCHANGE_RATE REVPROC_EXCHANGE_RATE, INVPROC_CURRENCY_CODE INVPROC_CURRENCY_CODE, INVPROC_RATE_TYPE INVPROC_RATE_TYPE, INVPROC_RATE_DATE INVPROC_RATE_DATE, INVPROC_EXCHANGE_RATE INVPROC_EXCHANGE_RATE, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE, PROJECT_REVENUE_AMOUNT PROJECT_REVENUE_AMOUNT, PROJECT_REV_RATE_TYPE PROJECT_REV_RATE_TYPE, PROJECT_REV_RATE_DATE PROJECT_REV_RATE_DATE, PROJECT_REV_EXCHANGE_RATE PROJECT_REV_EXCHANGE_RATE, PROJECT_BILL_AMOUNT PROJECT_BILL_AMOUNT, PROJECT_INV_RATE_TYPE PROJECT_INV_RATE_TYPE, PROJECT_INV_RATE_DATE PROJECT_INV_RATE_DATE, PROJECT_INV_EXCHANGE_RATE PROJECT_INV_EXCHANGE_RATE, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE, PROJFUNC_REVENUE_AMOUNT PROJFUNC_REVENUE_AMOUNT, PROJFUNC_REV_RATE_TYPE PROJFUNC_REV_RATE_TYPE, PROJFUNC_REV_RATE_DATE PROJFUNC_REV_RATE_DATE, PROJFUNC_REV_EXCHANGE_RATE PROJFUNC_REV_EXCHANGE_RATE, PROJFUNC_BILL_AMOUNT PROJFUNC_BILL_AMOUNT, PROJFUNC_INV_RATE_TYPE PROJFUNC_INV_RATE_TYPE, PROJFUNC_INV_RATE_DATE PROJFUNC_INV_RATE_DATE, PROJFUNC_INV_EXCHANGE_RATE PROJFUNC_INV_EXCHANGE_RATE, FUNDING_CURRENCY_CODE FUNDING_CURRENCY_CODE, FUNDING_REVENUE_AMOUNT FUNDING_REVENUE_AMOUNT, FUNDING_REV_RATE_TYPE FUNDING_REV_RATE_TYPE, FUNDING_REV_RATE_DATE FUNDING_REV_RATE_DATE, FUNDING_REV_EXCHANGE_RATE FUNDING_REV_EXCHANGE_RATE, FUNDING_BILL_AMOUNT FUNDING_BILL_AMOUNT, FUNDING_INV_RATE_TYPE FUNDING_INV_RATE_TYPE, FUNDING_INV_RATE_DATE FUNDING_INV_RATE_DATE, FUNDING_INV_EXCHANGE_RATE FUNDING_INV_EXCHANGE_RATE, LABOR_MULTIPLIER LABOR_MULTIPLIER, DISCOUNT_PERCENTAGE DISCOUNT_PERCENTAGE, AMOUNT_CALCULATION_CODE AMOUNT_CALCULATION_CODE, BILL_MARKUP_PERCENTAGE BILL_MARKUP_PERCENTAGE, RATE_SOURCE_ID RATE_SOURCE_ID, INV_GEN_REJECTION_CODE INV_GEN_REJECTION_CODE, RETN_DRAFT_INVOICE_NUM RETN_DRAFT_INVOICE_NUM, RETN_DRAFT_INVOICE_LINE_NUM RETN_DRAFT_INVOICE_LINE_NUM, RETAINED_AMOUNT RETAINED_AMOUNT, RETENTION_RULE_ID RETENTION_RULE_ID, RATE_DISC_REASON_CODE RATE_DISC_REASON_CODE, OUTPUT_TAX_CLASSIFICATION_CODE OUTPUT_TAX_CLASSIFICATION_CODE, REVTRANS_AMOUNT REVTRANS_AMOUNT, REVTRANS_CURRENCY_CODE REVTRANS_CURRENCY_CODE, REVPROC_REVTRANS_RATE_TYPE REVPROC_REVTRANS_RATE_TYPE, REVPROC_REVTRANS_RATE_DATE REVPROC_REVTRANS_RATE_DATE, REVPROC_REVTRANS_EX_RATE REVPROC_REVTRANS_EX_RATE from "PA"."PA_CUST_REV_DIST_LINES_ALL"

View Text - HTML Formatted

SELECT EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, LINE_NUM LINE_NUM
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, PROJECT_ID PROJECT_ID
, DRAFT_REVENUE_NUM DRAFT_REVENUE_NUM
, DRAFT_REVENUE_ITEM_LINE_NUM DRAFT_REVENUE_ITEM_LINE_NUM
, AMOUNT AMOUNT
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, BILL_AMOUNT BILL_AMOUNT
, FUNCTION_CODE FUNCTION_CODE
, FUNCTION_TRANSACTION_CODE FUNCTION_TRANSACTION_CODE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, BATCH_NAME BATCH_NAME
, ADDITIONAL_REVENUE_FLAG ADDITIONAL_REVENUE_FLAG
, INVOICE_ELIGIBLE_FLAG INVOICE_ELIGIBLE_FLAG
, DRAFT_INVOICE_NUM DRAFT_INVOICE_NUM
, DRAFT_INVOICE_ITEM_LINE_NUM DRAFT_INVOICE_ITEM_LINE_NUM
, REVERSED_FLAG REVERSED_FLAG
, LINE_NUM_REVERSED LINE_NUM_REVERSED
, REV_IND_COMPILED_SET_ID REV_IND_COMPILED_SET_ID
, INV_IND_COMPILED_SET_ID INV_IND_COMPILED_SET_ID
, RAW_COST RAW_COST
, ORG_ID ORG_ID
, OUTPUT_VAT_TAX_ID OUTPUT_VAT_TAX_ID
, OUTPUT_TAX_EXEMPT_FLAG OUTPUT_TAX_EXEMPT_FLAG
, OUTPUT_TAX_EXEMPT_REASON_CODE OUTPUT_TAX_EXEMPT_REASON_CODE
, OUTPUT_TAX_EXEMPT_NUMBER OUTPUT_TAX_EXEMPT_NUMBER
, PRC_GENERATED_FLAG PRC_GENERATED_FLAG
, BILL_TRANS_CURRENCY_CODE BILL_TRANS_CURRENCY_CODE
, BILL_TRANS_AMOUNT BILL_TRANS_AMOUNT
, BILL_TRANS_BILL_AMOUNT BILL_TRANS_BILL_AMOUNT
, BILL_RATE BILL_RATE
, REVPROC_CURRENCY_CODE REVPROC_CURRENCY_CODE
, REVPROC_RATE_TYPE REVPROC_RATE_TYPE
, REVPROC_RATE_DATE REVPROC_RATE_DATE
, REVPROC_EXCHANGE_RATE REVPROC_EXCHANGE_RATE
, INVPROC_CURRENCY_CODE INVPROC_CURRENCY_CODE
, INVPROC_RATE_TYPE INVPROC_RATE_TYPE
, INVPROC_RATE_DATE INVPROC_RATE_DATE
, INVPROC_EXCHANGE_RATE INVPROC_EXCHANGE_RATE
, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE
, PROJECT_REVENUE_AMOUNT PROJECT_REVENUE_AMOUNT
, PROJECT_REV_RATE_TYPE PROJECT_REV_RATE_TYPE
, PROJECT_REV_RATE_DATE PROJECT_REV_RATE_DATE
, PROJECT_REV_EXCHANGE_RATE PROJECT_REV_EXCHANGE_RATE
, PROJECT_BILL_AMOUNT PROJECT_BILL_AMOUNT
, PROJECT_INV_RATE_TYPE PROJECT_INV_RATE_TYPE
, PROJECT_INV_RATE_DATE PROJECT_INV_RATE_DATE
, PROJECT_INV_EXCHANGE_RATE PROJECT_INV_EXCHANGE_RATE
, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE
, PROJFUNC_REVENUE_AMOUNT PROJFUNC_REVENUE_AMOUNT
, PROJFUNC_REV_RATE_TYPE PROJFUNC_REV_RATE_TYPE
, PROJFUNC_REV_RATE_DATE PROJFUNC_REV_RATE_DATE
, PROJFUNC_REV_EXCHANGE_RATE PROJFUNC_REV_EXCHANGE_RATE
, PROJFUNC_BILL_AMOUNT PROJFUNC_BILL_AMOUNT
, PROJFUNC_INV_RATE_TYPE PROJFUNC_INV_RATE_TYPE
, PROJFUNC_INV_RATE_DATE PROJFUNC_INV_RATE_DATE
, PROJFUNC_INV_EXCHANGE_RATE PROJFUNC_INV_EXCHANGE_RATE
, FUNDING_CURRENCY_CODE FUNDING_CURRENCY_CODE
, FUNDING_REVENUE_AMOUNT FUNDING_REVENUE_AMOUNT
, FUNDING_REV_RATE_TYPE FUNDING_REV_RATE_TYPE
, FUNDING_REV_RATE_DATE FUNDING_REV_RATE_DATE
, FUNDING_REV_EXCHANGE_RATE FUNDING_REV_EXCHANGE_RATE
, FUNDING_BILL_AMOUNT FUNDING_BILL_AMOUNT
, FUNDING_INV_RATE_TYPE FUNDING_INV_RATE_TYPE
, FUNDING_INV_RATE_DATE FUNDING_INV_RATE_DATE
, FUNDING_INV_EXCHANGE_RATE FUNDING_INV_EXCHANGE_RATE
, LABOR_MULTIPLIER LABOR_MULTIPLIER
, DISCOUNT_PERCENTAGE DISCOUNT_PERCENTAGE
, AMOUNT_CALCULATION_CODE AMOUNT_CALCULATION_CODE
, BILL_MARKUP_PERCENTAGE BILL_MARKUP_PERCENTAGE
, RATE_SOURCE_ID RATE_SOURCE_ID
, INV_GEN_REJECTION_CODE INV_GEN_REJECTION_CODE
, RETN_DRAFT_INVOICE_NUM RETN_DRAFT_INVOICE_NUM
, RETN_DRAFT_INVOICE_LINE_NUM RETN_DRAFT_INVOICE_LINE_NUM
, RETAINED_AMOUNT RETAINED_AMOUNT
, RETENTION_RULE_ID RETENTION_RULE_ID
, RATE_DISC_REASON_CODE RATE_DISC_REASON_CODE
, OUTPUT_TAX_CLASSIFICATION_CODE OUTPUT_TAX_CLASSIFICATION_CODE
, REVTRANS_AMOUNT REVTRANS_AMOUNT
, REVTRANS_CURRENCY_CODE REVTRANS_CURRENCY_CODE
, REVPROC_REVTRANS_RATE_TYPE REVPROC_REVTRANS_RATE_TYPE
, REVPROC_REVTRANS_RATE_DATE REVPROC_REVTRANS_RATE_DATE
, REVPROC_REVTRANS_EX_RATE REVPROC_REVTRANS_EX_RATE
FROM "PA"."PA_CUST_REV_DIST_LINES_ALL"