## WMS部分接口文档 ### 物料部分 ```go 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"` } ``` ```go 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"` } ``` ```go 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"` } ``` ### 库房 ```go 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"` } ``` ### 库区 ```go 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"` } ``` ### 库架 ```go 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"` } ``` ### 库位 ```go 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"` } ```