| Name | Description | Type | Additional information |
|---|---|---|---|
| ITEM | string |
Max length: 1 |
|
| STOCK_CODE | string |
Required Max length: 15 |
|
| STOCK_DESCRIPTION | string |
Max length: 100 |
|
| CURRENCY_CODE | string |
Required Max length: 4 |
|
| CC_RATE | decimal number |
None. |
|
| COST_CODE | string |
Required Max length: 6 |
|
| TYPE_CODE | string |
Max length: 20 |
|
| CATEGORY_CODE | string |
Max length: 20 |
|
| SUBCATEGORY_CODE | string |
Max length: 20 |
|
| BRAND_CODE | string |
Max length: 20 |
|
| COUNTRY_CODE | string |
Max length: 20 |
|
| SUPPLIER_CODE | string |
Max length: 6 |
|
| SUPPLIER_REF | string |
Max length: 50 |
|
| DESIGN_CODE | string |
Max length: 20 |
|
| SET_REF | string |
Max length: 20 |
|
| PICTURE_NAME | string |
Max length: 200 |
|
| PICTURE_NAME1 | Collection of byte |
None. |
|
| STOCK_FCCOST | decimal number |
None. |
|
| STOCK_LCCOST | decimal number |
None. |
|
| PRICE1PER | string |
Required Max length: 6 |
|
| PRICE2PER | string |
Max length: 6 |
|
| PRICE3PER | string |
Max length: 6 |
|
| PRICE4PER | string |
Max length: 6 |
|
| PRICE5PER | string |
Max length: 6 |
|
| PRICE1FC | decimal number |
None. |
|
| PRICE1LC | decimal number |
None. |
|
| PRICE2FC | decimal number |
None. |
|
| PRICE2LC | decimal number |
None. |
|
| PRICE3FC | decimal number |
None. |
|
| PRICE3LC | decimal number |
None. |
|
| PRICE4FC | decimal number |
None. |
|
| PRICE4LC | decimal number |
None. |
|
| PRICE5FC | decimal number |
None. |
|
| PRICE5LC | decimal number |
None. |
|
| CHARGE1FC | decimal number |
None. |
|
| CHARGE1LC | decimal number |
None. |
|
| CHARGE2FC | decimal number |
None. |
|
| CHARGE2LC | decimal number |
None. |
|
| CHARGE3FC | decimal number |
None. |
|
| CHARGE3LC | decimal number |
None. |
|
| CHARGE4FC | decimal number |
None. |
|
| CHARGE4LC | decimal number |
None. |
|
| CHARGE5FC | decimal number |
None. |
|
| CHARGE5LC | decimal number |
None. |
|
| SHORT_ID | string |
Max length: 3 |
|
| COLOR | string |
Max length: 20 |
|
| CLARITY | string |
Max length: 20 |
|
| SIZE | string |
Max length: 20 |
|
| SIEVE | string |
Max length: 20 |
|
| SHAPE | string |
Max length: 20 |
|
| GRADE | string |
Max length: 20 |
|
| FLUOR | string |
Max length: 20 |
|
| FINISH | string |
Max length: 20 |
|
| CERT_BY | string |
Max length: 20 |
|
| CERT_NO | string |
Max length: 30 |
|
| CERT_DATE | date |
None. |
|
| GRIDLE | string |
Max length: 25 |
|
| CULET | string |
Max length: 50 |
|
| TWIDTH | decimal number |
None. |
|
| CRHEIGHT | decimal number |
None. |
|
| PAVDEPTH | decimal number |
None. |
|
| OVERALL | string |
Max length: 25 |
|
| MEASURE | string |
Max length: 25 |
|
| CERT_PICTURE_NAME | string |
Max length: 200 |
|
| TAG_LINES | string |
Max length: 250 |
|
| COMMENTS | string |
Max length: 500 |
|
| WATCH_TYPE | decimal number |
None. |
|
| PEARL_TYPE | decimal number |
None. |
|
| STRAP_TYPE | string |
Max length: 20 |
|
| STRAP_COLOR | string |
Max length: 20 |
|
| GW | decimal number |
None. |
|
| MODEL_NO | string |
Max length: 25 |
|
| MODEL_YEAR | decimal number |
None. |
|
| OPENED_ON | date |
None. |
|
| OPENED_BY | string |
Max length: 15 |
|
| FIRST_TRN | string |
Max length: 10 |
|
| LAST_TRN | string |
Max length: 10 |
|
| MID | integer |
Required |
|
| PRINTED | boolean |
None. |
|
| PURVOCTYPE_NO | string |
Max length: 25 |
|
| PURPARTY | string |
Max length: 6 |
|
| PURDATE | date |
None. |
|
| PURAMOUNT | decimal number |
None. |
|
| PURBRLOC | string |
Max length: 6 |
|
| SALVOCTYPE_NO | string |
Max length: 25 |
|
| SALPARTY | string |
Max length: 40 |
|
| SALDATE | date |
None. |
|
| SALAMOUNT | decimal number |
None. |
|
| SALBRLOC | string |
Max length: 6 |
|
| METAL_TOTALGROSSWT | decimal number |
None. |
|
| METAL_TOTALAMOUNT | decimal number |
None. |
|
| METAL_TOTALMAKING | decimal number |
None. |
|
| LOOSE_TOTALWT | decimal number |
None. |
|
| LOOSE_TOTALAMOUNT | decimal number |
None. |
|
| COLOR_TOTALWT | decimal number |
None. |
|
| COLOR_TOTALAMOUNT | decimal number |
None. |
|
| PEARL_TOTALWT | decimal number |
None. |
|
| PEARL_TOTALAMOUNT | decimal number |
None. |
|
| MANF_MID | decimal number |
None. |
|
| MANF_BR_VOCTYPE_NO | string |
Max length: 20 |
|
| WATCH_REFNO | string |
Max length: 15 |
|
| WATCH_MODELNAME | string |
Max length: 20 |
|
| WATCH_MODELNO | string |
Max length: 20 |
|
| WATCH_MATERIAL | string |
Max length: 20 |
|
| WATCH_DIALCOLOR | string |
Max length: 20 |
|
| WATCH_BAZEL | string |
Max length: 20 |
|
| WATCH_MOVEMENT | string |
Max length: 20 |
|
| WATCH_STATUS | string |
Max length: 15 |
|
| WATCH_WEIGHT | string |
Max length: 15 |
|
| UNIT | string |
Max length: 5 |
|
| PCS_PERUNIT | decimal number |
None. |
|
| TAG_LINESWOENTER | string |
Max length: 250 |
|
| PICTURE_NAME_THUMBNAIL | string |
Max length: 200 |
|
| GOLDSMITH | string |
Max length: 6 |
|
| STONESETTER | string |
Max length: 6 |
|
| STD_LCCOST | decimal number |
None. |
|
| TAG1 | string |
Max length: 250 |
|
| TAG2 | string |
Max length: 250 |
|
| TAG3 | string |
Max length: 250 |
|
| TAG4 | string |
Max length: 250 |
|
| TAG5 | string |
Max length: 250 |
|
| WEIGHT_PER_PCS | decimal number |
None. |
|
| DETAILDESCRIPTION | string |
Max length: 500 |
|
| PROD_CUSTOMER_CODE | string |
Max length: 6 |
|
| TDWT | decimal number |
None. |
|
| RD | decimal number |
None. |
|
| TB | decimal number |
None. |
|
| PR | decimal number |
None. |
|
| MQ | decimal number |
None. |
|
| SO | decimal number |
None. |
|
| OT | decimal number |
None. |
|
| RUBY | decimal number |
None. |
|
| EMERALD | decimal number |
None. |
|
| SAPHIRE | decimal number |
None. |
|
| WATCH_SERIALNO | string |
Max length: 50 |
|
| CERT_PRINTED | boolean |
Required |
|
| NOQTYCHANGE | boolean |
None. |
|
| STYLE | string |
Max length: 20 |
|
| CUSTOMERSKU | string |
Required Max length: 20 |
|
| INITIAL_BRPURVOCTYPE_NO | string |
Required Max length: 100 |
|
| STOCK_DESCRIPTION_OTHERS | string |
Max length: 100 |
|
| TIME_CODE | string |
Max length: 20 |
|
| RANGE_CODE | string |
Max length: 20 |
|
| COMMENTS_CODE | string |
Max length: 20 |
|
| NOTES | string |
Max length: 150 |
|
| ASK | string |
Max length: 20 |
|
| SELL | string |
Max length: 20 |
|
| CUT | string |
Max length: 20 |
|
| POLISH | string |
Max length: 20 |
|
| SYMMETRY | string |
Max length: 20 |
|
| UDF1 | string |
Max length: 15 |
|
| UDF2 | string |
Max length: 15 |
|
| UDF3 | string |
Max length: 15 |
|
| UDF4 | string |
Max length: 15 |
|
| UDF5 | string |
Max length: 15 |
|
| UDF6 | string |
Max length: 15 |
|
| UDF7 | string |
Max length: 15 |
|
| UDF8 | string |
Max length: 15 |
|
| UDF9 | string |
Max length: 15 |
|
| UDF10 | string |
Max length: 15 |
|
| UDF11 | string |
Max length: 15 |
|
| UDF12 | string |
Max length: 15 |
|
| UDF13 | string |
Max length: 15 |
|
| UDF14 | string |
Max length: 15 |
|
| UDF15 | string |
Max length: 15 |
|
| PROMOTIONALITEM | boolean |
None. |
|
| EXCLUDEGSTVAT | boolean |
None. |
|
| RRR_CARAT | decimal number |
None. |
|
| RRR_PERCENT | decimal number |
None. |
|
| NACRE | string |
Max length: 20 |
|
| SURFACE | string |
Max length: 20 |
|
| MATCHING | string |
Max length: 20 |
|
| TREATMENT | string |
Max length: 20 |
|
| CUTSTYLE_CROWN | string |
Max length: 20 |
|
| CUTSTYLE_PAVILION | string |
Max length: 20 |
|
| TRANSPARENCY | string |
Max length: 20 |
|
| CONCLUSION | string |
Max length: 20 |
|
| SPECIES | string |
Max length: 20 |
|
| VARIETY | string |
Max length: 20 |
|
| CERTIFICATETYPE | string |
Max length: 20 |
|
| SOURCETYPE | string |
Max length: 20 |
|
| CHARACTERISTIC | string |
Max length: 20 |
|
| TONE_SATURATION | string |
Max length: 20 |
|
| SHAPEAPPAREL | string |
Max length: 20 |
|
| DIA_PCS | decimal number |
None. |
|
| DIA_CARAT | decimal number |
None. |
|
| DIA_VALUEFC | decimal number |
None. |
|
| DIA_VALUECC | decimal number |
None. |
|
| COLOR_PCS | decimal number |
None. |
|
| COLOR_CARAT | decimal number |
None. |
|
| COLOR_VALUEFC | decimal number |
None. |
|
| COLOR_VALUECC | decimal number |
None. |
|
| PEARL_PCS | decimal number |
None. |
|
| PEARL_CARAT | decimal number |
None. |
|
| PEARL_VALUEFC | decimal number |
None. |
|
| PEARL_VALUECC | decimal number |
None. |
|
| OTSTONES_PCS | decimal number |
None. |
|
| OTSTONES_CARAT | decimal number |
None. |
|
| OTSTONES_VALUEFC | decimal number |
None. |
|
| OTSTONES_VALUECC | decimal number |
None. |
|
| METAL_GROSSWT | decimal number |
None. |
|
| METAL_VALUEFC | decimal number |
None. |
|
| METAL_VALUECC | decimal number |
None. |
|
| TOTPCS | decimal number |
None. |
|
| TOTCARAT | decimal number |
None. |
|
| TOTGMS | decimal number |
None. |
|
| TOTVFC | decimal number |
None. |
|
| TOTVLC | decimal number |
None. |
|
| TOTALFC | decimal number |
None. |
|
| TOTALCC | decimal number |
None. |
|
| LAST_EDT_BY | string |
Max length: 15 |
|
| LAST_EDT_ON | date |
None. |
|
| UNITCODE | string |
Max length: 6 |
|
| UNITWT | decimal number |
None. |
|
| CHKUNIT | boolean |
None. |
|
| CHKCOMPONENTSUMMARY | string |
Max length: 10 |
|
| CHKCOMPONENTDETAIL | string |
Max length: 10 |
|
| CMBNATURE | string |
Max length: 10 |
|
| CMBTYPE | string |
Max length: 10 |
|
| RFID_TAG | string |
Max length: 40 |
|
| SKUDESCRIPTION | string |
Max length: 100 |
|
| ON_OFF | boolean |
None. |
|
| NOTFORSALES | decimal number |
None. |
|
| TRANSFERED_WEB | boolean |
Required |
|
| CALCULATE_COSTING | boolean |
None. |
|
| QUALITY_CODE | string |
Max length: 50 |
|
| PARENTSTOCK_CODE | string |
Max length: 15 |
|
| PARTNER_CODE | string |
Max length: 6 |
|
| KPNUMBER | string |
Max length: 50 |
|
| HSN_CODE | string |
Required Max length: 20 |
|
| ITEM_ONHOLD | boolean |
Required |
|
| POS_CUST_CODE | string |
Max length: 20 |
|
| CONSIGNMENT | boolean |
None. |
|
| POSGROSSWT | decimal number |
Required |
|
| HANDLING_CHARGEFC | decimal number |
Required |
|
| HANDLING_CHARGELC | decimal number |
Required |
|
| ORG_COSTFC | decimal number |
Required |
|
| ORG_COSTLC | decimal number |
Required |
|
| VATONMARGIN | boolean |
Required |
|
| SALESPERSON_CODE | string |
Required Max length: 6 |
|
| ORDSALESPERSON_CODE | string |
Required Max length: 6 |
|
| BATCH_STOCK | boolean |
Required |
|
| BATCH_PREFIX | string |
Required Max length: 6 |
|
| SIEVE_SET | string |
Required Max length: 20 |
|
| MODEL_CODE | string |
Required Max length: 15 |
|
| NOOF_PLAT | decimal number |
Required |
|
| PLAT_CHARGESFC | decimal number |
Required |
|
| PLAT_CHARGESLC | decimal number |
Required |
|
| CERT_CHARGESLC | decimal number |
Required |
|
| CERT_CHARGESFC | decimal number |
Required |
|
| UNFIX_DIAMOND_ITEM | boolean |
Required |
|
| ALLOW_WITHOUT_RATE | boolean |
None. |
|
| RRR_STOCK_REF | string |
Required Max length: 100 |
|
| MARKETCOSTFC | decimal number |
Required |
|
| MARKETCOSTLC | decimal number |
Required |
|
| RRR_PRICE_UPDATED | boolean |
Required |
|
| RRR_PRICE_UPDDATE | date |
Required |
|
| SALESCODE | decimal number |
Required |
|
| RRR_PUR_CARAT | decimal number |
Required |
|
| RRR_PUR_PERCENT | decimal number |
Required |
|
| RRR_SAL_PERCENT | decimal number |
Required |
|
| RRR_OTHER_PERCENT | decimal number |
Required |
|
| SET_PICTURE_NAME | string |
Required Max length: 1000 |
|
| SALES_TAGLINES | string |
Required Max length: 250 |
|
| PACKET_ITEM | boolean |
Required |
|
| PACKET_WT | decimal number |
Required |
|
| ALLOW_ZEROPCS | boolean |
Required |
|
| NOOF_CERT | decimal number |
None. |
|
| ADDITIONAL_RATEFC | decimal number |
Required |
|
| ADDITIONAL_RATELC | decimal number |
Required |
|
| DiamondStockDetails | Collection of DiamondStockDetails |
None. |