FND Design Data [Home] [Help]

Table: ZX_FC_CODES_DENORM_B

Product: ZX - E-Business Tax
Description: This table stores relations data for fiscal classification code hierarchies in denormalized form. There is one row for each classification code that is present in the hierarchy.
Implementation/DBA Data: TableZX.ZX_FC_CODES_DENORM_B
Primary Key: ZX_FC_CODES_DENORM_B_PK
  1. ColumnCLASSIFICATION_TYPE_CODE
  2. ColumnLANGUAGE
  3. ColumnCLASSIFICATION_CODE
  4. ColumnANCESTOR_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
ZX_FC_CODES_DENORM_B FK Joins to TableZX_FC_CODES_B ZX_FC_CODES_DENORM_B.CLASSIFICATION_ID
ZX_FC_CODES_DENORM_B FK Joins to TableFND_TERRITORIES ZX_FC_CODES_DENORM_B.COUNTRY_CODE
ZX_FC_CODES_DENORM_B FK Joins to TableFND_LANGUAGES ZX_FC_CODES_DENORM_B.LANGUAGE