eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: PA_DRAFT_INVOICES_ALL

Product:	PA - Projects
Description:	Information about draft invoices generated for projects
Implementation/DBA Data:	PA.PA_DRAFT_INVOICES_ALL

Primary Key: PA_DRAFT_INVOICES_PK

PROJECT_ID
DRAFT_INVOICE_NUM

Foreign Keys

Table	Foreign Table	Foreign Key Column
PA_DRAFT_INVOICES_ALL	PA_PROJECTS_ALL	PA_DRAFT_INVOICES_ALL.PROJECT_ID
PA_DRAFT_INVOICES_ALL	RA_ADDRESSES_ALL	PA_DRAFT_INVOICES_ALL.BILL_TO_ADDRESS_ID
PA_DRAFT_INVOICES_ALL	RA_ADDRESSES_ALL	PA_DRAFT_INVOICES_ALL.SHIP_TO_ADDRESS_ID
PA_DRAFT_INVOICES_ALL	GL_DAILY_CONVERSION_TYPES	PA_DRAFT_INVOICES_ALL.INV_RATE_TYPE
PA_DRAFT_INVOICES_ALL	GL_CODE_COMBINATIONS	PA_DRAFT_INVOICES_ALL.RECEIVABLE_CODE_COMBINATION_ID
PA_DRAFT_INVOICES_ALL	GL_CODE_COMBINATIONS	PA_DRAFT_INVOICES_ALL.ROUNDING_CODE_COMBINATION_ID
PA_DRAFT_INVOICES_ALL	GL_CODE_COMBINATIONS	PA_DRAFT_INVOICES_ALL.UNBILLED_CODE_COMBINATION_ID
PA_DRAFT_INVOICES_ALL	GL_CODE_COMBINATIONS	PA_DRAFT_INVOICES_ALL.UNEARNED_CODE_COMBINATION_ID
PA_DRAFT_INVOICES_ALL	GL_CODE_COMBINATIONS	PA_DRAFT_INVOICES_ALL.WOFF_CODE_COMBINATION_ID
PA_DRAFT_INVOICES_ALL	FND_CURRENCIES	PA_DRAFT_INVOICES_ALL.INV_CURRENCY_CODE
PA_DRAFT_INVOICES_ALL	HZ_CUST_ACCT_SITES_ALL	PA_DRAFT_INVOICES_ALL.BILL_TO_ADDRESS_ID
PA_DRAFT_INVOICES_ALL	PA_AGREEMENTS_ALL	PA_DRAFT_INVOICES_ALL.AGREEMENT_ID
PA_DRAFT_INVOICES_ALL	HZ_CUST_ACCT_SITES_ALL	PA_DRAFT_INVOICES_ALL.SHIP_TO_ADDRESS_ID
PA_DRAFT_INVOICES_ALL	HZ_CUST_ACCOUNTS	PA_DRAFT_INVOICES_ALL.CUSTOMER_ID
PA_DRAFT_INVOICES_ALL	HZ_CUST_ACCOUNTS	PA_DRAFT_INVOICES_ALL.BILL_TO_CUSTOMER_ID
PA_DRAFT_INVOICES_ALL	HZ_CUST_ACCOUNTS	PA_DRAFT_INVOICES_ALL.SHIP_TO_CUSTOMER_ID
PA_DRAFT_INVOICES_ALL	PA_DRAFT_INVOICES_ALL	PA_DRAFT_INVOICES_ALL.PROJECT_ID PA_DRAFT_INVOICES_ALL.DRAFT_INVOICE_NUM_CREDITED
PA_DRAFT_INVOICES_ALL	RA_CUSTOMER_TRX_ALL	PA_DRAFT_INVOICES_ALL.SYSTEM_REFERENCE
JAI_PA_DRAFT_INVOICES	PA_DRAFT_INVOICES_ALL	JAI_PA_DRAFT_INVOICES.PROJECT_ID JAI_PA_DRAFT_INVOICES.DRAFT_INVOICE_NUM
PA_DISTRIBUTION_WARNINGS	PA_DRAFT_INVOICES_ALL	PA_DISTRIBUTION_WARNINGS.PROJECT_ID PA_DISTRIBUTION_WARNINGS.DRAFT_INVOICE_NUM
PA_DRAFT_INVOICES_ALL	PA_DRAFT_INVOICES_ALL	PA_DRAFT_INVOICES_ALL.PROJECT_ID PA_DRAFT_INVOICES_ALL.DRAFT_INVOICE_NUM_CREDITED
PA_DRAFT_INVOICE_DETAILS_ALL	PA_DRAFT_INVOICES_ALL	PA_DRAFT_INVOICE_DETAILS_ALL.PROJECT_ID PA_DRAFT_INVOICE_DETAILS_ALL.DRAFT_INVOICE_NUM
PA_DRAFT_INVOICE_DETAILS_ALL	PA_DRAFT_INVOICES_ALL	PA_DRAFT_INVOICE_DETAILS_ALL.PROJECT_ID PA_DRAFT_INVOICE_DETAILS_ALL.ORIG_DRAFT_INVOICE_NUM
PA_DRAFT_INVOICE_ITEMS	PA_DRAFT_INVOICES_ALL	PA_DRAFT_INVOICE_ITEMS.PROJECT_ID PA_DRAFT_INVOICE_ITEMS.DRAFT_INVOICE_NUM
PA_MC_DRAFT_INV_ITEMS	PA_DRAFT_INVOICES_ALL	PA_MC_DRAFT_INV_ITEMS.PROJECT_ID PA_MC_DRAFT_INV_ITEMS.DRAFT_INVOICE_NUM