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_AGREEMENTS_ALL

Product:	PA - Projects
Description:	Customer contracts that serve as the basis for work authorization
Implementation/DBA Data:	PA.PA_AGREEMENTS_ALL

Primary Key: PA_AGREEMENTS_PK

AGREEMENT_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PA_AGREEMENTS_ALL	PA_AGREEMENT_TYPES	PA_AGREEMENTS_ALL.AGREEMENT_TYPE
PA_AGREEMENTS_ALL	RA_CUSTOMERS	PA_AGREEMENTS_ALL.CUSTOMER_ID
PA_AGREEMENTS_ALL	RA_TERMS_B	PA_AGREEMENTS_ALL.TERM_ID
PA_AGREEMENTS_ALL	HZ_CUST_ACCOUNTS	PA_AGREEMENTS_ALL.CUSTOMER_ID
OKE_K_FUNDING_SOURCES	PA_AGREEMENTS_ALL	OKE_K_FUNDING_SOURCES.AGREEMENT_NUMBER
PA_BUDGET_VERSIONS	PA_AGREEMENTS_ALL	PA_BUDGET_VERSIONS.AGREEMENT_ID
PA_DRAFT_INVOICES_ALL	PA_AGREEMENTS_ALL	PA_DRAFT_INVOICES_ALL.AGREEMENT_ID
PA_DRAFT_REVENUES_ALL	PA_AGREEMENTS_ALL	PA_DRAFT_REVENUES_ALL.AGREEMENT_ID
PA_PROJECT_FUNDINGS	PA_AGREEMENTS_ALL	PA_PROJECT_FUNDINGS.AGREEMENT_ID
PA_PROJECT_RETENTIONS	PA_AGREEMENTS_ALL	PA_PROJECT_RETENTIONS.AGREEMENT_ID
PA_SUMMARY_PROJECT_FUNDINGS	PA_AGREEMENTS_ALL	PA_SUMMARY_PROJECT_FUNDINGS.AGREEMENT_ID
PA_SUMMARY_PROJECT_RETN	PA_AGREEMENTS_ALL	PA_SUMMARY_PROJECT_RETN.AGREEMENT_ID