Commodity object

Name

Data type (in C#)

GetCommodity

commodityCode

String

0 = successful

100 = no records found

1000 = errors occurred

Returns all Commodity objects that correspond to the provided commodity code

RetrieveCommodities

N/A

0 = successful

100 = no records found

1000 = errors occurred

Returns all the Commodity objects that meet the provided criteria

Name

Data Type (in C#)

Name

Data Type

1

Code

string

c.cmd_code

varchar(8)

Insert only

Unique and required

2

CommodityClass

string

c.cmd_class

varchar(8)

Insert/Update

3

DataSourceID

string

N/A

Not mapped

4

Description

string

c.cmd_name

varchar(60)

Insert/Update

Unique and required

5

Hazardous

int

c.cmd_hazardous

int

Insert/Update

6

IsDirty

bool

N/A

Not mapped or used in service

7

IsNew

bool

N/A

Not mapped, set to false during save to update

8

IsValid

bool

N/A

Not mapped or used in service

9

Misc1

string

c.cmd_misc1

varchar(254)

Insert/Update

10

Misc2

string

c.cmd_misc2

varchar(254)

Insert/Update

11

Misc3

string

c.cmd_misc3

varchar(254)

Insert/Update

12

Misc4

string

c.cmd_misc4

varchar(254)

Insert/Update

13

Pin

string

c.cmd_pin

varchar(8)

Insert/Update

14

UpdateableProperties

CommodityUpdateInfo

N/A

Not mapped