Skip to main content

Suppliers Table (SIM)

dbo.Suppliers - Sites and their locations

R
Written by Renee Thiesing
Updated over 5 months ago

Name

Data Type

Required

Description

BaseScenario*

nvarchar(255)

True

Base Scenario name

Supplier*

nvarchar(255)

True

Supplier Name

SupplierDescription

nvarchar(255)

False

Optional for reporting

SupplierRollup

nvarchar(255)

False

Optional for reporting

Address

nvarchar(255)

False

City

nvarchar(255)

False

State

nvarchar(10)

False

Country

nvarchar(20)

False

PostalCode

nvarchar(20)

False

Latitude

decimal(9,6)

False

Optional for mapping

Longitude

decimal(9,6)

False

Optional for mapping

GeocodeMethod

nvarchar(255)

False

Not currently used

Prefix

nvarchar(10)

False

Optional for reporting

Notes

nvarchar(255)

False

SolverInclude

nvarchar(5)

True

Value of "yes" will be included by the Simulation engine. "No" will be ignored

*PrimaryKey
​

Did this answer your question?