Summary

同RE_Retail_b,是RE_Retail_b的临时表，用于老零售数据上传(不用重复维护)

Columns

	Column Name	Description	Datatype	Length	Allow Nulls
	memberprice (T+16.0)		decimal	13	True
	discountAuthorize (T+16.0)		nvarchar	100	True
	freeItem4 (T+16.0)		nvarchar	600	True
	freeItem0 (T+16.0)		nvarchar	600	True
	priuserdefdecm2 (T+16.0)		decimal	13	True
	promotionid (T+16.0)		int	4	True
	quantity (T+16.0)		decimal	13	True
	freeItem1 (T+16.0)		nvarchar	600	True
	temporaryQty (T+16.0)		decimal	13	True
	storageDiscountAmount (T+16.0)		decimal	13	True
	isFromPriceStrategy (T+16.0)		int	4	True
	price (T+16.0)		decimal	13	True
	ismemberstorageprojet (T+16.0)		tinyint	1	True
	VirtualSettleAmount (T+16.0)		decimal	13	True
	idperson (T+16.0)		int	4	True
	idproject (T+16.0)		int	4	True
	storagesettleamount (T+16.0)		decimal	13	True
	totalDiscountRate (T+16.0)		decimal	13	True
	CashSettleAmount (T+16.0)		decimal	13	True
	bookingQuantity (T+16.0)		decimal	13	True
	pubuserdefdecm4 (T+16.0)		decimal	13	True
	freeItem5 (T+16.0)		nvarchar	600	True
	expirydate (T+16.0)		datetime	8	True
	limitedsaleid (T+16.0)		int	4	True
	batch (T+16.0)		nvarchar	100	True
	freeItem8 (T+16.0)		nvarchar	600	True
	PaymentCode (T+16.0)		varchar	50	True
	code (T+16.0)		nvarchar	60	True
	cardTicketDiscountAmount (T+16.0)		decimal	13	True
	totalSaleoutQty (T+16.0)		decimal	13	True
	taxrate (T+16.0)		decimal	13	True
	priuserdefnvc1 (T+16.0)		nvarchar	1000	True
	accountAmount (T+16.0)		decimal	13	True
	ReturnSourceDetailId (T+16.0)		int	4	True
	taxprice (T+16.0)		decimal	13	True
	freeItem3 (T+16.0)		nvarchar	600	True
	ProductionDate (T+16.0)		datetime	8	True
	freeItem7 (T+16.0)		nvarchar	600	True
	idbaseUnit (T+16.0)		int	4	True
	RedPaymentCode (T+16.0)		varchar	50	True
	retailamount (T+16.0)		decimal	13	True
	ts (T+16.0)		timestamp	8	False
	detailDiscountAmount (T+16.0)		decimal	13	True
	memo (T+16.0)		nvarchar	400	True
	priuserdefdecm3 (T+16.0)		decimal	13	True
	isuseintegralandcash (T+16.0)		tinyint	1	True
	freeItem6 (T+16.0)		nvarchar	600	True
	priuserdefnvc2 (T+16.0)		nvarchar	1000	True
	tax (T+16.0)		decimal	13	True
	LastModifiedField (T+16.0)		varchar	200	True
	iscancel (T+16.0)		int	4	True
	idRetailDTO (T+16.0)		int	4	True
	isusestorage (T+16.0)		tinyint	1	True
	totalpickupQty (T+16.0)		decimal	13	True
	isdel (T+16.0)		tinyint	1	True
	IsManualChangePrice (T+16.0)		tinyint	1	True
	pubuserdefdecm3 (T+16.0)		decimal	13	True
	ReturnSourceId (T+16.0)		int	4	True
	basequantity (T+16.0)		decimal	13	True
	idsubUnit (T+16.0)		int	4	True
	RdRecordCode (T+16.0)		nvarchar	100	True
	priuserdefnvc3 (T+16.0)		nvarchar	1000	True
	priuserdefnvc4 (T+16.0)		nvarchar	1000	True
	freeItem9 (T+16.0)		nvarchar	600	True
	idunit2 (T+16.0)		int	4	True
	pubuserdefdecm1 (T+16.0)		decimal	13	True
	promotioncode (T+16.0)		nvarchar	400	True
	issaleout (T+16.0)		int	4	True
	pubuserdefdecm2 (T+16.0)		decimal	13	True
	pubuserdefnvc4 (T+16.0)		nvarchar	200	True
	totalReturnQty (T+16.0)		decimal	13	True
	RetailID (T+16.0)		bigint	8	True
	bookingAmount (T+16.0)		decimal	13	True
	memberdiscountrate (T+16.0)		decimal	13	True
	PaymentStatus (T+16.0)		int	4	True
	promotiontype (T+16.0)		int	4	True
	refundStatus (T+16.0)		int	4	True
	pubuserdefnvc3 (T+16.0)		nvarchar	200	True
	idRdRecord (T+16.0)		int	4	True
	pubuserdefnvc1 (T+16.0)		nvarchar	200	True
	retailsettlecode (T+16.0)		nvarchar	100	True
	promotiontypestr (T+16.0)		nvarchar	400	True
	barCodeParseResultDic (T+16.0)		nvarchar	1000	True
	forpickupQty (T+16.0)		decimal	13	True
	quantity2 (T+16.0)		decimal	13	True
	TaxFlag (T+16.0)		tinyint	1	True
	TotalReturnAmount (T+16.0)		decimal	13	True
	discountrate (T+16.0)		decimal	13	True
	limitedsalesubid (T+16.0)		int	4	True
	wipechange (T+16.0)		decimal	13	True
	freeItem2 (T+16.0)		nvarchar	600	True
	amount (T+16.0)		decimal	13	True
	unitexchangerate (T+16.0)		decimal	13	True
	id (T+16.0)		int	4	False
	discountAuthorizeId (T+16.0)		int	4	True
	promotionidstr (T+16.0)		nvarchar	400	True
	createdtime (T+16.0)		datetime	8	True
	inventorybarcode (T+16.0)		nvarchar	400	True
	RedPaymentStatus (T+16.0)		int	4	True
	taxamount (T+16.0)		decimal	13	True
	idinventory (T+16.0)		int	4	True
	subquantity (T+16.0)		decimal	13	True
	priuserdefdecm1 (T+16.0)		decimal	13	True
	UmallSkuId (T+16.0)		varchar	50	True
	detailCoponAmount (T+16.0)		decimal	13	True
	idunit (T+16.0)		int	4	True
	idretailsettle (T+16.0)		int	4	True
	priuserdefdecm4 (T+16.0)		decimal	13	True
	sourceVoucherCode (T+16.0)		nvarchar	100	True
	retailprice (T+16.0)		decimal	13	True
	name (T+16.0)		nvarchar	400	True
	ispresent (T+16.0)		tinyint	1	True
	sequencenumber (T+16.0)		int	4	True
	pubuserdefnvc2 (T+16.0)		nvarchar	200	True

---

Send feedback

Copyright 2016 Chanjet Inc.