STCABWAR

Cabinet Warranty Information

Field Name

Caption

Mask

Description

Field Type

WB_ADD_CST

Additional Cost

nnnnnn.nn

Additional Cost

Double

WB_CB_ID

Cabinet Rec #

nnnnnnnn

Link to STCABINET.CB_ID

Long Integer

WB_COMP_CD

Component

nnn

Component

Integer

WB_COMP_TY

Component Text

25x

Component Text

Text

WB_CRT_BY

Created By

25x

Created By

Text

WB_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

WB_DESC

Description

100x

Description

Text

WB_DOC_FLG

Document Available

 

Document Flag

Boolean

WB_EXPR_DT

Expiration Date

mm/dd/yyyy

Warranty Expiration Date

Date/Time

WB_EXTEND

Extended Warranty

 

Extended Warranty

Boolean

WB_ID

Warranty Rec #

nnnnnnnn

Unique Number

Long Integer

WB_MAN_CD

Manuf

10x

Manufacturer

Text

WB_MAN_TY

Manuf Name

60x

Manufacturer Contact Name

Text

WB_MANCITY

Manuf City

25x

Manufacturer City

Text

WB_MANCTRY

Manuf Country

15x

Manufacturer Country

Text

WB_MANEML

Manuf E-Mail

150x

Manufacturer E-Mail

Text

WB_MANFAX

Manuf Fax #

25x

Manufacturer Fax #

Text

WB_MANMOB

Manuf Mobile #

25x

Manufacturer Mobile #

Text

WB_MANPHN

Manuf Phone #

25x

Manufacturer Phone #

Text

WB_MANSTAT

Manuf State

25x

Manufacturer State

Text

WB_MANSTR1

Manuf Street 1

50x

Manufacturer Street1

Text

WB_MANSTR2

Manuf Street 2

50x

Manufacturer Street2

Text

WB_MANSTR3

Manuf Street 3

50x

Manufacturer Street3

Text

WB_MANWEB

Manuf Web Site

40x

Manufacturer Web Site

Text

WB_MOD_BY

Last Modified By

25x

Modified By

Text

WB_MOD_DT

Last Modified Date

mm/dd/yyyy

Modification Date

Date/Time

WB_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

WB_MPOSTAL

Manuf Zip

15x

Manufacturer Zip

Text

WB_NUMBER

Warranty Number

40x

Warranty Number

Text

WB_OPEN_DT

Warranty Open Date

mm/dd/yyyy

Warranty Open Date

Date/Time

WB_REV_DT

Review Date

mm/dd/yyyy

Warranty Review Date

Date/Time

WB_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

WB_SUPL_CD

Supplier

nnn

Warr Supplier

Integer

WB_SUPL_TY

Supplier Text

25x

Warr Supplier Text

Text

WB_TYPECD

Warranty Type

nnn

Warranty Type

Integer

WB_TYPETY

Warranty Type Text

25x

Warranty Type Text

Text

WB_USER1CD

User 1

nnn

User 1 Code

Integer

WB_USER1TY

User 1 Text

25x

User 1 Text

Text

WB_USER2CD

User 2

nnn

User 2 Code

Integer

WB_USER2TY

User 2 Text

25x

User 2 Text

Text

WB_USER3CD

User 3

nnn

User 3 Code

Integer

WB_USER3TY

User 3 Text

25x

User 3 Text

Text

WB_USER4

User 4

30x

User 4

Text

WB_USER5

User 5

30x

User 5

Text

WB_USER6

User 6

30x

User 6

Text

WB_USER7

User 7

-nnnnnnnn.nn

User 7

Double

WB_USER8

User 8

-nnnnnnnn.nn

User 8

Double

WB_USER9

User 9

-nnnnnnnn.nn

User 9

Double

WB_USER10

User 10

mm/dd/yyyy

User 10

Date/Time

WB_USER11

User 11

mm/dd/yyyy

User 11

Date/Time

WB_USER12

User 12

mm/dd/yyyy

User 12

Date/Time

WB_USER13

User 13

 

User 13

Boolean

WB_USER14

User 14

 

User 14

Boolean

WB_USER15

User 15

 

User 15

Boolean

WB_USER16CD

User 16

nnn

User 16

Integer

WB_USER16TY

User 16 Text

50x

User 16 Text

String

WB_USER17CD

User 17

nnn

User 17

Integer

WB_USER17TY

User 17 Text

50x

User 17 Text

String

WB_USER18CD

User 18

nnn

User 18

Integer

WB_USER18TY

User 18 Text

50x

User 18 Text

String

WB_USER19CD

User 19

nnn

User 19

Integer

WB_USER19TY

User 19 Text

50x

User 19 Text

String

WB_USER20CD

User 20

nnn

User 20

Integer

WB_USER20TY

User 20 Text

50x

User 20 Text

String

WB_USER21

User 21

50x

User 21

String

WB_USER22

User 22

50x

User 22

String

WB_USER23

User 23

50x

User 23

String

WB_USER24

User 24

50x

User 24

String

WB_USER25

User 25

50x

User 25

String

WB_USER26

User 26

nnnnnnnn.nn

User 26

Double

WB_USER27

User 27

nnnnnnnn.nn

User 27

Double

WB_USER28

User 28

nnnnnnnn.nn

User 28

Double

WB_USER29

User 29

nnnnnnnn.nn

User 29

Double

WB_USER30

User 30

nnnnnnnn.nn

User 30

Double

WB_USER31

User 31

mm/dd/yyyy hh:mm am

User 31

DateTime

WB_USER32

User 32

mm/dd/yyyy hh:mm am

User 32

DateTime

WB_USER33

User 33

mm/dd/yyyy hh:mm am

User 33

DateTime

WB_USER34

User 34

mm/dd/yyyy hh:mm am

User 34

DateTime

WB_USER35

User 35

mm/dd/yyyy hh:mm am

User 35

DateTime

WB_USER36

User 36

 

User 36

Boolean

WB_USER37

User 37

 

User 37

Boolean

WB_USER38

User 38

 

User 38

Boolean

WB_USER39

User 39

 

User 39

Boolean

WB_USER40

User 40

 

User 40

Boolean