EN
Español
English
Português
    ASMS_CONTRACT

    It contains the information of accounting documents (CONTRACTS-INVOICES-OTHER DOCUMENTS) for the execution of a work or work

    Data model

    Fields

    Field Type Description
    area_id INT Identifier of the area related to the contract, reference the table AFW_GROUPS.grou_id
    area_id_contract INT Group identifier related to the contract, reference the table AFW_GROUPS.grou_id
    class_id INT Document Class Identifier
    con_modified_date DATETIME Date of last modification of the document
    con_modifier_id INT User ID related to the last modification of the document, reference the table AFW_USERS.user_id
    contractfin DATETIME Document end date
    contractid* INT Unique Object Identifier
    contractini DATETIME Document Start Date
    contractvalue NUMERIC Contract Value
    days_warranty INT Contract Warranty Value in Days
    fl_int_has_alarm* BIT Indicates whether the contract has an associated alarm (0 = no alarm, 1 = with alarm)
    fl_int_limitdays INT Number of days in advance to inform about the termination of the contract
    fl_int_user_id INT Identifier of the user responsible for the Agreement, reference the table AFW_USERS.user_id
    fl_str_contract_type INT Model representing the type of document, reference the table ASMS_MODEL.id
    fl_str_description NVARCHAR (1000) Document Description
    fl_str_statuscontract INT Current Contract Status Identifier
    numbercontract NVARCHAR (120) Number that identifies the document for the user
    schedule_flag BIT Indicates whether or not the contract is expired (0 = expired, 1 = active)
    template_id INT Identifier of the contract-related template, reference the ASMS_MAIL_TEMPLATE.id table
    type_id INT Document type identifier, reference the ASMS_TYPES.id table
    vendor_id_contract INT Identifier of the supplier related to the contract, reference table ASMS_COMPANY. Id
    vendorid INT Identifier of the company or manufacturer, reference table ASMS_COMPANY. Id

    Primary Key

    PK_ASMS_CONTRACT
    contractid

    References

    Column Referenced Table Referenced column Name
    area_id dbo.AFW_GROUPS grou_id FK07_ASMS_CONTRACT
    area_id_contract dbo.AFW_GROUPS grou_id FK08_ASMS_CONTRACT
    fl_int_user_id dbo.AFW_USERS user_id FK02_ASMS_CONTRACT
    template_id dbo.ASMS_MAIL_TEMPLATE id FK05_ASMS_CONTRACT
    type_id dbo.ASMS_TYPES id FK03_ASMS_CONTRACT
    vendor_id_contract dbo.ASMS_COMPANY id FK06_ASMS_CONTRACT
    vendorid dbo.ASMS_COMPANY id FK01_ASMS_CONTRACT