VIEW: PA.PA_DRAFT_INV_ITEMS_AR#

Source

View Text - Preformatted

select PURGE_BATCH_ID PURGE_BATCH_ID, PURGE_RELEASE PURGE_RELEASE, PURGE_PROJECT_ID PURGE_PROJECT_ID, PROJECT_ID PROJECT_ID, DRAFT_INVOICE_NUM DRAFT_INVOICE_NUM, LINE_NUM LINE_NUM, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, AMOUNT AMOUNT, TEXT TEXT, INVOICE_LINE_TYPE INVOICE_LINE_TYPE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, UNEARNED_REVENUE_CR UNEARNED_REVENUE_CR, UNBILLED_RECEIVABLE_DR UNBILLED_RECEIVABLE_DR, TASK_ID TASK_ID, EVENT_TASK_ID EVENT_TASK_ID, EVENT_NUM EVENT_NUM, SHIP_TO_ADDRESS_ID SHIP_TO_ADDRESS_ID, TAXABLE_FLAG TAXABLE_FLAG, DRAFT_INV_LINE_NUM_CREDITED DRAFT_INV_LINE_NUM_CREDITED, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, INV_AMOUNT INV_AMOUNT, 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, ACCT_AMOUNT ACCT_AMOUNT, ROUNDING_AMOUNT ROUNDING_AMOUNT, UNBILLED_ROUNDING_AMOUNT_DR UNBILLED_ROUNDING_AMOUNT_DR, UNEARNED_ROUNDING_AMOUNT_CR UNEARNED_ROUNDING_AMOUNT_CR, TRANSLATED_TEXT TRANSLATED_TEXT, CC_REV_CODE_COMBINATION_ID CC_REV_CODE_COMBINATION_ID, CC_PROJECT_ID CC_PROJECT_ID, CC_TAX_TASK_ID CC_TAX_TASK_ID, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE, PROJFUNC_BILL_AMOUNT PROJFUNC_BILL_AMOUNT, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE, PROJECT_BILL_AMOUNT PROJECT_BILL_AMOUNT, FUNDING_CURRENCY_CODE FUNDING_CURRENCY_CODE, FUNDING_BILL_AMOUNT FUNDING_BILL_AMOUNT, FUNDING_RATE_DATE FUNDING_RATE_DATE, FUNDING_EXCHANGE_RATE FUNDING_EXCHANGE_RATE, FUNDING_RATE_TYPE FUNDING_RATE_TYPE, INVPROC_CURRENCY_CODE INVPROC_CURRENCY_CODE, BILL_TRANS_CURRENCY_CODE BILL_TRANS_CURRENCY_CODE, BILL_TRANS_BILL_AMOUNT BILL_TRANS_BILL_AMOUNT, RETN_BILLING_METHOD RETN_BILLING_METHOD, RETN_PERCENT_COMPLETE RETN_PERCENT_COMPLETE, RETN_TOTAL_RETENTION RETN_TOTAL_RETENTION, RETN_BILLING_CYCLE_ID RETN_BILLING_CYCLE_ID, RETN_CLIENT_EXTENSION_FLAG RETN_CLIENT_EXTENSION_FLAG, RETN_BILLING_PERCENTAGE RETN_BILLING_PERCENTAGE, RETN_BILLING_AMOUNT RETN_BILLING_AMOUNT, RETENTION_RULE_ID RETENTION_RULE_ID, RETAINED_AMOUNT RETAINED_AMOUNT, RETN_DRAFT_INVOICE_NUM RETN_DRAFT_INVOICE_NUM, RETN_DRAFT_INVOICE_LINE_NUM RETN_DRAFT_INVOICE_LINE_NUM, CREDIT_AMOUNT CREDIT_AMOUNT, CREDIT_PROCESS_FLAG CREDIT_PROCESS_FLAG, OUTPUT_TAX_CLASSIFICATION_CODE OUTPUT_TAX_CLASSIFICATION_CODE from "PA"."PA_DRAFT_INV_ITEMS_AR"

View Text - HTML Formatted

SELECT PURGE_BATCH_ID PURGE_BATCH_ID
, PURGE_RELEASE PURGE_RELEASE
, PURGE_PROJECT_ID PURGE_PROJECT_ID
, PROJECT_ID PROJECT_ID
, DRAFT_INVOICE_NUM DRAFT_INVOICE_NUM
, LINE_NUM LINE_NUM
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, AMOUNT AMOUNT
, TEXT TEXT
, INVOICE_LINE_TYPE INVOICE_LINE_TYPE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, UNEARNED_REVENUE_CR UNEARNED_REVENUE_CR
, UNBILLED_RECEIVABLE_DR UNBILLED_RECEIVABLE_DR
, TASK_ID TASK_ID
, EVENT_TASK_ID EVENT_TASK_ID
, EVENT_NUM EVENT_NUM
, SHIP_TO_ADDRESS_ID SHIP_TO_ADDRESS_ID
, TAXABLE_FLAG TAXABLE_FLAG
, DRAFT_INV_LINE_NUM_CREDITED DRAFT_INV_LINE_NUM_CREDITED
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INV_AMOUNT INV_AMOUNT
, 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
, ACCT_AMOUNT ACCT_AMOUNT
, ROUNDING_AMOUNT ROUNDING_AMOUNT
, UNBILLED_ROUNDING_AMOUNT_DR UNBILLED_ROUNDING_AMOUNT_DR
, UNEARNED_ROUNDING_AMOUNT_CR UNEARNED_ROUNDING_AMOUNT_CR
, TRANSLATED_TEXT TRANSLATED_TEXT
, CC_REV_CODE_COMBINATION_ID CC_REV_CODE_COMBINATION_ID
, CC_PROJECT_ID CC_PROJECT_ID
, CC_TAX_TASK_ID CC_TAX_TASK_ID
, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE
, PROJFUNC_BILL_AMOUNT PROJFUNC_BILL_AMOUNT
, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE
, PROJECT_BILL_AMOUNT PROJECT_BILL_AMOUNT
, FUNDING_CURRENCY_CODE FUNDING_CURRENCY_CODE
, FUNDING_BILL_AMOUNT FUNDING_BILL_AMOUNT
, FUNDING_RATE_DATE FUNDING_RATE_DATE
, FUNDING_EXCHANGE_RATE FUNDING_EXCHANGE_RATE
, FUNDING_RATE_TYPE FUNDING_RATE_TYPE
, INVPROC_CURRENCY_CODE INVPROC_CURRENCY_CODE
, BILL_TRANS_CURRENCY_CODE BILL_TRANS_CURRENCY_CODE
, BILL_TRANS_BILL_AMOUNT BILL_TRANS_BILL_AMOUNT
, RETN_BILLING_METHOD RETN_BILLING_METHOD
, RETN_PERCENT_COMPLETE RETN_PERCENT_COMPLETE
, RETN_TOTAL_RETENTION RETN_TOTAL_RETENTION
, RETN_BILLING_CYCLE_ID RETN_BILLING_CYCLE_ID
, RETN_CLIENT_EXTENSION_FLAG RETN_CLIENT_EXTENSION_FLAG
, RETN_BILLING_PERCENTAGE RETN_BILLING_PERCENTAGE
, RETN_BILLING_AMOUNT RETN_BILLING_AMOUNT
, RETENTION_RULE_ID RETENTION_RULE_ID
, RETAINED_AMOUNT RETAINED_AMOUNT
, RETN_DRAFT_INVOICE_NUM RETN_DRAFT_INVOICE_NUM
, RETN_DRAFT_INVOICE_LINE_NUM RETN_DRAFT_INVOICE_LINE_NUM
, CREDIT_AMOUNT CREDIT_AMOUNT
, CREDIT_PROCESS_FLAG CREDIT_PROCESS_FLAG
, OUTPUT_TAX_CLASSIFICATION_CODE OUTPUT_TAX_CLASSIFICATION_CODE
FROM "PA"."PA_DRAFT_INV_ITEMS_AR"