EN
Español
English
Português
    ASMS_COMPANY

    Represents information from companies - suppliers

    Data model

    Fields

    Field Type Description
    address1 NVARCHAR (510) Company Address
    address2 NVARCHAR (510) Second management of the company
    address3 NVARCHAR (510) Third management of the company
    cityid INT Company City Identifier
    contact VARCHAR (100) Name of the person of the company’s primary contact
    countryid INT Company Country Identifier
    createdby INT Identifier of the user who created the company
    creationdate DATETIME Company Creation Date
    description NVARCHAR (2000) Company Description
    email NVARCHAR (200) Email for company contact
    ext NVARCHAR (100) Extension number for company contact
    fax NVARCHAR (100) Fax number for company contact
    id* INT Company Identifier
    location VARCHAR (300) Company Location
    locationid INT Company Location Identifier
    mobil NVARCHAR (100) Mobile phone number for company contact
    modificationdate DATETIME Company Modification Date
    modifiedby INT Identifier of the user that the company modified
    name* NVARCHAR (400) Company Name
    nit NVARCHAR (200) Company Identification Number
    phone1 NVARCHAR (100) First phone number of the company
    phone2 NVARCHAR (100) Second phone number of the company
    phone3 NVARCHAR (100) Third phone number of the company
    vendor_status INT Identify whether the company is active or not
    website NVARCHAR (500) Company Website

    Primary Key

    PK_ASMS_COMPANY
    id

    References

    Column Referenced Table Referenced column Name
    cityid Bod. AFW_CATALOG_CODE code_id FK02_ASMS_COMPANY
    countryid Bod. AFW_CATALOG_CODE code_id FK01_ASMS_COMPANY
    createdby dbo.AFW_USERS user_id FK03_ASMS_COMPANY
    locationid dbo.ASMS_LOCATION id FK05_ASMS_COMPANY
    modifiedby dbo.AFW_USERS user_id FK04_ASMS_COMPANY