VIEW: PA.PA_DRAFT_INVOICE_ITEMS#

Source

View Text - Preformatted

select 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, INV_RATE_TYPE INV_RATE_TYPE, INV_RATE_DATE INV_RATE_DATE, INV_EXCHANGE_RATE INV_EXCHANGE_RATE, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, GLOBAL_ATTRIBUTE21 GLOBAL_ATTRIBUTE21, GLOBAL_ATTRIBUTE22 GLOBAL_ATTRIBUTE22, GLOBAL_ATTRIBUTE23 GLOBAL_ATTRIBUTE23, GLOBAL_ATTRIBUTE24 GLOBAL_ATTRIBUTE24, GLOBAL_ATTRIBUTE25 GLOBAL_ATTRIBUTE25, GLOBAL_ATTRIBUTE26 GLOBAL_ATTRIBUTE26, GLOBAL_ATTRIBUTE27 GLOBAL_ATTRIBUTE27, GLOBAL_ATTRIBUTE28 GLOBAL_ATTRIBUTE28, GLOBAL_ATTRIBUTE29 GLOBAL_ATTRIBUTE29, GLOBAL_ATTRIBUTE30 GLOBAL_ATTRIBUTE30, PROVIDER_ORGANIZATION_ID PROVIDER_ORGANIZATION_ID, RECEIVER_ORGANIZATION_ID RECEIVER_ORGANIZATION_ID from "PA"."PA_DRAFT_INVOICE_ITEMS"

View Text - HTML Formatted

SELECT 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
, INV_RATE_TYPE INV_RATE_TYPE
, INV_RATE_DATE INV_RATE_DATE
, INV_EXCHANGE_RATE INV_EXCHANGE_RATE
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE21 GLOBAL_ATTRIBUTE21
, GLOBAL_ATTRIBUTE22 GLOBAL_ATTRIBUTE22
, GLOBAL_ATTRIBUTE23 GLOBAL_ATTRIBUTE23
, GLOBAL_ATTRIBUTE24 GLOBAL_ATTRIBUTE24
, GLOBAL_ATTRIBUTE25 GLOBAL_ATTRIBUTE25
, GLOBAL_ATTRIBUTE26 GLOBAL_ATTRIBUTE26
, GLOBAL_ATTRIBUTE27 GLOBAL_ATTRIBUTE27
, GLOBAL_ATTRIBUTE28 GLOBAL_ATTRIBUTE28
, GLOBAL_ATTRIBUTE29 GLOBAL_ATTRIBUTE29
, GLOBAL_ATTRIBUTE30 GLOBAL_ATTRIBUTE30
, PROVIDER_ORGANIZATION_ID PROVIDER_ORGANIZATION_ID
, RECEIVER_ORGANIZATION_ID RECEIVER_ORGANIZATION_ID
FROM "PA"."PA_DRAFT_INVOICE_ITEMS"