Note object

Note properties and column mapping

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

  • n = notes

  • o = orderheader

  • s = stops
Property Database Column

Name

Data Type (in C#)

Name

Data Type

Modifiable

Comments

1

AutoNote

string

n.autonote

char(1)

Insert/Update

2

DataSourceID

string

N/A

Not mapped

3

Expires

DateTime

n.not_expires

datetime

Insert/Update

4

ForwardedFrom

int

n.not_forwardedfrom

int

Insert/Update

5

Id

int

n.not_number

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

LastUpdated

DateTime

n.last_updatedatetime

datetime

Insert/Update

10

LastUpdatedBy

string

n.last_updatedby

char(20)

Insert/Update

11

NumberCopiedFrom

int

n.not_number_copied_from

int

Insert/Update

12

OrderNumber

string

o.ord_number

char(12)

Insert/Update

13

SentBy

string

n.not_sentby

varchar(6)

Insert/Update

14

SentOn

DateTime

n.not_senton

datetime

Insert/Update

15

Sequence

short

n.not_sequence

smallint

Insert/Update

16

Table

string

n.ntb_table

char(18)

Insert/Update

17

TableCopiedFrom

string

n.not_ntb_table_copied_from

varchar(18)

Insert/Update

18

TableKey

string

n.nre_tablekey

char(18)

Insert/Update

19

TableKeyCopiedFrom

string

n.nre_tablekey_copied_from

varchar(18)

Insert/Update

20

Text

string

n.not_text

varchar(254)

Insert/Update

21

TextLarge

string

n.not_text_large

text

Insert/Update

22

TmSend

string

n.not_tmsend

char(1)

Insert/Update

23

Type

string

n.not_type

varchar(6)

Insert/Update

24

UpdateableProperties

NoteUpdateInfo

N/A

Not mapped

25

Urgent

string

n.not_urgent

char(1)

Insert/Update

26

Viewlevel

string

n.not_viewlevel

varchar(6)

Insert/Update

Note.ReturnObject

Property Name Data Type (in C#) Comments

1

ErrorMessages

List<string>

2

ErrorObjectIndexList

List<int>

3

Exceptions

List<Exception>

4

ReferenceObjects

List<Note>

5

ReturnCode

int

6

TraceMessages

List<string>

7

WarningMessages

List<string>

NoteUpdateInfo object

  • Data types (in C#) for all properties are bool.

  • Set the property to true to update the corresponding Note property.

Property Name

1

AutoNote

2

Expires

3

ForwardedFrom

4

Id

5

LastUpdated

6

LastUpdatedBy

7

NumberCopiedFrom

8

OrderNumber

9

SentBy

10

SentOn

11

Table

12

TableCopiedFrom

13

TableKey

14

TableKeyCopiedFrom

15

Text

16

TextLarge

17

TmSend

18

Type

19

Urgent

20

Viewlevel

Note Criteria object

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

n = notes
Name Database Column Data Type (in C#) Comments

1

Id

n.not_number

int?

2

Table

n.ntb_table

string

3

TableKey

n.nre_tablekey

string

4

Text

n.not_text

string

5

Type

n.not_type

string

6

Urgent

n.not_urgent

string