Help Page Home

TableViewWithoutCost

Name	Type	Additional information
MID	integer	Required
DIVISION	string	Max length: 1
STOCK_CODE	string	Required Max length: 15
DESCRIPTION	string	Max length: 60
STOCK_LCCOST	decimal number	None.
CC_MAKING	string	Max length: 6
CC_METAL	string	Max length: 6
KARAT_CODE	string	Max length: 4
PURITY	decimal number	None.
SUPPLIER	string	Max length: 6
SUPPLIER_REF	string	Max length: 50
PRICE_CODE1	string	Max length: 6
PRICE_CODE2	string	Max length: 6
PRICE_CODE3	string	Max length: 6
PRICE_CODE4	string	Max length: 6
PRICE_CODE5	string	Max length: 6
STONE	boolean	Required
CONV_FACTOR_OZ	decimal number	None.
INPIECES	boolean	Required
SUBCODE	boolean	Required
PCS2GMS	decimal number	None.
ASK_SUPPLIER	boolean	None.
PREFIX_CODE	string	Max length: 6
TRANSVOCNO	decimal number	None.
TRANSMID	decimal number	Required
TRANSVOCTYPE	string	Max length: 3
BATCH_SRNO	decimal number	None.
GROSSWT	decimal number	None.
STONEWT	decimal number	None.
NETWT	decimal number	None.
METAL_RATEFC	decimal number	None.
STONE_RATEFC	decimal number	None.
MKG_RATEFC	decimal number	None.
PUREWT	decimal number	None.
PURITYDIFF	decimal number	None.
STONEAMTFC	decimal number	None.
MKGAMTFC	decimal number	None.
METALAMTFC	decimal number	None.
OZWT	decimal number	None.
BARCODEITEM	boolean	None.
DIVISIONMS	string	Max length: 1
BLOCK_GRWT	boolean	None.
PRICE1VAL	decimal number	None.
PRICE2VAL	decimal number	None.
PRICE3VAL	decimal number	None.
PRICE4VAL	decimal number	None.
PRICE5VAL	decimal number	None.
TAGLINES	string	Max length: 250
AUTO_PL	boolean	Required
SET_REF	string	Max length: 15
DESIGN_CODE	string	Max length: 20
FIELD2	string	Max length: 50
FIELD3	string	Max length: 50
FIELD4	string	Max length: 50
FIELD5	string	Max length: 50
FIELD6	string	Max length: 50
FIELD7	string	Max length: 50
FIELD8	string	Max length: 50
FIELD9	string	Max length: 50
FIELD10	string	Max length: 50
FIELD11	string	Max length: 50
TYPE_CODE	string	Max length: 20
COUNTRY_CODE	string	Max length: 20
CATEGORY_CODE	string	Max length: 20
PICTURE_NAME	string	Max length: 200
BRAND_CODE	string	Max length: 20
UNIT_CODE	string	Max length: 6
COLOR	string	Max length: 20
CLARITY	string	Max length: 20
SIEVE	string	Max length: 20
SHAPE	string	Max length: 20
MAIN_STOCK_CODE	string	Max length: 15
BRAND_DESC	string	Max length: 100
CATEGORY_DESC	string	Max length: 100
LESSTHANCOST	boolean	None.
ASK_WASTAGE	boolean	None.
ALLOW_NEGATIVE	boolean	None.
BLNSTUDDEDJEW	boolean	None.
FIX_STOCK_CODE	string	Max length: 15
POSFIXED	boolean	None.
EXCLUDEGSTVAT	boolean	None.
DESCRIPTION_OTHERS	string	Max length: 100
LOYALTY_ITEM	boolean	None.
TPROMOTIONALITEM	boolean	None.
UNIT_CODESAL	decimal number	None.
CALCULATE_COSTING	boolean	None.
BRANCH_CODE	string	Required Max length: 6
GSTVATONMAKING	boolean	Required
ITEM_ONHOLD	boolean	Required
POS_CUST_CODE	string	Max length: 20
UNQ_ORDER_ID	string	Required Max length: 50
D_SIZE	string	Required Max length: 20
SUB_CATEGORY_CODE	string	Required Max length: 20
SIZE	string	Required Max length: 20
SIEVE_SET	string	Required Max length: 20
MT5_RATE_TYPE	string	Max length: 12
MT5_INCLUSIVE	boolean	None.
KUNDAN_UNIT_CODE	string	Required Max length: 6
KUNDAN	boolean	Required
PCS	decimal number	Required
KUNDANWT	decimal number	Required
KUNDANPCS	decimal number	Required
KUNDANRATETYPE	string	Required Max length: 20
KUNDANRATE	decimal number	Required
WASTAGE_PER	decimal number	Required
WASTAGE_WT	decimal number	Required
WASTAGE_AMTFC	decimal number	Required
WASTAGE_AMTCC	decimal number	Required
METAL_RATECC	decimal number	Required
METALAMTCC	decimal number	Required
DET_REMARK	string	Required Max length: 200
TAG_WT	decimal number	Required
TVATONMARGIN	boolean	None.
MODEL_CODE	string	Required Max length: 15
UDF1	string	Required Max length: 20
UDF2	string	Required Max length: 20
UDF3	string	Required Max length: 20
UDF4	string	Required Max length: 20
UDF5	string	Required Max length: 20
UDF6	string	Required Max length: 20
UDF7	string	Required Max length: 20
UDF8	string	Required Max length: 20
UDF9	string	Required Max length: 20
UDF10	string	Required Max length: 20
UDF11	string	Required Max length: 20
UDF12	string	Required Max length: 20
UDF13	string	Required Max length: 20
UDF14	string	Required Max length: 20
UDF15	string	Required Max length: 20
WASTAGEPRICE1PER	decimal number	Required
WASTAGEPRICE2PER	decimal number	Required
WASTAGEPRICE3PER	decimal number	Required
WASTAGEPRICE4PER	decimal number	Required
WASTAGEPRICE5PER	decimal number	Required
UNFIX_DIAMOND_ITEM	boolean	Required
DETAILWEIGHT	string	Max length: 25
NOTFORSALES	decimal number	None.
STAMPCHARGES	decimal number	Required
SET_PICTURE_NAME	string	Required Max length: 1000
SALES_TAGLINES	string	Required Max length: 250
MKGCALC_NETWT	boolean	None.