CREATE TABLE [dbo].[prov_company] (
    [prov_company_key]        INT           IDENTITY (1, 1) NOT NULL,
    [prov_company_type]       INT           NULL,
    [prov_company_no]         VARCHAR (45)  NULL,
    [prov_company_name]       VARCHAR (100) NULL,
    [prov_company_trading_as] VARCHAR (100) NULL,
    [prov_company_BBBEE]      INT           NULL,
    [prov_company_vat_no]     VARCHAR (15)  NULL,
	[modified_dt]            DATETIME         NULL,
    [modified_by_key]        UNIQUEIDENTIFIER NULL,
    CONSTRAINT [prov_company_PK] PRIMARY KEY CLUSTERED ([prov_company_key] ASC)
);

