Note object

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 Modifiable Comments

Name

Data Type (in C#)

Name

Data Type

1

AutoNote

string

n.autonote

char(1)

Insert/Update

2

CompanyID

string

s.cmp_id

varchar(8)

Insert/Update

3

DataSourceID

string

N/A

Not mapped

4

Expires

DateTime

n.not_expires

datetime

Insert/Update

5

ForwardedFrom

int

n.not_forwardedfrom

int

Insert/Update

6

Id

int

n.not_number

int

Insert/Update

7

IsDirty

bool

N/A

Not mapped or used in service

8

IsNew

bool

N/A

Not mapped, set to false during save to update

9

IsValid

bool

N/A

Not mapped or used in service

10

LastUpdated

DateTime

n.last_updatedatetime

datetime

Insert/Update

11

LastUpdatedBy

string

n.last_updatedby

char(20)

Insert/Update

12

NumberCopiedFrom

int

n.not_number_copied_from

int

Insert/Update

13

OrderNumber

string

o.ord_number

char(12)

Insert/Update

14

SentBy

string

n.not_sentby

varchar(6)

Insert/Update

15

SentOn

DateTime

n.not_senton

datetime

Insert/Update

16

Sequence

short

n.not_sequence

smallint

Insert/Update

17

Table

string

n.ntb_table

char(18)

Insert/Update

18

TableCopiedFrom

string

n.not_ntb_table_copied_from

varchar(18)

Insert/Update

19

TableKey

string

n.nre_tablekey

char(18)

Insert/Update

20

TableKeyCopiedFrom

string

n.nre_tablekey_copied_from

varchar(18)

Insert/Update

21

Text

string

n.not_text

varchar(254)

Insert/Update

22

TextLarge

string

n.not_text_large

text

Insert/Update

23

TmSend

string

n.not_tmsend

char(1)

Insert/Update

24

Type

string

n.not_type

varchar(6)

Insert/Update

25

UpdateableProperties

NoteUpdateInfo

N/A

Not mapped

26

Urgent

string

n.not_urgent

char(1)

Insert/Update

27

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

Criteria object

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

n = notes

All columns in the notes table are included.
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