FND Design Data [Home] [Help]

Table: ZX_PARTY_TAX_PROFILE

Product: ZX - E-Business Tax
Description: This table stores tax profiles for third parties, third party sites, third party providers, first party legal entities, first party legal establishments, operating units and tax authorities.
Implementation/DBA Data: TableZX.ZX_PARTY_TAX_PROFILE
Primary Key: ZX_PARTY_TAX_PROFILE_PK
  1. ColumnPARTY_TAX_PROFILE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
ZX_PARTY_TAX_PROFILE FK Joins to TableHZ_PARTIES ZX_PARTY_TAX_PROFILE.PARTY_ID
ZX_PARTY_TAX_PROFILE FK Joins to TableHZ_PARTY_SITES ZX_PARTY_TAX_PROFILE.PARTY_ID
ZX_PARTY_TAX_PROFILE FK Joins to TableFND_TERRITORIES ZX_PARTY_TAX_PROFILE.COUNTRY_CODE
TableZX_API_REGISTRATIONS FK Joins to ZX_PARTY_TAX_PROFILE ZX_API_REGISTRATIONS.API_OWNER_ID
TableZX_CONTENT_SOURCES FK Joins to ZX_PARTY_TAX_PROFILE ZX_CONTENT_SOURCES.PROVIDER_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.SHIP_TO_PARTY_TAX_PROF_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.POA_PARTY_TAX_PROF_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.POO_PARTY_TAX_PROF_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.TITLE_TRANS_PARTY_TAX_PROF_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.SHIP_TO_SITE_TAX_PROF_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.POA_SITE_TAX_PROF_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.POO_SITE_TAX_PROF_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.BILL_TO_SITE_TAX_PROF_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.RDNG_SHIP_TO_PTY_TX_PROF_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_PROF_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.RDNG_BILL_TO_PTY_TX_PROF_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_PROF_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.RDNG_SHIP_TO_PTY_TX_P_ST_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.RDNG_BILL_TO_PTY_TX_P_ST_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.MERCHANT_PARTY_TAX_PROF_ID
TableZX_LINES_DET_FACTORS FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.HQ_ESTB_PARTY_TAX_PROF_ID
TableZX_LINES FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES.CONTENT_OWNER_ID
TableZX_LINES FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES.HQ_ESTB_PARTY_TAX_PROF_ID
TableZX_LINES FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID
TableZX_LINES FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES.TAX_PROVIDER_ID
TableZX_LINES_SUMMARY FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_SUMMARY.CONTENT_OWNER_ID
TableZX_LINES_SUMMARY FK Joins to ZX_PARTY_TAX_PROFILE ZX_LINES_SUMMARY.TAX_PROVIDER_ID
TableZX_PROCESS_RESULTS FK Joins to ZX_PARTY_TAX_PROFILE ZX_PROCESS_RESULTS.CONTENT_OWNER_ID
TableZX_REC_NREC_DIST FK Joins to ZX_PARTY_TAX_PROFILE ZX_REC_NREC_DIST.CONTENT_OWNER_ID
TableZX_REGIMES_B FK Joins to ZX_PARTY_TAX_PROFILE ZX_REGIMES_B.REP_TAX_AUTHORITY_ID
TableZX_REGIMES_B FK Joins to ZX_PARTY_TAX_PROFILE ZX_REGIMES_B.COLL_TAX_AUTHORITY_ID
TableZX_REGIMES_USAGES FK Joins to ZX_PARTY_TAX_PROFILE ZX_REGIMES_USAGES.FIRST_PTY_ORG_ID
TableZX_REGISTRATIONS FK Joins to ZX_PARTY_TAX_PROFILE ZX_REGISTRATIONS.PARTY_TAX_PROFILE_ID
TableZX_REGISTRATIONS FK Joins to ZX_PARTY_TAX_PROFILE ZX_REGISTRATIONS.TAX_AUTHORITY_ID
TableZX_REGISTRATIONS FK Joins to ZX_PARTY_TAX_PROFILE ZX_REGISTRATIONS.COLL_TAX_AUTHORITY_ID
TableZX_REGISTRATIONS FK Joins to ZX_PARTY_TAX_PROFILE ZX_REGISTRATIONS.REP_TAX_AUTHORITY_ID
TableZX_RULES_B FK Joins to ZX_PARTY_TAX_PROFILE ZX_RULES_B.CONTENT_OWNER_ID
TableZX_SRVC_SUBSCRIPTIONS FK Joins to ZX_PARTY_TAX_PROFILE ZX_SRVC_SUBSCRIPTIONS.SRVC_PROVIDER_ID
TableZX_STATUS_B FK Joins to ZX_PARTY_TAX_PROFILE ZX_STATUS_B.CONTENT_OWNER_ID
TableZX_SUBSCRIPTION_DETAILS FK Joins to ZX_PARTY_TAX_PROFILE ZX_SUBSCRIPTION_DETAILS.FIRST_PTY_ORG_ID
TableZX_SUBSCRIPTION_DETAILS FK Joins to ZX_PARTY_TAX_PROFILE ZX_SUBSCRIPTION_DETAILS.PARENT_FIRST_PTY_ORG_ID
TableZX_SUBSCRIPTION_OPTIONS FK Joins to ZX_PARTY_TAX_PROFILE ZX_SUBSCRIPTION_OPTIONS.PARENT_FIRST_PTY_ORG_ID
TableZX_TAXES_B FK Joins to ZX_PARTY_TAX_PROFILE ZX_TAXES_B.CONTENT_OWNER_ID
TableZX_TAXES_B FK Joins to ZX_PARTY_TAX_PROFILE ZX_TAXES_B.REP_TAX_AUTHORITY_ID
TableZX_TAXES_B FK Joins to ZX_PARTY_TAX_PROFILE ZX_TAXES_B.COLL_TAX_AUTHORITY_ID
TableZX_TRX_LINE_APP_REGIMES FK Joins to ZX_PARTY_TAX_PROFILE ZX_TRX_LINE_APP_REGIMES.TAX_PROVIDER_ID