Help Page Home

MetalStockDetails

Name	Type	Additional information
SRNO	integer	None.
UNIQUEID	decimal number	Required
TRANSVOCNO	decimal number	None.
TRANSMID	decimal number	Required
TRANSVOCTYPE	string	Max length: 3
BATCH_SRNO	decimal number	None.
SUB_STOCK_CODE	string	Required Max length: 12
STOCK_DESC	string	Max length: 100
GROSSWT	decimal number	None.
STONEWT	decimal number	None.
NETWT	decimal number	None.
SUPPLIER_REF	string	Max length: 50
SUPPLIER	string	Max length: 6
PUREWT	decimal number	None.
PURITYDIFF	decimal number	None.
OZWT	decimal number	None.
TRANSPURITY	decimal number	None.
METAL_RATEFC	decimal number	None.
METAL_RATECC	decimal number	None.
STONE_RATEFC	decimal number	None.
STONE_RATECC	decimal number	None.
MKG_RATEFC	decimal number	None.
MKG_RATECC	decimal number	None.
STONEAMTFC	decimal number	None.
STONEAMTCC	decimal number	None.
MKGAMTFC	decimal number	None.
MKGAMTCC	decimal number	None.
METALAMTFC	decimal number	None.
METALAMTCC	decimal number	None.
PRICE1FC	decimal number	None.
PRICE1CC	decimal number	None.
PRICE2FC	decimal number	None.
PRICE2CC	decimal number	None.
PRINTED	string	Max length: 1
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
TRANSVOCDATE	date	None.
TAGLINE1	string	Max length: 20
TAGLINE2	string	Max length: 20
MAIN_STOCK_CODE	string	Max length: 12
SAMPLEWT	decimal number	None.
PAYMENTISSUED	boolean	None.
DIVISION_CODE	string	Max length: 1
PRICE1PERCENT	decimal number	Required
PRICE2PERCENT	decimal number	Required
PRICE1PERVALUELC	decimal number	Required
PRICE2PERVALUELC	decimal number	Required
MBCPURCHASEREF	string	Max length: 30
STONE_SALES_PRICE	decimal number	Required
RUBY_WT	decimal number	None.
RUBY_RATE	decimal number	None.
EMERALD_WT	decimal number	None.
EMERALD_RATE	decimal number	None.
SAPPHIRE_WT	decimal number	None.
SAPPHIRE_RATE	decimal number	None.
ZIRCON_WT	decimal number	None.
ZIRCON_RATE	decimal number	None.
COLOR_STONE_WT	decimal number	None.
COLOR_STONE_RATE	decimal number	None.
RUBY_SALES_VALUE	decimal number	None.
EMERALD_SALES_VALUE	decimal number	None.
SAPPHIRE_SALES_VALUE	decimal number	None.
ZIRCON_SALES_VALUE	decimal number	None.
COLORSTONE_SALES_VALUE	decimal number	None.
MBCPURCHASEREFNEW	string	Max length: 30
COLOR	string	Max length: 20
D_SIZE	string	Max length: 20
CONS_SALNO	string	Max length: 20
CONS_SALDATE	date	None.
CONS_BRANCH_CODE	string	Max length: 6
CUST_BARCODE	string	Max length: 20
POSFIXED	boolean	None.
STOCK_DESC_OTHERS	string	Max length: 100
DET_DESIGN_CODE	string	Max length: 15
COUNTRY	string	Max length: 20
DETAILWEIGHT	string	Max length: 25
COLORWEIGHT	decimal number	None.
TYPE	string	Max length: 20
BRAND	string	Max length: 20
CATEGORY	string	Max length: 20
VENDOR	string	Max length: 20
VENDORREF	string	Max length: 20
DESIGN	string	Max length: 20
PREFIX	string	Max length: 20
SUB_CATEGORY_CODE	string	Max length: 20
SET_REF	string	Max length: 15
PRICE3FC	decimal number	None.
PRICE3CC	decimal number	None.
PRICE4FC	decimal number	None.
PRICE4CC	decimal number	None.
PRICE5FC	decimal number	None.
PRICE5CC	decimal number	None.
PRICE1	string	Max length: 20
PRICE2	string	Max length: 20
UNQ_ORDER_ID	string	Required Max length: 50
ITEM_ONHOLD	boolean	Required
POS_CUST_CODE	string	Max length: 20
PICTURE_NAME	string	Required Max length: 1000
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
KUNDAN_UNIT_CODE	string	Required Max length: 6
KUNDAN	boolean	Required
DET_REMARK	string	Required Max length: 200
WASTAGEPRICE1PER	decimal number	Required
WASTAGEPRICE2PER	decimal number	Required
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
TAG_WT	decimal number	Required
LANDING_RATECC	decimal number	Required
LANDING_RATEFC	decimal number	Required
LANDING_AMOUNTCC	decimal number	Required
LANDING_AMOUNTFC	decimal number	Required
STONE_SALES_PRICE2	decimal number	Required
STONE_SALES_PRICE3	decimal number	Required
STONE_SALES_PRICE4	decimal number	Required
STONE_SALES_PRICE5	decimal number	Required
WASTAGEPRICE3PER	decimal number	Required
WASTAGEPRICE4PER	decimal number	Required
WASTAGEPRICE5PER	decimal number	Required
STOCK_MTLRATE	decimal number	None.
KUNDANAMOUNTCC	decimal number	None.
KUNDANAMOUNTFC	decimal number	None.
KUNDANWTGMS	decimal number	None.
KUNDAN_SALES_PRICE	decimal number	None.
KUNDAN_SALES_PRICE2	decimal number	None.
KUNDAN_SALES_PRICE3	decimal number	None.
KUNDAN_SALES_PRICE4	decimal number	None.
KUNDAN_SALES_PRICE5	decimal number	None.
TJS_RFID_CODE	string	Required Max length: 100
STAMPCHARGES	decimal number	Required
SET_PICTURE_NAME	string	Required Max length: 1000