EN
Español
English
Português
    ASMS_COST

    Represents a cost incurred or income earned by the organization

    Data model

    Fields

    Field Type Description
    cost_center_id* INT Unique identifier of the associated cost center, reference the table ASMS_COST_CENTER.id
    description NVARCHAR (8000) Cost Description
    expense_type INT Expense type identifier
    id* INT Unique cost identifier
    name NVARCHAR (1400) Descriptive name of the cost
    original_value NUMERIC Value assigned to the cost when it was created
    parent_id INT Identifier of the main cost to which the current cost is related, reference Table ASMS_COST. Id
    parent_type INT Identifier of the type of the principal cost to which the current cost relates
    type INT Cost type identifier, (1 = accounting, 2 = budgetary)
    value NUMERIC Present Cost Value
    value_date DATETIME Date of creation

    Primary Key

    PK_ASMS_COST
    id

    References

    Column Referenced Table Referenced column Name
    cost_center_id* dbo.ASMS_COST_CENTER id FK01_ASMS_COST
    parent_id dbo.ASMS_COST id FK02_ASMS_COST
    parent_type dbo.ASMS_COST_CENTER_CONTRACT fl_int_costcenter_support_id FK03_ASMS_COST