[Home] [Help] [Dependency Information]

VIEW: PA.PA_DRAFT_INV_ITEMS_AR#

Object Details

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

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

Dependencies

[top of page]

PA

PA_DRAFT_INV_ITEMS_AR

APPS

PA_DRAFT_INV_ITEMS_AR