Name | Description | Type | Additional 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. |