| Name | Description | Type | Additional information |
|---|---|---|---|
| SEQ_NO | integer |
None. |
|
| PACKET_NO | string |
String length: inclusive between 0 and 25 |
|
| REPORT_NO | string |
String length: inclusive between 0 and 25 |
|
| SHAPE_SEQ | integer |
None. |
|
| LAB_SEQ | integer |
None. |
|
| CARAT | decimal number |
None. |
|
| COLOR_SEQ | integer |
None. |
|
| CLARITY_SEQ | integer |
None. |
|
| CUT_SEQ | integer |
None. |
|
| POLISH_SEQ | integer |
None. |
|
| SYMM_SEQ | integer |
None. |
|
| FLS_SEQ | integer |
None. |
|
| 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. |
|
| H_A | integer |
None. |
|
| SHADE_SEQ | integer |
None. |
|
| CULET | string |
String length: inclusive between 0 and 50 |
|
| GIRDLE_COND | string |
String length: inclusive between 0 and 50 |
|
| GIRDLE_PER | decimal number |
None. |
|
| EYE_CLEAN | string |
String length: inclusive between 0 and 25 |
|
| REPORT_COMMENT | string |
String length: inclusive between 0 and 500 |
|
| KEY_TO_SYMBOLS | string |
String length: inclusive between 0 and 500 |
|
| LOCATION | string |
String length: inclusive between 0 and 30 |
|
| STATUS | string |
String length: inclusive between 0 and 1 |
|
| IS_ACTIVE | boolean |
None. |
|
| UPLOAD_DATE | date |
None. |
|
| REVISE_DATE | date |
None. |
|
| VIDEO | boolean |
None. |
|
| REAL_IMAGE | boolean |
None. |
|
| DIAGRAM_IMAGE | boolean |
None. |
|
| PLOTTING_IMAGE | boolean |
None. |
|
| HEART_IMAGE | boolean |
None. |
|
| ARROW_IMAGE | boolean |
None. |
|
| CERTI_IMAGE | boolean |
None. |
|
| CERTI_LINK | string |
String length: inclusive between 0 and 250 |
|
| TRANS_USER_SEQ | integer |
None. |
|
| RATIO | decimal number |
None. |
|
| BROWN | string |
String length: inclusive between 0 and 50 |
|
| TABLE_INCL | string |
String length: inclusive between 0 and 50 |
|
| SIDE_INCL | string |
String length: inclusive between 0 and 50 |
|
| TABLE_BLACK | string |
String length: inclusive between 0 and 50 |
|
| SIDE_BLACK | string |
String length: inclusive between 0 and 50 |
|
| SIDE_OPEN | string |
String length: inclusive between 0 and 50 |
|
| TABLE_OPEN | string |
String length: inclusive between 0 and 50 |
|
| EXTRA_FACET | string |
String length: inclusive between 0 and 50 |
|
| LUSTER | string |
String length: inclusive between 0 and 50 |
|
| STAR_LENGTH | decimal number |
None. |
|
| BLACK_INCL | string |
String length: inclusive between 0 and 50 |
|
| INCL_TYPE | string |
String length: inclusive between 0 and 50 |
|
| OPEN_INCL | string |
String length: inclusive between 0 and 50 |
|
| GRAINING | string |
String length: inclusive between 0 and 50 |
|
| CULET_SEQ | integer |
None. |
|
| SHADE_TYPE_SEQ | integer |
None. |
|
| BLACK_INCLUSION | string |
String length: inclusive between 0 and 50 |
|
| BRILLIANCY | string |
String length: inclusive between 0 and 50 |
|
| TRANS_BROKER_NAME | 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 |
|
| CITY | 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 |
|
| COUNTRY | string |
String length: inclusive between 0 and 50 |
|
| CULET_CONDITION | string |
String length: inclusive between 0 and 50 |
|
| DIAMETER | decimal number |
None. |
|
| FANCY_COLOR | string |
String length: inclusive between 0 and 50 |
|
| INT_STATUS | string |
String length: inclusive between 0 and 50 |
|
| 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 |
|
| ORIGIN | string |
String length: inclusive between 0 and 50 |
|
| TRANS_PARTY_CODE | string |
String length: inclusive between 0 and 15 |
|
| POP | string |
String length: inclusive between 0 and 50 |
|
| RATE_MODE | string |
String length: inclusive between 0 and 5 |
|
| TRANS_SALESMAN_CODE | string |
String length: inclusive between 0 and 15 |
|
| SIDE_CRYSTAL | string |
String length: inclusive between 0 and 50 |
|
| SIDE_FEATHER | string |
String length: inclusive between 0 and 50 |
|
| STATE | 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 |
|
| GIRDLE | string |
String length: inclusive between 0 and 50 |
|
| REPORT_DATE | date |
None. |
|
| VIDEO_LINK | string |
String length: inclusive between 0 and 250 |
|
| MILKY_SEQ | integer |
None. |
|
| UPDATE_DATE | date |
None. |
|
| COLOR_INTENSITY_SEQ | integer |
None. |
|
| COLOR_OVERTONE_SEQ | integer |
None. |
|
| LOGO_INSCRIPTION | boolean |
None. |
|
| CVD_TYPE | string |
None. |
|
| AS_GROWN | string |
None. |
|
| STOCK_TYPE_SEQ | integer |
None. |
|
| GROWN_TYPE_SEQ | byte |
None. |
|
| CLARITY_MAS | CLARITY_MAS |
None. |
|
| COLOR_MAS | COLOR_MAS |
None. |
|
| COLOR_MAS1 | COLOR_MAS |
None. |
|
| COLOR_MAS2 | COLOR_MAS |
None. |
|
| CPS_MAS | CPS_MAS |
None. |
|
| CPS_MAS1 | CPS_MAS |
None. |
|
| CPS_MAS2 | CPS_MAS |
None. |
|
| CULET_MAS | CULET_MAS |
None. |
|
| DIA_PARA | Collection of DIA_PARA |
None. |
|
| EXCLUSIVE_STOCK | Collection of EXCLUSIVE_STOCK |
None. |
|
| FLS_MAS | FLS_MAS |
None. |
|
| HA_MAS | HA_MAS |
None. |
|
| HOLD_DET | Collection of HOLD_DET |
None. |
|
| ISSUE_DET | Collection of ISSUE_DET |
None. |
|
| LAB_MAS | LAB_MAS |
None. |
|
| MILKY_MAS | MILKY_MAS |
None. |
|
| PROFORMA_DET | Collection of PROFORMA_DET |
None. |
|
| SALE_DET | Collection of SALE_DET |
None. |
|
| SHADE_MAS | SHADE_MAS |
None. |
|
| SHADE_TYPE_MAS | SHADE_TYPE_MAS |
None. |
|
| SHAPE_MAS | SHAPE_MAS |
None. |
|
| STOCK_FILE | Collection of STOCK_FILE |
None. |
|
| TRANS_DET | Collection of TRANS_DET |
None. |