EN
Español
English
Português
    AFW_CATALOG_CODE

    Store the value information of an additional field

    Data model

    Fields

    Field Type Description
    code_cata_id* INT Catalog category identifier
    code_description NVARCHAR (1000) Catalog Description
    code_id* INT Catalog identifier
    code_key NVARCHAR (1000) Catalog name or identifier
    code_order INT Catalog Order Identifier in the Registry
    code_parent_id INT Parent catalog identifier
    code_status* INT Determines the status of the catalog
    code_value NVARCHAR (1000) Catalog Value
    modification_date DATETIME Date of last modification
    modified_by INT Identifier of the last user who modified the record

    Primary Key

    PK_AFW_CATALOG_CODE
    code_id

    References

    Column Referenced Table Referenced column Name
    code_cata_id* dbo.AFW_CATALOG cata_id FK01_AFW_CATALOG_CODE
    code_parent_id dbo.AFW_CATALOG_CODE code_id FK02_AFW_CATALOG_CODE