FND Design Data [Home] [Help]

Table: PA_DRAFT_INVOICES_ALL

Product: PA - Projects
Description: Information about draft invoices generated for projects
Implementation/DBA Data: TablePA.PA_DRAFT_INVOICES_ALL
Primary Key: PA_DRAFT_INVOICES_PK
  1. ColumnPROJECT_ID
  2. ColumnDRAFT_INVOICE_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
PA_DRAFT_INVOICES_ALL FK Joins to TablePA_PROJECTS_ALL PA_DRAFT_INVOICES_ALL.PROJECT_ID
PA_DRAFT_INVOICES_ALL FK Joins to TableRA_ADDRESSES_ALL PA_DRAFT_INVOICES_ALL.BILL_TO_ADDRESS_ID
PA_DRAFT_INVOICES_ALL FK Joins to TableRA_ADDRESSES_ALL PA_DRAFT_INVOICES_ALL.SHIP_TO_ADDRESS_ID
PA_DRAFT_INVOICES_ALL FK Joins to TableGL_DAILY_CONVERSION_TYPES PA_DRAFT_INVOICES_ALL.INV_RATE_TYPE
PA_DRAFT_INVOICES_ALL FK Joins to TableGL_CODE_COMBINATIONS PA_DRAFT_INVOICES_ALL.RECEIVABLE_CODE_COMBINATION_ID
PA_DRAFT_INVOICES_ALL FK Joins to TableGL_CODE_COMBINATIONS PA_DRAFT_INVOICES_ALL.ROUNDING_CODE_COMBINATION_ID
PA_DRAFT_INVOICES_ALL FK Joins to TableGL_CODE_COMBINATIONS PA_DRAFT_INVOICES_ALL.UNBILLED_CODE_COMBINATION_ID
PA_DRAFT_INVOICES_ALL FK Joins to TableGL_CODE_COMBINATIONS PA_DRAFT_INVOICES_ALL.UNEARNED_CODE_COMBINATION_ID
PA_DRAFT_INVOICES_ALL FK Joins to TableGL_CODE_COMBINATIONS PA_DRAFT_INVOICES_ALL.WOFF_CODE_COMBINATION_ID
PA_DRAFT_INVOICES_ALL FK Joins to TableFND_CURRENCIES PA_DRAFT_INVOICES_ALL.INV_CURRENCY_CODE
PA_DRAFT_INVOICES_ALL FK Joins to TableHZ_CUST_ACCT_SITES_ALL PA_DRAFT_INVOICES_ALL.BILL_TO_ADDRESS_ID
PA_DRAFT_INVOICES_ALL FK Joins to TablePA_AGREEMENTS_ALL PA_DRAFT_INVOICES_ALL.AGREEMENT_ID
PA_DRAFT_INVOICES_ALL FK Joins to TableHZ_CUST_ACCT_SITES_ALL PA_DRAFT_INVOICES_ALL.SHIP_TO_ADDRESS_ID
PA_DRAFT_INVOICES_ALL FK Joins to TableHZ_CUST_ACCOUNTS PA_DRAFT_INVOICES_ALL.CUSTOMER_ID
PA_DRAFT_INVOICES_ALL FK Joins to TableHZ_CUST_ACCOUNTS PA_DRAFT_INVOICES_ALL.BILL_TO_CUSTOMER_ID
PA_DRAFT_INVOICES_ALL FK Joins to TableHZ_CUST_ACCOUNTS PA_DRAFT_INVOICES_ALL.SHIP_TO_CUSTOMER_ID
PA_DRAFT_INVOICES_ALL FK Joins to TablePA_DRAFT_INVOICES_ALL PA_DRAFT_INVOICES_ALL.PROJECT_ID
PA_DRAFT_INVOICES_ALL.DRAFT_INVOICE_NUM_CREDITED
PA_DRAFT_INVOICES_ALL FK Joins to TableRA_CUSTOMER_TRX_ALL PA_DRAFT_INVOICES_ALL.SYSTEM_REFERENCE
TableJAI_PA_DRAFT_INVOICES FK Joins to PA_DRAFT_INVOICES_ALL JAI_PA_DRAFT_INVOICES.PROJECT_ID
JAI_PA_DRAFT_INVOICES.DRAFT_INVOICE_NUM
TablePA_DISTRIBUTION_WARNINGS FK Joins to PA_DRAFT_INVOICES_ALL PA_DISTRIBUTION_WARNINGS.PROJECT_ID
PA_DISTRIBUTION_WARNINGS.DRAFT_INVOICE_NUM
TablePA_DRAFT_INVOICES_ALL FK Joins to PA_DRAFT_INVOICES_ALL PA_DRAFT_INVOICES_ALL.PROJECT_ID
PA_DRAFT_INVOICES_ALL.DRAFT_INVOICE_NUM_CREDITED
TablePA_DRAFT_INVOICE_DETAILS_ALL FK Joins to PA_DRAFT_INVOICES_ALL PA_DRAFT_INVOICE_DETAILS_ALL.PROJECT_ID
PA_DRAFT_INVOICE_DETAILS_ALL.DRAFT_INVOICE_NUM
TablePA_DRAFT_INVOICE_DETAILS_ALL FK Joins to PA_DRAFT_INVOICES_ALL PA_DRAFT_INVOICE_DETAILS_ALL.PROJECT_ID
PA_DRAFT_INVOICE_DETAILS_ALL.ORIG_DRAFT_INVOICE_NUM
TablePA_DRAFT_INVOICE_ITEMS FK Joins to PA_DRAFT_INVOICES_ALL PA_DRAFT_INVOICE_ITEMS.PROJECT_ID
PA_DRAFT_INVOICE_ITEMS.DRAFT_INVOICE_NUM
TablePA_MC_DRAFT_INV_ITEMS FK Joins to PA_DRAFT_INVOICES_ALL PA_MC_DRAFT_INV_ITEMS.PROJECT_ID
PA_MC_DRAFT_INV_ITEMS.DRAFT_INVOICE_NUM