p_tmpinoutstore

• Rows (estimated): 0
• Data size: 16.0 KB
• Engine: InnoDB
• Collation: utf8mb3_general_ci
• Created: 2026-04-27 18:54:46
• Updated:

Columns

#	Name	Type	Null	Key	Default	Extra	Comment
1	sWareHouseId	varchar(100)	YES
2	sWareHouseNo	varchar(255)	YES
3	sWareHouseName	varchar(255)	YES
4	sLocationId	varchar(100)	YES
5	sLocationName	varchar(255)	YES
6	sWarehouseLocationId	varchar(100)	YES
7	sWarehouseLocationName	varchar(255)	YES
8	sCustomerId	varchar(100)	YES
9	sCustomerNo	varchar(255)	YES
10	sCustomerName	varchar(255)	YES
11	sProductId	varchar(100)	YES
12	sProductNo	varchar(255)	YES
13	sCustomerProductNo	varchar(255)	YES
14	sProductName	varchar(255)	YES
15	sProductStyle	varchar(255)	YES
16	sProductUnit	varchar(255)	YES
17	sDefineNo	varchar(255)	YES
18	sDefineNo2	varchar(255)	YES
19	dDeliverGoodsQty	decimal(18,6)	YES
20	dDeliverGoodsMoney	decimal(18,6)	YES
21	dRejectGoodsQty	decimal(18,6)	YES
22	dRejectGoodsMoney	decimal(18,6)	YES
23	dTransferInQty	decimal(18,6)	YES
24	dTransferInMoney	decimal(18,6)	YES
25	dTransferOutQty	decimal(18,6)	YES
26	dTransferOutMoney	decimal(18,6)	YES
27	dProductInStoreQty	decimal(18,6)	YES
28	dProductInStoreMoney	decimal(18,6)	YES
29	dProductRejectQty	decimal(18,6)	YES
30	dProductRejectMoney	decimal(18,6)	YES
31	dSemigoodsInQty	decimal(18,6)	YES
32	dSemigoodsInMoney	decimal(18,6)	YES
33	dSemigoodsOutQty	decimal(18,6)	YES
34	dSemigoodsOutMoney	decimal(18,6)	YES
35	dOutSideInQty	decimal(18,6)	YES
36	dOutSideInMoney	decimal(18,6)	YES
37	dCheckInStoreQty	decimal(18,6)	YES
38	dCheckInStoreMoney	decimal(18,6)	YES
39	dCheckOutStoreQty	decimal(18,6)	YES
40	dCheckOutStoreMoney	decimal(18,6)	YES
41	dStoreAdjustmentQty	decimal(18,6)	YES
42	dStoreAdjustmentMoney	decimal(18,6)	YES
43	dProductInitQty	decimal(18,6)	YES
44	dProductInitMoney	decimal(18,6)	YES
45	dProductEndMoney	decimal(18,6)	YES
46	dProductEndPrice	decimal(24,13)	NO		0.0000000000000
47	dProductEndQty	decimal(18,6)	YES
48	dNowInStoreQty	decimal(18,6)	YES
49	dNowInStoreMoney	decimal(18,6)	YES
50	dNowOutStoreQty	decimal(18,6)	YES
51	dNowOutStoreMoney	decimal(18,6)	YES

Narrative

No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.