You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
19 KiB
19 KiB
WMS部分接口文档
物料部分
type Article struct {
*ArtId string `xorm:"pk nvarchar(40) 'ArtId'" json:"WM_Article-ArtId"`
Descr1 string `xorm:"nvarchar(100) 'Descr1' not null" json:"WM_Article-Descr1"`
Descr2 string `xorm:"nvarchar(100) 'Descr2' not null" json:"WM_Article-Descr2"`
ArtType string `xorm:"nvarchar(40) 'ArtType' not null" json:"WM_Article-ArtType"`
ProjectId string `xorm:"nvarchar(40) 'ProjectId' not null" json:"WM_Article-ProjectId"` // 不展示
Uom string `xorm:"nvarchar(40) 'Uom' not null" json:"WM_Article-Uom"`
Weight float64 `xorm:"float 'Weight' not null" json:"WM_Article-Weight"`
WeightUom string `xorm:"nvarchar(40) 'WeightUom' not null" json:"WM_Article-WeightUom"`
Length float64 `xorm:"float 'Length' not null" json:"WM_Article-Length"`
Width float64 `xorm:"float 'Width' not null" json:"WM_Article-Width"`
Height float64 `xorm:"float 'Height' not null" json:"WM_Article-Height"`
SizeUom string `xorm:"nvarchar(40) 'SizeUom' not null" json:"WM_Article-SizeUom"`
Fragile bool `xorm:"bit 'Fragile' not null" json:"WM_Article-Fragile"` // 勾选
Icon string `xorm:"nvarchar(100) 'Icon' not null" json:"WM_Article-Icon"`
DisplayColor string `xorm:"nvarchar(20) 'DisplayColor' not null" json:"WM_Article-DisplayColor"`
Document string `xorm:"nvarchar(100) 'Document' not null" json:"WM_Article-Document"`
LotSize float64 `xorm:"float 'LotSize'" json:"WM_Article-LotSize"`
ABCClass string `xorm:"nvarchar(1) 'ABCClass' not null" json:"WM_Article-ABCClass"`
ArtSize1 float64 `xorm:"float 'ArtSize1' not null" json:"WM_Article-ArtSize1"`
ArtSize2 float64 `xorm:"float 'ArtSize2' not null" json:"WM_Article-ArtSize2"`
ArtSize3 int `xorm:"int 'ArtSize3' not null" json:"WM_Article-ArtSize3"`
ArtSize4 int `xorm:"int 'ArtSize4' not null" json:"WM_Article-ArtSize4"`
ArtSize5 string `xorm:"nvarchar(100) 'ArtSize5' not null" json:"WM_Article-ArtSize5"`
ArtSpec1 string `xorm:"nvarchar(100) 'ArtSpec1' not null" json:"WM_Article-ArtSpec1"`
ArtSpec2 string `xorm:"nvarchar(100) 'ArtSpec2' not null" json:"WM_Article-ArtSpec2"`
ArtSpec3 string `xorm:"nvarchar(100) 'ArtSpec3' not null" json:"WM_Article-ArtSpec3"`
ArtSpec4 string `xorm:"nvarchar(100) 'ArtSpec4' not null" json:"WM_Article-ArtSpec4"`
ArtSpec5 string `xorm:"nvarchar(100) 'ArtSpec5' not null" json:"WM_Article-ArtSpec5"`
LastModify grmi.DateTime `xorm:"datetime 'LastModify' not null updated" json:"WM_Article-LastModify"`
LastUser string `xorm:"nvarchar(20) 'LastUser' not null" json:"WM_Article-LastUser"`
CreateTime grmi.DateTime `xorm:"datetime 'CreateTime' not null created" json:"WM_Article-CreateTime"`
Qty float64 `xorm:"float 'Qty' not null" json:"WM_Article-Qty"` // 不展示
ArticlePickingRate ArticlePickingRate `xorm:"-" json:"WM_Article-ArticlePickingRate"`
ArticleReplenish ArticleReplenish `xorm:"-" json:"WM_Article-ArticleReplenish"`
}
type ArticlePickingRate struct {
*ArtId string `xorm:"pk nvarchar(1) 'ArtId'" json:"WM_ArticlePickingRate-ArtId"`
Priority int `xorm:"int 'Priority' not null" json:"WM_ArticlePickingRate-Priority"`
PickRateArea string `xorm:"nvarchar(100) 'PickRateArea' not null" json:"WM_ArticlePickingRate-PickRateArea"`
Force string `xorm:"nvarchar(100) 'Force' not null" json:"WM_ArticlePickingRate-Force"`
Uom string `xorm:"nvarchar(40) 'Uom' not null" json:"WM_ArticlePickingRate-Uom"`
Availiable bool `xorm:"bit 'Availiable' not null" json:"WM_ArticlePickingRate-Availiable"`
OnStock int `xorm:"int 'OnStock' not null" json:"WM_ArticlePickingRate-OnStock"`
APRCtrlPara1 string `xorm:"nvarchar(100) 'APRCtrlPara1' not null" json:"WM_ArticlePickingRate-APRCtrlPara1"`
APRCtrlPara2 string `xorm:"nvarchar(100) 'APRCtrlPara2' not null" json:"WM_ArticlePickingRate-APRCtrlPara2"`
APRCtrlPara3 int `xorm:"int 'APRCtrlPara3' not null" json:"WM_ArticlePickingRate-APRCtrlPara3"`
APRCtrlPara4 int `xorm:"int 'APRCtrlPara4' not null" json:"WM_ArticlePickingRate-APRCtrlPara4"`
APRCtrlPara5 float64 `xorm:"float 'APRCtrlPara5' not null" json:"WM_ArticlePickingRate-APRCtrlPara5"`
APRCtrlPara6 float64 `xorm:"float 'APRCtrlPara6' not null" json:"WM_ArticlePickingRate-APRCtrlPara6"`
LastModify grmi.DateTime `xorm:"datetime 'LastModify' not null updated" json:"WM_ArticlePickingRate-LastModify"`
LastUser string `xorm:"nvarchar(20) 'LastUser' not null" json:"WM_ArticlePickingRate-LastUser"`
CreateTime grmi.DateTime `xorm:"datetime 'CreateTime' not null created" json:"WM_ArticlePickingRate-CreateTime"`
}
type ArticleReplenish struct {
*ArtId string `xorm:"pk nvarchar(40) 'ArtId'" json:"WM_ArticleReplenish-ArtId"`
*MinQty float64 `xorm:"float 'MinQty' not null" json:"WM_ArticleReplenish-MinQty"`
MaxQty float64 `xorm:"float 'MaxQty' not null" json:"WM_ArticleReplenish-MaxQty"`
*ReplenishQty float64 `xorm:"float 'ReplenishQty' not null" json:"WM_ArticleReplenish-ReplenishQty"`
ReplenishFrom string `xorm:"nvarchar(255) 'ReplenishFrom' not null" json:"WM_ArticleReplenish-ReplenishFrom"`
ARCtrlPara1 string `xorm:"nvarchar(100) 'ARCtrlPara1' not null" json:"WM_ArticleReplenish-ARCtrlPara1"`
ARCtrlPara2 string `xorm:"nvarchar(100) 'ARCtrlPara2' not null" json:"WM_ArticleReplenish-ARCtrlPara2"`
ARCtrlPara3 int `xorm:"int 'ARCtrlPara3' not null" json:"WM_ArticleReplenish-ARCtrlPara3"`
ARCtrlPara4 int `xorm:"int 'ARCtrlPara4' not null" json:"WM_ArticleReplenish-ARCtrlPara4"`
ARCtrlPara5 float64 `xorm:"float 'ARCtrlPara5' not null" json:"WM_ArticleReplenish-ARCtrlPara5"`
ARCtrlPara6 float64 `xorm:"float 'ARCtrlPara6' not null" json:"WM_ArticleReplenish-ARCtrlPara6"`
LastModify grmi.DateTime `xorm:"datetime 'LastModify' not null updated" json:"WM_ArticleReplenish-LastModify"`
LastUser string `xorm:"nvarchar(20) 'LastUser' not null" json:"WM_ArticleReplenish-LastUser"`
CreateTime grmi.DateTime `xorm:"datetime 'CreateTime' not null created" json:"WM_ArticleReplenish-CreateTime"`
}
库房
type Warehouse struct {
*WarehouseId string `xorm:"pk nvarchar(40) 'WarehouseId'" json:"WM_Warehouse-WarehouseId"`
Descr string `xorm:"nvarchar(100) 'Descr' not null" json:"WM_Warehouse-Descr"`
Status string `xorm:"nvarchar(3) 'Status' not null" json:"WM_Warehouse-Status"`
WarehouseType string `xorm:"nvarchar(40) 'WarehouseType' not null" json:"WM_Warehouse-WarehouseType"`
StorageMethod string `xorm:"nvarchar(40) 'StorageMethod' not null" json:"WM_Warehouse-StorageMethod"`
Comment string `xorm:"nvarchar(255) 'Comment' not null" json:"WM_Warehouse-Comment"`
AllocationStrategy string `xorm:"nvarchar(40) 'AllocationStrategy' not null" json:"WM_Warehouse-AllocationStrategy"`
RuleSetId string `xorm:"nvarchar(40) 'RuleSetId' not null" json:"WM_Warehouse-RuleSetId"`
CompleteStockRemoval string `xorm:"nvarchar(40) 'CompleteStockRemoval' not null" json:"WM_Warehouse-CompleteStockRemoval"`
TransportSystemNr int `xorm:"int 'TransportSystemNr' not null" json:"WM_Warehouse-TransportSystemNr"`
TransportPoint int `xorm:"int 'TransportPoint' not null" json:"WM_Warehouse-TransportPoint"`
WarehouseCtrlPara1 int `xorm:"int 'WarehouseCtrlPara1' not null" json:"WM_Warehouse-WarehouseCtrlPara1"`
WarehouseCtrlPara2 int `xorm:"int 'WarehouseCtrlPara2' not null" json:"WM_Warehouse-WarehouseCtrlPara2"`
WarehouseCtrlPara3 int `xorm:"int 'WarehouseCtrlPara3' not null" json:"WM_Warehouse-WarehouseCtrlPara3"`
WarehouseCtrlPara4 int `xorm:"int 'WarehouseCtrlPara4' not null" json:"WM_Warehouse-WarehouseCtrlPara4"`
WarehouseCtrlPara5 string `xorm:"nvarchar(255) 'WarehouseCtrlPara5'" json:"WM_Warehouse-WarehouseCtrlPara5"`
WarehouseCtrlPara6 string `xorm:"nvarchar(255) 'WarehouseCtrlPara6'" json:"WM_Warehouse-WarehouseCtrlPara6"`
WarehouseCtrlPara7 string `xorm:"nvarchar(255) 'WarehouseCtrlPara7'" json:"WM_Warehouse-WarehouseCtrlPara7"`
WarehouseCtrlPara8 string `xorm:"nvarchar(255) 'WarehouseCtrlPara8'" json:"WM_Warehouse-WarehouseCtrlPara8"`
WarehouseCtrlPara9 float64 `xorm:"float 'WarehouseCtrlPara9'" json:"WM_Warehouse-WarehouseCtrlPara9"`
WarehouseCtrlPara10 float64 `xorm:"float 'WarehouseCtrlPara10'" json:"WM_Warehouse-WarehouseCtrlPara10"`
WarehouseCtrlPara11 float64 `xorm:"float 'WarehouseCtrlPara11'" json:"WM_Warehouse-WarehouseCtrlPara11"`
WarehouseCtrlPara12 float64 `xorm:"float 'WarehouseCtrlPara12'" json:"WM_Warehouse-WarehouseCtrlPara12"`
WarehouseCtrlPara13 grmi.DateTime `xorm:"datetime 'WarehouseCtrlPara13'" json:"WM_Warehouse-WarehouseCtrlPara13"`
WarehouseCtrlPara14 grmi.DateTime `xorm:"datetime 'WarehouseCtrlPara14'" json:"WM_Warehouse-WarehouseCtrlPara14"`
WarehouseCtrlPara15 grmi.DateTime `xorm:"datetime 'WarehouseCtrlPara15'" json:"WM_Warehouse-WarehouseCtrlPara15"`
WarehouseCtrlPara16 grmi.DateTime `xorm:"datetime 'WarehouseCtrlPara16'" json:"WM_Warehouse-WarehouseCtrlPara16"`
LastModify grmi.DateTime `xorm:"datetime 'LastModify' not null updated" json:"WM_Warehouse-LastModify"`
LastUser string `xorm:"nvarchar(20) 'LastUser' not null" json:"WM_Warehouse-LastUser"`
CreateTime grmi.DateTime `xorm:"datetime 'CreateTime' not null created" json:"WM_Warehouse-CreateTime"`
}
库区
type StorageArea struct {
StorageAreaId string `xorm:"pk nvarchar(40) 'StorageAreaId'" json:"WM_StorageArea-StorageAreaId"`
WarehouseId string `xorm:"pk nvarchar(40) 'WarehouseId'" json:"WM_StorageArea-WarehouseId"`
Descr string `xorm:"nvarchar(100) 'Descr' not null" json:"WM_StorageArea-Descr"`
Status string `xorm:"nvarchar(3) 'Status' not null" json:"WM_StorageArea-Status"`
AreaCtrlPara1 int `xorm:"int 'AreaCtrlPara1' not null" json:"WM_StorageArea-AreaCtrlPara1"`
AreaCtrlPara2 int `xorm:"int 'AreaCtrlPara2' not null" json:"WM_StorageArea-AreaCtrlPara2"`
AreaCtrlPara3 int `xorm:"int 'AreaCtrlPara3' not null" json:"WM_StorageArea-AreaCtrlPara3"`
AreaCtrlPara4 int `xorm:"int 'AreaCtrlPara4' not null" json:"WM_StorageArea-AreaCtrlPara4"`
AreaCtrlPara5 string `xorm:"nvarchar(255) 'AreaCtrlPara5'" json:"WM_StorageArea-AreaCtrlPara5"`
AreaCtrlPara6 string `xorm:"nvarchar(255) 'AreaCtrlPara6'" json:"WM_StorageArea-AreaCtrlPara6"`
AreaCtrlPara7 string `xorm:"nvarchar(255) 'AreaCtrlPara7'" json:"WM_StorageArea-AreaCtrlPara7"`
AreaCtrlPara8 string `xorm:"nvarchar(255) 'AreaCtrlPara8'" json:"WM_StorageArea-AreaCtrlPara8"`
AreaCtrlPara9 float64 `xorm:"float 'AreaCtrlPara9'" json:"WM_StorageArea-AreaCtrlPara9"`
AreaCtrlPara10 float64 `xorm:"float 'AreaCtrlPara10'" json:"WM_StorageArea-AreaCtrlPara10"`
AreaCtrlPara11 float64 `xorm:"float 'AreaCtrlPara11'" json:"WM_StorageArea-AreaCtrlPara11"`
AreaCtrlPara12 float64 `xorm:"float 'AreaCtrlPara12'" json:"WM_StorageArea-AreaCtrlPara12"`
AreaCtrlPara13 grmi.DateTime `xorm:"datetime 'AreaCtrlPara13'" json:"WM_StorageArea-AreaCtrlPara13"`
AreaCtrlPara14 grmi.DateTime `xorm:"datetime 'AreaCtrlPara14'" json:"WM_StorageArea-AreaCtrlPara14"`
AreaCtrlPara15 grmi.DateTime `xorm:"datetime 'AreaCtrlPara15'" json:"WM_StorageArea-AreaCtrlPara15"`
AreaCtrlPara16 grmi.DateTime `xorm:"datetime 'AreaCtrlPara16'" json:"WM_StorageArea-AreaCtrlPara16"`
LastModify grmi.DateTime `xorm:"datetime 'LastModify' not null updated" json:"WM_StorageArea-LastModify"`
LastUser string `xorm:"nvarchar(20) 'LastUser' not null" json:"WM_StorageArea-LastUser"`
CreateTime grmi.DateTime `xorm:"datetime 'CreateTime' not null created" json:"WM_StorageArea-CreateTime"`
}
库架
type StorageRack struct {
StorageRackId string `xorm:"pk nvarchar(40) 'StorageRackId'" json:"WM_StorageRack-StorageRackId"`
WarehouseId string `xorm:"pk nvarchar(40) 'WarehouseId'" json:"WM_StorageRack-WarehouseId"`
StorageAreaId string `xorm:"nvarchar(40) 'StorageAreaId' not null" json:"WM_StorageRack-StorageAreaId"`
Descr string `xorm:"nvarchar(100) 'Descr' not null" json:"WM_StorageRack-Descr"`
Status string `xorm:"nvarchar(10) 'Status' not null" json:"WM_StorageRack-Status"`
SRCtrlPara1 string `xorm:"nvarchar(100) 'SRCtrlPara1' not null" json:"WM_StorageRack-SRCtrlPara1"`
SRCtrlPara2 string `xorm:"nvarchar(100) 'SRCtrlPara2' not null" json:"WM_StorageRack-SRCtrlPara2"`
SRCtrlPara3 int `xorm:"int 'SRCtrlPara3' not null" json:"WM_StorageRack-SRCtrlPara3"`
SRCtrlPara4 int `xorm:"int 'SRCtrlPara4' not null" json:"WM_StorageRack-SRCtrlPara4"`
SRCtrlPara5 float64 `xorm:"float 'SRCtrlPara5' not null" json:"WM_StorageRack-SRCtrlPara5"`
SRCtrlPara6 float64 `xorm:"float 'SRCtrlPara6' not null" json:"WM_StorageRack-SRCtrlPara6"`
LastModify grmi.DateTime `xorm:"datetime 'LastModify' not null updated" json:"WM_StorageRack-LastModify"`
LastUser string `xorm:"nvarchar(20) 'LastUser' not null" json:"WM_StorageRack-LastUser"`
CreateTime grmi.DateTime `xorm:"datetime 'CreateTime' not null created" json:"WM_StorageRack-CreateTime"`
}
库位
type StorageBin struct {
StorageBinId string `xorm:"pk nvarchar(40) 'StorageBinId'" json:"WM_StorageBin-StorageBinId"`
WarehouseId string `xorm:"pk nvarchar(40) 'WarehouseId'" json:"WM_StorageBin-WarehouseId"`
StorageAreaId string `xorm:"nvarchar(40) 'StorageAreaId' not null" json:"WM_StorageBin-StorageAreaId"`
Descr string `xorm:"nvarchar(100) 'Descr' not null" json:"WM_StorageBin-Descr"`
Status string `xorm:"nvarchar(3) 'Status' not null" json:"WM_StorageBin-Status"`
ActualStock float64 `xorm:"float 'ActualStock' not null" json:"WM_StorageBin-ActualStock"`
BlockedStock float64 `xorm:"float 'BlockedStock' not null" json:"WM_StorageBin-BlockedStock"`
AvailableStock float64 `xorm:"float 'AvailableStock' not null" json:"WM_StorageBin-AvailableStock"`
ReservedStock float64 `xorm:"float 'ReservedStock' not null" json:"WM_StorageBin-ReservedStock"`
ReservableStock float64 `xorm:"float 'ReservableStock' not null" json:"WM_StorageBin-ReservableStock"`
RemovalReason string `xorm:"nvarchar(255) 'RemovalReason' not null" json:"WM_StorageBin-RemovalReason"`
RemovalPerson string `xorm:"nvarchar(40) 'RemovalPerson' not null" json:"WM_StorageBin-RemovalPerson"`
LastStorageBlock grmi.DateTime `xorm:"datetime 'LastStorageBlock' not null" json:"WM_StorageBin-LastStorageBlock"`
StorageBlockReason string `xorm:"nvarchar(255) 'StorageBlockReason' not null" json:"WM_StorageBin-StorageBlockReason"`
StoragePerson string `xorm:"nvarchar(40) 'StoragePerson' not null" json:"WM_StorageBin-StoragePerson"`
StorageCapacity float64 `xorm:"float 'StorageCapacity' not null" json:"WM_StorageBin-StorageCapacity"`
LastRemoval grmi.DateTime `xorm:"datetime 'LastRemoval' not null" json:"WM_StorageBin-LastRemoval"`
LastStorage grmi.DateTime `xorm:"datetime 'LastStorage' not null" json:"WM_StorageBin-LastStorage"`
RemainStock float64 `xorm:"float 'RemainStock' not null" json:"WM_StorageBin-RemainStock"`
LastStockTaking grmi.DateTime `xorm:"datetime 'LastStockTaking' not null" json:"WM_StorageBin-LastStockTaking"`
Weight float64 `xorm:"float 'Weight' not null" json:"WM_StorageBin-Weight"`
WeightUom string `xorm:"nvarchar(40) 'WeightUom' not null" json:"WM_StorageBin-WeightUom"`
Length float64 `xorm:"float 'Length' not null" json:"WM_StorageBin-Length"`
Width float64 `xorm:"float 'Width' not null" json:"WM_StorageBin-Width"`
Height float64 `xorm:"float 'Height' not null" json:"WM_StorageBin-Height"`
SizeUom string `xorm:"nvarchar(40) 'SizeUom' not null" json:"WM_StorageBin-SizeUom"`
MovementClass string `xorm:"nvarchar(40) 'MovementClass' not null" json:"WM_StorageBin-MovementClass"`
BinCtrlPara1 int `xorm:"int 'BinCtrlPara1' not null" json:"WM_StorageBin-BinCtrlPara1"`
BinCtrlPara2 int `xorm:"int 'BinCtrlPara2' not null" json:"WM_StorageBin-BinCtrlPara2"`
BinCtrlPara3 int `xorm:"int 'BinCtrlPara3' not null" json:"WM_StorageBin-BinCtrlPara3"`
BinCtrlPara4 int `xorm:"int 'BinCtrlPara4' not null" json:"WM_StorageBin-BinCtrlPara4"`
BinCtrlPara5 string `xorm:"nvarchar(255) 'BinCtrlPara5'" json:"WM_StorageBin-BinCtrlPara5"`
BinCtrlPara6 string `xorm:"nvarchar(255) 'BinCtrlPara6'" json:"WM_StorageBin-BinCtrlPara6"`
BinCtrlPara7 string `xorm:"nvarchar(255) 'BinCtrlPara7'" json:"WM_StorageBin-BinCtrlPara7"`
BinCtrlPara8 string `xorm:"nvarchar(255) 'BinCtrlPara8'" json:"WM_StorageBin-BinCtrlPara8"`
BinCtrlPara9 float64 `xorm:"float 'BinCtrlPara9'" json:"WM_StorageBin-BinCtrlPara9"`
BinCtrlPara10 float64 `xorm:"float 'BinCtrlPara10'" json:"WM_StorageBin-BinCtrlPara10"`
BinCtrlPara11 float64 `xorm:"float 'BinCtrlPara11'" json:"WM_StorageBin-BinCtrlPara11"`
BinCtrlPara12 float64 `xorm:"float 'BinCtrlPara12'" json:"WM_StorageBin-BinCtrlPara12"`
BinCtrlPara13 grmi.DateTime `xorm:"datetime 'BinCtrlPara13'" json:"WM_StorageBin-BinCtrlPara13"`
BinCtrlPara14 grmi.DateTime `xorm:"datetime 'BinCtrlPara14'" json:"WM_StorageBin-BinCtrlPara14"`
BinCtrlPara15 grmi.DateTime `xorm:"datetime 'BinCtrlPara15'" json:"WM_StorageBin-BinCtrlPara15"`
BinCtrlPara16 grmi.DateTime `xorm:"datetime 'BinCtrlPara16'" json:"WM_StorageBin-BinCtrlPara16"`
StorageRackId string `xorm:"nvarchar(40) 'StorageRackId' not null" json:"WM_StorageBin-StorageRackId"`
RowIndex string `xorm:"nvarchar(20) 'RowIndex' not null" json:"WM_StorageBin-RowIndex"`
ColIndex string `xorm:"nvarchar(20) 'ColIndex' not null" json:"WM_StorageBin-ColIndex"`
LastModify grmi.DateTime `xorm:"datetime 'LastModify' not null updated" json:"WM_StorageBin-LastModify"`
LastUser string `xorm:"nvarchar(20) 'LastUser' not null" json:"WM_StorageBin-LastUser"`
CreateTime grmi.DateTime `xorm:"datetime 'CreateTime' not null created" json:"WM_StorageBin-CreateTime"`
}