FND Design Data [Home] [Help]

Table: RA_CUST_TRX_LINE_SALESREPS_ALL

Product: AR - Receivables
Description: Sales credit assignments for transactions
Implementation/DBA Data: TableAR.RA_CUST_TRX_LINE_SALESREPS_ALL
Primary Key: RA_CUST_TRX_LINE_SALESREPS_PK
  1. ColumnCUST_TRX_LINE_SALESREP_ID
Primary Key: RA_CUST_TRX_LINE_SALESREPS_UK1
  1. ColumnCUSTOMER_TRX_LINE_ID
  2. ColumnSALESREP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
RA_CUST_TRX_LINE_SALESREPS_ALL FK Joins to TableRA_CUSTOMER_TRX_ALL RA_CUST_TRX_LINE_SALESREPS_ALL.CUSTOMER_TRX_ID
RA_CUST_TRX_LINE_SALESREPS_ALL FK Joins to TableRA_SALESREPS_ALL RA_CUST_TRX_LINE_SALESREPS_ALL.SALESREP_ID
RA_CUST_TRX_LINE_SALESREPS_ALL FK Joins to TableRA_CUSTOMER_TRX_LINES_ALL RA_CUST_TRX_LINE_SALESREPS_ALL.CUSTOMER_TRX_LINE_ID
RA_CUST_TRX_LINE_SALESREPS_ALL FK Joins to TableRA_SALESREPS_ALL RA_CUST_TRX_LINE_SALESREPS_ALL.ORIGINAL_LINE_SALESREP_ID
RA_CUST_TRX_LINE_SALESREPS_ALL FK Joins to TableRA_SALESREPS_ALL RA_CUST_TRX_LINE_SALESREPS_ALL.PREV_CUST_TRX_LINE_SALESREP_ID
RA_CUST_TRX_LINE_SALESREPS_ALL FK Joins to TableJTF_RS_GROUPS_B RA_CUST_TRX_LINE_SALESREPS_ALL.REVENUE_SALESGROUP_ID
RA_CUST_TRX_LINE_SALESREPS_ALL FK Joins to TableJTF_RS_GROUPS_B RA_CUST_TRX_LINE_SALESREPS_ALL.NON_REVENUE_SALESGROUP_ID
TableFII_AR_SALES_CREDITS_D_T FK Joins to RA_CUST_TRX_LINE_SALESREPS_ALL FII_AR_SALES_CREDITS_D_T.SALESCREDIT_PK
TableFII_AR_SALES_CREDITS FK Joins to RA_CUST_TRX_LINE_SALESREPS_ALL FII_AR_SALES_CREDITS.SALESCREDIT_PK
TableRA_CUST_TRX_LINE_GL_DIST_ALL FK Joins to RA_CUST_TRX_LINE_SALESREPS_ALL RA_CUST_TRX_LINE_GL_DIST_ALL.CUST_TRX_LINE_SALESREP_ID