Home > Technical > Table Definitions > MEDIACLP

MEDIACLP

Column

Type

Description

CTRCODE

INT

 

STRMANUFACTURER

VARCHAR(10)

 

DTMRECEIVED

DATETIME

 

DTMPLAYABLEFROM

DATETIME

 

DTMPLAYABLETO

DATETIME

 

STRDESCRIPTION

VARCHAR(100)

 

DTMLENGTH

DATETIME

 

STRFILENAME1

VARCHAR(60)

 

STRCLIPTYPE1

VARCHAR(5)

 

STRFILENAME2

VARCHAR(60)

 

STRCLIPTYPE2

VARCHAR(5)

 

LINTITEMNUMBER

INT

 

STRDEPTCODE

VARCHAR(10)

 

STRCATCODE

VARCHAR(10)

 

STRGROUPCODE

VARCHAR(10)

 

STRFAMILYCODE

VARCHAR(10)

 

YSNNEW

VARCHAR(1)

 

YSNCHANGED

VARCHAR(1)

 

STRSUPPLIERCODE

VARCHAR(10)

 

STRTRADECODE

VARCHAR(10)

 

INTTYPE

INT

 

STRSOURCE

VARCHAR(10)

 

STRREFERENCE

VARCHAR(20)

 

STRKEYWORDS

VARCHAR(255)

 

STRFILEPATH1

VARCHAR(255)

 

STRFILEPATH2

VARCHAR(255)

 

STRSUBGROUPCODE

VARCHAR(10)

 

 

Primary Key: CTRCODE

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