CompanyTankDetail object

First available in SystemsLink Fuel 2015.1

CompanyTankDetail properties and column mapping

To condense the information in this table, the Database Column Name uses the following abbreviations for database tables:

ctd = company_tankdetail

Unless otherwise stated, all properties were first available in 2015.1.
Property Database Column

Name

Data Type (in C#)

Name

Data Type

Modifiable

Comments

1

ActiveCommodityCode

string

ctd.ActiveCommodityCode

varchar(8), null

Insert/Update

2

BarrelsPerInch

double

N/A

N/A

Not mapped

3

cmd_class

string

ctd.cmd_class

varchar(8), not null

Insert/Update

4

cmd_code

string

ctd.cmd_code

varchar(8), not null

Insert/Update

5

cmd_rvp

decimal

ctd.cmd_rvp

float, null

Insert/Update

6

cmd_volumeunit

string

ctd.cmd_volumeunit

varchar(6), not null

Insert/Update

7

cmp_id

string

ctd.cmp_id

varchar(8), not null

Insert/Update

8

cmp_tank_id

int

ctd.cmp_tank_id

int, not null

Insert/Update

9

CompanyType

string

ctd.CompanyType

varchar(8), null

Insert/Update

10

DailyAverageWeeksBack

int

ctd.DailyAverageWeeksBack

int, not null

Insert/Update

11

DataSourceID

string

N/A

N/A

Not mapped

12

Diameter

decimal

ctd.Diameter

decimal(10,2), null

Insert/Update

13

DwellTime

int

ctd.DwellTime

int, null

Insert/Update

14

forecast_bucket

int

ctd.forecast_bucket

int, null

Insert/Update

15

ForecastID

int

ctd.ForecastID

int, null

Insert/Update

16

GallonWeight

double

N/A

N/A

Not mapped

17

GenerationRule

string

ctd.GenerationRule

varchar(6), not null

Insert/Update

18

InchesToGallonsFactor

double

ctd.InchesToGallonsFactor

float, null

Insert/Update

19

IsDirty

bool

N/A

N/A

Not mapped

20

IsManifolded

bool

ctd.IsManifolded

char(1), not null

Insert/Update

21

IsNew

bool

N/A

N/A

Not mapped

22

IsProducing

bool

ctd.IsProducing

varchar(1), not null

Insert/Update

23

IsPumpManifold

bool

ctd.IsPumpManifold

char(1), not null

Insert/Update

24

IsQuotable

bool

ctd.IsQuotable

char(1), not null

Insert/Update

25

IsValid

bool

N/A

N/A

Not mapped

26

LastRejectionDate

DateTime

ctd.LastRejectionDate

datetime, null

Insert/Update

27

ManifoldGroup

string

ctd.ManifoldGroup

varchar(6), null

Insert/Update

28

model_id

string

ctd.model_id

varchar(19), null

Insert/Update

29

OrderThreshold

int

ctd.OrderThreshold

int, null

Insert/Update

30

PercentOfForecast

int

ctd.PercentOfForecast

decimal(9,2), null

Insert/Update

31

PMDeliveryPercentage

decimal

ctd.PMDeliveryPercentage

decimal(10,4), not null

Insert/Update

32

QuoteVolume

int

ctd.QuoteVolume

int, not null

Insert/Update

33

SafeFillPercent

int

N/A

N/A

Not mapped

34

ShutDownGallons

int

ctd.ShutDownGallons

int, not null

Insert/Update

35

ShutDownPercent

int

N/A

N/A

Not mapped

36

tank_hours_offset

decimal

ctd.tank_hours_offset

decimal(9,2), null

Insert/Update

37

TankRejected

bool

ctd.TankRejected

varchar(1), not null

Insert/Update

38

TankSize

int

ctd.TankSize

int, not null

Insert/Update

39

TankTranslation

string

ctd.TankTranslation

varchar(19), null

Insert/Update

40

ThresholdPercentofSales

decimal

ctd.ThresholdPercentofSales

decimal(9,2), null

Insert/Update

41

Ullage

int

ctd.Ullage

int, not null

Insert/Update

42

UpdateableProperties

CompanyTankDetailUpdateInfo

N/A

N/A

Not mapped

43

ValidCommodityCodes

List<string>

N/A

N/A

Not mapped

44

ValidCommodityList

string

ctd.ValidCommodityList

varchar(1000), null

Insert/Update

45

VolumeUnitWeight

double

ctd.VolumeUnitWeight

float, null

Insert/Update

CompanyTankDetail methods

The Return Value for all methods is CompanyTankDetail.ReturnObject.

Unless otherwise stated, all methods were first available in 2015.1.

Internal

Parameters

Method Name

Name

Data type (in C#)

CompanyTankDetail.ReturnObject
ReturnCode

Description

RetrieveCompanyTankDetail

criteria

CompanyTankDetail.Criteria

0 = successful

100 = no records found

1000 = errors occurred

Returns all CompanyTankDetail objects that meet the specified criteria

CompanyTankDetail.ReturnObject

Unless otherwise stated, all properties were first available in 2015.1.

Property Name Data Type (in C#) Comments

1

ErrorMessages

List<string>

2

ErrorObjectIndexList

List<int>

3

Exceptions

List<Exception>

4

ReferenceObjects

List<CompanyTankDetail>

5

ReturnCode

int

6

TraceMessages

List<string>

7

WarningMessages

List<string>

Criteria object

To condense the information in the table, the Database Column uses the following abbreviations for database tables:

ctd = company_tankdetail

Unless otherwise stated, all properties were first available in 2015.1.
Name Database Column Data Type (in C#) Comments

1

Cmp_id

ctd.cmp_id

string

2

Cmp_tank_id

Ctd.cmp_tank_id

Int?