EFLEASES

Sublease Inventory

Field Name

Caption

Mask

Description

Field Type

LS_COMMENT1

Long Note

 

Long Note

Memo

LS_CRT_BY

Created By

25x

Created By

Text

LS_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

LS_DOC_FLG

Document Available

 

Document Flag

Boolean

LS_EXP_DT

Expiration Date

mm/dd/yyyy

Expiration Date

Date/Time

LS_ID

Sub Lease Rec #

nnnnnnnnn

Unique Number

Long Integer

LS_INIT_DT

Initiation Date

mm/dd/yyyy

Initiation Date

Date/Time

LS_LE_ID

Lease Rec #

nnnnnnnn

Link to EFLEASE.LE_ID

Long Integer

LS_LTYP_CD

Lease Type

nnn

Lease Type

Integer

LS_LTYP_TY

Lease Type Text

25x

Lease Type Text

Text

LS_MOD_BY

Last Modified By

25x

Modified By

Text

LS_MOD_DT

Last Modified Date

mm/dd/yyyy

Modification Date

Date/Time

LS_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

LS_NAME

Name

50x

Name

Text

LS_NUMBER

Number

20x

Number

Text

LS_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

LS_SIGN_DT

Signed Date

mm/dd/yyyy

Signed Date

Date/Time

LS_TEN

Tenant

40x

Tenant

Text

LS_TEN_CN

Tenant Name

40x

Tenant Contact Name

Text

LS_TENCITY

Tenant City

100x

Tenant City

Text

LS_TENCTRY

Tenant Country

15x

Tenant Country

Text

LS_TENEML

Tenant Email

150x

Tenant Email

Text

LS_TENFAX

Tenant Fax #

25x

Tenant Fax #

Text

LS_TENMOB

Tenant Mobile #

25x

Tenant Mobile #

Text

LS_TENPHN

Tenant Phone #

25x

Tenant Phone #

Text

LS_TENSTAT

Tenant State

25x

Tenant State

Text

LS_TENSTR1

Tenant Street 1

50x

Tenant Street1

Text

LS_TENSTR2

Tenant Street 2

50x

Tenant Street2

Text

LS_TENSTR3

Tenant Street 3

50x

Tenant Street3

Text

LS_TENWEB

Tenant Web Site

40x

Tenant Web Site

Text

LS_TPOSTAL

Tenant Zip

15x

Tenant Zip

Text

LS_USER10

User 10

mm/dd/yyyy

User 10

Date/Time

LS_USER11

User 11

mm/dd/yyyy

User 11

Date/Time

LS_USER12

User 12

mm/dd/yyyy

User 12

Date/Time

LS_USER13

User 13

 

User 13

Boolean

LS_USER14

User 14

 

User 14

Boolean

LS_USER15

User 15

 

User 15

Boolean

LS_USER16CD

User 16

nnn

User 16

Small Integer

LS_USER16TY

User 16 Text

50x

User 16 Text

String

LS_USER17CD

User 17

nnn

User 17

Small Integer

LS_USER17TY

User 17 Text

50x

User 17 Text

String

LS_USER18CD

User 18

nnn

User 18

Small Integer

LS_USER18TY

User 18 Text

50x

User 18 Text

String

LS_USER19CD

User 19

nnn

User 19

Small Integer

LS_USER19TY

User 19 Text

50x

User 19 Text

String

LS_USER1CD

User 1

nnn

User 1 Code

Integer

LS_USER1TY

User 1 Text

25x

User 1 Text

Text

LS_USER20CD

User 20

nnn

User 20

Small Integer

LS_USER20TY

User 20 Text

50x

User 20 Text

String

LS_USER21

User 21

50x

User 21

String

LS_USER22

User 22

50x

User 22

String

LS_USER23

User 23

50x

User 23

String

LS_USER24

User 24

50x

User 24

String

LS_USER25

User 25

50x

User 25

String

LS_USER26

User 26

-nnnnnnnn.nn

User 26

Double

LS_USER27

User 27

-nnnnnnnn.nn

User 27

Double

LS_USER28

User 28

-nnnnnnnn.nn

User 28

Double

LS_USER29

User 29

-nnnnnnnn.nn

User 29

Double

LS_USER2CD

User 2

nnn

User 2 Code

Integer

LS_USER2TY

User 2 Text

25x

User 2 Text

Text

LS_USER30

User 30

-nnnnnnnn.nn

User 30

Double

LS_USER31

User 31

mm/dd/yyyy

User 31

DateTime

LS_USER32

User 32

mm/dd/yyyy

User 32

DateTime

LS_USER33

User 33

mm/dd/yyyy

User 33

DateTime

LS_USER34

User 34

mm/dd/yyyy

User 34

DateTime

LS_USER35

User 35

mm/dd/yyyy

User 35

DateTime

LS_USER36

User 36

 

User 36

Boolean

LS_USER37

User 37

 

User 37

Boolean

LS_USER38

User 38

 

User 38

Boolean

LS_USER39

User 39

 

User 39

Boolean

LS_USER3CD

User 3

nnn

User 3 Code

Integer

LS_USER3TY

User 3 Text

25x

User 3 Text

Text

LS_USER40

User 40

 

User 40

Boolean

LS_USER4

User 4

30x

User 4

Text

LS_USER5

User 5

30x

User 5

Text

LS_USER6

User 6

30x

User 6

Text

LS_USER7

User 7

-nnnnnnnn.nn

User 7

Double

LS_USER8

User 8

-nnnnnnnn.nn

User 8

Double

LS_USER9

User 9

-nnnnnnnn.nn

User 9

Double