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: HZ_CUST_ACCOUNT_ROLES

Product:	AR - Receivables
Description:	Roles that parties perform in customer accounts
Implementation/DBA Data:	AR.HZ_CUST_ACCOUNT_ROLES

Primary Key: HZ_CUST_ACCOUNT_ROLES_PK

CUST_ACCOUNT_ROLE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
HZ_CUST_ACCOUNT_ROLES	HZ_PARTIES	HZ_CUST_ACCOUNT_ROLES.PARTY_ID
HZ_CUST_ACCOUNT_ROLES	HZ_CUST_ACCOUNTS	HZ_CUST_ACCOUNT_ROLES.CUST_ACCOUNT_ID
HZ_CUST_ACCOUNT_ROLES	HZ_CUST_ACCT_SITES_ALL	HZ_CUST_ACCOUNT_ROLES.CUST_ACCT_SITE_ID
AR_BR_TRX_BATCH_RPT	HZ_CUST_ACCOUNT_ROLES	AR_BR_TRX_BATCH_RPT.DRAWEE_CONTACT_ID
AR_CUSTOMER_CALLS_ALL	HZ_CUST_ACCOUNT_ROLES	AR_CUSTOMER_CALLS_ALL.CONTACT_ID
HZ_CUST_CONTACT_POINTS	HZ_CUST_ACCOUNT_ROLES	HZ_CUST_CONTACT_POINTS.CUST_ACCOUNT_ROLE_ID
HZ_CUST_SITE_USES_ALL	HZ_CUST_ACCOUNT_ROLES	HZ_CUST_SITE_USES_ALL.CONTACT_ID
HZ_ROLE_RESPONSIBILITY	HZ_CUST_ACCOUNT_ROLES	HZ_ROLE_RESPONSIBILITY.CUST_ACCOUNT_ROLE_ID
OE_BLANKET_HEADERS_ALL	HZ_CUST_ACCOUNT_ROLES	OE_BLANKET_HEADERS_ALL.DELIVER_TO_CONTACT_ID
OE_BLANKET_HEADERS_ALL	HZ_CUST_ACCOUNT_ROLES	OE_BLANKET_HEADERS_ALL.SHIP_TO_CONTACT_ID
OE_BLANKET_HEADERS_ALL	HZ_CUST_ACCOUNT_ROLES	OE_BLANKET_HEADERS_ALL.SOLD_TO_CONTACT_ID
OE_BLANKET_HEADERS_ALL	HZ_CUST_ACCOUNT_ROLES	OE_BLANKET_HEADERS_ALL.INVOICE_TO_CONTACT_ID
OE_BLANKET_HEADERS_HIST	HZ_CUST_ACCOUNT_ROLES	OE_BLANKET_HEADERS_HIST.DELIVER_TO_CONTACT_ID
OE_BLANKET_HEADERS_HIST	HZ_CUST_ACCOUNT_ROLES	OE_BLANKET_HEADERS_HIST.SHIP_TO_CONTACT_ID
OE_BLANKET_HEADERS_HIST	HZ_CUST_ACCOUNT_ROLES	OE_BLANKET_HEADERS_HIST.INVOICE_TO_CONTACT_ID
OE_BLANKET_HEADERS_HIST	HZ_CUST_ACCOUNT_ROLES	OE_BLANKET_HEADERS_HIST.SOLD_TO_CONTACT_ID
OE_BLANKET_LINES_ALL	HZ_CUST_ACCOUNT_ROLES	OE_BLANKET_LINES_ALL.DELIVER_TO_CONTACT_ID
OE_BLANKET_LINES_ALL	HZ_CUST_ACCOUNT_ROLES	OE_BLANKET_LINES_ALL.INTMED_SHIP_TO_CONTACT_ID
OE_BLANKET_LINES_ALL	HZ_CUST_ACCOUNT_ROLES	OE_BLANKET_LINES_ALL.INVOICE_TO_CONTACT_ID
OE_BLANKET_LINES_ALL	HZ_CUST_ACCOUNT_ROLES	OE_BLANKET_LINES_ALL.SHIP_TO_CONTACT_ID
OE_BLANKET_LINES_HIST	HZ_CUST_ACCOUNT_ROLES	OE_BLANKET_LINES_HIST.SHIP_TO_CONTACT_ID
OE_BLANKET_LINES_HIST	HZ_CUST_ACCOUNT_ROLES	OE_BLANKET_LINES_HIST.INTMED_SHIP_TO_CONTACT_ID
OE_BLANKET_LINES_HIST	HZ_CUST_ACCOUNT_ROLES	OE_BLANKET_LINES_HIST.INVOICE_TO_CONTACT_ID
OE_BLANKET_LINES_HIST	HZ_CUST_ACCOUNT_ROLES	OE_BLANKET_LINES_HIST.DELIVER_TO_CONTACT_ID
OE_HEADER_ACKS	HZ_CUST_ACCOUNT_ROLES	OE_HEADER_ACKS.END_CUSTOMER_CONTACT_ID
OE_LINES_IFACE_ALL	HZ_CUST_ACCOUNT_ROLES	OE_LINES_IFACE_ALL.END_CUSTOMER_CONTACT_ID
OE_LINE_ACKS	HZ_CUST_ACCOUNT_ROLES	OE_LINE_ACKS.END_CUSTOMER_CONTACT_ID
OE_ORDER_HEADERS_ALL	HZ_CUST_ACCOUNT_ROLES	OE_ORDER_HEADERS_ALL.END_CUSTOMER_CONTACT_ID
OE_ORDER_HEADER_HISTORY	HZ_CUST_ACCOUNT_ROLES	OE_ORDER_HEADER_HISTORY.DELIVER_TO_CONTACT_ID
OE_ORDER_HEADER_HISTORY	HZ_CUST_ACCOUNT_ROLES	OE_ORDER_HEADER_HISTORY.INVOICE_TO_CONTACT_ID
OE_ORDER_HEADER_HISTORY	HZ_CUST_ACCOUNT_ROLES	OE_ORDER_HEADER_HISTORY.SHIP_TO_CONTACT_ID
OE_ORDER_HEADER_HISTORY	HZ_CUST_ACCOUNT_ROLES	OE_ORDER_HEADER_HISTORY.SOLD_TO_CONTACT_ID
OE_ORDER_HEADER_HISTORY	HZ_CUST_ACCOUNT_ROLES	OE_ORDER_HEADER_HISTORY.END_CUSTOMER_CONTACT_ID
OE_ORDER_LINES_ALL	HZ_CUST_ACCOUNT_ROLES	OE_ORDER_LINES_ALL.END_CUSTOMER_CONTACT_ID
OE_ORDER_LINES_ALL	HZ_CUST_ACCOUNT_ROLES	OE_ORDER_LINES_ALL.INTMED_SHIP_TO_CONTACT_ID
OE_ORDER_LINES_HISTORY	HZ_CUST_ACCOUNT_ROLES	OE_ORDER_LINES_HISTORY.END_CUSTOMER_CONTACT_ID
OE_ORDER_LINES_HISTORY	HZ_CUST_ACCOUNT_ROLES	OE_ORDER_LINES_HISTORY.INVOICE_TO_CONTACT_ID
OE_ORDER_LINES_HISTORY	HZ_CUST_ACCOUNT_ROLES	OE_ORDER_LINES_HISTORY.SHIP_TO_CONTACT_ID
OE_ORDER_LINES_HISTORY	HZ_CUST_ACCOUNT_ROLES	OE_ORDER_LINES_HISTORY.DELIVER_TO_CONTACT_ID
OE_ORDER_LINES_HISTORY	HZ_CUST_ACCOUNT_ROLES	OE_ORDER_LINES_HISTORY.INTMED_SHIP_TO_CONTACT_ID
PA_PROJECT_CONTACTS	HZ_CUST_ACCOUNT_ROLES	PA_PROJECT_CONTACTS.CONTACT_ID
RA_CUSTOMER_TRX_ALL	HZ_CUST_ACCOUNT_ROLES	RA_CUSTOMER_TRX_ALL.BILL_TO_CONTACT_ID
RA_CUSTOMER_TRX_ALL	HZ_CUST_ACCOUNT_ROLES	RA_CUSTOMER_TRX_ALL.SHIP_TO_CONTACT_ID
RA_CUSTOMER_TRX_ALL	HZ_CUST_ACCOUNT_ROLES	RA_CUSTOMER_TRX_ALL.DRAWEE_CONTACT_ID
RA_CUSTOMER_TRX_ALL	HZ_CUST_ACCOUNT_ROLES	RA_CUSTOMER_TRX_ALL.SOLD_TO_CONTACT_ID
RA_CUSTOMER_TRX_LINES_ALL	HZ_CUST_ACCOUNT_ROLES	RA_CUSTOMER_TRX_LINES_ALL.SHIP_TO_CONTACT_ID
RA_INTERFACE_LINES_ALL	HZ_CUST_ACCOUNT_ROLES	RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_BILL_CONTACT_ID
RA_INTERFACE_LINES_ALL	HZ_CUST_ACCOUNT_ROLES	RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_SHIP_CONTACT_ID