SecurityCard object

First available in SystemsLink: 2014.4.0

Methods

The Return Value for all methods is SecurityCard.ReturnObject.
Method Name Parameters ReturnCode Description

Name

Data type (in C#)

GetPagedSecurityCardsForVendorByToken

tokenValue

string

SecurityCard.PagedReturnObject.ReturnCode

0 = successful

100 = no records found

1000 = errors occurred

Retrieves paged Security Cards by TMW Toke.

vendorCode

string

pageIndex

int

pageSize

int

RetrievePagedSecurityCards

criteria

SecurityCard.Criteria

SecurityCard.PagedReturnObject.ReturnCode

0 = successful

100 = no records found

1000 = errors occurred

Retrieves page data from TCHMoneyCode and Fuel Card Advance.

RetrieveSecurityCard

criteria

SecurityCard.Criteria

SecurityCard.ReturnObject.ReturnCode

0 = successful

100 = no records found

1000 = errors occurred

Retrieves security card data from TCHMoneyCode and Fuel Card Advance.

Properties and column mapping

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

s = cdsecuritycard
Property Database Column Modifiable Comments

Name

Data Type (in C#)

Name

Data Type

1

AdvanceMax

int

s.csc_advancemax

decimal

Insert/Update

2

AssignmentType

string

s.csc_asgntype

varchar(1)

Insert/Update

3

DataSourceID

string

Not mapped

4

Ecb

string

s.csc_ecb

char(1)

Insert/Update

5

IsDirty

bool

Not mapped

6

IsGeneric

string

s.csc_generic

char(1)

Insert/Update

7

IsNew

bool

Not mapped

8

IsValid

bool

Not mapped

9

SecurityCardId

int

s.csc_id

int

Read only

10

SecurityCardNumber

string

s.csc_cardnumber

varchar(10)

Insert/Update

11

TtsUserId

string

s.csc_userid

varchar(20)

Insert/Update

12

UpdateableProperties

SecurityCardUpdateInfo

13

Vendor

string

s.csc_vendor

varchar(50)

Insert/Update

14

VendorAccountCodeId

string

s.cac_id

varchar(10)

Insert/Update

15

VendorCustomerId

string

s.ccc_id

varchar(10)

Insert/Update

16

VendorLoginId

string

s.csc_vendor_userid

varchar(20)

Insert/Update

First available in SystemsLink: 2015.2.0

17

VendorPassword

string

s.csc_codeword

varchar(25)

Insert/Update

First available in SystemsLink: 2015.2.0

SecurityCard.ReturnObject

Property Name Data Type (in C#) Comments

1

ErrorMessages

List<string>

2

ErrorObjectIndexList

List<int>

3

Exceptions

List<Exception>

4

ReferenceObjects

List<SecurityCard>

5

ReturnCode

int

6

TraceMessages

List<string>

7

WarningMessages

List<string>

SecurityCard.PagedReturnObject

Property Name Data Type (in C#) Comments

1

PageIndex

int

2

PageSize

int

3

TotalRecords

int

SecurityCardUpdateInfo object

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

  • Set the property to true to update the corresponding SecurityCard property.
Property Name Comments

1

AdvanceMax

2

AssignmentType

3

Ecb

4

IsGeneric

5

SecurityCardNumber

6

TtsUserId

7

Vendor

8

VendorAccountCodeId

9

VendorCustomerId

10

VendorLoginId

11

VendorPassword

Criteria object

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

s = cdsecuritycard
Name Database Column Data Type (in C#) Comments

1

Ascending

bool?

Not mapped

2

Expressions

List<CriteriaExpression>

3

PagingData

PagingData

Not mapped

4

SecurityCardId

s.csc_id

int?

5

SecurityCardNumber

s.csc_cardnumber

string

6

Settings

List<CriteriaSettings>

7

SortBy

string

Not mapped

8

TtsUserId

s.csc_userid

string

9

Vendor

s.csc_vendor

string

10

VendorAccountCodeId

s.cac_id

string

CriteriaSettings object

Name Comments

1

SecurityCardNumber

2

VendorAccountCodeId

3

TtsUserId

4

Vendor

5

SecurityCardId

CriteriaExpression object

Name Data Type (in C#) Comments

1

Criteria

Criteria

2

Conjuction

CriteriaSetting.ConjuctionEnum