FND Design Data [Home] [Help]

Table: HZ_CUST_ACCOUNT_ROLES

Product: AR - Receivables
Description: Roles that parties perform in customer accounts
Implementation/DBA Data: TableAR.HZ_CUST_ACCOUNT_ROLES
Primary Key: HZ_CUST_ACCOUNT_ROLES_PK
  1. ColumnCUST_ACCOUNT_ROLE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
HZ_CUST_ACCOUNT_ROLES FK Joins to TableHZ_PARTIES HZ_CUST_ACCOUNT_ROLES.PARTY_ID
HZ_CUST_ACCOUNT_ROLES FK Joins to TableHZ_CUST_ACCOUNTS HZ_CUST_ACCOUNT_ROLES.CUST_ACCOUNT_ID
HZ_CUST_ACCOUNT_ROLES FK Joins to TableHZ_CUST_ACCT_SITES_ALL HZ_CUST_ACCOUNT_ROLES.CUST_ACCT_SITE_ID
TableAR_BR_TRX_BATCH_RPT FK Joins to HZ_CUST_ACCOUNT_ROLES AR_BR_TRX_BATCH_RPT.DRAWEE_CONTACT_ID
TableAR_CUSTOMER_CALLS_ALL FK Joins to HZ_CUST_ACCOUNT_ROLES AR_CUSTOMER_CALLS_ALL.CONTACT_ID
TableHZ_CUST_CONTACT_POINTS FK Joins to HZ_CUST_ACCOUNT_ROLES HZ_CUST_CONTACT_POINTS.CUST_ACCOUNT_ROLE_ID
TableHZ_CUST_SITE_USES_ALL FK Joins to HZ_CUST_ACCOUNT_ROLES HZ_CUST_SITE_USES_ALL.CONTACT_ID
TableHZ_ROLE_RESPONSIBILITY FK Joins to HZ_CUST_ACCOUNT_ROLES HZ_ROLE_RESPONSIBILITY.CUST_ACCOUNT_ROLE_ID
TableOE_BLANKET_HEADERS_ALL FK Joins to HZ_CUST_ACCOUNT_ROLES OE_BLANKET_HEADERS_ALL.DELIVER_TO_CONTACT_ID
TableOE_BLANKET_HEADERS_ALL FK Joins to HZ_CUST_ACCOUNT_ROLES OE_BLANKET_HEADERS_ALL.SHIP_TO_CONTACT_ID
TableOE_BLANKET_HEADERS_ALL FK Joins to HZ_CUST_ACCOUNT_ROLES OE_BLANKET_HEADERS_ALL.SOLD_TO_CONTACT_ID
TableOE_BLANKET_HEADERS_ALL FK Joins to HZ_CUST_ACCOUNT_ROLES OE_BLANKET_HEADERS_ALL.INVOICE_TO_CONTACT_ID
TableOE_BLANKET_HEADERS_HIST FK Joins to HZ_CUST_ACCOUNT_ROLES OE_BLANKET_HEADERS_HIST.DELIVER_TO_CONTACT_ID
TableOE_BLANKET_HEADERS_HIST FK Joins to HZ_CUST_ACCOUNT_ROLES OE_BLANKET_HEADERS_HIST.SHIP_TO_CONTACT_ID
TableOE_BLANKET_HEADERS_HIST FK Joins to HZ_CUST_ACCOUNT_ROLES OE_BLANKET_HEADERS_HIST.INVOICE_TO_CONTACT_ID
TableOE_BLANKET_HEADERS_HIST FK Joins to HZ_CUST_ACCOUNT_ROLES OE_BLANKET_HEADERS_HIST.SOLD_TO_CONTACT_ID
TableOE_BLANKET_LINES_ALL FK Joins to HZ_CUST_ACCOUNT_ROLES OE_BLANKET_LINES_ALL.DELIVER_TO_CONTACT_ID
TableOE_BLANKET_LINES_ALL FK Joins to HZ_CUST_ACCOUNT_ROLES OE_BLANKET_LINES_ALL.INTMED_SHIP_TO_CONTACT_ID
TableOE_BLANKET_LINES_ALL FK Joins to HZ_CUST_ACCOUNT_ROLES OE_BLANKET_LINES_ALL.INVOICE_TO_CONTACT_ID
TableOE_BLANKET_LINES_ALL FK Joins to HZ_CUST_ACCOUNT_ROLES OE_BLANKET_LINES_ALL.SHIP_TO_CONTACT_ID
TableOE_BLANKET_LINES_HIST FK Joins to HZ_CUST_ACCOUNT_ROLES OE_BLANKET_LINES_HIST.SHIP_TO_CONTACT_ID
TableOE_BLANKET_LINES_HIST FK Joins to HZ_CUST_ACCOUNT_ROLES OE_BLANKET_LINES_HIST.INTMED_SHIP_TO_CONTACT_ID
TableOE_BLANKET_LINES_HIST FK Joins to HZ_CUST_ACCOUNT_ROLES OE_BLANKET_LINES_HIST.INVOICE_TO_CONTACT_ID
TableOE_BLANKET_LINES_HIST FK Joins to HZ_CUST_ACCOUNT_ROLES OE_BLANKET_LINES_HIST.DELIVER_TO_CONTACT_ID
TableOE_HEADER_ACKS FK Joins to HZ_CUST_ACCOUNT_ROLES OE_HEADER_ACKS.END_CUSTOMER_CONTACT_ID
TableOE_LINES_IFACE_ALL FK Joins to HZ_CUST_ACCOUNT_ROLES OE_LINES_IFACE_ALL.END_CUSTOMER_CONTACT_ID
TableOE_LINE_ACKS FK Joins to HZ_CUST_ACCOUNT_ROLES OE_LINE_ACKS.END_CUSTOMER_CONTACT_ID
TableOE_ORDER_HEADERS_ALL FK Joins to HZ_CUST_ACCOUNT_ROLES OE_ORDER_HEADERS_ALL.END_CUSTOMER_CONTACT_ID
TableOE_ORDER_HEADER_HISTORY FK Joins to HZ_CUST_ACCOUNT_ROLES OE_ORDER_HEADER_HISTORY.DELIVER_TO_CONTACT_ID
TableOE_ORDER_HEADER_HISTORY FK Joins to HZ_CUST_ACCOUNT_ROLES OE_ORDER_HEADER_HISTORY.INVOICE_TO_CONTACT_ID
TableOE_ORDER_HEADER_HISTORY FK Joins to HZ_CUST_ACCOUNT_ROLES OE_ORDER_HEADER_HISTORY.SHIP_TO_CONTACT_ID
TableOE_ORDER_HEADER_HISTORY FK Joins to HZ_CUST_ACCOUNT_ROLES OE_ORDER_HEADER_HISTORY.SOLD_TO_CONTACT_ID
TableOE_ORDER_HEADER_HISTORY FK Joins to HZ_CUST_ACCOUNT_ROLES OE_ORDER_HEADER_HISTORY.END_CUSTOMER_CONTACT_ID
TableOE_ORDER_LINES_ALL FK Joins to HZ_CUST_ACCOUNT_ROLES OE_ORDER_LINES_ALL.END_CUSTOMER_CONTACT_ID
TableOE_ORDER_LINES_ALL FK Joins to HZ_CUST_ACCOUNT_ROLES OE_ORDER_LINES_ALL.INTMED_SHIP_TO_CONTACT_ID
TableOE_ORDER_LINES_HISTORY FK Joins to HZ_CUST_ACCOUNT_ROLES OE_ORDER_LINES_HISTORY.END_CUSTOMER_CONTACT_ID
TableOE_ORDER_LINES_HISTORY FK Joins to HZ_CUST_ACCOUNT_ROLES OE_ORDER_LINES_HISTORY.INVOICE_TO_CONTACT_ID
TableOE_ORDER_LINES_HISTORY FK Joins to HZ_CUST_ACCOUNT_ROLES OE_ORDER_LINES_HISTORY.SHIP_TO_CONTACT_ID
TableOE_ORDER_LINES_HISTORY FK Joins to HZ_CUST_ACCOUNT_ROLES OE_ORDER_LINES_HISTORY.DELIVER_TO_CONTACT_ID
TableOE_ORDER_LINES_HISTORY FK Joins to HZ_CUST_ACCOUNT_ROLES OE_ORDER_LINES_HISTORY.INTMED_SHIP_TO_CONTACT_ID
TablePA_PROJECT_CONTACTS FK Joins to HZ_CUST_ACCOUNT_ROLES PA_PROJECT_CONTACTS.CONTACT_ID
TableRA_CUSTOMER_TRX_ALL FK Joins to HZ_CUST_ACCOUNT_ROLES RA_CUSTOMER_TRX_ALL.BILL_TO_CONTACT_ID
TableRA_CUSTOMER_TRX_ALL FK Joins to HZ_CUST_ACCOUNT_ROLES RA_CUSTOMER_TRX_ALL.SHIP_TO_CONTACT_ID
TableRA_CUSTOMER_TRX_ALL FK Joins to HZ_CUST_ACCOUNT_ROLES RA_CUSTOMER_TRX_ALL.DRAWEE_CONTACT_ID
TableRA_CUSTOMER_TRX_ALL FK Joins to HZ_CUST_ACCOUNT_ROLES RA_CUSTOMER_TRX_ALL.SOLD_TO_CONTACT_ID
TableRA_CUSTOMER_TRX_LINES_ALL FK Joins to HZ_CUST_ACCOUNT_ROLES RA_CUSTOMER_TRX_LINES_ALL.SHIP_TO_CONTACT_ID
TableRA_INTERFACE_LINES_ALL FK Joins to HZ_CUST_ACCOUNT_ROLES RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_BILL_CONTACT_ID
TableRA_INTERFACE_LINES_ALL FK Joins to HZ_CUST_ACCOUNT_ROLES RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_SHIP_CONTACT_ID