FND Design Data [Home] [Help]

Table: ZX_LINES_DET_FACTORS

Product: ZX - E-Business Tax
Description: This table stores transaction related attributes used for tax calculation and reporting. Each row stores a trasnaction line of an event class.
Implementation/DBA Data: TableZX.ZX_LINES_DET_FACTORS
Primary Key: ZX_LINES_DET_FACTORS_PK
  1. ColumnAPPLICATION_ID
  2. ColumnEVENT_CLASS_CODE
  3. ColumnENTITY_CODE
  4. ColumnTRX_ID
  5. ColumnTRX_LINE_ID
  6. ColumnTRX_LEVEL_TYPE
  7. ColumnICX_SESSION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
ZX_LINES_DET_FACTORS FK Joins to TableAR_VAT_TAX_ALL_B ZX_LINES_DET_FACTORS.HISTORICAL_TAX_CODE_ID
ZX_LINES_DET_FACTORS FK Joins to TableHZ_CUST_ACCT_SITES_ALL ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID
ZX_LINES_DET_FACTORS FK Joins to TableHZ_CUST_ACCOUNTS ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID
ZX_LINES_DET_FACTORS FK Joins to TableHZ_CUST_ACCOUNTS ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID
ZX_LINES_DET_FACTORS FK Joins to Table% ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID
ZX_LINES_DET_FACTORS FK Joins to Table% ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID
ZX_LINES_DET_FACTORS FK Joins to Table% ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID
ZX_LINES_DET_FACTORS FK Joins to Table% ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID
ZX_LINES_DET_FACTORS FK Joins to TableHR_ALL_ORGANIZATION_UNITS ZX_LINES_DET_FACTORS.INTERNAL_ORGANIZATION_ID
ZX_LINES_DET_FACTORS FK Joins to Table% ZX_LINES_DET_FACTORS.APPLICATION_ID
ZX_LINES_DET_FACTORS.ENTITY_CODE
ZX_LINES_DET_FACTORS FK Joins to TableZX_EVNT_CLS_MAPPINGS ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID
ZX_LINES_DET_FACTORS FK Joins to TableAP_TAX_CODES_ALL ZX_LINES_DET_FACTORS.HISTORICAL_TAX_CODE_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_EVNT_TYP_MAPPINGS ZX_LINES_DET_FACTORS.APPLICATION_ID
ZX_LINES_DET_FACTORS.ENTITY_CODE
ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE
ZX_LINES_DET_FACTORS.EVENT_TYPE_CODE
ZX_LINES_DET_FACTORS FK Joins to Table% ZX_LINES_DET_FACTORS.LEDGER_ID
ZX_LINES_DET_FACTORS FK Joins to TableFND_CURRENCIES ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE
ZX_LINES_DET_FACTORS FK Joins to TableFND_DOCUMENT_SEQUENCES ZX_LINES_DET_FACTORS.DOC_SEQ_ID
ZX_LINES_DET_FACTORS FK Joins to TableHR_LOCATIONS_ALL ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID
ZX_LINES_DET_FACTORS FK Joins to TableHR_LOCATIONS_ALL ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID
ZX_LINES_DET_FACTORS FK Joins to TableFND_CURRENCIES ZX_LINES_DET_FACTORS.TRX_LINE_CURRENCY_CODE
ZX_LINES_DET_FACTORS FK Joins to TableHZ_LOCATIONS ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID
ZX_LINES_DET_FACTORS FK Joins to TableHZ_LOCATIONS ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID
ZX_LINES_DET_FACTORS FK Joins to TableHR_LOCATIONS_ALL ZX_LINES_DET_FACTORS.POA_LOCATION_ID
ZX_LINES_DET_FACTORS FK Joins to TableHR_LOCATIONS_ALL ZX_LINES_DET_FACTORS.POO_LOCATION_ID
ZX_LINES_DET_FACTORS FK Joins to TableHR_LOCATIONS_ALL ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID
ZX_LINES_DET_FACTORS FK Joins to TableHR_LOCATIONS_ALL ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID
ZX_LINES_DET_FACTORS FK Joins to TableHZ_LOCATIONS ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID
ZX_LINES_DET_FACTORS FK Joins to TableHZ_LOCATIONS ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.SHIP_TO_PARTY_TAX_PROF_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID
ZX_LINES_DET_FACTORS FK Joins to TableHZ_CUST_SITE_USES_ALL ZX_LINES_DET_FACTORS.SHIP_TO_CUST_ACCT_SITE_USE_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.POA_PARTY_TAX_PROF_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.POO_PARTY_TAX_PROF_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.TITLE_TRANS_PARTY_TAX_PROF_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.SHIP_TO_SITE_TAX_PROF_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.POA_SITE_TAX_PROF_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.POO_SITE_TAX_PROF_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.BILL_TO_SITE_TAX_PROF_ID
ZX_LINES_DET_FACTORS FK Joins to TableHZ_CUST_SITE_USES_ALL ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID
ZX_LINES_DET_FACTORS FK Joins to Table% ZX_LINES_DET_FACTORS.REF_DOC_APPLICATION_ID
ZX_LINES_DET_FACTORS.REF_DOC_ENTITY_CODE
ZX_LINES_DET_FACTORS FK Joins to TableHR_LOCATIONS_ALL ZX_LINES_DET_FACTORS.INTERNAL_ORG_LOCATION_ID
ZX_LINES_DET_FACTORS FK Joins to Table% ZX_LINES_DET_FACTORS.APPLIED_FROM_APPLICATION_ID
ZX_LINES_DET_FACTORS.APPLIED_FROM_ENTITY_CODE
ZX_LINES_DET_FACTORS FK Joins to TableGL_CODE_COMBINATIONS ZX_LINES_DET_FACTORS.ACCOUNT_CCID
ZX_LINES_DET_FACTORS FK Joins to Table% ZX_LINES_DET_FACTORS.ADJUSTED_DOC_APPLICATION_ID
ZX_LINES_DET_FACTORS.ADJUSTED_DOC_ENTITY_CODE
ZX_LINES_DET_FACTORS FK Joins to Table% ZX_LINES_DET_FACTORS.APPLIED_TO_APPLICATION_ID
ZX_LINES_DET_FACTORS.APPLIED_TO_ENTITY_CODE
ZX_LINES_DET_FACTORS FK Joins to Table% ZX_LINES_DET_FACTORS.RELATED_DOC_APPLICATION_ID
ZX_LINES_DET_FACTORS.RELATED_DOC_ENTITY_CODE
ZX_LINES_DET_FACTORS FK Joins to TableHR_ALL_ORGANIZATION_UNITS ZX_LINES_DET_FACTORS.FIRST_PTY_ORG_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_EVENT_CLASSES_B ZX_LINES_DET_FACTORS.TAX_EVENT_CLASS_CODE
ZX_LINES_DET_FACTORS FK Joins to Table% ZX_LINES_DET_FACTORS.SOURCE_APPLICATION_ID
ZX_LINES_DET_FACTORS.SOURCE_ENTITY_CODE
ZX_LINES_DET_FACTORS FK Joins to TableZX_EVNT_CLS_TYPS ZX_LINES_DET_FACTORS.TAX_EVENT_CLASS_CODE
ZX_LINES_DET_FACTORS.TAX_EVENT_TYPE_CODE
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.RDNG_SHIP_TO_PTY_TX_PROF_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_PROF_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.RDNG_BILL_TO_PTY_TX_PROF_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_PROF_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.RDNG_SHIP_TO_PTY_TX_P_ST_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.RDNG_BILL_TO_PTY_TX_P_ST_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_LINES ZX_LINES_DET_FACTORS.SOURCE_TAX_LINE_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.MERCHANT_PARTY_TAX_PROF_ID
ZX_LINES_DET_FACTORS FK Joins to TableZX_PARTY_TAX_PROFILE ZX_LINES_DET_FACTORS.HQ_ESTB_PARTY_TAX_PROF_ID
ZX_LINES_DET_FACTORS FK Joins to TableRA_INTERFACE_LINES_ALL ZX_LINES_DET_FACTORS.INTERFACE_LINE_ID
ZX_LINES_DET_FACTORS FK Joins to TableRA_BATCHES_ALL ZX_LINES_DET_FACTORS.TRX_BATCH_ID
ZX_LINES_DET_FACTORS FK Joins to Table% ZX_LINES_DET_FACTORS.REVERSED_APPLN_ID
ZX_LINES_DET_FACTORS.REVERSED_ENTITY_CODE
ZX_LINES_DET_FACTORS FK Joins to TableHZ_CUST_ACCT_SITES_ALL ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID