EN
Español
English
Português
    ASDK_SERVICE_BAG

    Contains the information for the management of quotas in the finances of the ASMS suite services

    Data model

    Fields

    Field Type Description
    end_date DATETIME End date for the discount of the fee in the service
    id* INT Unique identifier for service finance quotas
    item_type_id* INT Item type identifier, reference the ASMS_TYPES.id table
    remaining FLOAT Remaining Value
    service_id* INT Service identifier related to the item, reference the table ASDK_SERVICE.id
    start_date DATETIME Start date for the discount of the fee in the service
    state_id INT Identifier of the state in which the quota is located (Before = 0, Active = 1, After = 2)
    type_id INT Quota Type (Efforts = 0, Costs = 1, Pricing = 2, Caseload = 3)
    value FLOAT Value of the installment

    Primary Key

    PK_ASDK_SERVICE_BAG
    id

    References

    Column Referenced Table Referenced column Name
    item_type_id* dbo.ASMS_TYPES id FK02_ASDK_SERVICE_BAG
    service_id* dbo.ASDK_SERVICE id FK01_ASDK_SERVICE_BAG