| 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 |
|
| P_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 |
|
| COLOR_TYPE | 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. |