Help Page Home

RetailSalesDetails

Name	Type	Additional information
UNIQUEID	decimal number	None.
SRNO	integer	Required
DIVISION_CODE	string	Required Max length: 1
STOCK_CODE	string	Max length: 15
PCS	decimal number	None.
GROSSWT	decimal number	None.
STONEWT	decimal number	None.
NETWT	decimal number	None.
PURITY	decimal number	None.
PUREWT	decimal number	None.
CHARGABLEWT	decimal number	None.
MKG_RATEFC	decimal number	None.
MKG_RATECC	decimal number	None.
MKGVALUEFC	decimal number	None.
MKGVALUECC	decimal number	None.
RATE_TYPE	string	Max length: 6
METAL_RATE	decimal number	None.
METAL_RATE_GMSFC	decimal number	None.
METAL_RATE_GMSCC	decimal number	None.
METALVALUEFC	decimal number	None.
METALVALUECC	decimal number	None.
STONE_RATEFC	decimal number	None.
STONE_RATECC	decimal number	None.
STONEVALUEFC	decimal number	None.
STONEVALUECC	decimal number	None.
DISCOUNT	decimal number	None.
DISCOUNTVALUEFC	decimal number	None.
DISCOUNTVALUECC	decimal number	None.
NETVALUEFC	decimal number	None.
NETVALUECC	decimal number	None.
PUDIFF	decimal number	None.
STONEDIFF	decimal number	None.
PONO	decimal number	None.
LOCTYPE_CODE	string	Max length: 6
SUPPLIER	string	Max length: 6
STOCK_DOCDESC	string	Max length: 60
LOCKED	boolean	None.
MCLENGTH	decimal number	None.
MCUNIT	decimal number	None.
POSSALESSR	string	Max length: 6
PHYSICALSTOCK	string	Max length: 6
METALAMT	string	Max length: 6
MAKINGAMT	string	Max length: 6
STDIFFAC	string	Max length: 6
STAMTAC	string	Max length: 6
STKTRANMKGCOST	decimal number	None.
MAINSTOCKCODE	string	Max length: 15
MKGMTLNETRATE	decimal number	None.
RS_PICTUREPATH	string	Max length: 250
RSO_FIXED	boolean	None.
RSORDERGROSSWT	decimal number	None.
RUBY_WT	decimal number	Required
RUBY_RATE	decimal number	Required
RUBY_AMOUNTFC	decimal number	Required
RUBY_AMOUNTCC	decimal number	Required
EMERALD_WT	decimal number	Required
EMERALD_RATE	decimal number	Required
EMERALD_AMOUNTFC	decimal number	Required
EMERALD_AMOUNTCC	decimal number	Required
SAPPHIRE_WT	decimal number	Required
SAPPHIRE_RATE	decimal number	Required
SAPPHIRE_AMOUNTFC	decimal number	Required
SAPPHIRE_AMOUNTCC	decimal number	Required
ZIRCON_WT	decimal number	Required
ZIRCON_RATE	decimal number	Required
ZIRCON_AMOUNTFC	decimal number	Required
ZIRCON_AMOUNTCC	decimal number	Required
COLOR_STONE_WT	decimal number	Required
COLOR_STONE_RATE	decimal number	Required
COLOR_STONE_AMOUNTFC	decimal number	Required
COLOR_STONE_AMOUNTCC	decimal number	Required
SJEW_TAGLINES	string	Max length: 200
MTL_SIZE	string	Max length: 20
MTL_COLOR	string	Max length: 20
MTL_DESIGN	string	Max length: 20
DTSALESPERSON_CODE	string	Max length: 6
VAT_ACCODE	string	Max length: 6
VAT_PER	decimal number	None.
TOTALWITHVATFC	decimal number	None.
TOTALWITHVATLC	decimal number	None.
VAT_AMOUNTLC	decimal number	None.
VAT_AMOUNTFC	decimal number	None.
LOYALTY_ITEM	boolean	None.
WASTE_PER	decimal number	Required
STKTRN_LANDINGCOST	decimal number	None.
STKTRN_WASTAGERATE	decimal number	None.
DT_BRANCH_CODE	string	Max length: 6
DT_VOCTYPE	string	Max length: 3
DT_VOCNO	decimal number	None.
DT_YEARMONTH	string	Max length: 6
SALESPERSON_CODE	string	Max length: 6
MARGIN_PER	decimal number	Required
MARGIN_AMTFC	decimal number	Required
MARGIN_AMTCC	decimal number	Required
CGST_PER	decimal number	Required
CGST_AMOUNTFC	decimal number	Required
CGST_AMOUNTCC	decimal number	Required
SGST_PER	decimal number	Required
SGST_AMOUNTFC	decimal number	Required
SGST_AMOUNTCC	decimal number	Required
IGST_PER	decimal number	Required
IGST_AMOUNTFC	decimal number	Required
IGST_AMOUNTCC	decimal number	Required
CGST_ACCODE	string	Required Max length: 6
SGST_ACCODE	string	Required Max length: 6
IGST_ACCODE	string	Required Max length: 6
TOTAL_AMOUNTFC	decimal number	Required
TOTAL_AMOUNTCC	decimal number	Required
CGST_CTRLACCODE	string	Required Max length: 6
SGST_CTRLACCODE	string	Required Max length: 6
IGST_CTRLACCODE	string	Required Max length: 6
GST_GROUP	string	Required Max length: 1
GST_CODE	string	Required Max length: 15
HSN_CODE	string	Max length: 20
SERVICE_ACCODE	string	Required Max length: 6
WASTAGEPER	decimal number	Required
WASTAGEQTY	decimal number	Required
WASTAGEPUREWT	decimal number	Required
WASTAGEAMOUNTFC	decimal number	Required
WASTAGEAMOUNTCC	decimal number	Required
DIVISIONMS	string	Required Max length: 1
INCLUSIVE	boolean	None.
OLDRATE	decimal number	None.
OLDAMOUNT	decimal number	None.
DISC_USER_NAME	string	Required Max length: 20
DISC_AMOUNT	decimal number	Required
DISC_PERCENTAGE	decimal number	Required
KUNDAN_UNIT	decimal number	Required
KUNDAN_PCS	decimal number	Required
KUNDAN_CARAT	decimal number	Required
KUNDAN_WEIGHT	decimal number	Required
KUNDAN_RATEFC	decimal number	Required
KUNDAN_RATECC	decimal number	Required
KUNDANVALUEFC	decimal number	Required
KUNDANVALUECC	decimal number	Required
CESS_PER	decimal number	None.
CESS_AMOUNTFC	decimal number	Required
CESS_AMOUNTCC	decimal number	Required
ROS_FIXED	decimal number	Required
BATCHID	decimal number	Required
STAMP_RATE	decimal number	Required
STAMP_AMOUNT	decimal number	Required
STAMP_AMOUNTCC	decimal number	Required
SET_REF	string	Required Max length: 15
SALES_TAGLINES	string	Required Max length: 1000
LOYALTY_POINTS	decimal number	Required
SERVICE_STOCK_CODE	string	Max length: 15