| Name | Description | 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. |
|
| 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 |
|
| OZWT | decimal number |
None. |
|
| SUPPLIER | string |
Max length: 6 |
|
| BATCHSRNO | decimal number |
None. |
|
| STOCK_DOCDESC | string |
Max length: 40 |
|
| BAGNO | string |
Max length: 20 |
|
| BAGREMARKS | string |
Max length: 500 |
|
| WASTAGEPER | decimal number |
None. |
|
| WASTAGEQTY | decimal number |
None. |
|
| WASTAGEAMOUNTFC | decimal number |
None. |
|
| WASTAGEAMOUNTCC | decimal number |
None. |
|
| MKGMTLNETRATE | decimal number |
None. |
|
| MCLENGTH | decimal number |
None. |
|
| MCUNIT | decimal number |
None. |
|
| SORDER_REF | string |
Max length: 30 |
|
| BARCODEDQTY | decimal number |
Required |
|
| RUBY_WT | decimal number |
Required |
|
| RUBY_RATE | decimal number |
None. |
|
| RUBY_AMOUNTFC | decimal number |
None. |
|
| RUBY_AMOUNTCC | decimal number |
None. |
|
| EMERALD_WT | decimal number |
Required |
|
| EMERALD_RATE | decimal number |
None. |
|
| EMERALD_AMOUNTFC | decimal number |
None. |
|
| EMERALD_AMOUNTCC | decimal number |
None. |
|
| SAPPHIRE_WT | decimal number |
Required |
|
| SAPPHIRE_RATE | decimal number |
None. |
|
| SAPPHIRE_AMOUNTFC | decimal number |
None. |
|
| SAPPHIRE_AMOUNTCC | decimal number |
None. |
|
| ZIRCON_WT | decimal number |
Required |
|
| ZIRCON_RATE | decimal number |
None. |
|
| ZIRCON_AMOUNTFC | decimal number |
None. |
|
| ZIRCON_AMOUNTCC | decimal number |
None. |
|
| COLOR_STONE_WT | decimal number |
Required |
|
| COLOR_STONE_RATE | decimal number |
None. |
|
| COLOR_STONE_AMOUNTFC | decimal number |
None. |
|
| COLOR_STONE_AMOUNTCC | decimal number |
None. |
|
| DISCOUNTWT | decimal number |
Required |
|
| DISCOUNTPUWT | decimal number |
Required |
|
| REPITEMCODE | string |
Required Max length: 12 |
|
| MTL_SIZE | string |
Max length: 20 |
|
| MTL_COLOR | string |
Max length: 20 |
|
| MTL_DESIGN | string |
Max length: 20 |
|
| BARCODE | string |
Max length: 15 |
|
| ORDER_STATUS | boolean |
None. |
|
| PORDER_REF | string |
Max length: 30 |
|
| DT_BRANCH_CODE | string |
Max length: 6 |
|
| DT_VOCTYPE | string |
Max length: 3 |
|
| DT_VOCNO | decimal number |
None. |
|
| DT_YEARMONTH | string |
Max length: 6 |
|
| SUPPLIERDISC | string |
Max length: 100 |
|
| BARCODEDPCS | decimal number |
Required |
|
| BASE_CONV_RATE | decimal number |
None. |
|
| WASTAGE_PURITY | decimal number |
None. |
|
| PUDIFF_AMTLC | decimal number |
None. |
|
| PUDIFF_AMTFC | decimal number |
None. |
|
| TAX_AMOUNTFC | decimal number |
None. |
|
| TAX_AMOUNTCC | decimal number |
None. |
|
| TAX_P | decimal number |
None. |
|
| LOT_NO | string |
Required Max length: 100 |
|
| BAR_NO | string |
Required Max length: 100 |
|
| TICKET_NO | string |
Required Max length: 100 |
|
| PENALTY | decimal number |
Required |
|
| UNITWT | decimal number |
None. |
|
| TOTAL_AMOUNTFC | decimal number |
Required |
|
| TOTAL_AMOUNTCC | decimal number |
Required |
|
| CGST_PER | decimal number |
None. |
|
| CGST_AMOUNTFC | decimal number |
Required |
|
| CGST_AMOUNTCC | decimal number |
Required |
|
| SGST_PER | decimal number |
None. |
|
| SGST_AMOUNTFC | decimal number |
Required |
|
| SGST_AMOUNTCC | decimal number |
Required |
|
| IGST_PER | decimal number |
None. |
|
| 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 |
|
| CGST_CTRLACCODE | string |
Required Max length: 6 |
|
| SGST_CTRLACCODE | string |
Required Max length: 6 |
|
| IGST_CTRLACCODE | string |
Required Max length: 6 |
|
| HSN_CODE | string |
Max length: 20 |
|
| OLD_GOLD_TYPE | string |
Required Max length: 20 |
|
| OUTSIDEGOLD | boolean |
Required |
|
| GST_ROUNDOFFFC | decimal number |
Required |
|
| GST_ROUNDOFFCC | decimal number |
Required |
|
| ROUNDOFF_ACCODE | string |
Required Max length: 6 |
|
| KUNDAN_PCS | decimal number |
Required |
|
| KUNDAN_CARAT | decimal number |
Required |
|
| KUNDAN_RATEFC | decimal number |
Required |
|
| KUNDAN_RATECC | decimal number |
Required |
|
| KUNDAN_WEIGHT | decimal number |
Required |
|
| KUNDANVALUEFC | decimal number |
Required |
|
| KUNDANVALUECC | decimal number |
Required |
|
| KUNDAN_UNIT | decimal number |
Required |
|
| PREMIUM_CURRENCY | string |
Required Max length: 8 |
|
| PREMIUM_CURR_RATE | decimal number |
Required |
|
| PREMIUM_RATE_TYPE | string |
Required Max length: 8 |
|
| PREMIUM_METAL_RATEFC | decimal number |
Required |
|
| PREMIUM_METAL_RATECC | decimal number |
Required |
|
| PREMIUM_TOTALAMOUNTCC | decimal number |
Required |
|
| PREMIUM_TOTALAMOUNTFC | decimal number |
Required |
|
| TDS_CODE | string |
Required Max length: 6 |
|
| TDS_PER | decimal number |
Required |
|
| TDS_TOTALFC | decimal number |
Required |
|
| TDS_TOTALCC | decimal number |
Required |
|
| SILVER_PURITY | decimal number |
Required |
|
| SILVER_PUREWT | decimal number |
Required |
|
| SILVER_RATE_TYPE | string |
Required Max length: 6 |
|
| SILVER_RATE | decimal number |
Required |
|
| SILVER_RATEFC | decimal number |
Required |
|
| SILVER_RATECC | decimal number |
Required |
|
| SILVER_VALUEFC | decimal number |
Required |
|
| SILVER_VALUECC | decimal number |
Required |
|
| OZGOLD_PUREWT | decimal number |
Required |
|
| OZSILVER_PUREWT | decimal number |
Required |
|
| DECLARATIONNO | string |
Max length: 50 |
|
| REEXPORTYN | decimal number |
Required |
|
| CONV_FACTOR_OZ | decimal number |
Required |
|
| PUR_REF | string |
Required Max length: 30 |
|
| STAMPCHARGE_RATEFC | decimal number |
Required |
|
| STAMPCHARGE_RATECC | decimal number |
Required |
|
| STAMPCHARGE_AMTFC | decimal number |
Required |
|
| STAMPCHARGE_AMTCC | decimal number |
Required |
|
| BATCHID | decimal number |
Required |
|
| STAMPCHARGE | boolean |
Required |
|
| ACTUALGROSSWT | decimal number |
None. |
|
| ACTUALPURITY | decimal number |
None. |
|
| MELTINGLOSS | decimal number |
None. |
|
| DRAFTIMPORTFLG | boolean |
Required |
|
| FIXMID | decimal number |
None. |
|
| FIXVOCTYPE | string |
Max length: 3 |
|
| FIXVOCNO | decimal number |
None. |
|
| FIXBRANCH | string |
Max length: 6 |
|
| FIXYEARMONTH | string |
Max length: 12 |
|
| FIXSRNO | decimal number |
None. |
|
| FIX_STOCKCODE | string |
Max length: 20 |
|
| IMPORT_REF | string |
Max length: 200 |