NameDescriptionTypeAdditional 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