Home > Technical > Table Definitions > LICENCECODE

LICENCECODE

Column

Type

Description

LINTCODE

INT(4)

 

LINTCUSTOMERNUM

INT(4)

 

STRLICENCECODE

VARCHAR(50)

 

INTPOS

INT(4)

 

STRLICENCEKEY

VARCHAR(50)

 

STRCREATEDBY

VARCHAR(20)

 

DTMCREATED

DATETIME(8)

 

MEMNOTES

TEXT(16)

 

YSNACTIVE

VARCHAR(1)

 

STRGROUP

VARCHAR(3)

 

DTMLASTUPDATE

DATETIME(8)

 

DTMEXPIRY

DATETIME(8)

 

STRLICENCETYPE

VARCHAR(10)

 

STREVALTYPE

VARCHAR(10)

 

INTSTORES

INT(4)

 

STRWHO

VARCHAR(20)

 

DTMWHEN

DATETIME

 

 

Primary Key: LINTCODE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)