NameDescriptionTypeAdditional information
SEQ_NO

integer

None.

IS_SELECT

integer

None.

PACKET_NO

string

String length: inclusive between 0 and 25

REPORT_NO

string

String length: inclusive between 0 and 25

SHAPE

string

String length: inclusive between 0 and 25

LAB

string

String length: inclusive between 0 and 25

CARAT

decimal number

None.

COLOR

string

String length: inclusive between 0 and 10

CLARITY

string

String length: inclusive between 0 and 25

CUT

string

String length: inclusive between 0 and 2

POLISH

string

String length: inclusive between 0 and 2

SYMM

string

String length: inclusive between 0 and 2

FLS

string

String length: inclusive between 0 and 5

H_A

string

String length: inclusive between 0 and 2

SHADE

string

String length: inclusive between 0 and 25

RATE

decimal number

None.

DISCOUNT

decimal number

None.

NET_RATE

decimal number

None.

NET_VALUE

decimal number

None.

LENGTH

decimal number

None.

WIDTH

decimal number

None.

DEPTH

decimal number

None.

TABLE_PER

decimal number

None.

DEPTH_PER

decimal number

None.

CR_ANGLE

decimal number

None.

CR_HEIGHT

decimal number

None.

PAV_ANGLE

decimal number

None.

PAV_HEIGHT

decimal number

None.

CULET

string

String length: inclusive between 0 and 25

GIRDLE_COND

string

String length: inclusive between 0 and 25

GIRDLE_PER

decimal number

None.

EYE_CLEAN

string

String length: inclusive between 0 and 20

REPORT_COMMENT

string

String length: inclusive between 0 and 200

KEY_TO_SYMBOLS

string

String length: inclusive between 0 and 200

LOCATION

string

String length: inclusive between 0 and 25

STATUS

string

String length: inclusive between 0 and 2

UPLOAD_DATE

string

String length: inclusive between 0 and 20

REVISE_DATE

string

String length: inclusive between 0 and 20

DNA

string

String length: inclusive between 0 and 10

CERTI_LINK

string

String length: inclusive between 0 and 250

TRANS_USER_SEQ

integer

None.

TRANS_SUPPORT_SEQ

integer

None.

RATIO

decimal number

None.

BROWN

string

String length: inclusive between 0 and 30

TABLE_INCL

string

String length: inclusive between 0 and 30

SIDE_INCL

string

String length: inclusive between 0 and 30

TABLE_BLACK

string

String length: inclusive between 0 and 30

SIDE_BLACK

string

String length: inclusive between 0 and 30

SIDE_OPEN

string

String length: inclusive between 0 and 30

TABLE_OPEN

string

String length: inclusive between 0 and 30

EXTRA_FACET

string

String length: inclusive between 0 and 30

LUSTER

string

String length: inclusive between 0 and 30

STAR_LENGTH

decimal number

None.

MEASUREMENT

string

String length: inclusive between 0 and 50

POINTER

string

String length: inclusive between 0 and 30

ROWNUMBER

integer

None.

TRANS_COMP_NAME

string

String length: inclusive between 0 and 50

VIDEO

string

String length: inclusive between 0 and 500

REAL_IMAGE

string

String length: inclusive between 0 and 500

DIAGRAM_IMAGE

string

String length: inclusive between 0 and 500

PLOTTING_IMAGE

string

String length: inclusive between 0 and 500

HEART_IMAGE

string

String length: inclusive between 0 and 500

ARROW_IMAGE

string

String length: inclusive between 0 and 500

CERTI_IMAGE

string

String length: inclusive between 0 and 500

VDISCOUNT

decimal number

None.

BID_DISCOUNT

decimal number

None.

BID_RATE

decimal number

None.

BID_NET_RATE

decimal number

None.

BID_NET_VALUE

decimal number

None.

BID_VALID_DATE

date

None.

CART_COMP_NAME

string

String length: inclusive between 0 and 100

CART_USER_SEQ

integer

None.

BLACK_INCL

string

String length: inclusive between 0 and 50

BRILLIANCY

string

String length: inclusive between 0 and 50

CANADA_MARK_CERT_NO

string

String length: inclusive between 0 and 50

CENTER_CRYSTAL

string

String length: inclusive between 0 and 50

CENTER_FEATHER

string

String length: inclusive between 0 and 50

CENTER_NATTS

string

String length: inclusive between 0 and 50

COLOR_INTENSITY

string

String length: inclusive between 0 and 50

COLOR_OVERTONE

string

String length: inclusive between 0 and 50

COP

string

String length: inclusive between 0 and 50

CULET_CONDITION

string

String length: inclusive between 0 and 50

CULET_SEQ

integer

None.

DIAMETER

decimal number

None.

FANCY_COLOR

string

String length: inclusive between 0 and 50

GIRDLE

string

String length: inclusive between 0 and 50

GRAINING

string

String length: inclusive between 0 and 10

IS_CANADA_MARK

string

String length: inclusive between 0 and 50

LASER_INSCRIPTION

string

String length: inclusive between 0 and 30

LOWER

string

String length: inclusive between 0 and 50

MEMBER_COMMENTS

string

String length: inclusive between 0 and 100

TRANS_CONTACT

string

String length: inclusive between 0 and 50

TRANS_EMAIL_ID

string

String length: inclusive between 0 and 50

TRANS_EST_RETURN_DATE

date

None.

TRANS_DATE

date

None.

TRANS_PARTY

string

String length: inclusive between 0 and 100

TRANS_SALESMAN

string

String length: inclusive between 0 and 50

MILKY

string

String length: inclusive between 0 and 50

MINES

string

String length: inclusive between 0 and 50

OPEN_INCL

string

String length: inclusive between 0 and 15

ORIGIN

string

String length: inclusive between 0 and 50

TRANS_PARTY_CODE

integer

None.

POP

string

String length: inclusive between 0 and 50

RATE_MODE

string

String length: inclusive between 0 and 5

TRANS_SALESMAN_CODE

integer

None.

SIDE_CRYSTAL

string

String length: inclusive between 0 and 50

SIDE_FEATHER

string

String length: inclusive between 0 and 50

TINGE

string

String length: inclusive between 0 and 50

XTOP

string

String length: inclusive between 0 and 50

REPORT_DATE

date

None.

INCL_TYPE

string

String length: inclusive between 0 and 15

ONLINE_OFF_AMT

decimal number

None.

FINAL_DISCOUNT

decimal number

None.

FINAL_AMOUNT

decimal number

None.

SPECIAL_OFF_AMT

decimal number

None.

VIDEO_LINK

string

String length: inclusive between 0 and 250

IMAGE_LINK

string

String length: inclusive between 0 and 250

CART_DATE

date

None.

CVD_TYPE

string

None.

AS_GROWN

string

None.

USER_MAS

USER_MAS

None.