FND Design Data [Home] [Help]

Table: ZX_EXCEPTIONS

Product: ZX - E-Business Tax
Description: This table stores tax rate exceptions for items and product fiscal classifications.Each row specifies the percentage of original tax rate to be treated as an exception for an item or a product fiscal classification during tax calculation.
Implementation/DBA Data: TableZX.ZX_EXCEPTIONS
Primary Key: ZX_EXCEPTIONS_PK
  1. ColumnTAX_EXCEPTION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
ZX_EXCEPTIONS FK Joins to TableMTL_SYSTEM_ITEMS_B ZX_EXCEPTIONS.PRODUCT_ID
ZX_EXCEPTIONS FK Joins to TableHR_ALL_ORGANIZATION_UNITS ZX_EXCEPTIONS.INVENTORY_ORG_ID
ZX_EXCEPTIONS FK Joins to TableZX_DET_FACTOR_TEMPL_B ZX_EXCEPTIONS.DET_FACTOR_TEMPL_CODE
TableZX_LINES FK Joins to ZX_EXCEPTIONS ZX_LINES.TAX_EXCEPTION_ID
TableZX_LINES_SUMMARY FK Joins to ZX_EXCEPTIONS ZX_LINES_SUMMARY.TAX_EXCEPTION_ID